First 100 rows

Out of roughly 33.9K rows in texas.oil_annual_field. Version obs-6f293c9eb4a9.

First 100 rows of texas.oil_annual_field, 25 columns wide
report_yeardistrictfield_namecounty_namemulti_county_flagdiscovery_datedepth_ftoil_gravitytotal_wellsproducing_wellsoil_productioncasinghead_gas_prodcumulative_oilremark1remark2remark3remark4remark5remark6remark7remark8remark9remark10filler11ingested_at
202501WILDCATN/AMN/AN/AN/A6810028954nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501WILDCAT-COMMISSION USE ONLYN/AnullN/AN/AN/A00000DUMMY FIELD CREATED FOR ADMINISTRATIVE PURPOSES IN VALIDATINGDRILLING PERMITS WITHIN THE NEW MIGRATED SYSTEM. (ECAP)nullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501A.W.P. (OLMOS)MCMULLENM12-20-1981980038.0549420504781283881050496637PER DOCKET 01-0286066 BIG MULE(OLMOS 8850) CONSOLIDATEDA.W.P.(OLMOS) EFFECTIVE 03/25/14PER DOCKET 01-0277308 THE ENTIRE CORRELATIVE INTERVAL FROM9000' TO 10154' SHALL BE CONSIDERED A SINGLE RESERVIOR.CERTIFIED PLATS REQUIRED.PER DOCKET #01-0277308 OPERATORS SHALL FILE CERTIFIED PLATS.nullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501A.W.P. (WALES)MCMULLENnull3-04-1988613048.0100047011nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501A.W.P. (WILCOX)MCMULLENnull9-27-1987665838.610001799nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501A.W.P. (WILCOX 6200)MCMULLENnull11-16-2002619234.0400054765nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACEITUNA (HARPER SD.)DIMMITnull2-05-1958403249.0000011390nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACEITUNA (OLMOS)DIMMITnull7-29-1957420537.00000120231nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACLETO CREEK (POTH SAND)WILSONnull3-16-1952306854.0545700312425nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACLETO CREEK (POTH A)WILSONnull4-01-1981283848.0362268730943141nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACLETO CREEK (POTH B)WILSONnull4-01-1981288135.0311921570443444nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ACLETO CREEK (POTH C)WILSONnull4-01-1981291540.217128740215925nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ADAMS (BUDA)MEDINAnull8-20-1976182228.0494849170512804nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ADAMS (NAVARRO, UPPER)MEDINAnull4-02-195838222.054437065238nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ADDISON (NAVARRO)BASTROPnull3-16-1956447443.00000161nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ALAMO, S. (OLMOS-BOOTH)MCMULLENnull1-31-1984976856.800001329nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ALDERMAN (AUSTIN)GUADALUPEnull2-13-1966194923.000001738nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ALLIGATOR SLOUGH (BRACERO)ZAVALAnull6-02-1990358929.000001653nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ALLIGATOR SLOUGH (ELAINE)ZAVALAnull3-16-1980369127.843180533199nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ALTA VISTABEXARnull1915110012.0000075970nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501AMMANN (BUDA)DIMMITM1-30-1977590038.04210980220961nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ANCHORAGEATASCOSAnull1-16-1952229847.0000087573nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ANDERSON RANCH (SAN MIGUEL)ZAVALAnull4-12-197455260.000001688nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ANDY BROWN (BUDA)WILSONnull4-24-1985530519.9000029784nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARBUCKLE (AUSTIN CHALK)BASTROPnull1-01-1979174924.80000306nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARNOLD-WELDON (B-2)MCMULLENnull8-26-1962348127.00000232062nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARNOLD-WELDON (WALES SAND)MCMULLENnull7-02-1963540640.00000190339nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARNOLD-WELDON (WRIGHT)MCMULLENnull7-10-1963588636.00000550331nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARNOLD-WELDON (WRIGHT S SEG)MCMULLENnull8-24-1963593838.00000563217nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ARROYO NEGRO (AUSTIN CHALK)ZAVALAnull12-12-1976658933.000007073TRANSFERED TO PEARSALL (AUSTIN CHALK) 4-1-77nullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ASHERTON (OLMOS 3-A)DIMMITnull8-28-1955332240.00000613nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ASHERTON,E. (OLMOS 4500)DIMMITnull11-03-1981453348.400001727nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ASHERTON, E. (OLMOS 4600)DIMMITnull10-11-1972460136.6000060326nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501ATLEE (OLMOS)LA SALLEnull0000721045.91178640012385nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501AUSTIN PIERCE (AUSTIN CHALK)GONZALESM12-07-19641085643.0611339132265346nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501AUSTIN PIERCE (EDWARDS LIME)GONZALESnull10-04-19781155838.0000062731nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501B B B (OLMOS A)DIMMITnull9-14-1987371437.5100099583nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BBJ (WILCOX 5700)MCMULLENnull11-02-1984578245.00000173443nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BBJ, N. (WILCOX 5700)MCMULLENnull10-05-1985577945.01000158188nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BACKDRAFT (OLMOS)FRIOnull9-18-2008579634.01000457071nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BAILEYVILLEMILAMnull195263022.00000405nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BAKER (2500)MCMULLENnull1-24-2013247420.444125291150186058nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BAKER (GOVT. WELLS, LOWER)MCMULLENnull1-16-1976311424.3000017642nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BANDERA TANK, WEST (2400)ZAVALAnull8-11-1984245122.70000960nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BANDERA TANK, WEST (2500)ZAVALAnull8-11-1984256222.500003771nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BARBARAS PATCH (SAN MIGUEL)MAVERICKnull7-01-1964104935.000003642FIELD NAME CHG. FROM LAWLESS-BENSON(SAN MIGUEL) 10/1/74nullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BARNES (CHALK)BEXARnull1-05-1983177022.00000687nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BARRETT (WILCOX)MILAMnull10-04-1982289826.50000781nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BASTROP (AUSTIN CHALK)BASTROPnull1-26-1957249628.000004236nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATEMANBASTROPnull9-04-1932220036.0421860774203nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATEMAN (AUSTIN CHALK)BASTROPM4-03-1963223437.07438100001078857nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE (BRACERO)ZAVALAnull9-01-1971313223.40000106524nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE, SOUTH (ANACACHO)ZAVALAnull2-02-1981499721.02217500269153nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE, SOUTH (SAN MIGUEL)ZAVALAnull12-08-1959440028.02000326227nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE,SOUTH(SAN MIGUEL,SEGAZAVALAnull2-25-1981439030.2113500222850nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE, SW. (SAN MIGUEL)ZAVALAnull4-04-1976336027.00000162208nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BATESVILLE, SW. (SAN MIGUEL, LO)ZAVALAnull1-30-1978330331.4000024501nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BEAR CREEKMEDINAM9-01-1947220939.012824202752037SLEEPY CREEK (NAVARRO) TRANSFERRED INTO THIS FIELD 1/1/63.nullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BEAR SALT (OLMOS)ZAVALAnull8-02-1982268413.900001nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BEBE (AUSTIN CHALK)GONZALESnull6-02-1977624430.022642059815nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BEE CREEKCALDWELLM1932209539.00000391565CONSOLIDATED INTO DALE-MCBRIDE FIELD EFF. 7/1/70.nullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BELMONT (POTH)GONZALESnull4-20-1968188321.000008477nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BENNER (NAVARRO)CALDWELLnull2-23-196979424.000000nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BENTON CITY (ANACACHO)ATASCOSAnull0000185323.21000352nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BENTON CITY S, (ANACACHO)ATASCOSAM12-28-1980204923.2441356035943nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BEYERSVILLE, SW.WILLIAMSONnull6-12-1949111538.0000028241nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG FOOTFRIOM2-02-1949328044.04393841164635403396nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG FOOT (AUSTIN CHALK)ATASCOSAnull11-22-1976512634.00000755nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG FOOT (GEORGETOWN)FRIOnull7-19-2019402833.00000112nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG FOOT (OLMOS D-3 SAND)FRIOM6-17-1953350439.0464117602292990nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG MULE (OLMOS 8850)MCMULLENnull0000886642.9000011967PER DOCKET 01-0286066 BIG MULE (OLMOS 8850) CONSOLIDATEDINTO A.W.P.(OLMOS)FIELD. EFFECTIVE 03/25/14nullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG MULE (WILCOX 5100)MCMULLENnull11-23-1981510243.20000104560nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG MULE (WILCOX 5600)MCMULLENnull8-31-1983562443.000004857nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG MULE (5500 SAND)MCMULLENnull1-24-1983555645.0100001213060nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG SANDY CREEK (DALE)BASTROPnull6-10-1985271628.600001481nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS (AUSTIN CHALK)DIMMITnull12-09-1976695033.0000037881TRANSFERED TO PEARSALL (AUSTIN CHALK) 4-1-77BIG WELLS, NE. (SAN MIGUEL) COMBINED WITH THIS FIELD.nullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS (OLMOS SAND)DIMMITnull8-21-1958424934.0000029403nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS (SAN MIGUEL)DIMMITM4-18-1970542533.4914724170059973188nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS(SAN MIGUEL, LO., EAST)DIMMITnull3-26-1971575432.02128406738954nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS, E. (UPPER SAN MIGUEL)DIMMITnull4-15-1987561034.00000531nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS, NE. (OLMOS)ZAVALAM6-17-1970470833.01000824nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BIG WELLS, NE. (SAN MIGUEL)ZAVALAM4-18-1969543535.800001340307COMBINED WITH BIG WELLS /SAN MIGUEL/ 11-1-71.nullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BILL RICHARDSON (ESCONDIDO)ATASCOSAnull9-03-1985462038.500004189nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BILL RICHARDSON (NAVARRO SD.)ATASCOSAnull2-20-1954542438.0000078982nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BILLY HOLLANDEDWARDSnull12-13-194854020.000000nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACK HILLS (ANACACHO)ATASCOSAnull7-29-1975622026.00000575nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACK HILLS (AUSTIN CHALK)ATASCOSAnull4-27-1975638426.000008479nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACK HILLS (BUDA)ATASCOSAM12-20-1976708232.0000074252nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACK HILLS, SOUTH (BUDA)ATASCOSAnull9-01-1977722836.0000015730nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACK ROCK (SAN MIGUEL)MAVERICKnull5-31-1982172034.010004944nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLACKJACK (WILCOX)ATASCOSAnull11-18-1983562441.3000024517nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLAKEWAY (DIXON SAND)DIMMITnull9-14-1979454646.0115193386844nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLAKEWAY (OLMOS A)DIMMITnull1-23-1986449243.33216024858nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLAKEWAY (STRICKLAND SAND)DIMMITnull10-01-1981458050.700005856nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLANCH (OLMOS)DIMMITnull5-30-1959195139.0000073167nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLEDSOE-EROG (BUDA)GONZALESnull8-03-1981730023.600001394nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BLUE TIE AFFAIR (W-15)MCMULLENnull11-01-2005641437.000006676nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BOB HINDES (2100)ATASCOSAnull10-16-1954209919.0000025234nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BOB HINDES (2100 SEG. B)ATASCOSAnull10-08-1962209619.02000126603nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 a.m.
202501BOB ROSECALDWELLnull1940209539.0000048859nullnullnullnullnullnullnullnullnullnullnullSept. 14, 2026, 1:29 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
33.9K
Distinct
13
  • 04 5.8K
  • 03 4.8K
  • 7B 4.8K
  • 09 3.9K
  • 02 3.3K
  • 08 3.1K
  • 7C 2.5K
  • 8A 1.9K
  • 06 1.5K
  • 01 1.4K
  • 10 741
  • 05 367

report_year

varchar

Sampled
33.9K
Distinct
1
  • 2025 33.9K

field_name

varchar

Sampled
33.9K
Distinct
33.9K
  • WILDCAT-COMMISSION USE ONLY 21
  • DISTRICT TOTAL 13
  • WILDCAT 12
  • BRIDGES 2
  • DAY 2
  • MARSTON RANCH (ELLENBURGER) 2
  • PONLAW (SOMA) 2
  • KING 2
  • SHEPHERD-WOOD (MORRIS) 2
  • BUFFALO CAMP, N (FRIO 10,300-B) 2
  • GREEN LAKE 2
  • WEST 2

county_name

varchar

Sampled
33.9K
Distinct
222
Empty
0.0004
  • NUECES 1.1K
  • JACKSON 712
  • RUNNELS 709
  • STARR 699
  • SAN PATRICIO 664
  • KLEBERG 634
  • YOUNG 633
  • JACK 580
  • DUVAL 578
  • VICTORIA 537
  • REFUGIO 535
  • CHAMBERS 515

multi_county_flag

varchar

Sampled
33.9K
Distinct
1
Empty
0.913
  • M 3K

discovery_date

varchar

Sampled
33.9K
Distinct
15.5K
Empty
0.0004
  • 0000 802
  • 1950 101
  • 1951 76
  • 1949 71
  • 1953 70
  • 1948 65
  • 1952 64
  • 1936 55
  • 1955 52
  • 1941 47
  • 1939 45
  • 1940 42

depth_ft

varchar

Sampled
33.9K
Distinct
9.7K
Empty
0.0004
  • N/A 64
  • 5500 32
  • 4300 31
  • 5400 31
  • 4800 29
  • 4400 28
  • 5900 27
  • 4600 26
  • 5800 26
  • 4000 25
  • 4500 25
  • 3200 24

oil_gravity

varchar

Sampled
33.9K
Distinct
517
Empty
0.0004
  • 40.0 2.3K
  • 42.0 2.1K
  • 41.0 1.8K
  • 43.0 1.2K
  • 38.0 1.2K
  • 39.0 1.1K
  • 44.0 867
  • 36.0 760
  • 45.0 750
  • 37.0 694
  • 46.0 630
  • 35.0 532

Take it away

Back to everything we know about Oil Annual Report Field Table