EZRRC
Cart Sign in

PDQ County Lease Production by Cycle

Lease production split by county, for leases that cross a county line.

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. 64 million rows.

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 34 columns and about 76.8M 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.
  • county_no County FIPS code within Texas, zero-padded to three digits.

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

What we add:

Produce county-level production totals that are actually correct for multi-county leases, which a naive lease-to-county join gets wrong. Compare county production over time without double counting.

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

Summing this table by lease double counts a multi-county lease. Use the lease cycle table for lease totals and this one for county totals. 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: