EZRRC
Cart Sign in

PDQ Field Production by Cycle

Field-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 field 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 12 columns and about 10.2M rows.

The columns you will most likely want:

  • district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide.
  • field_no The eight-digit RRC field 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.
  • district_name RRC district as the industry writes it, e.g. 7B, 8A, 6E.

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

What we add:

Rank fields by production, track a play's output month by month, and find when a field peaked.

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

A field number appears under more than one district when the field crosses a district boundary — sum across districts for a field total. 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:

  • PDQ Field Directory The field number to field name lookup, with class, discovery date and rules flags.
  • Field Monthly Statistics (Allowables and Production) Field-level monthly allowables beside the P-1 and P-2 production actually reported. 4.0 million field-months, and no other RRC file has them.
  • Statewide Field Data The mainframe's field master: every oil and gas field in Texas with its rules, its allocation formulas and 10.5 million rows of allowable and production history.
  • PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
  • Production Data Query Dump The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
  • Gas Ledger The gas proration schedule: every gas field in Texas and how its allowable is set.