NATURAL DISASTERS - USA / LAST 3 MONTHS / NOAA

FULL DETAILS - LAST 3 MONTHS - 3 CSV DOCUMENTS

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa

Table List

3 tables(1.14 MB)

Details C

Fatalities C

Locations C

Details C

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa.details_c

869.7 KB
7538 rows
37 columns

last_date_certified Last Date Certified	episode_id Episode Id	event_id Event Id	state State	state_fips State Fips	year Year	month_name Month Name	event_type Event Type	cz_type Cz Type	cz_fips Cz Fips	cz_name Cz Name	wfo Wfo	begin_date_time Begin Date Time	cz_timezone Cz Timezone	end_date_time End Date Time	damage_property Damage Property	damage_crops Damage Crops	source Source	magnitude Magnitude	magnitude_type Magnitude Type	flood_cause Flood Cause	tor_f_scale Tor F Scale	tor_other_wfo Tor Other Wfo	tor_other_cz_state Tor Other Cz State	tor_other_cz_name Tor Other Cz Name	episode_title Episode Title	episode_narrative Episode Narrative	event_narrative Event Narrative
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159374	963885	GULF OF MEXICO	85	2021	July	Waterspout	Z	830	TAMPA BAY	TBW	Wed Jul 21 2021 07:27:00 GMT+0000 (Coordinated Universal Time)	EST-5	Wed Jul 21 2021 07:27:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Broadcast Media		nan	nan	nan	nan	nan	nan	07/21 - Morning shower spawns waterspout over Tampa Bay	Waterspout formed over Tampa Bay in association with morning convection.	Broadcast media relayed images and video shared by public of a waterspout south of the I-275 Howard Frankland Bridge.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159382	963893	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	830	TAMPA BAY	TBW	Mon Jul 12 2021 14:32:00 GMT+0000 (Coordinated Universal Time)	EST-5	Mon Jul 12 2021 14:32:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	ASOS	45	MG	nan	nan	nan	nan	nan	07/12 - Afternoon storms produce strong marine wind gusts over Tampa Bay and surrounding areas	Afternoon convection moving over Tampa Bay area produces multiple strong wind gusts.	ASOS site KPIE St. Petersburg-Clearwater International Airport reported a 52 mph wind gust.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159382	963895	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	830	TAMPA BAY	TBW	Mon Jul 12 2021 14:31:00 GMT+0000 (Coordinated Universal Time)	EST-5	Mon Jul 12 2021 14:31:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	ASOS	37	MG	nan	nan	nan	nan	nan	07/12 - Afternoon storms produce strong marine wind gusts over Tampa Bay and surrounding areas	Afternoon convection moving over Tampa Bay area produces multiple strong wind gusts.	ASOS site KTPA Tampa International Airport reported a 43 mph wind gust.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159382	963897	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	853	ENGLEWOOD TO TARPON SPRINGS FL OUT 20NM	TBW	Mon Jul 12 2021 14:54:00 GMT+0000 (Coordinated Universal Time)	EST-5	Mon Jul 12 2021 14:54:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Mesonet	39	EG	nan	nan	nan	nan	nan	07/12 - Afternoon storms produce strong marine wind gusts over Tampa Bay and surrounding areas	Afternoon convection moving over Tampa Bay area produces multiple strong wind gusts.	Mesonet site near Clearwater Beach reported a 45 mph wind gust.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159382	963898	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	830	TAMPA BAY	TBW	Mon Jul 12 2021 14:28:00 GMT+0000 (Coordinated Universal Time)	EST-5	Mon Jul 12 2021 14:28:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	AWOS	36	MG	nan	nan	nan	nan	nan	07/12 - Afternoon storms produce strong marine wind gusts over Tampa Bay and surrounding areas	Afternoon convection moving over Tampa Bay area produces multiple strong wind gusts.	AWOS site KMCF MacDill Air Force Base reported a 41 mph wind gust.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159385	963899	FLORIDA	12	2021	July	Thunderstorm Wind	C	81	MANATEE	TBW	Sun Jul 11 2021 15:37:00 GMT+0000 (Coordinated Universal Time)	EST-5	Sun Jul 11 2021 15:37:00 GMT+0000 (Coordinated Universal Time)	5.00K	0.00K	Public	50	EG	nan	nan	nan	nan	nan	07/11 - Strong straight-line winds produce damage to Manatee County home	Afternoon storms damage structure attached to home near Ellenton.	Public report received of structure attached to a manufactured home blown over by straight-line winds.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159386	963900	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	830	TAMPA BAY	TBW	Sun Jul 11 2021 16:18:00 GMT+0000 (Coordinated Universal Time)	EST-5	Sun Jul 11 2021 16:18:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Buoy	43	MG	nan	nan	nan	nan	nan	07/11 - Afternoon storms produce strong marine wind gusts along West Central and Southwest Florida coast	Multiple strong wind gusts reported across west Florida coastal areas in association with afternoon convection.	Buoy in middle Tampa Bay reported a 49 mph wind gust.
Wed Aug 04 2021 11:50:34 GMT+0000 (Coordinated Universal Time)	159386	963901	GULF OF MEXICO	85	2021	July	Marine Thunderstorm Wind	Z	836	CHARLOTTE HARBOR AND PINE ISLAND SOUND	TBW	Sun Jul 11 2021 15:35:00 GMT+0000 (Coordinated Universal Time)	EST-5	Sun Jul 11 2021 15:35:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Mesonet	47	EG	nan	nan	nan	nan	nan	07/11 - Afternoon storms produce strong marine wind gusts along West Central and Southwest Florida coast	Multiple strong wind gusts reported across west Florida coastal areas in association with afternoon convection.	Mesonet site near Port Charlotte reported a 54 mph wind gust.
Sat Aug 07 2021 22:45:17 GMT+0000 (Coordinated Universal Time)	158490	958200	CALIFORNIA	6	2021	July	Flood	C	3	ALPINE	REV	Thu Jul 01 2021 16:20:00 GMT+0000 (Coordinated Universal Time)	PST-8	Thu Jul 01 2021 17:00:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Department of Highways		nan	Heavy Rain	nan	nan	nan	nan	Slow Moving Thunderstorms July 1-2	High pressure nearby with enhanced moisture aloft brought scattered slow moving and outflow dominated thunderstorms to the region.	Caltrans reported several rock slides on Highway 4 between Highway 89 and Ebbetts Pass due to thunderstorm heavy rainfall. Roadway was closed for a couple hours for cleanup.
Sat Aug 07 2021 22:45:17 GMT+0000 (Coordinated Universal Time)	158491	958201	NEVADA	32	2021	July	Flood	C	19	LYON	REV	Thu Jul 01 2021 18:25:00 GMT+0000 (Coordinated Universal Time)	PST-8	Thu Jul 01 2021 19:00:00 GMT+0000 (Coordinated Universal Time)	0.00K	0.00K	Trained Spotter		nan	Heavy Rain	nan	nan	nan	nan	Slow Moving Thunderstorms July 1-2	High pressure nearby with enhanced moisture aloft brought scattered slow moving and outflow dominated thunderstorms to the region.	Spotter reported flooding on some roadways in the Fernley area due to thunderstorms. 0.25 inch of rainfall in 15 minutes.


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
);