Baselight

Electricity Mix (EI & Ember, 2023)

@owid.electricity_mix

Loading...
Loading...

About this Dataset

Electricity Mix (EI & Ember, 2023)

Data is compiled by Our World in Data based on three main sources:

Ember compile their global dataset from various sources including:

  • Eurostat: Annual European generation and import data, and monthly data in some cases where better sources are not available.
  • ENTSO-E: Monthly European generation and import data.
  • EIA: Annual global generation and import data.
  • UN: Monthly global generation data in some cases.
  • GEM: Annual global coal and gas capacity data.
  • IRENA: Annual global capacity data for all non-fossil fuel types, and for Other Fossil where available.
  • WRI: Annual global capacity data for Other Fossil where other sources are not available.
  • European carbon intensities rely on data from the European Environment Agency (EEA).
  • A complete list of data sources for each individual country in Ember's Yearly Electricity Data can be found here.
  • A complete list of data sources for each individual country in Ember's European Electricity Review can be found here.

We rely on Ember as the primary source of electricity consumption data. While EI provides primary energy (not just electricity) consumption data and it provides a longer time-series (dating back to 1965) than Ember (which only dates back to 1990), EI does not provide data for all countries or for all sources of electricity (for example, only Ember provides data on electricity from bioenergy). So, where data from Ember is available for a given country and year, we rely on it as the primary source. We then supplement this with data from EI where data from Ember is not available.

Tables

Electricity

@owid.electricity_mix.owid_electricity_mix_1
  • 1.14 MB
  • 9904 rows
  • 54 columns
Loading...

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
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_2
  • 1.17 MB
  • 9908 rows
  • 55 columns
Loading...

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
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_3
  • 1.22 MB
  • 10084 rows
  • 55 columns
Loading...

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
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_4
  • 1.25 MB
  • 10139 rows
  • 56 columns
Loading...

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
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_5
  • 1.29 MB
  • 10347 rows
  • 56 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.