Preview PDQ Regulatory Lease Directory

First 100 rows

Out of roughly 548.5K rows in texas.pdq_og_regulatory_lease_dw. Version obs-b142cbbb8c02.

First 100 rows of `texas.pdq_og_regulatory_lease_dw`, 13 columns wide
`oil_gas_code`	`district_no`	`lease_no`	`district_name`	`lease_name`	`operator_no`	`operator_name`	`field_no`	`field_name`	`well_no`	`lease_off_sched_flag`	`lease_severance_flag`	`ingested_at`
G	11	019599	8A	H. & J. 385	263600	FASKEN, DAVID	05228800	BALE (YATES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	019901	8A	null	292323	G-M-K OIL CO., INC.	33473750	G-M-K (YATES)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	019902	8A	null	292323	G-M-K OIL CO., INC.	33473750	G-M-K (YATES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	020502	8A	PERKINS, J. J.	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	020679	8A	DOSS, M. S.	302450	GETTY OIL CO.	76707333	RILEY, NORTH (YATES)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	020770	8A	H. & J. SECTION 217	386310	HILCORP ENERGY COMPANY	82225852	SEMINOLE (YATES)	15	Y	N	Sept. 6, 2026, 11 p.m.
G	11	020926	8A	null	390490	HITCHCOCK, E. C. & SON	89005001	TEX-MEX	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	031486	8A	O. D. C. -B-	121945	CABOT TRANSMISSION CORPORATION	54849666	LOOP (YATES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	034560	8A	MASTERSON, R. B. -A-	339493	GUNN OIL COMPANY	47709333	JUNIPER (BEND CONGL.)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	035103	8A	MASTERSON, R. B. -A-	339493	GUNN OIL COMPANY	47709333	JUNIPER (BEND CONGL.)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	049400	8A	REED-WRIGHT -B-	841329	TEMA OIL AND GAS COMPANY	53411426	LEVELLAND (SAN ANDRES)	12	Y	N	Sept. 6, 2026, 11 p.m.
G	11	049401	8A	SEABOARD-WRIGHT	841329	TEMA OIL AND GAS COMPANY	53411426	LEVELLAND (SAN ANDRES)	6	Y	N	Sept. 6, 2026, 11 p.m.
G	11	052568	8A	O. D. C. -57- GAS UNIT	916958	WHITE ROCK OIL & GAS, LLC	96188666	WELLMAN, WEST (YATES)	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	053623	8A	PERKINS ESTATE	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	056873	8A	RAINS COUNTY SCHOOL LAND A/C 7	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	29	N	N	Sept. 6, 2026, 11 p.m.
G	11	057327	8A	COOK, W. E. "11"	263600	FASKEN, DAVID	12615200	BRUMLEY (CLEAR FORK, LO.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	059571	8A	RAINS COUNTY SCHOOL LAND A/C 7	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	30	N	N	Sept. 6, 2026, 11 p.m.
G	11	060099	8A	JONES ESTATE	516247	LYNX ENERGY COMPANY, INC.	05228800	BALE (YATES)	1 C	Y	N	Sept. 6, 2026, 11 p.m.
G	11	060561	8A	NELSON-BROWN	689412	RAMC DISP.	53411426	LEVELLAND (SAN ANDRES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	068984	8A	DUNBAR "B"	015134	ALPHA TWENTY-ONE PRODUCTION CO.	89005001	TEX-MEX	5	Y	N	Sept. 6, 2026, 11 p.m.
G	11	071180	8A	SEABOARD WRIGHT	331115	GREENE, VERNON	53411426	LEVELLAND (SAN ANDRES)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	071353	8A	SEABOARD-WRIGHT	841329	TEMA OIL AND GAS COMPANY	53411426	LEVELLAND (SAN ANDRES)	16	Y	N	Sept. 6, 2026, 11 p.m.
G	11	073946	8A	SEABOARD WRIGHT	841329	TEMA OIL AND GAS COMPANY	53411426	LEVELLAND (SAN ANDRES)	21	Y	N	Sept. 6, 2026, 11 p.m.
G	11	076151	8A	SEABOARD WRIGHT	331115	GREENE, VERNON	53411426	LEVELLAND (SAN ANDRES)	4	Y	N	Sept. 6, 2026, 11 p.m.
G	11	077094	8A	PRENTISS FIELDS "A"	643730	PATTON EXPLORATION, INC.	90170200	TIPPEN, S. (CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	078224	8A	LAWSON	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1010	N	Y	Sept. 6, 2026, 11 p.m.
G	11	078230	8A	H & J SECTION 217	386310	HILCORP ENERGY COMPANY	82225852	SEMINOLE (YATES)	16	N	N	Sept. 6, 2026, 11 p.m.
G	11	080320	8A	SEABOARD WRIGHT	841329	TEMA OIL AND GAS COMPANY	53411426	LEVELLAND (SAN ANDRES)	20A	Y	N	Sept. 6, 2026, 11 p.m.
G	11	083603	8A	BURNETT, S. B. ESTATE	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	1016	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	083604	8A	MASTERSON, T. B.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	087589	8A	BURNETT, S. B.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	1Q	Y	N	Sept. 6, 2026, 11 p.m.
G	11	087672	8A	BURNETT, S. B. ESTATE	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	2016	Y	N	Sept. 6, 2026, 11 p.m.
G	11	088381	8A	7907 JV-P KING	041860	BTA OIL PRODUCERS	73303333	PRUDENCE (ATOKA)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	088382	8A	TAYLOR, CYNTHIA	800750	SOJOURNER DRILLING CORPORATION	86020600	STESCOTT (ATOKA 6185)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	089226	8A	GIBSON, J. J.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	101	Y	N	Sept. 6, 2026, 11 p.m.
G	11	089875	8A	GIBSON, J. J.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	201	Y	N	Sept. 6, 2026, 11 p.m.
G	11	089909	8A	BURNETT, S. B.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	2Q	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	094683	8A	RATLIFF, J. P. JR.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	098744	8A	PERKINS ESTATE	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	2	N	N	Sept. 6, 2026, 11 p.m.
G	11	100510	8A	GIBSON, J. J.	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	203	Y	N	Sept. 6, 2026, 11 p.m.
G	11	105133	8A	HODGE, J. A. ESTATE	650125	PEDEN, OREN INC.	53411426	LEVELLAND (SAN ANDRES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	113832	8A	SLAUGHTER "18"	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1018	N	Y	Sept. 6, 2026, 11 p.m.
G	11	113833	8A	SLAUGHTER "20"	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1020	N	Y	Sept. 6, 2026, 11 p.m.
G	11	113859	8A	SLAUGHTER	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1019	N	Y	Sept. 6, 2026, 11 p.m.
G	11	116320	8A	LAWSON	288580	FULLER OPERATING COMPANY	53411426	LEVELLAND (SAN ANDRES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	116694	8A	SLAUGHTER "22"	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1	N	Y	Sept. 6, 2026, 11 p.m.
G	11	119124	8A	LAWSON	834370	TACTICAL OIL & GAS, LLC	53411426	LEVELLAND (SAN ANDRES)	1	N	Y	Sept. 6, 2026, 11 p.m.
G	11	120837	8A	DELOACHE, N.	852128	THOMAS EXPLORATION & DEVEL., INC	53411426	LEVELLAND (SAN ANDRES)	201	Y	N	Sept. 6, 2026, 11 p.m.
G	11	122809	8A	RAINS COUNTY SCHOOL LAND A/C 7	849745	TEXLAND-RECTOR & SCHUMACHER	53411426	LEVELLAND (SAN ANDRES)	33	Y	N	Sept. 6, 2026, 11 p.m.
G	11	122811	8A	RAINS COUNTY SCHOOL LAND A/C 7	253489	ERNMAR INVESTMENTS, INC.	53411426	LEVELLAND (SAN ANDRES)	36	N	N	Sept. 6, 2026, 11 p.m.
G	11	123499	8A	GILL "F"	338094	GULF EXPLORATION CORPORATION	42401500	HOMANN (YATES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	136695	8A	MASTERSON RANCH "R"	923282	WILD HORSE ENERGY	58178300	MASTERSON RANCH (BEND CONGL.)	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	137651	8A	MASTERSON RANCH "R"	923282	WILD HORSE ENERGY	58178300	MASTERSON RANCH (BEND CONGL.)	2	N	N	Sept. 6, 2026, 11 p.m.
G	11	145119	8A	BROOKS	339493	GUNN OIL COMPANY	12150500	BROKEN BONE (CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	149266	8A	BROTHERS	339493	GUNN OIL COMPANY	22704500	DAD WERNER (STRAWN)	3 C	Y	N	Sept. 6, 2026, 11 p.m.
G	11	149267	8A	BROTHERS	339493	GUNN OIL COMPANY	12150500	BROKEN BONE (CONGL.)	3 T	Y	N	Sept. 6, 2026, 11 p.m.
G	11	157073	8A	TRIANGLE B	110016	BURNETT OIL CO., INC.	62697200	MOON CAMP (CONGLOMERATE)	2R	Y	N	Sept. 6, 2026, 11 p.m.
G	11	158290	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	4	Y	N	Sept. 6, 2026, 11 p.m.
G	11	163205	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1A	Y	N	Sept. 6, 2026, 11 p.m.
G	11	163310	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	9	Y	N	Sept. 6, 2026, 11 p.m.
G	11	163321	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	10	Y	N	Sept. 6, 2026, 11 p.m.
G	11	164081	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	164082	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	4	Y	N	Sept. 6, 2026, 11 p.m.
G	11	164189	8A	JONES 23-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	5	Y	N	Sept. 6, 2026, 11 p.m.
G	11	164483	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	6	Y	N	Sept. 6, 2026, 11 p.m.
G	11	164484	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	7	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165596	8A	JONES 20-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165597	8A	JONES 20-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165610	8A	JONES 21A-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165611	8A	JONES 21A-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	2	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165612	8A	JONES 21A-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165613	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	8	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165614	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	10	Y	N	Sept. 6, 2026, 11 p.m.
G	11	165652	8A	JONES 496-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165653	8A	JONES 496-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	2	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165654	8A	JONES 497-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165655	8A	JONES 497-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	3	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165656	8A	JONES 498-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	1	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165658	8A	JONES 498-G	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	2	Y	Y	Sept. 6, 2026, 11 p.m.
G	11	165661	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	166476	8A	JONES 22-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	9	Y	N	Sept. 6, 2026, 11 p.m.
G	11	166477	8A	JONES 23-7	919408	WHITEHAWK PRODUCTION COMPANY	89024666	TEX-PAC (YATES)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	168963	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	11	Y	N	Sept. 6, 2026, 11 p.m.
G	11	172174	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	16	Y	N	Sept. 6, 2026, 11 p.m.
G	11	173619	8A	MASTERSON 02	339493	GUNN OIL COMPANY	90426500	TOM ("B" CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	175160	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	18	Y	N	Sept. 6, 2026, 11 p.m.
G	11	178815	8A	WINDFOHR, A.B. 10	110016	BURNETT OIL CO., INC.	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	19	Y	N	Sept. 6, 2026, 11 p.m.
G	11	183709	8A	RUSSELL	339493	GUNN OIL COMPANY	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	3	Y	N	Sept. 6, 2026, 11 p.m.
G	11	188935	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6386GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	189910	8A	CORNELL UNIT PF WELL	386310	HILCORP ENERGY COMPANY	95397001	WASSON	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	191356	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6364GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	191357	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6352GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	194005	8A	FOX	800750	SOJOURNER DRILLING CORPORATION	76251025	RHOMBOCHASM (BEND CONGLOMERATE)	1	N	N	Sept. 6, 2026, 11 p.m.
G	11	197497	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6392GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	202725	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6337GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	202728	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6396GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	203649	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6397GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	203694	8A	CORNELL UNIT	386310	HILCORP ENERGY COMPANY	95397001	WASSON	6388GC	N	N	Sept. 6, 2026, 11 p.m.
G	11	203696	8A	MASTERSON 43	339493	GUNN OIL COMPANY	47709333	JUNIPER (BEND CONGL.)	1	Y	N	Sept. 6, 2026, 11 p.m.
G	11	203699	8A	MASTERSON PN	339493	GUNN OIL COMPANY	97164003	WICHITA DOME (ATOKA)	1	Y	N	Sept. 6, 2026, 11 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.

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 1

G 50K

`district_no`

varchar

Sampled: 50K
Distinct: 3

02 32.8K
01 15K
03 2.3K

`lease_no`

varchar

Sampled: 50K
Distinct: 50K

116882 2
089638 2
006577 2
006327 2
001385 2
004530 2
157417 1
208465 1
121673 1
003682 1
136526 1
145098 1

`operator_no`

varchar

Sampled: 50K
Distinct: 2.8K

027200 4.6K
072504 4.5K
020425 2.2K
020528 2K
036550 1.6K
040209 1.4K
036587 980
053974 908
040798 855
029340 785
073056 630
018900 556

`field_no`

varchar

Sampled: 50K
Distinct: 3.8K

68831001 2.9K
27302001 2K
89120001 1.3K
68826001 1.1K
88576304 1.1K
32950285 960
05189550 868
53411001 803
20823500 713
68831200 524
95397001 501
30321300 478

`district_name`

varchar

Sampled: 50K
Distinct: 5

10 17K
8A 16.1K
05 15K
6E 2K
7B 4

`lease_name`

varchar

Sampled: 50K
Distinct: 23.5K
Empty: 0.0819

BIVINS 394
MASTERSON 375
JOHNSON 93
THOMPSON 87
INDIAN CREEK 84
DENVER UNIT 84
MCWATTERS, T. H. 82
BROWN 73
NEWSOM, C. A. ESTATE 70
HUFFMAN "B" 68
FLORES 65
LEWIS "B" 63

`operator_name`

varchar

Sampled: 50K
Distinct: 4.5K
Empty: 0.0055

HILCORP ENERGY COMPANY 3.6K
BURK ROYALTY CO., LTD. 2.8K
DIVERSIFIED PRODUCTION LLC 2.1K
MMGL TXPH, LLC 1.5K
MEWBOURNE OIL COMPANY 1.3K
PANTERA ENERGY COMPANY 1.2K
XTO ENERGY INC. 880
BCE-MACH III LLC 717
VALENCE OPERATING COMPANY 593
BP AMERICA PRODUCTION COMPANY 557
TEXACO INC. 475
COURSON OIL & GAS, INC. 421

Take it away

Back to everything we know about PDQ Regulatory Lease Directory