EZRRC
Cart Sign in

Oil Annual Report Field Table

Annual oil production, well counts and gravity, per field.

What this is:

OGA100. One row per field per report year: total wells, producing wells, annual oil and casinghead gas, cumulative oil since discovery, formation depth, oil gravity, discovery date and the county the field is in. It is the Commission's own annual field summary — the numbers behind the printed annual report. RRC publishes it as thirteen }-delimited district parts, olf3341 to olf334d.

How it is laid out:

The Railroad Commission publishes this as Delimited text. Separated text, usually with an unusual delimiter such as a brace. We decode it into a table you can open anywhere. It has 25 columns and about 33.9K rows.

The columns you will most likely want:

  • report_year The calendar year the totals cover.
  • district RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10).
  • field_name Field name.
  • county_name County name.
  • multi_county_flag Y when the field spans more than one county.
  • discovery_date Field discovery date.

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

What we add:

Compare fields year over year on production and well count, find fields by discovery date, and get oil gravity by field without sampling wells.

  • 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:

District 10 only, for now. RRC's folder holds all thirteen district parts and upstream is being extended to load them; until it does, a field outside District 10 is not missing from Texas, it is missing from here.

The full page lists every trap in this dataset.

Get it:

People who want this usually want:

  • Oil & Gas Field Name & Numbers The eight-digit field number to field name lookup, as RRC publishes it.
  • 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 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.