Climate Data — CO₂, Temp, Emissions, Sea Level
Climate change data: CO₂, temperature, emissions, sea level, glaciers, quotas
@kaggle.mostov_climate_data_co_temp_emissions_sea_level
Climate change data: CO₂, temperature, emissions, sea level, glaciers, quotas
@kaggle.mostov_climate_data_co_temp_emissions_sea_level
CREATE TABLE annual (
"source" VARCHAR,
"year" BIGINT,
"mean" DOUBLE
);
CREATE TABLE co2_annmean_gl (
"year" BIGINT,
"mean" DOUBLE,
"uncertainty" DOUBLE
);
CREATE TABLE co2_annmean_mlo (
"year" BIGINT,
"mean" DOUBLE,
"uncertainty" DOUBLE
);
CREATE TABLE co2_gr_gl (
"year" BIGINT,
"annual_increase" DOUBLE,
"uncertainty" DOUBLE
);
CREATE TABLE co2_gr_mlo (
"year" BIGINT,
"annual_increase" DOUBLE,
"uncertainty" DOUBLE
);
CREATE TABLE co2_mm_gl (
"date" TIMESTAMP,
"decimal_date" DOUBLE,
"average" DOUBLE,
"trend" DOUBLE
);
CREATE TABLE csiro_recons_gmsl_mo_2015 (
"time" VARCHAR,
"gmsl" DOUBLE,
"gmsl_uncertainty" DOUBLE
);
CREATE TABLE epa_sea_level (
"year" BIGINT,
"csiro_adjusted_sea_level" DOUBLE,
"lower_error_bound" DOUBLE,
"upper_error_bound" DOUBLE,
"noaa_adjusted_sea_level" DOUBLE
);
CREATE TABLE eu_ets (
"country_code" VARCHAR,
"country" VARCHAR,
"main_activity_sector_name" VARCHAR,
"ets_information" VARCHAR,
"year" VARCHAR,
"value" DOUBLE,
"unit" VARCHAR
);
CREATE TABLE fossil_fuel_co2_emissions_by_nation (
"year" BIGINT,
"country" VARCHAR,
"total" BIGINT,
"solid_fuel" DOUBLE,
"liquid_fuel" DOUBLE,
"gas_fuel" DOUBLE,
"cement" DOUBLE,
"gas_flaring" DOUBLE,
"per_capita" DOUBLE,
"bunker_fuels_not_in_total" DOUBLE
);
CREATE TABLE glaciers (
"year" BIGINT,
"mean_cumulative_mass_balance" DOUBLE,
"number_of_observations" DOUBLE
);
CREATE TABLE global (
"year" BIGINT,
"total" BIGINT,
"gas_fuel" BIGINT,
"liquid_fuel" BIGINT,
"solid_fuel" BIGINT,
"cement" BIGINT,
"gas_flaring" BIGINT,
"per_capita" DOUBLE
);
CREATE TABLE global_temp_5yr (
"year" BIGINT,
"land" DOUBLE,
"land_and_ocean" DOUBLE,
"n_hem" DOUBLE,
"s_hem" DOUBLE,
"band_1" DOUBLE,
"band_2" DOUBLE,
"band_3" DOUBLE
);
CREATE TABLE global_temp_annual (
"year" BIGINT,
"land" DOUBLE,
"land_and_ocean" DOUBLE,
"n_hem" DOUBLE,
"s_hem" DOUBLE,
"band_1" DOUBLE,
"band_2" DOUBLE,
"band_3" DOUBLE
);
CREATE TABLE monthly (
"source" VARCHAR,
"year" TIMESTAMP,
"mean" DOUBLE
);
Anyone who has the link will be able to view this.