Gas Ledger — Well Months — what it is, in short

What this is:

The MONTHLY-WELL group of the GSA020K well record: 1,973,888 rows, fourteen months for each of the 140,992 gas wells.

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 47 columns and about 2M rows.

The columns you will most likely want:

district RRC district of the well this month belongs to, in the ledger's spelling.
field_no The eight-digit field number the well produces from.
operator_no P-5 number of the well's operator.
gas_rrc_id The gas well's six-digit statewide RRC identification number.
month_ordinal Which of the fourteen month slots in the well record this row came from, 1 to 14, oldest first.
cycle_yyyymm The schedule month this row is for, CCYYMM.

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

What we add:

Compare a gas well's allowable against what it produced, month by month; find wells producing under a word allowable such as '14B2 EXT' or 'DLQ G-10'; and pull the pressure and potential history behind the allowable.

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:

word_allow is the readable half of this table: '14B2 EXT' on 331,107 rows, ' SWR 10' on 72,223, '14B DENY' on 71,334, plus 'DLQ G-10', 'PRTL PLG', 'H15 VIOL', ' SHUT IN', 'T. A.', 'INJECT', 'SI MULT' and 'DOMESTIC'. The leading spaces are the tape's right-justification, so match with contains rather than equals.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Gas Ledger — Wells Every gas well on the proration schedule, with its gatherers, pressures and balances.
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.
Historical Ledger — Gas Well Months 42.9 million gas well-months, 1993 to 2024: allowable, word allowable, production, overage and the well's type that month.