Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	coal_prod_change_pct Coal Prod Change Pct	coal_prod_change_twh Coal Prod Change Twh	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_share_elec Coal Share Elec	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_elec_per_capita Coal Elec Per Capita	coal_cons_per_capita Coal Cons Per Capita	coal_production Coal Production	coal_prod_per_capita Coal Prod Per Capita	coal_electricity Coal Electricity	fossil_electricity Fossil Electricity	gas_electricity Gas Electricity	hydro_electricity Hydro Electricity	nuclear_electricity Nuclear Electricity	oil_electricity Oil Electricity	other_renewable_electricity Other Renewable 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	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	nuclear_share_elec Nuclear Share Elec	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_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	oil_production Oil Production	oil_prod_per_capita Oil Prod Per Capita	other_renewables_elec_per_capita Other Renewables Elec Per Capita	other_renewables_cons_change_pct Other Renewables Cons Change Pct	other_renewables_share_energy Other Renewables Share Energy	other_renewables_cons_change_twh Other Renewables Cons Change Twh
RUS	Russia	1985									14.382		24.199		2303.885	967.79	16115.911	2160.92	15115.844	138.353	702.957	451.267	159.726	99.317	113.337		159.726	962	5.302	66597.386		92.442		8801.024	61564.013	4917.251	73.072	1795626512575	46.909		37.402		3560.848	3156.658	24908.495	4248.812	29720.853	16.604		4.66		443.684	1117.299	3103.609	26.928	259.043	1812.032		7.558		719.565	5033.426	10.324		2.898		275.881	694.733	1929.816	11.781		30.841		2936.284	792.804	20539.607	6307.019	44118.206
RUS	Russia	1986	3.427	74.057	8.87	376.859	3.481	219.528	1.766	168.139	14.384	2.716	24.425	62.576	2366.461	1000.301	16434.301	2234.977	15521.174	144.039	731.848	469.814	164.331	105.221	117.995		164.331	1001.4	5.265	67284.954	1.579	92.272	138.946	8939.97	62085.135	5082.439	73.082	1840205385700	46.916	1.16	37.179	41.295	3602.143	3262.701	25015.712	4625.671	32123.755	16.41	2.883	4.711	12.792	456.475	1141.224	3170.07	26.918	269.552	1871.953	4.057	7.728	29.193	748.757	5199.873	10.507	5.945	3.017	16.401	292.282	730.728	2029.803	11.783	1.195	30.668	35.075	2971.359	819.437	20635.121	6526.547	45324.706
RUS	Russia	1987	0.811	18.115	8.211	379.802	1.479	96.517	3.275	317.328	14.284	1.526	24.011	36.103	2402.564	1031.444	16565.663	2253.092	15535.041	149.593	760.07	487.931	162.528	124.702	122.545		162.528	1047.3	5.442	68991.579	3	92.026	268.224	9208.195	63490.386	5240.673	72.574	1838644351479	46.589	5.769	38.077	207.824	3809.967	3364.28	26269.695	5005.473	34512.672	15.519	-1.097	4.512	-5.009	451.467	1120.628	3112.857	27.426	287.23	1980.448	6.558	7.974	49.104	797.862	5501.248	11.907	18.514	3.462	54.113	346.395	859.82	2388.391	11.701	0.818	29.938	24.297	2995.656	844.949	20655.027	6623.064	45665.943
RUS	Russia	1988	3.213	72.403	8.359	418.426	-0.123	-8.164	1.75	175.12	14.219	-1.476	23.25	-35.462	2367.102	1037.582	16211.542	2325.495	15926.573	151.501	769.763	494.153	160.924	134.814	124.108		160.924	1065.5	5.45	69727.589	1.645	91.931	151.489	9359.683	64101.497	5271.859	72.244	1868131716720	46.378	5.527	39.49	210.595	4020.562	3384.3	27535.574	5423.898	37146.556	15.103	-0.987	4.391	-4.456	447.01	1102.115	3061.432	27.756	295.737	2025.412	2.962	8.069	23.632	821.493	5626.148	12.653	8.109	3.678	28.088	374.483	923.297	2564.716	11.648	-0.789	29.191	-23.644	2972.012	849.977	20354.381	6614.9	45303.347
RUS	Russia	1989	-3.806	-88.514	4.408	239.1	-2.91	-192.511	0.372	37.892	14.269	-3.305	22.398	-78.235	2288.867	1045.877	15584.965	2236.98	15231.653	153.602	780.436	501.005	159.726	136.338	125.829		159.726	1076.5	5.433	69581.83	0.395	91.952	36.983	9396.667	63982.131	5314.005	72.497	1881091725604	46.54	1.487	39.929	59.774	4080.336	3411.356	27783.13	5662.999	38559.495	14.838	-0.744	4.342	-3.327	443.684	1087.578	3021.052	27.503	296.064	2015.91	0.111	8.048	0.908	822.402	5599.754	12.665	1.131	3.706	4.235	378.718	928.332	2578.702	11.689	1.866	29.626	55.444	3027.456	856.772	20614.036	6422.388	43730.199
RUS	Russia	1990	-3.527	-78.904	5.879	332.901	-6.58	-422.576	-1.761	-179.943	14.494	-7.368	21.12	-168.654	2120.213	1063.194	14371.264	2158.076	14627.893	156.855	796.964	511.616	166.846	118.325	128.494	0.065	166.911	1082.2	5.471	68047.247	-1.595	92.108	-149.863	9246.803	62676.778	5401.992	73.643	1834865200000	47.276	1.51	41.258	61.614	4141.95	3467.84	28075.033	5995.9	40641.469	15.417	4.457	4.617	19.777	463.46	1130.915	3141.432	26.357	285.236	1933.387	-3.658	7.892	-30.08	792.322	5370.524	10.934	-13.212	3.274	-50.037	328.681	802.032	2227.868	11.873	-1.415	29.73	-42.824	2984.632	870.958	20230.481	5999.812	40667.99	0.441		0.002	0.181
RUS	Russia	1991	-8.039	-173.491	-1.38	-82.765	-10.457	-627.404	-1.372	-137.783	14.486	-8.362	19.623	-177.303	1942.911	1045.544	13128.179	1984.585	13409.756	154.736	780.021	501.311	168.094	119.984	123.973	0.065	168.159	1068.163	5.57	66902.906	-1.577	91.916	-145.858	9100.945	61494.708	5270.566	73.024	1777486523641	46.932	2.598	42.919	107.598	4249.548	3387.338	28714.043	5913.134	39954.802	15.737	0.748	4.716	3.468	466.928	1135.804	3155.014	26.976	288.143	1946.969	1.019	8.084	8.075	800.397	5408.251	11.233	1.402	3.366	4.608	333.289	810.726	2252.017	11.606	-2.552	29.375	-76.153	2908.479	837.683	19652.485	5372.409	36301.142	0.439		0.002
RUS	Russia	1992	-4.108	-81.519	0.156	9.196	-13.667	-734.248	-3.765	-372.808	15.282	-6.032	19.16	-117.205	1825.707	1039.407	12313.52	1903.066	12835.262	154.111	714.351	460.187	172.594	119.626	100.052	0.063	172.657	1008.45	6.128	64265.317	-4.223	91.479	-384.308	8716.637	58789.509	4817.952	70.837	1555013222609	45.633	-3.203	43.17	-136.099	4113.449	3103.742	27743.251	5922.33	39943.261	17.115	2.677	5.031	12.5	479.428	1164.063	3233.512	28.983	292.283	1971.308	1.437	8.521	11.501	811.898	5475.859	11.862	-0.298	3.487	-0.994	332.295	806.82	2241.167	9.921	-4.504	29.149	-131.005	2777.474	674.803	18732.738	4638.16	31282.153	0.425	-3.077	0.002	-0.006
RUS	Russia	1993	-9.813	-186.749	-3.991	-236.341	-11.017	-510.964	-6.798	-647.766	15.513	-9.741	18.556	-177.837	1647.87	1000.121	11106.229	1716.317	11567.535	148.392	660.445	429.168	174.289	119.186	82.886	0.06	174.349	956.587	6.127	59854.058	-7.471	90.819	-651.244	8065.393	54358.683	4451.232	69.042	1449494329787	44.865	-0.291	46.184	-11.961	4101.488	2892.484	27642.999	5685.989	38322.111	18.22	0.982	5.452	4.708	484.136	1174.663	3262.956	30.686	293.535	1978.351	0.428	9.181	3.478	815.376	5495.423	12.46	-0.368	3.728	-1.222	331.072	803.283	2231.344	8.665	-16.614	26.079	-461.446	2316.029	558.628	15609.454	4127.196	27816.247	0.404	-4.762	0.002	-0.008
RUS	Russia	1994	-11.002	-188.835	-1.779	-101.158	-10.51	-433.764	-8.78	-779.723	18.55	-12.54	17.791	-206.645	1441.225	1095.284	9715.078	1527.482	10296.513	162.485	599.497	363.742	175.926	97.82	73.27	0.061	175.987	875.914	6.253	54607.813	-8.988	90.611	-724.923	7340.469	49480.937	4041.117	68.443	1295583353421	41.527	-6.054	47.564	-248.287	3853.201	2451.929	25973.836	5584.831	37646.459	20.085	0.939	6.032	4.547	488.684	1185.889	3294.139	31.26	273.807	1845.689	-6.721	9.389	-54.8	760.576	5126.919	11.168	-17.927	3.354	-59.35	271.722	659.389	1831.638	8.365	-11.658	25.256	-269.992	2046.037	493.904	13792.023	3693.432	24896.839	0.411	1.667	0.002	0.003


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