First 100 rows

Out of roughly 72.4M rows in texas.pdq_og_lease_cycle. Version obs-df26b454dad9.

oil_gas_codedistrict_nolease_nocycle_yearcycle_monthcycle_year_monthlease_no_district_nooperator_nofield_nofield_typegas_well_noprod_report_filed_flaglease_oil_prod_vollease_oil_allowlease_oil_ending_ballease_gas_prod_vollease_gas_allowlease_gas_lift_inj_vollease_cond_prod_vollease_cond_limitlease_cond_ending_ballease_csgd_prod_vollease_csgd_limitlease_csgd_gas_liftlease_oil_tot_displease_gas_tot_displease_cond_tot_displease_csgd_tot_dispdistrict_namelease_nameoperator_namefield_nameingested_at
O0828097200210200210280970821327574128210RnullY160217191000000725084017800727BBROOKSHIER, R.G. "A"DELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828097200211200211280970821327574128210RnullY25827084000000854920036500857BBROOKSHIER, R.G. "A"DELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828097200212200212280970821327574128210RnullY18427983000000965084018500967BBROOKSHIER, R.G. "A"DELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828120200201200201281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200202200202281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200203200203281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200204200204281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200205200205281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200206200206281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200207200207281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200208200208281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200209200209281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200210200210281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200211200211281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828120200212200212281200894929004791500RnullN00000000000000007BMUEHLSTEIN 45YOUNG, MARSHALL R., OIL CO.BMW (KING SAND)July 14, 2026, 1:46 a.m.
O0828139200201200201281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200202200202281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200203200203281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200204200204281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200205200205281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200206200206281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200207200207281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200208200208281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200209200209281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200210200210281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200211200211281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828139200212200212281390886089104345333RnullY005700000000000007BSMITH "A"TKP PETROLEUM, INC.AUDAS-GRAHAM (CAPPS LIME)July 14, 2026, 1:46 a.m.
O0828200200201200201282000889523106621750RnullY00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200202200202282000889523106621750RnullY00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200203200203282000889523106621750RnullY00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200204200204282000889523106621750RnullY00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200205200205282000889523106621750RnullN00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200206200206282000889523106621750RnullN00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200207200207282000889523106621750RnullN00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200208200208282000889523106621750RnullN00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828200200209200209282000889523106621750RnullN00000000000000007BPACE HEIRS UNITWALTER EXPLORATION COMPANYBECKHAM (TANNEHILL)July 14, 2026, 1:46 a.m.
O0828220200201200201282200821327574128210RnullY23227926400000035850840175003587BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828220200202200202282200821327574128210RnullY22625214100000032445920349003247BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828220200203200203282200821327574128210RnullY21927918900000035450840171003547BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828220200204200204282200821327574128210RnullY2332707000000036349200352003637BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828220200205200205282200821327574128210RnullY22627911600000035650840180003567BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O0828220200206200206282200821327574128210RnullY20024013500000032749200181003277BPEARCE, BONNIE LOUDELRAY OIL, INC.RACHEL (GUNSIGHT)July 14, 2026, 1:46 a.m.
O140505520020320020350551419685468887001RnullY59373700000006200000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020420020450551419685468887001RnullY59074200000006000000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020520020550551419685468887001RnullY59374700000006200000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020620020650551419685468887001RnullY59075200000006000000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020720020750551419685468887001RnullY69375800000006200000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020820020850551419685468887001RnullY59376300000006200000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520020920020950551419685468887001RnullY59076800000006000000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520021020021050551419685468887001RnullY59377300000006200000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520021120021150551419685468887001RnullY59077800000006000000010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140505520021220021250551419685468887001RnullY593783000000160620000016010WENDYD & S OIL CO. #1PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020120020151591402871068887001RnullY501241650000002751240000027510VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020220020251591402871068887001RnullY3511263000000213112001370021310VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020320020351591402871068887001RnullY511241140000002571240000025710VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020420020451591402871068887001RnullY2712014100000011120000001110VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020520020551591402871068887001RnullY4312474000000425124001100042510VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020620020651591402871068887001RnullY401201140000002961200000029610VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020720020751591402871068887001RnullY401241540000002961240000029610VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020820020851591402871068887001RnullY4112449000000294124001460029410VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920020920020951591402871068887001RnullY36120850000003021200000030210VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920021020021051591402871068887001RnullY401241250000002611240000026110VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920021120021151591402871068887001RnullY361201610000005481200000054810VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140515920021220021251591402871068887001RnullY409364000000257124001370025710VIDAARAPAHOE PROD. CO.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020120020154911447972568887001RnullY15121713000000116328601750011610STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020220020254911447972568887001RnullY188196170000006929680184006910STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020320020354911447972568887001RnullY16321713000000113328601670011310STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020420020454911447972568887001RnullY1822101000000043180018500410STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020520020554911447972568887001RnullY1892171500000083286018400810STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020620020654911447972568887001RnullY18021010000000345318001850034510STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020720020754911447972568887001RnullY18021712000000314328601780031410STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020820020854911447972568887001RnullY16721710000000358328601690035810STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120020920020954911447972568887001RnullY17621012000000301318001740030110STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120021020021054911447972568887001RnullY17621714000000297328601740029710STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120021120021154911447972568887001RnullY174210160000007031800172007010STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140549120021220021254911447972568887001RnullY7221788000000032860000010STEVENSON -B-L & G OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020120020155151457043268887001RnullY451930224000000408226164049500408210KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020220020255151457043268887001RnullY512840220000000351623632051600351610KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020320020355151457043268887001RnullY464930172000000410026164051200410010KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020420020455151457043268887001RnullY522900177000000364725320051700364710KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020520020555151457043268887001RnullY332930159000000418226164035000418210KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020620020655151457043268887001RnullY343900179000000413125320032300413110KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020720020755151457043268887001RnullY384930212000000436226164035100436210KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020820020855151457043268887001RnullY314930192000000419526164033400419510KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520020920020955151457043268887001RnullY352900208000000411825320033600411810KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520021020021055151457043268887001RnullY360930227000000394726164034100394710KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520021120021155151457043268887001RnullY342900239000000342225320033000342210KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140551520021220021255151457043268887001RnullY306775219000000365826164032600365810KILLOUGHMISTEX OPERATING, INC.PANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020120020157111468195668887001RnullY121551570000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020220020257111468195668887001RnullY101401670000000106400000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020320020357111468195668887001RnullY71551740000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020420020457111468195668887001RnullY41501780000000114000000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020520020557111468195668887001RnullY61551840000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020620020657111468195668887001RnullY181502020000000114000000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020720020757111468195668887001RnullY815539000000011780017100010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020820020857111468195668887001RnullY9155480000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120020920020957111468195668887001RnullY9150570000000114000000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120021020021057111468195668887001RnullY6155630000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120021120021157111468195668887001RnullY7150700000000114000000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.m.
O140571120021220021257111468195668887001RnullY7155770000000117800000010PRUETT -B-PRUETT, CECIL ESTATE OFPANHANDLE HUTCHINSON COUNTY FLD.July 14, 2026, 1:46 a.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
1
  • 01 50K

lease_no

varchar

Sampled
50K
Distinct
185
  • 000026 403
  • 000017 403
  • 000159 403
  • 000060 403
  • 000347 403
  • 000193 403
  • 000130 403
  • 000442 403
  • 000210 403
  • 000033 403
  • 000207 403
  • 000406 403

cycle_year_month

varchar

Sampled
50K
Distinct
12
  • 200211 4.2K
  • 200212 4.2K
  • 200210 4.2K
  • 200209 4.2K
  • 200208 4.2K
  • 200207 4.2K
  • 200206 4.2K
  • 200205 4.2K
  • 200204 4.2K
  • 200201 4.1K
  • 200202 4.1K
  • 200203 4.1K

operator_no

varchar

Sampled
50K
Distinct
63
  • 000118 5.8K
  • 000225 5.6K
  • 000000 5K
  • 000194 3.9K
  • 000151 3K
  • 000202 2.6K
  • 000103 2.1K
  • 000222 1.8K
  • 000211 1.6K
  • 000139 1.6K
  • 000203 1.6K
  • 000184 1.3K

field_no

varchar

Sampled
50K
Distinct
2
  • 00002001 45.1K
  • 00000000 4.9K

cycle_year

varchar

Sampled
50K
Distinct
1
  • 1993 50K

cycle_month

varchar

Sampled
50K
Distinct
1
  • 01 50K

Take it away

Back to everything we know about PDQ Lease Production by Cycle