Full Wellbore Database (ASCII)
Every well ever assigned an API number in Texas, with casing, tubing, perforations, formations, plugging and inactive-well tests.
- Rows
- 1.2M
- Size
- 297.8 MB
- Updates
- Weekly
- Last seen
- 1 Aug 2026
The Railroad Commission publishes these as EBCDIC, fixed-width ASCII, dBase and shapefiles, described only in scanned COBOL manuals. Here they are with the record layouts, code lookups and join keys spelled out — and exports in formats a spreadsheet can open.
Every well ever assigned an API number in Texas, with casing, tubing, perforations, formations, plugging and inactive-well tests.
Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
Every casing string set in every Texas well: size, depth, hole size and cement.
The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
Patent survey lines and tracts as shapefiles.
County code, FIPS code, name and the district each county belongs to.
The complete statewide listing of assigned API numbers.
Lease production split by county, for leases that cross a county line.
Every map layer for a county in one package.
Roads, water features, cities and political boundaries as shapefiles.
Forms G-1 and W-2: the filings that turn a drilled hole into a producing well.
Every lease certified as high-cost gas for severance tax relief.
Multi-well detail records carrying W-10 test data.
The eight-digit field number to field name lookup.
One row saying which production cycles this PDQ release covers.
Operator-level monthly production totals.
Abandoned, liquid and gas pipeline routes as shapefiles.
Monthly gas processing plant reports, in the current JSON release.
The lease and well identifiers each wellbore has been completed under.
Surface and bottomhole well locations as shapefiles, county by county.
County-level monthly production totals.
The field number to field name lookup, with class, discovery date and rules flags.
W-3 plugging reports: when a well was plugged, to what depth, and with what.