EZRRC
Cart Sign in

Oil & Gas Field Name & Numbers

The eight-digit field number to field name lookup, as RRC publishes it.

What this is:

OGA040, copybook FLW700A1. One row per RRC field number — 65,826 of them, every one distinct — carrying the field's name, the district it is in, its county code, whether it spans more than one county, and whether the Commission classifies it as OIL, GAS or O & G. This is the Commission's own answer to "what does this eight-digit field number mean".

How it is laid out:

The Railroad Commission publishes this as Fixed-width ASCII. Columns are byte ranges with no separators, described only in a scanned record layout. We decode it into a table you can open anywhere. It has 11 columns and about 65.8K rows.

The columns you will most likely want:

  • field_no The eight-digit RRC field number as a whole number, and the key of this file: 65,826 records, 65,826 distinct values.
  • field_no_text The same number as the eight characters RRC publishes, leading zeros kept -- 00002001, not 2001.
  • district The district as RRC PRINTS it: 01-06, 6E, 7B, 7C, 08, 8A, 09, 10.
  • county_code The three-digit RRC county code, which for onshore Texas is also the county's FIPS code.
  • multi_county True where FIELD-MULTI-COUNTIES is '*', meaning the field crosses a county line: 4,588 of 65,826 fields, split 1,968 gas, 1,714 oil and 906 oil-and-gas.
  • field_class How the Commission classifies the field: 'GAS' (31,887 fields), 'OIL' (23,693) or 'O & G' (10,246).

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

What we add:

Decode a field number anywhere it appears — a W-1, a P-4, a completion, a production report, a severance-tax filing — and get back RRC's own spelling of the name rather than a copy of it.

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:

A name is not a key. 65,826 field numbers carry 65,702 distinct names, and 95 names are used by more than one number — SPRABERRY (TREND AREA) is 85279200 in District 7C and 85280300 in District 08. Join on the number.

The full page lists every trap in this dataset.

Get it:

People who want this usually want: