EZRRC
Cart Sign in

PDQ County Production by Cycle

County-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, allowable, ending balance and total disposition rolled up to the county and month.

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 25 columns and about 146.2K rows.

The columns you will most likely want:

  • county_no County FIPS code within Texas, zero-padded to three digits.
  • district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the …
  • 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.
  • cnty_oil_prod_vol The amount of oil in BBL produced by county as reported by the operator on a production report. …

…and 19 more, all documented on the full page.

What we add

Chart county production without aggregating 64 million lease rows yourself.

  • 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.
  • The Commission's single-letter codes translated into words.

Worth knowing before you use it

Upstream has loaded only a token slice of this table so far, so the row count is far short of what RRC publishes. The lease and county-lease tables are complete; roll those up if you need full coverage.

A lease number is only unique with the oil/gas code and the district in it. Oil lease …

The full page lists every trap in this dataset.

Get it

People who want this usually want