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_no The operator's six-digit RRC P-5 organization number.
  • cycle_year Production cycle year, four digits.
  • cycle_month Production cycle month, two digits.
  • cycle_year_month Production cycle as YYYYMM. This is the column to filter a date range on.
  • operator_name Operator name as carried in this file.
  • oper_oil_prod_vol

…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 use:

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.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: