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.

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
  • oil_extract_date
  • ingested_at When the upstream pipeline last wrote this row.

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

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: