Oil and Gas Docket Parties
Queryable Fixed-width
The organizations and people named in each docket.
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 name records of the docket file: 223,000 rows tying a docket number to the parties involved.
It is the fastest route from a company to its regulatory history.
What you can do with it
Find every docket a named operator appears in, and identify the protestants in a contested case.
Gotchas
Party names are free text as filed and do not carry the operator number. Matching them to the P-5 directory is a name match, and about one in five will not match exactly — punctuation, suffixes and abbreviations all vary.
Record layout
4 columns.
og_docket_name
4 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
docket_number
key
join
|
text | — | The docket these parties belong to. Join to the docket master on it. | — |
| 2 |
name
|
text | — | A party to the docket — applicant, operator, protestant or representative. One docket has several. | — |
| 3 |
row_no
key
|
integer | — | Sequence number of this row within its parent record. Part of the key. | — |
| 4 |
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. | — |
What this joins to
The Railroad Commission never states these keys anywhere in the files. They are the reason the data is hard to use, so here they are with the exact columns on both sides.
Oil and Gas Docket Parties joins to P-5 Organization (ASCII) on Name — rows can match many rows in both directions.
is the organization named
The docket file names parties as free text and does not carry the P-5 number, so this is a name match against the operator directory. 4,079 of 5,000 sampled party names match exactly; the remainder differ by punctuation, a suffix or an abbreviation. Treat a miss as 'not matched', never as 'not an operator'.
oil-and-gas-docket-parties.name = p5-organization-ascii.name
Oil and Gas Docket Parties joins to Oil and Gas Docket on Docket number — many rows here share a single row there.
was brought by and against
The organizations and people named in the case, one row each.
oil-and-gas-docket.docket_number = oil-and-gas-docket-parties.docket_number
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Fixed-width Columns are byte ranges with no separators, described only in a scanned record layout.
- Update cadence
- Updated once a month (Monthly, with the docket file.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.og_docket_name
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.