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	hydro_electricity Hydro 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	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
LVA	Latvia	1985				7.984		8.443	3271.663				2.979		2.979	4.961	2.843	40978.126		92.176		97.481	37772.09			37201218565			19.957		21.105		8177.807	60.042		7.824		8.274	1154.184	3206.069	60.042	2.979	1154.184		7.824		8.274	3206.069					64.236		67.932		26322.619
LVA	Latvia	1986	-7.115	-7.524	26.19	10.847	2.211	10.655	4094.579				3.001		3.001	5.184	2.572	37749.832	-7.781	91.514	-7.585	89.895	34546.558			38189518605		4.574	22.468	0.965	22.07		8481.565	57.885	0.742	8.486	0.061	8.335	1153.189	3203.305	57.885	3.001	1153.189	0.742	8.486	0.061	8.335	3203.305				-15.842	58.2	-10.762	57.17		21970.413
LVA	Latvia	1987	-8.929	-8.771	-8.435	10.905	-0.899	9.756	3713.856				3.699		3.699	5.937	2.352	34055.256	-11.914	88.514	-10.71	79.185	30143.794			38039137400		4.009	25.66	0.885	22.955		8738.5	62.305	23.27	11.486	1.94	10.275	1408.135	3911.489	62.305	3.699	1408.135	23.27	11.486	1.94	10.275	3911.489				-18.71	51.949	-10.697	46.474		17691.439
LVA	Latvia	1988	-5.523	-4.941	0.372	11.586	0.036	9.792	3695.413				3.001		3.001	5.11	2.133	31895.966	-3.79	90.138	-3.001	76.184	28750.329			39628011500		7.689	29.248	1.765	24.72		9328.987	58.724	-18.877	9.862	-1.94	8.335	1132.438	3145.662	58.724	3.001	1132.438	-18.877	9.862	-1.94	8.335	3145.662				-10.334	49.304	-4.803	41.671		15725.929
LVA	Latvia	1989	-0.152	-0.128	-18.335	9.476	-1.795	7.997	3001.864				3.606		3.606	5.801	2.02	31678.832	-2.376	88.13	-1.81	74.373	27918.524			41772726249			29.293		24.72		9279.581	62.166	20.177	11.87	1.682	10.017	1353.719	3760.334	62.166	3.606	1353.719	20.177	11.87	1.682	10.017	3760.334				-0.036	49.361	-0.015	41.656		15637.079
LVA	Latvia	1990	1.505	1.27	3.04	9.619	0.243	8.24	3092.522	10.23	2.15	1.73	4.5	0.42	4.5	6.65	2.035	32149.458	-1.616	85.42	-1.202	73.172	27462.245	806.922	32.331	42100703540	26.015	3.905	29.985	0.965	25.686	649.29	9640.13	67.669	24.673	14.58	2.472	12.489	1688.906	4687.239	67.669	4.5	1688.906	24.673	14.58	2.472	12.489	4687.239	34.995	3.58	6.316	-5.786	45.816	-2.41	39.246	157.631	14729.592
LVA	Latvia	1991	-7.667	-6.568	-12.35	9.131	-1.018	7.222	2726.235	9.88	2.37	1.81	3.28	0.56	3.28	5.65	2.166	29855.727	-4.341	88.498	-3.176	69.995	26421.747	894.623	41.947	36517596963	32.035	-3.758	31.255	-0.965	24.72	683.235	9331.36	58.053	-27.157	11.502	-3.392	9.097	1238.128	3434.004	58.053	3.28	1238.128	-27.157	11.502	-3.392	9.097	3434.004	42.814	4.23	9.912	-3.04	48.112	-1.193	38.053	211.388	14364.152
LVA	Latvia	1992	-28.46	-22.51	-12.029	11.229	-0.869	6.353	2424.755	7.92	1.32	1.15	2.52	0.17	2.52	3.84	2.299	21594.43	-29.167	87.624	-20.415	49.58	18921.888	503.768	34.375	24608100411	29.948	-42.879	24.955	-10.6	14.12	438.889	5388.967	65.625	-23.023	12.376	-2.094	7.003	961.739	2672.559	65.625	2.52	961.739	-23.023	12.376	-2.094	7.003	2672.559	51.515	4.08	4.427	-23.511	51.44	-8.947	29.106	64.879	11108.165
LVA	Latvia	1993	-14.037	-7.943	-8.603	11.938	-0.547	5.807	2248.406	6.43	1.05	0.56	2.88	0.49	2.88	3.93	2.248	18833.367	-18.009	83.576	-8.929	40.651	15740.097	406.558	26.718	21636016750	14.249	-37.466	18.154	-5.29	8.83	216.831	3418.967	73.282	14.082	16.424	0.986	7.989	1115.13	3093.284	73.282	2.88	1115.13	14.082	16.424	0.986	7.989	3093.284	38.88	2.5	12.468	-10.623	53.483	-3.092	26.014	189.727	10072.725
LVA	Latvia	1994	-3.309	-1.609	-24.775	9.288	-1.439	4.368	1717.321	6.26	1.13	0.31	3.31	0.82	3.31	4.44	2.143	18489.614	-6.89	80.48	-2.801	37.85	14880.394	444.247	25.45	21944830346	6.982		18.775		8.83	121.873	3471.423	74.55	14.917	19.52	1.192	9.181	1301.289	3609.234	74.55	3.31	1301.289	14.917	19.52	1.192	9.181	3609.234	29.073	1.82	18.468	-5.237	52.417	-1.362	24.652	322.374	9691.651


CREATE TABLE latvia_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
);