First 100 rows

Out of roughly 741 rows in texas.oil_annual_field. Version obs-c0498c9b5052.

report_yeardistrictfield_namecounty_namemulti_county_flagdiscovery_datefield_numberoil_gravitytotal_wellsproducing_wellsoil_productioncasinghead_gas_prodtotal_gas_prodfiller1filler2filler3filler4filler5filler6filler7filler8filler9filler10filler11ingested_at
202510WILDCATN/AMN/AN/AN/A21000112331nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510WILDCAT-COMMISSION USE ONLYLIPSCOMBnull8-11-2004N/A1.000000nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ABRAHAM (GRANITE WASH)HEMPHILLnull1-18-19721103942.3100059799nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ACHILLES (TONKAWA)HEMPHILLnull00001275240.943672174307490845nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ADOBE WALLS (CONGL)HUTCHINSONnull7-09-1969369043.51000307950nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ADOBE WALLS (GRANITE WASH)HUTCHINSONnull4-28-1969239042.2000087096nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ADOBE WALLS (PENN LIME UPPER)HUTCHINSONnull4-10-1969367041.25000523445nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ADOBE WALLS (SPRING CREEK WASH)HUTCHINSONnull1-05-1970341241.8100070391nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510AGEY FIELDCARSONnull1948328529.00000300947TRANS. TO PANHANDLE CARSON CO. FLD. EFF 11-1-59.nullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALAMOSA (VIRGIL)OLDHAMnull5-11-1957610140.0000058270nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALAMOSA, EAST (GRANITE WASH)OLDHAMnull9-07-1957711643.31000116785nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALAMOSA, SOUTHEAST (MISSOURI)OLDHAMnull7-01-1959666436.6000048277nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALAMOSA DOME (CANYON REEF)OLDHAMnull11-16-2006613643.03002250145437nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLEN-PARKER (CHESTER BASAL)OCHILTREEnull10-01-1984923839.8000036786nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLEN-PARKER (MARMATON)OCHILTREEM5-20-1967698039.0231191344189944737419279496DKT 10-0306413 12/5/2017: ORDER THAT THE PAN PETRO (MARMATON)FIELD BE CONSOLIDATED INTO THE ALLEN-PARKER (MARMATON) FIELD ANDnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLEN & SMITH (PENN LIME)HUTCHINSONnull7-29-1969369443.9000017708FORMERLY ALLEN & SMITH FIELD 8-1-74.nullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLISON PARKS (CLEVELAND)HEMPHILLnull10-24-19851104854.10000647PER DOCKET 10-0272543 DATED 11/22/11, THE FOLLOWING FIELDSHAVE BEEN CONSOLIDATED INTO THE LIPSCOMB, S.E. (CLEVELAND)FIELD: ALLISON PARKS (CLEVELAND), FELDMAN (CLEVELAND),GLAZIER (CLEVELAND), GLAZIER, NW (CLEVELAND), HORSE CREEK,SE (CLEVELAND), HUMPHREYS (CLEVELAND), MATHERS (CLEVELAND),PARSELL (CLEVELAND), RILEY (CLEVELAND 10250), ANDURSCHELL (CLEVELAND).nullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLISON PARKS (DOUGLAS)WHEELERM7-16-1980885239.84220043199330995nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLISON PARKS (TONKAWA)WHEELERnull10-19-1982994837.000001123nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALLISON-BRITT (12350)WHEELERnull1-26-19851281454.61000115907nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR (ST. LOUIS)OCHILTREEnull11-14-1983910943.000008542nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR (HUNTON)OCHILTREEM1-01-1983910844.081029532095560nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR (TONKAWA)HEMPHILLnull1-10-1974852847.02113222678782396nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR (VIOLA)HANSFORDnull9-10-2009993850.00000205nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-BRAINARD (MARMATON)ROBERTSnull3-02-1996671243.00000541nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-FALCON (SIMPSON)OCHILTREEnull10-08-19841071748.01000384391nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-JINES (MARMATON)OCHILTREEnull2-08-2000748637.310001968nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-LIPS (ATOKA)ROBERTSM1-01-1995806738.02248462212488106nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-LIPS (DOUGLAS)ROBERTSM2-22-1988558639.02000103048nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-LIPS (MARMATON)ROBERTSM1-07-1997714041.2518823156461868nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR-LIPS (ST. LOUIS)ROBERTSM11-19-1992913037.2258166988181282486810nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR POOL (DOUGLAS)HEMPHILLM8-12-1993660940.0100079727nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ALPAR POOL (TONKAWA)ROBERTSnull8-10-1993683442.500005288nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510AMARILLO, NORTH (CANYON LIME)POTTERnull5-26-2014678140.1171272833353231732910nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510AMMER (TONKAWA)LIPSCOMBnull10-30-1996626842.000003305nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ARRINGTON (GRANITE WASH)HUTCHINSONnull5-22-1989538952.81100379755nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ARRINGTON (HUNTON)HUTCHINSONnull1-29-1985752041.0110703475994nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ARRINGTON (MARMATON)HUTCHINSONnull3-12-1993534445.31100131687nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ARRINGTON (MORROW)HUTCHINSONnull0000635429.000000nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510ARRINGTON, WEST (HUNTON)HUTCHINSONnull6-09-1988770435.600001526630nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510AT (MORROW, UPPER)SHERMANnull1-22-1996643540.3000023486nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510B & B (GRANITE WASH)WHEELERnull6-23-19881225653.433938795630680824nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BAR NINE (COUNCIL GROVE)HUTCHINSONnull7-07-1970380042.03000244004nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BAR NINE (PENN.)HUTCHINSONnull10-20-1959490343.0000085449nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BAR NINE (PENN. LIME 4000)HUTCHINSONnull11-01-1974660039.600008849nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BARLOW (DES MOINES)OCHILTREEnull2-04-1958696040.07243039660172nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BARLOW (MISSISSIPPIAN)OCHILTREEnull1-13-1960876139.011039967965nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BARLOW (OIL)OCHILTREEnull7-13-1960807042.00000190098nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BARTON (MORROW, UPPER)LIPSCOMBnull5-22-19581003441.033502861367128303nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BARTON CORNERS (CLEVELAND, UP.)LIPSCOMBnull6-23-2005747145.02293892171093062nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BEAL (MORROW LOWER)LIPSCOMBnull2-11-19651037938.50000272380nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BEAL (MORROW UPPER)LIPSCOMBnull6-05-1968974342.60000151512nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BEAL, SOUTH (UPPER MORROW)LIPSCOMBnull7-12-19881015543.0000046nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BECHTHOLD (TONKAWA)LIPSCOMBnull4-11-1959614240.03137314222332401nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIG LEBOWKSI (UPPER MORROW)OCHILTREEnull6-26-2006821540.0200052862nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIG TIMBER CREEK (DOUGLAS)HEMPHILLnull3-08-1973800043.82110810349587803nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BILLY-ROSE (GRANITE WASH 5600)WHEELERnull9-08-2004568847.011818869287467nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVINS (KRIDER, LOWER)SHERMANnull5-22-1958311036.50000104055nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVINS LIT (CANYON LIME)OLDHAMM1-29-2014939041.523221662921754534603588nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVINS LIT (WOLFCAMP)POTTERnull6-15-2017663049.02123905838165245nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVENS RANCH (GRANITE WASH)POTTERM8-05-1983935843.0200055253nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVINS RANCH (MISSOURIAN WASH)POTTERnull3-16-2023799441.0225450789154888nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BIVENS RANCH (PENN SAND)POTTERnull2-01-2012802040.0100027251nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BLOCK A-1 (DES MOINES)ROBERTSnull1-01-1966950643.0000012930nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOOKER, EAST (TONKAWA)LIPSCOMBnull10-13-1957629040.7000021305nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOOKER, N. (MORROW, UPPER)OCHILTREEM8-23-1981806240.427100742096544021SOME WELLS TRANS TO SELL (UPPER MORROW) 10-81775 1-1-84nullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOOKER, S. (BASAL CHESTER)LIPSCOMBnull7-15-1991995946.000003012nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOOKER, SW. (CLEVELAND)OCHILTREEM6-30-1988692238.6100030445nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOOTH-PROCTOR (MORROW, UP.)LIPSCOMBnull7-30-1981938233.3000024120nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BORN (TONKAWA)LIPSCOMBnull9-23-1984640438.200005806nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BOWERS (DOUGLAS)HEMPHILLnull4-17-1984842042.5000014013nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD (CLEVELAND)LIPSCOMBnull9-16-1959733339.60000715959PER DOCKET 10-0269213 DATED 4/5/11, THE BRADFORD (CLEVELAND)FIELD WAS CONSOLIDATED INTO THE LIPSCOMB (CLEVELAND) FIELD.nullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD (HEPLER)LIPSCOMBnull12-07-1980766336.5000057989nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD (MORROW, UP.)LIPSCOMBnull8-14-1981896442.100004751nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD (TONKAWA)LIPSCOMBnull11-19-1958648039.54294886715529092536nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD, NW. (TONKAWA)LIPSCOMBnull9-18-1967945040.01167901400910475nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD, S. (TONKAWA)LIPSCOMBnull6-15-1966666940.00000272746nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD, SE. (CLEVELAND)LIPSCOMBnull9-17-1961781642.100003311PER DOCKET 10-0269213 DATED 4/5/11,THE BRADFORD, SE.(CLEVELAND)FIELD WAS CONSOLIDATED INTO THE LIPSCOMB (CLEVELAND) FIELD.nullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRADFORD, WEST (TONKAWA)LIPSCOMBnull10-04-1983652146.0000027641nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRAINARD (ATOKA)ROBERTSnull8-22-1957749342.0000031049nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRAINARD (DES MOINES)HUTCHINSONnull10-06-1982676242.000006852nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRANDI (GRANITE WASH, UPPER)OLDHAMM8-13-1983793045.683035821159797nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRENT (GRANITE WASH)MOOREnull3-01-1982374439.00000262nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRILLHART (HUNTON)HANSFORDnull8-01-1972858045.51000100984nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BRITT RANCH W. (GRANITE WASH A )WHEELERnull10-06-19891265458.132654811219841nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BUFFALO WALLOW (DOUGLAS)HEMPHILLnull4-14-1978813140.021300264092444nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BUFFALO WALLOW (GRANITE WASH)HEMPHILLM3-25-19801152052.0516180813161286822nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BUFFALO WALLOW (OSWEGO, UPPER)HEMPHILLnull6-23-19841028232.8100021913nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER (PENNSYLVANIAN)OCHILTREEnull12-20-1951886435.0000049143nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER, EAST (MORROW, UPPER OIL)OCHILTREEnull12-31-1983871038.600003459nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER, NORTH (CLEVELAND)OCHILTREEnull4-30-1973710738.00000982087PER DOCKET 10-0269117 DATED 4/18/11, THE BULER, NORTH(CLEVELAND) FIELD CONSOLIDATED INTO THE PAN PETRO(CLEVELAND) FIELD.nullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER, NORTH (DOUGLAS)OCHILTREEnull1-23-1959577838.02000119629nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER, NORTH (MORROW, UPPER)OCHILTREEnull9-19-1958859839.01000221501nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BULER, SE. (MORROW, UPPER)OCHILTREEnull8-28-1962905038.50000187154nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510BURK (DOUGLAS 7340)HEMPHILLnull4-05-1966735843.000005859TRANSFERRED TO FELDMAN (DOUGLAS) 8-22-67nullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510C. A. HOBBY (CANYON REEF)CHILDRESSnull3-16-1988460436.6000085575nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510CNB (CLEVELAND)LIPSCOMBnull9-28-1980836042.000009243nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510C.N.B. (MORROW, LO.)LIPSCOMBnull5-04-19641083839.60000740190nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510CALLIHAM (ATOKA)OCHILTREEnull9-15-1980867644.7000010nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 a.m.
202510CAMBRIDGE (ATOKA)LIPSCOMBM9-29-1981876040.0100020769nullnullnullnullnullnullnullnullnullnullnullMay 18, 2026, 1:15 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
741
Distinct
1
  • 10 741

field_number

varchar

Sampled
741
Distinct
666
Empty
0.0027
  • 3000 4
  • 8730 3
  • 7930 3
  • 7492 3
  • 5844 2
  • 6534 2
  • 7537 2
  • 6665 2
  • 6412 2
  • 8360 2
  • 8118 2
  • 5790 2

report_year

varchar

Sampled
741
Distinct
1
  • 2025 741

field_name

varchar

Sampled
741
Distinct
741
  • SHREIKEY (GRANITE WASH) 1
  • ALPAR-JINES (MARMATON) 1
  • STAMPER (MORROW, UP.) 1
  • B & B (GRANITE WASH) 1
  • WAKA (MORROW, UPPER) 1
  • TECOVAS CREEK (GRANITE) 1
  • STEKOLL (CLEVELAND) 1
  • HODGES (DES MOINES) 1
  • COLDWATER RANCH, W. (MARMATON) 1
  • RED DEER (WOLFCAMP LM) 1
  • LIPS (MISSISSIPPIAN) 1
  • SHAPLEY (MORROW) 1

county_name

varchar

Sampled
741
Distinct
18
Empty
0.0027
  • OCHILTREE 175
  • LIPSCOMB 134
  • ROBERTS 93
  • HEMPHILL 84
  • HANSFORD 69
  • HUTCHINSON 47
  • WHEELER 33
  • SHERMAN 26
  • OLDHAM 23
  • HARTLEY 16
  • POTTER 16
  • GRAY 9

multi_county_flag

varchar

Sampled
741
Distinct
1
Empty
0.8772
  • M 91

discovery_date

varchar

Sampled
741
Distinct
687
Empty
0.0027
  • 0000 20
  • 1921 5
  • 4-25-1975 3
  • 10-01-1979 3
  • 1956 2
  • 4-05-1966 2
  • 6-19-1984 2
  • 5-22-1958 2
  • 11-12-1985 2
  • 8-01-1986 2
  • 7-15-1993 2
  • 6-16-2021 2

oil_gravity

varchar

Sampled
741
Distinct
169
Empty
0.0027
  • 40.0 66
  • 42.0 48
  • 38.0 30
  • 43.0 29
  • 39.0 29
  • 41.0 23
  • 44.0 18
  • 45.0 15
  • 46.0 14
  • 37.0 14
  • 36.0 14
  • 41.2 12

Take it away

Back to everything we know about Oil Annual Report Field Table