Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	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_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	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	gdp Gdp	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	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	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	oil_production Oil Production	oil_prod_per_capita Oil Prod Per Capita
TKM	Turkmenistan	1985								2.617		3.745	1154.388	0.003	0.003	10.987	7.139	44112.97		99.994		143.095	44110.437	20045559792		57.127		81.751	25200.507	787.319	242698.365	0.027		0.006		0.008	0.925	2.569	0.027	0.003	0.925		0.006		0.008	2.569		40.25		57.599	17755.542	78.851	24306.664
TKM	Turkmenistan	1986	1.815	14.291	-3.245	-2.559	24.46	35.003		2.103		3.745	1126.457	0.003	0.003	12.396	8.638	53574.645	24.462	99.995	35.003	178.099	53572.181	20620067292	61.982	74.35	50.671	132.422	39832.591	801.61	241124.768	0.024		0.005		0.008	0.902	2.507	0.024	0.003	0.902		0.005		0.008	2.507	-27.201	23.543	-15.668	41.932	12613.133	76.293	22948.916
TKM	Turkmenistan	1987	4.014	32.178	-1.372	-1.047	-0.519	-0.924		2.114		3.745	1099.067	0.003	0.003	13.267	8.387	52000.752	-0.519	99.995	-0.924	177.174	51998.348	21125900576	-0.665	74.241	-0.88	131.542	38605.754	833.788	244705.678	0.023		0.005		0.008	0.88	2.446	0.023	0.003	0.88		0.005		0.008	2.446	-0.105	23.641	-0.044	41.888	12293.526	75.246	22083.726
TKM	Turkmenistan	1988	0.227	1.893	-11.592	-8.722	0.677	1.2	-14.286	1.799	-0.535	3.21	918.713	0.003	0.003	12.891	7.738	51055.522	0.677	99.995	1.2	178.374	51053.178	23051919786	1.342	74.731	1.765	133.307	38154.25	835.681	239183.388	0.023		0.005		0.008	0.859	2.385	0.023	0.003	0.859		0.005		0.008	2.385	-0.072	23.465	-0.03	41.858	11980.215	66.524	19039.97
TKM	Turkmenistan	1989	1.812	15.143	0.524	0.349	2.751	4.907	16.667	2.043	0.535	3.745	1044.34	0.003	0.003	14.508	8.675	51114.538	2.751	99.995	4.907	183.282	51112.255	21128380000	3.312	75.139	4.415	137.722	38406.846	850.824	237271.349	0.021		0.005		0.008	0.837	2.324	0.021	0.003	0.837		0.005		0.008	2.324	-0.102	22.814	-0.043	41.815	11661.07	66.872	18648.907
TKM	Turkmenistan	1990	-6.864	-58.397	-0.87	-0.581	-17.131	-31.399	14.286	2.818	0.535	4.28	1161.745	0.003	0.003	14.61	7.164	41230.203	-17.131	99.995	-31.399	151.883	41227.974	21201768000	-32.628	61.087	-44.936	92.786	25186.418	792.426	215100.701	0.021		0.005		0.008	0.814	2.262	0.021	0.003	0.814		0.005		0.008	2.262	31.094	36.09	13.002	54.817	14879.811	66.291	17994.407
TKM	Turkmenistan	1991	-3.911	-30.992	-5.263	-3.489	2.699	4.099	-12.5	2.401	-0.535	3.745	988.302	0.003	0.003	14.954	7.632	41167.214	2.699	99.995	4.099	155.982	41165.047	20437995415	-1.999	58.293	-1.855	90.931	23997.554	761.434	200949.056	0.02		0.005		0.008	0.792	2.199	0.02	0.003	0.792		0.005		0.008	2.199	11.838	39.301	6.489	61.306	16179.191	62.802	16573.999
TKM	Turkmenistan	1992	-33.94	-258.431	-3.704	-2.326	-4.5	-7.02	-57.143	1.077	-2.14	1.605	411.54	0.004	0.004	13.183	8.479	38199.102	-4.503	99.992	-7.023	148.959	38196.141	17569984855	-2.904	59.267	-2.64	88.291	22639.566	503.002	128980.192	0.032	40	0.008	0.003	0.012	1.077	2.992	0.032	0.004	1.077	40	0.008	0.003	0.012	2.992	-3.658	39.648	-2.243	59.063	15145.035	60.476	15507.291
TKM	Turkmenistan	1993	17.069	85.855	-15.731	-9.513	-17.908	-26.678	-100		-1.605			0.005	0.005	12.637	6.78	30490.811	-17.911	99.989	-26.681	122.278	30487.373	18037533421		72.196		88.291	22013.313	588.858	146818.369	0.04	19.048	0.011	0.002	0.014	1.247	3.463	0.04	0.005	1.247	19.048	0.011	0.002	0.014	3.463	-42.455	27.792	-25.076	33.988	8474.06	50.963	12706.393
TKM	Turkmenistan	1994	-45.096	-265.554	-4.336	-2.21	6.673	8.161		0.045	0.058	0.058	14.131	0.004	0.004	10.52	8.644	31701.007	6.676	99.991	8.164	130.442	31698.333	15091298497	8.993	73.767	7.94	96.231	23384.859	323.304	78565.128	0.038	-20	0.009	-0.003	0.011	0.972	2.7	0.038	0.004	0.972	-20	0.009	-0.003	0.011	2.7	0.485	26.18	0.165	34.153	8299.343	48.753	11847.319


CREATE TABLE turkmenistan_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" VARCHAR,
  "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" VARCHAR,
  "other_renewables_share_energy" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE
);