Dataset: Renewable Vs Nuclear Energy Generation (1965-)

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.71 MB
34936 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

62.45 KB
4284 rows
6 columns


CREATE TABLE primary_energy_consumption_from_fossilfuels_nuclear_renewables (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "fossil_fuels_sub_energy" DOUBLE,
  "renewables_sub_energy" DOUBLE,
  "nuclear_sub_energy" DOUBLE
);

Share Elec Produc By Source

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.share_elec_produc_by_source

247.17 KB
6190 rows
11 columns


CREATE TABLE share_elec_produc_by_source (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "coal_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "other_renewables_electricity" DOUBLE
);

Share Energy Consum By Source

@kaggle.donjoeml_energy_consumption_and_generation_in_the_globe.share_energy_consum_by_source

135.86 KB
4284 rows
11 columns


CREATE TABLE share_energy_consum_by_source (
  "entity" VARCHAR,
  "code" VARCHAR,
  "year" BIGINT,
  "oil_sub_energy" DOUBLE,
  "coal_sub_energy" DOUBLE,
  "solar_sub_energy" DOUBLE,
  "nuclear_sub_energy" DOUBLE,
  "hydro_sub_energy" DOUBLE,
  "wind_sub_energy" DOUBLE,
  "gas_sub_energy" DOUBLE,
  "other_renewables_sub_energy" DOUBLE
);