First 100 rows

Out of roughly 500K rows in texas.pdq_og_regulatory_lease_dw. Version obs-ccfd141039dc.

oil_gas_codedistrict_nolease_nodistrict_namelease_nameoperator_nooperator_namefield_nofield_namewell_nolease_off_sched_flaglease_severance_flagingested_at
G0528270805FOWLER 'A'220903DIVERSIFIED PRODUCTION LLC67102620OLETHA (TRAVIS PEAK)1NNJuly 26, 2026, 11:03 p.m.
O102270408JOHNSON, J. L.036550ATLANTIC RICHFIELD CO.21289180COWDEN, NORTH (CANYON)nullYNJuly 26, 2026, 11:03 p.m.
O102271108HOLT "C"191549CROWN RESOURCES, INC.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102274008USM "A"762500SEAY, JOHN R.53002666LEHN-APCO, NORTH (1600)nullYNJuly 26, 2026, 11:03 p.m.
O102274408COWDEN,B.T. "B"328362GREAT BASIN WELL SERVICE CORP.34639001GIBnullYNJuly 26, 2026, 11:03 p.m.
O102275708ABELL NORTHWEST MCKEE UNIT149441CHISOS OPERATING, INC.00296500ABELL, NORTHWEST (MCKEE SAND)nullYNJuly 26, 2026, 11:03 p.m.
O102276408HOLT "D"191549CROWN RESOURCES, INC.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102279608STIMSON-BURLEY185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102280108TEINERT185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102280308HOLT "A"806470SOUTHWEST ROYALTIES, INC.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102280408null762500SEAY, JOHN R.53000332LEHN-APCO (MONTOYA)nullYNJuly 26, 2026, 11:03 p.m.
O102280508null547855MCDONALD & MIDKIFF85280400SPRABERRY (TREND AREA CL. FK.)nullYNJuly 26, 2026, 11:03 p.m.
O102283308PARHAM251955ENERGY DEVELOPMENT CORP.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102285008WIGGINS, LLOYD M.450175KAISER-FRANCIS OIL COMPANY85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102285508SHULL216735DEVON ENERGY CORPORATION(NEVADA)85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102286408MCELROY328362GREAT BASIN WELL SERVICE CORP.34639001GIBnullYNJuly 26, 2026, 11:03 p.m.
O102287308CUMMINS, H. E. "C"760218SCOUT ENERGY MANAGEMENT LLC35659250GOLDSMITH, W. (DEVONIAN)nullNNJuly 26, 2026, 11:03 p.m.
O102288108MABEE, GUY "C"185980COX, JOHN L.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102288808UNIVERSITY "31"377550HENDON, WILLIAM E., JR.28899095EMMA (CONNELL)nullYNJuly 26, 2026, 11:03 p.m.
O102290208MABEE "E"185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102290708MORGAN, E. K.049950BARNES EXPLORATION COMPANY04701500B.F.M. (ELLEN.)nullYNJuly 26, 2026, 11:03 p.m.
O102291608MABEE, GUY "D"185980COX, JOHN L.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102291708HOLT "B"806470SOUTHWEST ROYALTIES, INC.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102292908COWDEN, JERRY876520UNION OIL COMPANY OF CALIFORNIA06385400BAYVIEW, W. (CLEAR FORK MI.)nullYNJuly 26, 2026, 11:03 p.m.
O102293608CONNELL, W. E. TR."B"216735DEVON ENERGY CORPORATION(NEVADA)47267684JORDAN (WADDELL)nullYNJuly 26, 2026, 11:03 p.m.
O102295308UNIVERSITY811975STALLION ENERGY, INC.22845500DALSAM (DEVONIAN)nullYNJuly 26, 2026, 11:03 p.m.
O102296008COPE, H.R."B"416330HUNT OIL COMPANY65766888NOLLEY (WOLFCAMP)nullYNJuly 26, 2026, 11:03 p.m.
O102296208CRESPI-J-185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102296308UNIVERSITY"27"185980COX, JOHN L.30394750FASKEN (WOLFCAMP)nullYNJuly 26, 2026, 11:03 p.m.
O102296908TXL"O"103919OXY USA WTP EOR, LLC35659750GOLDSMITH, W. (WADDELL)nullNNJuly 26, 2026, 11:03 p.m.
O102297308SCHARBAUER -B-185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102297508BAUER -A-561132MERIDIAN OIL INC.87073333SULPHUR DRAW (DEAN 8790)nullYNJuly 26, 2026, 11:03 p.m.
O102298408null416330HUNT OIL COMPANY65766888NOLLEY (WOLFCAMP)nullYNJuly 26, 2026, 11:03 p.m.
O102299108COPE,H.R.416330HUNT OIL COMPANY65973410NORMAN (DEVONIAN)nullYNJuly 26, 2026, 11:03 p.m.
O102299908null154380CITIES SERVICE OIL CO.65981500NORMAN,S(QUEEN)nullYNJuly 26, 2026, 11:03 p.m.
O102300508SNELL561132MERIDIAN OIL INC.87073333SULPHUR DRAW (DEAN 8790)nullYNJuly 26, 2026, 11:03 p.m.
O102302008COFFMAN,D.E.525339MARALO, LLC23907710DEEP ROCK (PENN.)nullYNJuly 26, 2026, 11:03 p.m.
O102302108PVOC -S-028617APV MCCAMEY LLC70129638PECOS VALLEY (LOW GRAVITY)nullNYJuly 26, 2026, 11:03 p.m.
O102303308null036550ATLANTIC RICHFIELD CO.82570700SHAFTER LAKE (YATES)nullYNJuly 26, 2026, 11:03 p.m.
O102303808KELTON871000TRI-SERVICE DRILLING CO.51152500LACAFF (DEAN)nullYYJuly 26, 2026, 11:03 p.m.
O102304108UNIVERSITY "69"036550ATLANTIC RICHFIELD CO.28899095EMMA (CONNELL)nullYNJuly 26, 2026, 11:03 p.m.
O102304808TIDAL"A"SEC.18806470SOUTHWEST ROYALTIES, INC.49129132KEYSTONE (COLBY)nullYNJuly 26, 2026, 11:03 p.m.
O102305308null154380CITIES SERVICE OIL CO.21292125COWDEN, SOUTH (CANYON 8790)nullYNJuly 26, 2026, 11:03 p.m.
O102306308HYATT216735DEVON ENERGY CORPORATION(NEVADA)11756270BREEDLOVE, SOUTH (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102306408SCHARBAUER -C-185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102307108UNIVERSITY "A"185980COX, JOHN L.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102308808HINYARD112687BUSTOS, MARTIN OIL41639666HINYARD (QUEEN)nullNYJuly 26, 2026, 11:03 p.m.
O102309508MABEE,GUY"E"185980COX, JOHN L.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102309808PVOC "WES"028617APV MCCAMEY LLC70129638PECOS VALLEY (LOW GRAVITY)nullNYJuly 26, 2026, 11:03 p.m.
O102310408ORSON, HENRY660241PETROLEUM ACQUISITIONS, INC.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102310708MABEE "D"806470SOUTHWEST ROYALTIES, INC.51152500LACAFF (DEAN)nullYNJuly 26, 2026, 11:03 p.m.
O102310908WADE450175KAISER-FRANCIS OIL COMPANY11751200BREEDLOVE (SPRABERRY)nullYNJuly 26, 2026, 11:03 p.m.
O102311508null154380CITIES SERVICE OIL CO.23907710DEEP ROCK (PENN.)nullYNJuly 26, 2026, 11:03 p.m.
O102311908null855610THOMPSON, J. CLEO59339700MCELROY, NORTH (SILURIAN)nullYNJuly 26, 2026, 11:03 p.m.
O102312008WADDELL276959FORMENTERA OPERATIONS LLC49129594KEYSTONE (SAN ANDRES)nullNNJuly 26, 2026, 11:03 p.m.
O102312208COWDEN,B.T."A"328362GREAT BASIN WELL SERVICE CORP.34639001GIBnullYNJuly 26, 2026, 11:03 p.m.
O102313708WINDHAM450175KAISER-FRANCIS OIL COMPANY69233664PARKS (SPRABERRY)nullYNJuly 26, 2026, 11:03 p.m.
O102314908PARHAM561132MERIDIAN OIL INC.87073333SULPHUR DRAW (DEAN 8790)nullYNJuly 26, 2026, 11:03 p.m.
O102315408DICKINSON, EDWARD416330HUNT OIL COMPANY70129122PECOS VALLEY (DEVONIAN A)nullYNJuly 26, 2026, 11:03 p.m.
O102317708KING "B"185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
O102318908KING185980COX, JOHN L.85280300SPRABERRY (TREND AREA)nullYNJuly 26, 2026, 11:03 p.m.
G0528296805T-BAR X SMITHERMAN220903DIVERSIFIED PRODUCTION LLC05189550BALD PRAIRIE (CV CONSOLIDATED)1NNJuly 26, 2026, 11:03 p.m.
G0528297005MCBRIDE GAS UNIT NO. 1220903DIVERSIFIED PRODUCTION LLC11470800BRANTON (RODESSA)1NNJuly 26, 2026, 11:03 p.m.
G0528332605WEST A220903DIVERSIFIED PRODUCTION LLC06476800BEAR GRASS (TRAVIS PEAK)7NNJuly 26, 2026, 11:03 p.m.
G0528376605WEST "A"220903DIVERSIFIED PRODUCTION LLC06476800BEAR GRASS (TRAVIS PEAK)4NYJuly 26, 2026, 11:03 p.m.
G0528406005T-BAR-X/SORRELS220903DIVERSIFIED PRODUCTION LLC81262050SAVELL (BOSSIER SAND)4NNJuly 26, 2026, 11:03 p.m.
G0528417505MCFERRAN U-BURLESON MCBAY U220903DIVERSIFIED PRODUCTION LLC32950285FREESTONE (CV-BOSSIER CONS.)1HANNJuly 26, 2026, 11:03 p.m.
G0528436805NETTLES U-MCFERRAN LCCO220903DIVERSIFIED PRODUCTION LLC32950285FREESTONE (CV-BOSSIER CONS.)1HANNJuly 26, 2026, 11:03 p.m.
G0528579805PRUIETT, M.E.220903DIVERSIFIED PRODUCTION LLC88582166TEAGUE, WEST (PETTIT)3NNJuly 26, 2026, 11:03 p.m.
G0529037105MABEL CARPENTER ET AL G.U.220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)2NNJuly 26, 2026, 11:03 p.m.
G0529039705WHITE388861HILLTEX OPERATING COMPANY, LLC10974200BOX CHURCH (PETTIT)5NNJuly 26, 2026, 11:03 p.m.
G0529042605SMYTHE GAS UNIT220903DIVERSIFIED PRODUCTION LLC72710401POKEY (RODESSA B)2NNJuly 26, 2026, 11:03 p.m.
G0529046205VANCE, MAE B. G.U.220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)3NNJuly 26, 2026, 11:03 p.m.
G0529055305HANNAH WATSON RODESSA GAS UNIT220903DIVERSIFIED PRODUCTION LLC11470800BRANTON (RODESSA)3NNJuly 26, 2026, 11:03 p.m.
G0529081005LANE, T. W.027049AP OPERATING, INC.49692755KIRVIN (TRAVIS PEAK,UPPER)3NYJuly 26, 2026, 11:03 p.m.
G0529411805BARON-HARTMAN GU 1220903DIVERSIFIED PRODUCTION LLC11470800BRANTON (RODESSA)5NNJuly 26, 2026, 11:03 p.m.
G0529412005DANIEL, PETER EST.220903DIVERSIFIED PRODUCTION LLC24478379DEW (TRAVIS PEAK)9NNJuly 26, 2026, 11:03 p.m.
G0529444205MAGGIE B. BROWN220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)5NNJuly 26, 2026, 11:03 p.m.
G0529444405MABEL CARPENTER ET AL GU220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)4NNJuly 26, 2026, 11:03 p.m.
G0529467005LITTLE, W. P.220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)4NNJuly 26, 2026, 11:03 p.m.
G0529476005WATSON, IKE NO. 1 GAS UNIT220903DIVERSIFIED PRODUCTION LLC46335500JEWETT (PETTIT)3NNJuly 26, 2026, 11:03 p.m.
G0529502805WORSLEY220903DIVERSIFIED PRODUCTION LLC70792333PERSONVILLE (RODESSA)1NNJuly 26, 2026, 11:03 p.m.
G0529511405A. O. EVANS, JR. GU220903DIVERSIFIED PRODUCTION LLC24478379DEW (TRAVIS PEAK)13NNJuly 26, 2026, 11:03 p.m.
G0529526305LITTLE, W. P.220903DIVERSIFIED PRODUCTION LLC70792666PERSONVILLE (TRAVIS PEAK)5NNJuly 26, 2026, 11:03 p.m.
G0529556705FOWLER 'A'220903DIVERSIFIED PRODUCTION LLC67102200OLETHA (PETTIT)1NNJuly 26, 2026, 11:03 p.m.
O050004305null213350DELTA DRILLING CO.19947001COMOnullYNJuly 26, 2026, 11:03 p.m.
O050004405null213350DELTA DRILLING CO.19947001COMOnullYNJuly 26, 2026, 11:03 p.m.
O050006805null040750B. M. &M. OIL CO.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050007105null040750B. M. &M. OIL CO.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050009605null074165BLAIR OIL COMPANY (1)20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050018705null084560BOYD BROTHERS & RASH20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050019205RICHARDSON, R. B.368750HAYES, RAYMOND20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050019305null208115DAWSON, PLEAS E.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050019405JACKSON, J. L.556640MEANS OIL COMPANY, LLC20823500CORSICANA (SHALLOW)nullNNJuly 26, 2026, 11:03 p.m.
O050019905null208115DAWSON, PLEAS E.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050020005null208115DAWSON, PLEAS E.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050020105null208115DAWSON, PLEAS E.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050020205null208115DAWSON, PLEAS E.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050020805RAMSEY, S. D., ESTATE601105NAVARRO PETROLEUM CORP.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 p.m.
O050022205HICKEY, T. J.601105NAVARRO PETROLEUM CORP.20823500CORSICANA (SHALLOW)nullYNJuly 26, 2026, 11:03 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.7K
  • 01 14.8K
  • 03 2.5K

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 625
  • 018900 556

field_no

varchar

Sampled
50K
Distinct
9.1K
  • 68831001 1.9K
  • 27302001 947
  • 65280200 728
  • 16032300 711
  • 68826001 689
  • 85280300 680
  • 89120001 660
  • 20823500 501
  • 68831200 477
  • 20097700 467
  • 99480001 426
  • 53411001 399

district_name

varchar

Sampled
50K
Distinct
11
  • 08 8.5K
  • 10 8.5K
  • 8A 7.9K
  • 05 7.4K
  • 09 5.2K
  • 06 3.6K
  • 03 3.2K
  • 01 2.5K
  • 02 2.2K
  • 6E 947
  • 7C 42

lease_name

varchar

Sampled
50K
Distinct
28.4K
Empty
0.0951
  • BIVINS 357
  • MASTERSON 351
  • WEST RANCH 210
  • CONROE FIELD UNIT 95
  • DENVER UNIT 84
  • THOMPSON 82
  • INDIAN CREEK 81
  • JOHNSON 70
  • HUFFMAN "B" 68
  • LEWIS "B" 63
  • WORTHY GAS UNIT 58
  • COON, R. S. 58

operator_name

varchar

Sampled
50K
Distinct
5.1K
Empty
0.0047
  • BURK ROYALTY CO., LTD. 3K
  • MEWBOURNE OIL COMPANY 1.3K
  • FORMENTERA OPERATIONS LLC 994
  • XTO ENERGY INC. 875
  • DEVON ENERGY PRODUCTION CO, L.P. 800
  • SABINE ENERGY INC. 749
  • BCE-MACH III LLC 629
  • VALENCE OPERATING COMPANY 589
  • BP AMERICA PRODUCTION COMPANY 560
  • HILCORP ENERGY COMPANY 555
  • ATLANTIC RICHFIELD CO. 539
  • SCOUT ENERGY MANAGEMENT LLC 517

Take it away

Back to everything we know about PDQ Regulatory Lease Directory