Preview PDQ Well Completion Directory

First 100 rows

Out of roughly 820.6K rows in texas.pdq_og_well_completion. Version obs-6597bddc5c88.

First 100 rows of `texas.pdq_og_well_completion`, 17 columns wide
`oil_gas_code`	`district_no`	`lease_no`	`well_no`	`api_county_code`	`api_unique_no`	`onshore_assc_cnty`	`district_name`	`county_name`	`oil_well_unit_no`	`well_root_no`	`wellbore_shutin_dt`	`well_shutin_dt`	`well_14b2_status_code`	`well_subject_14b2_flag`	`wellbore_location_code`	`ingested_at`
G	11	019600	3	165	10074	165	8A	GAINES	null	00357549	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019644	9	165	02711	165	8A	GAINES	null	00357579	000000	200010	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019645	10	165	02714	165	8A	GAINES	null	00357580	000000	200010	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019833	1	165	01085	165	8A	GAINES	null	00357588	200508	200508	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	019840	1	165	02190	165	8A	GAINES	null	00357589	202602	202602	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019844	1	165	01453	000	8A	GAINES	null	00357590	200508	200508	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	019900	1	165	01042	000	8A	GAINES	null	00357600	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019903	1	165	01004	000	8A	GAINES	null	00357601	200703	200703	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	019907	1A	165	01051	165	8A	GAINES	null	00357606	000000	000000	0	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019908	3	165	01054	165	8A	GAINES	null	00357607	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019911	1	165	01679	165	8A	GAINES	null	00357603	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	019912	1	165	80005	165	8A	GAINES	null	00357597	201406	201406	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	019913	1	165	02784	165	8A	GAINES	null	00357602	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020102	3	165	01208	000	8A	GAINES	null	00357611	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020103	2 C	165	00465	165	8A	GAINES	null	00357612	201808	199801	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020112	1	165	00064	165	8A	GAINES	null	00357614	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020113	1	165	03228	165	8A	GAINES	null	00357615	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020115	2	165	01076	165	8A	GAINES	null	00357616	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020117	1	165	80008	165	8A	GAINES	null	00357617	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020118	1	165	80009	165	8A	GAINES	null	00357618	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020119	1	165	80010	165	8A	GAINES	null	00357619	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020120	2	165	80011	165	8A	GAINES	null	00357620	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020121	1	165	01159	000	8A	GAINES	null	00357621	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020122	1A	165	80013	165	8A	GAINES	null	00357622	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020764	1	165	00201	165	8A	GAINES	null	00357831	201912	201912	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	020765	1	165	10096	000	8A	GAINES	null	00357832	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020767	1	165	10062	165	8A	GAINES	null	00357833	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020768	2BH	165	02018	165	8A	GAINES	null	00357837	000000	200010	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020769	3BH	165	02019	165	8A	GAINES	null	00357838	000000	200010	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020770	15	165	02596	000	8A	GAINES	null	00357839	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020771	19	165	02597	000	8A	GAINES	null	00357840	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	020772	12	165	02600	165	8A	GAINES	null	00357841	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	021061	2	165	03205	165	8A	GAINES	null	00357902	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	031311	1	165	10176	165	8A	GAINES	null	00357780	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	031486	1	165	10175	165	8A	GAINES	null	00357781	000000	000000	0	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	031608	1A	165	10008	000	8A	GAINES	null	00357782	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	033632	1	165	10262	000	8A	GAINES	null	00357846	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	034936	9	165	00044	165	8A	GAINES	null	00357836	201912	201912	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	035036	1	165	10714	000	8A	GAINES	null	00357783	000000	000000	0	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	037056	1	165	10263	165	8A	GAINES	null	00357847	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	038483	1	165	10628	000	8A	GAINES	null	00357793	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	038816	1	165	10629	000	8A	GAINES	null	00357794	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	039603	2	165	10657	000	8A	GAINES	null	00357795	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	040347	1	165	10863	000	8A	GAINES	null	00357796	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	040570	4	165	10870	165	8A	GAINES	null	00357550	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	040789	17	165	10868	000	8A	GAINES	null	00357842	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	041970	17	165	10701	165	8A	GAINES	null	00357834	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	044381	1	165	10750	000	8A	GAINES	null	00357835	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	049757	1	165	80031	165	8A	GAINES	null	00357610	202106	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	060099	1 C	165	30215	165	8A	GAINES	null	00357548	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	060419	1	165	30371	165	8A	GAINES	null	00357551	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	060522	1	165	30442	165	8A	GAINES	null	00357581	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	062299	1 A	165	30432	165	8A	GAINES	null	00357806	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	065514	1	165	30516	165	8A	GAINES	null	00357791	201111	201111	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	065788	2	165	30525	165	8A	GAINES	null	00357582	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	067928	1	165	30529	000	8A	GAINES	null	00357792	201111	201111	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	071487	14	165	30646	165	8A	GAINES	null	00357604	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	072330	2	165	30607	165	8A	GAINES	null	00357605	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	073552	1	165	31191	000	8A	GAINES	null	00357797	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	076295	1	165	31299	165	8A	GAINES	null	00357591	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	077868	21	165	31402	165	8A	GAINES	null	00357843	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	078230	16	165	31417	165	8A	GAINES	null	00357844	201906	201906	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	078522	2	165	31212	000	8A	GAINES	null	00357598	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	078733	14	165	31403	165	8A	GAINES	null	00357845	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	079107	2	165	31431	165	8A	GAINES	null	00357599	201607	201607	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	079204	1	165	31311	165	8A	GAINES	null	00357556	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	079324	3	165	02705	165	8A	GAINES	null	00357583	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	081335	1 G	165	31543	165	8A	GAINES	null	00357592	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	081336	1 B	165	31522	165	8A	GAINES	null	00357593	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	081337	2 G	165	31544	165	8A	GAINES	null	00357594	202510	202510	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	089335	7	165	31806	165	8A	GAINES	null	00357804	201601	201601	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	091531	1	165	31505	165	8A	GAINES	null	00357596	201710	201710	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	093314	1	165	31839	165	8A	GAINES	null	00357857	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	095806	1	165	32159	165	8A	GAINES	null	00357595	202511	202511	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	096294	4	165	01328	165	8A	GAINES	null	00357805	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	097971	1012	165	32194	165	8A	GAINES	null	00357784	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	097972	1028	165	32193	165	8A	GAINES	null	00357785	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	099665	2028	165	32276	165	8A	GAINES	null	00357786	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	099666	2012	165	32272	165	8A	GAINES	null	00357787	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	101161	3028	165	32277	165	8A	GAINES	null	00357788	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	101162	3012	165	32273	165	8A	GAINES	null	00357789	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	101540	7540GC	165	31911	165	8A	GAINES	null	00357894	199801	199801	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	103548	1	165	32423	165	8A	GAINES	null	00357790	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	105286	1	165	32370	165	8A	GAINES	null	00357623	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	106592	1	165	32505	165	8A	GAINES	null	00357624	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	110957	1	165	32763	000	8A	GAINES	null	00357798	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	111302	1	165	32791	165	8A	GAINES	null	00357608	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	118450	1	165	31804	000	8A	GAINES	null	00357830	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	118523	2	165	32730	165	8A	GAINES	null	00357801	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	123351	1	165	32760	165	8A	GAINES	null	00357613	199801	199801	Y	D	L	Sept. 6, 2026, 11:01 p.m.
G	11	123499	1	165	33517	165	8A	GAINES	null	00357625	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	127838	1	165	33957	165	8A	GAINES	null	00357858	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	128312	1 T	165	33468	165	8A	GAINES	null	00357860	201310	201008	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	128792	1 C	165	33468	165	8A	GAINES	null	00357859	201310	201310	Y	A	L	Sept. 6, 2026, 11:01 p.m.
G	11	130658	3	165	33956	165	8A	GAINES	null	00357861	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	132958	1	165	34004	165	8A	GAINES	null	00357584	000000	000000	Y	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	136842	1013	165	34159	165	8A	GAINES	null	00390031	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	136843	2013	165	34189	165	8A	GAINES	null	00390032	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	136844	3013	165	34188	165	8A	GAINES	null	00390033	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.
G	11	136846	4012	165	34187	165	8A	GAINES	null	00390035	000000	000000	N	N	L	Sept. 6, 2026, 11:01 p.m.

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_code`

varchar

Sampled: 50K
Distinct: 14

003 25.7K
009 10.7K
013 5.2K
025 2.4K
001 2.3K
015 971
023 886
021 867
007 477
005 304
029 189
019 7

`api_unique_no`

varchar

Sampled: 50K
Distinct: 27.9K

00333 19
30478 12
30950 11
30951 11
00370 11
31053 10
30792 10
31029 10
30037 10
30207 10
30739 10
31061 10

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 1

G 50K

`district_no`

varchar

Sampled: 50K
Distinct: 3

02 20.1K
03 16.3K
01 13.5K

`lease_no`

varchar

Sampled: 50K
Distinct: 50K

267054 1
144357 1
287440 1
186801 1
080758 1
201534 1
190567 1
220024 1
126373 1
172212 1
046079 1
221738 1

`well_no`

varchar

Sampled: 50K
Distinct: 5.6K

1 13.7K
2 4.2K
3 2.2K
1H 1.5K
4 1.4K
5 1K
6 755
2H 735
7 576
3H 513
8 464
9 420

`onshore_assc_cnty`

varchar

Sampled: 50K
Distinct: 116

161 4.8K
389 3.8K
367 3.5K
295 2.5K
293 2K
429 1.8K
357 1.7K
109 1.6K
000 1.4K
179 1.3K
395 1.2K
233 1.2K

`district_name`

varchar

Sampled: 50K
Distinct: 8

08 11.1K
05 10.4K
10 8.2K
7B 7.7K
03 5.8K
7C 3.2K
09 2.8K
8A 860

Take it away

Back to everything we know about PDQ Well Completion Directory