Preview Completion Casing Records

First 100 rows

Out of roughly 1.1M rows in texas.cmpl_casing_data. Version obs-5003abaf66a4.

`tracking_no`	`packet_id`	`parent_id`	`row_no`	`casing_size`	`weight_lb_per_ft`	`weight_lb_per_ft2`	`depth_set`	`multistage_tool_depth`	`type_of_cement`	`amount_of_cement`	`hole_size`	`top_of_cement`	`slurry_volume`
7007	9943	7721	1	13 3/8	61.0		2529		STD A	2070	17 1/2	SURFACE	3522.0
7007	9943	7721	2	9 5/8	53.5		10506		CLASS H	890	12 1/4	7996 CALC	1254.9
7007	9943	7721	3	4 1/2	15.1		15553		GASSTOP	580	6 1/2	9449 CALC	875.0
5616	8215	9089	1	10 3/4	45.5		4184		A	2332	14 3/4	SURFACE	4578.0
5616	8215	9089	2	5 1/2	23.0		9821		H	1698	6 3/4	9644 CBL	2761.0
5616	8215	9089	3	4 1/2	15.1		17924		H	1698	6 3/4	9644 CBL	2761.0
6082	11089	7169	1	8 5/8	24.0		442		CLASS A	142	12 1/4	SURFACE	220.0
6082	11089	7169	2	5 1/2	15.5		3050		CLASS A	580	7 7/8	850	776.4
1860	3229	5314	1	9 5/8	36.0		2012		CLASS A	500	12 1/4	SURFACE	1131.0
1860	3229	5314	2	4 1/2	11.6		3946	3946	CLASS A	960	7 5/8	SURFACE	2048.4
1860	3229	5314	3	4 1/2	11.6		10281		CLASS POZ H	710	7 5/8	8030	972.7
3542	5957	4699	1	9 5/8	36.0		6035		H	2400	12 1/4	SURFACE	3573.0
9364	12905	9448	1	8 5/8	24.0		314		15/85 POZ/ A NEAT	230	12 1/4	SURFACE	327.0
9364	12905	9448	2	4 1/2	9.5		1293		15/85 POZ/50/50 POZ	230	7 7/8	SURFACE	396.0
5363	7903	6489	1	13 3/8	61.0		1525		BASIC LT A / CLASS A	995	17 1/2	SURFACE	1705.0
5363	7903	6489	2	7 5/8	29.7		10360		CLASS A	596	9 7/8	7590	879.32
5363	7903	6489	3	5 1/2	23.0		9856		TIE BACK	0	7 5/8	NA	0.0
5010	12898	10302	1	13 3/8	48.0	48.0	452			475		SURFACE
5010	12898	10302	2	9 5/8	36.0	36.0	2050			897
8350	11499	9634	1	5 1/2	17.0		1700		A&C, H, A	425	7 7/8	SURFACE	735.0
8407	11570	9454	1	5 1/2	15.5		1700		A&C, A, H	475	7 7/8	SURFACE	854.0
3996	11282	8918	1	8 5/8	28.0	0.0	680	0	C	440	0	SURFACE	0.0
3996	11282	8918	2	5 1/2	15.5	0.0	4850	0	C	1100	0	SURFACE	0.0
4351	13071	5283	1	8 5/8	24.0		2000		CLASS C	1220	11	SURFACE	2315.0
4351	13071	5283	2	4 1/2	11.6		8580		CLASS H	1550	7 7/8	2590	3164.6
4525	6757	5500	1	8 5/8	24.0		280		PBCZ	150	12 1/4	SURFACE	243.0
4525	6757	5500	2	5 1/2	15.5		4550		PREM PLUS	1100	7 7/8	SURFACE	1973.0
6086	12724	7108	1	9 5/8	36.0		1460		TYPE 1	495	12 1/4	SURFACE	1236.0
6086	12724	7108	2	5 1/2	17.0		12381		CLASS H 50:50 POZ	815	7 7/8	6270	1060.0
6249	9070	7508	1	9 5/8	36.0		988		CLASS C	435	12 1/4	SURFACE	716.0
6249	9070	7508	2	5 1/2	17.0		10113		CLASS H	1543	8 1/2	2685	2259.0
6249	9070	7508	3	5 1/2	17.0		2512	2512	CLASS C	400	8 1/2	450	530.0
6625	9514	7499	1	9 5/8	36.0		2024		PUMPCO 1	655	12 1/4	SURFACE	1283.0
6625	9514	7499	2	5 1/2	17.0		11715		50/50 POZ- H	1155	8 3/4	6500	1444.0
3574	5886	4756	1	8 5/8	35.0		569		CL C	235	11	SURFACE	310.0
3574	5886	4756	2	5 1/2	17.0		9787		POZ 50/50	1170	7 7/8	2950	2259.0
4623	6878	5606	1	12 3/4	33.0		320		C	140	14 3/4	SURFACE	185.0
4623	6878	5606	2	8 5/8	32.0		4722		POZ & C	1024	11	SURFACE	1898.0
4623	6878	5606	3	5 1/2	17.0		10300		C&H	912	7 7/8	4722	1662.0
4644	6909	5626	1	12 3/4	35.0		360		CLASS C	350	17 1/2	SURFACE	599.0
4644	6909	5626	2	4 1/2	11.6		10635		CLASS H	1050	7 7/8	7134	1430.0
4635	11674	9041	1	9 5/8	36.0		370		CLASS C	225	12 1/4	SURFACE	297.0
4635	11674	9041	2	4 1/2	11.6		10644	4342	CLASS H	1595	7 7/8	3055	2287.0
6023	8783	7778	1	9 5/8	36.0	36.0	794		TYPE 1	310	12 1/4	CIRC SURF	518.0
6023	8783	7778	2	5 1/2	12.0	12.0	8793		H	1265	8 3/4	5725	1607.0
6087	8870	9336	1	9 5/8	36.0		2075		TYPE 1	725	12 1/4	SURFACE	1413.0
6087	8870	9336	2	5 1/2	17.0		11209		CLASS H	1730	8 1/2	3050	2697.0
6090	8877	7334	1	9 5/8	36.0		583		C 35/65 POZ	254	12 1/4	SURFACE	396.0
6090	8877	7334	2	5 1/2	17.0		12710		H	1470	8 3/4	3940	2393.7
6127	8935	7139	1	9 5/8	36.0		1490		A	480	12 1/4	SURFACE	963.35
6127	8935	7139	2	5 1/2	17.0		12105		H	1325	8 3/4	3300	2422.0
6653	9543	8256	1	9 5/8	30.0	36.0	1460		CLASS A	430	12 1/4	SURFACE	826.75
6653	9543	8256	2	5 1/2	17.0		9438		CLASS H	865	8 3/4	5530	1368.75
4786	14956	5771	1	8 5/8	23.0	32.0	321		CLASS C	175	11	SURFACE	299.0
4786	14956	5771	2	4 1/2	11.6		9868		TXI/LW	775	7 7/8	6074	1876.0
4786	14956	5771	3	4 1/2	11.6		9868		50/50 POZ/H	435	7 7/8	6074	574.0
5889	8619	12135	1	8 5/8	22.0		1488		REG 8%	400	12 1/4	SURF	933.0
5889	8619	12135	2	8 5/8	22.0		1488		REG 8%	126	12 1/4	SURF	0.0
5889	8619	12135	3	5 1/2	14.0		5670		REG 8%	300	7 7/8	SURF	751.0
5889	8619	12135	4	5 1/2	14.0		5670	3687	REG 8%	1250	7 7/8	SURF	0.0
6917	9847	7667	2	5 1/2	17.0		12980		CLASS H & C	1565	8 3/4	4980	3107.0
6989	9922	10664	1	9 5/8	36.0		1873		C	675	12 1/4	SURFACE	1167.0
6989	9922	10664	2	5 1/2	17.0		11375		50:50	980	8 3/4	5276	1541.0
7022	9962	10516	1	9 5/8	36.0		1218		TYPE 1	390	12 1/4	SURFACE	759.0
7022	9962	10516	2	5 1/2	17.0		9307		CLASS H	735	8 3/4	5479	919.0
8595	11788	10968	1	8 5/8	23.0		144		C	75	12 1/4	SURFACE	99.0
8595	11788	10968	2	5 1/2	17.0		4337		C	170	7 7/8	2300	554.3
8595	11788	10968	3	5 1/2	17.0	17.0	1750	1750	NONE	0	7 7/8	2300	554.3
6397	11583	17694	1	9 5/8	40.0		3107		15:85	681	12 1/4	SURFACE	1995.5
6397	11583	17694	2	9 5/8	40.0		3107		A	358	12 1/4	SURFACE	1995.5
4175	13042	10445	1	9 5/8	36.0		1719		POZ C, CL C	900	12 1/4	SURFACE	1716.0
6397	11583	17694	3	5 1/2	26.0		14655		H	1650	8 3/4	7300	2145.0
16982	45894	18551	1	13 3/8	54.5		379		CLASS C	440	17 1/2	SURFACE	589.0
16982	45894	18551	2	8 5/8	32.0		4487		50:50 POZC/ CLASS C	1175	11	SURFACE	2658.0
16982	45894	18551	3	5 1/2	17.0		10580		50:50 POZH	1015	7 7/8	5426	1651.0
17109	21836	18691	1	9 5/8	32.3		879		LITE & C	550	12 1/2	SURFACE	936.0
10721	28621	10144	1	10 3/4	45.5		5217		A	2742	14 3/4	SURFACE	5410.0
4190	6324	5502	1	9 5/8	40.0		2026		TYPE1 + ECONOLITE	605	12 1/4	SURFACE	1306.0
4190	6324	5502	2	4 1/2	15.1	13.5	12950		TYPE 1 + EXTENDACMT	1725	8 3/4	6600	2355.0
4269	6434	5588	1	9 5/8	36.0	40.0	1100		A	397	12 1/4	SURFACE	719.32
4269	6434	5588	2	5 1/2	17.0		12104		H	1170	8 3/4	5550	1525.0
4721	7021	5988	1	9 5/8	40.0		2997		A	1080	12 1/4	SURFACE	1907.0
4721	7021	5988	2	5 1/2	17.0		11505		H	1270	8 3/4	6375	1883.0
5534	8120	9358	1	9 5/8	36.0		2125		A	686	12 1/4	SURFACE	1309.43
5534	8120	9358	2	5 1/2	20.0		12481		H	2463	8 3/4	1268.25	2832.5
5607	8204	9361	1	9 5/8	36.0		1751		A	457	12 1/4	SURFACE	868.93
5607	8204	9361	2	5 1/2	20.0		12223		H	2540	8 3/4	659.71	2921.0
5608	8206	9356	1	9 5/8	36.0		2121		A	686	12 1/4	SURFACE	1309.43
5608	8206	9356	2	5 1/2	20.0		12590		H	2485	8 3/4	1234	2875.75
4737	7042	6560	1	9 5/8	40.0		2997		A	1080	12 1/4	SURFACE	1907.0
3568	5479	4951	1	8 5/8	28.0		503		LONGHORN COMMON	225	12 1/4	SURFACE	0.0
7079	10023	8036	1	8 5/8	24.0	24.0	178		PREMIUM	200	12 1/4	SURFACE	264.0
7079	10023	8036	2	4 1/2	11.6	11.6	5435	4043	H	450	7 7/8	4043	697.5
7079	10023	8036	3	4 1/2	11.6	11.6	5435	4043	H & C LITE	680	7 7/8	1400	1269.0
5963	12707	7020	1	9 5/8	36.0		668		TYPE 1	280	12 1/4	SURFACE	468.0
5963	12707	7020	2	5 1/2	17.0		11477		H & C	1240	8 1/2	3340	2648.0
6201	9016	9414	1	9 5/8	40.0	36.0	1539		CLASS A	450	12 1/4	SURFACE	867.7
6201	9016	9414	2	5 1/2	17.0		9762		CLASS H	910	8 3/4	2492	1427.7
6421	9266	7355	1	9 5/8	36.0		1338		CLASS A	490	12 1/4	SURFACE	859.0
6421	9266	7355	2	5 1/2	17.0		10961		PREMIUM1025 50/50	695	8 1/2	2980	2523.0

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: 18.4K

112344 14
105123 13
114958 11
113756 10
113125 10
117197 10
111984 10
110411 10
118379 10
115886 10
115337 10
111978 10

`packet_id`

varchar

Sampled: 50K
Distinct: 19.5K

174169 13
160745 11
165584 10
156281 10
159235 10
163983 10
165593 10
165031 10
162448 10
154978 10
152228 10
170164 10

`parent_id`

varchar

Sampled: 50K
Distinct: 19.6K

173324 10
176948 10
69300 10
186730 10
174160 10
64144 10
179592 10
184978 8
169554 8
187952 8
182357 8
186125 8

`row_no`

varchar

Sampled: 50K
Distinct: 7

1 20.1K
2 19.4K
3 8.3K
4 1.9K
5 273
6 19
7 5

`casing_size`

varchar

Sampled: 50K
Distinct: 127

5 1/2 15.3K
9 5/8 9.5K
8 5/8 8.8K
4 1/2 4.9K
7 2.8K
13 3/8 2.7K
10 3/4 2.3K
7 5/8 1.2K
5 414
12 3/4 305
2 7/8 242
0 233

`weight_lb_per_ft`

varchar

Sampled: 50K
Distinct: 316

17.0 7.6K
24.0 5.8K
36.0 5.7K
23.0 3.3K
15.5 3.1K
40.0 3K
11.6 2.1K
32.0 1.9K
20.0 1.8K
26.0 1.3K
48.0 1.3K
45.5 1K

`weight_lb_per_ft2`

varchar

Sampled: 50K
Distinct: 106

45.8K
0.0 855
36.0 797
32.0 549
17.0 322
40.0 295
15.5 169
24.0 163
26.0 163
20.0 141
23.0 97
10.5 83

`depth_set`

varchar

Sampled: 50K
Distinct: 12.8K

0 610
400 74
450 63
2500 59
65 56
126 56
60 55
3000 55
360 52
460 52
2000 51
330 50

Take it away

Back to everything we know about Completion Casing Records