Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	energy_cons_change_pct Energy Cons Change Pct	energy_cons_change_twh Energy Cons Change Twh	coal_cons_change_pct Coal Cons Change Pct	coal_share_energy Coal Share Energy	coal_cons_change_twh Coal Cons Change Twh	coal_consumption Coal Consumption	coal_cons_per_capita Coal Cons Per Capita	hydro_electricity Hydro Electricity	renewables_electricity Renewables Electricity	energy_per_gdp Energy Per Gdp	energy_per_capita Energy Per Capita	fossil_cons_change_pct Fossil Cons Change Pct	fossil_share_energy Fossil Share Energy	fossil_cons_change_twh Fossil Cons Change Twh	fossil_fuel_consumption Fossil Fuel Consumption	fossil_energy_per_capita Fossil Energy Per Capita	gdp Gdp	gas_share_energy Gas Share Energy	gas_cons_change_twh Gas Cons Change Twh	gas_consumption Gas Consumption	gas_energy_per_capita Gas Energy Per Capita	hydro_cons_change_pct Hydro Cons Change Pct	hydro_share_energy Hydro Share Energy	hydro_cons_change_twh Hydro Cons Change Twh	hydro_consumption Hydro Consumption	hydro_elec_per_capita Hydro Elec Per Capita	hydro_energy_per_capita Hydro Energy Per Capita	low_carbon_electricity Low Carbon Electricity	low_carbon_elec_per_capita Low Carbon Elec Per Capita	low_carbon_cons_change_pct Low Carbon Cons Change Pct	low_carbon_share_energy Low Carbon Share Energy	low_carbon_cons_change_twh Low Carbon Cons Change Twh	low_carbon_consumption Low Carbon Consumption	low_carbon_energy_per_capita Low Carbon Energy Per Capita	oil_cons_change_pct Oil Cons Change Pct	oil_share_energy Oil Share Energy	oil_cons_change_twh Oil Cons Change Twh	oil_consumption Oil Consumption	oil_energy_per_capita Oil Energy Per Capita
FIN	Finland	1965				17.814		20.26	4434.579	9.354	9.354	2.038	24893.238		77.154		87.745	19206.167	55796187432						22.846		25.982	2047.351	5687.09	9.354	2047.351		22.846		25.982	5687.09		59.34		67.485	14771.588
FIN	Finland	1966	13.873	15.777	-7.183	14.52	-1.455	18.805	4104.798	10.381	10.381	2.267	28269.271	14.729	77.734	12.924	100.669	21974.843	57128017299					10.983	22.266	2.854	28.836	2266	6294.45	10.381	2266	10.983	22.266	2.854	28.836	6294.45	21.307	63.214	14.379	81.865	17870.045
FIN	Finland	1967	5.145	6.663	-3.79	13.286	-0.713	18.092	3942.744	11.629	11.629	2.334	29674.912	3.174	76.277	3.195	103.865	22635.055	58340959248					12.027	23.723	3.468	32.304	2534.355	7039.88	11.629	2534.355	12.027	23.723	3.468	32.304	7039.88	4.774	62.99	3.908	85.773	18692.312
FIN	Finland	1968	8.8	11.983	20.433	14.707	3.697	21.789	4742.825	10.489	10.489	2.482	32248.683	14.587	80.334	15.151	119.015	25906.59	59681450100					-9.806	19.666	-3.168	29.136	2283.161	6342.119	10.489	2283.161	-9.806	19.666	-3.168	29.136	6342.119	13.354	65.627	11.454	97.227	21163.765
FIN	Finland	1969	10.261	15.202	19.962	16.001	4.349	26.138	5680.914	8.745	8.745	2.497	35503.59	16.842	85.129	20.045	139.06	30223.729	65431181535					-16.622	14.871	-4.843	24.293	1900.759	5279.89	8.745	1900.759	-16.622	14.871	-4.843	24.293	5279.89	16.143	69.128	15.696	112.922	24542.814
FIN	Finland	1970	10.192	16.648	1.643	14.76	0.429	26.568	5760.065	9.524	9.524	2.56	39025.894	10.416	85.302	14.485	153.546	33289.985	70319882662					8.905	14.698	2.163	26.456	2064.937	5735.94	9.524	2064.937	8.905	14.698	2.163	26.456	5735.94	12.447	70.543	14.056	126.978	27529.921
FIN	Finland	1971	2.592	4.666	-11.247	12.769	-2.988	23.579	5093.449	10.681	10.681	2.572	39890.356	0.946	83.934	1.453	154.998	33481.54	71787710060					12.143	16.066	3.213	29.669	2307.183	6408.848	10.681	2307.183	12.143	16.066	3.213	29.669	6408.848	3.497	71.165	4.441	131.419	28388.091
FIN	Finland	1972	5.514	10.183	10.935	13.425	2.578	26.158	5623.913	10.38	10.38	2.522	41892.752	7.109	85.203	11.019	166.018	35693.749	77268847678					-2.818	14.797	-0.836	28.833	2231.651	6199.036	10.38	2231.651	-2.818	14.797	-0.836	28.833	6199.036	6.423	71.778	8.441	139.86	30069.836
FIN	Finland	1973	10.281	20.032	10.988	13.511	2.874	29.032	6209.449	10.58	10.58	2.606	45959.752	11.732	86.324	19.477	185.494	39674.115	82444985189					1.927	13.676	0.556	29.388	2262.841	6285.673	10.58	2262.841	1.927	13.676	0.556	29.388	6285.673	11.871	72.813	16.602	156.462	33464.666
FIN	Finland	1974	-4.291	-9.22	1.906	14.385	0.553	29.585	6296.377	12.703	12.703	2.421	43769.384	-8.15	82.843	-15.118	170.377	36259.765	84941604566	2.161	4.444	4.444	945.872	20.069	17.157	5.898	35.286	2703.473	7509.653	12.703	2703.473	20.069	17.157	5.898	35.286	7509.653	-12.856	66.296	-20.115	136.347	29017.516


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