Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	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	electricity_demand Electricity Demand	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	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	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
LTU	Lithuania	1985						5.253		9.458	2654.871				0.393	9.48		0.393	20.962	3.778	50543.57		84.769		152.632	42845.187			47660894184			22.655		40.792		11450.691	1.876		0.607		1.093	110.411	306.696	47.099	9.873	2771.43		15.231		27.425	7698.423			45.223		14.624		26.332	2661.019	7391.727			56.861		102.382		28739.625
LTU	Lithuania	1986			-7.768	-13.987	16.384	6.628	1.55	11.007	3062.618				0.384	9.882		0.384	22.416	3.357	46206.687	-9.879	82.828	-15.079	137.552	38272.133			49468977531		0.212	24.615	0.087	40.878		11373.891	1.715	-2.247	0.643	-0.025	1.068	106.979	297.163	45.799	10.266	2856.451	3.984	17.172	1.093	28.517	7934.591			44.084	4.242	16.529	1.117	27.449	2749.472	7637.428		-16.326	51.585	-16.715	85.667		23835.624
LTU	Lithuania	1987			4.808	7.985	-1.562	6.225	-0.172	10.835	2987.134				0.362	9.184		0.362	22.755	3.445	47984.246	7.26	84.765	9.986	147.538	40674.1			50529331709		4.447	24.53	1.818	42.696		11770.73	1.593	-5.747	0.578	-0.061	1.007	99.906	277.516	41.951	9.546	2631.664	-7.017	15.235	-2.001	26.516	7310.184			40.358	-7.066	14.656	-1.94	25.51	2531.758	7032.668		9.735	54.01	8.34	94.007		25916.236
LTU	Lithuania	1988			4.844	8.431	0.81	5.986	0.088	10.923	2985.68				0.384	12.812		0.384	26	3.345	49879.886	-1.158	79.913	-1.709	145.829	39860.373			54561831450		4.257	24.393	1.818	44.514		12167.311	1.479	6.098	0.585	0.061	1.068	105.094	291.929	50.755	13.196	3607.036	38.241	20.087	10.14	36.656	10019.554			49.276	39.509	19.502	10.079	35.588	3501.942	9727.624		-3.845	49.534	-3.615	90.392		24707.382
LTU	Lithuania	1989			8.233	15.023	-6.568	5.167	-0.717	10.206	2771.364				0.384	16.652		0.384	29.158	3.652	53633.615	2.987	76.039	4.356	150.185	40782.683			54088606250		6.125	23.918	2.727	47.241		12828.242	1.319		0.541		1.068	104.408	290.022	58.429	17.037	4626.347	29.102	23.961	10.668	47.324	12850.975			57.111	29.976	23.42	10.668	46.256	4521.939	12560.953		2.596	46.954	2.346	92.738		25183.077
LTU	Lithuania	1990			1.664	3.287	-9.154	4.617	-0.934	9.271	2508.484	16.38	10.92	6.77	0.41	17.03	4.15	0.41	28.36	3.935	54327.381	1.43	75.864	2.148	152.332	41215.014	2954.517	38.505	51021990324	23.872	15.186	27.099	7.174	54.414	1831.693	14722.395	1.446	7.676	0.573	0.082	1.15	110.93	311.144	61.495	17.44	4718.57	2.408	24.136	1.139	48.464	13112.41	-73.138	-11.98	60.049	2.286	23.563	1.058	47.314	4607.64	12801.266	14.633	-4.412	44.147	-4.092	88.646	1122.825	23984.135
LTU	Lithuania	1991			5.755	11.557	11.691	4.876	1.084	10.355	2800.675	16.58	11.99	6.29	0.34	17	5.7	0.34	29.33	4.414	57432.177	7.785	77.32	11.86	164.192	44406.723	3242.775	40.88	48112085208	21.446	3.518	26.526	1.914	56.329	1701.172	15234.492	1.159	-18.357	0.442	-0.211	0.939	91.955	253.929	59.12	17.34	4689.717	-0.625	22.68	-0.303	48.161	13025.5	-76.9	-12.75	57.961	-0.194	22.238	-0.092	47.222	4597.762	12771.572	19.434	9.996	45.918	8.861	97.507	1541.603	26371.555
LTU	Lithuania	1992			-38.874	-82.55	-53.133	3.739	-5.502	4.853	1315.908	13.23	3.58	1.26	0.31	14.64	2.32	0.31	18.53	3.428	35194.993	-46.235	68.009	-75.914	88.278	23935.836	970.689	19.32	37861880282	6.8	-42.871	24.792	-24.149	32.18	341.639	8725.417	1.673	-7.988	0.666	-0.075	0.864	84.054	234.237	80.68	14.95	4053.574	-13.779	31.991	-6.636	41.525	11259.185	-40.06	-5.3	79.007	-13.894	31.325	-6.561	40.661	3969.52	11024.948	12.52	-47.446	39.479	-46.263	51.244	629.05	13894.512
LTU	Lithuania	1993		1.007	-21.856	-28.37	-11.335	4.242	-0.55	4.303	1172.299	11.18	1.26	0.26	0.39	12.26	1	0.39	13.91	3.198	27633.486	-24.912	65.349	-21.992	66.286	18058.304	343.263	9.058	31722383759	1.869	-45.916	17.158	-14.776	17.404	70.832	4741.475	2.804	26.367	1.076	0.228	1.092	106.248	297.404	90.942	12.65	3446.253	-15.359	34.651	-6.378	35.147	9575.204	-24.419	-2.73	88.138	-16.245	33.574	-6.606	34.056	3340.005	9277.8	7.189	-13.008	43.949	-6.666	44.578	272.431	12144.53	1.007	274.413
LTU	Lithuania	1994	81.25	0.818	-13.538	-13.732	-16.973	4.074	-0.73	3.573	979.063	10.83	1.57	0.33	0.45	7.71	1.24	0.45	9.73	3.065	24033.244	-1.88	74.161	-1.246	65.04	17823.275	430.238	16.136	28612205261	3.392	15.69	22.959	2.731	20.135	90.432	5517.745	4.625	15.013	1.432	0.164	1.256	123.317	344.069	83.864	8.16	2236.142	-35.525	25.839	-12.486	22.661	6209.988	10.157	1.1	79.239	-37.145	24.408	-12.65	21.406	2112.825	5865.919	12.744	-7.283	47.128	-3.246	41.332	339.806	11326.467	1.826	500.306


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