PDQ Operator Directory
The operator number to operator name lookup used by the production data.
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. 78,000 operators with their P-5 status code, last P-5 filing date, tax certification flag and e-filing status.
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 15 columns and about 78.3K rows.
The columns you will most likely want:
-
operator_noThe operator's six-digit RRC P-5 organization number. -
operator_nameOperator name as carried in this file. -
p5_status_code -
p5_last_filed_dt -
operator_tax_cert_flag -
operator_sb639_flag
…and 9 more, all documented on the full page.
What we add:
Resolve operator numbers to names inside the production data without leaving it, and check whether an operator's P-5 was current.
- 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.
Worth knowing before use:
This is the production system's copy. The P-5 organization dataset is the authoritative operator record and carries the address and organisation type.
The full page lists every trap in this dataset.