First 100 rows

Out of roughly 92.8K rows in texas.pr_gas_disposition. Version obs-482b1e748da9.

First 100 rows of texas.pr_gas_disposition, 28 columns wide
districtgas_well_gas_rrcidreport_yearreport_monthbalancing_codediscrepancy_printed_codeinvalid_or_omitted_codeextraction_loss_codecoding_mast_op_numbercompany_tape_op_numberfield_numberfield_namelease_namegas_well_gas_numberbatch_codelease_fld_fuel_systemstransmission_lineprocessing_plantvented_or_flaredgas_well_gas_liftpressure_maintenancecarbon_blackunderground_storageextraction_lossgas_well_gas_productiongas_well_gas_lift_injectedcondensate_productioningested_at
01000124202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.R 1null1710000000017100Sept. 14, 2026, 1:45 a.m.
01000124202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.R 1null1840000000018400Sept. 14, 2026, 1:45 a.m.
01000125202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.X 1null1830000000018300Sept. 14, 2026, 1:45 a.m.
01000125202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.X 1null1990000000019900Sept. 14, 2026, 1:45 a.m.
01000127202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.R 17null1840000000018400Sept. 14, 2026, 1:45 a.m.
01000127202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.R 17null1770000000017700Sept. 14, 2026, 1:45 a.m.
01000128202605Inullnullnull25426300000017876684CHITTIM (5600)CHITTIM3null4400000000044000Sept. 14, 2026, 1:45 a.m.
01000132202606Inullnullnull49997800000020336375COOKE (EDWARDS LIME)PXP COOKE, C. N., -A- GAS UNIT1null2136000000013800Sept. 14, 2026, 1:45 a.m.
01000159202606Inullnullnull10357500000024806333DILWORTH (EDWARDS LIME)SEALY, GOERGE EST.1null0053200000053200Sept. 14, 2026, 1:45 a.m.
01157464202606InullnullV10282400000000256500A.W.P. (OLMOS)SBR32null13013100000314703Sept. 14, 2026, 1:45 a.m.
01000207202606Inullnullnull94593600000030379500FASHING (EDWARDS LIME -A-)SCHUMAN ET AL GAS UNIT #21null0634000000063400Sept. 14, 2026, 1:45 a.m.
01000213202606InullnullV94593600000030379500FASHING (EDWARDS LIME -A-)TARTT, EMMA ET AL4null03205000000283233025Sept. 14, 2026, 1:45 a.m.
01000214202606Inullnullnull94593600000030379500FASHING (EDWARDS LIME -A-)TARTT, EMMA ET AL5null0177000000017700Sept. 14, 2026, 1:45 a.m.
01000222202606Inullnullnull13042600000030379500FASHING (EDWARDS LIME -A-)TOM "A" GU 31 Unull003000000300Sept. 14, 2026, 1:45 a.m.
01000437202606Inullnullnull64728400000078139142ROOS (WILCOX 7500)BAIN, W. S. UNIT1null01700000001700Sept. 14, 2026, 1:45 a.m.
01000481202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PETTY, O. S. -A-1null50000000005000Sept. 14, 2026, 1:45 a.m.
01000481202605Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PETTY, O. S. -A-1null55000000005500Sept. 14, 2026, 1:45 a.m.
01000482202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PXP PETTY, O. S. -B-2null50000000005000Sept. 14, 2026, 1:45 a.m.
01000483202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PXP PETTY, O. S. -A-4null193100000005000Sept. 14, 2026, 1:45 a.m.
01000487202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PXP MARTIN, ALBERT1null203200000005200Sept. 14, 2026, 1:45 a.m.
01000488202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)PXP PETTY, O.S.1null50000000005000Sept. 14, 2026, 1:45 a.m.
01000497202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -C-1null04400000004400Sept. 14, 2026, 1:45 a.m.
01000500202606Inullnullnull10357500000093874100VINEGARONE (STRAWN)COE, HAZEL WHITEHEAD1null0633000000063300Sept. 14, 2026, 1:45 a.m.
01000500202605Inullnullnull10357500000093874100VINEGARONE (STRAWN)COE, HAZEL WHITEHEAD1null0699000000069900Sept. 14, 2026, 1:45 a.m.
01000502202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -D-1null0129000000012900Sept. 14, 2026, 1:45 a.m.
01000517202606Inullnullnull49997800000096950666WHITE KITCHEN (EDWARDS LIME)VT BECKMAN, M. A.1null40216000000025600Sept. 14, 2026, 1:45 a.m.
01030575202605Inullnullnull17401700000017876684CHITTIM (5600)WRIGHT, TULETA CHITTIM5 Unull1050000000010500Sept. 14, 2026, 1:45 a.m.
01030575202604Inullnullnull17401700000017876684CHITTIM (5600)WRIGHT, TULETA CHITTIM5 Unull1710000000017100Sept. 14, 2026, 1:45 a.m.
01034408202605Inullnullnull17401700000017876608CHITTIM (5000)WRIGHT, TULETA CHITTIM6null1480000000014800Sept. 14, 2026, 1:45 a.m.
01034408202604Inullnullnull17401700000017876608CHITTIM (5000)WRIGHT, TULETA CHITTIM6null2010000000020100Sept. 14, 2026, 1:45 a.m.
01039498202606Inullnullnull70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH GAS UNIT1null0749000000074900Sept. 14, 2026, 1:45 a.m.
01043436202606Inullnullnull70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH GAS UNIT #12null0749000000074900Sept. 14, 2026, 1:45 a.m.
01046077202606Inullnullnull49997800000028977666ENCINAL (5800)BURKHOLDER5null400000000400Sept. 14, 2026, 1:45 a.m.
01050319202606InullnullV70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH, J. C. JR.9null0409020000002140923019Sept. 14, 2026, 1:45 a.m.
01051836202606Inullnullnull49997800000086357380STOREY (4900)VT STOREY, H. D.5Unull52500000003000Sept. 14, 2026, 1:45 a.m.
01053244202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E. -KJ-1null1720000000017200Sept. 14, 2026, 1:45 a.m.
01053244202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E. -KJ-1null1960000000019600Sept. 14, 2026, 1:45 a.m.
01053735202605Inullnullnull17401700000017876608CHITTIM (5000)CHITTIM, ANNIE E. -PJ-3null1550000000015500Sept. 14, 2026, 1:45 a.m.
01053735202604Inullnullnull17401700000017876608CHITTIM (5000)CHITTIM, ANNIE E. -PJ-3null2050000000020500Sept. 14, 2026, 1:45 a.m.
01053792202606Inullnullnull70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH, J. C. JR.10null0749000000074900Sept. 14, 2026, 1:45 a.m.
01053971202605Inullnullnull17401700000017876249CHITTIM (GEORGETOWN)CHITTIM, ANNIE E. (115)7MJnull1640000000016400Sept. 14, 2026, 1:45 a.m.
01053971202604Inullnullnull17401700000017876249CHITTIM (GEORGETOWN)CHITTIM, ANNIE E. (115)7MJnull1920000000019200Sept. 14, 2026, 1:45 a.m.
01055877202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E., (LJ)8null1660000000016600Sept. 14, 2026, 1:45 a.m.
01055877202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E., (LJ)8null1890000000018900Sept. 14, 2026, 1:45 a.m.
01056029202606Inullnullnull27393300000008072500BIG WELLS (SAN MIGUEL)BIG WELLS (SAN MIGUEL) UNIT5901null0082800000082800Sept. 14, 2026, 1:45 a.m.
01056202202605Inullnullnull17401700000017876600CHITTIM (4900)CHITTIM, ANNIE E.14JTnull1850000000018500Sept. 14, 2026, 1:45 a.m.
01056202202604Inullnullnull17401700000017876600CHITTIM (4900)CHITTIM, ANNIE E.14JTnull2010000000020100Sept. 14, 2026, 1:45 a.m.
01056796202606Inullnullnull37864100000032519500FRANCES HILL (PENN)HILL, FRANCIS -85-1null09000000009000Sept. 14, 2026, 1:45 a.m.
01059867202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -F-1null06800000006800Sept. 14, 2026, 1:45 a.m.
01060823202606Inullnullnull37864100000032519500FRANCES HILL (PENN)HILL, FRANCIS -89-1null03000000003000Sept. 14, 2026, 1:45 a.m.
01067499202606Inullnullnull10282400000042805500HOSTETTER, NORTH (WILCOX,UPPER)AMERICAN NATIONAL INS. G.U. -A-1null134123640000000370500Sept. 14, 2026, 1:45 a.m.
01067607202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)KRAUSE, A. L. ESTATE1null1012090000000121900Sept. 14, 2026, 1:45 a.m.
01068801202606Inullnullnull49997800000086792500STUART CITY (EDWARDS LIME)KRAUSE, A. L. ESTATE2null050000000500Sept. 14, 2026, 1:45 a.m.
01070354202606InullnullV70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH GAS UNIT #13null01334100000081334907Sept. 14, 2026, 1:45 a.m.
01071635202606Inullnullnull10079700000025146230DOERING RANCH (GEORGETOWN)CALVERT, J. H.1null002416000000241600Sept. 14, 2026, 1:45 a.m.
01073987202606Inullnullnull10357500000093874100VINEGARONE (STRAWN)ALTIZER, MINNIE LEE "B"1null015500000000155000Sept. 14, 2026, 1:45 a.m.
01073987202605Inullnullnull10357500000093874100VINEGARONE (STRAWN)ALTIZER, MINNIE LEE "B"1null019260000000192600Sept. 14, 2026, 1:45 a.m.
01074919202606InullnullV89117500000076213250RHODE RANCH, EAST (WILCOX FIRST)RHODE, D. W. -9-3 Unull8750600500000436923039Sept. 14, 2026, 1:45 a.m.
01075752202606Inullnullnull49997800000091080500TRI BAR (OLMOS)SCHLETZE, A.E.7null700000000700Sept. 14, 2026, 1:45 a.m.
01076846202606InullnullV37161600000080153700SAN CAJA (BLK 86 SD.)HAYES-EZZELL2 Tnull04112000000254137023Sept. 14, 2026, 1:45 a.m.
01078972202606Inullnullnull13042600000030379750FASHING (EDWARDS LIME -B-)URBANCZYK GU 12 Lnull003000000300Sept. 14, 2026, 1:45 a.m.
01082143202605Inullnullnull39685200000024806333DILWORTH (EDWARDS LIME)MARTIN, ALONZO1null041010000000410100Sept. 14, 2026, 1:45 a.m.
01082910202606Inullnullnull70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH GAS UNIT 14null0749000000074900Sept. 14, 2026, 1:45 a.m.
01083702202606Inullnullnull70161300000024806333DILWORTH (EDWARDS LIME)DILWORTH, J. C. JR.14null0749000000074900Sept. 14, 2026, 1:45 a.m.
01084357202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -G-1null08300000008300Sept. 14, 2026, 1:45 a.m.
01085715202606Inullnullnull13042600000030379500FASHING (EDWARDS LIME -A-)URBANCZYK GU 12 Unull003000000300Sept. 14, 2026, 1:45 a.m.
01087779202606InullnullV13042600000030379500FASHING (EDWARDS LIME -A-)URBANCZYK GU 23 Unull00696600000547020049Sept. 14, 2026, 1:45 a.m.
01089368202606Inullnullnull10357500000093874100VINEGARONE (STRAWN)CAUTHORN, ADAH -11-2null018280000000182800Sept. 14, 2026, 1:45 a.m.
01089368202605Inullnullnull10357500000093874100VINEGARONE (STRAWN)CAUTHORN, ADAH -11-2null0349000000034900Sept. 14, 2026, 1:45 a.m.
01090281202606Inullnullnull54667500000044267200IKE PRYOR (BRACERO)PRYOR RANCH2 Tnull19000000001900Sept. 14, 2026, 1:45 a.m.
01090529202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -C-2null09300000009300Sept. 14, 2026, 1:45 a.m.
01090625202606Inullnullnull49997800000091080500TRI BAR (OLMOS)D. W. TRI BAR 12 F6null500000000500Sept. 14, 2026, 1:45 a.m.
01090878202606Inullnullnull91695800000093874100VINEGARONE (STRAWN)CAUTHORN -B-2null07600000007600Sept. 14, 2026, 1:45 a.m.
01091131202606InullnullV94593600000030379500FASHING (EDWARDS LIME -A-)HENDERSON ET AL UNIT #12null01580000000321612029Sept. 14, 2026, 1:45 a.m.
01091710202606Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS2null3600000000036000Sept. 14, 2026, 1:45 a.m.
01091710202605Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS2null60000000006000Sept. 14, 2026, 1:45 a.m.
01091757202606InullnullV94593600000030379500FASHING (EDWARDS LIME -A-)HURT, W. T. ET AL4null06463000000116474010Sept. 14, 2026, 1:45 a.m.
01093161202606Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS3null25000000002500Sept. 14, 2026, 1:45 a.m.
01093161202605Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS3null10000000001000Sept. 14, 2026, 1:45 a.m.
01094152202606Inullnullnull54667500000098075250WINN-DULCE (DEL MONTE)PRYOR RANCH3 Tnull19000000001900Sept. 14, 2026, 1:45 a.m.
01094315202606Inullnullnull54667500000098075250WINN-DULCE (DEL MONTE)PRYOR RANCH32 Tnull20000000002000Sept. 14, 2026, 1:45 a.m.
01094317202606Inullnullnull54667500000098075250WINN-DULCE (DEL MONTE)PRYOR RANCH20 Tnull24000000002400Sept. 14, 2026, 1:45 a.m.
01094320202606Inullnullnull54667500000098075250WINN-DULCE (DEL MONTE)PRYOR RANCH11 Tnull16000000001600Sept. 14, 2026, 1:45 a.m.
01094323202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH19 Tnull15000000001500Sept. 14, 2026, 1:45 a.m.
01095064202606Inullnullnull54667500000098075250WINN-DULCE (DEL MONTE)PRYOR RANCH29 Tnull24000000002400Sept. 14, 2026, 1:45 a.m.
01095344202606InullnullV94593600000030379500FASHING (EDWARDS LIME -A-)HENDERSON, ET AL GAS UNIT #22null025230000006252905Sept. 14, 2026, 1:45 a.m.
01095834202606InullnullV94593600000030379500FASHING (EDWARDS LIME -A-)KOEHLER, EDNA S.2null01324000000341358031Sept. 14, 2026, 1:45 a.m.
01096408202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH30 Tnull15000000001500Sept. 14, 2026, 1:45 a.m.
01096975202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.21null1830000000018300Sept. 14, 2026, 1:45 a.m.
01096975202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE E.21null1850000000018500Sept. 14, 2026, 1:45 a.m.
01097978202606Inullnullnull13042600000030379500FASHING (EDWARDS LIME -A-)TOM "A" GU 32 Unull004000000400Sept. 14, 2026, 1:45 a.m.
01098624202605Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE22null1740000000017400Sept. 14, 2026, 1:45 a.m.
01098624202604Inullnullnull17401700000017876684CHITTIM (5600)CHITTIM, ANNIE22null2020000000020200Sept. 14, 2026, 1:45 a.m.
01099242202606Inullnullnull10389100000097476600WILL O, NORTH (WOLFCAMP)KINCAID1012null020000000200Sept. 14, 2026, 1:45 a.m.
01100166202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH63 Tnull20000000002000Sept. 14, 2026, 1:45 a.m.
01100551202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH59 Tnull21000000002100Sept. 14, 2026, 1:45 a.m.
01100923202606Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS4null4950000000049500Sept. 14, 2026, 1:45 a.m.
01100923202605Inullnullnull50608000000042298500HOLMAN RANCH, N (PENN)EPPS4null1200000000012000Sept. 14, 2026, 1:45 a.m.
01102559202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH79 Tnull21000000002100Sept. 14, 2026, 1:45 a.m.
01102696202606Inullnullnull54667500000098075200WINN-DULCE (BRACERO)PRYOR RANCH93 Tnull18000000001800Sept. 14, 2026, 1:45 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.

district

varchar

Sampled
50K
Distinct
7
  • 06 12.8K
  • 01 10.8K
  • 02 9K
  • 04 8.9K
  • 05 5.2K
  • 03 2.5K
  • 08 972

gas_well_gas_rrcid

varchar

Sampled
50K
Distinct
34.6K
  • 301665 24
  • 211949 24
  • 301676 24
  • 301719 24
  • 301606 24
  • 301887 24
  • 296484 24
  • 301305 24
  • 264506 24
  • 301808 24
  • 301714 24
  • 296487 24

report_year

varchar

Sampled
50K
Distinct
3
  • 2026 39.4K
  • 2025 8.6K
  • 2024 2K

report_month

varchar

Sampled
50K
Distinct
12
  • 06 20.2K
  • 05 9.9K
  • 04 4.1K
  • 03 3K
  • 01 2.9K
  • 02 2.5K
  • 08 1.6K
  • 09 1.4K
  • 10 1.2K
  • 11 1.1K
  • 07 1.1K
  • 12 955

balancing_code

varchar

Sampled
50K
Distinct
2
  • I 49.9K
  • O 100

discrepancy_printed_code

varchar

Sampled
50K
Distinct
0
Empty
1.0

invalid_or_omitted_code

varchar

Sampled
50K
Distinct
0
Empty
1.0

extraction_loss_code

varchar

Sampled
50K
Distinct
1
Empty
0.4829
  • V 25.9K

Take it away

Back to everything we know about PR (P-1/P-2) Gas Disposition (ASCII)