European Electricity Review (Ember, 2022)

CREATE TABLE owid_country_overview_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "total_generation_twh" FLOAT,
  "net_imports_twh" FLOAT,
  "demand_twh" FLOAT,
  "demand_per_capita_kwh" FLOAT
);

CREATE TABLE owid_country_overview_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "total_generation_twh" FLOAT,
  "net_imports_twh" FLOAT,
  "demand_twh" FLOAT,
  "demand_per_capita_kwh" FLOAT
);

CREATE TABLE owid_emissions_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "co2_intensity_gco2_kwh" INTEGER,
  "total_emissions_mtco2" INTEGER
);

CREATE TABLE owid_emissions_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "co2_intensity_gco2_kwh" INTEGER,
  "total_emissions_mtco2" INTEGER
);

CREATE TABLE owid_european_electricity_review (
  "country" VARCHAR,
  "year" INTEGER,
  "demand_twh" FLOAT,
  "demand_per_capita_mwh" FLOAT,
  "emissions_bioenergy_mtco2" FLOAT,
  "emissions_clean_mtco2" FLOAT,
  "emissions_co2_intensity_gco2_per_kwh" FLOAT,
  "emissions_coal_mtco2" FLOAT,
  "emissions_fossil_mtco2" FLOAT,
  "emissions_gas_mtco2" FLOAT,
  "emissions_hard_coal_mtco2" FLOAT,
  "emissions_hydro_bioenergy_and_other_renewables_mtco2" FLOAT,
  "emissions_hydro_mtco2" FLOAT,
  "emissions_lignite_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_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_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_twh" FLOAT,
  "generation_wind_pct" FLOAT,
  "generation_wind_twh" FLOAT,
  "generation_wind_and_solar_pct" FLOAT,
  "generation_wind_and_solar_twh" FLOAT,
  "net_imports_total_twh" FLOAT
);

CREATE TABLE owid_generation_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "bioenergy_twh" FLOAT,
  "gas_twh" FLOAT,
  "hard_coal_twh" FLOAT,
  "hydro_twh" FLOAT,
  "lignite_twh" FLOAT,
  "nuclear_twh" FLOAT,
  "other_fossil_twh" FLOAT,
  "other_renewables_twh" FLOAT,
  "solar_twh" FLOAT,
  "wind_twh" FLOAT,
  "bioenergy_pct" FLOAT,
  "gas_pct" FLOAT,
  "hard_coal_pct" FLOAT,
  "hydro_pct" FLOAT,
  "lignite_pct" FLOAT,
  "nuclear_pct" FLOAT,
  "other_fossil_pct" FLOAT,
  "other_renewables_pct" FLOAT,
  "solar_pct" FLOAT,
  "wind_pct" FLOAT
);

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

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

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