Climate Change Impacts
@owid.climate_change_impacts
@owid.climate_change_impacts
CREATE TABLE owid_climate_change_impacts_annual_1 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_2 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_3 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_4 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_5 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_6 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_7 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_8 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"sea_temperature_anomaly_annual" FLOAT,
"sea_temperature_anomaly_low_annual" FLOAT,
"sea_temperature_anomaly_high_annual" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_9 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"sea_temperature_anomaly_annual" FLOAT,
"sea_temperature_anomaly_low_annual" FLOAT,
"sea_temperature_anomaly_high_annual" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT,
"near_surface_temperature_anomaly" FLOAT,
"near_surface_temperature_anomaly_lower" FLOAT,
"near_surface_temperature_anomaly_upper" FLOAT
);
CREATE TABLE owid_climate_change_impacts_annual_10 (
"location" VARCHAR,
"year" INTEGER,
"ocean_heat_content_csiro_700m" FLOAT,
"ocean_heat_content_iap_2000m" FLOAT,
"ocean_heat_content_iap_700m" FLOAT,
"ocean_heat_content_mri_2000m" FLOAT,
"ocean_heat_content_mri_700m" FLOAT,
"ocean_heat_content_noaa_2000m" FLOAT,
"ocean_heat_content_noaa_700m" FLOAT,
"sea_temperature_anomaly_annual" FLOAT,
"sea_temperature_anomaly_low_annual" FLOAT,
"sea_temperature_anomaly_high_annual" FLOAT,
"arctic_sea_ice_extent_max" FLOAT,
"arctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_min" FLOAT,
"antarctic_sea_ice_extent_max" FLOAT,
"ch4_concentration" FLOAT,
"co2_concentration" FLOAT,
"n2o_concentration" FLOAT,
"mass_balance_us_glaciers" FLOAT,
"near_surface_temperature_anomaly" FLOAT,
"near_surface_temperature_anomaly_lower" FLOAT,
"near_surface_temperature_anomaly_upper" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_1 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_2 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_3 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_4 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_5 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_6 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" FLOAT,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_7 (
"location" VARCHAR,
"date" VARCHAR,
"temperature_anomaly" FLOAT,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" UINTEGER,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_8 (
"location" VARCHAR,
"date" VARCHAR,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" UINTEGER,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_9 (
"location" VARCHAR,
"date" VARCHAR,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" UINTEGER,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
CREATE TABLE owid_climate_change_impacts_monthly_10 (
"location" VARCHAR,
"date" VARCHAR,
"sea_ice_extent" FLOAT,
"sea_temperature_anomaly" FLOAT,
"sea_temperature_anomaly_low" FLOAT,
"sea_temperature_anomaly_high" FLOAT,
"ocean_heat_content_2000m" FLOAT,
"ocean_heat_content_700m" FLOAT,
"ocean_ph" FLOAT,
"ocean_ph_yearly_average" FLOAT,
"snow_cover_extent" UINTEGER,
"snow_cover_extent_yearly_average" UINTEGER,
"cumulative_ice_mass_change_imbie" FLOAT,
"land_ice_mass_nasa" FLOAT,
"co2_concentration" FLOAT,
"co2_concentration_yearly_average" FLOAT,
"ch4_concentration" FLOAT,
"ch4_concentration_yearly_average" FLOAT,
"n2o_concentration" FLOAT,
"n2o_concentration_yearly_average" FLOAT,
"sea_level_church_and_white_2011" FLOAT,
"sea_level_uhslc" FLOAT,
"sea_level_average" FLOAT
);
Anyone who has the link will be able to view this.