Baselight
Sign In

NATURAL DISASTER DATA / NOAA / YEARS

CLIMATE CHANGE / USA

@kaggle.brsdincer_natural_disaster_data_noaa_years

Loading...
Loading...

About this Dataset

NATURAL DISASTER DATA / NOAA / YEARS

NATURAL DISASTER DATA / NOAA / YEARS

You will be seeing the climate disasters of years. It is based on USA. There are disasters that occur in different years. Read the descriptions and the PDF carefully.

Tables

Stormevents Details Database V1–0 D2021 C20210607

@kaggle.brsdincer_natural_disaster_data_noaa_years.stormevents_details_database_v1_0_d2021_c20210607
  • 1.26 MB
  • 10709 rows
  • 60 columns
Loading... 

CREATE TABLE stormevents_details_database_v1_0_d2021_c20210607 (
  "begin_yearmonth" BIGINT,
  "begin_day" BIGINT,
  "begin_time" BIGINT,
  "end_yearmonth" BIGINT,
  "end_day" BIGINT,
  "end_time" BIGINT,
  "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" VARCHAR,
  "cz_timezone" VARCHAR,
  "end_date_time" VARCHAR,
  "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,
  "begin_range" DOUBLE,
  "begin_azimuth" VARCHAR,
  "begin_location" VARCHAR,
  "end_range" DOUBLE,
  "end_azimuth" VARCHAR,
  "end_location" VARCHAR,
  "begin_lat" DOUBLE,
  "begin_lon" DOUBLE,
  "end_lat" DOUBLE,
  "end_lon" DOUBLE,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR,
  "last_mod_date" BIGINT,
  "last_mod_time" BIGINT,
  "last_cert_date" BIGINT,
  "last_cert_time" BIGINT,
  "last_mod" TIMESTAMP,
  "last_cert" TIMESTAMP,
  "addcorr_flg" DOUBLE,
  "addcorr_date" DOUBLE,
  "data_source" VARCHAR
);

Stormevents Details Database V1–0 D2018 C20210604

@kaggle.brsdincer_natural_disaster_data_noaa_years.stormevents_details_database_v1_0_d2018_c20210604
  • 12.45 MB
  • 62693 rows
  • 60 columns
Loading... 

CREATE TABLE stormevents_details_database_v1_0_d2018_c20210604 (
  "begin_yearmonth" BIGINT,
  "begin_day" BIGINT,
  "begin_time" BIGINT,
  "end_yearmonth" BIGINT,
  "end_day" BIGINT,
  "end_time" BIGINT,
  "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" VARCHAR,
  "cz_timezone" VARCHAR,
  "end_date_time" VARCHAR,
  "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" DOUBLE,
  "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,
  "begin_range" DOUBLE,
  "begin_azimuth" VARCHAR,
  "begin_location" VARCHAR,
  "end_range" DOUBLE,
  "end_azimuth" VARCHAR,
  "end_location" VARCHAR,
  "begin_lat" DOUBLE,
  "begin_lon" DOUBLE,
  "end_lat" DOUBLE,
  "end_lon" DOUBLE,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR,
  "last_mod_date" BIGINT,
  "last_mod_time" BIGINT,
  "last_cert_date" BIGINT,
  "last_cert_time" BIGINT,
  "last_mod" TIMESTAMP,
  "last_cert" TIMESTAMP,
  "addcorr_flg" DOUBLE,
  "addcorr_date" DOUBLE,
  "data_source" VARCHAR
);

Stormevents Details Database V1–0 D2020 C20210604

@kaggle.brsdincer_natural_disaster_data_noaa_years.stormevents_details_database_v1_0_d2020_c20210604
  • 12.36 MB
  • 60714 rows
  • 60 columns
Loading... 

CREATE TABLE stormevents_details_database_v1_0_d2020_c20210604 (
  "begin_yearmonth" BIGINT,
  "begin_day" BIGINT,
  "begin_time" BIGINT,
  "end_yearmonth" BIGINT,
  "end_day" BIGINT,
  "end_time" BIGINT,
  "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" VARCHAR,
  "cz_timezone" VARCHAR,
  "end_date_time" VARCHAR,
  "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" DOUBLE,
  "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,
  "begin_range" DOUBLE,
  "begin_azimuth" VARCHAR,
  "begin_location" VARCHAR,
  "end_range" DOUBLE,
  "end_azimuth" VARCHAR,
  "end_location" VARCHAR,
  "begin_lat" DOUBLE,
  "begin_lon" DOUBLE,
  "end_lat" DOUBLE,
  "end_lon" DOUBLE,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR,
  "last_mod_date" BIGINT,
  "last_mod_time" BIGINT,
  "last_cert_date" BIGINT,
  "last_cert_time" BIGINT,
  "last_mod" TIMESTAMP,
  "last_cert" TIMESTAMP,
  "addcorr_flg" DOUBLE,
  "addcorr_date" DOUBLE,
  "data_source" VARCHAR
);

Stormevents Details Database V1–0 D2019 C20210604

@kaggle.brsdincer_natural_disaster_data_noaa_years.stormevents_details_database_v1_0_d2019_c20210604
  • 13.03 MB
  • 67654 rows
  • 60 columns
Loading... 

CREATE TABLE stormevents_details_database_v1_0_d2019_c20210604 (
  "begin_yearmonth" BIGINT,
  "begin_day" BIGINT,
  "begin_time" BIGINT,
  "end_yearmonth" BIGINT,
  "end_day" BIGINT,
  "end_time" BIGINT,
  "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" VARCHAR,
  "cz_timezone" VARCHAR,
  "end_date_time" VARCHAR,
  "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" DOUBLE,
  "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,
  "begin_range" DOUBLE,
  "begin_azimuth" VARCHAR,
  "begin_location" VARCHAR,
  "end_range" DOUBLE,
  "end_azimuth" VARCHAR,
  "end_location" VARCHAR,
  "begin_lat" DOUBLE,
  "begin_lon" DOUBLE,
  "end_lat" DOUBLE,
  "end_lon" DOUBLE,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR,
  "last_mod_date" BIGINT,
  "last_mod_time" BIGINT,
  "last_cert_date" BIGINT,
  "last_cert_time" BIGINT,
  "last_mod" TIMESTAMP,
  "last_cert" TIMESTAMP,
  "addcorr_flg" DOUBLE,
  "addcorr_date" DOUBLE,
  "data_source" VARCHAR
);

Stormevents Details Database V1–0 D2006 C20210603

@kaggle.brsdincer_natural_disaster_data_noaa_years.stormevents_details_database_v1_0_d2006_c20210603
  • 7.64 MB
  • 56400 rows
  • 60 columns
Loading... 

CREATE TABLE stormevents_details_database_v1_0_d2006_c20210603 (
  "begin_yearmonth" BIGINT,
  "begin_day" BIGINT,
  "begin_time" BIGINT,
  "end_yearmonth" BIGINT,
  "end_day" BIGINT,
  "end_time" BIGINT,
  "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" VARCHAR,
  "cz_timezone" VARCHAR,
  "end_date_time" VARCHAR,
  "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,
  "begin_range" DOUBLE,
  "begin_azimuth" VARCHAR,
  "begin_location" VARCHAR,
  "end_range" DOUBLE,
  "end_azimuth" VARCHAR,
  "end_location" VARCHAR,
  "begin_lat" DOUBLE,
  "begin_lon" DOUBLE,
  "end_lat" DOUBLE,
  "end_lon" DOUBLE,
  "episode_title" VARCHAR,
  "episode_narrative" VARCHAR,
  "event_narrative" VARCHAR,
  "last_mod_date" DOUBLE,
  "last_mod_time" DOUBLE,
  "last_cert_date" DOUBLE,
  "last_cert_time" DOUBLE,
  "last_mod" TIMESTAMP,
  "last_cert" TIMESTAMP,
  "addcorr_flg" DOUBLE,
  "addcorr_date" DOUBLE,
  "data_source" VARCHAR
);

Ugc Areas

@kaggle.brsdincer_natural_disaster_data_noaa_years.ugc_areas
  • 281.08 KB
  • 7790 rows
  • 14 columns
Loading... 

CREATE TABLE ugc_areas (
  "combined_id" VARCHAR,
  "ugc_type" VARCHAR,
  "wfo" VARCHAR,
  "valid_from_date" VARCHAR,
  "valid_to_date" VARCHAR,
  "state" VARCHAR,
  "fips" BIGINT,
  "name" VARCHAR,
  "lat" DOUBLE,
  "lon" DOUBLE,
  "timezone" VARCHAR,
  "display_name" VARCHAR,
  "short_ugc" VARCHAR,
  "region" VARCHAR
);

Share link

Anyone who has the link will be able to view this.