EZRRC
Cart Sign in

P-5 Organization (EBCDIC)

The operator directory in the Commission's original mainframe encoding.

What this is

The same ORA001 records as the ASCII edition, in EBCDIC cp037 — 350 byte records across nine record types, of which the 'A' organization records are the ones EZRRC loads.

This is the file the upstream pipeline actually downloads and decodes, and the one whose pristine original is archived, so it is the edition you can download byte-for-byte as RRC published it.

How it is laid out

The Railroad Commission publishes this as EBCDIC (IBM cp037). IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first. 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

Take the Commission's original file unmodified, or query the decoded rows — both work from this page.

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 …

  • 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 original file is EBCDIC and will look like noise in a text editor. The decoded rows EZRRC serves are the same records.

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 …

The full page lists every trap in this dataset.

Get it

People who want this usually want