Damage reports for King AND Spokane County businesses after November 2015 storm
This dataset has the following 15 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Business Name | business_name | text | TEST test Abaculo LLC dba Cherry Creek Farm Lake Villas Condominium Association Steel wheel Farm view top 100 | |
Degree of Damage | description_of_damages | drop_down_list | Damage Categories - Use the pull down menu to select Affected, Minor, Major, Minor or Destroyed. The description of the categories pops up each time you click on a cell in this column. This is important information we will need to do the Preliminary Damag | view top 100 |
Facility Owner or Renter | owner_s_name | text | Lake Villas Condominium Association me Ryan Lichttenegger Wayne Gullstad TEST view top 100 | |
Street Address | street_address | text | 31913 se 28th st test 123 4th st Unit 47, floor 2 500 4th Ave 4030 WEST LAKE SAMMAMISH Pkwy NE view top 100 | |
City | city | text | Redmond Auburn Mercer Island Issaquah Seattle view top 100 | |
ZIP Code | zip_code | text | 98104 98040 98024 98052 98027 view top 100 | |
Business occupant | business_occupant | drop_down_list | Business occupant | view top 100 |
Type of insurance | type_of_insurance | drop_down_list | Insurance - Use the pull down menu. If the Cause of Damage is FLOOD, then the insurance MUST be Flood or None. If the damage is from a mudslide, the insurance MUST be Landslide or None. Wind, Rain or Snow events would be covered by Structure & Contents in | view top 100 |
Business Continuity Insurance? | business_continuity_insurance_ | drop_down_list | Business Continuity Insurance | view top 100 |
Date Damage Occurred | date_damage_occurred | calendar_date | What day did the primary damage occur? | 2020-02-05T00:00:00.000 2020-02-05T12:00:00.000 2020-02-06T05:30:00.000 0004-10-06T10:30:00.000 2020-02-08T09:00:00.000 view top 100 |
Description of damages | degreeofdamage | text | Description of damages - Be brief - comment on the damage to business and contents or any access restrictions to the property. Damage to Out buildings, landscaping, are NOT eligible categories for federal assistance and need not be reported. Crop damage | THIS IS A TEST - Business form TEST Lost driveway gravel , scoured road, Floor covered in silt and water, some expensive tooling was wet, some inventory was lost broken stuff view top 100 |
Contact Name | contact_name | text | Tyler Weaver br CJS Test Biz Ryan Lichttenegger Wayne Gullstad view top 100 | |
Contact Phone | contact_phone | text | 555-555-5555 4257864017 eyppppp 206-263-9758 425-770-7926 view top 100 | |
Contact Email | contact_email | text | info@clearimageglass.com TYLERW@BESTPMC.NET test@test.com steelwheelfarm@gmail.com gullstad@comcast.net view top 100 | |
Location | _location | location | Location coordinates, based on address information | view top 100 |