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 district lookup: internal district number, the designation the Commission prints, the office phone and the office location.

This table is why EZRRC keeps two district code sets. …

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 5 columns and about 14 rows.

The columns you will most likely want:

  • 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.
  • office_phone_no District office phone number.
  • office_location City the district office is in.
  • ingested_at When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, …

What we add

Translate between the internal district number and the printed designation, which is the difference between District 8A and District 11 meaning the same thing.

  • 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

Internal 07 is District 6E, 08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is 09 and 14 is District 10. There is no internal 12. Number 20 is the statewide bucket.

The full page lists every trap in this dataset.

Get it

People who want this usually want