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. The field number is the join to the field directory, which is the only place the field's name, class and discovery …
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_noRRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the … -
field_noThe eight-digit RRC field number. The field's name is not in most files; join to the field directory … -
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. -
district_nameRRC 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 you use it
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. Oil lease 027587 in District 08 and gas lease 027587 in District 08 are different leases; …
The full page lists every trap in this dataset.