European Electricity Review (Ember, 2022)

CREATE TABLE owid_country_overview_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "net_imports_twh" FLOAT  -- Net Imports, Twh,
  "demand_twh" FLOAT  -- Demand, Twh,
  "demand_per_capita_kwh" FLOAT  -- Demand Per Capita, Kwh
);

CREATE TABLE owid_country_overview_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "net_imports_twh" FLOAT  -- Net Imports, Twh,
  "demand_twh" FLOAT  -- Demand, Twh,
  "demand_per_capita_kwh" FLOAT  -- Demand Per Capita, Kwh
);

CREATE TABLE owid_emissions_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "co2_intensity_gco2_kwh" INTEGER  -- Co2 Intensity, Gco2 Kwh,
  "total_emissions_mtco2" INTEGER  -- Total Emissions, Mtco2
);

CREATE TABLE owid_emissions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "co2_intensity_gco2_kwh" INTEGER  -- Co2 Intensity, Gco2 Kwh,
  "total_emissions_mtco2" INTEGER  -- Total Emissions, Mtco2
);

CREATE TABLE owid_european_electricity_review (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_twh" FLOAT  -- Demand, Twh,
  "demand_per_capita_mwh" FLOAT  -- Demand Per Capita, Mwh,
  "emissions_bioenergy_mtco2" FLOAT  -- Emissions, Bioenergy, Mtco2,
  "emissions_clean_mtco2" FLOAT  -- Emissions, Clean, Mtco2,
  "emissions_co2_intensity_gco2_per_kwh" FLOAT  -- Emissions, Co2 Intensity, Gco2 Per Kwh,
  "emissions_coal_mtco2" FLOAT  -- Emissions, Coal, Mtco2,
  "emissions_fossil_mtco2" FLOAT  -- Emissions, Fossil, Mtco2,
  "emissions_gas_mtco2" FLOAT  -- Emissions, Gas, Mtco2,
  "emissions_hard_coal_mtco2" FLOAT  -- Emissions, Hard Coal, Mtco2,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT  -- Emissions, Hydro, Bioenergy And Other Renewables, Mtco2,
  "emissions_hydro_mtco2" FLOAT  -- Emissions, Hydro, Mtco2,
  "emissions_lignite_mtco2" FLOAT  -- Emissions, Lignite, 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_mtco2" FLOAT  -- Emissions, Total, 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_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_twh" FLOAT  -- Generation, Total, 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,
  "net_imports_total_twh" FLOAT  -- Net Imports, Total, Twh
);

CREATE TABLE owid_generation_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_twh" FLOAT  -- Bioenergy, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "hard_coal_twh" FLOAT  -- Hard Coal, Twh,
  "hydro_twh" FLOAT  -- Hydro, Twh,
  "lignite_twh" FLOAT  -- Lignite, Twh,
  "nuclear_twh" FLOAT  -- Nuclear, Twh,
  "other_fossil_twh" FLOAT  -- Other Fossil, Twh,
  "other_renewables_twh" FLOAT  -- Other Renewables, Twh,
  "solar_twh" FLOAT  -- Solar, Twh,
  "wind_twh" FLOAT  -- Wind, Twh,
  "bioenergy_pct" FLOAT  -- Bioenergy, Pct,
  "gas_pct" FLOAT  -- Gas, Pct,
  "hard_coal_pct" FLOAT  -- Hard Coal, Pct,
  "hydro_pct" FLOAT  -- Hydro, Pct,
  "lignite_pct" FLOAT  -- Lignite, Pct,
  "nuclear_pct" FLOAT  -- Nuclear, Pct,
  "other_fossil_pct" FLOAT  -- Other Fossil, Pct,
  "other_renewables_pct" FLOAT  -- Other Renewables, Pct,
  "solar_pct" FLOAT  -- Solar, Pct,
  "wind_pct" FLOAT  -- Wind, Pct
);

CREATE TABLE owid_generation_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_twh" FLOAT  -- Bioenergy, Twh,
  "gas_twh" FLOAT  -- Gas, Twh,
  "hard_coal_twh" FLOAT  -- Hard Coal, Twh,
  "hydro_twh" FLOAT  -- Hydro, Twh,
  "lignite_twh" FLOAT  -- Lignite, Twh,
  "nuclear_twh" FLOAT  -- Nuclear, Twh,
  "other_fossil_twh" FLOAT  -- Other Fossil, Twh,
  "other_renewables_twh" FLOAT  -- Other Renewables, Twh,
  "solar_twh" FLOAT  -- Solar, Twh,
  "wind_twh" FLOAT  -- Wind, Twh,
  "bioenergy_pct" FLOAT  -- Bioenergy, Pct,
  "gas_pct" FLOAT  -- Gas, Pct,
  "hard_coal_pct" FLOAT  -- Hard Coal, Pct,
  "hydro_pct" FLOAT  -- Hydro, Pct,
  "lignite_pct" FLOAT  -- Lignite, Pct,
  "nuclear_pct" FLOAT  -- Nuclear, Pct,
  "other_fossil_pct" FLOAT  -- Other Fossil, Pct,
  "other_renewables_pct" FLOAT  -- Other Renewables, Pct,
  "solar_pct" FLOAT  -- Solar, Pct,
  "wind_pct" FLOAT  -- Wind, Pct,
  "coal_twh" FLOAT  -- Coal, Twh,
  "wind_and_solar_twh" FLOAT  -- Wind And Solar, Twh,
  "hydro_bioenergy_and_other_renewables_twh" FLOAT  -- Hydro, Bioenergy And Other Renewables, Twh,
  "renewables_twh" FLOAT  -- Renewables, Twh,
  "clean_twh" FLOAT  -- Clean, Twh,
  "gas_and_other_fossil_twh" FLOAT  -- Gas And Other Fossil, Twh,
  "fossil_twh" FLOAT  -- Fossil, Twh,
  "total_generation_twh" FLOAT  -- Total Generation, Twh,
  "coal_pct" FLOAT  -- Coal, Pct,
  "wind_and_solar_pct" FLOAT  -- Wind And Solar, Pct,
  "hydro_bioenergy_and_other_renewables_pct" FLOAT  -- Hydro, Bioenergy And Other Renewables, Pct,
  "renewables_pct" FLOAT  -- Renewables, Pct,
  "clean_pct" FLOAT  -- Clean, Pct,
  "gas_and_other_fossil_pct" FLOAT  -- Gas And Other Fossil, Pct,
  "fossil_pct" FLOAT  -- Fossil, Pct,
  "total_generation_pct" FLOAT  -- Total Generation, Pct
);

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

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