PDQ Lease Production by Cycle — what it is, in short

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.

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 33 columns .

The columns you will most likely want:

oil_gas_code Whether the lease is carried on the oil schedule or the gas schedule.
district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide.
lease_no RRC lease number.
cycle_year Production cycle year, four digits.
cycle_month Production cycle month, two digits.
cycle_year_month Production cycle as YYYYMM. This is the column to filter a date range on.

…and 27 more, all documented on the full page.

What we add:

Build a monthly production history for any lease, operator, field or district back to 1993. Rank operators by production, measure decline curves at lease level, and compare produced volume against the allowable the Commission set.

There is more on the full page, including what this joins to.

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.
The Commission's single-letter codes translated into words.

Worth knowing before use:

76 million rows and about 31 GB. Filter before you export — a county, an operator, a field or a date range all cut it to something workable. A lease number is only unique with the oil/gas code and the district in it.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

PDQ Regulatory Lease Directory The lease directory: lease number to lease name, operator, field and well number.
PDQ Lease Disposition by Cycle Where each lease's production actually went, month by month, by disposition code.
Historical Ledger — Statewide Gas Every Texas gas well's month back to January 1993 — allowable, production, balances and dispositions. 105.9 million rows.
Historical Ledger — Statewide Oil Every Texas oil lease's month back to January 1993 — allowable, production, movable balance and dispositions. 60.4 million rows.
Statewide Production Data — Gas The live P-2 world: every gas well's allowable, production, dispositions and flaring remarks, 26 months deep.
Statewide Production Data — Oil The live P-1 world: every oil lease's allowable, production, dispositions and remarks, 26 months deep.