Gas Ledger — what it is, in short

What this is:

GSA020K, the gas master tape. Three volumes of 2120-byte EBCDIC records covering districts 1-3, 4-6 and 7B-10, decoded here into four tables: a record for every gas FIELD and one for every gas WELL, each with fourteen months carried inside the record.

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 180 columns and about 42.1K rows.

The columns you will most likely want:

district RRC district the field is in, as the ledger tape writes it: 01-06, 07B, 07C, 08, 08A, 09, 10, with the leading zero the W-10 and PDQ do not use.
field_no The eight-digit RRC field number, five of field and three of reservoir.
field_name The field name RRC designated, usually an operator's word plus the formation and depth.
county_code_1 First of up to six county codes the field lies in, three digits.
county_code_2 Second county the field lies in, or 0.
county_code_3 Third county the field lies in, or 0.

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

What we add:

Read how each gas field's allowable is set -- prorated, exempt, one-well, 100% open flow -- and rank the state's gas fields by cumulative production. Cumulative condensate beside cumulative gas is the cheapest way to find the liquids-rich fields.

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.
The Commission's single-letter codes translated into words.

Worth knowing before use:

The district is spelled the tape's way -- 07B, 07C, 08A -- where the G-10 file and PDQ write 7B, 7C, 8A. The August 2026 gas tape carries twelve districts and no 6E at all.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Gas Ledger — Field Months Fourteen months of allocation factors and limited-allowable codes for every gas field.
Gas Ledger — Wells Every gas well on the proration schedule, with its gatherers, pressures and balances.
PDQ Field Directory The field number to field name lookup, with class, discovery date and rules flags.
Oil Ledger The oil proration schedule: every oil field in Texas and the allowable it prorates.
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.