World Energy Consumption

Consumption of energy by different countries

@kaggle.pralabhpoudel_world_energy_consumption

Table List

1 table(3.84 MB)

World Energy Consumption

@kaggle.pralabhpoudel_world_energy_consumption.world_energy_consumption

3.84 MB
22012 rows
129 columns
Only the first 100 columns are shown

country Country	year Year	iso_code Iso Code	biofuel_electricity Biofuel Electricity	biofuel_share_elec Biofuel Share Elec	carbon_intensity_elec Carbon Intensity Elec	coal_electricity Coal Electricity	coal_share_elec Coal Share Elec	electricity_demand Electricity Demand	electricity_generation Electricity Generation	fossil_electricity Fossil Electricity	fossil_share_elec Fossil Share Elec	gas_electricity Gas Electricity	gas_share_elec Gas Share Elec	greenhouse_gas_emissions Greenhouse Gas Emissions	hydro_electricity Hydro Electricity	hydro_share_elec Hydro Share Elec	low_carbon_electricity Low Carbon Electricity	low_carbon_share_elec Low Carbon Share Elec	oil_electricity Oil Electricity	oil_share_elec Oil Share Elec	other_renewable_electricity Other Renewable Electricity	other_renewable_exc_biofuel_electricity Other Renewable Exc Biofuel Electricity
ASEAN (Ember)	2000	nan	5.6	1.519	500.231	71.03	19.268	368.65	368.65	295.75	80.225	163.22	44.275	184.41	50.37	13.663	72.9	19.775	61.5	16.682	22.53	16.93
ASEAN (Ember)	2001	nan	6.02	1.516	499.358	80.02	20.147	397.19	397.19	320.51	80.694	185.35	46.665	198.34	54.26	13.661	76.68	19.306	55.14	13.883	22.42	16.4
ASEAN (Ember)	2002	nan	6.06	1.433	505.652	87.16	20.614	422.82	422.82	346.83	82.028	203.52	48.134	213.8	53.32	12.611	75.99	17.972	56.15	13.28	22.67	16.61
ASEAN (Ember)	2003	nan	6.69	1.496	513.698	98.51	22.031	447.15	447.15	371.44	83.068	216.92	48.512	229.7	53.28	11.915	75.71	16.932	56.01	12.526	22.43	15.74
ASEAN (Ember)	2004	nan	7.57	1.561	520.91	111.62	23.017	484.94	484.94	407.92	84.118	237.97	49.072	252.61	52.88	10.904	77.02	15.882	58.33	12.028	24.14	16.57
ASEAN (Ember)	2005	nan	7.94	1.555	525.789	122.39	23.966	510.68	510.68	432.46	84.683	250.68	49.087	268.51	53.76	10.527	78.22	15.317	59.39	11.63	24.44	16.5
ASEAN (Ember)	2006	nan	7.76	1.451	525.277	135.26	25.298	534.67	534.67	449.35	84.042	256.2	47.917	280.85	60.38	11.293	85.32	15.958	57.89	10.827	24.89	17.13
ASEAN (Ember)	2007	nan	9.44	1.674	529.352	152.04	26.957	564.01	564.01	474.14	84.066	266.35	47.224	298.56	63.13	11.193	89.87	15.934	55.75	9.885	26.68	17.24
ASEAN (Ember)	2008	nan	9.72	1.647	518.096	149.68	25.362	590.18	590.18	491.57	83.292	290.13	49.16	305.77	69.8	11.827	98.61	16.708	51.76	8.77	28.75	19.03
ASEAN (Ember)	2009	nan	10.11	1.654	519.021	160.27	26.223	611.17	611.17	507.84	83.093	296.9	48.579	317.21	73.52	12.029	103.33	16.907	50.67	8.291	29.73	19.62


CREATE TABLE world_energy_consumption (
  "country" VARCHAR,
  "year" BIGINT,
  "iso_code" VARCHAR,
  "population" DOUBLE,
  "gdp" DOUBLE,
  "biofuel_cons_change_pct" DOUBLE,
  "biofuel_cons_change_twh" DOUBLE,
  "biofuel_cons_per_capita" DOUBLE,
  "biofuel_consumption" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_share_energy" DOUBLE,
  "carbon_intensity_elec" DOUBLE,
  "coal_cons_change_pct" DOUBLE,
  "coal_cons_change_twh" DOUBLE,
  "coal_cons_per_capita" DOUBLE,
  "coal_consumption" DOUBLE,
  "coal_elec_per_capita" DOUBLE,
  "coal_electricity" DOUBLE,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "coal_production" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_share_energy" DOUBLE,
  "electricity_demand" DOUBLE,
  "electricity_generation" DOUBLE,
  "electricity_share_energy" DOUBLE,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "energy_per_capita" DOUBLE,
  "energy_per_gdp" DOUBLE,
  "fossil_cons_change_pct" DOUBLE,
  "fossil_cons_change_twh" DOUBLE,
  "fossil_elec_per_capita" DOUBLE,
  "fossil_electricity" DOUBLE,
  "fossil_energy_per_capita" DOUBLE,
  "fossil_fuel_consumption" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "fossil_share_energy" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" DOUBLE,
  "gas_electricity" DOUBLE,
  "gas_energy_per_capita" DOUBLE,
  "gas_prod_change_pct" DOUBLE,
  "gas_prod_change_twh" DOUBLE,
  "gas_prod_per_capita" DOUBLE,
  "gas_production" DOUBLE,
  "gas_share_elec" DOUBLE,
  "gas_share_energy" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "hydro_cons_change_pct" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_electricity" DOUBLE,
  "hydro_energy_per_capita" DOUBLE,
  "hydro_share_elec" DOUBLE,
  "hydro_share_energy" DOUBLE,
  "low_carbon_cons_change_pct" DOUBLE,
  "low_carbon_cons_change_twh" DOUBLE,
  "low_carbon_consumption" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_energy_per_capita" DOUBLE,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_share_energy" DOUBLE,
  "net_elec_imports" DOUBLE,
  "net_elec_imports_share_demand" DOUBLE,
  "nuclear_cons_change_pct" DOUBLE,
  "nuclear_cons_change_twh" DOUBLE,
  "nuclear_consumption" DOUBLE,
  "nuclear_elec_per_capita" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "nuclear_energy_per_capita" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_share_energy" DOUBLE,
  "oil_cons_change_pct" DOUBLE,
  "oil_cons_change_twh" DOUBLE,
  "oil_consumption" DOUBLE,
  "oil_elec_per_capita" DOUBLE,
  "oil_electricity" DOUBLE,
  "oil_energy_per_capita" DOUBLE,
  "oil_prod_change_pct" DOUBLE,
  "oil_prod_change_twh" DOUBLE,
  "oil_prod_per_capita" DOUBLE,
  "oil_production" DOUBLE,
  "oil_share_elec" DOUBLE,
  "oil_share_energy" DOUBLE,
  "other_renewable_consumption" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewables_cons_change_pct" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE,
  "other_renewables_elec_per_capita" DOUBLE,
  "other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
  "other_renewables_energy_per_capita" DOUBLE
);