PR (P-1/P-2) Gas Disposition (EBCDIC) — what it is, in short

What this is:

The EBCDIC edition of OGA0861 — identical records, original encoding, published for subscribers whose readers expect it.

How it is laid out:

The Railroad Commission publishes this as EBCDIC (IBM cp037). IBM mainframe encoding (cp037). Opening it as text gives you nonsense; it has to be transcoded first. We decode it into a table you can open anywhere. It has 56 columns and about 92.8K rows.

The columns you will most likely want:

district RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10).
gas_well_gas_rrcid
report_year
report_month
balancing_code
discrepancy_printed_code

…and 50 more, all documented on the full page.

What we add:

Feed a COBOL reader directly. For anything else take the ASCII edition.

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 use:

EBCDIC with packed-decimal numerics: the original is unreadable in a text editor. The decoded table here is the same data, and is what you want unless you need the Commission's own encoding.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
Production Data Query Dump The whole PDQ archive: sixteen delimited tables of Texas production from 1993 to today.
Gas Ledger The gas proration schedule: every gas field in Texas and how its allowable is set.
Gas Ledger — Field Months Fourteen months of allocation factors and limited-allowable codes for every gas field.
Gas Ledger — Well Months Fourteen months of gas allowable against reported production, well by well.
Gas Ledger — Wells Every gas well on the proration schedule, with its gatherers, pressures and balances.