Preview PDQ Well Completion Directory

First 100 rows

Out of roughly 98.1K rows in texas.pdq_og_well_completion. Version obs-4ba8a454dfe1.

`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	13	208632	201H	121	32360	121	09	DENTON	null	00529504	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208636	1 H	221	30994	221	09	HOOD	null	00529509	202305	202305	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208637	7	121	32476	121	09	DENTON	null	00529513	202302	202302	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208639	1H	439	31058	439	09	TARRANT	null	00529524	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208712	7	121	32466	121	09	DENTON	null	00529650	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208716	2 H	121	32526	121	09	DENTON	null	00529657	202003	202003	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208722	2 H	439	30808	439	09	TARRANT	null	00529660	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208724	3	439	30810	439	09	TARRANT	null	00529661	200604	200604	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208730	2 H	121	32454	121	09	DENTON	null	00529672	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208734	14	121	32381	121	09	DENTON	null	00529675	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208739	5	121	32424	121	09	DENTON	null	00529686	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208746	14	121	32446	121	09	DENTON	null	00529688	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208747	13	121	32440	121	09	DENTON	null	00529690	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208756	15	121	32442	121	09	DENTON	null	00529700	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208799	A 1 H	439	30700	439	09	TARRANT	null	00529778	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208800	B 1 H	439	31029	439	09	TARRANT	null	00529780	202603	202603	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208808	F 2 H	439	31013	439	09	TARRANT	null	00529781	202602	202602	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208809	P 1	439	31024	439	09	TARRANT	null	00529784	201212	201212	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208812	B 3	439	30971	439	09	TARRANT	null	00529791	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208814	G 1 H	439	31074	439	09	TARRANT	null	00529794	201810	201810	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208815	1 H	439	30992	439	09	TARRANT	null	00529795	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208816	1 H	439	31099	439	09	TARRANT	null	00529796	202402	202402	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208819	P 2 H	439	31025	439	09	TARRANT	null	00529799	201207	201207	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	208820	F 1	439	31012	439	09	TARRANT	null	00529800	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208864	10	121	32452	121	09	DENTON	null	00529893	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	208998	29 H	121	32453	121	09	DENTON	null	00530059	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209004	2	121	32486	121	09	DENTON	null	00530068	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209111	6	121	32554	121	09	DENTON	null	00530235	201901	201901	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	209176	2	121	32517	121	09	DENTON	null	00530312	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209217	16	121	32435	121	09	DENTON	null	00530361	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209260	2	121	32458	121	09	DENTON	null	00530457	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209290	B 3 H	121	32544	121	09	DENTON	null	00530471	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209300	1	121	32519	121	09	DENTON	null	00530482	202404	202404	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	209313	8	121	32475	121	09	DENTON	null	00530711	202201	202201	Y	A	L	July 26, 2026, 11:12 p.m.
G	13	209314	1 H	121	32492	121	09	DENTON	null	00530496	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209338	3	439	30699	439	09	TARRANT	null	00530520	202603	202603	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209342	1	121	32342	121	09	DENTON	null	00530525	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209345	1	121	32472	121	09	DENTON	null	00530536	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209365	1 H	121	32467	121	09	DENTON	null	00530550	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209366	11	121	32484	121	09	DENTON	null	00530551	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209367	1	121	32339	121	09	DENTON	null	00530552	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209384	1 H	121	32358	121	09	DENTON	null	00530570	202307	202307	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209395	6	439	30921	439	09	TARRANT	null	00530587	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209404	1 H	221	30992	221	09	HOOD	null	00530592	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209437	B 2 H	439	31104	439	09	TARRANT	null	00530632	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209438	B 2 H	439	31166	439	09	TARRANT	null	00530633	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209439	B 2 H	121	32376	121	09	DENTON	null	00530634	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	13	209440	1 H	439	31042	439	09	TARRANT	null	00530635	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250762	1	395	31545	395	05	ROBERTSON	null	00597087	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250763	10	395	31506	395	05	ROBERTSON	null	00597088	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250764	6	395	31528	395	05	ROBERTSON	null	00597089	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250765	9	395	31563	395	05	ROBERTSON	null	00597092	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250789	3	395	31535	395	05	ROBERTSON	null	00597147	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250795	2	395	31568	395	05	ROBERTSON	null	00597156	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250822	1	395	31428	395	05	ROBERTSON	null	00597205	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250823	14	395	31527	395	05	ROBERTSON	null	00597206	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250862	12	395	31516	395	05	ROBERTSON	null	00597302	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250883	1	395	31544	395	05	ROBERTSON	null	00597344	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250886	1	395	31519	395	05	ROBERTSON	null	00597349	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250888	3	395	31374	395	05	ROBERTSON	null	00597350	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250895	10	395	31291	395	05	ROBERTSON	null	00597368	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250980	H 1	395	31179	395	05	ROBERTSON	null	00597595	201711	201711	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	250984	A 1	395	31176	395	05	ROBERTSON	null	00597602	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	250985	1	395	31502	395	05	ROBERTSON	null	00597604	201611	201611	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	250987	C 1	395	31186	395	05	ROBERTSON	null	00597608	201702	201702	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	251017	2	395	31551	395	05	ROBERTSON	null	00597645	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251018	5	395	31288	395	05	ROBERTSON	null	00597646	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251023	6	395	31293	395	05	ROBERTSON	null	00597659	202208	202208	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	251026	5	395	31513	395	05	ROBERTSON	null	00597662	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251251	14	395	31517	395	05	ROBERTSON	null	00598057	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251269	3	395	31564	395	05	ROBERTSON	null	00598081	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251271	1	395	31436	395	05	ROBERTSON	null	00598091	202603	202603	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251290	1	395	31487	395	05	ROBERTSON	null	00598125	201911	201911	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251304	16	395	31515	395	05	ROBERTSON	null	00598144	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251305	5	395	31604	395	05	ROBERTSON	null	00598148	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251352	2	395	31412	395	05	ROBERTSON	null	00598213	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251362	5	395	31526	395	05	ROBERTSON	null	00598230	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251363	5	395	31576	395	05	ROBERTSON	null	00598231	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251408	1	395	31272	395	05	ROBERTSON	null	00598296	201309	201003	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251423	6	395	31575	395	05	ROBERTSON	null	00598313	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251643	1	395	31437	395	05	ROBERTSON	null	00598700	202603	202603	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251694	2	395	31588	395	05	ROBERTSON	null	00598769	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251740	1	395	31584	395	05	ROBERTSON	null	00598852	202203	202203	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	251904	5	395	31520	395	05	ROBERTSON	null	00599085	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251907	1	395	31304	395	05	ROBERTSON	null	00599089	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	251910	5	395	31370	395	05	ROBERTSON	null	00599093	201804	201804	Y	A	L	July 26, 2026, 11:12 p.m.
G	05	252018	1	395	31554	395	05	ROBERTSON	null	00599247	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252028	1	395	31332	395	05	ROBERTSON	null	00599265	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252060	1	395	31188	395	05	ROBERTSON	null	00599312	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252313	E 5	395	31587	395	05	ROBERTSON	null	00599754	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252315	E 2	395	31582	395	05	ROBERTSON	null	00599756	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252349	3	395	31341	395	05	ROBERTSON	null	00599803	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252360	1	395	31595	395	05	ROBERTSON	null	00599814	202603	202603	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252361	10	395	31615	395	05	ROBERTSON	null	00599815	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252363	1	395	31432	395	05	ROBERTSON	null	00599818	000000	200906	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252368	2	395	31614	395	05	ROBERTSON	null	00599826	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252411	5	395	31596	395	05	ROBERTSON	null	00599875	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252423	8	395	31631	395	05	ROBERTSON	null	00599894	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252437	2	395	31638	395	05	ROBERTSON	null	00599911	000000	000000	N	N	L	July 26, 2026, 11:12 p.m.
G	05	252439	3	395	31555	395	05	ROBERTSON	null	00599914	000000	000000	N	N	L	July 26, 2026, 11:12 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: 101

367 3.2K
363 2.9K
439 2.6K
483 2.5K
203 2.4K
301 2.2K
505 2.1K
469 1.7K
249 1.6K
109 1.6K
371 1.5K
285 1.5K

`api_unique_no`

varchar

Sampled: 50K
Distinct: 12K

32461 21
32444 21
31674 21
32535 20
32393 20
32500 19
32216 19
32680 19
32465 19
32478 19
30402 19
32498 18

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 1

G 50K

`district_no`

varchar

Sampled: 50K
Distinct: 12

04 7.8K
14 7.7K
10 7.6K
08 6K
13 5.9K
02 5.1K
05 3.4K
06 2.4K
03 1.7K
09 1.5K
11 860
01 68

`lease_no`

varchar

Sampled: 50K
Distinct: 50K

299830 1
294034 1
249573 1
285202 1
234227 1
165979 1
065420 1
121673 1
293249 1
209126 1
228173 1
204192 1

`well_no`

varchar

Sampled: 50K
Distinct: 6.4K

1 12.2K
2 4.8K
3 2.6K
1H 1.8K
4 1.6K
5 1.1K
2H 1K
6 860
7 668
3H 657
8 519
4H 458

`onshore_assc_cnty`

varchar

Sampled: 50K
Distinct: 101

367 3.1K
363 2.8K
439 2.6K
483 2.5K
203 2.4K
301 2.1K
505 2.1K
469 1.7K
249 1.6K
109 1.6K
371 1.5K
285 1.4K

`district_name`

varchar

Sampled: 50K
Distinct: 12

04 7.8K
10 7.7K
08 7.6K
7B 6K
09 5.9K
02 5.1K
05 3.4K
06 2.4K
03 1.7K
7C 1.5K
8A 860
01 68

Take it away

Back to everything we know about PDQ Well Completion Directory