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.
Four of the column NAMES in this table are wrong, and are being corrected upstream. Read the per-column notes before …
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 25 columns and about 741 rows.
The columns you will most likely want:
-
report_yearThe calendar year the totals cover. -
districtRRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, … -
field_nameField name. -
county_nameCounty name. -
multi_county_flagY when the field spans more than one county. -
discovery_dateField 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 you use it
Four columns are misnamed and one set is mislabelled, all verified against RRC's OGA100 layout and the table itself. field_number is formation depth (nothing in it is an 8-digit field number); total_gas_prod is cumulative oil since discovery, which is why 490 of 741 rows carry a value while reporting zero producing wells; and oil_production and …
The full page lists every trap in this dataset.