First 100 rows

Out of roughly 1.1M rows in texas.pdq_og_summary_master_large. Version obs-2eb311e01a8a.

oil_gas_codedistrict_nolease_nooperator_nofield_nocycle_year_month_mincycle_year_month_maxdistrict_namelease_nameoperator_namefield_nameingested_at
G140220645725503052675019930119930710MCCLURE, BERT F.MOBIL PRODUCING TX. & N.M. INC.FELDMAN (TONKAWA)July 12, 2026, 11:24 p.m.
G061454142531629775211020000220100806KILLINGSWORTH "B" G.U.EOG RESOURCES, INC.WILLOW SPRINGS (COTTON VALLEY,W)July 12, 2026, 11:25 p.m.
G062308297142923902620020070820100406PROPES GAS UNITRIVERSTONE ENERGY OPERATING, LLCHARDWOOD (COTTON VALLEY)July 12, 2026, 11:25 p.m.
G062509151217009099850020090820100806TRAWICK GU 29CABOT OIL & GAS CORPORATIONTRAWICK (PETTIT-TP CONS.)July 12, 2026, 11:25 p.m.
G08090673841412618485002009052010067BBUCHANAN, H. UNITTEMPO RESOURCES GP, LLCMINERAL WELLS, S. (CONGL)July 12, 2026, 11:25 p.m.
G09120734646831879205002010082010087CMUNN-B 1125PDC-WV-CO CORPORATIONT. D. (6575)July 12, 2026, 11:25 p.m.
G09161357040798123907502002012010117CGOODE ESTATE C UNITBP AMERICA PRODUCTION COMPANYBROWN-BASSETT (WOLFCAMP)July 12, 2026, 11:25 p.m.
G140274202163788912000120000420100410SPURDEVON ENERGY PRODUCTION CO, L.P.TEXAS HUGOTONJuly 12, 2026, 11:25 p.m.
O0916452166150828573002009012010127CUNIV5 HATTIE4COG OPERATING LLCSHEEP MOUNTAIN (CONSOLIDATED)July 12, 2026, 11:25 p.m.
O10360509459218397720020050720100708KLOH B-39XOG OPERATING LLCSLATOR (DEVONIAN)July 12, 2026, 11:25 p.m.
O10269135261558528030020071220100708STANTON TOWNSITE UNIT IMARINER ENERGY, INC.SPRABERRY (TREND AREA)July 12, 2026, 11:25 p.m.
O10403106434018528030020100820101108CASEYPATRIOT RESOURCES, INC.SPRABERRY (TREND AREA)July 12, 2026, 11:25 p.m.
O10399593785358528030020100120100808LEAGUE 298-14HENRY RESOURCES LLCSPRABERRY (TREND AREA)July 12, 2026, 11:25 p.m.
O10335481661508528030020090120101208MADOLYNCOG OPERATING LLCSPRABERRY (TREND AREA)July 12, 2026, 11:25 p.m.
O14049726007509539120019930120101110WASSELLNATURAL GAS ANADARKO COMPANYWASSEL (CLEVELAND)July 12, 2026, 11:25 p.m.
O10395466434018528030020090620101108BROOKSPATRIOT RESOURCES, INC.SPRABERRY (TREND AREA)July 12, 2026, 11:25 p.m.
G031980841722322038530020030820101003EL FERROCARRIL LTDCONOCOPHILLIPS COMPANYCOOLEY (MEEK SAND)July 12, 2026, 11:25 p.m.
G042000812757404311825020070720100604ALEXANDER, CHARLESFOREST OIL CORPORATIONHUBBERD (LOBO)July 12, 2026, 11:25 p.m.
G031471466846365512070419990420100603MCINTYRE, WILLISQUESTAR EXPL. AND PROD. CO.LOUISE (RAY 6175)July 12, 2026, 11:25 p.m.
G131991062516916528020020050120100809LEE, LUTHERENCANA OIL & GAS(USA) INC.NEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G132043181916246528020020080820100209LINDLEY, BOBBYLEACRUSADER ENERGY GROUP INC.NEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G132222048361806528020020100920101009RILEYTARPON OIL COMPANYNEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G132379071093336528020020080320101209KILLOUGHBURLINGTON RESOURCES O & G CO LPNEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G132245402163786528020020061020100609SNIPES UNITDEVON ENERGY PRODUCTION CO, L.P.NEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G132406189459366528020020070420100309TOMONAXTO ENERGY INC.NEWARK, EAST (BARNETT SHALE)July 12, 2026, 11:25 p.m.
G140230191217006883100119930120101010DAUERCABOT OIL & GAS CORPORATIONPANHANDLE, WESTJuly 12, 2026, 11:25 p.m.
O01040943008042282000120070820101101KAISERGEOMEG OPERATING, LLCDALE-MCBRIDEJuly 12, 2026, 11:25 p.m.
O03106333139908643461020100720101203HANKAMERGOLDSTON OIL CORPORATIONSTOWELL, SOUTH (SMITH -B-)July 12, 2026, 11:25 p.m.
O02084521506554095774820010320100602CRABTREE, JERRY W.CHOICE EXPLORATION, INC.HEYSER (6000)July 12, 2026, 11:25 p.m.
O04097096175316115462520081220101104CAMPBELL ESTATEOCCIDENTAL ENERGY COMPANY, INC.MIDWAY (5680)July 12, 2026, 11:25 p.m.
G040153593283649981388820090120090304PARKS, W. S., ET ALGREAT BAY OPERATIONS, LLCZIM-RICABY (2600)July 12, 2026, 11:25 p.m.
G042475912716770738737520081020091104RUBEN R. GONZALEZ NO. 309FLATIRONS RESOURCES LLCBERRY R. COX (WX. 6B HINNANT)July 12, 2026, 11:25 p.m.
G09138582452709846465002002012009027CMIERS AKCS RESOURCES, INC.SONORA (CANYON UPPER)July 12, 2026, 11:25 p.m.
G021385945667897978215020071220090902MCCAN, C. K. JR., ET ALMILAGRO EXPLORATION, LLCSALEM (1440)July 12, 2026, 11:25 p.m.
G041975764999780801515020020920091004BOOTH UNCAL HLEWIS PETRO PROPERTIES, INC.BIG REEF (EDWARDS)July 12, 2026, 11:25 p.m.
G062187032569330752734120080720091206SCHULZEEXCO PRODUCTION COMPANY, LPBETHANY (PALUXY)July 12, 2026, 11:25 p.m.
G140400444411291962350019930520090210COLLARD -A-JONES ENERGY, LTD.COLLARD (WHITE DOLOMITE)July 12, 2026, 11:25 p.m.
O01146921418351290347520060520090501SWAIM 58CENTURY RESOURCES, INC.BUCK WHEAT (WALES)July 12, 2026, 11:25 p.m.
O0706379253162273020012000022009026ELATHROP -B-EOG RESOURCES, INC.EAST TEXASJuly 12, 2026, 11:25 p.m.
O0826513326480471130012003122009047BNEASGRAY OIL & GAS INC.JONES COUNTY REGULARJuly 12, 2026, 11:25 p.m.
G012042911481134280385020040620090201YEAGER GAS UNITCHEVRON U. S. A. INC.HOSTETTER (WILCOX 15300)July 12, 2026, 11:25 p.m.
O13308488849879243650020070820090409DAVIS, VAN B.VICARS MINERAL VENTURES, LLCUNDERWOOD-RAY (CONGLOMERATE)July 12, 2026, 11:25 p.m.
O13211098315983418450019931220091109HAAG, OLIVERSWAN PRODUCTION CO.GATES (ATOKA CONGLOMERATE)July 12, 2026, 11:25 p.m.
G031936328958052021119020060920091203KEYSTONE MILLSWAPITI OPERATING, LLCCONROE (MIDDLE WILCOX CONS.)July 12, 2026, 11:25 p.m.
G062052982569153541530020080720090806GLADEWATER G.U. 15EXCO OPERATING COMPANY, LPGLENWOOD (COTTON VALLEY)July 12, 2026, 11:25 p.m.
G062210972569153541530020080720090806FENTON, J.D. GUEXCO OPERATING COMPANY, LPGLENWOOD (COTTON VALLEY)July 12, 2026, 11:25 p.m.
G08110263541455532752002002112009127BSTRIEGLERMCCLYMOND, LTD.LEONARD (DUFFER)July 12, 2026, 11:25 p.m.
G101896027480167165970020061220090508LONGFELLOWSANDRIDGE ENERGY, INC.PINON (OVERTHRUST)July 12, 2026, 11:25 p.m.
G102246387480167165970020061120090508WEST RANCHSANDRIDGE ENERGY, INC.PINON (OVERTHRUST)July 12, 2026, 11:25 p.m.
G102381847480167165970020071120090508WEST RANCHSANDRIDGE ENERGY, INC.PINON (OVERTHRUST)July 12, 2026, 11:25 p.m.
G101310327885732884377719991020090808UNIVERSITY 20-10SLOAN PETROLEUM INC.EMBAR (YATES)July 12, 2026, 11:25 p.m.
G102387727480167165970020080320090508WEST RANCHSANDRIDGE ENERGY, INC.PINON (OVERTHRUST)July 12, 2026, 11:25 p.m.
G142241735015453315120020071020090210FRYE 9LINN OPERATING, INC.FRYE RANCH (CONSOLIDATED)July 12, 2026, 11:25 p.m.
O01150025248970490050020080920091201KOTHMANNMANTI OPERATING COMPANYBACKDRAFT (OLMOS)July 12, 2026, 11:25 p.m.
O0821079123867513652001993011993077BROCK "E"CALIFORNIA-T.D. AND ASSOC., INC.LAKE ABILENE (CROSS CUT)July 12, 2026, 11:24 p.m.
G09063856324140812673331993011993107CMAYER, EDWIN S., JR.GRAHAM ROYALTY, LTD.SAWYER (CANYON)July 12, 2026, 11:24 p.m.
O0824793106392000735001993011993037BDAWS MARTIN UNITBUFFUM OIL & GAS, INC.A. BAKER (MISS.)July 12, 2026, 11:24 p.m.
G09079317300756282517001993011993037CCOX "60"GEODYNE OPERATING COMPANYELA SUGG (WOLFCAMP)July 12, 2026, 11:24 p.m.
G041105158644240579180019930119930704ARCO FEETRANSAMERICAN NATURAL GAS CORP.BARNSLEY (LOBO 10,900)July 12, 2026, 11:24 p.m.
G041418328644241587427519930119930704CARR "B"TRANSAMERICAN NATURAL GAS CORP.CARR (LOBO 8700)July 12, 2026, 11:24 p.m.
G08063300575000014049001993011993077BBROWNMONCRIEF, W. A., JR.ALEDO, SE. (1200 STRAWN)July 12, 2026, 11:24 p.m.
G041431838644246383650019930119930704L.F.T.TRANSAMERICAN NATURAL GAS CORP.MUNOZ (LOBO)July 12, 2026, 11:24 p.m.
O13278827403200214307119930119930809HENRY, J. C.S & J OPERATING CO.ALVORD (ATOKA CONGLOMERATE)July 12, 2026, 11:24 p.m.
G09144269242980119748001993021993087CPARRAMOREEDGAR, C. B. OIL CO.BRILEY, SE. (GARDNER, LO.)July 12, 2026, 11:24 p.m.
O03139504939463473350019930419930703SCHOPPE, LEELEE "C" PRODUCTION COMPANY INC.GIDDINGS (AUSTIN CHALK-3)July 12, 2026, 11:24 p.m.
G08140087858320991712001993011993077BDAVIS YLTHROCKMORTON OIL, INC.Y-L (CADDO)July 12, 2026, 11:24 p.m.
O01046218442836998112519930619930901BEEVER, C.A. JR.TEXAN PRODUCTIONPEARSALL (AUSTIN CHALK)July 12, 2026, 11:24 p.m.
O0912046216735901966661993011993097CARCO FEE "23"DEVON ENERGY CORPORATION(NEVADA)TIPPETT, W. (WOLFCAMP LO.)July 12, 2026, 11:24 p.m.
O10275310481636241866619930119930708MITCHELL -C-BALL OIL FIELD SERVICEMONAHANS, NE. (PENN DETRITAL,UP)July 12, 2026, 11:24 p.m.
O1105856855610827106641993011993128AMURPHY "A"THOMPSON, J. CLEOSHARON RIDGE (2400)July 12, 2026, 11:24 p.m.
G09140148324140702835001993011993107CPOWELL "10"GRAHAM ROYALTY, LTD.PEGASUS, S. (BEND)July 12, 2026, 11:24 p.m.
O04093947033673929633319930119930104DOBIE, E. W.RESOURCE MANAGEMENT COMPANYHARRY (MIRANDO)July 12, 2026, 11:24 p.m.
G020720718862282912980019930119930702GOHLKE, M.F.VIRTEX PETROLEUM COMPANY, INC.ENKE (700)July 12, 2026, 11:24 p.m.
G140242496383506883100119930119931010BROADWAYPANHANDLE PRODUCING COMPANYPANHANDLE, WESTJuly 12, 2026, 11:24 p.m.
G08088214800281141703001993011993057BROGERSSO OPERATING COMPANYBYRNES (DUFFER)July 12, 2026, 11:24 p.m.
G08115659742261088794001993011993077BWHITFIELDSABRE OPERATING, INC.BLIND (DUFFER)July 12, 2026, 11:24 p.m.
O01058276271276998112519930419930801PENAORYX ENERGY COMPANYPEARSALL (AUSTIN CHALK)July 12, 2026, 11:24 p.m.
O0820972487327877195001993011993127BSWENSONLARSON, PERRY L OPERATING CO INCSWENSON -207- (CADDO)July 12, 2026, 11:24 p.m.
G09066139324140812673331993011993107CMAYER, EDWIN S. JR. "D"GRAHAM ROYALTY, LTD.SAWYER (CANYON)July 12, 2026, 11:24 p.m.
G021329772885835869316019930119930302MACHA-SWANSONFULLER, ANCIL T.MAYO (V-X6 VICKSBURG )July 12, 2026, 11:24 p.m.
O14000371968546884500119930119930910WORLEYD & S OIL CO. #1PANHANDLE CARSON COUNTY FIELDJuly 12, 2026, 11:24 p.m.
G041311675725509698040019930119930404JONES, FRED B. ET AL UNITMOBIL PRODUCING TX. & N.M. INC.WHITE POINT,EAST DEEP (HATCH)July 12, 2026, 11:24 p.m.
O03181526002109672291219930119931003FELDER-MOERSNASSER OIL & GAS, INC.WHARTON, S. (FRIO 6508)July 12, 2026, 11:24 p.m.
G08143750912942242823001993011993037BGUPTON-ADDISONWESTRIDGE OIL & GAS PROPERTIESDENNIS, WEST (STRAWN)July 12, 2026, 11:24 p.m.
O0911984314125981825681993011993067CONKENGONDAY INDUSTRIES CORPORATIONWINTERS (JENNINGS SAND)July 12, 2026, 11:24 p.m.
O0826120105970273580011993011993057BOGDENBUCKEYE ENERGY, INC.EASTLAND COUNTY REGULARJuly 12, 2026, 11:24 p.m.
G08114809516247192807001993011993037BBLACK RANCHLYNX ENERGY COMPANY, INC.COCKRELL (STRAWN)July 12, 2026, 11:24 p.m.
G040671932208381060635019930119930604GONZALES, MARIA ANADIRKS, R.W. PET. ENG. INC.BOOTH RANCH (OLMOS)July 12, 2026, 11:24 p.m.
O10262596408892503450019930119930808NAIL, JAS. H. JR. TRUSTEEPARKER & PARSLEY DEVELOPMENT CO.DIXON (STRAWN)July 12, 2026, 11:24 p.m.
O02077774489254023857519930119930602KUESTER, IDAKP EXPLORATION, INC.HELEN GOHLKE, SW. (YEGUA 5370)July 12, 2026, 11:24 p.m.
O10329001859804493005019930119931108WELCH "39"COX, JOHN L.J C (DEVONIAN)July 12, 2026, 11:24 p.m.
G041359888644245093255019930119930704LA PERLATRANSAMERICAN NATURAL GAS CORP.LA PERLA RANCH (LOBO 8800)July 12, 2026, 11:24 p.m.
G041459286271278994578119930619930904CANALES, A.T.ORYX ENERGY COMPANYTIJERINA-CANALES-BLUCHER ( 9400)July 12, 2026, 11:24 p.m.
O01130941494103096710019930119930201SPRADLINCHIPPEWA RESOURCES CORPORATIONFIRST SHOT (AUSTIN CHALK)July 12, 2026, 11:24 p.m.
O01131128159909030748019930119930301TOCQUIGNYSTARRAK OPERATING COMPANY, INC.TOCQUIGNY (OLMOS)July 12, 2026, 11:24 p.m.
O01030718497407990500119930119931201COPELAND UNITTEXLAN OIL COMPANY, INC.SALT FLATJuly 12, 2026, 11:24 p.m.
O0801039545890139240011993011993067BEVANS, E. E.MCDANIEL, M. K.BURT-OGDEN-MABEEJuly 12, 2026, 11:24 p.m.
G021173945189408888046819930119930802O'CONNOR, DENNIA ET AL "D"M-V COMPANYTERRELL POINT (3975)July 12, 2026, 11:24 p.m.
O0900967868539588400011993011993017CREESE, A. A. AC. 1TREY SERVICES, INC.MCCAMEYJuly 12, 2026, 11:24 p.m.
O0912331857063291435001993011993017CPRESLEYTHORNTON OIL CO.ENOCH JOHNSON (MORRIS SAND)July 12, 2026, 11:24 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
2
  • 01 33.2K
  • 02 16.8K

lease_no

varchar

Sampled
50K
Distinct
19.4K
  • 139234 14
  • 103176 13
  • 096618 13
  • 100629 13
  • 098582 13
  • 116557 13
  • 113782 13
  • 067270 13
  • 141534 13
  • 100977 13
  • 111599 12
  • 104096 12

operator_no

varchar

Sampled
50K
Distinct
2.6K
  • 100351 1.7K
  • 020528 1.7K
  • 797102 1.7K
  • 499978 1.6K
  • 781915 1.3K
  • 833348 936
  • 788997 820
  • 103575 777
  • 085408 598
  • 020542 571
  • 147699 541
  • 102824 538

field_no

varchar

Sampled
50K
Distinct
4K
  • 12018200 9.7K
  • 39744500 4K
  • 00256500 2.7K
  • 27135700 2K
  • 87251500 851
  • 83704300 656
  • 00002001 620
  • 16340500 456
  • 54928500 433
  • 30379500 417
  • 07856250 383
  • 93874100 372

cycle_year_month_min

int8

Sampled
50K
Distinct
402
  • 199301 6.3K
  • 201410 476
  • 201904 457
  • 200801 439
  • 201301 374
  • 200004 361
  • 202001 359
  • 201411 291
  • 200204 284
  • 199503 282
  • 200201 280
  • 200212 279

cycle_year_month_max

int8

Sampled
50K
Distinct
403
  • 202607 11.1K
  • 201409 457
  • 201903 396
  • 200308 365
  • 200712 354
  • 202604 335
  • 200003 334
  • 201212 321
  • 201912 320
  • 200211 282
  • 202101 280
  • 202312 277

district_name

varchar

Sampled
50K
Distinct
13
  • 08 6.8K
  • 04 5.7K
  • 09 5.7K
  • 7C 5.5K
  • 06 5.4K
  • 10 4.7K
  • 03 3.9K
  • 01 3.3K
  • 7B 3.1K
  • 02 2.6K
  • 05 1.9K
  • 8A 1.2K

Take it away

Back to everything we know about PDQ Lease Summary (master)