First 100 rows

Out of roughly 1.1M rows in texas.pdq_og_summary_onshore_lease. Version obs-87f89cf0096d.

oil_gas_codedistrict_nolease_nooperator_nofield_nocycle_year_month_mincycle_year_month_maxlease_nameoperator_namefield_nameingested_at
G0127285873810011581380201211201712BAKER, EARLRUTHERFORD OIL CORPORATIONBRAZIL, SW. (LULING 9800)July 12, 2026, 11:41 p.m.
G0127285902052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0309756535309934773550199301199603BAUER, R.A. UNITHAMPTON RESOURCES CORPORATIONGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756602054234773550200605200707HANCOCK, MOZELLE UNITANADARKO E&P COMPANY LPGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756610308834773550199301200604HANCOCK, MOZELLE UNITBROWNING OIL COMPANY, INC.GIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756625213134773550200708201807HANCOCK, MOZELLE UNITENERVEST OPERATING, L.L.C.GIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756652154434733500202510202607HANCOCK, MOZELLE UNITMAGNOLIA OIL & GAS OPERATING LLCGIDDINGS (AUSTIN CHALK-3)July 12, 2026, 11:41 p.m.
G0309756652154434773550201808202509HANCOCK, MOZELLE UNITMAGNOLIA OIL & GAS OPERATING LLCGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756702054234773550200603200707HARRELL, MARY BLACKBURN UNITANADARKO E&P COMPANY LPGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756702054434773550200212200602HARRELL, MARY BLACKBURN UNITANADARKO AUSTIN CHALK COMPANYGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756715409034773550199301199509HARRELL, MARY BLACKBURN UNITCIRRUS PRODUCTION COMPANYGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756725213134773550200708201807HARRELL, MARY BLACKBURN UNITENERVEST OPERATING, L.L.C.GIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756752154434773550201808202607HARRELL, MARY BLACKBURN UNITMAGNOLIA OIL & GAS OPERATING LLCGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756771422634773550200102200211HARRELL, MARY BLACKBURN UNITRME AUSTIN CHALK COMPANYGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309756787666434773550199510200101HARRELL, MARY BLACKBURN UNITUNION PACIFIC AUSTIN CHALK CO.GIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0309757513942044640400199803199906YEAGER ADAMSCASHCO, L.L.C.IOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309757513958244640400199301199802YEAGER ADAMSCASHCO OIL COMPANYIOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309757574753444640400200307200511YEAGER ADAMSSANDEL OPERATING COMPANYIOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309757574755244640400199907200306YEAGER ADAMSSANDEL ENERGY, INC.IOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309758002042567011100199301199804OLD OCEAN UNITAMOCO PRODUCTION COMPANYOLD OCEAN (ARMSTRONG)July 12, 2026, 11:41 p.m.
G0309758038631067011100199805202607OLD OCEAN UNITHILCORP ENERGY COMPANYOLD OCEAN (ARMSTRONG)July 12, 2026, 11:41 p.m.
G0309758102042567011700199301199804OLD OCEAN UNITAMOCO PRODUCTION COMPANYOLD OCEAN (F- 8)July 12, 2026, 11:41 p.m.
G0309758138631067011700199805200506OLD OCEAN UNITHILCORP ENERGY COMPANYOLD OCEAN (F- 8)July 12, 2026, 11:41 p.m.
G0309758229337175234634200907201704RFR TRACT 246GALVESTON BAY ENERGY, LLCRED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758229337575234634201705202607RFR TRACT 246GALVESTON BAY OPERATING CO LLCRED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758253295175234634200301200609RFR TRACT 246MASTERS OIL & GAS, LLCRED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758253297075234634200006200212RFR TRACT 246MASTERS RESOURCES, L.L.C.RED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758284132275234634200610200906RFR TRACT 246TEKOIL AND GAS GULF COAST, LLCRED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758288620075234634199301200005RFR TRACT 246VINTAGE PETROLEUM, INC.RED FISH REEF (FB B-3, FRIO 17)July 12, 2026, 11:41 p.m.
G0309758410786567183333199301199512STATE TRACT 309BURGARD, TRUSTEEOLIVER POINT, S (3950)July 12, 2026, 11:41 p.m.
G0309758729337175234403200907201704RFR TRACT 246GALVESTON BAY ENERGY, LLCRED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309758729337575234403201705202607RFR TRACT 246GALVESTON BAY OPERATING CO LLCRED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309758753295175234403200301200609RFR TRACT 246MASTERS OIL & GAS, LLCRED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309758753297075234403200006200212RFR TRACT 246MASTERS RESOURCES, L.L.C.RED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309758784132275234403200610200906RFR TRACT 246TEKOIL AND GAS GULF COAST, LLCRED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309758788620075234403199301200005RFR TRACT 246VINTAGE PETROLEUM, INC.RED FISH REEF (FB B-1, FRIO 10)July 12, 2026, 11:41 p.m.
G0309760687542671885500199401199412PLEASANT BAYOUU.S. DEPARTMENT OF ENERGYPLEASANT BAYOU (FRIO GEOTHERMAL)July 12, 2026, 11:41 p.m.
G0309760723976571885500199301199306PLEASANT BAYOUEATON OPERATING CO., INC.PLEASANT BAYOU (FRIO GEOTHERMAL)July 12, 2026, 11:41 p.m.
G0309760787542671885500199307199312PLEASANT BAYOUU.S. DEPARTMENT OF ENERGYPLEASANT BAYOU (FRIO GEOTHERMAL)July 12, 2026, 11:41 p.m.
G0309773405889315561450200108201104JONES "FF"BC OPERATING, INC.CARAWAY (GLEN ROSE, GAS)July 12, 2026, 11:41 p.m.
G0309773419155415561450200007200107JONES "FF"CROWNQUEST OPERATING, LLCCARAWAY (GLEN ROSE, GAS)July 12, 2026, 11:41 p.m.
G0309773452538015561450199301200006JONES "FF"MARATHON OIL COMPANYCARAWAY (GLEN ROSE, GAS)July 12, 2026, 11:41 p.m.
G0309774188455543822530199301199512GOLD-ZAPPVENUS OIL COMPANYHUTCHINS, SW. (3165)July 12, 2026, 11:41 p.m.
G0309774225709748278544199301200003KGFCUEXXON CORP.KATY (I-B)July 12, 2026, 11:41 p.m.
G0309774225712848278544200004200607KGFCUEXXON MOBIL CORPORATIONKATY (I-B)July 12, 2026, 11:41 p.m.
G0309774227574048278544200608201212KGFCUFOREST OIL CORPORATIONKATY (I-B)July 12, 2026, 11:41 p.m.
G0309774238631048278544201301202607KGFCUHILCORP ENERGY COMPANYKATY (I-B)July 12, 2026, 11:41 p.m.
G0309778813942044640400199803199906SCAMARDOCASHCO, L.L.C.IOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309778813958244640400199301199802SCAMARDOCASHCO OIL COMPANYIOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309778874753444640400200307202607SCAMARDOSANDEL OPERATING COMPANYIOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309778874755244640400199907200306SCAMARDOSANDEL ENERGY, INC.IOLA (SUB-CLARKSVILLE)July 12, 2026, 11:41 p.m.
G0309783883718834773550199301200412NORTH GAYHILLTAURUS ENTERPRISES CORPORATIONGIDDINGS (AUSTIN CHALK, GAS)July 12, 2026, 11:41 p.m.
G0424883448654300008001200901201009RASHLAREDO ENERGYWILDCATJuly 12, 2026, 11:43 p.m.
G0127285910035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127285979710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286002052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286010035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286079710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286202052812018200201310201702WORTHEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286210035112018200202309202607WORTHEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286279710212018200201703202308WORTHEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286702052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286710035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286779710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286802052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286810035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286879710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286902052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286910035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127286979710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287102052812018200201308201702WORTHEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287110035112018200202309202607WORTHEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287179710212018200201703202308WORTHEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287302052812018200201401201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287310035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287379710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287402052812018200201207201702STANLEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287402054212018200201206201206STANLEY RANCHANADARKO E&P COMPANY LPBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287410035112018200202309202607STANLEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287479710212018200201703202308STANLEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287702052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287710035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287779710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287802052812018200201310201702WORTHEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287810035112018200202309202607WORTHEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287879710212018200201703202308WORTHEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287902052812018200201402201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287910035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127287979710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127288102052812018200201401201702BRISCOE CATARINA SOUTHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127288110035112018200202309202607BRISCOE CATARINA SOUTHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127288179710212018200201703202308BRISCOE CATARINA SOUTHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127288749997887251500201211202607APPLINGLEWIS PETRO PROPERTIES, INC.SUN T S H (OLMOS)July 12, 2026, 11:41 p.m.
G0127289102052812018200201309201702WORTHEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289110035112018200202309202607WORTHEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289179710212018200201703202308WORTHEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289202052812018200201310201702STANLEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289210035112018200202309202607STANLEY RANCHJAVELIN ENERGY PARTNERS MGMT LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289279710212018200201703202308STANLEY RANCHSN EF MAVERICK, LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 p.m.
G0127289302052812018200201311201702STANLEY RANCHANADARKO E&P ONSHORE LLCBRISCOE RANCH (EAGLEFORD)July 12, 2026, 11:41 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
  • 098582 13
  • 096618 13
  • 100977 13
  • 113782 13
  • 116557 13
  • 067270 13
  • 103176 13
  • 141534 13
  • 100629 13
  • 111599 12
  • 112470 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 937
  • 788997 819
  • 103575 777
  • 085408 597
  • 020542 571
  • 147699 541
  • 102824 538

field_no

varchar

Sampled
50K
Distinct
3.9K
  • 12018200 9.6K
  • 39744500 4K
  • 00256500 2.7K
  • 27135700 2K
  • 87251500 851
  • 83704300 656
  • 00002001 616
  • 16340500 455
  • 54928500 433
  • 30379500 416
  • 07856250 383
  • 93874100 370

cycle_year_month_min

int8

Sampled
50K
Distinct
401
  • 199301 5.3K
  • 201910 765
  • 202309 765
  • 201703 731
  • 202303 675
  • 202605 664
  • 199401 607
  • 199601 493
  • 200101 449
  • 201912 442
  • 199801 439
  • 200001 431

cycle_year_month_max

int8

Sampled
50K
Distinct
401
  • 202607 11.3K
  • 202308 764
  • 201909 727
  • 202604 696
  • 201702 686
  • 202302 643
  • 199312 624
  • 199512 509
  • 199912 479
  • 199412 479
  • 199812 464
  • 200112 457

lease_name

varchar

Sampled
50K
Distinct
9.4K
  • PILONCILLO 621
  • WEST RANCH -A- 391
  • MCFADDIN 360
  • BRISCOE COCHINA EAST RANCH 261
  • BRISCOE CATARINA WEST 260
  • GALVAN RANCH 233
  • FASKEN STATE 201
  • BORCHERS, WILLIAM 199
  • BRISCOE CATARINA SOUTH 197
  • LAMBERT, M. F. 195
  • BRISCOE CATARINA NORTH 195
  • TRAYLOR, MAUDE B. 178

Take it away

Back to everything we know about PDQ Onshore Lease Summary