Wellbore Query Data
The fifty-nine column extract behind the Commission's own public wellbore query.
What this is:
The EWA subscription file: a wide, comma-delimited denormalisation of the wellbore, operator, lease and permit data that powers RRC's online well search. It is convenient precisely because it is pre-joined — operator name, field name, lease name, plugging and 14(b)(2) status all sit on one row.
How it is laid out:
The Railroad Commission publishes this as Delimited text. Separated text, usually with an unusual delimiter such as a brace. We decode it into a table you can open anywhere. It has 120 columns and about 1.3M rows.
The columns you will most likely want:
-
districtRRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10). -
county_codeCounty code as this file carries it. -
api_no -
county_name -
oil_gas_code -
lease_name
…and 114 more, all documented on the full page.
What we add:
Get a wide, human-readable well list without doing the joins yourself, including the 14(b)(2) extension detail that is not published anywhere else.
- Decoded out of the Commission's original format into something Excel opens.
- Filterable before you download, so you can take one county instead of the whole state.
Worth knowing before use:
What is loaded and archived here is the undated OG_WELLBORE_EWA_Report.csv from RRC's folder, which the Commission wrote in December 2020 and has not touched since: the newest plug date in the table is 2020-11-10.
The full page lists every trap in this dataset.