Dataset: Yearly Electricity Data (Ember, 2023b)

About this Dataset

Yearly Electricity Data (Ember, 2023b)

Ember's latest yearly electricity generation, capacity, emissions and demand data from over 200 geographies.

This dataset contains yearly electricity generation, capacity, emissions, import and demand data for over 200 geographies. Data is collected from multi-country datasets (EIA, Eurostat, BP, UN) as well as national sources (e.g China data from the National Bureau of Statistics).

You can find more about Ember's methodology in this document: https://ember-climate.org/app/uploads/2022/07/Ember-Electricity-Data-Methodology.pdf

Tables

Capacity

@owid.yearly_electricity.owid_capacity_1

141.3 KB
5317 rows
17 columns


CREATE TABLE owid_capacity_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_gw" FLOAT,
  "clean_gw" FLOAT,
  "coal_gw" FLOAT,
  "fossil_gw" FLOAT,
  "gas_gw" FLOAT,
  "gas_and_other_fossil_gw" FLOAT,
  "hydro_gw" FLOAT,
  "hydro_bioenergy_and_other_renewables_gw" FLOAT,
  "nuclear_gw" FLOAT,
  "other_fossil_gw" FLOAT,
  "other_renewables_gw" FLOAT,
  "renewables_gw" FLOAT,
  "solar_gw" FLOAT,
  "wind_gw" FLOAT,
  "wind_and_solar_gw" FLOAT
);

Capacity

@owid.yearly_electricity.owid_capacity_2

140.81 KB
5324 rows
17 columns


CREATE TABLE owid_capacity_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_gw" FLOAT,
  "clean_gw" FLOAT,
  "coal_gw" FLOAT,
  "fossil_gw" FLOAT,
  "gas_gw" FLOAT,
  "gas_and_other_fossil_gw" FLOAT,
  "hydro_gw" FLOAT,
  "hydro_bioenergy_and_other_renewables_gw" FLOAT,
  "nuclear_gw" FLOAT,
  "other_fossil_gw" FLOAT,
  "other_renewables_gw" FLOAT,
  "renewables_gw" FLOAT,
  "solar_gw" FLOAT,
  "wind_gw" FLOAT,
  "wind_and_solar_gw" FLOAT
);

Electricity Demand

@owid.yearly_electricity.owid_electricity_demand_1

90.49 KB
5317 rows
5 columns


CREATE TABLE owid_electricity_demand_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_twh" FLOAT,
  "population" BIGINT,
  "demand_per_capita_kwh" FLOAT
);

Electricity Demand

@owid.yearly_electricity.owid_electricity_demand_2

90.52 KB
5324 rows
5 columns


CREATE TABLE owid_electricity_demand_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_twh" FLOAT,
  "population" BIGINT,
  "demand_per_capita_kwh" FLOAT
);

Electricity Generation

@owid.yearly_electricity.owid_electricity_generation_1

407.49 KB
5317 rows
33 columns


CREATE TABLE owid_electricity_generation_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_pct" FLOAT,
  "bioenergy_twh" FLOAT,
  "clean_pct" FLOAT,
  "clean_twh" FLOAT,
  "coal_pct" FLOAT,
  "coal_twh" FLOAT,
  "fossil_pct" FLOAT,
  "fossil_twh" FLOAT,
  "gas_pct" FLOAT,
  "gas_twh" FLOAT,
  "gas_and_other_fossil_pct" FLOAT,
  "gas_and_other_fossil_twh" FLOAT,
  "hydro_pct" FLOAT,
  "hydro_twh" FLOAT,
  "hydro_bioenergy_and_other_renewables_pct" FLOAT,
  "hydro_bioenergy_and_other_renewables_twh" FLOAT,
  "nuclear_pct" FLOAT,
  "nuclear_twh" FLOAT,
  "other_fossil_pct" FLOAT,
  "other_fossil_twh" FLOAT,
  "other_renewables_pct" FLOAT,
  "other_renewables_twh" FLOAT,
  "renewables_pct" FLOAT,
  "renewables_twh" FLOAT,
  "solar_pct" FLOAT,
  "solar_twh" FLOAT,
  "total_generation_twh" FLOAT,
  "wind_pct" FLOAT,
  "wind_twh" FLOAT,
  "wind_and_solar_pct" FLOAT,
  "wind_and_solar_twh" FLOAT
);

Electricity Generation

@owid.yearly_electricity.owid_electricity_generation_2

408.6 KB
5324 rows
33 columns


CREATE TABLE owid_electricity_generation_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_pct" FLOAT,
  "bioenergy_twh" FLOAT,
  "clean_pct" FLOAT,
  "clean_twh" FLOAT,
  "coal_pct" FLOAT,
  "coal_twh" FLOAT,
  "fossil_pct" FLOAT,
  "fossil_twh" FLOAT,
  "gas_pct" FLOAT,
  "gas_twh" FLOAT,
  "gas_and_other_fossil_pct" FLOAT,
  "gas_and_other_fossil_twh" FLOAT,
  "hydro_pct" FLOAT,
  "hydro_twh" FLOAT,
  "hydro_bioenergy_and_other_renewables_pct" FLOAT,
  "hydro_bioenergy_and_other_renewables_twh" FLOAT,
  "nuclear_pct" FLOAT,
  "nuclear_twh" FLOAT,
  "other_fossil_pct" FLOAT,
  "other_fossil_twh" FLOAT,
  "other_renewables_pct" FLOAT,
  "other_renewables_twh" FLOAT,
  "renewables_pct" FLOAT,
  "renewables_twh" FLOAT,
  "solar_pct" FLOAT,
  "solar_twh" FLOAT,
  "total_generation_twh" FLOAT,
  "wind_pct" FLOAT,
  "wind_twh" FLOAT,
  "wind_and_solar_pct" FLOAT,
  "wind_and_solar_twh" FLOAT
);

Electricity Imports

@owid.yearly_electricity.owid_electricity_imports_1

16.53 KB
5317 rows
3 columns


CREATE TABLE owid_electricity_imports_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "net_imports_twh" FLOAT
);

Electricity Imports

@owid.yearly_electricity.owid_electricity_imports_2

16.51 KB
5324 rows
3 columns


CREATE TABLE owid_electricity_imports_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "net_imports_twh" FLOAT
);

Power Sector Emissions

@owid.yearly_electricity.owid_power_sector_emissions_1

198.79 KB
5317 rows
20 columns


CREATE TABLE owid_power_sector_emissions_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_mtco2" FLOAT,
  "clean_mtco2" FLOAT,
  "coal_mtco2" FLOAT,
  "fossil_mtco2" FLOAT,
  "gas_mtco2" FLOAT,
  "gas_and_other_fossil_mtco2" FLOAT,
  "hydro_mtco2" FLOAT,
  "hydro_bioenergy_and_other_renewables_mtco2" FLOAT,
  "nuclear_mtco2" FLOAT,
  "other_fossil_mtco2" FLOAT,
  "other_renewables_mtco2" FLOAT,
  "renewables_mtco2" FLOAT,
  "solar_mtco2" FLOAT,
  "total_emissions_mtco2" FLOAT,
  "wind_mtco2" FLOAT,
  "wind_and_solar_mtco2" FLOAT,
  "total_generation_twh" FLOAT,
  "co2_intensity_gco2_kwh" FLOAT
);

Power Sector Emissions

@owid.yearly_electricity.owid_power_sector_emissions_2

198.77 KB
5324 rows
20 columns


CREATE TABLE owid_power_sector_emissions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_mtco2" FLOAT,
  "clean_mtco2" FLOAT,
  "coal_mtco2" FLOAT,
  "fossil_mtco2" FLOAT,
  "gas_mtco2" FLOAT,
  "gas_and_other_fossil_mtco2" FLOAT,
  "hydro_mtco2" FLOAT,
  "hydro_bioenergy_and_other_renewables_mtco2" FLOAT,
  "nuclear_mtco2" FLOAT,
  "other_fossil_mtco2" FLOAT,
  "other_renewables_mtco2" FLOAT,
  "renewables_mtco2" FLOAT,
  "solar_mtco2" FLOAT,
  "total_emissions_mtco2" FLOAT,
  "wind_mtco2" FLOAT,
  "wind_and_solar_mtco2" FLOAT,
  "total_generation_twh" FLOAT,
  "co2_intensity_gco2_kwh" FLOAT
);

Yearly Electricity

@owid.yearly_electricity.owid_yearly_electricity_1

863.99 KB
5934 rows
68 columns


CREATE TABLE owid_yearly_electricity_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT,
  "capacity_clean_gw" FLOAT,
  "capacity_coal_gw" FLOAT,
  "capacity_fossil_gw" FLOAT,
  "capacity_gas_gw" FLOAT,
  "capacity_gas_and_other_fossil_gw" FLOAT,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT,
  "capacity_hydro_gw" FLOAT,
  "capacity_nuclear_gw" FLOAT,
  "capacity_other_fossil_gw" FLOAT,
  "capacity_other_renewables_gw" FLOAT,
  "capacity_renewables_gw" FLOAT,
  "capacity_solar_gw" FLOAT,
  "capacity_wind_gw" FLOAT,
  "capacity_wind_and_solar_gw" FLOAT,
  "demand_total_demand_twh" FLOAT,
  "demand_total_demand_per_capita_kwh" FLOAT,
  "emissions_bioenergy_mtco2" FLOAT,
  "emissions_clean_mtco2" FLOAT,
  "emissions_co2_intensity_gco2_kwh" FLOAT,
  "emissions_coal_mtco2" FLOAT,
  "emissions_fossil_mtco2" FLOAT,
  "emissions_gas_mtco2" FLOAT,
  "emissions_gas_and_other_fossil_mtco2" FLOAT,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT,
  "emissions_hydro_mtco2" FLOAT,
  "emissions_nuclear_mtco2" FLOAT,
  "emissions_other_fossil_mtco2" FLOAT,
  "emissions_other_renewables_mtco2" FLOAT,
  "emissions_renewables_mtco2" FLOAT,
  "emissions_solar_mtco2" FLOAT,
  "emissions_total_emissions_mtco2" FLOAT,
  "emissions_wind_mtco2" FLOAT,
  "emissions_wind_and_solar_mtco2" FLOAT,
  "generation_bioenergy_pct" FLOAT,
  "generation_bioenergy_twh" FLOAT,
  "generation_clean_pct" FLOAT,
  "generation_clean_twh" FLOAT,
  "generation_coal_pct" FLOAT,
  "generation_coal_twh" FLOAT,
  "generation_fossil_pct" FLOAT,
  "generation_fossil_twh" FLOAT,
  "generation_gas_pct" FLOAT,
  "generation_gas_twh" FLOAT,
  "generation_gas_and_other_fossil_pct" FLOAT,
  "generation_gas_and_other_fossil_twh" FLOAT,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT,
  "generation_hydro_pct" FLOAT,
  "generation_hydro_twh" FLOAT,
  "generation_nuclear_pct" FLOAT,
  "generation_nuclear_twh" FLOAT,
  "generation_other_fossil_pct" FLOAT,
  "generation_other_fossil_twh" FLOAT,
  "generation_other_renewables_pct" FLOAT,
  "generation_other_renewables_twh" FLOAT,
  "generation_renewables_pct" FLOAT,
  "generation_renewables_twh" FLOAT,
  "generation_solar_pct" FLOAT,
  "generation_solar_twh" FLOAT,
  "generation_total_generation_twh" FLOAT,
  "generation_wind_pct" FLOAT,
  "generation_wind_twh" FLOAT,
  "generation_wind_and_solar_pct" FLOAT,
  "generation_wind_and_solar_twh" FLOAT,
  "imports_total_net_imports_twh" FLOAT
);

Yearly Electricity

@owid.yearly_electricity.owid_yearly_electricity_2

999.79 KB
6166 rows
96 columns


CREATE TABLE owid_yearly_electricity_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT,
  "capacity_clean_gw" FLOAT,
  "capacity_coal_gw" FLOAT,
  "capacity_fossil_gw" FLOAT,
  "capacity_gas_gw" FLOAT,
  "capacity_gas_and_other_fossil_gw" FLOAT,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT,
  "capacity_hydro_gw" FLOAT,
  "capacity_nuclear_gw" FLOAT,
  "capacity_other_fossil_gw" FLOAT,
  "capacity_other_renewables_gw" FLOAT,
  "capacity_renewables_gw" FLOAT,
  "capacity_solar_gw" FLOAT,
  "capacity_wind_gw" FLOAT,
  "capacity_wind_and_solar_gw" FLOAT,
  "demand_total_demand_twh" FLOAT,
  "demand_total_demand_per_capita_kwh" FLOAT,
  "emissions_bioenergy_mtco2" FLOAT,
  "emissions_bioenergy_mtco2e" FLOAT,
  "emissions_clean_mtco2" FLOAT,
  "emissions_clean_mtco2e" FLOAT,
  "emissions_co2_intensity_gco2_kwh" FLOAT,
  "emissions_co2_intensity_gco2e_per_kwh" FLOAT,
  "emissions_coal_mtco2" FLOAT,
  "emissions_coal_mtco2e" FLOAT,
  "emissions_fossil_mtco2" FLOAT,
  "emissions_fossil_mtco2e" FLOAT,
  "emissions_gas_mtco2" FLOAT,
  "emissions_gas_mtco2e" FLOAT,
  "emissions_gas_and_other_fossil_mtco2" FLOAT,
  "emissions_gas_and_other_fossil_mtco2e" FLOAT,
  "emissions_hard_coal_mtco2e" FLOAT,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2e" FLOAT,
  "emissions_hydro_mtco2" FLOAT,
  "emissions_hydro_mtco2e" FLOAT,
  "emissions_lignite_mtco2e" FLOAT,
  "emissions_nuclear_mtco2" FLOAT,
  "emissions_nuclear_mtco2e" FLOAT,
  "emissions_offshore_wind_mtco2e" FLOAT,
  "emissions_onshore_wind_mtco2e" FLOAT,
  "emissions_other_fossil_mtco2" FLOAT,
  "emissions_other_fossil_mtco2e" FLOAT,
  "emissions_other_renewables_mtco2" FLOAT,
  "emissions_other_renewables_mtco2e" FLOAT,
  "emissions_renewables_mtco2" FLOAT,
  "emissions_renewables_mtco2e" FLOAT,
  "emissions_solar_mtco2" FLOAT,
  "emissions_solar_mtco2e" FLOAT,
  "emissions_total_emissions_mtco2" FLOAT,
  "emissions_wind_mtco2" FLOAT,
  "emissions_wind_mtco2e" FLOAT,
  "emissions_wind_and_solar_mtco2" FLOAT,
  "emissions_wind_and_solar_mtco2e" FLOAT,
  "generation_bioenergy_pct" FLOAT,
  "generation_bioenergy_twh" FLOAT,
  "generation_clean_pct" FLOAT,
  "generation_clean_twh" FLOAT,
  "generation_coal_pct" FLOAT,
  "generation_coal_twh" FLOAT,
  "generation_fossil_pct" FLOAT,
  "generation_fossil_twh" FLOAT,
  "generation_gas_pct" FLOAT,
  "generation_gas_twh" FLOAT,
  "generation_gas_and_other_fossil_pct" FLOAT,
  "generation_gas_and_other_fossil_twh" FLOAT,
  "generation_hard_coal_pct" FLOAT,
  "generation_hard_coal_twh" FLOAT,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT,
  "generation_hydro_pct" FLOAT,
  "generation_hydro_twh" FLOAT,
  "generation_lignite_pct" FLOAT,
  "generation_lignite_twh" FLOAT,
  "generation_nuclear_pct" FLOAT,
  "generation_nuclear_twh" FLOAT,
  "generation_offshore_wind_pct" FLOAT,
  "generation_offshore_wind_twh" FLOAT,
  "generation_onshore_wind_pct" FLOAT,
  "generation_onshore_wind_twh" FLOAT,
  "generation_other_fossil_pct" FLOAT,
  "generation_other_fossil_twh" FLOAT,
  "generation_other_renewables_pct" FLOAT,
  "generation_other_renewables_twh" FLOAT,
  "generation_renewables_pct" FLOAT,
  "generation_renewables_twh" FLOAT,
  "generation_solar_pct" FLOAT,
  "generation_solar_twh" FLOAT,
  "generation_total_generation_twh" FLOAT,
  "generation_wind_pct" FLOAT,
  "generation_wind_twh" FLOAT,
  "generation_wind_and_solar_pct" FLOAT,
  "generation_wind_and_solar_twh" FLOAT,
  "imports_total_net_imports_twh" FLOAT
);