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 indonesia_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" VARCHAR,
"nuclear_share_energy" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_production" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"other_renewables_elec_per_capita_exc_biofuel" VARCHAR,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" DOUBLE,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE iran_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 iraq_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" VARCHAR,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE ireland_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" 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 israel_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"gas_prod_change_twh" DOUBLE,
"oil_prod_change_pct" DOUBLE,
"oil_prod_change_twh" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" VARCHAR,
"biofuel_share_energy" VARCHAR,
"biofuel_cons_change_twh" VARCHAR,
"biofuel_consumption" VARCHAR,
"biofuel_cons_per_capita" VARCHAR,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" DOUBLE,
"coal_share_energy" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_consumption" DOUBLE,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" 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 italy_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 jamaica_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 japan_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 jordan_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 kazakhstan_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" 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
);CREATE TABLE kenya_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 kiribati_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 kosovo_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" 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" 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" VARCHAR,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"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" 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" 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" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" DOUBLE,
"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" 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" 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" VARCHAR,
"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" VARCHAR,
"oil_energy_per_capita" VARCHAR,
"oil_production" DOUBLE,
"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 kuwait_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" DOUBLE,
"gas_prod_change_twh" DOUBLE,
"oil_prod_change_pct" DOUBLE,
"oil_prod_change_twh" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" VARCHAR,
"biofuel_share_energy" VARCHAR,
"biofuel_cons_change_twh" VARCHAR,
"biofuel_consumption" VARCHAR,
"biofuel_cons_per_capita" VARCHAR,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" DOUBLE,
"coal_share_energy" DOUBLE,
"coal_cons_change_twh" DOUBLE,
"coal_consumption" DOUBLE,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" DOUBLE,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"other_renewable_electricity" DOUBLE,
"renewables_electricity" DOUBLE,
"solar_electricity" DOUBLE,
"wind_electricity" DOUBLE,
"electricity_generation" DOUBLE,
"greenhouse_gas_emissions" DOUBLE,
"energy_per_gdp" DOUBLE,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" DOUBLE,
"fossil_share_energy" DOUBLE,
"fossil_cons_change_twh" DOUBLE,
"fossil_fuel_consumption" DOUBLE,
"fossil_energy_per_capita" DOUBLE,
"fossil_cons_per_capita" DOUBLE,
"fossil_share_elec" DOUBLE,
"gdp" DOUBLE,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" DOUBLE,
"gas_share_energy" DOUBLE,
"gas_cons_change_twh" DOUBLE,
"gas_consumption" DOUBLE,
"gas_elec_per_capita" DOUBLE,
"gas_energy_per_capita" DOUBLE,
"gas_production" DOUBLE,
"gas_prod_per_capita" DOUBLE,
"hydro_share_elec" DOUBLE,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" DOUBLE,
"hydro_cons_change_twh" DOUBLE,
"hydro_consumption" DOUBLE,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" DOUBLE,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" DOUBLE,
"low_carbon_share_energy" DOUBLE,
"low_carbon_cons_change_twh" DOUBLE,
"low_carbon_consumption" DOUBLE,
"low_carbon_energy_per_capita" DOUBLE,
"net_elec_imports_share_demand" DOUBLE,
"net_elec_imports" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_production" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE kyrgyzstan_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 laos_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 latvia_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 lebanon_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 lesotho_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 liberia_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 libya_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 lithuania_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" 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 luxembourg_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" DOUBLE,
"hydro_share_energy" DOUBLE,
"hydro_cons_change_twh" DOUBLE,
"hydro_consumption" DOUBLE,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" DOUBLE,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" DOUBLE,
"low_carbon_share_energy" DOUBLE,
"low_carbon_cons_change_twh" DOUBLE,
"low_carbon_consumption" DOUBLE,
"low_carbon_energy_per_capita" DOUBLE,
"net_elec_imports_share_demand" DOUBLE,
"net_elec_imports" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" DOUBLE,
"nuclear_cons_change_twh" DOUBLE,
"nuclear_consumption" DOUBLE,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" DOUBLE,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" DOUBLE,
"oil_share_energy" DOUBLE,
"oil_cons_change_twh" DOUBLE,
"oil_consumption" DOUBLE,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" DOUBLE,
"oil_production" VARCHAR,
"oil_prod_per_capita" VARCHAR,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" DOUBLE,
"other_renewables_share_energy" DOUBLE,
"other_renewables_cons_change_twh" DOUBLE
);CREATE TABLE macao_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 madagascar_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 malawi_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 malaysia_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 maldives_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 mali_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 malta_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 martinique_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 mauritania_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 mauritius_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 mexico_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 micronesia_country_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" DOUBLE,
"fossil_cons_change_pct" VARCHAR,
"fossil_share_energy" VARCHAR,
"fossil_cons_change_twh" VARCHAR,
"fossil_fuel_consumption" VARCHAR,
"fossil_energy_per_capita" VARCHAR,
"fossil_cons_per_capita" VARCHAR,
"fossil_share_elec" VARCHAR,
"gdp" VARCHAR,
"gas_share_elec" VARCHAR,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"hydro_share_elec" VARCHAR,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" VARCHAR,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" VARCHAR,
"low_carbon_electricity" VARCHAR,
"low_carbon_elec_per_capita" VARCHAR,
"low_carbon_cons_change_pct" VARCHAR,
"low_carbon_share_energy" VARCHAR,
"low_carbon_cons_change_twh" VARCHAR,
"low_carbon_consumption" VARCHAR,
"low_carbon_energy_per_capita" VARCHAR,
"net_elec_imports_share_demand" VARCHAR,
"net_elec_imports" VARCHAR,
"nuclear_share_elec" VARCHAR,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" VARCHAR,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" VARCHAR,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" VARCHAR,
"oil_energy_per_capita" VARCHAR,
"oil_production" VARCHAR,
"oil_prod_per_capita" VARCHAR,
"other_renewables_elec_per_capita_exc_biofuel" VARCHAR,
"other_renewables_elec_per_capita" VARCHAR,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);CREATE TABLE middle_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 middle_east_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" VARCHAR,
"biofuel_cons_change_pct" DOUBLE,
"biofuel_share_energy" DOUBLE,
"biofuel_cons_change_twh" DOUBLE,
"biofuel_consumption" DOUBLE,
"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" VARCHAR,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"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" DOUBLE,
"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" 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" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" DOUBLE,
"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" DOUBLE,
"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" DOUBLE,
"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" DOUBLE,
"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 moldova_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 mongolia_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" 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 montenegro_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" DOUBLE,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" VARCHAR,
"gas_prod_change_twh" DOUBLE,
"oil_prod_change_pct" VARCHAR,
"oil_prod_change_twh" DOUBLE,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" VARCHAR,
"biofuel_share_energy" VARCHAR,
"biofuel_cons_change_twh" VARCHAR,
"biofuel_consumption" VARCHAR,
"biofuel_cons_per_capita" VARCHAR,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" VARCHAR,
"coal_share_energy" VARCHAR,
"coal_cons_change_twh" VARCHAR,
"coal_consumption" VARCHAR,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"other_renewable_electricity" DOUBLE,
"renewables_electricity" DOUBLE,
"solar_electricity" DOUBLE,
"wind_electricity" DOUBLE,
"electricity_generation" DOUBLE,
"greenhouse_gas_emissions" DOUBLE,
"energy_per_gdp" DOUBLE,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" VARCHAR,
"fossil_share_energy" VARCHAR,
"fossil_cons_change_twh" VARCHAR,
"fossil_fuel_consumption" VARCHAR,
"fossil_energy_per_capita" VARCHAR,
"fossil_cons_per_capita" DOUBLE,
"fossil_share_elec" DOUBLE,
"gdp" DOUBLE,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" DOUBLE,
"gas_energy_per_capita" VARCHAR,
"gas_production" DOUBLE,
"gas_prod_per_capita" DOUBLE,
"hydro_share_elec" DOUBLE,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" VARCHAR,
"low_carbon_share_energy" VARCHAR,
"low_carbon_cons_change_twh" VARCHAR,
"low_carbon_consumption" VARCHAR,
"low_carbon_energy_per_capita" VARCHAR,
"net_elec_imports_share_demand" DOUBLE,
"net_elec_imports" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" VARCHAR,
"oil_production" DOUBLE,
"oil_prod_per_capita" DOUBLE,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);CREATE TABLE montserrat_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 morocco_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 mozambique_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" 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 myanmar_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 namibia_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 nauru_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 nepal_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 netherlands_antilles_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" VARCHAR,
"gas_prod_change_twh" VARCHAR,
"oil_prod_change_pct" VARCHAR,
"oil_prod_change_twh" VARCHAR,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" VARCHAR,
"biofuel_elec_per_capita" VARCHAR,
"biofuel_cons_change_pct" VARCHAR,
"biofuel_share_energy" VARCHAR,
"biofuel_cons_change_twh" VARCHAR,
"biofuel_consumption" VARCHAR,
"biofuel_cons_per_capita" VARCHAR,
"carbon_intensity_elec" VARCHAR,
"coal_share_elec" VARCHAR,
"coal_cons_change_pct" VARCHAR,
"coal_share_energy" VARCHAR,
"coal_cons_change_twh" VARCHAR,
"coal_consumption" VARCHAR,
"coal_elec_per_capita" VARCHAR,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" VARCHAR,
"biofuel_electricity" VARCHAR,
"coal_electricity" VARCHAR,
"fossil_electricity" VARCHAR,
"gas_electricity" VARCHAR,
"hydro_electricity" VARCHAR,
"nuclear_electricity" VARCHAR,
"oil_electricity" VARCHAR,
"other_renewable_exc_biofuel_electricity" VARCHAR,
"other_renewable_electricity" VARCHAR,
"renewables_electricity" VARCHAR,
"solar_electricity" VARCHAR,
"wind_electricity" VARCHAR,
"electricity_generation" VARCHAR,
"greenhouse_gas_emissions" VARCHAR,
"energy_per_gdp" VARCHAR,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" VARCHAR,
"fossil_share_energy" VARCHAR,
"fossil_cons_change_twh" VARCHAR,
"fossil_fuel_consumption" VARCHAR,
"fossil_energy_per_capita" VARCHAR,
"fossil_cons_per_capita" VARCHAR,
"fossil_share_elec" VARCHAR,
"gdp" VARCHAR,
"gas_share_elec" VARCHAR,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" VARCHAR,
"gas_energy_per_capita" VARCHAR,
"gas_production" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"hydro_share_elec" VARCHAR,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" VARCHAR,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" VARCHAR,
"low_carbon_electricity" VARCHAR,
"low_carbon_elec_per_capita" VARCHAR,
"low_carbon_cons_change_pct" VARCHAR,
"low_carbon_share_energy" VARCHAR,
"low_carbon_cons_change_twh" VARCHAR,
"low_carbon_consumption" VARCHAR,
"low_carbon_energy_per_capita" VARCHAR,
"net_elec_imports_share_demand" VARCHAR,
"net_elec_imports" VARCHAR,
"nuclear_share_elec" VARCHAR,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" VARCHAR,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" VARCHAR,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" VARCHAR,
"oil_energy_per_capita" VARCHAR,
"oil_production" VARCHAR,
"oil_prod_per_capita" VARCHAR,
"other_renewables_elec_per_capita_exc_biofuel" VARCHAR,
"other_renewables_elec_per_capita" VARCHAR,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);CREATE TABLE netherlands_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 new_caledonia_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
);Anyone who has the link will be able to view this.