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	other_renewable_electricity Other Renewable 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	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	other_renewables_elec_per_capita Other Renewables Elec Per Capita	other_renewables_cons_change_pct Other Renewables Cons Change Pct	other_renewables_share_energy Other Renewables Share Energy	other_renewables_cons_change_twh Other Renewables Cons Change Twh
ISL	Iceland	1965				1.018		0.076	395.294	0.641		0.641	2.755	38833.211		76.169		5.688	29579.03	2711260800		23.831		1.78	3331.513	9254.211	0.641	3331.513		23.831		1.78	9254.211		75.151		5.612	29183.737
ISL	Iceland	1966	4.981	0.372	-26.367	0.714	-0.02	0.056	287.073	0.624		0.624	2.662	40207.965	7.36	77.895	0.419	6.107	31320.116	2945495380	-2.622	22.105	-0.047	1.733	3199.635	8887.882	0.624	3199.635	-2.622	22.105	-0.047	1.733	8887.882	7.816	77.181	0.439	6.051	31033.043
ISL	Iceland	1967	-1.018	-0.08	-23.144	0.554	-0.013	0.043	217.935	0.664		0.664	2.668	39312.06	-3.153	76.215	-0.193	5.915	29961.595	2909013992	6.507	23.785	0.113	1.846	3366.176	9350.497	0.664	3366.176	6.507	23.785	0.113	1.846	9350.497	-2.968	75.66	-0.18	5.872	29743.66
ISL	Iceland	1968	5.811	0.451	-21.022	0.414	-0.009	0.034	170.168	0.687		0.687	2.99	41124.791	6.572	76.763	0.389	6.303	31568.723	2746591760	3.371	23.237	0.062	1.908	3440.194	9556.101	0.687	3440.194	3.371	23.237	0.062	1.908	9556.101	6.775	76.349	0.398	6.269	31398.555
ISL	Iceland	1969	-0.529	-0.043	-29.528	0.293	-0.01	0.024	118.554	0.86	0.002	0.862	2.9	40441.007	-8.406	70.684	-0.53	5.773	28585.535	2816529600	25.215	29.251	0.481	2.389	4258.532	11829.265	0.862	4267.959	25.492	29.315	0.486	2.394	11855.452	-8.291	70.391	-0.52	5.75	28466.981	9.427		0.065	0.005
ISL	Iceland	1970	20.593	1.682	-33.179	0.162	-0.008	0.016	78.269	1.413	0.012	1.425	3.254	48184.178	2.047	59.814	0.118	5.892	28820.826	3026862320	64.272	39.845	1.536	3.925	6911.649	19199.04	1.425	6970.796	65.311	40.186	1.564	3.958	19363.337	2.194	59.651	0.126	5.876	28742.557	59.147	535.032	0.341	0.028
ISL	Iceland	1971	8.841	0.871	-31.25	0.103	-0.005	0.011	53.116	1.54	0.012	1.552	3.133	51767.503	8.81	59.797	0.519	6.411	30955.382	3422363752	8.967	39.891	0.352	4.277	7434.269	20650.765	1.552	7492.373	8.887	40.203	0.352	4.31	20812.164	8.919	59.694	0.524	6.4	30902.266	58.104	-0.48	0.312
ISL	Iceland	1972	8.709	0.934	-27.778	0.068	-0.003	0.008	37.844	1.703	0.022	1.724	3.207	55516.615	7.085	58.903	0.454	6.865	32701.095	3634269650	10.587	40.58	0.453	4.729	8110.4	22528.906	1.724	8213.597	11.126	41.097	0.48	4.79	22815.566	7.144	58.835	0.457	6.857	32663.251	103.197	80.038	0.516	0.027
ISL	Iceland	1973	20.728	2.416	-37.063	0.036	-0.003	0.005	23.496	2.181	0.024	2.205	3.625	66118.858	15.73	56.465	1.08	7.945	37333.736	3881376828	28.098	43.058	1.329	6.058	10248.916	28469.233	2.205	10362.636	27.892	43.535	1.336	6.126	28785.123	15.791	56.429	1.083	7.94	37310.24	113.72	11.706	0.478	0.007
ISL	Iceland	1974	-2.612	-0.367	-19.444	0.029	-0.001	0.004	18.685	2.258	0.006	2.264	3.34	63566.08	-6.68	54.106	-0.531	7.414	34393.14	4102783496	3.54	45.777	0.214	6.273	10475.581	29098.859	2.264	10502.259	2.664	45.894	0.163	6.289	29172.965	-6.671	54.077	-0.53	7.41	34374.455	26.678	-76.236	0.117	-0.051


CREATE TABLE iceland_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" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);