Global Energy Consumption & Renewable Generation
Global Energy Consumption (1990-2020) & Renewable Energy Generation (1997-2017)
@kaggle.jamesvandenberg_renewable_power_generation
Global Energy Consumption (1990-2020) & Renewable Energy Generation (1997-2017)
@kaggle.jamesvandenberg_renewable_power_generation
CREATE TABLE continent_consumption_twh (
"year" BIGINT,
"world" DOUBLE,
"oecd" DOUBLE,
"brics" DOUBLE,
"europe" DOUBLE,
"north_america" DOUBLE,
"latin_america" DOUBLE,
"asia" DOUBLE,
"pacific" DOUBLE,
"africa" DOUBLE,
"middle_east" DOUBLE,
"cis" DOUBLE
);
CREATE TABLE country_consumption_twh (
"year" DOUBLE,
"china" DOUBLE,
"united_states" DOUBLE,
"brazil" DOUBLE,
"belgium" DOUBLE,
"czechia" DOUBLE,
"france" DOUBLE,
"germany" DOUBLE,
"italy" DOUBLE,
"netherlands" DOUBLE,
"poland" DOUBLE,
"portugal" DOUBLE,
"romania" DOUBLE,
"spain" DOUBLE,
"sweden" DOUBLE,
"united_kingdom" DOUBLE,
"norway" DOUBLE,
"turkey" DOUBLE,
"kazakhstan" DOUBLE,
"russia" DOUBLE,
"ukraine" DOUBLE,
"uzbekistan" DOUBLE,
"argentina" DOUBLE,
"canada" DOUBLE,
"chile" DOUBLE,
"colombia" DOUBLE,
"mexico" DOUBLE,
"venezuela" DOUBLE,
"indonesia" DOUBLE,
"japan" DOUBLE,
"malaysia" DOUBLE,
"south_korea" DOUBLE,
"taiwan" DOUBLE,
"thailand" DOUBLE,
"india" DOUBLE,
"australia" DOUBLE,
"new_zealand" DOUBLE,
"algeria" DOUBLE,
"egypt" DOUBLE,
"nigeria" DOUBLE,
"south_africa" DOUBLE,
"iran" DOUBLE,
"kuwait" DOUBLE,
"saudi_arabia" DOUBLE,
"united_arab_emirates" DOUBLE
);
CREATE TABLE nonrenewablestotalpowergeneration (
"mode_of_generation" VARCHAR,
"contribution_twh" DOUBLE
);
CREATE TABLE renewablepowergeneration97_17 (
"year" BIGINT,
"hydro_twh" DOUBLE,
"biofuel_twh" DOUBLE,
"solar_pv_twh" DOUBLE,
"geothermal_twh" DOUBLE
);
CREATE TABLE renewablestotalpowergeneration (
"mode_of_generation" VARCHAR,
"contribution_twh" DOUBLE
);
CREATE TABLE top20countriespowergeneration (
"country" VARCHAR,
"hydro_twh" DOUBLE,
"biofuel_twh" DOUBLE,
"solar_pv_twh" DOUBLE,
"geothermal_twh" DOUBLE,
"total_twh" DOUBLE
);
Anyone who has the link will be able to view this.