Production Data Query Dump
The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
What this is
RRC's modern production release. One monthly archive containing sixteen delimited tables covering production at lease, field, operator, county and district grain, the disposition codes that say where the product went, and the directories that decode the keys.
This dataset is the archive as RRC publishes it — the pristine original, 3.6 GB compressed. The sixteen tables inside it are also published individually and are queryable, which is almost always what …
How it is laid out
The Railroad Commission publishes this as CSV. Comma-separated text. We mirror the Commission's file exactly as they published it, byte for byte. We have not decoded this one into a table yet, so reading it needs the right tooling.
What we add
Take the Commission's release exactly as issued, for archival or for loading into your own warehouse.
For anything else, use the individual PDQ tables — they are the same data, filterable, and you will not download 3.6 GB to answer a question about one county.
- Mirrored so the file is here when the Commission's own link is not.
- Documented — what it is, where it came from, and when we last fetched it.
Worth knowing before you use it
It is one very large zip. Extracting it needs about 30 GB of free disk.
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; so is oil lease 027587 in District 09.
district_no …
The full page lists every trap in this dataset.