Storm events sample

The data module contains a calculated column named Region that uses a Case statement to assign one of four regions to each state:

case 
when State_ = 'CONNECTICUT' then 'Northeast'
when State_ = 'MAINE' then 'Northeast'
when State_ = 'MASSACHUSETTS' then 'Northeast'
when State_ = 'NEW HAMPSHIRE' then 'Northeast'
when State_ = 'RHODE ISLAND' then 'Northeast'
when State_ = 'VERMONT' then 'Northeast'
when State_ = 'NEW JERSEY' then 'Northeast'
when State_ = 'NEW YORK' then 'Northeast'
when State_ = 'PENNSYLVANIA' then 'Northeast'
when State_ = 'ILLINOIS' then 'Midwest'
when State_ = 'INDIANA' then 'Midwest'
when State_ = 'MICHIGAN' then 'Midwest'
when State_ = 'OHIO' then 'Midwest'
when State_ = 'WISCONSIN' then 'Midwest'
when State_ = 'IOWA' then 'Midwest'
when State_ = 'KANSAS' then 'Midwest'
when State_ = 'MINNESOTA' then 'Midwest'
when State_ = 'MISSOURI' then 'Midwest'
when State_ = 'NEBRASKA' then 'Midwest'
when State_ = 'SOUTH DAKOTA' then 'Midwest'
when State_ = 'NORTH DAKOTA' then 'Midwest'
when State_ = 'DELAWARE' then 'South'
when State_ = 'FLORIDA' then 'South'
when State_ = 'GEORGIA' then 'South'
when State_ = 'MARYLAND' then 'South'
when State_ = 'NORTH CAROLINA' then 'South'
when State_ = 'SOUTH CAROLINA' then 'South'
when State_ = 'VIRGINIA' then 'South'
when State_ = 'DC' then 'South'
when State_ = 'WEST VIRGINIA' then 'South'
when State_ = 'ALABAMA' then 'South'
when State_ = 'KENTUCKY' then 'South'
when State_ = 'MISSISSIPPI' then 'South'
when State_ = 'TENNESSEE' then 'South'
when State_ = 'ARKANSAS' then 'South'
when State_ = 'LOUISIANA' then 'South'
when State_ = 'OKLAHOMA' then 'South'
when State_ = 'TEXAS' then 'South'
when State_ = 'ARIZONA' then 'West'
when State_ = 'COLORADO' then 'West'
when State_ = 'IDAHO' then 'West'
when State_ = 'MONTANA' then 'West'
when State_ = 'NEVADA' then 'West'
when State_ = 'NEW MEXICO' then 'West'
when State_ = 'UTAH' then 'West'
when State_ = 'WYOMING' then 'West'
when State_ = 'ALASKA' then 'West'
when State_ = 'CALIFORNIA' then 'West'
when State_ = 'HAWAII'then 'West'
when State_ = 'OREGON' then 'West'
when State_ = 'WASHINGTON' then 'West'
end

There is a calculated column named Injuries that adds the two different types of injuries, accounting for null values:

coalesce(Direct_Injuries, Indirect_Injuries)

There is a calculated column Deaths that adds the two different types of deaths, accounting for null values:

coalesce(Direct_Deaths, Indirect_Deaths)