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	hydro_electricity Hydro Electricity	nuclear_electricity Nuclear Electricity	renewables_electricity Renewables Electricity	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	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_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	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_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
CHE	Switzerland	1965				8.326		14.833	2551.822	24.097		24.097	1.514	30647.614		62.427		111.213	19132.286	117686331787							37.573		66.937	4145.524	11515.353	24.097	4145.524		37.573		66.937	11515.353								54.1		96.38	16580.463
CHE	Switzerland	1966	7.31	13.023	-17.322	6.415	-2.569	12.264	2078.811	27.519		27.519	1.576	32404.992	3.164	60.015	3.519	114.732	19447.831	121266331047						14.198	39.985	9.504	76.441	4664.584	12957.187	27.519	4664.584	14.198	39.985	9.504	76.441	12957.187							6.317	53.6	6.089	102.468	17369.02
CHE	Switzerland	1967	6.759	12.922	-15.651	5.068	-1.919	10.344	1731.596	29.85		29.85	1.623	34164.08	5.617	59.373	6.445	121.177	20284.268	125760276907						8.473	40.627	6.477	82.917	4996.738	13879.839	29.85	4996.738	8.473	40.627	6.477	82.917	13879.839							8.163	54.305	8.364	110.832	18552.672
CHE	Switzerland	1968	5.195	10.603	-5.478	4.554	-0.567	9.778	1619.287	29.515		29.515	1.636	35555.784	9.518	61.813	11.534	132.711	21978.028	131196509404						-1.122	38.187	-0.93	81.987	4887.998	13577.784	29.515	4887.998	-1.122	38.187	-0.93	81.987	13577.784							10.918	57.259	12.1	122.933	20358.741
CHE	Switzerland	1969	3.622	7.777	-9.545	3.975	-0.933	8.844	1450.76	28.245	0.535	28.245	1.605	36492.615	7.399	64.066	9.819	142.53	23379.246	138575264054		0.001	0.003	0.002	0.41	-4.304	35.266	-3.528	78.459	4633.063	12869.63	28.78	4720.819	-2.491	35.934	-2.042	79.945	13113.398		0.668	1.486	1.486	87.756	243.768	8.745	60.089	10.75	133.683	21928.076
CHE	Switzerland	1970	9.555	21.258	-14.196	3.114	-1.256	7.589	1233.797	29.173	1.766	29.173	1.656	39625.774	10.708	64.74	15.262	157.792	25653.635	147142841610	15300	0.158	0.383	0.385	62.593	3.284	33.248	2.576	81.035	4742.863	13174.629	30.939	5029.978	7.5	35.26	5.996	85.941	13972.171	230.093	2.013	3.419	4.906	287.115	797.542	12.069	61.468	16.135	149.818	24357.245
CHE	Switzerland	1971	2.397	5.843	-32.467	2.053	-2.464	5.125	826.22	29.044	1.391	29.044	1.607	40234.958	4.59	66.126	7.243	165.035	26605.836	155328076772	141.558	0.373	0.545	0.93	149.929	-0.442	32.326	-0.358	80.677	4682.243	13006.242	30.435	4906.491	-1.629	33.874	-1.4	84.541	13629.154	-21.234	1.548	-1.042	3.864	224.248	622.912	6.115	63.7	9.162	158.98	25629.687
CHE	Switzerland	1972	-1.237	-3.086	-15.393	1.759	-0.789	4.336	693.636	24.234	3.84	24.234	1.519	39430.132	2.103	68.362	3.471	168.506	26955.372	162319729435	26.882	0.479	0.25	1.18	188.761	-16.56	27.31	-13.36	67.317	3876.648	10768.474	28.074	4490.921	-7.757	31.638	-6.557	77.983	12474.791	176.06	4.327	6.803	10.667	614.274	1706.317	2.522	66.124	4.01	162.989	26072.975
CHE	Switzerland	1973	10.556	26.02	-5.061	1.511	-0.219	4.117	654.215	26.587	6.31	26.587	1.627	43306.762	7.492	66.467	12.624	181.13	28784.908	167492529974	35.381	0.586	0.418	1.598	253.872	9.708	27.101	6.535	73.852	4225.101	11736.4	32.897	5227.876	17.178	33.533	13.396	91.38	14521.889	64.323	6.432	6.861	17.528	1002.775	2785.488	7.624	64.371	12.426	175.416	27876.821
CHE	Switzerland	1974	-4.585	-12.495	-13.765	1.365	-0.567	3.55	561.531	27.85	7.067	27.85	1.565	41128.506	-9.997	62.697	-18.108	163.022	25786.441	166140026784	110.642	1.294	1.768	3.365	532.268	4.753	29.753	3.511	77.362	4405.309	12236.98	34.917	5523.151	6.143	37.303	5.613	96.993	15342.098	11.997	7.55	2.103	19.631	1117.841	3105.117	-11.008	60.038	-19.309	156.107	24692.642


CREATE TABLE switzerland_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" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "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" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "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" VARCHAR,
  "oil_prod_per_capita" VARCHAR,
  "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
);