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	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	coal_electricity Coal Electricity	fossil_electricity Fossil Electricity	gas_electricity Gas Electricity	hydro_electricity Hydro Electricity	nuclear_electricity Nuclear Electricity	oil_electricity Oil 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	nuclear_share_elec Nuclear Share Elec	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_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
KAZ	Kazakhstan	1985									72.687		55.779		443.498	3770.556	28310.371	666.059	42517.326	59.068	76.053	8.686	5.21		8.299	5.21	81.263	4.362	50754.13		98.18		780.621	49830.264	4854.749	93.588	182290343205	10.688		11.349		90.234	554.444	5760	38.679	2469.027	6.412		1.82		14.474	332.606	923.907	6.412	5.21	332.606		1.82		14.474	923.907								10.212		31.051		246.888	529.749	15759.893	263.536	16822.586
KAZ	Kazakhstan	1986	5.046	33.613	6.745	2.609	2.78	7.327	2.302	18.3	73.303	5.066	57.287	22.469	465.968	3934.792	29393.928	699.672	44136.299	62.376	80.312	9.172	4.782		8.764	4.782	85.094	4.406	51310.039	2.497	98.367	19.491	800.112	50472.184	5066.21	94.381	184592273544	10.779	21.081	13.432	19.022	109.256	578.594	6892.031	41.288	2604.482	5.619	-8.227	1.633	-1.191	13.283	301.642	837.896	5.619	4.782	301.642	-8.227	1.633	-1.191	13.283	837.896								10.299	-8.911	27.648	-22.001	224.887	552.824	14186.225	270.863	17086.408
KAZ	Kazakhstan	1987	3.3	23.088	8.362	3.452	3.306	8.955	2.234	18.174	72.636	3.904	58.222	18.189	484.157	4007.419	30185.775	722.76	45061.925	64.276	82.758	9.452	5.732		9.031	5.732	88.49	4.532	51845.78	1.942	98.085	15.535	815.646	50853.124	5159.719	93.522	183469478262	10.681	4.464	13.725	4.878	114.134	589.273	7115.892	44.74	2789.41	6.478	19.871	1.915	2.639	15.922	357.371	992.698	6.478	5.732	357.371	19.871	1.915	2.639	15.922	992.698								10.205	-3.349	26.138	-7.532	217.355	563.027	13551.457	279.818	17445.812
KAZ	Kazakhstan	1988	0.312	2.257	13.041	5.834	3.741	10.467	3.624	30.137	71.526	4.309	58.607	20.864	505.021	3902.324	31162.63	725.016	44737.528	63.241	81.426	9.299	6.991		8.885	6.991	88.417	4.338	53171.947	3.266	97.746	26.638	842.284	51973.617	5024.406	92.093	198629915744	10.518	4.274	13.811	4.878	119.011	573.819	7343.645	50.574	3120.726	7.907	21.974	2.254	3.499	19.421	431.414	1198.373	7.907	6.991	431.414	21.974	2.254	3.499	19.421	1198.373								10.049	0.412	25.328	0.896	218.252	548.262	13467.342	290.285	17912.183
KAZ	Kazakhstan	1989	-3.5	-25.372	-5.943	-3.006	1.763	5.117	-1.569	-13.521	71.262	-4.555	56.829	-23.004	482.017	3913.296	29522.99	699.644	42852.365	63.892	82.263	9.395	7.292	0.102	8.977	7.292	89.657	4.291	51950.208	-1.738	97.579	-14.638	827.646	50692.324	5038.532	91.753	197669310639	10.479	3.279	14.491	3.902	122.913	575.433	7528.281	47.569	2913.524	8.133	4.298	2.388	0.835	20.256	446.627	1240.631	8.247	7.394	452.853	5.752	2.421	1.117	20.538	1257.925	0.113		0.033	0.282	0.282	6.226	17.294	10.012	2.045	26.258	4.464	222.715	549.803	13641.053	295.402	18093.021
KAZ	Kazakhstan	1990	-5.129	-35.886	6.013	2.86	1.575	4.652	1.17	9.922	71.12	-6.579	52.477	-31.71	450.307	3792.996	27484.796	663.758	40512.872	62.144	80.013	9.138	7.366		8.731	7.366	87.379	4.402	52374.975	1.208	97.616	9.999	837.645	51126.16	4883.641	91.57	194940981328	10.458	6.587	15.267	8.097	131.01	557.743	7996.259	50.429	3077.974	8.43	1.015	2.384	0.206	20.461	449.588	1248.857	8.43	7.366	449.588	-0.374	2.384	-0.077	20.461	1248.857		-100		-0.282				9.992	15.092	29.871	33.612	256.327	532.902	15645.105	300.054	18313.976
KAZ	Kazakhstan	1991	-0.942	-6.252	10.847	5.47	3.101	9.304	-0.104	-0.89	72.231	-2.383	51.279	-10.733	439.575	3793.457	26847.042	657.506	40157.197	62.111	78.252	8.641	7.2	0.539	7.499	7.2	85.99	4.914	52354.41	-0.23	97.492	-1.927	835.718	51041.48	4779.219	91.001	174429512652	10.049	4.989	16.046	6.536	137.546	527.762	8400.6	55.899	3414.044	8.373	-2.254	2.333	-0.461	20	439.74	1221.501	9	7.739	472.67	5.066	2.508	1.037	21.498	1312.972	0.627		0.175	1.498	1.498	32.93	91.471	8.721	0.886	30.167	2.27	258.597	458	15793.838	309.358	18894.044
KAZ	Kazakhstan	1992	-3.044	-20.014	2.885	1.613	-3.008	-9.304	-1.283	-10.998	71.908	0.738	52.329	3.246	442.82	3668.255	27162.22	637.492	39103.225	59.803	75.839	8.735	6.866	0.464	7.3	6.866	83.166	5.096	51906.223	-1.18	97.594	-9.861	825.857	50657.324	4651.875	91.189	166043897933	10.504	2.837	16.715	3.902	141.448	535.823	8676.272	57.512	3527.735	8.256	-4.639	2.254	-0.928	19.072	421.154	1169.874	8.814	7.33	449.618	-5.286	2.406	-1.136	20.361	1248.94	0.558	-13.934	0.152	-0.209	1.289	28.464	79.066	8.778	-6.577	28.549	-17.009	241.588	447.797	14818.831	300.054	18405.049
KAZ	Kazakhstan	1993	-11.86	-75.608	-17.592	-10.118	-10.853	-32.564	-11.753	-99.457	71.024	-9.19	53.849	-40.694	402.126	3418.779	24851.527	561.884	34724.578	55.32	69.815	7.76	7.629	0.446	6.735	7.629	77.889	4.927	46149.952	-12.294	96.996	-101.528	724.329	44763.712	4314.57	89.634	151572682288	9.963	-4.138	18.158	-5.853	135.594	479.568	8379.782	47.394	2928.978	9.795	11.113	2.838	2.119	21.192	471.474	1309.652	10.368	8.075	499.059	10.168	3.004	2.07	22.432	1386.277	0.573	-3.81	0.166	-0.049	1.24	27.585	76.625	8.647	-22.758	24.989	-54.981	186.608	416.223	11532.402	267.49	16530.952
KAZ	Kazakhstan	1994	-6.626	-37.231	-32.87	-15.579	-11.687	-31.261	-10.982	-82.006	70.539	-2.177	59.176	-8.754	393.372	2939.886	24551.694	524.653	32745.344	47.104	57.222	5.35	9.179	0.38	4.768	9.179	66.777	4.99	41489.464	-11.891	96.006	-86.128	638.201	39832.237	3571.43	85.692	133221814987	8.012	-27.338	14.821	-37.069	98.526	333.936	6149.307	31.816	1985.723	13.746	20.317	3.836	4.306	25.497	572.892	1591.367	14.315	9.559	596.613	18.373	3.994	4.121	26.553	1657.26	0.569	-14.851	0.159	-0.184	1.056	23.721	65.893	7.141	-21.599	22.009	-40.305	146.303	297.609	9131.236	236.229	14743.806


CREATE TABLE kazakhstan_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" VARCHAR,
  "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" VARCHAR,
  "other_renewables_elec_per_capita" DOUBLE,
  "other_renewables_cons_change_pct" DOUBLE,
  "other_renewables_share_energy" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE
);