Oil and Gas Docket Subjects

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.

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.

People who want this usually want:

• Oil and Gas Docket Contested cases, rulemakings and hearings before the Commission.
• P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
• Certificate of Authorization P-4 (Oil and Gas) Who gathers, buys and nominates each Texas lease's oil and gas, and every P-4 behind it.
• Oil and Gas Docket Parties The organizations and people named in each docket.
• P-5 Organization (EBCDIC) The operator directory in the Commission's original mainframe encoding.
• R-3 Gas Processing Plants (EBCDIC, retired) Every gas plant Texas has known since 1912, and the last two years of R-3 forms. Frozen 2025-08-25.