Statewide Production Data — Gas — what it is, in short

What this is:

PDA001, the gas half: PDF101, the same 102-byte EBCDIC tape structure for gas. 232,028 WELLS by RRC gas id, each with the last 26 reporting CYCLES, and on every cycle the P-2 production report, the gas and condensate dispositions by code, the commingle permit, the balancing-period status and the remarks -- ten tables in all. Two things here exist nowhere else on the site.

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 107 columns and about 232K 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.
gas_code The tape's record marker, 'G' for a gas well, on all 232,028 rows.
gas_oldest_eom_balance Gas overproduction or underproduction, in MCF, carried into the oldest cycle the tape still holds.
cond_oldest_eom_balance Condensate in stock at the end of the oldest month on the tape, in barrels.
liquid_oldest_eom_balance Plant liquids at the end of the oldest month on the tape, in barrels.

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

What we add:

Put a gas well's allowable beside what it produced, follow 1,238,315 pipeline deliveries and 166,991 vented-or-flared dispositions across the state, read the operator's own explanation for the flaring, and find the 34,967 well-months inside a balancing period working off an imbalance.

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 GAS ALLOWABLE IS TRUNCATED. balancing_allow_amt is a three-byte packed S9(5) on the tape where the 2005 manual documents nine digits, so anything of 100,000 MCF or more wraps: RRC id 298707 in cycle 202506 reads 92,883 here and 492,883 in PDQ's lease_gas_allow.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Historical Ledger — Statewide Gas Every Texas gas well's month back to January 1993 — allowable, production, balances and dispositions. 105.9 million rows.
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.
Certificate of Authorization P-4 (Oil and Gas) Who gathers, buys and nominates each Texas lease's oil and gas, and every P-4 behind it.
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.