Preview Wellbore Casing Records

First 100 rows

Out of roughly 1.7M rows in texas.wb_casings. Version obs-23a4cb93587b.

`api_county`	`api_unique`	`casing_count`	`cas_inch`	`cas_frac_num`	`cas_frac_denom`	`casing_depth_set`	`mlti_stg_tool_dpth`	`amount_of_cement`	`cement_measurement`	`hole_inch`	`hole_frac_num`	`hole_frac_denom`	`top_of_cement_casing`	`amount_casing_left`	`ingested_at`	`cas_wt_table`
001	00001	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00008	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00037	1	8	5	8	304	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00037	2	5	1	2	5978	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00043	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00045	1	10	null	null	529	null	140	S	12	3	4	SURF	30000	May 17, 2026, 10 p.m.	2800000
001	00045	2	7	null	null	4081	null	260	S	9	3	4	2860	30000	May 17, 2026, 10 p.m.	2200000
001	00046	1	10	null	null	532	null	160	S	12	3	4	SURF	30000	May 17, 2026, 10 p.m.	3200000
001	00046	2	7	null	null	4052	null	250	S	9	1	2	2740	30000	May 17, 2026, 10 p.m.	2200000
001	00046	3	5	1	2	3900	null	100	S	7	null	null	1870	30000	May 17, 2026, 10 p.m.	1400000
001	00049	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00055	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00064	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00066	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00068	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00069	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00070	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00070	2	5	1	2	10070	null	575	S	8	3	4	8070	92	May 17, 2026, 10 p.m.	1550170
001	00071	1	5	1	2	10065	null	650	S	8	3	4	8200	1053	May 17, 2026, 10 p.m.	1550000
001	00071	2	9	5	8	2107	null	700	S	12	1	4	SURF	1053	May 17, 2026, 10 p.m.	3230000
001	00072	1	5	1	2	10205	null	657	S	8	3	4	8105	null	May 17, 2026, 10 p.m.	1700000
001	00072	2	9	5	8	2146	null	700	S	12	1	4	SURF	null	May 17, 2026, 10 p.m.	null
001	00078	1	9	5	8	2186	null	690	S	12	1	4	SURF	20000	May 17, 2026, 10 p.m.	3230000
001	00078	2	4	1	2	10155	null	580	S	8	3	4	8455	20000	May 17, 2026, 10 p.m.	1160000
001	00084	1	9	5	8	2061	null	null	S	12	1	4	null	60000	May 17, 2026, 10 p.m.	3600000
001	00084	2	5	1	2	10370	null	750	S	8	3	4	null	60000	May 17, 2026, 10 p.m.	1700155
001	00086	1	9	5	8	2166	null	null	S	12	1	4	null	null	May 17, 2026, 10 p.m.	3230000
001	00086	2	5	1	2	10158	null	null	S	8	3	4	null	null	May 17, 2026, 10 p.m.	1550170
001	00086	3	2	3	8	9952	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00087	1	8	5	8	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00087	2	4	1	2	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00089	1	9	5	8	2124	null	null	S	12	1	4	null	40000	May 17, 2026, 10 p.m.	3230000
001	00089	2	4	1	2	10230	null	75	S	8	3	4	null	40000	May 17, 2026, 10 p.m.	1160000
001	00090	1	9	5	8	2153	null	740	S	12	1	4	SURF	5022	May 17, 2026, 10 p.m.	3200000
001	00090	2	5	1	2	10035	null	375	S	8	3	4	8253	5022	May 17, 2026, 10 p.m.	1700155
001	00091	1	8	5	8	2031	null	950	S	null	null	null	SURF	4031	May 17, 2026, 10 p.m.	null
001	00091	2	4	1	2	10024	null	300	S	7	7	8	8200	4031	May 17, 2026, 10 p.m.	1160135
001	00092	1	9	5	8	2220	null	800	S	12	1	4	SURF	4062	May 17, 2026, 10 p.m.	3400000
001	00092	2	4	1	2	9974	null	375	S	null	null	null	SURF	4062	May 17, 2026, 10 p.m.	1160000
001	00094	1	9	5	8	2171	null	null	S	12	1	4	SURF	null	May 17, 2026, 10 p.m.	null
001	00094	2	5	1	2	10058	null	400	S	8	3	4	8914	null	May 17, 2026, 10 p.m.	null
001	00094	3	5	1	2	6052	null	50	S	8	3	4	6025	null	May 17, 2026, 10 p.m.	null
001	00094	4	5	1	2	4885	null	200	S	8	3	4	4885	null	May 17, 2026, 10 p.m.	null
001	00096	1	10	3	4	2026	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00096	2	7	null	null	10078	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00101	1	9	5	8	2018	null	750	S	12	1	4	0	null	May 17, 2026, 10 p.m.	null
001	00101	2	5	1	2	10286	null	750	S	8	3	4	8000	null	May 17, 2026, 10 p.m.	null
001	00104	1	9	5	8	2099	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00106	1	9	5	8	2029	null	1000	S	12	1	4	SURFACE	null	May 17, 2026, 10 p.m.	null
001	00106	2	5	1	2	10160	null	700	S	8	3	4	null	null	May 17, 2026, 10 p.m.	1700000
001	00109	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00110	1	9	5	8	2045	null	700	S	12	1	4	SURF	90000	May 17, 2026, 10 p.m.	3230000
001	00110	2	5	1	2	10093	null	800	S	8	3	4	7243	90000	May 17, 2026, 10 p.m.	1700000
001	00111	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00111	2	7	null	null	10185	null	420	S	12	1	4	9450	null	May 17, 2026, 10 p.m.	null
001	00112	1	9	5	8	2237	null	500	S	12	1	4	SURF	40000	May 17, 2026, 10 p.m.	3230000
001	00112	2	5	1	2	10613	null	1300	S	8	3	4	6000	40000	May 17, 2026, 10 p.m.	1550170
001	00113	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00113	2	9	5	8	2231	null	500	S	12	1	4	SURF	80000	May 17, 2026, 10 p.m.	3230000
001	00113	3	5	1	2	10615	null	1325	S	8	3	4	8095	80000	May 17, 2026, 10 p.m.	1400170
001	00113	4	2	7	8	5048	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00117	1	9	5	8	2085	null	700	S	12	1	4	SURFACE	null	May 17, 2026, 10 p.m.	null
001	00117	2	5	1	2	10423	null	600	S	8	3	4	8414	null	May 17, 2026, 10 p.m.	null
001	00120	1	8	1	2	null	null	null	S	8	3	4	null	3091	May 17, 2026, 10 p.m.	1700000
001	00120	2	9	5	8	2155	null	575	S	12	1	4	SURF	3091	May 17, 2026, 10 p.m.	3600000
001	00128	1	10	3	4	2195	null	616	S	13	3	4	SURF	80000	May 17, 2026, 10 p.m.	4050000
001	00128	2	4	1	2	10163	null	650	S	8	3	4	6607	80000	May 17, 2026, 10 p.m.	1160135
001	00130	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00133	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00135	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00135	2	5	1	2	10300	null	600	S	8	3	4	null	null	May 17, 2026, 10 p.m.	null
001	00137	1	9	5	8	2201	null	700	S	12	1	4	null	90000	May 17, 2026, 10 p.m.	3600000
001	00137	2	5	1	2	10324	null	650	S	8	3	4	8950	90000	May 17, 2026, 10 p.m.	1700000
001	00139	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00164	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00167	1	8	5	8	245	null	null	S	12	1	4	SURF	70000	May 17, 2026, 10 p.m.	2400000
001	00167	2	5	1	2	3723	null	180	S	7	7	8	SURF	70000	May 17, 2026, 10 p.m.	1700000
001	00189	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00209	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00240	1	8	5	8	271	null	175	S	12	1	4	SURF	null	May 17, 2026, 10 p.m.	null
001	00240	2	4	1	2	3874	null	355	S	7	7	8	2500	null	May 17, 2026, 10 p.m.	null
001	00259	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00260	1	null	null	null	null	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00262	1	8	5	8	519	null	null	null	11	null	null	null	null	May 17, 2026, 10 p.m.	2400000
001	00262	2	5	1	2	4751	null	null	null	7	7	8	null	null	May 17, 2026, 10 p.m.	1400000
001	00263	1	8	5	8	523	null	null	S	11	null	null	null	null	May 17, 2026, 10 p.m.	2400000
001	00263	2	5	1	2	4727	null	null	S	7	7	8	null	null	May 17, 2026, 10 p.m.	1400000
001	00263	3	2	7	8	3565	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00264	1	10	3	4	1820	null	511	S	13	3	4	null	null	May 17, 2026, 10 p.m.	4000000
001	00264	2	5	1	2	4770	null	225	S	8	3	4	null	null	May 17, 2026, 10 p.m.	1400000
001	00266	1	2	3	8	4461	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00273	1	8	5	8	529	null	175	S	12	1	4	SURF	40000	May 17, 2026, 10 p.m.	2400000
001	00273	2	5	1	2	4775	null	225	S	7	7	8	SURF	40000	May 17, 2026, 10 p.m.	1400000
001	00273	3	null	null	null	null	1906	500	S	null	null	null	null	40000	May 17, 2026, 10 p.m.	null
001	00274	1	2	3	8	4613	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00276	1	2	3	8	4485	null	null	S	null	null	null	null	null	May 17, 2026, 10 p.m.	null
001	00280	1	13	3	8	538	null	375	S	17	1	2	SURF	50000	May 17, 2026, 10 p.m.	4800680
001	00280	2	9	5	8	5641	null	355	S	12	1	4	4335	50000	May 17, 2026, 10 p.m.	3600000
001	00280	3	null	null	null	null	1900	405	S	null	null	null	310	50000	May 17, 2026, 10 p.m.	null
001	00280	4	7	null	null	4823	null	null	S	null	null	null	null	50000	May 17, 2026, 10 p.m.	2000000

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.

`api_county`

varchar

Sampled: 50K
Distinct: 2

003 45.8K
001 4.2K

`api_unique`

varchar

Sampled: 50K
Distinct: 19.2K

33618 11
30895 10
02492 9
34128 9
32669 9
02146 9
30912 8
32706 8
31024 8
30471 8
31744 8
02113 8

`casing_count`

int2

Sampled: 50K
Distinct: 11

1 20.6K
2 18.3K
3 8.3K
4 2.3K
5 447
6 57
7 8
8 4
9 2
10 1
11 1

`cement_measurement`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0069

S 49.6K
Y 7

`cas_inch`

int4

Sampled: 50K
Distinct: 30
Empty: 0.0815

5 14.5K
8 13.8K
2 4.2K
13 3.6K
7 3.2K
9 2.6K
4 2.5K
10 721
11 354
12 145
16 76
1 69

`cas_frac_num`

int4

Sampled: 50K
Distinct: 9
Empty: 0.1594

1 17.2K
5 17K
3 6.4K
7 1.4K
9 6
8 2
13 1
2 1
4 1

`cas_frac_denom`

int4

Sampled: 50K
Distinct: 15
Empty: 0.1593

8 23.7K
2 17.1K
4 1.2K
5 9
16 7
7 6
12 4
3 2
38 2
21 1
6 1
52 1

`casing_depth_set`

int4

Sampled: 50K
Distinct: 8.2K
Empty: 0.0888

4800 310
4750 199
4700 185
4900 184
400 174
4850 141
4600 136
350 134
300 121
4550 118
5000 118
1960 115

Take it away

Back to everything we know about Wellbore Casing Records