EZRRC
Cart Sign in

PDQ Lease Disposition by Cycle

Where each lease's production actually went, month by month, by disposition code.

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 53 columns and about 48.6M 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.
  • cycle_year Production cycle year, four digits.
  • cycle_month Production cycle month, two digits.
  • operator_no The operator's six-digit RRC P-5 organization number.

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

What we add:

Measure flaring and venting by lease, operator, field or district — the disposition codes are the only public source for that. Reconcile produced volume against disposed volume, and see how much gas is used as lease fuel rather than sold.

  • 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:

Each disposition code is its own column, not a row — the table is very wide rather than long. Oil, gas, condensate and casinghead gas each have their own set. Disposition should sum to production plus opening balance minus closing balance, and does not always. Discrepancies are real filings, not parsing errors.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: