PDQ Regulatory Lease Directory — 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. 547,000 leases.

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 13 columns and about 548.5K 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.
district_name RRC district as the industry writes it, e.g. 7B, 8A, 6E.
lease_name Lease name as filed.
operator_no The operator's six-digit RRC P-5 organization number.

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

What we add:

Turn a lease key into a name, a field and an operator. Find every lease an operator holds, and find leases that have been severed — the Commission's enforcement action for delinquent filings.

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 severance flag means the lease has been severed for a compliance failure and cannot legally sell product. It is one of the most consequential columns in the catalog and it is a single character. 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:

Certificate of Authorization P-4 (Oil and Gas) Who gathers, buys and nominates each Texas lease's oil and gas, and every P-4 behind it.
PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
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.