Field Gas Information — what it is, in short

What this is:

The 02 GASSEG segment of the statewide field tape, one row for each of the 42,133 fields carried on 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 40 columns and about 42.1K rows.

The columns you will most likely want:

district_no RRC district as the FL tape stores it, 01 to 14 — the INTERNAL number, not the designation the industry prints.
field_no The eight-digit RRC field number: five digits of field, then three of reservoir.
disc_date Discovery date of the field's first gas well, CCYYMMDD. Filled on 41,376 of the 42,133 gas fields.
disc_county_code Three-digit RRC county code the field was discovered in. Zero where the mainframe never recorded one.
perf_1st_well Depth in feet at which the discovery well was perforated — the closest thing this file has to a field depth.
type_field_code 'A' associated with an oil field, 'N' non-associated.

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

What we add:

Rank fields by cumulative gas or condensate, or by what they have produced in the last two years. Find the gas fields in a county, the ones discovered in a decade, the ones exempt from the minimum GOR, and the ones sitting in state waters.

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.

Worth knowing before use:

The four cumulative families do not add up to one another and must not be summed together. The conversion totals exclude retro P-2 reports; the off-file totals include them; the on-file totals stop two months short so they can be compared with production.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

Statewide Field Data The mainframe's field master: every oil and gas field in Texas with its rules, its allocation formulas and 10.5 million rows of allowable and production history.
Field Monthly Statistics (Allowables and Production) Field-level monthly allowables beside the P-1 and P-2 production actually reported. 4.0 million field-months, and no other RRC file has them.
Field Gas Rules (Mainframe) 13,951 gas field rules as the IMS database holds them: spacing, density, casing, diagonal, docket and the analyst's own text.
Field Oil Information The oil half of a field's master record: discovery, testing county, schedule headings and cumulative oil and casinghead gas.
Field Oil Rules (Mainframe) 8,565 oil field rules as the IMS database holds them, with the allocation code that says how the field's allowable is split.
Gas Annual Report Field Table Annual gas production, condensate and well counts, per field, statewide.