Oil and Gas Docket Parties
The organizations and people named in each docket.
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.
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 4 columns and about 223.4K rows.
The columns you will most likely want:
-
docket_numberThe docket these parties belong to. Join to the docket master on it. -
nameA party to the docket — applicant, operator, protestant or representative. One docket has several. -
row_noSequence number of this row within its parent record. Part of the key. -
ingested_atWhen the upstream pipeline last wrote this row.
What we add:
Find every docket a named operator appears in, and identify the protestants in a contested case.
- 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 use:
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.
The full page lists every trap in this dataset.