Name: Energy Dataset Country-Wise (1900-2021)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Energy Dataset Country-Wise (1900-2021)

This dataset contains country-wise energy consumption and energy generation from various sources. It also includes several metrics for easy comparison between countries.

Information about the columns is as follows:

iso_code : ISO 3166-1 alpha-3 three-letter country codes
country Geographic location
coal_prod_change_pct Annual percentage change in coal production
coal_prod_change_twh Annual change in coal production, measured in terawatt-hours
gas_prod_change_pct Annual percentage change in gas production
gas_prod_change_twh Annual change in gas production, measured in terawatt-hours
oil_prod_change_pct Annual percentage change in oil production
oil_prod_change_twh Annual change in oil production, measured in terawatt-hours
**energy_cons_change_pct **Annual percentage change in primary energy consumption
energy_cons_change_twh Annual change in primary energy consumption, measured in terawatt-hours
biofuel_share_elec Share of electricity generation that comes from biofuels
biofuel_cons_change_pct Annual percentage change in biofuel consumption
biofuel_share_energy Share of primary energy consumption that comes from biofuels
biofuel_cons_change_twh Annual change in biofuel consumption, measured in terawatt-hours
biofuel_consumption Primary energy consumption from biofuels, measured in terawatt-hours
biofuel_elec_per_capita Per capita electricity generation from biofuels, measured in kilowatt-hours
biofuel_cons_per_capita Per capita primary energy consumption from biofuels, measured in kilowatt-hours
carbon_intensity_elec Carbon intensity of electricity production, measured in grams of carbon dioxide emitted per kilowatt-hour
coal_share_elec Share of electricity generation that comes from coal
coal_cons_change_pct Annual percentage change in coal consumption
coal_share_energy Share of primary energy consumption that comes from coal
coal_cons_change_twh Annual change in coal consumption, measured in terawatt-hours
coal_consumption Primary energy consumption from coal, measured in terawatt-hours
coal_elec_per_capita Per capita electricity generation from coal, measured in kilowatt-hours
coal_cons_per_capita Per capita primary energy consumption from coal, measured in kilowatt-hours
coal_production Coal production, measured in terawatt-hours
coal_prod_per_capita Per capita coal production, measured in kilowatt-hours
electricity_demand Electricity demand, measured in terawatt-hour
electricity_generation Electricity generation, measured in terawatt-hours
greenhouse_gas_emissions Greenhouse-gas emissions produced in the generation of electricity, measured in million tonnes of CO2 equivalent
biofuel_electricity Electricity generation from biofuels, measured in terawatt-hours
coal_electricity Electricity generation from coal, measured in terawatt-hours
fossil_electricity Electricity generation from fossil fuels, measured in terawatt-hours. This is the sum of electricity generation from coal, oil and gas.
gas_electricity Electricity generation from gas, measured in terawatt-hours
hydro_electricity Electricity generation from hydropower, measured in terawatt-hours
nuclear_electricity Electricity generation from nuclear power, measured in terawatt-hours
oil_electricity Electricity generation from oil, measured in terawatt-hours
other_renewable_electricity Electricity generation from other renewable sources including biofuels, measured in terawatt-hours
other_renewable_exc_biofuel_electricity Electricity generation from other renewable sources excluding biofuels, measured in terawatt-hours
renewables_electricity Electricity generation from renewables, measured in terawatt-hours
solar_electricity Electricity generation from solar, measured in terawatt-hours
wind_electricity Electricity generation from wind, measured in terawatt-hours
energy_per_gdp Energy consumption per unit of GDP. This is measured in kilowatt-hours per 2011 international-$.
energy_per_capita Primary energy consumption per capita, measured in kilowatt-hours
fossil_cons_change_pct Annual percentage change in fossil fuel consumption
fossil_share_energy Share of primary energy consumption that comes from fossil fuels
fossil_cons_change_twh Annual change in fossil fuel consumption, measured in terawatt-hours

Also, I would thank the owid researcher for providing this dataset.

Tables

New Zealand Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.new_zealand_energy_data

136.95 kB
121 rows
128 columns

CREATE TABLE new_zealand_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "carbon_intensity_elec" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_cons_change_pct" DOUBLE,
  "coal_share_energy" DOUBLE,
  "coal_cons_change_twh" DOUBLE,
  "coal_consumption" DOUBLE,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" DOUBLE,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "electricity_demand" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "coal_electricity" DOUBLE,
  "fossil_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "energy_per_gdp" DOUBLE,
  "energy_per_capita" DOUBLE,
  "fossil_cons_change_pct" DOUBLE,
  "fossil_share_energy" DOUBLE,
  "fossil_cons_change_twh" DOUBLE,
  "fossil_fuel_consumption" DOUBLE,
  "fossil_energy_per_capita" DOUBLE,
  "fossil_cons_per_capita" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "gdp" DOUBLE,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" DOUBLE,
  "gas_energy_per_capita" DOUBLE,
  "gas_production" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "hydro_share_elec" DOUBLE,
  "hydro_cons_change_pct" DOUBLE,
  "hydro_share_energy" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" DOUBLE,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" DOUBLE,
  "low_carbon_share_energy" DOUBLE,
  "low_carbon_cons_change_twh" DOUBLE,
  "low_carbon_consumption" DOUBLE,
  "low_carbon_energy_per_capita" DOUBLE,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" 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
);

Nicaragua Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.nicaragua_energy_data

98.9 kB
41 rows
128 columns

CREATE TABLE nicaragua_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
);

Niger Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.niger_energy_data

99.43 kB
121 rows
128 columns

CREATE TABLE niger_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
);

Nigeria Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.nigeria_energy_data

108.25 kB
121 rows
128 columns

CREATE TABLE nigeria_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
);

Niue Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.niue_energy_data

84.82 kB
40 rows
128 columns

CREATE TABLE niue_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
);

Non Oecd Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.non_oecd_energy_data

125.79 kB
56 rows
128 columns

CREATE TABLE non_oecd_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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "biofuel_electricity" VARCHAR,
  "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" 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" DOUBLE,
  "gdp" VARCHAR,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" 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
);

Northern Mariana Islands Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.northern_mariana_islands_energy_data

84.1 kB
40 rows
128 columns

CREATE TABLE northern_mariana_islands_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" VARCHAR,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" VARCHAR,
  "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
);

North Korea Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.north_korea_energy_data

101.77 kB
121 rows
128 columns

CREATE TABLE north_korea_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" 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
);

North Macedonia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.north_macedonia_energy_data

116.64 kB
32 rows
128 columns

CREATE TABLE north_macedonia_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "carbon_intensity_elec" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_cons_change_pct" DOUBLE,
  "coal_share_energy" DOUBLE,
  "coal_cons_change_twh" DOUBLE,
  "coal_consumption" DOUBLE,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" DOUBLE,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "electricity_demand" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "coal_electricity" DOUBLE,
  "fossil_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "energy_per_gdp" DOUBLE,
  "energy_per_capita" DOUBLE,
  "fossil_cons_change_pct" DOUBLE,
  "fossil_share_energy" DOUBLE,
  "fossil_cons_change_twh" DOUBLE,
  "fossil_fuel_consumption" DOUBLE,
  "fossil_energy_per_capita" DOUBLE,
  "fossil_cons_per_capita" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "gdp" DOUBLE,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" DOUBLE,
  "gas_energy_per_capita" DOUBLE,
  "gas_production" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "hydro_share_elec" DOUBLE,
  "hydro_cons_change_pct" DOUBLE,
  "hydro_share_energy" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" DOUBLE,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" DOUBLE,
  "low_carbon_share_energy" DOUBLE,
  "low_carbon_cons_change_twh" DOUBLE,
  "low_carbon_consumption" DOUBLE,
  "low_carbon_energy_per_capita" DOUBLE,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" 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
);

Norway Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.norway_energy_data

139.85 kB
122 rows
128 columns

CREATE TABLE norway_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
);

Oecd Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.oecd_energy_data

135.72 kB
122 rows
128 columns

CREATE TABLE oecd_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" 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" DOUBLE,
  "gdp" VARCHAR,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" 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
);

Oman Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.oman_energy_data

116.5 kB
121 rows
128 columns

CREATE TABLE oman_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
);

Pakistan Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.pakistan_energy_data

140.36 kB
122 rows
128 columns

CREATE TABLE pakistan_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
);

Palestine Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.palestine_energy_data

93.7 kB
24 rows
128 columns

CREATE TABLE palestine_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
);

Panama Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.panama_energy_data

98.52 kB
41 rows
128 columns

CREATE TABLE panama_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
);

Papua New Guinea Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.papua_new_guinea_energy_data

95.97 kB
41 rows
128 columns

CREATE TABLE papua_new_guinea_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" VARCHAR,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "carbon_intensity_elec" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_cons_change_pct" VARCHAR,
  "coal_share_energy" VARCHAR,
  "coal_cons_change_twh" VARCHAR,
  "coal_consumption" VARCHAR,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" VARCHAR,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "electricity_demand" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "coal_electricity" DOUBLE,
  "fossil_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "energy_per_gdp" 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
);

Paraguay Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.paraguay_energy_data

95.92 kB
41 rows
128 columns

CREATE TABLE paraguay_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
);

Peru Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.peru_energy_data

141.75 kB
122 rows
128 columns

CREATE TABLE peru_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
);

Philippines Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.philippines_energy_data

134.1 kB
122 rows
128 columns

CREATE TABLE philippines_energy_data (
  "iso_code" VARCHAR,
  "country" VARCHAR,
  "year" BIGINT,
  "coal_prod_change_pct" DOUBLE,
  "coal_prod_change_twh" DOUBLE,
  "gas_prod_change_pct" VARCHAR,
  "gas_prod_change_twh" VARCHAR,
  "oil_prod_change_pct" VARCHAR,
  "oil_prod_change_twh" VARCHAR,
  "energy_cons_change_pct" DOUBLE,
  "energy_cons_change_twh" DOUBLE,
  "biofuel_share_elec" DOUBLE,
  "biofuel_elec_per_capita" DOUBLE,
  "biofuel_cons_change_pct" VARCHAR,
  "biofuel_share_energy" VARCHAR,
  "biofuel_cons_change_twh" VARCHAR,
  "biofuel_consumption" VARCHAR,
  "biofuel_cons_per_capita" VARCHAR,
  "carbon_intensity_elec" DOUBLE,
  "coal_share_elec" DOUBLE,
  "coal_cons_change_pct" DOUBLE,
  "coal_share_energy" DOUBLE,
  "coal_cons_change_twh" DOUBLE,
  "coal_consumption" DOUBLE,
  "coal_elec_per_capita" DOUBLE,
  "coal_cons_per_capita" DOUBLE,
  "coal_production" DOUBLE,
  "coal_prod_per_capita" DOUBLE,
  "electricity_demand" DOUBLE,
  "biofuel_electricity" DOUBLE,
  "coal_electricity" DOUBLE,
  "fossil_electricity" DOUBLE,
  "gas_electricity" DOUBLE,
  "hydro_electricity" DOUBLE,
  "nuclear_electricity" DOUBLE,
  "oil_electricity" DOUBLE,
  "other_renewable_exc_biofuel_electricity" DOUBLE,
  "other_renewable_electricity" DOUBLE,
  "renewables_electricity" DOUBLE,
  "solar_electricity" DOUBLE,
  "wind_electricity" DOUBLE,
  "electricity_generation" DOUBLE,
  "greenhouse_gas_emissions" DOUBLE,
  "energy_per_gdp" DOUBLE,
  "energy_per_capita" DOUBLE,
  "fossil_cons_change_pct" DOUBLE,
  "fossil_share_energy" DOUBLE,
  "fossil_cons_change_twh" DOUBLE,
  "fossil_fuel_consumption" DOUBLE,
  "fossil_energy_per_capita" DOUBLE,
  "fossil_cons_per_capita" DOUBLE,
  "fossil_share_elec" DOUBLE,
  "gdp" DOUBLE,
  "gas_share_elec" DOUBLE,
  "gas_cons_change_pct" DOUBLE,
  "gas_share_energy" DOUBLE,
  "gas_cons_change_twh" DOUBLE,
  "gas_consumption" DOUBLE,
  "gas_elec_per_capita" DOUBLE,
  "gas_energy_per_capita" DOUBLE,
  "gas_production" VARCHAR,
  "gas_prod_per_capita" VARCHAR,
  "hydro_share_elec" DOUBLE,
  "hydro_cons_change_pct" DOUBLE,
  "hydro_share_energy" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" DOUBLE,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" DOUBLE,
  "low_carbon_share_energy" DOUBLE,
  "low_carbon_cons_change_twh" DOUBLE,
  "low_carbon_consumption" DOUBLE,
  "low_carbon_energy_per_capita" DOUBLE,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" 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
);

Poland Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.poland_energy_data

147.45 kB
122 rows
128 columns

CREATE TABLE poland_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" 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
);

Portugal Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.portugal_energy_data

139.57 kB
122 rows
128 columns

CREATE TABLE portugal_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" 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" 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
);

Puerto Rico Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.puerto_rico_energy_data

96.61 kB
41 rows
128 columns

CREATE TABLE puerto_rico_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
);

Qatar Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.qatar_energy_data

118.76 kB
121 rows
128 columns

CREATE TABLE qatar_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" VARCHAR,
  "hydro_share_energy" DOUBLE,
  "hydro_cons_change_twh" DOUBLE,
  "hydro_consumption" DOUBLE,
  "hydro_elec_per_capita" DOUBLE,
  "hydro_energy_per_capita" DOUBLE,
  "low_carbon_share_elec" DOUBLE,
  "low_carbon_electricity" DOUBLE,
  "low_carbon_elec_per_capita" DOUBLE,
  "low_carbon_cons_change_pct" DOUBLE,
  "low_carbon_share_energy" DOUBLE,
  "low_carbon_cons_change_twh" DOUBLE,
  "low_carbon_consumption" DOUBLE,
  "low_carbon_energy_per_capita" DOUBLE,
  "net_elec_imports_share_demand" DOUBLE,
  "net_elec_imports" DOUBLE,
  "nuclear_share_elec" DOUBLE,
  "nuclear_cons_change_pct" VARCHAR,
  "nuclear_share_energy" DOUBLE,
  "nuclear_cons_change_twh" DOUBLE,
  "nuclear_consumption" DOUBLE,
  "nuclear_elec_per_capita" DOUBLE,
  "nuclear_energy_per_capita" DOUBLE,
  "oil_share_elec" DOUBLE,
  "oil_cons_change_pct" DOUBLE,
  "oil_share_energy" DOUBLE,
  "oil_cons_change_twh" DOUBLE,
  "oil_consumption" DOUBLE,
  "oil_elec_per_capita" DOUBLE,
  "oil_energy_per_capita" DOUBLE,
  "oil_production" DOUBLE,
  "oil_prod_per_capita" DOUBLE,
  "other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
  "other_renewables_elec_per_capita" DOUBLE,
  "other_renewables_cons_change_pct" DOUBLE,
  "other_renewables_share_energy" DOUBLE,
  "other_renewables_cons_change_twh" DOUBLE
);

Reunion Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.reunion_energy_data

96.34 kB
41 rows
128 columns

CREATE TABLE reunion_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
);

Romania Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.romania_energy_data

144.95 kB
122 rows
128 columns

CREATE TABLE romania_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
);

Russia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.russia_energy_data

129.75 kB
37 rows
128 columns

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

Rwanda Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.rwanda_energy_data

95.95 kB
41 rows
128 columns

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

Saint Helena Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saint_helena_energy_data

85.01 kB
40 rows
128 columns

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

Saint Kitts And Nevis Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saint_kitts_and_nevis_energy_data

93.12 kB
41 rows
128 columns

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

Saint Lucia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saint_lucia_energy_data

93.7 kB
41 rows
128 columns

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

Saint Pierre And Miquelon Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saint_pierre_and_miquelon_energy_data

92.31 kB
41 rows
128 columns

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

Saint Vincent And The Grenadines Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saint_vincent_and_the_grenadines_energy_data

93.77 kB
41 rows
128 columns

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

Samoa Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.samoa_energy_data

93.89 kB
41 rows
128 columns

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

Sao Tome And Principe Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.sao_tome_and_principe_energy_data

94.21 kB
41 rows
128 columns

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

Saudi Arabia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.saudi_arabia_energy_data

118.13 kB
57 rows
128 columns

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

Senegal Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.senegal_energy_data

99.19 kB
42 rows
128 columns

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

Serbia And Montenegro Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.serbia_and_montenegro_energy_data

83.42 kB
14 rows
128 columns

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

Serbia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.serbia_energy_data

102.6 kB
32 rows
128 columns

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

Seychelles Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.seychelles_energy_data

94.19 kB
41 rows
128 columns

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

Sierra Leone Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.sierra_leone_energy_data

95.54 kB
41 rows
128 columns

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

Singapore Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.singapore_energy_data

117.66 kB
57 rows
128 columns

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

Slovakia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.slovakia_energy_data

134.61 kB
57 rows
128 columns

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

Slovenia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.slovenia_energy_data

122.53 kB
32 rows
128 columns

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

Solomon Islands Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.solomon_islands_energy_data

92.41 kB
41 rows
128 columns

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

Somalia Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.somalia_energy_data

93.18 kB
41 rows
128 columns

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

South Africa Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.south_africa_energy_data

140.1 kB
122 rows
128 columns

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

South Korea Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.south_korea_energy_data

140.16 kB
122 rows
128 columns

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

South Sudan Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.south_sudan_energy_data

91.76 kB
10 rows
128 columns

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

Spain Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.spain_energy_data

151.23 kB
122 rows
128 columns

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

Sri Lanka Energy Data

@kaggle.pranjalverma08_energy_dataset_countrywise_19002021.sri_lanka_energy_data

123.25 kB
56 rows
128 columns

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