Energy Dataset Country-Wise (1900-2021)

country Country	year Year	gas_prod_change_pct Gas Prod Change Pct	gas_prod_change_twh Gas Prod Change Twh	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	hydro_electricity Hydro Electricity	nuclear_electricity Nuclear Electricity	renewables_electricity Renewables Electricity	energy_per_gdp Energy Per Gdp	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	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_production Gas Production	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	low_carbon_electricity Low Carbon Electricity	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	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	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_production Oil Production
USSR	1965								50.117		3459.188	81.434	1.861	81.434	4.053		96.648		6670.801	1702799531000		17.629		1216.758			3.277		226.206	83.295		3.352		231.374		0.075		5.168		28.902		1994.85	2824.787
USSR	1966			9.145	258.326	6.338	437.468	3.643	48.847	126.031	3585.219	91.823	2.064	91.823	4.112	6.117	96.447	408.045	7078.846	1785145323000	11.557	18.494	140.616	1357.374		12.758	3.475	28.858	255.064	93.887	12.717	3.553	29.423	260.797	10.926	0.078	0.565	5.733	7.088	29.106	141.398	2136.247	3083.113
USSR	1967			8.676	267.49	5.114	375.343	1.548	47.19	55.501	3640.72	88.571	2.254	88.571	4.139	5.422	96.73	383.848	7462.695	1864068930000	10.097	19.37	137.051	1494.425		-3.542	3.189	-9.033	246.031	90.825	-3.261	3.27	-8.505	252.292	9.208	0.081	0.528	6.261	8.955	30.169	191.296	2327.544	3350.603
USSR	1968			7.324	245.393	3.712	286.414	-0.872	45.104	-31.75	3608.97	104.04	3.133	104.04	4.055	3.229	96.279	241.002	7703.697	1973355036000	7.975	20.167	119.179	1613.604		17.465	3.612	42.969	289	107.173	18	3.721	45.412	297.704	39.02	0.109	2.443	8.704	6.598	31.009	153.573	2481.116	3595.996
USSR	1969			6.177	222.133	4.401	352.164	1.434	43.822	51.737	3660.708	115.181	3.633	115.181	4.175	4.152	96.049	319.83	8023.527	2001067237000	6.868	20.643	110.83	1724.434		10.708	3.83	30.947	319.947	118.814	10.861	3.951	32.334	330.038	15.938	0.121	1.387	10.091	6.338	31.584	157.263	2638.379	3818.129
USSR	1970			7.535	287.715	5.193	433.806	-0.828	41.314	-30.314	3630.394	124.377	4.388	124.377	4.078	5.062	95.93	406.162	8429.689	2154659508000	9.882	21.563	170.414	1894.847	1875.014	7.984	3.932	25.544	345.492	128.765	8.376	4.07	27.644	357.682	20.803	0.139	2.099	12.19	10.084	33.052	266.063	2904.441	4105.844
USSR	1971	7.303	136.924	6.787	278.666	4.917	432.069	2.022	40.174	73.411	3703.805	126.099	5.387	126.099	4.168	5.036	96.038	424.511	8854.201	2212064271000	9.308	22.466	176.371	2071.218	2011.937	1.385	3.799	4.783	350.275	131.486	2.113	3.962	7.558	365.24	22.759	0.162	2.774	14.965	6.016	33.399	174.729	3079.17	4384.51
USSR	1972	4.237	85.252	6.207	272.142	5.149	474.739	2.795	39.274	103.522	3807.328	122.899	9.833	122.899	4.357	5.323	96.197	471.278	9325.479	2224850285000	5.179	22.472	107.265	2178.483	2097.189	-2.538	3.522	-8.889	341.386	132.732	0.948	3.803	3.461	368.701	82.527	0.282	12.35	27.314	8.46	34.45	260.491	3339.661	4656.652
USSR	1973	6.73	141.139	7.143	332.618	5.086	493.069	1.071	37.774	40.768	3848.096	122.345	14.31	122.345	4.224	5.17	96.274	482.172	9807.651	2411718496000	8.752	23.256	190.666	2369.149	2238.328	-0.451	3.336	-1.539	339.847	136.655	2.955	3.726	10.897	379.598	45.528	0.39	12.436	39.75	7.508	35.244	250.738	3590.398	4989.27
USSR	1974	10.284	230.179	6.97	347.737	5.521	562.437	0.491	35.973	18.891	3866.987	132.03	21.461	132.03	4.331	5.258	96.034	515.672	10323.323	2481780684000	6.036	23.37	143.008	2512.157	2468.507	7.916	3.412	26.903	366.75	153.491	12.32	3.966	46.766	426.363	49.969	0.555	19.863	59.613	9.853	36.691	353.773	3944.171	5337.007


CREATE TABLE ussr_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "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" VARCHAR,
  "biofuel_elec_per_capita" VARCHAR,
  "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" VARCHAR,
  "coal_share_elec" VARCHAR,
  "coal_cons_change_pct" DOUBLE,
  "coal_share_energy" DOUBLE,
  "coal_cons_change_twh" DOUBLE,
  "coal_consumption" DOUBLE,
  "coal_elec_per_capita" VARCHAR,
  "coal_cons_per_capita" VARCHAR,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" VARCHAR,
  "electricity_demand" VARCHAR,
  "biofuel_electricity" VARCHAR,
  "coal_electricity" VARCHAR,
  "fossil_electricity" VARCHAR,
  "gas_electricity" VARCHAR,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" VARCHAR,
  "other_renewable_exc_biofuel_electricity" VARCHAR,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" VARCHAR,
  "greenhouse_gas_emissions" VARCHAR,
  "energy_per_gdp" DOUBLE,
  "energy_per_capita" VARCHAR,
  "fossil_cons_change_pct" DOUBLE,
  "fossil_share_energy" DOUBLE,
  "fossil_cons_change_twh" DOUBLE,
  "fossil_fuel_consumption" DOUBLE,
  "fossil_energy_per_capita" VARCHAR,
  "fossil_cons_per_capita" VARCHAR,
  "fossil_share_elec" VARCHAR,
  "gdp" DOUBLE,
  "gas_share_elec" VARCHAR,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" VARCHAR,
  "gas_energy_per_capita" VARCHAR,
  "gas_production" DOUBLE,
  "gas_prod_per_capita" VARCHAR,
  "hydro_share_elec" VARCHAR,
  "hydro_cons_change_pct" DOUBLE,
  "hydro_share_energy" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" VARCHAR,
  "hydro_energy_per_capita" VARCHAR,
  "low_carbon_share_elec" VARCHAR,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" VARCHAR,
  "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" VARCHAR,
  "net_elec_imports_share_demand" VARCHAR,
  "net_elec_imports" VARCHAR,
  "nuclear_share_elec" VARCHAR,
  "nuclear_cons_change_pct" DOUBLE,
  "nuclear_share_energy" DOUBLE,
  "nuclear_cons_change_twh" DOUBLE,
  "nuclear_consumption" DOUBLE,
  "nuclear_elec_per_capita" VARCHAR,
  "nuclear_energy_per_capita" VARCHAR,
  "oil_share_elec" VARCHAR,
  "oil_cons_change_pct" DOUBLE,
  "oil_share_energy" DOUBLE,
  "oil_cons_change_twh" DOUBLE,
  "oil_consumption" DOUBLE,
  "oil_elec_per_capita" VARCHAR,
  "oil_energy_per_capita" VARCHAR,
  "oil_production" DOUBLE,
  "oil_prod_per_capita" VARCHAR,
  "other_renewables_elec_per_capita_exc_biofuel" VARCHAR,
  "other_renewables_elec_per_capita" VARCHAR,
  "other_renewables_cons_change_pct" VARCHAR,
  "other_renewables_share_energy" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE
);