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	nuclear_electricity Nuclear Electricity	renewables_electricity Renewables Electricity	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	gas_cons_change_pct Gas Cons Change Pct	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	nuclear_cons_change_pct Nuclear Cons Change Pct	nuclear_share_energy Nuclear Share Energy	nuclear_cons_change_twh Nuclear Cons Change Twh	nuclear_consumption Nuclear Consumption	nuclear_elec_per_capita Nuclear Elec Per Capita	nuclear_energy_per_capita Nuclear 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
SVK	Slovakia	1965				65.983		70.231	16021.781	2.223		2.223	24281.772		94.199		100.263	22873.108		2.805		2.985	681.04		5.801		6.175	507.126	1408.684	2.223	507.126		5.801		6.175	1408.684								25.411		27.047	6170.287
SVK	Slovakia	1966	3.536	3.764	1.258	64.53	0.883	71.114	16095.643	2.13		2.13	24942.696	4.011	94.631	4.022	104.285	23603.463	11.215	3.013	0.335	3.32	751.46	-4.175	5.369	-0.258	5.917	482.131	1339.253	2.13	482.131	-4.175	5.369	-0.258	5.917	1339.253							10.366	27.088	2.804	29.851	6756.359
SVK	Slovakia	1967	0.576	0.635	-3.573	61.869	-2.541	68.573	15414.715	1.825		1.825	24915.227	1.421	95.426	1.482	105.767	23775.541	19.888	3.591	0.66	3.98	894.764	-14.315	4.574	-0.847	5.07	410.294	1139.705	1.825	410.294	-14.315	4.574	-0.847	5.07	1139.705							11.263	29.966	3.362	33.213	7466.062
SVK	Slovakia	1968	10.419	11.548	5.169	58.927	3.545	72.118	16109.158	1.675		1.675	27337.407	11.313	96.198	11.966	117.732	26298.155	123.885	7.282	4.931	8.912	1990.585	-8.232	3.802	-0.417	4.653	374.138	1039.274	1.675	374.138	-8.232	3.802	-0.417	4.653	1039.274							10.507	29.99	3.49	36.703	8198.413
SVK	Slovakia	1969	4.492	5.498	5.184	59.317	3.738	75.856	16833.946	1.304		1.304	28379.582	5.546	97.168	6.529	124.261	27575.936	1.344	7.062	0.12	9.031	2004.206	-22.164	2.832	-1.031	3.621	289.321	803.669	1.304	289.321	-22.164	2.832	-1.031	3.621	803.669							7.277	30.789	2.671	39.374	8737.784
SVK	Slovakia	1970	10.555	13.498	0.813	54.09	0.617	76.473	16848.64	1.967		1.967	31149.141	9.381	96.136	11.657	135.918	29945.583	34.284	8.578	3.096	12.128	2671.939	50.847	3.864	1.841	5.463	433.289	1203.583	1.967	433.289	50.847	3.864	1.841	5.463	1203.583							20.175	33.468	7.944	47.317	10425.005
SVK	Slovakia	1971	7.267	10.275	4.904	52.899	3.75	80.224	17533.104	1.476		1.476	33144.69	8.562	97.297	11.637	147.556	32248.651	25.531	10.038	3.096	15.224	3327.19	-24.948	2.703	-1.363	4.1	322.583	896.066	1.476	322.583	-24.948	2.703	-1.363	4.1	896.066							10.125	34.359	4.791	52.108	11388.358
SVK	Slovakia	1972	5.165	7.833	1.783	51.197	1.43	81.654	17690.042	1.546	0.003	1.546	34552.548	5.171	97.302	7.63	155.186	33620.397	8.593	10.366	1.308	16.532	3581.587	4.743	2.693	0.194	4.294	334.934	930.373	1.549	335.584	4.946	2.698	0.203	4.303	932.179		0.005	0.008	0.008	0.65	1.805	9.388	35.739	4.892	57	12348.768
SVK	Slovakia	1973	4.061	6.477	-2.763	47.84	-2.256	79.398	17040.853	1.322	0.232	1.322	35620.409	4.164	97.399	6.463	161.649	34693.97	9.826	10.94	1.625	18.156	3896.852	-14.489	2.213	-0.622	3.672	283.735	788.153	1.554	333.528	0.323	2.601	0.014	4.317	926.468	7633.333	0.388	0.636	0.644	49.793	138.314	12.446	38.619	7.094	64.094	13756.265
SVK	Slovakia	1974	5.149	8.545	-0.337	45.344	-0.267	79.131	16818.038	2.223	0.486	2.223	37089.652	3.302	95.688	5.337	166.986	35490.352	21.919	12.685	3.98	22.136	4704.737	68.154	3.538	2.503	6.175	472.466	1312.406	2.709	575.758	74.324	4.312	3.208	7.525	1599.329	109.483	0.774	0.706	1.35	103.292	286.923	2.535	37.659	1.625	65.719	13967.577


CREATE TABLE slovakia_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" DOUBLE,
  "gas_prod_change_twh" DOUBLE,
  "oil_prod_change_pct" DOUBLE,
  "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" 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
);