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_number The docket these parties belong to. Join to the docket master on it.
  • name A party to the docket — applicant, operator, protestant or representative. One docket has several.
  • row_no Sequence number of this row within its parent record. Part of the key.
  • ingested_at When 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.

Get it:

People who want this usually want: