P-5 Organization (EBCDIC)
Queryable EBCDIC
The operator directory in the Commission's original mainframe encoding.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
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.
What you can do with it
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 whose P-5 has lapsed, count operators by organisation type, and map the industry by mailing address.
Combine with the production data to rank companies, or with the permit data to see who is drilling.
Gotchas
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 register, not a list of operating companies.
The operator number is the join key, not the name. Names change, get re-registered and are reused; the number does not.
An organization being on file does not mean it operates wells. Purchasers, transporters and service companies all carry P-5 numbers.
Record layout
13 columns. Byte positions are 1-based and come from the RRC record layout, so you can check our decoding against the original file yourself.
operators
13 columns
| # | Column | Type | Bytes | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|---|
| 1 |
id
key
join
|
integer | 3-8 | OROR-ORG-OPERATOR-NUMBER |
The RRC P-5 operator number. This is the join key that turns an anonymous permit, lease or completion into a named company. e.g. 166150 | — |
| 2 |
name
|
text | 9-40 | OROR-ORG-ORGANIZATION-NAME |
Organization name exactly as filed on Form P-5, 32 characters. | — |
| 3 |
p5_status
|
char | 42 | OROR-P-5-STATUS |
Whether the organization's P-5 is active, inactive, delinquent or annotated. e.g. A | P-5 organization status |
| 4 |
org_type
|
char | 45 | OROR-ORGANIZATION-CODE |
Legal form of the organization: corporation, partnership, trust and so on. e.g. A | Organization type |
| 5 |
address1
|
text | 71-101 | OROR-ORG-ADDR-LINE1 |
First line of the P-5 master mailing address. | — |
| 6 |
address2
|
text | 102-132 | OROR-ORG-ADDR-LINE2 |
Second line of the P-5 master mailing address. | — |
| 7 |
city
|
text | 133-145 | OROR-ORG-ADDR-CITY |
City of the P-5 master mailing address. | — |
| 8 |
state
|
char | 146-147 | OROR-ORG-ADDR-STATE |
State of the P-5 master mailing address. | — |
| 9 |
zip
|
text | 148-152 | OROR-ORG-ADDR-ZIP |
ZIP code, with the four-digit suffix appended when RRC supplies one. | — |
| 10 |
phone
|
text | 259-268 | — | Contact phone number from the P-5. Null when RRC carries all zeros. | — |
| 11 |
date_built
|
date | 243-250 | — | Date the organization record was created, CCYYMMDD. | — |
| 12 |
date_inactive
|
date | 251-258 | — | Date the organization went inactive. Null while it is active. | — |
| 13 |
ingested_at
|
timestamptz | — | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
Code lookups used here
Every coded column in this dataset resolves to a real lookup table, so
a well code of G can be read as what it actually means.
Organization type 7 values
Read by org_type
The legal form the operator filed under. Codes 'H' and 'I' also appear in the warehouse but are not among the seven 88-level values ORA001 documents, so they are left unlabelled rather than guessed.
| Code | Means |
|---|---|
A |
Corporation |
B |
Limited partnership |
C |
Sole proprietor |
D |
Partnership |
E |
Trust |
F |
Joint venture |
G |
Other See the organization comment field for the description. |
Source: RRC manual ORA001, COBOL 88-level values on OROR-ORGANIZATION-CODE
P-5 organization status 4 values
Read by p5_status
Whether an operator's Form P-5 organization report is current. An operator has to hold an active P-5 to be the operator of record on anything. The warehouse also contains 'H', 'R' and 'X' in this column. Those are not among the four 88-level values ORA001 documents for OROR-P-5-STATUS, so EZRRC does not guess at labels for them.
| Code | Means |
|---|---|
A |
Active The P-5 is current. |
I |
Inactive The organization is inactive. |
D |
Delinquent The P-5 was not refiled by the notice month. |
S |
See remarks Not required to file; see remarks. |
Source: RRC manual ORA001, COBOL 88-level values on OROR-P-5-STATUS
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- EBCDIC IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first.
- Update cadence
- Updated once a month (Monthly. Available by the 25th.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.operators
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.