Billion-Dollar Weather And Climate Disasters
Billion-Dollar Weather and Climate Disasters Events
@kaggle.landfallmotto_billiondollar_weather_and_climate_disasters
Billion-Dollar Weather and Climate Disasters Events
@kaggle.landfallmotto_billiondollar_weather_and_climate_disasters
U.S. disaster cost assessments of the total, direct losses ($) inflicted by: tropical cyclones, inland floods, drought & heat waves, severe local storms (i.e., tornado, hail, straight-line wind damage), wildfires, crop freeze events and winter storms. Dataset also contains summary, time and location of disaster events.
Event: Disaster Type, Location and Date
Begin Date: Disaster Event Begin Date
End Date: Disaster Event End Date
Deaths: Number of deaths in disaster
CPI-Adjusted Estimated Cost (in Billions): Estimated Disaster Cost (*Exceeds $1 billion-dollar threshold after 2021 Consumer Price Index adjustment)
Summary: Summary of Disaster Event Details
Data Source:
National Centers for Environmental Information (NCEI)
https://www.ncdc.noaa.gov/billions/
CREATE TABLE billion_dollar_weather_and_climate_disasters_events_aug_2021 (
"event" VARCHAR,
"begin_date" TIMESTAMP,
"end_date" TIMESTAMP,
"deaths" BIGINT,
"cpi_adjusted_estimated_cost_in_billions" VARCHAR -- CPI-Adjusted Estimated Cost (In Billions),
"summary" VARCHAR
);
Anyone who has the link will be able to view this.