Name: ALL NATURAL DISASTERS 1900-2021 / EOSDIS
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

ALL NATURAL DISASTERS 1900-2021 / EOSDIS

As we know, the global climate disaster makes its impact on us more felt day by day. Understanding the parameters created by the climate crisis will be helpful in deciding the measures we will take against it.

In this dataset, you will see the natural disasters of all countries.

EOSDIS SYSTEM

Tables

N 1900–2021 Disasters Xlsx Emdat Data

@kaggle.brsdincer_all_natural_disasters_19002021_eosdis.n_1900_2021_disasters_xlsx_emdat_data

1.57 MB
16,126 rows
45 columns

CREATE TABLE n_1900_2021_disasters_xlsx_emdat_data (
  "year" BIGINT,
  "seq" BIGINT,
  "glide" VARCHAR,
  "disaster_group" VARCHAR,
  "disaster_subgroup" VARCHAR,
  "disaster_type" VARCHAR,
  "disaster_subtype" VARCHAR,
  "disaster_subsubtype" VARCHAR,
  "event_name" VARCHAR,
  "country" VARCHAR,
  "iso" VARCHAR,
  "region" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "origin" VARCHAR,
  "associated_dis" VARCHAR,
  "associated_dis2" VARCHAR,
  "ofda_response" VARCHAR,
  "appeal" VARCHAR,
  "declaration" VARCHAR,
  "aid_contribution" DOUBLE,
  "dis_mag_value" DOUBLE,
  "dis_mag_scale" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "local_time" VARCHAR,
  "river_basin" VARCHAR,
  "start_year" BIGINT,
  "start_month" DOUBLE,
  "start_day" DOUBLE,
  "end_year" BIGINT,
  "end_month" DOUBLE,
  "end_day" DOUBLE,
  "total_deaths" DOUBLE,
  "no_injured" DOUBLE,
  "no_affected" DOUBLE,
  "no_homeless" DOUBLE,
  "total_affected" DOUBLE,
  "insured_damages_000_us" DOUBLE  -- Insured Damages (\u0027000 US$),
  "total_damages_000_us" DOUBLE  -- Total Damages (\u0027000 US$),
  "cpi" DOUBLE,
  "adm_level" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "geo_locations" VARCHAR
);

N 1970–2021 Disasters Xlsx Emdat Data

@kaggle.brsdincer_all_natural_disasters_19002021_eosdis.n_1970_2021_disasters_xlsx_emdat_data

1.64 MB
14,644 rows
47 columns

CREATE TABLE n_1970_2021_disasters_xlsx_emdat_data (
  "dis_no" VARCHAR,
  "year" BIGINT,
  "seq" BIGINT,
  "glide" VARCHAR,
  "disaster_group" VARCHAR,
  "disaster_subgroup" VARCHAR,
  "disaster_type" VARCHAR,
  "disaster_subtype" VARCHAR,
  "disaster_subsubtype" VARCHAR,
  "event_name" VARCHAR,
  "country" VARCHAR,
  "iso" VARCHAR,
  "region" VARCHAR,
  "continent" VARCHAR,
  "location" VARCHAR,
  "origin" VARCHAR,
  "associated_dis" VARCHAR,
  "associated_dis2" VARCHAR,
  "ofda_response" VARCHAR,
  "appeal" VARCHAR,
  "declaration" VARCHAR,
  "aid_contribution" DOUBLE,
  "dis_mag_value" DOUBLE,
  "dis_mag_scale" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "local_time" VARCHAR,
  "river_basin" VARCHAR,
  "start_year" BIGINT,
  "start_month" DOUBLE,
  "start_day" DOUBLE,
  "end_year" BIGINT,
  "end_month" DOUBLE,
  "end_day" DOUBLE,
  "total_deaths" DOUBLE,
  "no_injured" DOUBLE,
  "no_affected" DOUBLE,
  "no_homeless" DOUBLE,
  "total_affected" DOUBLE,
  "reconstruction_costs_000_us" DOUBLE  -- Reconstruction Costs (\u0027000 US$),
  "insured_damages_000_us" DOUBLE  -- Insured Damages (\u0027000 US$),
  "total_damages_000_us" DOUBLE  -- Total Damages (\u0027000 US$),
  "cpi" DOUBLE,
  "adm_level" VARCHAR,
  "admin1_code" VARCHAR,
  "admin2_code" VARCHAR,
  "geo_locations" VARCHAR
);