EZRRC
Cart Sign in

PDQ Lease Summary (master)

One row per lease with the first and last production cycle it ever reported.

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.

1.1 million leases with the earliest and latest production cycle recorded for each. It is the index you want before touching the 76 million row cycle table.

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 12 columns and about 1.1M 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 + …
  • 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 …
  • field_no The eight-digit RRC field number. The field's name is not in most files; join to the field directory …
  • cycle_year_month_min This represents the minimum production month and year in YYYYMM format for which data is available.

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

What we add

Find leases that started producing in a given month, leases that have stopped, and the productive life of any lease — without scanning the full production history.

  • 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

The min and max cycles are stored as integers in YYYYMM form, so 202601 is January 2026 and arithmetic on them is not date arithmetic.

A lease number is only unique with the oil/gas code and the district in it. Oil lease 027587 in District 08 and gas lease 027587 in District 08 are different …

The full page lists every trap in this dataset.

Get it

People who want this usually want