Gas Well Status (26 Month G-10) — what it is, in short

What this is:

GSA018K. The gas counterpart of the W-10 file: the G-10 deliverability test behind a gas well's allowable, with the daily gas, condensate and water on the test day, the shut-in, flowing and bottom-hole pressures, gas and condensate gravity and the gas-liquid ratio that classifies the well.

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 23 columns and about 163.8K rows.

The columns you will most likely want:

record_id The tape ID, 'GT' on every one of the 163,819 records.
district RRC district the well is in, written the way RRC prints it: 01-06, 7B, 7C, 08, 8A, 09, 10 (the manual does not list 6E for gas).
rrc_id The gas well's six-digit RRC identification number, unique across Texas.
test_date Date the G-10 test was conducted.
daily_gas_mcf Deliverability: daily gas produced during the G-10 test, in MCF.
daily_cond_bbl Daily condensate produced during the test, in barrels, to one decimal place.

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

What we add:

Read the deliverability and pressures a gas well tested at, compare them against its reported PDQ production, and find wells whose G-10 has lapsed.

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 file RRC publishes under this name is not current. The copy fetched in August 2026 holds tests dated 1990 to November 2021 and effective dates from November 2019 to November 2021: read it as the state of the gas schedule in late 2021 rather than today's.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

P-5 Organization (ASCII) Every organization with an RRC operator number: name, status, type and address.
Gas Ledger — Wells Every gas well on the proration schedule, with its gatherers, pressures and balances.
Statewide Gas Well Database Every gas well on the proration schedule, with its allowables, G-1 completions and G-10 tests.
PDQ Well Completion Directory The wells that make up each lease, with API numbers and shut-in status.
Statewide Production Data — Gas The live P-2 world: every gas well's allowable, production, dispositions and flaring remarks, 26 months deep.
Historical Ledger — Statewide Gas Every Texas gas well's month back to January 1993 — allowable, production, balances and dispositions. 105.9 million rows.