Historical Ledger — Statewide Gas

What this is:

LAD001, the gas half: S.LDF900GS, a 160-byte EBCDIC tape of the Commission's Historical Ledger database.

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 63 columns and about 219.4K rows.

The columns you will most likely want:

• district RRC district as an INTERNAL district number, 01 to 14 -- not the designation the industry prints.
• gas_rrc_id The well's RRC gas identifier as a whole number.
• og_code The tape's record marker, 'G' for a gas well, on all 219,384 rows.
• gas_oldest_eom_balance Cumulative gas overage, or underage where it is negative, as of the beginning of the oldest cycle on the LIVE database -- so this describes the live ledger at the tape cut, not 1993.
• cond_oldest_eom_balance Condensate on hand at the end of the oldest live cycle, in barrels.
• liquid_oldest_eom_balance The same for plant liquids, and only meaningful for wells in liquid-limit fields.

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

What we add:

Take a gas well's whole allowable-and-production history in one query -- 378 months for the wells that have been on the schedule since 1993 -- and put the reason beside the number: 5,530,195 well-months whose allowable was the word '14B2 EXT', 752,293 that read '14B DENY', 330,843 delinquent on the G-10.

There is more on the full page, including what this joins to.

• 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.

People who want this usually want:

• 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.
• Statewide Production Data — Gas The live P-2 world: every gas well's allowable, production, dispositions and flaring remarks, 26 months deep.
• PDQ Regulatory Lease Directory The lease directory: lease number to lease name, operator, field and well number.
• PDQ Lease Production by Cycle Monthly oil, gas, condensate and casinghead gas production for every Texas lease since 1993.
• Statewide Gas Well Database Every gas well on the proration schedule, with its allowables, G-1 completions and G-10 tests.
• Gas Ledger — Wells Every gas well on the proration schedule, with its gatherers, pressures and balances.