EZRRC
Cart Sign in

Production Data Query Dump

Original only CSV

The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.

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

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 you actually want.

What you can do with it

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.

Gotchas

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 here is RRC's INTERNAL district numbering (01-14, 20), not the designation the industry prints. Internal 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is 09 and 14 is District 10. The district directory is the lookup; reading the number as a label is wrong.

Volumes are whole numbers in the reporting unit — barrels for liquids, MCF for gas. There are no implied decimals here, unlike the EBCDIC ledgers.

Cycle year and cycle month are separate columns; cycle_year_month is the two of them concatenated as YYYYMM and is the cheapest thing to range on.

Production is reported by lease, not by well. A lease can be one well or two hundred.

Record layout

0 columns.

We have not transcribed the record layout for this dataset yet. The RRC manual linked under “Where this comes from” is the authoritative description in the meantime.

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.)
RRC download link
GoAnywhere MFT
Record layout manual

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.

Written about this dataset

  • Start here — what the Texas RRC actually publishes The Railroad Commission gives away roughly sixty oil and gas datasets. This is the map: which files exist, what each one is really about, and how they hang together once you know the join keys. 6 min
  • Leases, fields and wells — the unit of account problem A lease is not a well, a field is not a formation, and Texas counts oil and gas in two different currencies. Get this wrong and every production number you compute will be wrong. 6 min
  • Understanding API numbers The API well number is the closest thing Texas has to a primary key for a hole in the ground. Here is how it is built, why the RRC stores only part of it, and why the same well legitimately appears under several different numbers. 5 min
  • RRC districts and counties Districts are the RRC's administrative geography, they are not numeric, they do not nest cleanly inside anything you already have, and half the datasets are partitioned by them. Here is how to handle both districts and counties. 5 min
  • Operators and P-5 numbers Every company that touches a Texas well has a six-digit P-5 number. The number is stable and the name is not. Here is what the P-5 Organization file contains, and how to use it as the operator dimension for everything else. 6 min
  • Production data explained — PDQ, cycles and reporting lag The Production Data Query dump is sixteen tables and tens of millions of rows of monthly Texas production back to 1993. This is what a cycle is, how the lease and county-lease tables differ, and why the last two months always lie. 6 min
  • Joining RRC datasets — the practical recipes Nine joins that connect the RRC's separate files into one dataset, with the cardinality of each, the type and padding traps that break them, and worked SQL you can run. 6 min
  • Using the EZRRC API and Python SDK Query any RRC dataset over HTTP, resolve code values, request an export in any format, and assemble a cross-dataset view of a single well — with curl, with the Python SDK, and from an MCP-capable assistant. 5 min

Also in Production Data