What this is

The subject records of the docket file: 1.1 million lines of subject text, with the flags the Commission tags them with.

The docket master says when things happened. This says what happened.

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 5 columns and about 1.2M rows.

The columns you will most likely want:

  • docket_number The docket this subject text belongs to. Join to the docket master on it.
  • line_no Line number within the docket's subject text. Order by it to rebuild the paragraph.
  • subject_text One 50-character line of the docket's subject description.
  • subject_flags Two bytes of subject flags.
  • ingested_at When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, …

What we add

Search the docket by subject matter — Rule 37 exceptions, allowable changes, enforcement, field rule amendments.

  • 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 you use it

Subject text is line-wrapped across several rows per docket. Order by the line number and concatenate before reading.

The full page lists every trap in this dataset.

Get it

People who want this usually want