Name: Renewable Vs Nuclear Energy Generation (1965-)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Renewable Vs Nuclear Energy Generation (1965-)

Context

An environmentally sustainable power sector is central to modern society since plants have significant impact on climate, through carbon dioxide (CO2) emissions; on water stress, through water withdrawal and consumption; and on air quality, through sulfur oxides (SOx), nitrogen oxides (NOx), and particulate matter (PM) emissions.

The datasets used in this project is publicly accessible in Our World in Data and Word Resources Institute. Datasets contains the following characteristics and indicators:

All types of fuel
Technical characteristics (fuel, technology, ownership)
Plants’ geolocation
Energy production/consumption (per capita) around the globe since 1965
Annual change in primary energy consumption

Tables

Global Power Plant Database Last

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.global_power_plant_database_last

2.84 MB
34,936 rows
36 columns

CREATE TABLE global_power_plant_database_last (
  "country" VARCHAR,
  "country_long" VARCHAR,
  "name" VARCHAR,
  "gppd_idnr" VARCHAR,
  "capacity_mw" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "primary_fuel" VARCHAR,
  "other_fuel1" VARCHAR,
  "other_fuel2" VARCHAR,
  "other_fuel3" VARCHAR,
  "commissioning_year" DOUBLE,
  "owner" VARCHAR,
  "source" VARCHAR,
  "url" VARCHAR,
  "geolocation_source" VARCHAR,
  "wepp_id" VARCHAR,
  "year_of_capacity_data" DOUBLE,
  "generation_gwh_2013" DOUBLE,
  "generation_gwh_2014" DOUBLE,
  "generation_gwh_2015" DOUBLE,
  "generation_gwh_2016" DOUBLE,
  "generation_gwh_2017" DOUBLE,
  "generation_gwh_2018" DOUBLE,
  "generation_gwh_2019" DOUBLE,
  "generation_data_source" VARCHAR,
  "estimated_generation_gwh_2013" DOUBLE,
  "estimated_generation_gwh_2014" DOUBLE,
  "estimated_generation_gwh_2015" DOUBLE,
  "estimated_generation_gwh_2016" DOUBLE,
  "estimated_generation_gwh_2017" DOUBLE,
  "estimated_generation_note_2013" VARCHAR,
  "estimated_generation_note_2014" VARCHAR,
  "estimated_generation_note_2015" VARCHAR,
  "estimated_generation_note_2016" VARCHAR,
  "estimated_generation_note_2017" VARCHAR
);

Primary Energy Consumption From Fossilfuels Nuclear Renewables

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.primary_energy_consumption_from_fossilfuels_nuclear_renewables

63.95 kB
4,284 rows
6 columns

CREATE TABLE primary_energy_consumption_from_fossilfuels_nuclear_renewables (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "fossil_fuels_sub_energy" DOUBLE  -- Fossil Fuels (% Sub Energy),
  "renewables_sub_energy" DOUBLE  -- Renewables (% Sub Energy),
  "nuclear_sub_energy" DOUBLE  -- Nuclear (% Sub Energy)
);

Share Elec Produc By Source

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.share_elec_produc_by_source

253.1 kB
6,190 rows
11 columns

CREATE TABLE share_elec_produc_by_source (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "coal_electricity" DOUBLE  -- Coal (% Electricity),
  "gas_electricity" DOUBLE  -- Gas (% Electricity),
  "hydro_electricity" DOUBLE  -- Hydro (% Electricity),
  "solar_electricity" DOUBLE  -- Solar (% Electricity),
  "wind_electricity" DOUBLE  -- Wind (% Electricity),
  "oil_electricity" DOUBLE  -- Oil (% Electricity),
  "nuclear_electricity" DOUBLE  -- Nuclear (% Electricity),
  "other_renewables_electricity" DOUBLE  -- Other Renewables (% Electricity)
);

Share Energy Consum By Source

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.share_energy_consum_by_source

139.12 kB
4,284 rows
11 columns

CREATE TABLE share_energy_consum_by_source (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "oil_sub_energy" DOUBLE  -- Oil (% Sub Energy),
  "coal_sub_energy" DOUBLE  -- Coal (% Sub Energy),
  "solar_sub_energy" DOUBLE  -- Solar (% Sub Energy),
  "nuclear_sub_energy" DOUBLE  -- Nuclear (% Sub Energy),
  "hydro_sub_energy" DOUBLE  -- Hydro (% Sub Energy),
  "wind_sub_energy" DOUBLE  -- Wind (% Sub Energy),
  "gas_sub_energy" DOUBLE  -- Gas (% Sub Energy),
  "other_renewables_sub_energy" DOUBLE  -- Other Renewables (% Sub Energy)
);