Dataset: NATURAL DISASTERS - USA / LAST 3 MONTHS / NOAA

About this Dataset

NATURAL DISASTERS - USA / LAST 3 MONTHS / NOAA

Please read "READ _ ME _ PDF" carefully.
It includes all parameters you need to use and analyze.
This dataset is useful for understand climate change around the USA and predict new disasters.

Tables

Details C

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa.details_c

869.7 KB
7538 rows
37 columns


CREATE TABLE details_c (
  "last_date_modified" TIMESTAMP,
  "last_date_certified" TIMESTAMP,
  "episode_id" BIGINT,
  "event_id" BIGINT,
  "state" VARCHAR,
  "state_fips" BIGINT,
  "year" BIGINT,
  "month_name" VARCHAR,
  "event_type" VARCHAR,
  "cz_type" VARCHAR,
  "cz_fips" BIGINT,
  "cz_name" VARCHAR,
  "wfo" VARCHAR,
  "begin_date_time" TIMESTAMP,
  "cz_timezone" VARCHAR,
  "end_date_time" TIMESTAMP,
  "injuries_direct" BIGINT,
  "injuries_indirect" BIGINT,
  "deaths_direct" BIGINT,
  "deaths_indirect" BIGINT,
  "damage_property" VARCHAR,
  "damage_crops" VARCHAR,
  "source" VARCHAR,
  "magnitude" DOUBLE,
  "magnitude_type" VARCHAR,
  "flood_cause" VARCHAR,
  "category" VARCHAR,
  "tor_f_scale" VARCHAR,
  "tor_length" DOUBLE,
  "tor_width" DOUBLE,
  "tor_other_wfo" VARCHAR,
  "tor_other_cz_state" VARCHAR,
  "tor_other_cz_fips" DOUBLE,
  "tor_other_cz_name" VARCHAR,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR
);

Fatalities C

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa.fatalities_c

6.38 KB
53 rows
7 columns


CREATE TABLE fatalities_c (
  "fatality_id" BIGINT,
  "event_id" BIGINT,
  "fatality_type" VARCHAR,
  "fatality_date" TIMESTAMP,
  "fatality_age" DOUBLE,
  "fatality_sex" VARCHAR,
  "fatality_location" VARCHAR
);

Locations C

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa.locations_c

290.87 KB
11418 rows
8 columns


CREATE TABLE locations_c (
  "episode_id" BIGINT,
  "event_id" BIGINT,
  "location_index" BIGINT,
  "range" DOUBLE,
  "azimuth" VARCHAR,
  "location" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE
);