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
This dataset contains country-wise energy consumption and energy generation from various sources. It also includes several metrics for easy comparison between countries.
Also, I would thank the owid researcher for providing this dataset.
CREATE TABLE croatia_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" 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 cuba_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" 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 cyprus_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" 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" 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 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
);CREATE TABLE czechoslovakia_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" 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" 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" DOUBLE,
"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" DOUBLE,
"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 democratic_republic_of_congo_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" 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 denmark_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" 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 djibouti_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 dominica_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 dominican_republic_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" 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 eastern_africa_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" DOUBLE,
"coal_share_energy" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_consumption" DOUBLE,
"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" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" VARCHAR,
"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" VARCHAR,
"energy_per_gdp" VARCHAR,
"energy_per_capita" VARCHAR,
"fossil_cons_change_pct" DOUBLE,
"fossil_share_energy" DOUBLE,
"fossil_cons_change_twh" DOUBLE,
"fossil_fuel_consumption" DOUBLE,
"fossil_energy_per_capita" VARCHAR,
"fossil_cons_per_capita" VARCHAR,
"fossil_share_elec" VARCHAR,
"gdp" VARCHAR,
"gas_share_elec" VARCHAR,
"gas_cons_change_pct" DOUBLE,
"gas_share_energy" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" DOUBLE,
"gas_elec_per_capita" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"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" VARCHAR,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" VARCHAR,
"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" VARCHAR,
"net_elec_imports_share_demand" VARCHAR,
"net_elec_imports" VARCHAR,
"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" VARCHAR,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" VARCHAR,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"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" DOUBLE,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE east_germany_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 ecuador_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" VARCHAR,
"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" 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 egypt_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" 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" VARCHAR,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE el_salvador_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" 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 equatorial_guinea_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" 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" 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 eritrea_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" 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" 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 estonia_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" 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" 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 eswatini_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" 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 ethiopia_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
);CREATE TABLE european_union_27_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" 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" VARCHAR,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_production" VARCHAR,
"coal_prod_per_capita" VARCHAR,
"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" 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" VARCHAR,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" DOUBLE,
"gas_share_energy" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" VARCHAR,
"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" VARCHAR,
"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 europe_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" VARCHAR,
"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" VARCHAR,
"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 faeroe_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 falkland_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 fiji_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 finland_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" 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 france_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 french_guiana_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 french_polynesia_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 gabon_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" 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 gambia_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 georgia_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 germany_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 ghana_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" 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 greece_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" 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 greenland_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" 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 grenada_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 guadeloupe_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 guam_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 guatemala_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" 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 guinea_bissau_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 guinea_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 guyana_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 haiti_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" 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 hawaiian_trade_zone_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 honduras_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" 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 hong_kong_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" 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" 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" 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 hungary_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 iceland_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" 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" 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" 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 india_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" 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" 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" VARCHAR,
"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.