EZRRC
Cart Sign in

Completion Formation Records — preview

A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.

First 100 rows

Out of roughly 4M rows in texas.cmpl_formation_data. Version obs-4bae296debd3.

tracking_nopacket_idparent_idrow_noformationdepthdepth_mdencountered
5607820493613UPPER EAGLEFORD6487.06505.0N
5607820493614LOWER EAGLEFORD6659.06729.0N
5608820693561ANACACHO5998.05999.0N
5616821590891ANACACHO9952.09952.0N
5616821590892AUSTIN CHALK10150.010150.0N
5616821590893EAGLE FORD10841.010943.0N
5608820693562AUSTIN CHALK6352.06353.0N
5608820693563UPPER EAGLEFORD6829.06856.0N
5608820693564LOWER EAGLEFORD7014.07126.0N
1860322953141NAVARRO6410.0N
1860322953142TAYLOR7096.0N
1860322953143AUSTIN CHALK8235.0N
7007994377211FRIO M10 SAND13000.013000.0N
7007994377212FRIO M50 SAND13650.013650.0N
93641290594481800 SAND796.0N
93641290594482900 SAND920.0N
7007994377213FRIO M70 SAND14000.014000.0N
5363790364891CV DAVIS9360.09360.0N
5363790364892CV TAYLOR9889.09889.0N
5363790364893HAYNESVILLE10160.010160.0N
6566944374842COMYN6944.07076.0N
6566944374843BARNETT7049.07219.0N
68941303592531CANYON SAND730.0N
68941303592532STRAWN SAND1450.0N
68941303592533CADDO3280.0N
68941303592534BEND CONGLOMERATE3720.0N
68941303592535MARBLE FALLS4160.0N
5272783963661CISCO/CANYON REEF6693.0N
5298781763761BASE LOWER WOLFCAMP5500.05500.0N
60821108971691MIDWAY390.0N
60821108971692TAYLOR164.0N
60821108971693AUSTIN2340.0N
5298781763762MIDDLE CANYON6878.06878.0N
4623687856061SAN ANDRES4951.04954.0N
4623687856062UPPER SPRABERRY6231.06231.0N
4623687856063WOLFCAMP9110.09110.0N
4644690956261UPPER SPBY7488.0N
4644690956262LOWER SPBY8044.0N
4644690956263DEAN8064.0N
4644690956264WOLFCAMP9056.0N
4644690956265STRAWN10553.0N
5534812093581ANACACHO5877.05880.0N
5534812093582AUSTIN CHALK6216.06219.0N
5534812093583UPPER EAGLEFORD6715.06738.0N
5534812093584LOWER EAGLEFORD6891.06990.0N
5607820493611ANACACHO5630.05633.0N
5607820493612AUSTIN CHALK5960.05963.0N
639711583176941AUSTIN CHALK7973.07973.0N
639711583176942BUDA8443.08443.0N
46351167490411MARBLE FALLS5326.05320.0N
46351167490412FORESTBURG5705.05715.0N
3568547949511FRIO3500.03500.0N
3568547949512PETERS3784.03784.0N
40551210395421OLMOS9196.09196.0N
40551210395422EAGLEFORD10791.010791.0N
40551210395423BUDA10990.010990.0N
4102620264251AUSTIN CHALK12858.0N
4102620264252EAGLE FORD13347.0N
4102620264253BUDA13635.0N
4177630489571MIDWAY8687.0N
4177630489572AUSTIN CHALK UPPER12482.0N
4177630489573EAGLE FORD12727.0N
46351167490413LOWER BARNETT5768.05650.0N
6023878377781TOP OF BARNETT6397.06397.0N
6023878377782FORESTBURG6486.06486.0N
56441243798501YEGUA5275.0N
56441243798502WILCOX8170.0N
70309970100121FRIO0.02600.0N
6023878377783TOP OF MARBLE FALLS6184.06184.0N
6087887093361BASAL ATOKA8005.08152.0N
6087887093362LOWER BARNETT8206.08405.0N
6087887093363UPPER BARNETT8060.08213.0N
6090887773341ATOKA4660.04660.0N
6090887773342MARBLE FALLS6280.06280.0N
6090887773343FORESTBURG LIMESTONE6934.06934.0N
6090887773344BARNETT SHALE6990.07105.0N
639711583176943DEL RIO8549.08549.0N
639711583176944EAGLEFORD8304.08304.0N
879412025111061ANACACHO8275.08290.0N
879412025111062AUSTIN CHALK8403.08440.0N
879412025111063EAGLE FORD UPPER8627.08790.0N
879412025111064EAGLE FORD8708.08976.0N
967318285151861MIDWAY4959.0N
967318285151862NAVARRO5710.0N
967318285151863ANACACHO8382.0N
982822197145531EAGLE FORD11800.015806.0N
982822197145532EAGLE FORD11800.015806.0N
982822197145533EAGLE FORD11800.015806.0N
1375817792120641FRIO L2711550.011550.0N
1077541581261578717SAN MIGUEL - H2S5330.05339.0Y
1077541581261578718ANACACHO6131.06143.0Y
1045481799961888291ANACACHON
1077541581261578719AUSTIN CHALK - H2S6422.06434.0Y
10775415812615787110EAGLE FORD - H2S6870.06887.0Y
3176940592391961UPEER SPBY7191.0N
3176940592391962LOWER SPBY7707.0N
3176940592391963DEAN8522.0N
1091224716152551WILCOX2576.02576.0N
1091224716152552MIDWAY7081.07081.0N
1091224716152553EAGLEFORD10550.010550.0N

What is in each column

Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.

tracking_no

varchar

Sampled
50K
Distinct
15.6K
  • 96758 19
  • 4282 16
  • 4276 15
  • 29160 15
  • 118440 15
  • 118423 15
  • 118437 15
  • 9257 14
  • 117347 14
  • 4375 14
  • 8077 14
  • 118650 14

packet_id

varchar

Sampled
50K
Distinct
15.6K
  • 133459 19
  • 6448 16
  • 165749 15
  • 165746 15
  • 6441 15
  • 37141 15
  • 165730 15
  • 156054 14
  • 148275 14
  • 176897 14
  • 11184 14
  • 6565 14

parent_id

varchar

Sampled
50K
Distinct
13.9K
  • 63798 19
  • 9149 18
  • 10844 18
  • 14203 16
  • 5206 16
  • 189335 15
  • 176536 15
  • 35816 15
  • 189286 15
  • 26229 15
  • 11714 15
  • 14120 14

row_no

varchar

Sampled
50K
Distinct
23
  • 1 15.6K
  • 2 13.5K
  • 3 12.5K
  • 4 4.1K
  • 5 2.3K
  • 6 1.2K
  • 7 296
  • 8 181
  • 9 107
  • 10 63
  • 11 44
  • 12 27

formation

varchar

Sampled
50K
Distinct
4.3K
  • SAN ANDRES 2K
  • AUSTIN CHALK 1.6K
  • WOLFCAMP 1.5K
  • MARBLE FALLS 1.2K
  • STRAWN 1.1K
  • YATES 1.1K
  • UPPER BARNETT 1K
  • ANACACHO 1K
  • LOWER BARNETT 975
  • EAGLE FORD 965
  • DEAN 830
  • SPRABERRY 796

depth

varchar

Sampled
50K
Distinct
11.4K
  • 3.4K
  • 0.0 313
  • 2300.0 248
  • 950.0 240
  • 2460.0 232
  • 4100.0 47
  • 2750.0 41
  • 7000.0 39
  • 4240.0 38
  • 6000.0 36
  • 4365.0 34
  • 7450.0 33

depth_md

varchar

Sampled
50K
Distinct
9.3K
  • 24K
  • 0.0 226
  • 8500.0 21
  • 7450.0 20
  • 1950.0 19
  • 6710.0 18
  • 5750.0 17
  • 6890.0 17
  • 7500.0 17
  • 1750.0 16
  • 6700.0 16
  • 1200.0 16

encountered

varchar

Sampled
50K
Distinct
2
  • N 49.8K
  • Y 222

Take it away

Back to everything we know about Completion Formation Records