Electricity Mix (EI & Ember, 2023)
@owid.electricity_mix
@owid.electricity_mix
CREATE TABLE owid_electricity_mix_1 (
"country" VARCHAR,
"year" INTEGER,
"bioenergy_generation_twh" FLOAT,
"bioenergy_share_of_electricity_pct" FLOAT,
"co2_intensity_gco2_kwh" FLOAT,
"coal_generation_twh" FLOAT,
"coal_share_of_electricity_pct" FLOAT,
"fossil_generation_twh" FLOAT,
"fossil_share_of_electricity_pct" FLOAT,
"gas_generation_twh" FLOAT,
"gas_share_of_electricity_pct" FLOAT,
"hydro_generation_twh" FLOAT,
"hydro_share_of_electricity_pct" FLOAT,
"low_carbon_generation_twh" FLOAT,
"low_carbon_share_of_electricity_pct" FLOAT,
"net_imports_share_of_demand_pct" FLOAT,
"nuclear_generation_twh" FLOAT,
"nuclear_share_of_electricity_pct" FLOAT,
"oil_generation_twh" FLOAT,
"oil_share_of_electricity_pct" FLOAT,
"other_renewables_excluding_bioenergy_generation_twh" FLOAT,
"other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT,
"other_renewables_including_bioenergy_generation_twh" FLOAT,
"other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT,
"per_capita_bioenergy_generation_kwh" FLOAT,
"per_capita_coal_generation_kwh" FLOAT,
"per_capita_fossil_generation_kwh" FLOAT,
"per_capita_gas_generation_kwh" FLOAT,
"per_capita_hydro_generation_kwh" FLOAT,
"per_capita_low_carbon_generation_kwh" FLOAT,
"per_capita_nuclear_generation_kwh" FLOAT,
"per_capita_oil_generation_kwh" FLOAT,
"per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT,
"per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT,
"per_capita_renewable_generation_kwh" FLOAT,
"per_capita_solar_and_wind_generation_kwh" FLOAT,
"per_capita_solar_generation_kwh" FLOAT,
"per_capita_total_generation_kwh" FLOAT,
"per_capita_wind_generation_kwh" FLOAT,
"population" BIGINT,
"primary_energy_consumption_twh" FLOAT,
"renewable_generation_twh" FLOAT,
"renewable_share_of_electricity_pct" FLOAT,
"solar_and_wind_generation_twh" FLOAT,
"solar_and_wind_share_of_electricity_pct" FLOAT,
"solar_generation_twh" FLOAT,
"solar_share_of_electricity_pct" FLOAT,
"total_demand_twh" FLOAT,
"total_electricity_share_of_primary_energy_pct" FLOAT,
"total_emissions_mtco2" FLOAT,
"total_generation_twh" FLOAT,
"total_net_imports_twh" FLOAT,
"wind_generation_twh" FLOAT,
"wind_share_of_electricity_pct" FLOAT
);
CREATE TABLE owid_electricity_mix_2 (
"country" VARCHAR,
"year" INTEGER,
"bioenergy_generation_twh" FLOAT,
"bioenergy_share_of_electricity_pct" FLOAT,
"co2_intensity_gco2_kwh" FLOAT,
"coal_generation_twh" FLOAT,
"coal_share_of_electricity_pct" FLOAT,
"direct_primary_energy_consumption_twh" FLOAT,
"fossil_generation_twh" FLOAT,
"fossil_share_of_electricity_pct" FLOAT,
"gas_generation_twh" FLOAT,
"gas_share_of_electricity_pct" FLOAT,
"hydro_generation_twh" FLOAT,
"hydro_share_of_electricity_pct" FLOAT,
"low_carbon_generation_twh" FLOAT,
"low_carbon_share_of_electricity_pct" FLOAT,
"net_imports_share_of_demand_pct" FLOAT,
"nuclear_generation_twh" FLOAT,
"nuclear_share_of_electricity_pct" FLOAT,
"oil_generation_twh" FLOAT,
"oil_share_of_electricity_pct" FLOAT,
"other_renewables_excluding_bioenergy_generation_twh" FLOAT,
"other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT,
"other_renewables_including_bioenergy_generation_twh" FLOAT,
"other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT,
"per_capita_bioenergy_generation_kwh" FLOAT,
"per_capita_coal_generation_kwh" FLOAT,
"per_capita_fossil_generation_kwh" FLOAT,
"per_capita_gas_generation_kwh" FLOAT,
"per_capita_hydro_generation_kwh" FLOAT,
"per_capita_low_carbon_generation_kwh" FLOAT,
"per_capita_nuclear_generation_kwh" FLOAT,
"per_capita_oil_generation_kwh" FLOAT,
"per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT,
"per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT,
"per_capita_renewable_generation_kwh" FLOAT,
"per_capita_solar_and_wind_generation_kwh" FLOAT,
"per_capita_solar_generation_kwh" FLOAT,
"per_capita_total_generation_kwh" FLOAT,
"per_capita_wind_generation_kwh" FLOAT,
"population" BIGINT,
"primary_energy_consumption_twh" FLOAT,
"renewable_generation_twh" FLOAT,
"renewable_share_of_electricity_pct" FLOAT,
"solar_and_wind_generation_twh" FLOAT,
"solar_and_wind_share_of_electricity_pct" FLOAT,
"solar_generation_twh" FLOAT,
"solar_share_of_electricity_pct" FLOAT,
"total_demand_twh" FLOAT,
"total_electricity_share_of_primary_energy_pct" FLOAT,
"total_emissions_mtco2" FLOAT,
"total_generation_twh" FLOAT,
"total_net_imports_twh" FLOAT,
"wind_generation_twh" FLOAT,
"wind_share_of_electricity_pct" FLOAT
);
CREATE TABLE owid_electricity_mix_3 (
"country" VARCHAR,
"year" INTEGER,
"bioenergy_generation_twh" FLOAT,
"bioenergy_share_of_electricity_pct" FLOAT,
"co2_intensity_gco2_kwh" FLOAT,
"coal_generation_twh" FLOAT,
"coal_share_of_electricity_pct" FLOAT,
"direct_primary_energy_consumption_twh" FLOAT,
"fossil_generation_twh" FLOAT,
"fossil_share_of_electricity_pct" FLOAT,
"gas_generation_twh" FLOAT,
"gas_share_of_electricity_pct" FLOAT,
"hydro_generation_twh" FLOAT,
"hydro_share_of_electricity_pct" FLOAT,
"low_carbon_generation_twh" FLOAT,
"low_carbon_share_of_electricity_pct" FLOAT,
"net_imports_share_of_demand_pct" FLOAT,
"nuclear_generation_twh" FLOAT,
"nuclear_share_of_electricity_pct" FLOAT,
"oil_generation_twh" FLOAT,
"oil_share_of_electricity_pct" FLOAT,
"other_renewables_excluding_bioenergy_generation_twh" FLOAT,
"other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT,
"other_renewables_including_bioenergy_generation_twh" FLOAT,
"other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT,
"per_capita_bioenergy_generation_kwh" FLOAT,
"per_capita_coal_generation_kwh" FLOAT,
"per_capita_fossil_generation_kwh" FLOAT,
"per_capita_gas_generation_kwh" FLOAT,
"per_capita_hydro_generation_kwh" FLOAT,
"per_capita_low_carbon_generation_kwh" FLOAT,
"per_capita_nuclear_generation_kwh" FLOAT,
"per_capita_oil_generation_kwh" FLOAT,
"per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT,
"per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT,
"per_capita_renewable_generation_kwh" FLOAT,
"per_capita_solar_and_wind_generation_kwh" FLOAT,
"per_capita_solar_generation_kwh" FLOAT,
"per_capita_total_generation_kwh" FLOAT,
"per_capita_wind_generation_kwh" FLOAT,
"population" BIGINT,
"primary_energy_consumption_twh" FLOAT,
"renewable_generation_twh" FLOAT,
"renewable_share_of_electricity_pct" FLOAT,
"solar_and_wind_generation_twh" FLOAT,
"solar_and_wind_share_of_electricity_pct" FLOAT,
"solar_generation_twh" FLOAT,
"solar_share_of_electricity_pct" FLOAT,
"total_demand_twh" FLOAT,
"total_electricity_share_of_primary_energy_pct" FLOAT,
"total_emissions_mtco2" FLOAT,
"total_generation_twh" FLOAT,
"total_net_imports_twh" FLOAT,
"wind_generation_twh" FLOAT,
"wind_share_of_electricity_pct" FLOAT
);
CREATE TABLE owid_electricity_mix_4 (
"country" VARCHAR,
"year" INTEGER,
"bioenergy_generation_twh" FLOAT,
"bioenergy_share_of_electricity_pct" FLOAT,
"co2_intensity_gco2_kwh" FLOAT,
"coal_generation_twh" FLOAT,
"coal_share_of_electricity_pct" FLOAT,
"direct_primary_energy_consumption_twh" FLOAT,
"fossil_generation_twh" FLOAT,
"fossil_share_of_electricity_pct" FLOAT,
"gas_generation_twh" FLOAT,
"gas_share_of_electricity_pct" FLOAT,
"hydro_generation_twh" FLOAT,
"hydro_share_of_electricity_pct" FLOAT,
"low_carbon_generation_twh" FLOAT,
"low_carbon_share_of_electricity_pct" FLOAT,
"net_imports_share_of_demand_pct" FLOAT,
"nuclear_generation_twh" FLOAT,
"nuclear_share_of_electricity_pct" FLOAT,
"oil_generation_twh" FLOAT,
"oil_share_of_electricity_pct" FLOAT,
"other_renewables_excluding_bioenergy_generation_twh" FLOAT,
"other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT,
"other_renewables_including_bioenergy_generation_twh" FLOAT,
"other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT,
"per_capita_bioenergy_generation_kwh" FLOAT,
"per_capita_coal_generation_kwh" FLOAT,
"per_capita_fossil_generation_kwh" FLOAT,
"per_capita_gas_generation_kwh" FLOAT,
"per_capita_hydro_generation_kwh" FLOAT,
"per_capita_low_carbon_generation_kwh" FLOAT,
"per_capita_nuclear_generation_kwh" FLOAT,
"per_capita_oil_generation_kwh" FLOAT,
"per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT,
"per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT,
"per_capita_renewable_generation_kwh" FLOAT,
"per_capita_solar_and_wind_generation_kwh" FLOAT,
"per_capita_solar_generation_kwh" FLOAT,
"per_capita_total_demand_kwh" FLOAT,
"per_capita_total_generation_kwh" FLOAT,
"per_capita_wind_generation_kwh" FLOAT,
"population" BIGINT,
"primary_energy_consumption_twh" FLOAT,
"renewable_generation_twh" FLOAT,
"renewable_share_of_electricity_pct" FLOAT,
"solar_and_wind_generation_twh" FLOAT,
"solar_and_wind_share_of_electricity_pct" FLOAT,
"solar_generation_twh" FLOAT,
"solar_share_of_electricity_pct" FLOAT,
"total_demand_twh" FLOAT,
"total_electricity_share_of_primary_energy_pct" FLOAT,
"total_emissions_mtco2" FLOAT,
"total_generation_twh" FLOAT,
"total_net_imports_twh" FLOAT,
"wind_generation_twh" FLOAT,
"wind_share_of_electricity_pct" FLOAT
);
CREATE TABLE owid_electricity_mix_5 (
"country" VARCHAR,
"year" INTEGER,
"bioenergy_generation_twh" FLOAT,
"bioenergy_share_of_electricity_pct" FLOAT,
"co2_intensity_gco2_kwh" FLOAT,
"coal_generation_twh" FLOAT,
"coal_share_of_electricity_pct" FLOAT,
"direct_primary_energy_consumption_twh" FLOAT,
"fossil_generation_twh" FLOAT,
"fossil_share_of_electricity_pct" FLOAT,
"gas_generation_twh" FLOAT,
"gas_share_of_electricity_pct" FLOAT,
"hydro_generation_twh" FLOAT,
"hydro_share_of_electricity_pct" FLOAT,
"low_carbon_generation_twh" FLOAT,
"low_carbon_share_of_electricity_pct" FLOAT,
"net_imports_share_of_demand_pct" FLOAT,
"nuclear_generation_twh" FLOAT,
"nuclear_share_of_electricity_pct" FLOAT,
"oil_generation_twh" FLOAT,
"oil_share_of_electricity_pct" FLOAT,
"other_renewables_excluding_bioenergy_generation_twh" FLOAT,
"other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT,
"other_renewables_including_bioenergy_generation_twh" FLOAT,
"other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT,
"per_capita_bioenergy_generation_kwh" FLOAT,
"per_capita_coal_generation_kwh" FLOAT,
"per_capita_fossil_generation_kwh" FLOAT,
"per_capita_gas_generation_kwh" FLOAT,
"per_capita_hydro_generation_kwh" FLOAT,
"per_capita_low_carbon_generation_kwh" FLOAT,
"per_capita_nuclear_generation_kwh" FLOAT,
"per_capita_oil_generation_kwh" FLOAT,
"per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT,
"per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT,
"per_capita_renewable_generation_kwh" FLOAT,
"per_capita_solar_and_wind_generation_kwh" FLOAT,
"per_capita_solar_generation_kwh" FLOAT,
"per_capita_total_demand_kwh" FLOAT,
"per_capita_total_generation_kwh" FLOAT,
"per_capita_wind_generation_kwh" FLOAT,
"population" BIGINT,
"primary_energy_consumption_twh" FLOAT,
"renewable_generation_twh" FLOAT,
"renewable_share_of_electricity_pct" FLOAT,
"solar_and_wind_generation_twh" FLOAT,
"solar_and_wind_share_of_electricity_pct" FLOAT,
"solar_generation_twh" FLOAT,
"solar_share_of_electricity_pct" FLOAT,
"total_demand_twh" FLOAT,
"total_electricity_share_of_primary_energy_pct" FLOAT,
"total_emissions_mtco2" FLOAT,
"total_generation_twh" FLOAT,
"total_net_imports_twh" FLOAT,
"wind_generation_twh" FLOAT,
"wind_share_of_electricity_pct" FLOAT
);
Anyone who has the link will be able to view this.