Doc: State generation fuel mix dictionary
Status: Complete source-bound analytical package
Owner: Rene
Last verified: 2026-11-15
Depends on: EIA final historical generation workbook, analysis.py and methodology sources

year is the annual observation year, 2015 through 2025. state is the original source code, including US-Total for the national row. state_name gives the full geography name in every derived public geography table. producer is fixed to Total Electric Power Industry. Do not add other producer groups to this total. fuel preserves the actual workbook label, with no unreported fuel row assigned a value. source_row is the original worksheet row; generation is column E, while A:D identify year, state, producer and fuel.

net_generation_mwh is the signed source integer in MWh. It measures net electrical output, not fuel input, nameplate capacity or consumed electricity. Divide MWh by 1,000 for GWh or by 1,000,000 for TWh. Solar Thermal and Photovoltaic is the workbook generating-facility category, with separate small solar estimates excluded from these calculations. Other Gases remains distinct from Natural Gas. Other is an actual reported source label, not an invented balancing remainder.

total_generation_mwh and all_source_total_mwh preserve the published Total for the same year, geography and selected producer category. share_pct=100*net_generation_mwh/total_generation_mwh. Denominators are not replaced with sums of rounded components. Negative fuel rows remain negative. No numeric row is created for an omitted fuel. A literal zero remains numeric and is included in eligible rankings.

largest_reported_fuel is the largest numeric reported fuel volume in a geography-year. largest_fuel_mwh and largest_fuel_pct_total preserve its amount and calculated share. This is a plurality classification, not necessarily a share above 50%. The complete total and largest source history contains all 52 geographies for all 11 years.

volume_rank_reported and share_rank_reported compare the same fuel across only state/DC rows with actual numeric source records in 2025. Competition rank equals one plus the number of strictly higher values. Full source MWh determine volume ranks; six decimal derived shares determine share ranks, checked against unrounded ratios. reporting_state_count is the eligible geography count for that fuel. The U.S. row explicitly says Not ranked, U.S. total in both rank fields.

begin_year=2015 and end_year=2025. begin_mwh and end_mwh use actual numeric matched fuel records. change_mwh=end_mwh-begin_mwh. begin_share_pct and end_share_pct divide by their own same-year state or national Total. share_change_percentage_points subtracts the unrounded endpoint shares before six decimal export rounding. This is not a percentage change in volume and does not establish causal fuel displacement.

sum_reported_fuel_rows_mwh includes every numeric non-Total fuel component with its original sign. sum_minus_total_mwh=sum_reported_fuel_rows_mwh-all_source_total_mwh. reported_component_rows counts actual component rows, not hypothetical zero entries. Small source rounding residuals remain visible. Do not force an exact 100% by changing a fuel row or adding a balancing Other value.

The selected EIA923-based series concerns generating facilities. Official instructions cover grid-connected electric and combined heat and power plants with at least one MW of aggregate nameplate capacity at a site. Separate small photovoltaic generation is estimated through other survey information and is not added here. Annual output is not consumer supply, imports, costs, emissions, reliability or capacity factor.
