Renewable Energy Share
World wide Renewable Energy data from 1965 to 2022
@kaggle.amirhoseinmousavian_renewable_energy_share
World wide Renewable Energy data from 1965 to 2022
@kaggle.amirhoseinmousavian_renewable_energy_share
CREATE TABLE biofuel_production (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"biofuels_production_twh" DOUBLE -- Biofuels Production - TWh
);
CREATE TABLE cumulative_installed_wind_energy_capacity_gigawatts (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"wind_energy_capacity" DOUBLE
);
CREATE TABLE hydropower_consumption (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"electricity_from_hydro_twh" DOUBLE -- Electricity From Hydro (TWh)
);
CREATE TABLE hydro_share_energy (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"hydro_equivalent_primary_energy" DOUBLE -- Hydro (% Equivalent Primary Energy)
);
CREATE TABLE installed_geothermal_capacity (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"geothermal_energy_capacity" DOUBLE
);
CREATE TABLE installed_solar_pv_capacity (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"solar_energy_capacity" DOUBLE
);
CREATE TABLE modern_renewable_energy_consumption (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"other_renewables_including_geothermal_and_biomass_elec_b27a2f52" DOUBLE -- Other Renewables (including Geothermal And Biomass) Electricity Generation - TWh,
"solar_generation_twh" DOUBLE -- Solar Generation - TWh,
"wind_generation_twh" DOUBLE -- Wind Generation - TWh,
"hydro_generation_twh" DOUBLE -- Hydro Generation - TWh
);
CREATE TABLE modern_renewable_prod (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"electricity_from_wind_twh" DOUBLE -- Electricity From Wind (TWh),
"electricity_from_hydro_twh" DOUBLE -- Electricity From Hydro (TWh),
"electricity_from_solar_twh" DOUBLE -- Electricity From Solar (TWh),
"other_renewables_including_bioenergy_twh" DOUBLE -- Other Renewables Including Bioenergy (TWh)
);
CREATE TABLE renewable_share_energy (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"renewables_equivalent_primary_energy" DOUBLE -- Renewables (% Equivalent Primary Energy)
);
CREATE TABLE share_electricity_hydro (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"hydro_electricity" DOUBLE -- Hydro (% Electricity)
);
CREATE TABLE share_electricity_renewables (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"renewables_electricity" DOUBLE -- Renewables (% Electricity)
);
CREATE TABLE share_electricity_solar (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"solar_electricity" DOUBLE -- Solar (% Electricity)
);
CREATE TABLE share_electricity_wind (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"wind_electricity" DOUBLE -- Wind (% Electricity)
);
CREATE TABLE solar_energy_consumption (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"electricity_from_solar_twh" DOUBLE -- Electricity From Solar (TWh)
);
CREATE TABLE solar_share_energy (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"solar_equivalent_primary_energy" DOUBLE -- Solar (% Equivalent Primary Energy)
);
CREATE TABLE wind_generation (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"electricity_from_wind_twh" DOUBLE -- Electricity From Wind (TWh)
);
CREATE TABLE wind_share_energy (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"wind_equivalent_primary_energy" DOUBLE -- Wind (% Equivalent Primary Energy)
);
Anyone who has the link will be able to view this.