EZRRC
Cart Sign in

PDQ Onshore Lease Summary

The onshore subset of the lease summary.

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. The same first/last production cycle summary as the master, restricted to onshore leases — 1.1 million of them.

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 11 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.
  • lease_no RRC lease number.
  • operator_no The operator's six-digit RRC P-5 organization number.
  • field_no The eight-digit RRC field number.
  • cycle_year_month_min

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

What we add:

Work with onshore leases only, without having to filter offshore records out by hand.

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

Offshore leases are simply absent rather than flagged, so a lease missing from this table is not an error. A lease number is only unique with the oil/gas code and the district in it.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: