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.

A single row: the oldest production cycle, the newest production cycle, the newest schedule cycle, and the dates the gas and oil extracts were taken.

It is the …

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 6 columns and about 1 rows.

The columns you will most likely want:

  • oldest_prod_cycle_year_month Oldest production cycle present in this PDQ release, YYYYMM.
  • newest_prod_cycle_year_month Newest production cycle present in this PDQ release, YYYYMM.
  • newest_sched_cycle_year_month Newest schedule cycle present in this PDQ release, YYYYMM.
  • gas_extract_date The current date the gas data is extracted from the database.
  • oil_extract_date The current date the oil data is extracted from the database.
  • ingested_at When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, …

What we add

Check what period a PDQ release actually covers before trusting a 'latest month' figure derived from it.

  • 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 newest production cycle is typically two to three months behind today. Texas production data is never current — operators have filing deadlines and amend for months afterwards.

The full page lists every trap in this dataset.

Get it

People who want this usually want