What this is

ORA001. The operator directory — 71,796 organizations with their P-5 number, organization name, P-5 status, organization type, mailing address, phone, the date the organization was created and the date it went inactive.

That six-digit operator number is the join key that turns an anonymous permit, lease or completion into a company with a name and an address.

How it is laid out

The Railroad Commission publishes this as Fixed-width ASCII. Columns are byte ranges with no separators, described only in a scanned record layout. We decode it into a table you can open anywhere. It has 13 columns and about 78.2K rows.

The columns you will most likely want:

  • id The RRC P-5 operator number. This is the join key that turns an anonymous permit, lease or completion …
  • name Organization name exactly as filed on Form P-5, 32 characters.
  • p5_status Whether the organization's P-5 is active, inactive, delinquent or annotated.
  • org_type Legal form of the organization: corporation, partnership, trust and so on.
  • address1 First line of the P-5 master mailing address.
  • address2 Second line of the P-5 master mailing address.

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

What we add

Turn an operator number into a company, an address and a regulatory status — the join that makes every other dataset in the catalog readable.

Find every organization whose P-5 has lapsed, count operators by organisation type, and map the industry by mailing address.

Combine …

  • 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

The P-5 status is a single letter and it matters: A is active, I inactive, D delinquent. Most of the 71,796 organizations on file are inactive — the file is a historical register, not a list of operating companies.

The operator number is the join key, not the name. Names change, get re-registered and are …

The full page lists every trap in this dataset.

Get it

People who want this usually want