Energy Dataset Country-Wise (1900-2021)
Complete Energy dataset including several metrics for country wise comparison.
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021
Complete Energy dataset including several metrics for country wise comparison.
@kaggle.pranjalverma08_energy_dataset_countrywise_19002021
CREATE TABLE bahamas_energy_data (
"iso_code" VARCHAR,
"country" VARCHAR,
"year" BIGINT,
"coal_prod_change_pct" VARCHAR,
"coal_prod_change_twh" DOUBLE,
"gas_prod_change_pct" VARCHAR,
"gas_prod_change_twh" VARCHAR,
"oil_prod_change_pct" VARCHAR,
"oil_prod_change_twh" VARCHAR,
"energy_cons_change_pct" DOUBLE,
"energy_cons_change_twh" DOUBLE,
"biofuel_share_elec" DOUBLE,
"biofuel_elec_per_capita" DOUBLE,
"biofuel_cons_change_pct" VARCHAR,
"biofuel_share_energy" VARCHAR,
"biofuel_cons_change_twh" VARCHAR,
"biofuel_consumption" VARCHAR,
"biofuel_cons_per_capita" VARCHAR,
"carbon_intensity_elec" DOUBLE,
"coal_share_elec" DOUBLE,
"coal_cons_change_pct" VARCHAR,
"coal_share_energy" VARCHAR,
"coal_cons_change_twh" VARCHAR,
"coal_consumption" VARCHAR,
"coal_elec_per_capita" DOUBLE,
"coal_cons_per_capita" VARCHAR,
"coal_production" DOUBLE,
"coal_prod_per_capita" DOUBLE,
"electricity_demand" DOUBLE,
"biofuel_electricity" DOUBLE,
"coal_electricity" DOUBLE,
"fossil_electricity" DOUBLE,
"gas_electricity" DOUBLE,
"hydro_electricity" DOUBLE,
"nuclear_electricity" DOUBLE,
"oil_electricity" DOUBLE,
"other_renewable_exc_biofuel_electricity" DOUBLE,
"other_renewable_electricity" DOUBLE,
"renewables_electricity" DOUBLE,
"solar_electricity" DOUBLE,
"wind_electricity" DOUBLE,
"electricity_generation" DOUBLE,
"greenhouse_gas_emissions" DOUBLE,
"energy_per_gdp" VARCHAR,
"energy_per_capita" DOUBLE,
"fossil_cons_change_pct" VARCHAR,
"fossil_share_energy" VARCHAR,
"fossil_cons_change_twh" VARCHAR,
"fossil_fuel_consumption" VARCHAR,
"fossil_energy_per_capita" VARCHAR,
"fossil_cons_per_capita" DOUBLE,
"fossil_share_elec" DOUBLE,
"gdp" VARCHAR,
"gas_share_elec" DOUBLE,
"gas_cons_change_pct" VARCHAR,
"gas_share_energy" VARCHAR,
"gas_cons_change_twh" VARCHAR,
"gas_consumption" VARCHAR,
"gas_elec_per_capita" DOUBLE,
"gas_energy_per_capita" VARCHAR,
"gas_production" VARCHAR,
"gas_prod_per_capita" VARCHAR,
"hydro_share_elec" DOUBLE,
"hydro_cons_change_pct" VARCHAR,
"hydro_share_energy" VARCHAR,
"hydro_cons_change_twh" VARCHAR,
"hydro_consumption" VARCHAR,
"hydro_elec_per_capita" DOUBLE,
"hydro_energy_per_capita" VARCHAR,
"low_carbon_share_elec" DOUBLE,
"low_carbon_electricity" DOUBLE,
"low_carbon_elec_per_capita" DOUBLE,
"low_carbon_cons_change_pct" VARCHAR,
"low_carbon_share_energy" VARCHAR,
"low_carbon_cons_change_twh" VARCHAR,
"low_carbon_consumption" VARCHAR,
"low_carbon_energy_per_capita" VARCHAR,
"net_elec_imports_share_demand" DOUBLE,
"net_elec_imports" DOUBLE,
"nuclear_share_elec" DOUBLE,
"nuclear_cons_change_pct" VARCHAR,
"nuclear_share_energy" VARCHAR,
"nuclear_cons_change_twh" VARCHAR,
"nuclear_consumption" VARCHAR,
"nuclear_elec_per_capita" DOUBLE,
"nuclear_energy_per_capita" VARCHAR,
"oil_share_elec" DOUBLE,
"oil_cons_change_pct" VARCHAR,
"oil_share_energy" VARCHAR,
"oil_cons_change_twh" VARCHAR,
"oil_consumption" VARCHAR,
"oil_elec_per_capita" DOUBLE,
"oil_energy_per_capita" VARCHAR,
"oil_production" VARCHAR,
"oil_prod_per_capita" VARCHAR,
"other_renewables_elec_per_capita_exc_biofuel" DOUBLE,
"other_renewables_elec_per_capita" DOUBLE,
"other_renewables_cons_change_pct" VARCHAR,
"other_renewables_share_energy" VARCHAR,
"other_renewables_cons_change_twh" VARCHAR
);
Anyone who has the link will be able to view this.