Oil and Gas Docket Subjects
Queryable Fixed-width
What each docket was actually about, in the Commission's own words.
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 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.
What you can do with it
Search the docket by subject matter — Rule 37 exceptions, allowable changes, enforcement, field rule amendments.
Gotchas
Subject text is line-wrapped across several rows per docket. Order by the line number and concatenate before reading.
Record layout
5 columns.
og_docket_subject
5 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
docket_number
key
join
|
text | — | The docket this subject text belongs to. Join to the docket master on it. | — |
| 2 |
line_no
key
|
text | — | Line number within the docket's subject text. Order by it to rebuild the paragraph. | — |
| 3 |
subject_text
|
text | — | One 50-character line of the docket's subject description. | — |
| 4 |
subject_flags
|
text | — | Two bytes of subject flags. | — |
| 5 |
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 Subjects joins to Oil and Gas Docket on Docket number — many rows here share a single row there.
was about
The subject text of the case, line-wrapped across several rows. The master record says when things happened; this says what happened.
oil-and-gas-docket.docket_number = oil-and-gas-docket-subjects.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_subject
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.