Statewide Field Data

What this is:

OGA090, the FL database tape. Every field on the Texas proration schedules — 65,826 of them — with everything the Commission keeps about it: what the field is and how it is classified, when and where it was discovered, the spacing and density rules it is under, the formula its allowable is split by, the counties it lies in, and month after month of allowables and production.

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 434 columns and about 65.8K 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.
• district_name The same district written the way RRC prints it and the way the ledgers, the W-10 and PDQ's district_name write it: 01-06, 6E, 7B, 7C, 08, 8A, 09, 10.
• field_name The field's name, up to 32 characters, as the Commission approved it: usually an operator's word, the stratigraphic interval and sometimes the depth, e.g.
• field_class How the field is classified: 'G' gas (31,848 fields), 'O' oil (23,693) or 'B' both (10,285).
• reservoir_name The reservoir the field produces from, up to 30 characters.

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

What we add:

Read a field's whole regulatory record in one place: its class and H2S status, its gas-oil ratio rule, its discovery well and permit, the counties it spans, and the rules and formula that decide what its wells may produce.

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:

• PDQ Field Directory The field number to field name lookup, with class, discovery date and rules flags.
• Oil & Gas Field Name & Numbers The eight-digit field number to field name lookup, as RRC publishes it.
• Oil & Gas Field Rules Every Texas field with the spacing and density rules the Commission adopted for it.
• Field Gas Information The gas half of a field's master record: discovery, testing cycle, offshore code and cumulative gas and condensate.
• 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 Oil Information The oil half of a field's master record: discovery, testing county, schedule headings and cumulative oil and casinghead gas.