Damage form for business - 6/9/20

data.kingcounty.gov | Last Updated 9 Jun 2020

Damage reports for King County businesses https://www.kingcounty.gov/depts/emergency-management/disaster-recovery/damage-assessment/business-damage-report.aspx

Tags: damages, business

This dataset has the following 26 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Business Namebusiness_nametext
Business Typebusiness_typetext
Degree of Damagedescription_of_damagesdrop_down_listDamage 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
Facility Owner or Renterowner_s_nametext
Street Addressstreet_addresstext
ZIP Codezip_codetext
Business occupantbusiness_occupantdrop_down_listBusiness occupant
Estimated Pre Disaster FMV of Bus.estimated_pre_disaster_fmv_of_bus_text
Estimated Structure Lossestimated_structure_losstext
Est. $ Loss Furnishing / Inventoryest_loss_furnishing_inventorytext
Estimated economic activity lossestimated_economic_activity_losstextEstimated economic activity loss (for example, loss of sales, rental income, etc.)
Cause of primary damagecause_of_primary_damagetextOptions 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.)
Type of insurancetype_of_insurancedrop_down_listInsurance - 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
Civil Unrest Insurance or Rider?civil_unrest_insurance_or_ridercheckbox
Amount of insurance for facility (if known)amount_of_insurance_for_facilitytext
Amount of insurance for contents (if known)amount_of_insurance_for_contentstext
# of days closed due to disaster_of_days_closed_due_to_disastertext
Business Continuity Insurance?business_continuity_insurance_drop_down_listBusiness Continuity Insurance
Date Damage Occurreddate_damage_occurredcalendar_dateWhat day did the primary damage occur?
Description of damagesdegreeofdamagetextDescription 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
Contact Namecontact_nametext
Contact Phonecontact_phonetext
Contact Emailcontact_emailtext
Location_locationlocationLocation coordinates, based on address information