EZRRC
Cart Sign in

PDQ County Directory

County code, FIPS code, name and the district each county belongs to.

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.

277 rows: the three-digit RRC county code, the county's FIPS code, the name, the district it sits in and the onshore flag.

EZRRC also publishes this as the …

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 8 columns and about 277 rows.

The columns you will most likely want:

  • county_no County FIPS code within Texas, zero-padded to three digits.
  • county_fips_code The county's FIPS code — the join to any Census or TIGER dataset.
  • county_name County name.
  • district_no RRC's INTERNAL district number, 01 to 14 plus 20 for statewide. This is not the district name the …
  • district_name RRC district as the industry writes it, e.g. 7B, 8A, 6E.
  • on_shore_flag Y when the county is onshore.

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

What we add

Decode county codes, and join Texas oil and gas data to Census or TIGER geography through the FIPS code.

  • 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

There are 254 Texas counties but 277 rows — the extra codes are offshore areas and administrative entries.

The county code and the county FIPS code are the same three digits. The full five-digit FIPS needs the state prefix 48.

The full page lists every trap in this dataset.

Get it

People who want this usually want