What this is

Free-text remarks recorded against a UIC permit — conditions, correspondence, the reasoning behind a decision.

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 1.3M rows.

The columns you will most likely want:

  • cntl_no The UIC control number this remark belongs to.
  • remark_text One line of free-text permit remark. Order by row number to rebuild it.
  • 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. Not an RRC field — it is EZRRC's provenance stamp, …

What we add

Read the conditions attached to a disposal permit in the Commission's own words.

  • 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

Line-wrapped continuations keyed on the control number and a row number. Order and concatenate to read one.

The full page lists every trap in this dataset.

Get it

People who want this usually want