Renewable Energy Share

entity Entity	code Code	year Year	other_renewables_including_geothermal_and_biomass_elec_b27a2f52 Other Renewables (including Geothermal And Biomass) Electricity Generation - TWh	hydro_generation_twh Hydro Generation - TWh
Africa	nan	1971	0.164	26.01339
Africa	nan	1972	0.165	29.633196
Africa	nan	1973	0.17	31.345707
Africa	nan	1974	0.175	35.667076
Africa	nan	1975	0.172	37.717968
Africa	nan	1976	0.185	41.797634
Africa	nan	1977	0.189	45.92877
Africa	nan	1978	0.195	46.306942
Africa	nan	1979	0.201	49.56523
Africa	nan	1980	0.207	48.311787


CREATE TABLE modern_renewable_energy_consumption (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "other_renewables_including_geothermal_and_biomass_elec_b27a2f52" DOUBLE,
  "solar_generation_twh" DOUBLE,
  "wind_generation_twh" DOUBLE,
  "hydro_generation_twh" DOUBLE
);