Statewide Gas Well Database — what it is, in short

What this is:

WLA001K, the gas half — the same 228-byte EBCDIC dump for the gas schedule.

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 240 columns and about 139K rows.

The columns you will most likely want:

wlroot_key The eight-digit RRC internal well id.
on_off_sched_ind 'N' on schedule, 'Y' off it. Every one of the 138,901 rows is 'N'.
oil_gas_code 'G' on every row -- this is the gas tape.
district_no RRC's INTERNAL district number.
gas_rrc_id The six-digit RRC identification number of the gas well, unique across Texas -- 138,901 distinct values in 138,901 rows.
well_no The operator's well number, right-aligned in six characters: well 1 is stored as ' 1'.

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

What we add:

Read a gas well's allowable month by month and the code and word allowable that explain it ('14B2 EXT', 'DLQ G-10', 'SWR 10'); pull the G-1 absolute open flow a well was completed at and compare it with the G-10 deliverability it is tested at now; find the wells shut in, temporarily abandoned, or held back for a delinquent G-10 (135,879 cycles); take the acres, acre-feet, bottom-hole pressure and calculated deliverability potential that the field's allocation formula actually used.

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:

Everything on this tape is ON the gas schedule: all 138,901 roots carry on_off_sched_ind 'N', and only 48 have a removed_reason other than '00'. district_no is RRC's INTERNAL district number (08 is 7B, 09 is 7C, 10 is District 08, 11 is 8A, 13 is District 09, 14 is District 10).

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

PDQ Well Completion Directory The wells that make up each lease, with API numbers and shut-in status.
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.
PDQ Regulatory Lease Directory The lease directory: lease number to lease name, operator, field and well number.
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.
Historical Ledger — Statewide Gas Every Texas gas well's month back to January 1993 — allowable, production, balances and dispositions. 105.9 million rows.