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.

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

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: