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

855.01 kB
5,667 rows
72 columns

CREATE TABLE owid_combined_electricity_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT  -- Capacity, Bioenergy, Gw,
  "capacity_clean_gw" FLOAT  -- Capacity, Clean, Gw,
  "capacity_coal_gw" FLOAT  -- Capacity, Coal, Gw,
  "capacity_fossil_gw" FLOAT  -- Capacity, Fossil, Gw,
  "capacity_gas_gw" FLOAT  -- Capacity, Gas, Gw,
  "capacity_gas_and_other_fossil_gw" FLOAT  -- Capacity, Gas And Other Fossil, Gw,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT  -- Capacity, Hydro, Bioenergy And Other Renewables, Gw,
  "capacity_hydro_gw" FLOAT  -- Capacity, Hydro, Gw,
  "capacity_nuclear_gw" FLOAT  -- Capacity, Nuclear, Gw,
  "capacity_other_fossil_gw" FLOAT  -- Capacity, Other Fossil, Gw,
  "capacity_other_renewables_gw" FLOAT  -- Capacity, Other Renewables, Gw,
  "capacity_renewables_gw" FLOAT  -- Capacity, Renewables, Gw,
  "capacity_solar_gw" FLOAT  -- Capacity, Solar, Gw,
  "capacity_wind_gw" FLOAT  -- Capacity, Wind, Gw,
  "capacity_wind_and_solar_gw" FLOAT  -- Capacity, Wind And Solar, Gw,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_bioenergy_mtco2" FLOAT  -- Emissions, Bioenergy, Mtco2,
  "emissions_clean_mtco2" FLOAT  -- Emissions, Clean, Mtco2,
  "emissions_co2_intensity_gco2_kwh" FLOAT  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_coal_mtco2" FLOAT  -- Emissions, Coal, Mtco2,
  "emissions_fossil_mtco2" FLOAT  -- Emissions, Fossil, Mtco2,
  "emissions_gas_mtco2" FLOAT  -- Emissions, Gas, Mtco2,
  "emissions_gas_and_other_fossil_mtco2" FLOAT  -- Emissions, Gas And Other Fossil, Mtco2,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT  -- Emissions, Hydro, Bioenergy And Other Renewables, Mtco2,
  "emissions_hydro_mtco2" FLOAT  -- Emissions, Hydro, Mtco2,
  "emissions_nuclear_mtco2" FLOAT  -- Emissions, Nuclear, Mtco2,
  "emissions_other_fossil_mtco2" FLOAT  -- Emissions, Other Fossil, Mtco2,
  "emissions_other_renewables_mtco2" FLOAT  -- Emissions, Other Renewables, Mtco2,
  "emissions_renewables_mtco2" FLOAT  -- Emissions, Renewables, Mtco2,
  "emissions_solar_mtco2" FLOAT  -- Emissions, Solar, Mtco2,
  "emissions_total_emissions_mtco2" FLOAT  -- Emissions, Total Emissions, Mtco2,
  "emissions_wind_mtco2" FLOAT  -- Emissions, Wind, Mtco2,
  "emissions_wind_and_solar_mtco2" FLOAT  -- Emissions, Wind And Solar, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hard_coal_pct" FLOAT  -- Generation, Hard Coal, Pct,
  "generation_hard_coal_twh" FLOAT  -- Generation, Hard Coal, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_lignite_pct" FLOAT  -- Generation, Lignite, Pct,
  "generation_lignite_twh" FLOAT  -- Generation, Lignite, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);

Yearly Electricity Data

@owid.combined_electricity.owid_combined_electricity_2

855.18 kB
5,674 rows
72 columns

CREATE TABLE owid_combined_electricity_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT  -- Capacity, Bioenergy, Gw,
  "capacity_clean_gw" FLOAT  -- Capacity, Clean, Gw,
  "capacity_coal_gw" FLOAT  -- Capacity, Coal, Gw,
  "capacity_fossil_gw" FLOAT  -- Capacity, Fossil, Gw,
  "capacity_gas_gw" FLOAT  -- Capacity, Gas, Gw,
  "capacity_gas_and_other_fossil_gw" FLOAT  -- Capacity, Gas And Other Fossil, Gw,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT  -- Capacity, Hydro, Bioenergy And Other Renewables, Gw,
  "capacity_hydro_gw" FLOAT  -- Capacity, Hydro, Gw,
  "capacity_nuclear_gw" FLOAT  -- Capacity, Nuclear, Gw,
  "capacity_other_fossil_gw" FLOAT  -- Capacity, Other Fossil, Gw,
  "capacity_other_renewables_gw" FLOAT  -- Capacity, Other Renewables, Gw,
  "capacity_renewables_gw" FLOAT  -- Capacity, Renewables, Gw,
  "capacity_solar_gw" FLOAT  -- Capacity, Solar, Gw,
  "capacity_wind_gw" FLOAT  -- Capacity, Wind, Gw,
  "capacity_wind_and_solar_gw" FLOAT  -- Capacity, Wind And Solar, Gw,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_bioenergy_mtco2" FLOAT  -- Emissions, Bioenergy, Mtco2,
  "emissions_clean_mtco2" FLOAT  -- Emissions, Clean, Mtco2,
  "emissions_co2_intensity_gco2_kwh" FLOAT  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_coal_mtco2" FLOAT  -- Emissions, Coal, Mtco2,
  "emissions_fossil_mtco2" FLOAT  -- Emissions, Fossil, Mtco2,
  "emissions_gas_mtco2" FLOAT  -- Emissions, Gas, Mtco2,
  "emissions_gas_and_other_fossil_mtco2" FLOAT  -- Emissions, Gas And Other Fossil, Mtco2,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT  -- Emissions, Hydro, Bioenergy And Other Renewables, Mtco2,
  "emissions_hydro_mtco2" FLOAT  -- Emissions, Hydro, Mtco2,
  "emissions_nuclear_mtco2" FLOAT  -- Emissions, Nuclear, Mtco2,
  "emissions_other_fossil_mtco2" FLOAT  -- Emissions, Other Fossil, Mtco2,
  "emissions_other_renewables_mtco2" FLOAT  -- Emissions, Other Renewables, Mtco2,
  "emissions_renewables_mtco2" FLOAT  -- Emissions, Renewables, Mtco2,
  "emissions_solar_mtco2" FLOAT  -- Emissions, Solar, Mtco2,
  "emissions_total_emissions_mtco2" FLOAT  -- Emissions, Total Emissions, Mtco2,
  "emissions_wind_mtco2" FLOAT  -- Emissions, Wind, Mtco2,
  "emissions_wind_and_solar_mtco2" FLOAT  -- Emissions, Wind And Solar, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hard_coal_pct" FLOAT  -- Generation, Hard Coal, Pct,
  "generation_hard_coal_twh" FLOAT  -- Generation, Hard Coal, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_lignite_pct" FLOAT  -- Generation, Lignite, Pct,
  "generation_lignite_twh" FLOAT  -- Generation, Lignite, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);

European Electricity Review

@owid.combined_electricity.owid_european_electricity_review_1

191.38 kB
1,156 rows
42 columns

CREATE TABLE owid_european_electricity_review_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_co2_intensity_gco2_kwh" INTEGER  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_total_emissions_mtco2" INTEGER  -- Emissions, Total Emissions, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hard_coal_pct" FLOAT  -- Generation, Hard Coal, Pct,
  "generation_hard_coal_twh" FLOAT  -- Generation, Hard Coal, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_lignite_pct" FLOAT  -- Generation, Lignite, Pct,
  "generation_lignite_twh" FLOAT  -- Generation, Lignite, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);

European Electricity Review

@owid.combined_electricity.owid_european_electricity_review_2

191.38 kB
1,156 rows
42 columns

CREATE TABLE owid_european_electricity_review_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_co2_intensity_gco2_kwh" INTEGER  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_total_emissions_mtco2" INTEGER  -- Emissions, Total Emissions, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hard_coal_pct" FLOAT  -- Generation, Hard Coal, Pct,
  "generation_hard_coal_twh" FLOAT  -- Generation, Hard Coal, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_lignite_pct" FLOAT  -- Generation, Lignite, Pct,
  "generation_lignite_twh" FLOAT  -- Generation, Lignite, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);

Net Flows

@owid.combined_electricity.owid_net_flows_1

10.14 kB
1,072 rows
4 columns

CREATE TABLE owid_net_flows_1 (
  "source_country" VARCHAR,
  "target_country" VARCHAR,
  "year" INTEGER,
  "net_flow_twh" FLOAT  -- Net Flow, Twh
);

Net Flows

@owid.combined_electricity.owid_net_flows_2

10.14 kB
1,072 rows
4 columns

CREATE TABLE owid_net_flows_2 (
  "source_country" VARCHAR,
  "target_country" VARCHAR,
  "year" INTEGER,
  "net_flow_twh" FLOAT  -- Net Flow, Twh
);

Yearly Electricity Data

@owid.combined_electricity.owid_yearly_electricity_1

799.74 kB
5,317 rows
68 columns

CREATE TABLE owid_yearly_electricity_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT  -- Capacity, Bioenergy, Gw,
  "capacity_clean_gw" FLOAT  -- Capacity, Clean, Gw,
  "capacity_coal_gw" FLOAT  -- Capacity, Coal, Gw,
  "capacity_fossil_gw" FLOAT  -- Capacity, Fossil, Gw,
  "capacity_gas_gw" FLOAT  -- Capacity, Gas, Gw,
  "capacity_gas_and_other_fossil_gw" FLOAT  -- Capacity, Gas And Other Fossil, Gw,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT  -- Capacity, Hydro, Bioenergy And Other Renewables, Gw,
  "capacity_hydro_gw" FLOAT  -- Capacity, Hydro, Gw,
  "capacity_nuclear_gw" FLOAT  -- Capacity, Nuclear, Gw,
  "capacity_other_fossil_gw" FLOAT  -- Capacity, Other Fossil, Gw,
  "capacity_other_renewables_gw" FLOAT  -- Capacity, Other Renewables, Gw,
  "capacity_renewables_gw" FLOAT  -- Capacity, Renewables, Gw,
  "capacity_solar_gw" FLOAT  -- Capacity, Solar, Gw,
  "capacity_wind_gw" FLOAT  -- Capacity, Wind, Gw,
  "capacity_wind_and_solar_gw" FLOAT  -- Capacity, Wind And Solar, Gw,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_bioenergy_mtco2" FLOAT  -- Emissions, Bioenergy, Mtco2,
  "emissions_clean_mtco2" FLOAT  -- Emissions, Clean, Mtco2,
  "emissions_co2_intensity_gco2_kwh" FLOAT  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_coal_mtco2" FLOAT  -- Emissions, Coal, Mtco2,
  "emissions_fossil_mtco2" FLOAT  -- Emissions, Fossil, Mtco2,
  "emissions_gas_mtco2" FLOAT  -- Emissions, Gas, Mtco2,
  "emissions_gas_and_other_fossil_mtco2" FLOAT  -- Emissions, Gas And Other Fossil, Mtco2,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT  -- Emissions, Hydro, Bioenergy And Other Renewables, Mtco2,
  "emissions_hydro_mtco2" FLOAT  -- Emissions, Hydro, Mtco2,
  "emissions_nuclear_mtco2" FLOAT  -- Emissions, Nuclear, Mtco2,
  "emissions_other_fossil_mtco2" FLOAT  -- Emissions, Other Fossil, Mtco2,
  "emissions_other_renewables_mtco2" FLOAT  -- Emissions, Other Renewables, Mtco2,
  "emissions_renewables_mtco2" FLOAT  -- Emissions, Renewables, Mtco2,
  "emissions_solar_mtco2" FLOAT  -- Emissions, Solar, Mtco2,
  "emissions_total_emissions_mtco2" FLOAT  -- Emissions, Total Emissions, Mtco2,
  "emissions_wind_mtco2" FLOAT  -- Emissions, Wind, Mtco2,
  "emissions_wind_and_solar_mtco2" FLOAT  -- Emissions, Wind And Solar, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);

Yearly Electricity Data

@owid.combined_electricity.owid_yearly_electricity_2

800.47 kB
5,324 rows
68 columns

CREATE TABLE owid_yearly_electricity_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "capacity_bioenergy_gw" FLOAT  -- Capacity, Bioenergy, Gw,
  "capacity_clean_gw" FLOAT  -- Capacity, Clean, Gw,
  "capacity_coal_gw" FLOAT  -- Capacity, Coal, Gw,
  "capacity_fossil_gw" FLOAT  -- Capacity, Fossil, Gw,
  "capacity_gas_gw" FLOAT  -- Capacity, Gas, Gw,
  "capacity_gas_and_other_fossil_gw" FLOAT  -- Capacity, Gas And Other Fossil, Gw,
  "capacity_hydro_bioenergy_and_other_renewables_gw" FLOAT  -- Capacity, Hydro, Bioenergy And Other Renewables, Gw,
  "capacity_hydro_gw" FLOAT  -- Capacity, Hydro, Gw,
  "capacity_nuclear_gw" FLOAT  -- Capacity, Nuclear, Gw,
  "capacity_other_fossil_gw" FLOAT  -- Capacity, Other Fossil, Gw,
  "capacity_other_renewables_gw" FLOAT  -- Capacity, Other Renewables, Gw,
  "capacity_renewables_gw" FLOAT  -- Capacity, Renewables, Gw,
  "capacity_solar_gw" FLOAT  -- Capacity, Solar, Gw,
  "capacity_wind_gw" FLOAT  -- Capacity, Wind, Gw,
  "capacity_wind_and_solar_gw" FLOAT  -- Capacity, Wind And Solar, Gw,
  "demand_total_demand_twh" FLOAT  -- Demand, Total Demand, Twh,
  "demand_total_demand_per_capita_kwh" FLOAT  -- Demand, Total Demand Per Capita, Kwh,
  "emissions_bioenergy_mtco2" FLOAT  -- Emissions, Bioenergy, Mtco2,
  "emissions_clean_mtco2" FLOAT  -- Emissions, Clean, Mtco2,
  "emissions_co2_intensity_gco2_kwh" FLOAT  -- Emissions, Co2 Intensity, Gco2 Kwh,
  "emissions_coal_mtco2" FLOAT  -- Emissions, Coal, Mtco2,
  "emissions_fossil_mtco2" FLOAT  -- Emissions, Fossil, Mtco2,
  "emissions_gas_mtco2" FLOAT  -- Emissions, Gas, Mtco2,
  "emissions_gas_and_other_fossil_mtco2" FLOAT  -- Emissions, Gas And Other Fossil, Mtco2,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT  -- Emissions, Hydro, Bioenergy And Other Renewables, Mtco2,
  "emissions_hydro_mtco2" FLOAT  -- Emissions, Hydro, Mtco2,
  "emissions_nuclear_mtco2" FLOAT  -- Emissions, Nuclear, Mtco2,
  "emissions_other_fossil_mtco2" FLOAT  -- Emissions, Other Fossil, Mtco2,
  "emissions_other_renewables_mtco2" FLOAT  -- Emissions, Other Renewables, Mtco2,
  "emissions_renewables_mtco2" FLOAT  -- Emissions, Renewables, Mtco2,
  "emissions_solar_mtco2" FLOAT  -- Emissions, Solar, Mtco2,
  "emissions_total_emissions_mtco2" FLOAT  -- Emissions, Total Emissions, Mtco2,
  "emissions_wind_mtco2" FLOAT  -- Emissions, Wind, Mtco2,
  "emissions_wind_and_solar_mtco2" FLOAT  -- Emissions, Wind And Solar, Mtco2,
  "generation_bioenergy_pct" FLOAT  -- Generation, Bioenergy, Pct,
  "generation_bioenergy_twh" FLOAT  -- Generation, Bioenergy, Twh,
  "generation_clean_pct" FLOAT  -- Generation, Clean, Pct,
  "generation_clean_twh" FLOAT  -- Generation, Clean, Twh,
  "generation_coal_pct" FLOAT  -- Generation, Coal, Pct,
  "generation_coal_twh" FLOAT  -- Generation, Coal, Twh,
  "generation_fossil_pct" FLOAT  -- Generation, Fossil, Pct,
  "generation_fossil_twh" FLOAT  -- Generation, Fossil, Twh,
  "generation_gas_pct" FLOAT  -- Generation, Gas, Pct,
  "generation_gas_twh" FLOAT  -- Generation, Gas, Twh,
  "generation_gas_and_other_fossil_pct" FLOAT  -- Generation, Gas And Other Fossil, Pct,
  "generation_gas_and_other_fossil_twh" FLOAT  -- Generation, Gas And Other Fossil, Twh,
  "generation_hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Pct,
  "generation_hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Generation, Hydro, Bioenergy And Other Renewables, Twh,
  "generation_hydro_pct" FLOAT  -- Generation, Hydro, Pct,
  "generation_hydro_twh" FLOAT  -- Generation, Hydro, Twh,
  "generation_nuclear_pct" FLOAT  -- Generation, Nuclear, Pct,
  "generation_nuclear_twh" FLOAT  -- Generation, Nuclear, Twh,
  "generation_other_fossil_pct" FLOAT  -- Generation, Other Fossil, Pct,
  "generation_other_fossil_twh" FLOAT  -- Generation, Other Fossil, Twh,
  "generation_other_renewables_pct" FLOAT  -- Generation, Other Renewables, Pct,
  "generation_other_renewables_twh" FLOAT  -- Generation, Other Renewables, Twh,
  "generation_renewables_pct" FLOAT  -- Generation, Renewables, Pct,
  "generation_renewables_twh" FLOAT  -- Generation, Renewables, Twh,
  "generation_solar_pct" FLOAT  -- Generation, Solar, Pct,
  "generation_solar_twh" FLOAT  -- Generation, Solar, Twh,
  "generation_total_generation_twh" FLOAT  -- Generation, Total Generation, Twh,
  "generation_wind_pct" FLOAT  -- Generation, Wind, Pct,
  "generation_wind_twh" FLOAT  -- Generation, Wind, Twh,
  "generation_wind_and_solar_pct" FLOAT  -- Generation, Wind And Solar, Pct,
  "generation_wind_and_solar_twh" FLOAT  -- Generation, Wind And Solar, Twh,
  "imports_total_net_imports_twh" FLOAT  -- Imports, Total Net Imports, Twh
);