Energy Dataset Country-Wise (1900-2021)

CREATE TABLE fiji_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" VARCHAR,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "carbon_intensity_elec" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_cons_change_pct" VARCHAR,
  "coal_share_energy" VARCHAR,
  "coal_cons_change_twh" VARCHAR,
  "coal_consumption" VARCHAR,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" VARCHAR,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "electricity_demand" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "coal_electricity" DOUBLE,
  "fossil_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "energy_per_gdp" VARCHAR,
  "energy_per_capita" DOUBLE,
  "fossil_cons_change_pct" VARCHAR,
  "fossil_share_energy" VARCHAR,
  "fossil_cons_change_twh" VARCHAR,
  "fossil_fuel_consumption" VARCHAR,
  "fossil_energy_per_capita" VARCHAR,
  "fossil_cons_per_capita" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "gdp" VARCHAR,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" VARCHAR,
  "gas_share_energy" VARCHAR,
  "gas_cons_change_twh" VARCHAR,
  "gas_consumption" VARCHAR,
  "gas_elec_per_capita" DOUBLE,
  "gas_energy_per_capita" VARCHAR,
  "gas_production" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "hydro_share_elec" DOUBLE,
  "hydro_cons_change_pct" VARCHAR,
  "hydro_share_energy" VARCHAR,
  "hydro_cons_change_twh" VARCHAR,
  "hydro_consumption" VARCHAR,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" VARCHAR,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" VARCHAR,
  "low_carbon_share_energy" VARCHAR,
  "low_carbon_cons_change_twh" VARCHAR,
  "low_carbon_consumption" VARCHAR,
  "low_carbon_energy_per_capita" VARCHAR,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" VARCHAR,
  "nuclear_share_energy" VARCHAR,
  "nuclear_cons_change_twh" VARCHAR,
  "nuclear_consumption" VARCHAR,
  "nuclear_elec_per_capita" DOUBLE,
  "nuclear_energy_per_capita" VARCHAR,
  "oil_share_elec" DOUBLE,
  "oil_cons_change_pct" VARCHAR,
  "oil_share_energy" VARCHAR,
  "oil_cons_change_twh" VARCHAR,
  "oil_consumption" VARCHAR,
  "oil_elec_per_capita" DOUBLE,
  "oil_energy_per_capita" VARCHAR,
  "oil_production" VARCHAR,
  "oil_prod_per_capita" VARCHAR,
  "other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
  "other_renewables_elec_per_capita" DOUBLE,
  "other_renewables_cons_change_pct" VARCHAR,
  "other_renewables_share_energy" VARCHAR,
  "other_renewables_cons_change_twh" VARCHAR
);