PDQ Lease Summary (master) — 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. 1.1 million leases with the earliest and latest production cycle recorded for each. It is the index you want before touching the 76 million row cycle table.

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 12 columns and about 1.1M rows.

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.
operator_no The operator's six-digit RRC P-5 organization number.
field_no The eight-digit RRC field number.
cycle_year_month_min

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

What we add:

Find leases that started producing in a given month, leases that have stopped, and the productive life of any lease — without scanning the full production history.

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:

The min and max cycles are stored as integers in YYYYMM form, so 202601 is January 2026 and arithmetic on them is not date arithmetic. 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 Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
Statewide Production Data — Oil The live P-1 world: every oil lease's allowable, production, dispositions and remarks, 26 months deep.
Statewide Production Data — Gas The live P-2 world: every gas well's allowable, production, dispositions and flaring remarks, 26 months deep.
Oil Ledger — Leases Every oil lease on the proration schedule, with its gatherers and its balances.
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.