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	hydro_electricity Hydro 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	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	gas_production Gas Production	gas_prod_per_capita Gas Prod 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	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	oil_production Oil Production	oil_prod_per_capita Oil Prod Per Capita
BLR	Belarus	1985						6.154		25.112	2536.224	0.02	0.02	33.175	3.716	41209.959		99.986		407.985	41204.381	109799184000		21.207		86.532	8739.279			0.06		0.014		0.056	2.02	5.611	0.06	0.02	2.02		0.014		0.056	5.611		72.625		296.34	29928.879
BLR	Belarus	1986			14.164	57.795	9.396	5.897	2.36	27.472	2756.79	0.02	0.02	36.282	4.13	46746.258	14.166	99.988	57.795	465.78	46740.72	112796186320	1.915	18.931	1.657	88.189	8849.695			0.055		0.012		0.056	2.007	5.575	0.055	0.02	2.007		0.012		0.056	5.575	18.147	75.159	53.778	350.119	35134.235
BLR	Belarus	1987			1.456	6.781	-2.771	5.652	-0.761	26.711	2664.004	0.02	0.02	37.453	4.143	47136.807	1.456	99.988	6.781	472.561	47131.304	114070847462	12.875	21.062	11.355	99.543	9928.072			0.053		0.012		0.056	1.995	5.541	0.053	0.02	1.995		0.012		0.056	5.541	-1.089	73.274	-3.812	346.306	34539.227
BLR	Belarus	1988			1.436	6.786	7.135	5.969	1.906	28.616	2838.585	0.02	0.02	38.15	4.218	47553.958	1.436	99.988	6.786	479.346	47548.485	113655355176	15.789	24.043	15.717	115.26	11433.195			0.052		0.012		0.056	1.984	5.511	0.052	0.02	1.984		0.012		0.056	5.511	-3.129	69.977	-10.837	335.469	33276.705
BLR	Belarus	1989			-3.284	-15.744	-1.831	6.059	-0.524	28.092	2774.821	0.02	0.02	38.489	3.828	45797.814	-3.285	99.988	-15.744	463.602	45792.363	121119311012	5.311	26.179	6.122	121.382	11989.573			0.052		0.012		0.056	1.976	5.488	0.052	0.02	1.976		0.012		0.056	5.488	-6.362	67.75	-21.342	314.127	31027.969
BLR	Belarus	1990			-4.117	-19.088	-12.039	5.558	-3.382	24.71	2434.232	0.02	0.02	39.526	3.801	43794.982	-4.117	99.988	-19.088	444.514	43789.545	116974867000	6.544	29.09	7.943	129.325	12739.968			0.051		0.012		0.056	1.97	5.473	0.051	0.02	1.97		0.012		0.056	5.473	-7.528	65.339	-23.649	290.478	28615.344
BLR	Belarus	1991			-1.081	-4.804	-5.006	5.338	-1.237	23.473	2310.173	0.018	0.018	38.735	3.857	43280.605	-1.079	99.989	-4.798	439.715	43275.719	114005495316	4.658	30.778	6.024	135.349	13320.709			0.046	-10	0.011	-0.006	0.05	1.772	4.921	0.046	0.018	1.772	-10	0.011	-0.006	0.05	4.921	-3.3	63.873	-9.585	280.893	27644.836
BLR	Belarus	1992			-5.389	-23.697	-16.713	4.699	-3.923	19.55	1925.306	0.017	0.017	37.595	4.084	40974.384	-5.389	99.989	-23.694	416.021	40969.767	101880773333	16.128	37.777	21.83	157.178	15478.943	3.115	306.751	0.045	-5.556	0.011	-0.003	0.047	1.674	4.65	0.045	0.017	1.674	-5.556	0.011	-0.003	0.047	4.65	-14.81	57.513	-41.601	239.292	23565.518	25.251	2486.709
BLR	Belarus	1993	-0.273	-0.069	-19.911	-82.845	-14.118	5.039	-2.76	16.79	1656.621	0.019	0.019	33.369	3.581	32877.963	-19.915	99.984	-82.851	333.17	32872.782	93050202894	-7.218	43.764	-11.345	145.833	14388.863	3.115	307.332	0.057	11.765	0.016	0.006	0.053	1.875	5.207	0.057	0.019	1.875	11.765	0.016	0.006	0.053	5.207	-28.729	51.181	-68.745	170.547	16827.299	25.182	2484.614
BLR	Belarus	1994	-0.623	-0.157	-16.668	-55.542	-29.936	4.236	-5.026	11.764	1163.775	0.019	0.019	31.397	3.419	27470.62	-16.671	99.981	-55.542	277.628	27465.42	81212697200	-12.581	45.911	-18.347	127.486	12612.01	3.115	308.148	0.061		0.019		0.053	1.88	5.221	0.061	0.019	1.88		0.019		0.053	5.221	-18.862	49.834	-32.168	138.379	13689.635	25.025	2475.687


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