Name: Electricity Mix (EI & Ember, 2023)
Creator: Our World In Data
License: https://ember-climate.org/creative-commons/

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.2 MB
9,904 rows
54 columns

CREATE TABLE owid_electricity_mix_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_2

1.23 MB
9,908 rows
55 columns

CREATE TABLE owid_electricity_mix_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "direct_primary_energy_consumption_twh" FLOAT  -- Direct Primary Energy Consumption, Twh,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_3

1.28 MB
10,084 rows
55 columns

CREATE TABLE owid_electricity_mix_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "direct_primary_energy_consumption_twh" FLOAT  -- Direct Primary Energy Consumption, Twh,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_4

1.31 MB
10,139 rows
56 columns

CREATE TABLE owid_electricity_mix_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "direct_primary_energy_consumption_twh" FLOAT  -- Direct Primary Energy Consumption, Twh,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_demand_kwh" FLOAT  -- Per Capita Total Demand, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_5

1.35 MB
10,347 rows
56 columns

CREATE TABLE owid_electricity_mix_5 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "direct_primary_energy_consumption_twh" FLOAT  -- Direct Primary Energy Consumption, Twh,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_demand_kwh" FLOAT  -- Per Capita Total Demand, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);

Electricity Mix

@owid.electricity_mix.owid_electricity_mix_6

1.43 MB
11,623 rows
56 columns

CREATE TABLE owid_electricity_mix_6 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_generation_twh" FLOAT  -- Bioenergy Generation, Twh,
  "bioenergy_share_of_electricity_pct" FLOAT  -- Bioenergy Share Of Electricity, Pct,
  "co2_intensity_gco2_kwh" FLOAT  -- Co2 Intensity, Gco2 Kwh,
  "coal_generation_twh" FLOAT  -- Coal Generation, Twh,
  "coal_share_of_electricity_pct" FLOAT  -- Coal Share Of Electricity, Pct,
  "direct_primary_energy_consumption_twh" FLOAT  -- Direct Primary Energy Consumption, Twh,
  "fossil_generation_twh" FLOAT  -- Fossil Generation, Twh,
  "fossil_share_of_electricity_pct" FLOAT  -- Fossil Share Of Electricity, Pct,
  "gas_generation_twh" FLOAT  -- Gas Generation, Twh,
  "gas_share_of_electricity_pct" FLOAT  -- Gas Share Of Electricity, Pct,
  "hydro_generation_twh" FLOAT  -- Hydro Generation, Twh,
  "hydro_share_of_electricity_pct" FLOAT  -- Hydro Share Of Electricity, Pct,
  "low_carbon_generation_twh" FLOAT  -- Low Carbon Generation, Twh,
  "low_carbon_share_of_electricity_pct" FLOAT  -- Low Carbon Share Of Electricity, Pct,
  "net_imports_share_of_demand_pct" FLOAT  -- Net Imports Share Of Demand, Pct,
  "nuclear_generation_twh" FLOAT  -- Nuclear Generation, Twh,
  "nuclear_share_of_electricity_pct" FLOAT  -- Nuclear Share Of Electricity, Pct,
  "oil_generation_twh" FLOAT  -- Oil Generation, Twh,
  "oil_share_of_electricity_pct" FLOAT  -- Oil Share Of Electricity, Pct,
  "other_renewables_excluding_bioenergy_generation_twh" FLOAT  -- Other Renewables Excluding Bioenergy Generation, Twh,
  "other_renewables_excluding_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Excluding Bioenergy Share Of Electricity, Pct,
  "other_renewables_including_bioenergy_generation_twh" FLOAT  -- Other Renewables Including Bioenergy Generation, Twh,
  "other_renewables_including_bioenergy_share_of_electricity_pct" FLOAT  -- Other Renewables Including Bioenergy Share Of Electricity, Pct,
  "per_capita_bioenergy_generation_kwh" FLOAT  -- Per Capita Bioenergy Generation, Kwh,
  "per_capita_coal_generation_kwh" FLOAT  -- Per Capita Coal Generation, Kwh,
  "per_capita_fossil_generation_kwh" FLOAT  -- Per Capita Fossil Generation, Kwh,
  "per_capita_gas_generation_kwh" FLOAT  -- Per Capita Gas Generation, Kwh,
  "per_capita_hydro_generation_kwh" FLOAT  -- Per Capita Hydro Generation, Kwh,
  "per_capita_low_carbon_generation_kwh" FLOAT  -- Per Capita Low Carbon Generation, Kwh,
  "per_capita_nuclear_generation_kwh" FLOAT  -- Per Capita Nuclear Generation, Kwh,
  "per_capita_oil_generation_kwh" FLOAT  -- Per Capita Oil Generation, Kwh,
  "per_capita_other_renewables_excluding_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Excluding Bioenergy Generation, Kwh,
  "per_capita_other_renewables_including_bioenergy_generation_kwh" FLOAT  -- Per Capita Other Renewables Including Bioenergy Generation, Kwh,
  "per_capita_renewable_generation_kwh" FLOAT  -- Per Capita Renewable Generation, Kwh,
  "per_capita_solar_and_wind_generation_kwh" FLOAT  -- Per Capita Solar And Wind Generation, Kwh,
  "per_capita_solar_generation_kwh" FLOAT  -- Per Capita Solar Generation, Kwh,
  "per_capita_total_demand_kwh" FLOAT  -- Per Capita Total Demand, Kwh,
  "per_capita_total_generation_kwh" FLOAT  -- Per Capita Total Generation, Kwh,
  "per_capita_wind_generation_kwh" FLOAT  -- Per Capita Wind Generation, Kwh,
  "population" BIGINT,
  "primary_energy_consumption_twh" FLOAT  -- Primary Energy Consumption, Twh,
  "renewable_generation_twh" FLOAT  -- Renewable Generation, Twh,
  "renewable_share_of_electricity_pct" FLOAT  -- Renewable Share Of Electricity, Pct,
  "solar_and_wind_generation_twh" FLOAT  -- Solar And Wind Generation, Twh,
  "solar_and_wind_share_of_electricity_pct" FLOAT  -- Solar And Wind Share Of Electricity, Pct,
  "solar_generation_twh" FLOAT  -- Solar Generation, Twh,
  "solar_share_of_electricity_pct" FLOAT  -- Solar Share Of Electricity, Pct,
  "total_demand_twh" FLOAT  -- Total Demand, Twh,
  "total_electricity_share_of_primary_energy_pct" FLOAT  -- Total Electricity Share Of Primary Energy, Pct,
  "total_emissions_mtco2" FLOAT  -- Total Emissions, Mtco2,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "total_net_imports_twh" FLOAT  -- Total Net Imports, Twh,
  "wind_generation_twh" FLOAT  -- Wind Generation, Twh,
  "wind_share_of_electricity_pct" FLOAT  -- Wind Share Of Electricity, Pct
);