Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	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	oil_electricity Oil 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	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
EST	Estonia	1985				57.002		67.52	44351.113					17.827	4.655	77806.242		100		118.453	77806.304			25443763184			8.853		10.486		6887.945					34.145		40.446		26567.246
EST	Estonia	1986	-0.481	-0.57	1.216	57.974	0.821	68.342	44492.225					17.951	4.509	76744.95	-0.481	100	-0.57	117.883	76745.012			26143514352		-9.116	8.085	-0.956	9.53		6204.528				-1.076	33.941	-0.435	40.011		26048.258
EST	Estonia	1987	1.513	1.783	0.863	57.603	0.59	68.931	44437.124					17.9	4.533	77143.924	1.513	100	1.783	119.666	77143.986			26398461152		8.342	8.628	0.795	10.325		6656.326				0.997	33.769	0.399	40.41		26050.537
EST	Estonia	1988	-1.699	-2.033	-4.609	55.898	-3.177	65.754	42037.006					17.627	4.245	75203.212	-1.699	100	-2.033	117.633	75203.273			27713411607		7.699	9.453	0.795	11.12		7109.282				0.862	34.649	0.349	40.758		26056.985
EST	Estonia	1989	3.054	3.592	3.523	56.152	2.316	68.071	43357.977					17.611	4.109	77215.035	3.054	100	3.592	121.225	77215.097			29500419354			9.173		11.12		7083.167				3.13	34.675	1.276	42.034		26773.953
EST	Estonia	1990	-0.716	-0.868	-4.807	53.839	-3.272	64.798	41398.258	10.18	17.18	0.96	16.22	17.18	4.447	76893.26	-0.716	100	-0.868	120.357	76893.322	10975.91	100	27066096534	5.588	27.831	11.811	3.095	14.215	613.322	9081.807	-68.762	-7	94.412	-1.644	34.351	-0.691	41.343	10362.588	26413.257
EST	Estonia	1991	-9.716	-11.694	-10.54	53.347	-6.83	57.969	37442.084	9.86	14.63	0.97	13.66	14.63	4.533	70185.76	-9.716	100	-11.694	108.663	70185.816	9449.561	100	23969414022	6.63	0.412	13.136	0.059	14.274	626.526	9219.466	-48.377	-4.77	93.37	-11.906	33.517	-4.923	36.421	8823.035	23524.266
EST	Estonia	1992	-27.689	-30.088	-12.615	64.468	-7.313	50.656	33308.51	8.59	11.83	0.29	11.54	11.83	3.878	51666.643	-27.689	100	-30.088	78.575	51666.685	7778.744	100	20260762853	2.451	-41.534	10.621	-5.929	8.345	190.688	5487.373	-37.718	-3.24	97.549	-46.256	24.911	-16.847	19.574	7588.057	12870.802
EST	Estonia	1993	-20.965	-16.473	-26.53	59.929	-13.439	37.217	25010.35	7.52	9.12	0.13	8.99	9.12	3.405	41733.398	-20.965	100	-16.473	62.102	41733.432	6128.785	100	18240809871	1.425	-50.433	6.661	-4.209	4.136	87.362	2779.796	-21.277	-1.6	98.575	6	33.41	1.174	20.748	6041.423	13943.285
EST	Estonia	1994	0.575	0.357	1.037	60.205	0.386	37.603	25806.881	7.96	9.15	0.22	8.93	9.15	3.538	42865.319	0.575	100	0.357	62.459	42865.353	6279.64	100	17654291517	2.404	43.618	9.511	1.804	5.941	150.986	4077.136	-14.95	-1.19	97.596	-8.837	30.284	-1.833	18.915	6128.654	12981.335


CREATE TABLE estonia_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" VARCHAR,
  "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
);