Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	coal_prod_change_pct Coal Prod Change Pct	coal_prod_change_twh Coal Prod Change Twh	gas_prod_change_pct Gas Prod Change Pct	gas_prod_change_twh Gas Prod Change Twh	oil_prod_change_pct Oil Prod Change Pct	oil_prod_change_twh Oil Prod Change Twh	energy_cons_change_pct Energy Cons Change Pct	energy_cons_change_twh Energy Cons Change Twh	biofuel_share_elec Biofuel Share Elec	biofuel_elec_per_capita Biofuel Elec Per Capita	coal_share_elec Coal Share Elec	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_elec_per_capita Coal Elec Per Capita	coal_cons_per_capita Coal Cons Per Capita	coal_production Coal Production	coal_prod_per_capita Coal Prod Per Capita	electricity_demand Electricity Demand	biofuel_electricity Biofuel Electricity	coal_electricity Coal Electricity	fossil_electricity Fossil Electricity	gas_electricity Gas Electricity	hydro_electricity Hydro Electricity	oil_electricity Oil Electricity	other_renewable_electricity Other Renewable Electricity	renewables_electricity Renewables Electricity	electricity_generation Electricity Generation	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	fossil_cons_per_capita Fossil Cons Per Capita	fossil_share_elec Fossil Share Elec	gdp Gdp	gas_share_elec Gas Share Elec	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_elec_per_capita Gas Elec Per Capita	gas_energy_per_capita Gas Energy Per Capita	gas_production Gas Production	gas_prod_per_capita Gas Prod Per Capita	hydro_share_elec Hydro Share Elec	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_share_elec Low Carbon Share Elec	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	net_elec_imports_share_demand Net Elec Imports Share Demand	net_elec_imports Net Elec Imports	oil_share_elec Oil Share Elec	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_elec_per_capita Oil Elec Per Capita	oil_energy_per_capita Oil Energy Per Capita	oil_production Oil Production	oil_prod_per_capita Oil Prod 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
HRV	Croatia	1990									0.113	2.094	7.111		9.425		9.403	131.899	1968.74			15.74	0.01	0.63	4.93	1.36	3.92	2.94	0.01	3.93	8.86	1.709	20888.506		89.406		89.202	18675.66	1032.165	55.643	58374076956	15.35		25.581		25.523	284.735	5343.55			44.244		10.594		10.569	820.707	2212.863	44.357	3.93	822.801		10.594		10.569	2212.863	43.71	6.88	33.183		54.4		54.276	615.53	11363.37			2.094
HRV	Croatia	1991							-16.052	-16.016	0.116	2.101	4.54	-43.775	6.313	-4.116	5.287	81.933	1110.738			13.7	0.01	0.39	3.05	0.74	5.53	1.92	0.01	5.54	8.59	1.838	17595.678	-24.419	80.495	-21.782	67.419	14163.735	640.756	35.506	45560400476	8.615	-7.392	28.22	-1.887	23.636	155.462	4965.547			64.377	54.56	19.505	5.767	16.336	1161.764	3431.957	64.494	5.54	1163.865	54.56	19.505	5.767	16.336	3431.957	37.299	5.11	22.352	-29.073	45.963	-15.779	38.496	403.361	8087.45			2.101
HRV	Croatia	1992							-4.793	-4.014	0.112	2.113	7.416	-12.101	5.828	-0.64	4.647	139.45	981.927	1.137	240.273	11.68	0.01	0.66	4.54	1.37	4.35	2.51	0.01	4.36	8.9	1.979	16848.417	0.333	84.829	0.225	67.644	14292.425	959.25	51.011	40296484886	15.393	3.658	30.725	0.865	24.5	289.465	5176.677	19.739	4170.704	48.876	-26.05	15.15	-4.256	12.081	919.105	2552.484	48.989	4.36	921.218	-25.948	15.171	-4.239	12.097	2556.006	23.801	2.78	28.202		48.276		38.496	530.334	8133.821	25.307	5347.063	2.113		0.021	0.017
HRV	Croatia	1993	-8.757	-0.1	13.627	2.69	1.567	0.396	4.316	3.442	0.209	4.258	4.702	-15.012	4.748	-0.698	3.95	95.795	840.793	1.038	220.882	11.69	0.02	0.45	5	1.82	4.55	2.73	0.02	4.57	9.57	2.192	17707.858	4.21	84.743	2.848	70.492	15006.1	1064.388	52.247	37941876958	19.018	5.584	31.098	1.368	25.868	387.437	5506.826	22.429	4774.682	47.544	4.622	15.194	0.558	12.639	968.593	2690.537	47.753	4.57	972.85	4.914	15.257	0.594	12.692	2701.773	18.135	2.12	28.527	5.656	48.896	2.177	40.674	581.156	8658.481	25.703	5471.679	4.258	216.667	0.063	0.036
HRV	Croatia	1994	-9.853	-0.102	-12.955	-2.906	7.277	1.87	0.846	0.704	0.114	2.147	1.14	-37.407	2.947	-1.477	2.472	21.469	530.764	0.935	200.816	11.83	0.01	0.1	3.33	1.84	5.43	1.39	0.01	5.44	8.77	2.043	18010.023	-2.438	81.983	-1.718	68.773	14765.179	714.93	37.97	41058421506	20.981	-5.913	29.014	-1.53	24.339	395.036	5225.432	19.523	4191.566	61.916	19.451	17.997	2.458	15.097	1165.786	3241.28	62.03	5.44	1167.933	19.085	18.017	2.422	15.114	3244.858	25.866	3.06	15.849	3.168	50.022	1.289	41.962	298.424	9008.983	27.574	5919.908	2.147	-68.421	0.02	-0.036
HRV	Croatia	1995	-35.726	-0.334	9.438	1.843	-13.97	-3.852	3.493	2.93	0.108	2.166	2.589	-17.787	2.341	-0.44	2.032	51.984	440.237	0.601	130.221	12.35	0.01	0.24	3.58	0.88	5.68	2.46	0.01	5.69	9.27	1.956	18804.721	3.263	81.801	2.244	71.017	15382.422	775.435	38.619	44384567029	9.493	-7.576	25.911	-1.844	22.495	190.61	4872.465	21.366	4627.958	61.273	4.563	18.183	0.689	15.786	1230.299	3419.306	61.381	5.69	1232.465	4.54	18.199	0.686	15.8	3422.314	24.939	3.08	26.537	10.789	53.549	4.527	46.489	532.841	10069.719	23.722	5138.195	2.166	-16.667	0.016	-0.003
HRV	Croatia	1996	-16.504	-0.099	-8.624	-1.843	-9.13	-2.166	6.928	6.015	0.09	2.186	1.074	-18.12	1.793	-0.368	1.664	26.23	363.765	0.502	109.724	12.86	0.01	0.12	3.3	1.31	7.86	1.87	0.01	7.87	11.17	1.957	20291.607	-0.077	76.442	-0.055	70.962	15511.295	721.329	29.543	47434643413	11.728	12.057	27.154	2.712	25.207	286.346	5509.921	19.523	4267.531	70.367	38.36	23.528	6.056	21.842	1718.075	4774.255	70.457	7.87	1720.261	38.414	23.558	6.069	21.869	4780.327	13.142	1.69	16.741	-5.159	47.496	-2.399	44.091	408.753	9637.61	21.556	4711.812	2.186	100	0.03	0.014
HRV	Croatia	1997	-28.422	-0.143	-11.115	-2.17	-0.357	-0.077	-0.561	-0.521			4.985	70	3.065	1.165	2.829	112.523	624.198	0.359	79.275	13.61		0.51	4.38	1.17	5.85	2.7		5.85	10.23	1.798	20366.878	7.165	82.381	5.085	76.047	16778.535	966.374	42.815	51344324398	11.437	3.66	28.306	0.923	26.13	258.141	5765.101	17.353	3828.736	57.185	-25.563	17.613	-5.583	16.258	1290.705	3587.134	57.185	5.85	1290.705	-25.632	17.619	-5.606	16.264	3588.36	24.835	3.38	26.393	6.798	51.01	2.997	47.088	595.71	10389.236	21.479	4738.983		-80	0.006	-0.022
HRV	Croatia	1998	4.082	0.015	-1.875	-0.325	5.588	1.2	5.772	5.328	0.087	2.226	4.716	-4.392	2.77	-0.124	2.705	120.216	602.163	0.374	83.254	14.24	0.01	0.54	5.42	1.34	6.02	3.54	0.01	6.03	11.45	1.83	21736.666	6.378	82.854	4.85	80.897	18009.606	1206.615	47.336	53359113205	11.703	-3.872	25.725	-1.012	25.118	298.314	5591.84	17.028	3790.82	52.576	2.887	17.132	0.469	16.728	1340.188	3723.985	52.664	6.03	1342.415	2.938	17.146	0.478	16.742	3727.077	19.593	2.79	30.917	12.713	54.358	5.986	53.075	788.084	11815.603	22.679	5048.93	2.226	150	0.014	0.008
HRV	Croatia	1999	-65.681	-0.246	-1.274	-0.217	-17.726	-4.02	3.214	3.139	0.077	2.244	4.006	-11.308	2.38	-0.306	2.399	116.685	538.32	0.128	28.799	14.6	0.01	0.52	5.64	1.23	7.33	3.89	0.01	7.34	12.98	1.881	22613.898	-0.591	79.799	-0.478	80.419	18045.623	1265.582	43.451	53571236568	9.476	1.391	25.271	0.35	25.468	276.005	5714.76	16.811	3772.309	56.471	21.671	20.196	3.625	20.353	1644.808	4567.046	56.549	7.34	1647.052	21.603	20.201	3.617	20.358	4568.293	11.096	1.62	29.969	-0.983	52.147	-0.522	52.553	872.893	11792.543	18.659	4187.03	2.244	-60	0.006	-0.008


CREATE TABLE croatia_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" 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
);