Oil Annual Report Field Table
Queryable Fixed-width
Annual oil production, well counts and gravity, per field.
Get the data
Free. You will be asked to confirm an email address before the files are built — that is the only gate, and it is there so we can tell you when a large export is ready.
What this is
OGA100. One row per field per report year: total wells, producing wells, oil production, casinghead gas production, total gas production, 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.
What you can do with it
Compare fields year over year on production and well count, find fields by discovery date, and get oil gravity by field without sampling wells.
Gotchas
The layout carries a long run of filler columns, which EZRRC keeps so the row matches the manual byte for byte. They are empty by design.
Annual totals here will not exactly match a sum of monthly PDQ production: the annual report is cut at a different time and includes later amendments.
Record layout
25 columns.
oil_annual_field
25 columns
| # | Column | Type | RRC name | Meaning | Lookup |
|---|---|---|---|---|---|
| 1 |
report_year
key
|
text | REPORT_YEAR |
The calendar year the totals cover. | — |
| 2 |
district
key
join
|
text | DISTRICT |
RRC district the record belongs to, written the way RRC prints it (01-06, 6E, 7B, 7C, 08, 8A, 09, 10). | RRC district (printed designation) |
| 3 |
field_name
|
text | FIELD_NAME |
Field name. | — |
| 4 |
county_name
|
text | COUNTY_NAME |
County name. | — |
| 5 |
multi_county_flag
|
text | MULTI_COUNTY_FLAG |
Y when the field spans more than one county. | — |
| 6 |
discovery_date
|
text | DISCOVERY_DATE |
Field discovery date. | — |
| 7 |
field_number
key
join
|
text | FIELD_NUMBER |
The eight-digit RRC field number. | — |
| 8 |
oil_gravity
|
text measured in API | OIL_GRAVITY |
Representative oil gravity for the field, degrees API. | — |
| 9 |
total_wells
|
integer | TOTAL_WELLS |
Total wells in the field. | — |
| 10 |
producing_wells
|
integer | PRODUCING_WELLS |
Producing wells in the field. | — |
| 11 |
oil_production
|
bigint measured in bbl | OIL_PRODUCTION |
Oil produced in the year, barrels. | — |
| 12 |
casinghead_gas_prod
|
bigint measured in MCF | CASINGHEAD_GAS_PROD |
Casinghead gas produced in the year, MCF. | — |
| 13 |
total_gas_prod
|
bigint measured in MCF | TOTAL_GAS_PROD |
Total gas produced in the year, MCF. | — |
| 14 |
filler1
|
text | FILLER1 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 15 |
filler2
|
text | FILLER2 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 16 |
filler3
|
text | FILLER3 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 17 |
filler4
|
text | FILLER4 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 18 |
filler5
|
text | FILLER5 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 19 |
filler6
|
text | FILLER6 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 20 |
filler7
|
text | FILLER7 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 21 |
filler8
|
text | FILLER8 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 22 |
filler9
|
text | FILLER9 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 23 |
filler10
|
text | FILLER10 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 24 |
filler11
|
text | FILLER11 |
Trailing filler in the brace-delimited record. RRC leaves these empty; they are kept so the column count matches the source file. | — |
| 25 |
ingested_at
|
timestamptz | — | When the upstream pipeline last wrote this row. Not an RRC field — it is EZRRC's provenance stamp, and it is what the freshness badge is measured against. | — |
Code lookups used here
Every coded column in this dataset resolves to a real lookup table, so
a well code of G can be read as what it actually means.
RRC district (printed designation) 14 values
Read by district
The district as the Railroad Commission prints it: 01-06, 6E, 7B, 7C, 08, 8A, 09 and 10, plus 20 for statewide. This is what appears on permits, completions, ST-1 filings and inspection reports. It is not interchangeable with the internal district number. A column holding '11' means District 8A under the internal numbering and nothing at all under this one.
| Code | Means |
|---|---|
01 |
District 01 — San Antonio RRC District 01, administered from the San Antonio district office. |
02 |
District 02 — San Antonio RRC District 02, administered from the San Antonio district office. |
03 |
District 03 — Houston RRC District 03, administered from the Houston district office. |
04 |
District 04 — Corpus Christi RRC District 04, administered from the Corpus Christi district office. |
05 |
District 05 — Kilgore RRC District 05, administered from the Kilgore district office. |
06 |
District 06 — Kilgore RRC District 06, administered from the Kilgore district office. |
6E |
District 6E — Kilgore RRC District 6E, administered from the Kilgore district office. |
7B |
District 7B — Abilene RRC District 7B, administered from the Abilene district office. |
7C |
District 7C — San Angelo RRC District 7C, administered from the San Angelo district office. |
08 |
District 08 — Midland RRC District 08, administered from the Midland district office. |
8A |
District 8A — Midland RRC District 8A, administered from the Midland district office. |
09 |
District 09 — Wichita Falls RRC District 09, administered from the Wichita Falls district office. |
10 |
District 10 — Pampa RRC District 10, administered from the Pampa district office. |
20 |
District 20 — State Wide RRC District 20, administered from the State Wide district office. |
Source: Generated from texas.pdq_gp_district.district_name
Where this comes from
- Published by
- Texas Railroad Commission — the original page
- Original format
- Fixed-width Columns are byte ranges with no separators, described only in a scanned record layout.
- Update cadence
- Updated once a month (Monthly. Available by the 27th.)
- RRC download link
- GoAnywhere MFT
- Record layout manual
- Our table
texas.oil_annual_field
EZRRC is an independent mirror of public-domain data published by the Texas Railroad Commission. It is not affiliated with or endorsed by the RRC. For any legal or regulatory purpose, verify against the official RRC release.