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

Fatalities C

@kaggle.brsdincer_natural_disasters_usa_last_3_months_noaa.fatalities_c

6.38 KB
53 rows
7 columns

fatality_id Fatality Id	event_id Event Id	fatality_type Fatality Type	fatality_date Fatality Date	fatality_age Fatality Age	fatality_sex Fatality Sex	fatality_location Fatality Location
44140	960613	D	Fri Jul 16 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	71	M	Golfing
43206	961309	I	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	32	M	Other
43207	961309	I	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	31	M	Other
43208	961309	I	Tue Jul 20 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		M	Other
43215	962841	I	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	47	M	Vehicle/Towed Trailer
43216	962841	I	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	16	F	Vehicle/Towed Trailer
43217	962841	I	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	17	F	Vehicle/Towed Trailer
43218	962841	I	Wed Jul 07 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	17	M	Vehicle/Towed Trailer
43235	964040	D	Sat Jul 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		M	Outside/Open Areas
43240	964357	D	Fri Jul 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	37	M	Under Tree


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