Damage reports for King County businesses https://www.kingcounty.gov/depts/emergency-management/disaster-recovery/damage-assessment/business-damage-report.aspx
This dataset has the following 26 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 | |
| Business Type | business_type | text | TEST test 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 |
| Estimated Pre Disaster FMV of Bus. | estimated_pre_disaster_fmv_of_bus_ | text | 200000 15000000 $$$$ 250000 500000 view top 100 | |
| Estimated Structure Loss | estimated_structure_loss | text | 50000 0 TEST $$$ 100000 view top 100 | |
| Est. $ Loss Furnishing / Inventory | est_loss_furnishing_inventory | text | 0 41349 6000 TEST 10000 view top 100 | |
| Estimated economic activity loss | estimated_economic_activity_loss | text | Estimated economic activity loss (for example, loss of sales, rental income, etc.) | TEST $$$ view top 100 |
| Cause of primary damage | cause_of_primary_damage | text | Options are: Flood, rain, wind, snow, fire, landslide, earthquake, civil unrest/riot/demonstration (You'll need to make a select option list in the HTML form yourself. The old version uses a dropdown list that can't be edited and now must be made manually.) | Civil unrest/riot/demonstration 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 |
| Civil Unrest Insurance or Rider? | civil_unrest_insurance_or_rider | checkbox | true view top 100 | |
| Deductible | deductible | text | 0 $40000 TEST 1000 1250 view top 100 | |
| Amount of insurance for facility (if known) | amount_of_insurance_for_facility | text | unknown TEST view top 100 | |
| Amount of insurance for contents (if known) | amount_of_insurance_for_contents | text | TEST test view top 100 | |
| # of days closed due to disaster | _of_days_closed_due_to_disaster | text | 3 0 4 test 5 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 |