Oil and Gas Docket Subjects
What each docket was actually about, in the Commission's own words.
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_numberThe docket this subject text belongs to. Join to the docket master on it. -
line_noLine number within the docket's subject text. Order by it to rebuild the paragraph. -
subject_textOne 50-character line of the docket's subject description. -
subject_flagsTwo bytes of subject flags. -
ingested_atWhen 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.