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.

Seventeen million rows breaking each lease-month's volume out by disposition code: sold to a purchaser, run to a pipeline, used as lease fuel, vented or flared, injected, put …

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 240K 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.
  • 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 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 you use it

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.

A lease number …

The full page lists every trap in this dataset.

Get it

People who want this usually want