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	energy_cons_change_pct Energy Cons Change Pct	energy_cons_change_twh Energy Cons Change Twh	carbon_intensity_elec Carbon Intensity Elec	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	hydro_electricity Hydro Electricity	renewables_electricity Renewables Electricity	electricity_generation Electricity Generation	greenhouse_gas_emissions Greenhouse Gas Emissions	energy_per_gdp Energy Per Gdp	energy_per_capita Energy Per Capita	fossil_cons_per_capita Fossil Cons Per Capita	fossil_share_elec Fossil Share Elec	gdp Gdp	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
MNE	Montenegro	2005					299.652	34.843	1622.355			4.66	1	1	1.87	1.87	2.87	0.86			1622.355	34.843	5587145705	65.157	3033.803	65.157	1.87	3033.803	38.412	1.79
MNE	Montenegro	2006					345.763	40.678	1942.178	4.075	6595.959	4.82	1.2	1.2	1.75	1.75	2.95	1.02	2.4	24847.49	1942.178	40.678	6395709425	59.322	2832.343	59.322	1.75	2832.343	38.797	1.87
MNE	Montenegro	2007	-20.437	-0.833	-10.056	-1.544	345.794	40.187	1388.095	3.243	5233.651	4.73	0.86	0.86	1.28	1.28	2.14	0.74	1.85	22287.923	1388.095	40.187	7462959805	59.813	2066.002	59.813	1.28	2066.002	54.757	2.59
MNE	Montenegro	2008	44.638	1.447	13.01	1.797	388.693	45.583	2076.252	4.69	7548.451	4.61	1.29	1.29	1.54	1.54	2.83	1.1	1.854	25116.34	2076.252	45.583	8414771324	54.417	2478.626	54.417	1.54	2478.626	38.612	1.78
MNE	Montenegro	2009	-45	-2.11	-13.745	-2.145	224.638	25	1107.663	2.579	4140.845	3.81	0.69	0.69	2.07	2.07	2.76	0.62	1.608	21607.767	1107.663	25	8371377798	75	3322.99	75	2.07	3322.99	27.559	1.05
MNE	Montenegro	2010	102.508	2.644	24.858	3.346	276.119	31.592	2034.347	5.224	8367.454	4.02	1.27	1.27	2.75	2.75	4.02	1.11	1.86	26920.755	2034.347	31.592	9033098103	68.408	4405.082	68.408	2.75	4405.082
MNE	Montenegro	2011	1.806	0.094	-17.514	-2.943	460.377	54.717	2318.994	5.318	8505.055	4.21	1.45	1.45	1.2	1.2	2.65	1.22	1.414	22170.623	2318.994	54.717	9801452451	45.283	1919.168	45.283	1.2	1919.168	37.055	1.56
MNE	Montenegro	2012	-9.478	-0.504	-2.86	-0.396	407.018	48.07	2188.74	4.814	7690.832	4.06	1.37	1.37	1.48	1.48	2.85	1.16	1.404	21513.935	2188.74	48.07	9593080259	51.93	2364.478	51.93	1.48	2364.478	29.803	1.21
MNE	Montenegro	2013	-5.263	-0.253	7.692	1.036	314.721	36.548	2299.063	4.561	7281.271	3.6	1.44	1.44	2.5	2.5	3.94	1.24	1.452	23153.6	2299.063	36.548	9985414528	63.452	3991.43	63.452	2.5	3991.43	-9.444	-0.34
MNE	Montenegro	2014	-2.187	-0.1	-10.68	-1.549	378.549	44.795	2266.018	4.461	7118.546	3.43	1.42	1.42	1.75	1.75	3.17	1.2	1.269	20670.57	2266.018	44.795	10205667552	55.205	2792.627	55.205	1.75	2792.627	7.58	0.26


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