Baselight
Sign In

Combined Electricity Data (Ember, 2023c)

@owid.combined_electricity

Loading...
Loading...

About this Dataset

Combined Electricity Data (Ember, 2023c)

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

Electricity

@owid.combined_electricity.owid_combined_electricity_1
  • 834.97 KB
  • 5667 rows
  • 72 columns
Loading... 

CREATE TABLE owid_combined_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_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_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 Data

@owid.combined_electricity.owid_combined_electricity_2
  • 835.14 KB
  • 5674 rows
  • 72 columns
Loading... 

CREATE TABLE owid_combined_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_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_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_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
);

European Electricity Review

@owid.combined_electricity.owid_european_electricity_review_1
  • 186.89 KB
  • 1156 rows
  • 42 columns
Loading... 

CREATE TABLE owid_european_electricity_review_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_total_demand_twh" FLOAT,
  "demand_total_demand_per_capita_kwh" FLOAT,
  "emissions_co2_intensity_gco2_kwh" INTEGER,
  "emissions_total_emissions_mtco2" INTEGER,
  "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_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
);

European Electricity Review

@owid.combined_electricity.owid_european_electricity_review_2
  • 186.89 KB
  • 1156 rows
  • 42 columns
Loading... 

CREATE TABLE owid_european_electricity_review_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_total_demand_twh" FLOAT,
  "demand_total_demand_per_capita_kwh" FLOAT,
  "emissions_co2_intensity_gco2_kwh" INTEGER,
  "emissions_total_emissions_mtco2" INTEGER,
  "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_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
);

Net Flows

@owid.combined_electricity.owid_net_flows_1
  • 9.9 KB
  • 1072 rows
  • 4 columns
Loading... 

CREATE TABLE owid_net_flows_1 (
  "source_country" VARCHAR,
  "target_country" VARCHAR,
  "year" INTEGER,
  "net_flow_twh" FLOAT
);

Net Flows

@owid.combined_electricity.owid_net_flows_2
  • 9.9 KB
  • 1072 rows
  • 4 columns
Loading... 

CREATE TABLE owid_net_flows_2 (
  "source_country" VARCHAR,
  "target_country" VARCHAR,
  "year" INTEGER,
  "net_flow_twh" FLOAT
);

Yearly Electricity Data

@owid.combined_electricity.owid_yearly_electricity_1
  • 781 KB
  • 5317 rows
  • 68 columns
Loading... 

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 Data

@owid.combined_electricity.owid_yearly_electricity_2
  • 781.71 KB
  • 5324 rows
  • 68 columns
Loading... 

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

Share link

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