Field Monthly Statistics (Allowables and Production)

What this is:

The 17 FLDMO segment of the statewide field tape, one row per field per month: the gas, oil, condensate and casinghead allowables the Commission assigned, the gas and condensate reported on form P-2, the oil and casinghead gas reported on form P-1, and two codes saying how much of that reporting had actually come in. 4,015,934 rows over all 65,826 fields.

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 18 columns and about 4M 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.
• prod_yyyymm The production month this row is for, as yyyymm. 199209 through 202608 on the August 2026 tape.
• gas_allowable Gas well gas the field was allowed to produce that month, in MCF.
• liquid_cond_allowable The monthly condensate (liquid) allowable assigned to a gas field, in barrels.
• oil_allowable Oil the field was allowed to produce that month, in barrels — the field total that the yardstick and the field's allocation formula distribute among its wells.

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

What we add:

Compare a field's allowable with its production, month by month, and see when a field was held back by proration rather than by geology.

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:

• 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.
• PDQ Field Production by Cycle Field-level monthly production totals.
• Field Gas Information The gas half of a field's master record: discovery, testing cycle, offshore code and cumulative gas and condensate.
• 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.