PDQ Regulatory Lease Directory

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. This is the table that makes production data legible: it maps the oil/gas code, district and lease number key to the lease name, the operating company, …

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 548K 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. This is not the district name the …
• lease_no RRC lease number. Unique only within a district and a schedule, so a lease key is district + …
• 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. Join to the P-5 Organization dataset for the company's name, address …

…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.

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.
• High Cost Gas Every lease certified as high-cost gas for severance tax relief.
• PDQ Well Completion Directory The wells that make up each lease, with API numbers and shut-in status.
• PDQ Lease Disposition by Cycle Where each lease's production actually went, month by month, by disposition code.
• PDQ Onshore Lease Summary The onshore subset of the lease summary.
• Production Data Query Dump The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.