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	coal_share_elec Coal Share Elec	coal_elec_per_capita Coal Elec Per Capita	coal_production Coal Production	coal_prod_per_capita Coal Prod Per Capita	electricity_demand Electricity Demand	coal_electricity Coal Electricity	fossil_electricity Fossil Electricity	gas_electricity Gas Electricity	hydro_electricity Hydro Electricity	oil_electricity Oil Electricity	renewables_electricity Renewables Electricity	electricity_generation Electricity Generation	fossil_cons_per_capita Fossil Cons Per Capita	fossil_share_elec Fossil Share Elec	gdp Gdp	gas_share_elec Gas Share Elec	gas_elec_per_capita Gas Elec Per Capita	gas_production Gas Production	gas_prod_per_capita Gas Prod Per Capita	hydro_share_elec Hydro Share Elec	hydro_elec_per_capita Hydro Elec 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	net_elec_imports_share_demand Net Elec Imports Share Demand	net_elec_imports Net Elec Imports	oil_share_elec Oil Share Elec	oil_elec_per_capita Oil Elec Per Capita	oil_production Oil Production	oil_prod_per_capita Oil Prod Per Capita
SRB	Serbia	1990							72.569	2971.313			36.95	28.28	31.48	1.32	7.49	1.88	7.49	38.97	3307.53	80.78	75948516338	3.387	138.689			19.22	786.957	19.22	7.49	786.957	-5.467	-2.02	4.824	197.527
SRB	Serbia	1991							66.1	2592.972			35.4	24.9	28.1	1.32	9.57	1.88	9.57	37.67	2926.206	74.595	68665329585	3.504	137.459			25.405	996.576	25.405	9.57	996.576	-6.412	-2.27	4.991	195.775
SRB	Serbia	1992							69.746	2466.719	99.657	10272.688	33.91	23.93	25.14	0.59	9.17	0.62	9.17	34.31	2591.447	73.273	50650013986	1.72	60.818	9.175	945.811	26.727	945.249	26.727	9.17	945.249	-1.18	-0.4	1.807	63.91	14.379	1482.146
SRB	Serbia	1993	-4.528	-4.512	13.713	1.258	-0.273	-0.039	70.861	2167.376	95.145	9713.347	28.96	21.23	21.9	0.37	8.06	0.3	8.06	29.96	2235.777	73.097	36015633659	1.235	37.773	10.434	1065.181	26.903	822.848	26.903	8.06	822.848	-3.453	-1	1.001	30.627	14.339	1463.896
SRB	Serbia	1994	-8.479	-8.067	-18.17	-1.896	10.842	1.555	69.273	2164.956	87.077	8829.916	29.57	21.35	21.9	0.31	8.92	0.24	8.92	30.82	2220.728	71.058	37817210022	1.006	31.435	8.538	865.767	28.942	904.516	28.942	8.92	904.516	-4.227	-1.25	0.779	24.337	15.894	1611.694
SRB	Serbia	1995	-20.603	-17.941	15.108	1.29	-7.845	-1.247	67.371	2193.412	69.137	6994.693	31.78	21.68	22.28	0.35	9.9	0.25	9.9	32.18	2254.115	69.236	40959922067	1.088	35.41	9.828	994.296	30.764	1001.604	30.764	9.9	1001.604	-1.259	-0.4	0.777	25.293	14.647	1481.872
SRB	Serbia	1996	60.103	41.553	-25.949	-2.55	0.274	0.04	61.591	2019.062	110.69	11230.644	34.07	19.9	20.83	0.51	11.48	0.42	11.48	32.31	2113.42	64.469	44013042703	1.578	51.745	7.278	738.385	35.531	1164.765	35.531	11.48	1164.765	5.166	1.76	1.3	42.613	14.687	1490.166
SRB	Serbia	1997	0.951	1.052	2.534	0.184	-8.763	-1.287	66.951	2407.844	111.742	11420.125	36.01	23.56	24.69	0.56	10.5	0.57	10.5	35.19	2523.33	70.162	48378787244	1.591	57.232	7.462	762.615	29.838	1073.105	29.838	10.5	1073.105	2.277	0.82	1.62	58.254	13.4	1369.502
SRB	Serbia	1998	2.6	2.905	36.919	2.755	-9.305	-1.247	68.351	2486.209	114.648	11837.148	35.68	24.08	24.91	0.52	10.32	0.31	10.32	35.23	2571.904	70.707	50685451365	1.476	53.689	10.217	1054.863	29.293	1065.518	29.293	10.32	1065.518	1.261	0.45	0.88	32.007	12.153	1254.799
SRB	Serbia	1999	-25.011	-28.674	-27.919	-2.852			61.499	1978.953	85.973	8973.491	32.7	18.96	19.69	0.36	11.14	0.37	11.14	30.83	2055.147	63.866	42474166038	1.168	37.575	7.364	768.654	36.134	1162.739	36.134	11.14	1162.739	5.719	1.87	1.2	38.619	12.153	1268.499


CREATE TABLE serbia_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" VARCHAR,
  "coal_share_energy" VARCHAR,
  "coal_cons_change_twh" VARCHAR,
  "coal_consumption" VARCHAR,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" VARCHAR,
  "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" VARCHAR,
  "fossil_share_energy" VARCHAR,
  "fossil_cons_change_twh" VARCHAR,
  "fossil_fuel_consumption" VARCHAR,
  "fossil_energy_per_capita" VARCHAR,
  "fossil_cons_per_capita" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "gdp" DOUBLE,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" VARCHAR,
  "gas_share_energy" VARCHAR,
  "gas_cons_change_twh" VARCHAR,
  "gas_consumption" VARCHAR,
  "gas_elec_per_capita" DOUBLE,
  "gas_energy_per_capita" VARCHAR,
  "gas_production" DOUBLE,
  "gas_prod_per_capita" DOUBLE,
  "hydro_share_elec" DOUBLE,
  "hydro_cons_change_pct" VARCHAR,
  "hydro_share_energy" VARCHAR,
  "hydro_cons_change_twh" VARCHAR,
  "hydro_consumption" VARCHAR,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" VARCHAR,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" VARCHAR,
  "low_carbon_share_energy" VARCHAR,
  "low_carbon_cons_change_twh" VARCHAR,
  "low_carbon_consumption" VARCHAR,
  "low_carbon_energy_per_capita" VARCHAR,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" VARCHAR,
  "nuclear_share_energy" VARCHAR,
  "nuclear_cons_change_twh" VARCHAR,
  "nuclear_consumption" VARCHAR,
  "nuclear_elec_per_capita" DOUBLE,
  "nuclear_energy_per_capita" VARCHAR,
  "oil_share_elec" DOUBLE,
  "oil_cons_change_pct" VARCHAR,
  "oil_share_energy" VARCHAR,
  "oil_cons_change_twh" VARCHAR,
  "oil_consumption" VARCHAR,
  "oil_elec_per_capita" DOUBLE,
  "oil_energy_per_capita" VARCHAR,
  "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" VARCHAR,
  "other_renewables_share_energy" VARCHAR,
  "other_renewables_cons_change_twh" VARCHAR
);