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.
It overlaps the P-5 organization file but is cut from 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 15 columns and about 78.2K rows.
The columns you will most likely want:
-
operator_noThe operator's six-digit RRC P-5 organization number. Join to the P-5 Organization dataset for the company's name, address … -
operator_nameOperator name as carried in this file. Names drift between filings — join on the operator number, never … -
p5_status_codeIndicates the status of the organization. -
p5_last_filed_dtThe date of the last P-5 filed. -
operator_tax_cert_flagIndicates whether the tax certificate for the operator has been received from the comptroller. -
operator_sb639_flagIndicates the SB639 status of the Operator.
…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 you use it
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.