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 60 columns and about 1.2M rows.
The columns you will most likely want:
-
district -
county_code -
api_no -
county_name -
oil_gas_code -
lease_name
…and 54 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 you use it
Upstream has created the table but has not loaded it, so EZRRC serves no rows for it yet. When the load runs it will become queryable with no change here.
Being a denormalisation, it is a point-in-time snapshot: the operator name on a row is the operator today, not the operator when the well was …
The full page lists every trap in this dataset.