Name: Renewable Energy
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Renewable Energy

Renewable energy is energy that is collected from renewable resources that are naturally replenished on a human timescale. It includes sources such as sunlight, wind, rain, tides, waves, and geothermal heat. Although most renewable energy sources are sustainable, some are not. Wikipedia

@article{owidenergy,
author = {Hannah Ritchie, Max Roser and Pablo Rosado},
title = {Energy},
journal = {Our World in Data},
year = {2020},
note = {https://ourworldindata.org/energy}
}

Tables

Biofuel Production

@kaggle.programmerrdai_renewable_energy.biofuel_production

11.41 kB
1,085 rows
4 columns

CREATE TABLE biofuel_production (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "biofuels_production_twh_total" DOUBLE  -- Biofuels Production - TWh - Total
);

Cumulative Installed Wind Energy Capacity Gigawatts

@kaggle.programmerrdai_renewable_energy.cumulative_installed_wind_energy_capacity_gigawatts

13.29 kB
1,403 rows
4 columns

CREATE TABLE cumulative_installed_wind_energy_capacity_gigawatts (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wind_capacity" DOUBLE
);

Hydropower Consumption

@kaggle.programmerrdai_renewable_energy.hydropower_consumption

40.58 kB
7,994 rows
4 columns

CREATE TABLE hydropower_consumption (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "electricity_from_hydro_twh" DOUBLE  -- Electricity From Hydro (TWh)
);

Hydro Share Energy

@kaggle.programmerrdai_renewable_energy.hydro_share_energy

30.3 kB
4,835 rows
4 columns

CREATE TABLE hydro_share_energy (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "hydro_sub_energy" DOUBLE  -- Hydro (% Sub Energy)
);

Installed Geothermal Capacity

@kaggle.programmerrdai_renewable_energy.installed_geothermal_capacity

6.84 kB
758 rows
4 columns

CREATE TABLE installed_geothermal_capacity (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "geothermal_capacity" DOUBLE
);

Installed Solar Pv Capacity

@kaggle.programmerrdai_renewable_energy.installed_solar_pv_capacity

13.44 kB
1,520 rows
4 columns

CREATE TABLE installed_solar_pv_capacity (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "solar_capacity" DOUBLE
);

Modern Renewable Energy Consumption

@kaggle.programmerrdai_renewable_energy.modern_renewable_energy_consumption

99.1 kB
5,003 rows
7 columns

CREATE TABLE modern_renewable_energy_consumption (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wind_generation_twh" DOUBLE  -- Wind Generation - TWh,
  "solar_generation_twh" DOUBLE  -- Solar Generation - TWh,
  "geo_biomass_other_twh" DOUBLE  -- Geo Biomass Other - TWh,
  "hydro_generation_twh" DOUBLE  -- Hydro Generation - TWh
);

Modern Renewable Prod

@kaggle.programmerrdai_renewable_energy.modern_renewable_prod

75.71 kB
7,995 rows
7 columns

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),
  "electricity_from_other_renewables_including_bioenergy_twh" DOUBLE  -- Electricity From Other Renewables Including Bioenergy (TWh)
);

Renewable Share Energy

@kaggle.programmerrdai_renewable_energy.renewable_share_energy

31.83 kB
4,835 rows
4 columns

CREATE TABLE renewable_share_energy (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "renewables_sub_energy" DOUBLE  -- Renewables (% Sub Energy)
);

Share Electricity Hydro

@kaggle.programmerrdai_renewable_energy.share_electricity_hydro

39.9 kB
6,379 rows
4 columns

CREATE TABLE share_electricity_hydro (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "hydro_electricity" DOUBLE  -- Hydro (% Electricity)
);

Share Electricity Renewables

@kaggle.programmerrdai_renewable_energy.share_electricity_renewables

41.89 kB
6,374 rows
4 columns

CREATE TABLE share_electricity_renewables (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "renewables_electricity" DOUBLE  -- Renewables (% Electricity)
);

Share Electricity Solar

@kaggle.programmerrdai_renewable_energy.share_electricity_solar

17.63 kB
6,380 rows
4 columns

CREATE TABLE share_electricity_solar (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "solar_electricity" DOUBLE  -- Solar (% Electricity)
);

Share Electricity Wind

@kaggle.programmerrdai_renewable_energy.share_electricity_wind

20.05 kB
6,379 rows
4 columns

CREATE TABLE share_electricity_wind (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wind_electricity" DOUBLE  -- Wind (% Electricity)
);

Solar Energy Consumption

@kaggle.programmerrdai_renewable_energy.solar_energy_consumption

15.58 kB
7,995 rows
4 columns

CREATE TABLE solar_energy_consumption (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "electricity_from_solar_twh" DOUBLE  -- Electricity From Solar (TWh)
);

Solar Share Energy

@kaggle.programmerrdai_renewable_energy.solar_share_energy

10.37 kB
4,835 rows
4 columns

CREATE TABLE solar_share_energy (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "solar_sub_energy" DOUBLE  -- Solar (% Sub Energy)
);

Wind Generation

@kaggle.programmerrdai_renewable_energy.wind_generation

18.19 kB
7,994 rows
4 columns

CREATE TABLE wind_generation (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "electricity_from_wind_twh" DOUBLE  -- Electricity From Wind (TWh)
);

Wind Share Energy

@kaggle.programmerrdai_renewable_energy.wind_share_energy

12.63 kB
4,835 rows
4 columns

CREATE TABLE wind_share_energy (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "wind_sub_energy" DOUBLE  -- Wind (% Sub Energy)
);