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	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	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
LUX	Luxembourg	1965				75.897		31.716	96063.116	0.086	0.086	7.003	126570.663		99.426		41.549	125843.742	5967663000							0.574		0.24	261.728	727.022	0.086	261.728		0.574		0.24	727.022		23.529		9.832	29780.626
LUX	Luxembourg	1966	-4.176	-1.745	-9.706	71.517	-3.078	28.638	86148.476	0.078	0.078	6.632	120458.819	-4.143	99.461	-1.721	39.827	119809.149	6038157180						-10.014	0.539	-0.024	0.216	233.916	649.767	0.078	233.916	-10.014	0.539	-0.024	0.216	649.767	13.803	27.944	1.357	11.19	33660.672
LUX	Luxembourg	1967	-1.517	-0.608	-6.299	68.045	-1.804	26.834	80284.831	0.088	0.088	6.516	117988.332	-1.595	99.382	-0.635	39.192	117259.088	6052326792						12.858	0.618	0.028	0.244	262.562	729.338	0.088	262.562	12.858	0.618	0.028	0.244	729.338	10.442	31.337	1.168	12.358	36974.257
LUX	Luxembourg	1968	8.158	3.217	7.186	67.433	1.928	28.762	85645.302	0.09	0.09	6.764	127007.391	8.195	99.416	3.212	42.404	126266.11	6305567058						2.137	0.584	0.005	0.249	266.898	741.383	0.09	266.898	2.137	0.584	0.005	0.249	741.383	10.387	31.983	1.284	13.642	40620.808
LUX	Luxembourg	1969	7.627	3.253	6.235	66.561	1.793	30.555	90516.647	0.078	0.078	6.63	135990.224	7.748	99.528	3.286	45.689	135348.511	6924150000		0.064	0.029	0.029	86.649	-12.981	0.472	-0.032	0.217	231.056	641.822	0.078	231.056	-12.981	0.472	-0.032	0.217	641.822	10.724	32.903	1.463	15.105	44745.216
LUX	Luxembourg	1970	3.834	1.76	2.535	65.729	0.775	31.33	92236.281	0.086	0.086	6.769	140328.852	3.802	99.498	1.737	47.426	139623.92	7042269762	149.404	0.153	0.044	0.073	214.768	10.535	0.502	0.023	0.239	253.815	705.043	0.086	253.815	10.535	0.502	0.023	0.239	705.043	6.083	33.616	0.919	16.023	47172.872
LUX	Luxembourg	1971	-3.839	-1.83	-7.844	62.991	-2.457	28.873	84365.755	0.049	0.049	6.339	133931.96	-3.639	99.705	-1.726	45.7	133536.542	7230460800	100.873	0.32	0.074	0.147	428.184	-43.478	0.295	-0.104	0.135	142.389	395.525	0.049	142.389	-43.478	0.295	-0.104	0.135	395.525	4.106	36.394	0.658	16.681	48742.603
LUX	Luxembourg	1972	3.117	1.429	-1.583	60.12	-0.457	28.416	82339.242	0.057	0.057	6.133	136957.007	3.073	99.662	1.404	47.105	136494.597	7706997600	700	2.48	1.026	1.172	3396.961	17.919	0.338	0.024	0.16	166.506	462.518	0.057	166.506	17.919	0.338	0.024	0.16	462.518	5.009	37.062	0.836	17.517	50758.395
LUX	Luxembourg	1973	6.014	2.842	-0.913	56.193	-0.259	28.156	80867.408	0.051	0.051	6.002	143911.184	6.074	99.719	2.861	49.966	143506.549	8347719000	100	4.679	1.172	2.345	6733.94	-11.71	0.281	-0.019	0.141	145.71	404.75	0.051	145.71	-11.71	0.281	-0.019	0.141	404.75	11.121	38.847	1.948	19.465	55905.2
LUX	Luxembourg	1974	1.544	0.774	6.609	58.995	1.861	30.017	85472.405	0.075	0.075	5.848	144880.258	1.414	99.591	0.707	50.672	144287.635	8699790150	34.375	6.192	0.806	3.151	8971.125	47.713	0.409	0.067	0.208	213.386	592.739	0.075	213.386	47.713	0.409	0.067	0.208	592.739	-10.07	34.404	-1.96	17.505	49844.104


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