PDQ Cycle Date Range
Queryable CSV
One row saying which production cycles this PDQ release covers.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
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 release's own statement of what it contains.
What you can do with it
Check what period a PDQ release actually covers before trusting a 'latest month' figure derived from it.
Gotchas
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.
Record layout
6 columns.
pdq_gp_date_range_cycle
6 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
oldest_prod_cycle_year_month
|
text | — | Oldest production cycle present in this PDQ release, YYYYMM. | — |
| 2 |
newest_prod_cycle_year_month
|
text | — | Newest production cycle present in this PDQ release, YYYYMM. | — |
| 3 |
newest_sched_cycle_year_month
|
text | — | Newest schedule cycle present in this PDQ release, YYYYMM. | — |
| 4 |
gas_extract_date
|
date | — | The current date the gas data is extracted from the database. | — |
| 5 |
oil_extract_date
|
date | — | The current date the oil data is extracted from the database. | — |
| 6 |
ingested_at
|
timestamptz | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- CSV Comma-separated text.
- Update cadence
- Updated once a month (Last Saturday each month, with the PDQ dump.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.pdq_gp_date_range_cycle
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.