2024 Standard Scenarios: A U.S. Electricity Sector Outlook
Department of Energy
@usgov.doe_gov_2024_standard_scenarios_a_u_s_electricity_sect_8e2aafbd
Department of Energy
@usgov.doe_gov_2024_standard_scenarios_a_u_s_electricity_sect_8e2aafbd
CREATE TABLE standard_scenario_2024_balancing_areas (
"scenario" VARCHAR,
"scenario_policy_type" VARCHAR,
"r" VARCHAR,
"state" VARCHAR,
"country" VARCHAR,
"year" VARCHAR,
"enduse_load_mwh" VARCHAR,
"distribution_losses_mwh" VARCHAR,
"transmission_losses_mwh" VARCHAR,
"energy_exported_to_canada_mwh" VARCHAR,
"storage_charging_load_mwh" VARCHAR,
"electrolyzer_load_mwh" VARCHAR,
"dac_load_mwh" VARCHAR,
"sum_of_all_loads_mwh" VARCHAR,
"hydrogen_production_metric_tons" VARCHAR,
"n_4_hour_battery_capacity_mw" VARCHAR,
"n_8_hour_battery_capacity_mw" VARCHAR,
"bioenergy_capacity_mw" VARCHAR,
"bioenergy_with_ccs_capacity_mw" VARCHAR,
"coal_with_ccs_capacity_mw" VARCHAR,
"coal_capacity_mw" VARCHAR,
"concentrating_solar_power_capacity_mw" VARCHAR,
"behind_the_meter_pv_capacity_mw" VARCHAR,
"natural_gas_combined_cycle_with_ccs_capacity_mw" VARCHAR,
"natural_gas_combined_cycle_capacity_mw" VARCHAR,
"natural_gas_combustion_turbine_capacity_mw" VARCHAR,
"geothermal_capacity_mw" VARCHAR,
"hydropower_capacity_mw" VARCHAR,
"nuclear_capacity_mw" VARCHAR,
"nuclear_small_modular_reactors_capacity_mw" VARCHAR,
"oil_gas_steam_capacity_mw" VARCHAR,
"pumped_hydropower_storage_capacity_mw" VARCHAR,
"hydrogen_combustion_turbine_capacity_mw" VARCHAR,
"utility_scale_pv_capacity_mw" VARCHAR,
"offshore_wind_capacity_mw" VARCHAR,
"onshore_wind_capacity_mw" VARCHAR,
"direct_air_capture_capacity_mw" VARCHAR,
"hydrogen_electrolyzer_capacity_mw" VARCHAR,
"n_4_hour_battery_generation_mwh" VARCHAR,
"n_8_hour_battery_generation_mwh" VARCHAR,
"bioenergy_generation_mwh" VARCHAR,
"bioenergy_with_ccs_generation_mwh" VARCHAR,
"canadian_imports_mwh" VARCHAR,
"coal_with_ccs_generation_mwh" VARCHAR,
"coal_generation_mwh" VARCHAR,
"concentrating_solar_power_generation_mwh" VARCHAR,
"behind_the_meter_pv_generation_mwh" VARCHAR,
"natural_gas_combined_cycle_with_ccs_generation_mwh" VARCHAR,
"natural_gas_combined_cycle_generation_mwh" VARCHAR,
"natural_gas_combustion_turbine_generation_mwh" VARCHAR,
"geothermal_generation_mwh" VARCHAR,
"hydropower_generation_mwh" VARCHAR,
"nuclear_generation_mwh" VARCHAR,
"nuclear_small_modular_reactors_generation_mwh" VARCHAR,
"oil_gas_steam_generation_mwh" VARCHAR,
"pumped_hydropower_storage_generation_mwh" VARCHAR,
"hydrogen_combustion_turbine_generation_mwh" VARCHAR,
"utility_scale_pv_generation_mwh" VARCHAR,
"offshore_wind_generation_mwh" VARCHAR,
"onshore_wind_generation_mwh" VARCHAR,
"total_generation_mwh" VARCHAR,
"utility_scale_non_storage_generation_excluding_canada_mwh" VARCHAR,
"co2_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2_emissions_from_fuel_combustion_net_of_in_region_ca_730f0ff8" VARCHAR,
"ch4_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"n2o_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"so2_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"nox_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"ch4_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"n2o_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"co2e_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2e_emissions_from_fuel_combustion_net_of_in_region_c_beb45fcf" VARCHAR,
"co2e_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"co2e_emissions_from_both_fuel_combustion_and_precombus_0287675d" VARCHAR,
"co2e_emissions_from_both_fuel_combustion_and_precombus_027e9850" VARCHAR,
"direct_air_capture_of_co2_metric_tons" VARCHAR,
"co2_capture_on_fossil_generators_metric_tons" VARCHAR,
"co2_capture_on_bioenergy_generators_metric_tons" VARCHAR,
"co2_emissions_rate_from_fuel_combustion_for_in_region__b98157ce" VARCHAR,
"co2e_emissions_rate_from_fuel_combustion_for_in_region_7df8fe3f" VARCHAR,
"ch4_emissions_rate_from_fuel_combustion_for_in_region__8e1b7609" VARCHAR,
"n2o_emissions_rate_from_fuel_combustion_for_in_region__fae9f79c" VARCHAR,
"so2_emissions_rate_from_fuel_combustion_for_in_region__fcc7ef1f" VARCHAR,
"nox_emissions_rate_from_fuel_combustion_for_in_region__d5980f09" VARCHAR,
"co2_emissions_rate_from_precombustion_activities_for_i_b8c11ce8" VARCHAR,
"co2e_emissions_rate_from_precombustion_activities_for__a647e4ae" VARCHAR,
"ch4_emissions_rate_from_precombustion_activities_for_i_feed8fce" VARCHAR,
"n2o_emissions_rate_from_precombustion_activities_for_i_700ce067" VARCHAR,
"co2e_emissions_rate_from_both_fuel_combustion_and_prec_5e93941a" VARCHAR
);
CREATE TABLE standard_scenario_2024_states (
"scenario" VARCHAR,
"scenario_policy_type" VARCHAR,
"state" VARCHAR,
"year" VARCHAR,
"enduse_load_mwh" VARCHAR,
"distribution_losses_mwh" VARCHAR,
"transmission_losses_mwh" VARCHAR,
"energy_exported_to_canada_mwh" VARCHAR,
"storage_charging_load_mwh" VARCHAR,
"electrolyzer_load_mwh" VARCHAR,
"dac_load_mwh" VARCHAR,
"sum_of_all_loads_mwh" VARCHAR,
"hydrogen_production_metric_tons" VARCHAR,
"n_4_hour_battery_capacity_mw" VARCHAR,
"n_8_hour_battery_capacity_mw" VARCHAR,
"bioenergy_capacity_mw" VARCHAR,
"bioenergy_with_ccs_capacity_mw" VARCHAR,
"coal_with_ccs_capacity_mw" VARCHAR,
"coal_capacity_mw" VARCHAR,
"concentrating_solar_power_capacity_mw" VARCHAR,
"behind_the_meter_pv_capacity_mw" VARCHAR,
"natural_gas_combined_cycle_with_ccs_capacity_mw" VARCHAR,
"natural_gas_combined_cycle_capacity_mw" VARCHAR,
"natural_gas_combustion_turbine_capacity_mw" VARCHAR,
"geothermal_capacity_mw" VARCHAR,
"hydropower_capacity_mw" VARCHAR,
"nuclear_capacity_mw" VARCHAR,
"nuclear_small_modular_reactors_capacity_mw" VARCHAR,
"oil_gas_steam_capacity_mw" VARCHAR,
"pumped_hydropower_storage_capacity_mw" VARCHAR,
"hydrogen_combustion_turbine_capacity_mw" VARCHAR,
"utility_scale_pv_capacity_mw" VARCHAR,
"offshore_wind_capacity_mw" VARCHAR,
"onshore_wind_capacity_mw" VARCHAR,
"direct_air_capture_capacity_mw" VARCHAR,
"hydrogen_electrolyzer_capacity_mw" VARCHAR,
"n_4_hour_battery_generation_mwh" VARCHAR,
"n_8_hour_battery_generation_mwh" VARCHAR,
"bioenergy_generation_mwh" VARCHAR,
"bioenergy_with_ccs_generation_mwh" VARCHAR,
"canadian_imports_mwh" VARCHAR,
"coal_with_ccs_generation_mwh" VARCHAR,
"coal_generation_mwh" VARCHAR,
"concentrating_solar_power_generation_mwh" VARCHAR,
"behind_the_meter_pv_generation_mwh" VARCHAR,
"natural_gas_combined_cycle_with_ccs_generation_mwh" VARCHAR,
"natural_gas_combined_cycle_generation_mwh" VARCHAR,
"natural_gas_combustion_turbine_generation_mwh" VARCHAR,
"geothermal_generation_mwh" VARCHAR,
"hydropower_generation_mwh" VARCHAR,
"nuclear_generation_mwh" VARCHAR,
"nuclear_small_modular_reactors_generation_mwh" VARCHAR,
"oil_gas_steam_generation_mwh" VARCHAR,
"pumped_hydropower_storage_generation_mwh" VARCHAR,
"hydrogen_combustion_turbine_generation_mwh" VARCHAR,
"utility_scale_pv_generation_mwh" VARCHAR,
"offshore_wind_generation_mwh" VARCHAR,
"onshore_wind_generation_mwh" VARCHAR,
"total_generation_mwh" VARCHAR,
"utility_scale_non_storage_generation_excluding_canada_mwh" VARCHAR,
"co2_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2_emissions_from_fuel_combustion_net_of_in_region_ca_730f0ff8" VARCHAR,
"ch4_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"n2o_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"so2_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"nox_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"ch4_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"n2o_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"co2e_emissions_from_fuel_combustion_metric_tons" VARCHAR,
"co2e_emissions_from_fuel_combustion_net_of_in_region_c_beb45fcf" VARCHAR,
"co2e_emissions_from_precombustion_activities_metric_tons" VARCHAR,
"co2e_emissions_from_both_fuel_combustion_and_precombus_0287675d" VARCHAR,
"co2e_emissions_from_both_fuel_combustion_and_precombus_027e9850" VARCHAR,
"direct_air_capture_of_co2_metric_tons" VARCHAR,
"co2_capture_on_fossil_generators_metric_tons" VARCHAR,
"co2_capture_on_bioenergy_generators_metric_tons" VARCHAR,
"co2_emissions_rate_from_fuel_combustion_for_in_region__b98157ce" VARCHAR,
"co2_emissions_rate_from_precombustion_activities_for_i_b8c11ce8" VARCHAR,
"co2e_emissions_rate_from_fuel_combustion_for_in_region_7df8fe3f" VARCHAR,
"co2e_emissions_rate_from_precombustion_activities_for__a647e4ae" VARCHAR,
"co2e_emissions_rate_from_both_fuel_combustion_and_prec_5e93941a" VARCHAR,
"ch4_emissions_rate_from_fuel_combustion_for_in_region__8e1b7609" VARCHAR,
"n2o_emissions_rate_from_fuel_combustion_for_in_region__fae9f79c" VARCHAR,
"so2_emissions_rate_from_fuel_combustion_for_in_region__fcc7ef1f" VARCHAR,
"nox_emissions_rate_from_fuel_combustion_for_in_region__d5980f09" VARCHAR,
"ch4_emissions_rate_from_precombustion_activities_for_i_feed8fce" VARCHAR,
"n2o_emissions_rate_from_precombustion_activities_for_i_700ce067" VARCHAR
);
CREATE TABLE standard_scenario_2024_transmission_capacities (
"scenario" VARCHAR,
"r" VARCHAR,
"rr" VARCHAR,
"trtype" VARCHAR,
"t" BIGINT,
"tran_cap_mw" DOUBLE
);
Anyone who has the link will be able to view this.