Energy Transitions: Global And National Perspectives - Vaclav Smil (2017)

CREATE TABLE owid_smil_2017_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "biofuels_twh_direct_energy" INTEGER  -- Biofuels, Twh Direct Energy,
  "coal_twh_direct_energy" INTEGER  -- Coal, Twh Direct Energy,
  "gas_twh_direct_energy" INTEGER  -- Gas, Twh Direct Energy,
  "hydropower_twh_direct_energy" INTEGER  -- Hydropower, Twh Direct Energy,
  "nuclear_twh_direct_energy" INTEGER  -- Nuclear, Twh Direct Energy,
  "oil_twh_direct_energy" INTEGER  -- Oil, Twh Direct Energy,
  "other_renewables_twh_direct_energy" INTEGER  -- Other Renewables, Twh Direct Energy,
  "solar_twh_direct_energy" INTEGER  -- Solar, Twh Direct Energy,
  "traditional_biomass_twh_direct_energy" INTEGER  -- Traditional Biomass, Twh Direct Energy,
  "wind_twh_direct_energy" INTEGER  -- Wind, Twh Direct Energy
);

CREATE TABLE owid_smil_2017_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "biofuels_twh_direct_energy" INTEGER  -- Biofuels, Twh Direct Energy,
  "coal_twh_direct_energy" INTEGER  -- Coal, Twh Direct Energy,
  "gas_twh_direct_energy" INTEGER  -- Gas, Twh Direct Energy,
  "hydropower_twh_direct_energy" INTEGER  -- Hydropower, Twh Direct Energy,
  "nuclear_twh_direct_energy" INTEGER  -- Nuclear, Twh Direct Energy,
  "oil_twh_direct_energy" INTEGER  -- Oil, Twh Direct Energy,
  "other_renewables_twh_direct_energy" INTEGER  -- Other Renewables, Twh Direct Energy,
  "solar_twh_direct_energy" INTEGER  -- Solar, Twh Direct Energy,
  "traditional_biomass_twh_direct_energy" INTEGER  -- Traditional Biomass, Twh Direct Energy,
  "wind_twh_direct_energy" INTEGER  -- Wind, Twh Direct Energy
);