PDQ Lease Production by Cycle

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.

This is the big one: 76 million rows, one per lease per month, carrying production volume, allowable and ending balance for oil, gas, condensate and casinghead gas, plus …

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 and about 37.4M 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 + …
• 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.

Join to the regulatory lease directory for the well count …

• 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 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.
• PDQ Operator Directory The operator number to operator name lookup used by the production data.
• PDQ Field Directory The field number to field name lookup, with class, discovery date and rules flags.
• PDQ County Lease Production by Cycle Lease production split by county, for leases that cross a county line.
• P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.