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

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. Oil lease 027587 in District 08 and gas lease 027587 in District 08 are different leases; so is oil lease 027587 …

The full page lists every trap in this dataset.

Get it

People who want this usually want