PDQ Operator Production by Cycle
Operator-level monthly production totals.
What this is
One of the sixteen delimited tables inside the monthly Production Data Query dump. RRC publishes the dump as a single archive; EZRRC publishes each table inside it separately so you can take the one you need instead of a 3.6 GB zip.
Production summed to the P-5 operator and month: 3.4 million rows of who produced what.
How it is laid out
The Railroad Commission publishes this as CSV. Comma-separated text. We decode it into a table you can open anywhere. It has 10 columns and about 3.7M rows.
The columns you will most likely want:
-
operator_noThe operator's six-digit RRC P-5 organization number. Join to the P-5 Organization dataset for the company's name, address … -
cycle_yearProduction cycle year, four digits. -
cycle_monthProduction cycle month, two digits. -
cycle_year_monthProduction cycle as YYYYMM. This is the column to filter a date range on. -
operator_nameOperator name as carried in this file. Names drift between filings — join on the operator number, never … -
oper_oil_prod_volThe amount of oil in BBL produced by operator as reported by the operator on a production report.
…and 4 more, all documented on the full page.
What we add
Rank Texas operators by monthly oil or gas production, watch an operator's output through an acquisition, and size a company against its peers.
- 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
The operator is whoever reported the production that month. An acquisition shows up as one operator's volume stopping and another's starting, with no link between them.
A lease number is only unique with the oil/gas code and the district in it. Oil lease 027587 in District 08 and gas lease 027587 in District 08 are …
The full page lists every trap in this dataset.