Global Energy Statistics (1980-2021)

Energy Trends and Insights from Around the Globe

@kaggle.akhiljethwa_world_energy_statistics

Table List

1 table(82.05 KB)

World Energy Overview

@kaggle.akhiljethwa_world_energy_statistics.world_energy_overview

82.05 KB
599 rows
13 columns

date Date	total_fossil_fuels_production Total Fossil Fuels Production	nuclear_electric_power_production Nuclear Electric Power Production	total_renewable_energy_production Total Renewable Energy Production	total_primary_energy_production Total Primary Energy Production	primary_energy_imports Primary Energy Imports	primary_energy_exports Primary Energy Exports	primary_energy_net_imports Primary Energy Net Imports	primary_energy_stock_change_and_other Primary Energy Stock Change And Other	total_fossil_fuels_consumption Total Fossil Fuels Consumption	nuclear_electric_power_consumption Nuclear Electric Power Consumption	total_renewable_energy_consumption Total Renewable Energy Consumption	total_primary_energy_consumption Total Primary Energy Consumption
Wed Jan 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.932632	0.068103	0.403981	5.404715	1.17308	0.125781	1.047299	0.771858	6.747651	0.068103	0.403981	7.223873
Wed Feb 28 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.729582	0.064634	0.3609	5.155115	1.168005	0.120883	1.047122	0.390129	6.163095	0.064634	0.3609	6.592366
Sat Mar 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.946902	0.072494	0.400161	5.419556	1.309473	0.13995	1.169523	-0.06764	6.044647	0.072494	0.400161	6.521439
Mon Apr 30 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.716271	0.06407	0.38047	5.160812	1.085169	0.194185	0.890984	-0.110067	5.493184	0.06407	0.38047	5.941729
Thu May 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.956995	0.062111	0.392141	5.411246	1.162804	0.196775	0.966029	-0.305335	5.613551	0.062111	0.392141	6.07194
Sat Jun 30 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.716096	0.073968	0.377232	5.167296	1.129614	0.178871	0.950743	-0.315356	5.347479	0.073968	0.377232	5.802683
Tue Jul 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.748276	0.07589	0.367325	5.191492	1.216246	0.164134	1.052112	-0.291695	5.504556	0.07589	0.367325	5.951909
Fri Aug 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	5.041997	0.084883	0.353757	5.480638	1.297848	0.191049	1.106799	-0.39578	5.748879	0.084883	0.353757	6.191657
Sun Sep 30 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.731504	0.085724	0.307006	5.124234	1.226145	0.146492	1.079652	-0.430371	5.376782	0.085724	0.307006	5.773515
Wed Oct 31 1973 00:00:00 GMT+0000 (Coordinated Universal Time)	4.998321	0.081971	0.323453	5.403745	1.315774	0.207655	1.108119	-0.337003	5.7653	0.081971	0.323453	6.174862


CREATE TABLE world_energy_overview (
  "date" TIMESTAMP,
  "total_fossil_fuels_production" DOUBLE,
  "nuclear_electric_power_production" DOUBLE,
  "total_renewable_energy_production" DOUBLE,
  "total_primary_energy_production" DOUBLE,
  "primary_energy_imports" DOUBLE,
  "primary_energy_exports" DOUBLE,
  "primary_energy_net_imports" DOUBLE,
  "primary_energy_stock_change_and_other" DOUBLE,
  "total_fossil_fuels_consumption" DOUBLE,
  "nuclear_electric_power_consumption" DOUBLE,
  "total_renewable_energy_consumption" DOUBLE,
  "total_primary_energy_consumption" DOUBLE
);