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
AZE	Azerbaijan	1985								0.456		1.07	160.499	1.313	1.313	20.702	4.101	35176.344		98.445		230.855	34629.453	57181877346		56.545		132.6	19890.629	137.172	20576.497	6.34		1.555		3.646	196.891	546.919	6.34	1.313	196.891		1.555		3.646	546.919		41.444		97.186	14578.324	153.865	23080.496
AZE	Azerbaijan	1986	-3.34	-4.582	-1.361	-2.093	7.655	17.951		0.424		1.07	157.843	0.804	0.804	21.542	4.3	37242.393	8.387	99.115	19.363	250.218	36912.82	58704585599	11.109	58.36	14.731	147.331	21734.621	132.59	19559.992	3.734	-38.721	0.885	-1.412	2.234	118.657	329.603	3.734	0.804	118.657	-38.721	0.885	-1.412	2.234	329.603	4.766	40.331	4.632	101.817	15020.356	151.772	22389.698
AZE	Azerbaijan	1987	-8.088	-10.724	6.59	10.002	-3.093	-7.809		0.437		1.07	155.213	0.804	0.804	22.909	3.957	35489.118	-3.121	99.087	-7.809	242.41	35165.036	61831432110	-1.234	59.479	-1.818	145.513	21108.73	121.866	17678.397	3.511		0.913		2.234	116.68	324.111	3.511	0.804	116.68		0.913		2.234	324.111	-5.884	39.17	-5.99	95.827	13901.092	161.773	23467.561
AZE	Azerbaijan	1988	-4.8	-5.85	-1.222	-1.977	0.083	0.203		0.437		1.07	152.633	0.698	0.698	23.572	3.763	34928.142	0.205	99.208	0.498	242.908	34651.476	65070243744	-1.25	58.687	-1.818	143.694	20498.423	116.016	16550.04	2.962	-13.187	0.792	-0.295	1.94	99.609	276.693	2.962	0.698	99.609	-13.187	0.792	-0.295	1.94	276.693	2.417	40.083	2.316	98.143	14000.421	159.796	22795.376
AZE	Azerbaijan	1989	-6.723	-7.799	-4.221	-6.745	1.975	4.836		0.429		1.07	150.13	0.698	0.698	23.3	4.175	35034	1.991	99.223	4.836	247.744	34761.871	59803710435	5.065	60.466	7.278	150.972	21183.518	108.217	15184.325	2.997		0.777		1.94	97.976	272.157	2.997	0.698	97.976		0.777		1.94	272.157	-2.488	38.329	-2.442	95.701	13428.223	153.051	21475.157
AZE	Azerbaijan	1990	-10.811	-11.699	-5.015	-7.676	4.134	10.323	-3.261	0.398	-0.035	1.035	142.911	1.658	1.658	23.152	4.884	35898.695	3.091	98.229	7.657	255.4	35262.839	53235602172	1.986	59.218	2.998	153.97	21258.508	96.518	13326.097	7.161	137.446	1.771	2.666	4.606	228.918	635.885	7.161	1.658	228.918	137.446	1.771	2.666	4.606	635.885	4.904	38.613	4.694	100.395	13861.42	145.375	20071.774
AZE	Azerbaijan	1991	-13.131	-12.674	-5.81	-8.447	-3.926	-10.207	-24.719	0.312	-0.256	0.779	105.901	1.759	1.759	23.45	4.676	33949.443	-4.107	98.044	-10.489	244.911	33285.298	53426624440	-4.312	58.98	-6.639	147.331	20023.386	83.844	11394.983	7.503	6.11	1.956	0.281	4.887	239.102	664.173	7.503	1.759	239.102	6.11	1.956	0.281	4.887	664.173	-3.58	38.752	-3.594	96.801	13156.011	136.928	18609.562
AZE	Azerbaijan	1992	-8.14	-6.824	-4.909	-6.722	-14.373	-35.902	-82.09	0.065	-0.64	0.14	18.678	1.747	1.747	19.763	5.118	28626.592	-14.646	97.731	-35.869	209.042	27977.035	41795271192	-22.227	53.57	-32.748	114.583	15335.163	77.019	10307.81	8.841	-0.682	2.269	-0.033	4.854	233.849	649.58	8.841	1.747	233.849	-0.682	2.269	-0.033	4.854	649.58	-2.564	44.096	-2.482	94.319	12623.194	130.206	17426.033
AZE	Azerbaijan	1993	-13.924	-10.724	-8.435	-10.983	-13.318	-28.487	-75	0.019	-0.105	0.035	4.602	2.426	2.426	19.051	5.707	24454.62	-14.529	96.365	-30.372	178.67	23565.809	32486442076	-26.185	45.618	-30.003	84.58	11155.703	66.295	8744.017	12.734	38.843	3.635	1.885	6.739	319.979	888.831	12.734	2.426	319.979	38.843	3.635	1.885	6.739	888.831	-0.28	50.729	-0.264	94.055	12405.504	119.223	15724.939
AZE	Azerbaijan	1994	-5.882	-3.9	-6.716	-8.007	-8.09	-15	33.333	0.027	0.012	0.047	6.054	1.83	1.83	17.571	6.462	22177.978	-7.469	97.017	-13.344	165.326	21516.422	26372109694	-6.455	46.43	-5.46	79.12	10297.144	62.395	8120.469	10.415	-24.567	2.983	-1.656	5.083	238.166	661.574	10.415	1.83	238.166	-24.567	2.983	-1.656	5.083	661.574	-8.395	50.56	-7.896	86.159	11213.224	111.215	14474.186


CREATE TABLE azerbaijan_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" DOUBLE,
  "other_renewables_share_energy" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE
);