Energy Dataset Country-Wise (1900-2021)

iso_code Iso Code	country Country	year Year	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	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	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_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
CZE	Czechia	1965				87.716		410.841	41874.02	2.232	2.232		47738.284		98.676		462.179	47106.459			0.916		4.29	437.299		1.324		6.199	227.47	631.863	2.232	227.47		1.324		6.199	631.863		10.045		47.047	4795.141
CZE	Czechia	1966	0.754	3.529	-0.294	86.803	-1.21	409.632	41709.557	2.104	2.104		48050.554	0.841	98.762	3.885	466.064	47455.602		4.656	0.952	0.2	4.49	457.206	-5.743	1.238	-0.356	5.843	214.196	594.99	2.104	214.196	-5.743	1.238	-0.356	5.843	594.99	10.405	11.007	4.895	51.942	5288.839
CZE	Czechia	1967	-1.548	-7.307	-3.293	85.265	-13.491	396.141	40352.138	1.896	1.896		47325.577	-1.444	98.866	-6.73	459.334	46789.158		20.121	1.161	0.904	5.394	549.424	-9.874	1.134	-0.577	5.266	193.124	536.457	1.896	193.124	-9.874	1.134	-0.577	5.266	536.457	11.276	12.441	5.857	57.799	5887.596
CZE	Czechia	1968	4.311	20.029	3.514	84.614	13.921	410.062	41809.225	1.467	1.467		49411.914	4.62	99.159	21.22	480.554	48996.406		23.314	1.372	1.258	6.651	678.15	-22.611	0.841	-1.191	4.076	149.597	415.548	1.467	149.597	-22.611	0.841	-1.191	4.076	415.548	10.452	13.173	6.041	63.84	6509.031
CZE	Czechia	1969	4.269	20.689	3.937	84.344	16.142	426.205	43466.705	1.198	1.198		51535.123	4.461	99.342	21.438	501.992	51195.876		9.664	1.443	0.643	7.294	743.882	-18.373	0.658	-0.749	3.327	122.144	339.288	1.198	122.144	-18.373	0.658	-0.749	3.327	339.288	7.288	13.554	4.653	68.493	6985.288
CZE	Czechia	1970	4.205	21.247	1.236	81.941	5.268	431.473	43948.664	1.71	1.71	6.145	53634.434	3.949	99.098	19.823	521.815	53150.567	85688637048	9.851	1.522	0.719	8.012	816.131	42.804	0.902	1.424	4.751	174.207	483.909	1.71	174.207	42.804	0.902	1.424	4.751	483.909	20.2	15.635	13.836	82.329	8385.772
CZE	Czechia	1971	5.112	26.92	4.186	81.219	18.061	449.534	45650.953	1.208	1.208	6.139	56207.228	5.426	99.394	28.315	550.13	55866.51	90161721573	24.243	1.799	1.943	9.955	1010.947	-29.369	0.606	-1.395	3.356	122.674	340.762	1.208	122.674	-29.369	0.606	-1.395	3.356	340.762	10.095	16.376	8.311	90.64	9204.611
CZE	Czechia	1972	0.566	3.134	-1.426	79.61	-6.408	443.126	44800.53	1.264	1.264	5.863	56274.71	0.541	99.369	2.979	553.108	55919.778	94933132908	8.594	1.942	0.856	10.81	1092.953	4.636	0.631	0.156	3.511	127.792	354.977	1.264	127.792	4.636	0.631	0.156	3.511	354.977	9.412	17.817	8.531	99.171	10026.294
CZE	Czechia	1973	0.602	3.352	-2.149	77.433	-9.525	433.601	43594.743	1.081	1.081	5.635	56300.032	0.698	99.464	3.86	556.969	55998.175	99378514080	9.824	2.12	1.062	11.872	1193.674	-14.478	0.536	-0.508	3.003	108.685	301.903	1.081	108.685	-14.478	0.536	-0.508	3.003	301.903	12.426	19.911	12.323	111.494	11209.758
CZE	Czechia	1974	1.049	5.875	-0.37	76.345	-1.605	431.996	43168.265	1.819	1.819	5.431	56543.413	0.687	99.107	3.825	560.793	56038.547	104186941880	21.923	2.558	2.603	14.475	1446.474	68.27	0.893	2.05	5.053	181.768	504.911	1.819	181.768	68.27	0.893	2.05	5.053	504.911	2.535	20.204	2.827	114.321	11423.809


CREATE TABLE czechia_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" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "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" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "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" VARCHAR,
  "oil_prod_per_capita" VARCHAR,
  "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
);