Doc: AMR proved oil reserve data dictionary
Status: Fixed analytical edition
Owner: American Mineral Registry
Last verified: 2026-11-14
Depends on: evidence-contract.json, pinned EIA workbooks, analysis.py

Run python3 analysis.py. Python standard library only, no network requests. Original XLSX files are read without recalculation or modification. All units, periods and source categories remain attached. Display rounding follows calculation.

## 2024-reserve-bridge-steps.csv

7 complete rows.

| Field | Definition |
| --- | --- |
| order | Source-informed arithmetic sequence, not a chronological transaction list. |
| step | Named source component, explicit source rounding residual or endpoint. |
| kind | Level or signed accounting change. |
| signed_amount_million_barrels | Component signed for addition to the reserve bridge, including negative production deduction. |
| running_reserves_million_barrels | Cumulative bridge result, not a physically observed reserve quantity after each transaction. |
| source_url | Original opened EIA workbook URL. |

## annual-additions-and-production-ratios.csv

11 complete rows.

| Field | Definition |
| --- | --- |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| reported_net_additions_million_barrels | AMR reconstruction of the full pre-production change: published change + matching source production, including all other effects and residual. |
| extensions_discoveries_million_barrels | Source extensions and discoveries component, million barrels. |
| reserves_report_production_million_barrels | Production estimate in Form EIA-23L reserves report; source says it may differ from official Petroleum Supply Annual or Natural Gas Annual production. |
| net_additions_to_production_percent | Reported net additions divided by matching source production, times 100; can be negative. |
| extensions_discoveries_to_production_percent | Extensions/discoveries divided by matching source production, times 100. |
| year_end_reserves_to_same_year_production_multiple | Year end reserve level / source annual production, static matched ratio; not depletion or exhaustion forecast. |
| year_end_reserves_change_percent | Published year end change / preceding level, times 100, from rounded source quantities. |
| source_url | Original opened EIA workbook URL. |

## annual-reserve-accounting-2014-2024.csv

11 complete rows.

| Field | Definition |
| --- | --- |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| previous_year_end_million_barrels | Matching preceding national year end level from the same report edition. |
| revisions_other_changes_million_barrels | Source annual EIA balancing item, signed; not an isolated measured geology or price effect. |
| net_acquisitions_divestitures_million_barrels | Source acquisitions minus divestitures, signed. |
| extensions_discoveries_million_barrels | Source extensions and discoveries component, million barrels. |
| reserves_report_production_million_barrels | Production estimate in Form EIA-23L reserves report; source says it may differ from official Petroleum Supply Annual or Natural Gas Annual production. |
| component_net_change_million_barrels | Revisions + net acquisitions + extensions/discoveries − report production, using displayed inputs. |
| published_net_change_million_barrels | Published change from preceding year end, million barrels. |
| rounding_residual_million_barrels | Published change minus the calculated sum of displayed source components; retained separately, never allocated silently. |
| year_end_reserves_million_barrels | Published national proved crude oil and lease condensate reserves at December 31, million barrels. |
| source_cells | Exact source worksheet and numerical cell span. |
| source_url | Original opened EIA workbook URL. |

## fixed-history-highs-and-lows.csv

10 complete rows.

| Field | Definition |
| --- | --- |
| comparison | Highest or Lowest inside the fixed 41-year 1984 through 2024 panel, not all recorded history. |
| rank | Order inside the stated fixed sample; no ties occur in the selected extrema. |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| year_end_reserves_million_barrels | Published national proved crude oil and lease condensate reserves at December 31, million barrels. |
| sample | Explicit fixed history window. |
| source_url | Original opened EIA workbook URL. |

## national-reserves-1984-2024.csv

41 complete rows.

| Field | Definition |
| --- | --- |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| year_end_reserves_million_barrels | Published national proved crude oil and lease condensate reserves at December 31, million barrels. |
| category | Exact material group: crude oil and lease condensate. |
| source_cells | Exact source worksheet and numerical cell span. |
| source_url | Original opened EIA workbook URL. |

## shale-and-nonshale-national-comparison.csv

2 complete rows.

| Field | Definition |
| --- | --- |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| total_oil_condensate_reserves_million_barrels | Published matching national reserve level, same report vintage. |
| shale_reserves_million_barrels | Published U.S. shale oil and lease condensate reserve total, not all national reserves. |
| nonshale_residual_reserves_million_barrels | Calculated national oil/condensate reserves minus reported shale reserves; derived complement, not independent field measurement. |
| shale_share_of_national_percent | Reported shale reserves / matching national oil-condensate reserves, times 100. |
| shale_reserves_report_production_million_barrels | Published shale production total in the reserves report. |
| source_url | Opened EIA Table 2 workbook containing the reported shale values. |
| national_source_url | Opened EIA Table 1 workbook containing the matching national oil and condensate reserve denominator. |

## shale-play-comparison-2023-2024.csv

8 complete rows.

| Field | Definition |
| --- | --- |
| basin | Original source basin label; no precise boundary or map inferred. |
| play | Original source play grouping or residual Other category, asterisks retained. |
| category_type | Named source grouping or reported residual aggregate; Other is not a missing value. |
| production_2023_million_barrels | Published source production 2023 million barrels, million barrels; source estimates and independent-rounding note retained. |
| reserves_2023_million_barrels | Published source reserves 2023 million barrels, million barrels; source estimates and independent-rounding note retained. |
| production_2024_million_barrels | Published source production 2024 million barrels, million barrels; source estimates and independent-rounding note retained. |
| reserves_2024_million_barrels | Published source reserves 2024 million barrels, million barrels; source estimates and independent-rounding note retained. |
| production_change_million_barrels | Published source production change million barrels, million barrels; source estimates and independent-rounding note retained. |
| reserves_change_million_barrels | Published source reserves change million barrels, million barrels; source estimates and independent-rounding note retained. |
| reserves_change_percent | 2024 reserves minus 2023 reserves, divided by 2023 reserves, times 100. |
| share_of_2024_shale_reserves_percent | 2024 category reserves divided by the published 2024 shale total of 27,533 million barrels, times 100. |
| share_of_2024_national_oil_condensate_reserves_percent | 2024 category reserves divided by the national 2024 oil and condensate total of 45,951 million barrels, times 100. |
| source_cells | Exact source worksheet and numerical cell span. |
| source_url | Original opened EIA workbook URL. |

## shale-source-rounding-controls.csv

2 complete rows.

| Field | Definition |
| --- | --- |
| year | Calendar year of reserve estimate or accounting flow, not publication year. |
| reported_shale_production_million_barrels | reported shale production million barrels, using the source rounded million barrel quantities. Leaf sums and published totals remain separate. |
| leaf_production_sum_million_barrels | leaf production sum million barrels, using the source rounded million barrel quantities. Leaf sums and published totals remain separate. |
| production_rounding_residual_million_barrels | Published source production rounding residual million barrels, million barrels; source estimates and independent-rounding note retained. |
| reported_shale_reserves_million_barrels | reported shale reserves million barrels, using the source rounded million barrel quantities. Leaf sums and published totals remain separate. |
| leaf_reserves_sum_million_barrels | leaf reserves sum million barrels, using the source rounded million barrel quantities. Leaf sums and published totals remain separate. |
| reserves_rounding_residual_million_barrels | Published source reserves rounding residual million barrels, million barrels; source estimates and independent-rounding note retained. |
| source_url | Original opened EIA workbook URL. |

## used-primary-workbook-cells.csv

218 complete rows.

| Field | Definition |
| --- | --- |
| source_file | Pinned original workbook filename. |
| sheet | Original worksheet label. |
| cell | Original spreadsheet coordinate. |
| cached_value | Numerical value stored in source workbook XML, without recalculation. |
| unit | Million barrels for numerical quantities; year cells remain calendar years. |
| source_url | Original opened EIA workbook URL. |

## Definitions and qualifications

The original report was released April 7, 2026 with 2024 data. Oil means crude oil AND lease condensate throughout this comparison. National history covers 1984 through 2024, annual accounting 2014 through 2024 and shale comparison 2023 and 2024. Revisions and other changes is an EIA annual balancing item. Report production may differ from Petroleum Supply Annual or Natural Gas Annual production. Independent rounding remains explicit, including the 2024 minus 1 million barrel national bridge residual and the plus 1 million barrel shale production residual in each comparison year. Missing inputs fail and never become zero. Other is a published aggregate. Net additions include more than discoveries. Ratios describe accounting and do not predict future depletion.

AMR calculations and original figures: CC BY 4.0. Preserve original EIA attribution and applicable source terms.
