Energy Dataset Country-Wise (1900-2021)
Complete Energy dataset including several metrics for country wise comparison.
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021
Complete Energy dataset including several metrics for country wise comparison.
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021
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
);
CREATE TABLE rwanda_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saint_helena_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"coal_share_energy" VARCHAR,
"coal_cons_change_twh" VARCHAR,
"coal_consumption" VARCHAR,
"coal_elec_per_capita" VARCHAR,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" VARCHAR,
"biofuel_electricity" VARCHAR,
"coal_electricity" VARCHAR,
"fossil_electricity" VARCHAR,
"gas_electricity" VARCHAR,
"hydro_electricity" VARCHAR,
"nuclear_electricity" VARCHAR,
"oil_electricity" VARCHAR,
"other_renewable_exc_biofuel_electricity" VARCHAR,
"other_renewable_electricity" VARCHAR,
"renewables_electricity" VARCHAR,
"solar_electricity" VARCHAR,
"wind_electricity" VARCHAR,
"electricity_generation" VARCHAR,
"greenhouse_gas_emissions" VARCHAR,
"energy_per_gdp" VARCHAR,
"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" VARCHAR,
"fossil_share_elec" VARCHAR,
"gdp" VARCHAR,
"gas_share_elec" VARCHAR,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"hydro_share_elec" VARCHAR,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" VARCHAR,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" VARCHAR,
"low_carbon_electricity" VARCHAR,
"low_carbon_elec_per_capita" VARCHAR,
"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" VARCHAR,
"net_elec_imports" VARCHAR,
"nuclear_share_elec" VARCHAR,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" VARCHAR,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" VARCHAR,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" VARCHAR,
"oil_energy_per_capita" VARCHAR,
"oil_production" VARCHAR,
"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" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saint_kitts_and_nevis_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saint_lucia_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saint_pierre_and_miquelon_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saint_vincent_and_the_grenadines_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE samoa_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE sao_tome_and_principe_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE saudi_arabia_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);
CREATE TABLE senegal_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"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
);
CREATE TABLE serbia_and_montenegro_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" VARCHAR,
"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" 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" VARCHAR,
"coal_share_energy" VARCHAR,
"coal_cons_change_twh" VARCHAR,
"coal_consumption" VARCHAR,
"coal_elec_per_capita" VARCHAR,
"coal_cons_per_capita" VARCHAR,
"coal_production" VARCHAR,
"coal_prod_per_capita" VARCHAR,
"electricity_demand" VARCHAR,
"biofuel_electricity" VARCHAR,
"coal_electricity" VARCHAR,
"fossil_electricity" VARCHAR,
"gas_electricity" VARCHAR,
"hydro_electricity" VARCHAR,
"nuclear_electricity" VARCHAR,
"oil_electricity" VARCHAR,
"other_renewable_exc_biofuel_electricity" VARCHAR,
"other_renewable_electricity" VARCHAR,
"renewables_electricity" VARCHAR,
"solar_electricity" VARCHAR,
"wind_electricity" VARCHAR,
"electricity_generation" VARCHAR,
"greenhouse_gas_emissions" VARCHAR,
"energy_per_gdp" VARCHAR,
"energy_per_capita" VARCHAR,
"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" VARCHAR,
"fossil_share_elec" VARCHAR,
"gdp" VARCHAR,
"gas_share_elec" VARCHAR,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"hydro_share_elec" VARCHAR,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" VARCHAR,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" VARCHAR,
"low_carbon_electricity" VARCHAR,
"low_carbon_elec_per_capita" VARCHAR,
"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" VARCHAR,
"net_elec_imports" VARCHAR,
"nuclear_share_elec" VARCHAR,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" VARCHAR,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" VARCHAR,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" VARCHAR,
"oil_energy_per_capita" VARCHAR,
"oil_production" VARCHAR,
"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" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
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
);
CREATE TABLE seychelles_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE sierra_leone_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE singapore_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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
);
CREATE TABLE slovakia_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
);
CREATE TABLE slovenia_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
);
CREATE TABLE solomon_islands_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE somalia_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" 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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
CREATE TABLE south_africa_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
);
CREATE TABLE south_korea_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" DOUBLE,
"biofuel_share_energy" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_consumption" DOUBLE,
"biofuel_cons_per_capita" DOUBLE,
"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
);
CREATE TABLE south_sudan_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" VARCHAR,
"gas_prod_change_twh" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"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
);
CREATE TABLE spain_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" DOUBLE,
"biofuel_share_energy" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_consumption" DOUBLE,
"biofuel_cons_per_capita" DOUBLE,
"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
);
CREATE TABLE sri_lanka_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"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" VARCHAR,
"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" VARCHAR,
"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
);
Anyone who has the link will be able to view this.