Exposure
Risks covered under a policy.
Attributes for the latest version are below.
Attributes
Cover Sheet array
Child Attributes
Cover Sheet object
An object that contains covering data about a given submission.
Child Attributes
File Name string
The name of the original source file.
File ID string
Unique identifier for the file within Groundspeed’s platform.
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Division string
Division of the insured responsible for the exposure.
Property array
Child Attributes
Property object
An object that contains property data.
Child Attributes
File Name string
The name of the original source file.
Record ID string
Unique id for a record within a file in Groundspeed’s platform.
File ID string
Unique identifier for the file within Groundspeed’s platform.
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Currency string
Currency in which financial values are denominated.
Description Of Operations string
Description of operations at a given location.
Description string
Additional descriptive details regarding a location.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location County string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
County of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Country string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Country of exposure.
Latitude float
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
The latitude of exposure.
Longitude float
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
The longitude of exposure.
Valuation Date string
Valuation date for exposure information.
Policy Year integer
Year indicated for exposure, taken from source document.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
Location Name string
Name of location of exposure.
Location Number string
Identifier for location of exposure.
Building Number string
Unique identifier for a building.
Date Added string
The date on which a location was added to a schedule.
Delete Date string
The date on which a location was deleted from a schedule.
Building Value float
The total building insured value.
Contents Value float
The total contents insured value.
Other Value float
The total other insured value.
BI Value float
The total business income value.
Total Insured Value float
The sum total insured value.
Occupancy string
Main use of location/building.
Construction string
Description of construction methods/materials used at location.
Year Built string
Year location was constructed.
Year Upgraded string
Year of most recent upgrade/renovation at location.
Area float
Specified area at location.
Number Of Stories integer
Number of stories at location.
Number Of Buildings integer
Number of buildings at location.
Number Of Floors Occupied integer
Number of occupied floors at location.
Wind Zone string
Wind zone designation at location.
Earthquake Zone string
Earthquake zone designation at location.
Flood Zone string
Flood zone designation at location.
Construction Quality string
The construction quality of a building.
Construction Quality Convective Storm string
The construction quality of a building with respects to the convective storm peril.
Construction Quality Earthquake string
The construction quality of a building with respects to the earthquake peril.
Roof Covering string
The material used to cover the roof.
Roof Covering Convective Storm string
The material used to cover the roof with respects to the convective storm peril.
Roof Age string
The age of the roof in years.
Roof Age Convective Storm string
The age of the roof with respects to the convective storm peril.
Roof Geometry string
The shape of the roof.
Roof Geometry Convective Storm string
The shape of the roof with respects to the convective storm peril.
Roof Anchor string
The roof anchorage system.
Roof Anchor Convective Storm string
The roof anchorage system with respects to the convective storm peril.
Roof Equipment string
Indicates if equipment is braced on the roof and the impact this will have on losses.
Roof Equipment Convective Storm string
Indicates if equipment is braced on the roof and the impact this will have on losses with respects to the convective storm peril.
Basement string
Indicates the presence of a basement.
Basement Convective Storm string
Indicates the presence of a basement with respects to the convective storm peril.
Other Structures string
Indicates the presence of other structures.
Other Structures Convective Storm string
Indicates the presence of other structures with respects to the convective storm peril.
Cladding string
The presence and material of exterior building cladding.
Cladding Convective Storm string
The presence and material of exterior building cladding with respects to the convective storm peril.
Cladding Earthquake string
The presence and material of exterior building cladding with respects to the earthquake peril.
Frame Connection string
The type of connection used between the frame and foundation.
Frame Connection Convective Storm string
The type of connection used between the frame and foundation with respects to the convective storm peril.
Ground Level Equipment string
Indicates whether equipment is present at the ground level of a building.
Ground Level Equipment Convective Storm string
Indicates whether equipment is present at the ground level of a building with respects to the convective storm peril.
Opening Protection string
Indicates the protection used on openings of a building.
Opening Protection Convective Storm string
Indicates the protection used on openings of a building with respects to the convective storm peril.
Flashing and Coping string
Indicates the quality of flashing or coping on a roof.
Flashing and Coping Convective Storm string
Indicates the quality of flashing or coping on a roof with respects to the convective storm peril.
Base Isolation string
Indicates the presence and type of a seismic base isolation system.
Equipment Support Maintenance string
Indicates the support maintenance system for equipment.
Engineered Foundation string
Indicates the type of foundation in a building.
Frame Bolt string
The type of bolt used to connect the frame.
Masonry Chimney string
Indicates the presence and height of a chimney.
Masonry Partitions string
Indicates the presence and type of partitions in a building.
Equipment Bracing string
Indicates the presence of and type bracing for equipment.
Ornamentation string
Indicates the presence of building ornamentation.
Vertical Irregularity string
Indicates vertical irregularities of a building.
Pounding string
Represents the distance to the closet structure.
Plan Irregularity string
Indicates plan irregularities of a building.
Short Column string
Indicates if there are short columns in the building.
Soft Story string
Indicates if there is a structural weakness at any floor.
Structural Upgrade string
Indicates if a structural upgrade has been made to a building.
Purlin Anchoring string
Indicates if purlin anchoring is used.
URMRetrofit string
Indicates the presence of a unreinforced masonry retrofit for a building.
Cripple Walls string
Indicates the presence of cripple walls in a building.
Sprinkler string
Indicates the presence or type of sprinkler in a building.
Sprinkler string
Indicates the presence or type of sprinkler in a building.
Wind Missiles string
Description of the wind missile risk for this location.
Mechanical Electrical Equipment string
The presence and type of bracing used to protect mechanical and electrical equipment from earthquake damage.
BI Preparedness string
Description of the business interruption preparedness for this location.
BI Redundancy string
Description of the business interruption redundancy for this location.
Redundancy string
Indicates the presence and type of the redundancy in place.
Tree Density string
Description of the density of trees adjacent to a building.
Construction Code string
The code representing the construction type of a building.
Sprinkler Leakage Susceptibility string
Description of the sprinkler leakage susceptibility of this location.
Door Resistance string
Description of the door resistance of this location.
Roof Maintenance string
Captures the impact roof maintenance has on the losses.
Parapets Chimneys string
Description of the parapets or chimneys in place at this location.
Time Element Period string
Indicates the amount of time for BI coverage.
Unique Market Reference string
A reference assigned to the binding authority by the Lloyds market.
Auto array
Child Attributes
Auto object
An object that contains auto data.
Child Attributes
File Name string
The name of the original source file.
Record ID string
Unique id for a record within a file in Groundspeed platform.
File ID string
Unique identifier for the file within Groundspeed platform.
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Currency string
Currency in which financial values are denominated.
Location Name string
Name of location of exposure.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location County string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
County of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Country string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Country of exposure.
Valuation Date string
Valuation date for exposure information.
Policy Year integer
Year indicated for exposure, taken from source document.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
VIN string
Vehicle identification number of vehicle.
Vehicle Body string
Body type of vehicle.
Vehicle Make string
Make of vehicle.
Vehicle Model string
Model of vehicle.
Gross Vehicle Weight Rating string
Maximum operating weight range of vehicle.
Vehicle Year string
Model year of vehicle.
Class Code string
Vehicle class code.
Normalized Vehicle Type string
Type of Vehicle Insured.
Vehicle Value float
Monetary value of the vehicle.
Vehicle Registered State string
State where vehicle is registered.
Vehicle Use string
Type of use of vehicle.
Vehicle Radius string
Operating range of vehicle.
Miles Driven string
Distance traveled during period.
Private Passenger Vehicles Count integer
Count of private passenger vehicles. Only present on summary records.
Light Vehicles Count integer
Count of light vehicles. Only present on summary records.
Medium Vehicles Count integer
Count of medium vehicles. Only present on summary records.
Heavy Vehicles Count integer
Count of heavy vehicles. Only present on summary records.
Extra Heavy Vehicles Count integer
Count of extra heavy vehicles. Only present on summary records.
Total Vehicles Count integer
Total count of vehicles. Only present on summary records.
Trailers Count integer
Count of trailers. Only present on summary records.
Date Added string
The date on which a location was added to a schedule.
Delete Date string
The date on which a location was deleted from a schedule.
Payroll array
Child Attributes
Payroll object
An object that contains payroll data.
Child Attributes
File Name string
The name of the original source file.
Record ID string
Unique id for a record within a file in Groundspeed’s platform.
File ID string
Unique identifier for the file within Groundspeed’s platform.
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Division string
Division of the insured responsible for the exposure.
Currency string
Currency in which financial values are denominated.
Description Of Operations string
Description of operations at a given location.
Description string
Additional descriptive details regarding a location.
Location Name string
Name of location of exposure.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location County string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
County of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Country string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Country of exposure.
Valuation Date string
Valuation date for exposure information.
Policy Year integer
Year indicated for exposure, taken from source document.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
Industry Class string
The classification of an insureds primary business activities.
Class Code string
Provided worker classification code.
Class Code Description string
Description of worker classification.
Employee Type string
Description of employee type.
Full-Time Employee Count integer
Count of full-time employees.
Part-Time Employee Count integer
Count of part-time employees.
Temp Employee Count integer
Count of temp employees.
Seasonal Employee Count integer
Count of seasonal employees.
Total Employee Count integer
Total count of employees.
Experience Modifier float
Experience modifier applied for premium rating.
Payroll float
Amount of payroll exposure. Defaults to audited if present on source document, otherwise reflects estimated payroll.
Rate float
A value used to calculate rated premium for an exposure.
Rate Type string
The type of rating used to determine an insurance premium.
Premium Basis Raw string
The raw value description of the basis of the exposure.
Premium Basis Calculated string
The normalized value description of the basis of the exposure.
Rated Premium float
Premium calculated using the exposure and rate.
Revenue array
Child Attributes
Revenue object
An object that contains revenue data.
Child Attributes
File Name string
The name of the original source file.
Record ID string
Unique id for a record within a file in Groundspeed’s platform.
File ID string
Unique identifier for the file within Groundspeed’s platform.
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Division string
Division of the insured responsible for the exposure.
Currency string
Currency in which financial values are denominated.
Description Of Operations string
Description of operations at a given location.
Description string
Additional descriptive details regarding a location.
Location Name string
Name of location of exposure.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location County string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
County of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Country string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Country of exposure.
Valuation Date string
Valuation date for exposure information.
Policy Year integer
Year indicated for exposure, taken from source document.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
Occupancy string
Main use of location/building.
Revenue float
Total revenue at location.
Estimated Revenue float
Estimated revenue at location.
Gross Revenue float
Realized revenue.
Net Revenue float
Revenue net cost of revenue.
Cost Of Goods Sold float
Cost of goods sold for insured.
Exposure Value float
The value of an item or a measure of potential loss.
Rate float
A value used to calculate rated premium for an exposure.
Rate Type string
The type of rating used to determine an insurance premium.
Premium Basis Raw string
The raw value description of the basis of the exposure.
Premium Basis Calculated string
The normalized value description of the basis of the exposure.
Rated Premium float
Premium calculated using the exposure and rate.
Equipment array
Child Attributes
Equipment object
An object that contains equipment data.
Child Attributes
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Division string
Division of the insured responsible for the exposure.
Currency string
Currency in which financial values are denominated.
Location Name string
Name of location of exposure.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location County string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
County of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Location Country string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Country of exposure.
Valuation Date string
Valuation date for exposure information.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
Policy Year integer
Year indicated for exposure, taken from source document.
Vehicle Number string
Numeric code assigned to the vehicle.
VIN string
Vehicle identification number of vehicle.
Vehicle Body string
Body type of vehicle.
Serial Number string
Serial number of the vehicle.
Vehicle Make string
Make of vehicle.
Vehicle Model string
Model of vehicle.
Vehicle Year string
Model year of vehicle.
Normalized Vehicle Type string
Type of Vehicle Insured.
Description string
Description of vehicle.
Current Value float
Current monetary value of the equipment.
Purchase Price float
Original purchase price of the equipment.
Replacement Cost float
Cost to replace the piece of equipment.
Garage Location string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Address where equipment is stored.
Garage City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City where equipment is stored.
Garage State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State where equipment is stored.
Vehicle License Plate State string
State where license plate is issued.
License Plate Number string
Vehicle license plate number.
Date Added string
The date on which a equipment was added to a schedule.
Vehicle Radius string
Operating range of equipment.
Ownership string
Ownership status of vehicle.
Connectors string
Type of connector used on equipment.
attachmentTypeRaw string
The type of attachment fixed to a vehicle.
Fuel Type string
Type of fuel used by equipment.
Vehicle Weight string
Weight of vehicle without battery.
Vehicle Weight With Battery string
Weight of vehicle with battery.
Use Hours string
The number of hours a vehicle has been used as of the valuation date.
Capacity string
Total carrying capacity of vehicle.
Vehicle Status string
The status of a vehicle.
Record ID string
Unique id for a record within a file.
File ID string
Unique identifier for the file within Groundspeeds platform.
File Name string
The name of the original source file.
Drivers array
Child Attributes
Drivers object
An object that contains driver data.
Child Attributes
ACTION CODE string
Value indicating a record to be sent for a driver motor vehicle report.
ACCOUNT string
Account identifier for the insured.
BILL CODE string
Not currently supported.
STATE string
The state in which the driver’s license was issued.
DL NUMBER string
The driver’s license number.
DATE OF BIRTH string
The driver’s date of birth.
LAST NAME string
The driver’s last name.
SUFFIX string
The driver’s suffix.
FIRST NAME string
The driver’s first name.
MIDDLE NAME string
The driver’s middle name.
GENDER string
The driver’s gender.
RESERVED null
Not currently supported.
REQUEST TYPE null
Not currently supported.
COMMENT string
Additional information about this driver motor vehicle request.
FILL OPTION null
Not currently supported.
GROUP NAME string
The classification of the driver’s license.
MEDICAL CERTIFICATION EXPIRATION string
The date on which the driver’s medical certification expires.
HIRE DATE string
The date on which the driver was hired.
HEIGHT float
The driver’s height in inches.
WEIGHT float
The driver’s weight in pounds.
Record ID string
Unique id for a record within a file.
File ID string
Unique identifier for the file within Groundspeeds platform.
Aircraft array
Child Attributes
Named Insured string
Full name of the insured.
Business Entity string
Subsidiary of the insured responsible for exposure.
Division string
Division of the insured responsible for the exposure.
Currency string
Currency in which financial values are denominated.
Location Street Address string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Street address of exposure.
Location City string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
City of exposure.
Location State string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
State of exposure.
Location Zip Code string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Zip Code of exposure.
Valuation Date string
Valuation date for exposure information.
Effective Date string
Effective date for exposure.
Expiration Date string
Expiration date for exposure.
Policy Year integer
Year indicated for exposure, taken from source document.
Vehicle Number string
Numeric code assigned to the vehicle.
Tail Number string
Aircraft identification number.
Vehicle Make string
Make of vehicle.
Vehicle Model string
Model of vehicle.
Vehicle Year string
Model year of vehicle.
Wingspan string
Max extent across aircraft wings.
Vehicle Weight string
Weight of vehicle without battery.
Vehicle Type string
Type of vehicle insured.
Take Off Method string
Method of takeoff for aircraft.
Auto Take Off Return string
Whether an aircraft has automatic take off and return functionality.
Modified From Original string
An indication that a vehicle was modified from its original construction.
Description string
Description of vehicle.
Current Value float
Current monetary value of the equipment.
Purchase Price float
Original purchase price of the equipment.
Garage Location string
This field is sourced from a 3rd party provider only available in our Premium subscription tier.
Address where equipment is stored.
Date Added string
The date on which a equipment was added to a schedule.
Ownership string
Ownership status of vehicle.
Use Hours string
The number of hours a vehicle has been used as of the valuation date.
Record ID string
Unique id for a record within a file.
File ID string
Unique identifier for the file within Groundspeeds platform.
File Name string
The name of the original source file.
Sample Data
[
{
"Cover Sheet": [
{
"File Name": "8188389664.xlsx",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "NA - Warehousing"
}
],
"Property": [
{
"File Name": "8188389664.xlsx",
"Record ID": "606ea4a3-9bb5-400f-9e89-1979a17f06a1",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Latitude": 42.27,
"Longitude": -83.732,
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Location Name": "Warehouse BB",
"Location Number": "1",
"Building Number": "04",
"Date Added": "07/01/2017",
"Delete Date": "08/13/2019",
"Building Value": 700000,
"Contents Value": 500000,
"Other Value": 150000,
"BI Value": 100000,
"Total Insured Value": 1300000,
"Occupancy": "Commercial, wholesale trade",
"Construction": "Block",
"Year Built": "1996",
"Year Upgraded": "1999",
"Area": 34500,
"Number Of Stories": 1,
"Number Of Buildings": 9,
"Number Of Floors Occupied": 9,
"Wind Zone": "Zone A",
"Earthquake Zone": "Zone 10",
"Flood Zone": "VE",
"Construction Quality": "Good",
"Construction Quality Convective Storm": "Medium",
"Construction Quality Earthquake": "Low",
"Roof Covering": "Copper",
"Roof Covering Convective Storm": "Plywood",
"Roof Age": "23",
"Roof Age Convective Storm": "19",
"Roof Geometry": "Gambrel",
"Roof Geometry Convective Storm": "Gambrel",
"Roof Anchor": "Hurricane Ties",
"Roof Anchor Convective Storm": "Adhesive Epoxy",
"Roof Equipment": "No equipment",
"Roof Equipment Convective Storm": "Vulnerable",
"Basement": "No basement",
"Basement Convective Storm": "Unfinished basement",
"Other Structures": "Other fences",
"Other Structures Convective Storm": "Shed",
"Cladding": "Tile",
"Cladding Convective Storm": "Clapboards",
"Cladding Earthquake": "Stucco",
"Frame Connection": "Gravity / Friction",
"Frame Connection Convective Storm": "Structurally Connected",
"Ground Level Equipment": "Vulnerable",
"Ground Level Equipment Convective Storm": "Vulnerable",
"Opening Protection": "No protection",
"Opening Protection Convective Storm": "Engineered shutters",
"Flashing and Coping": "Vulnerable",
"Flashing and Coping Convective Storm": "Resilient",
"Base Isolation": "Visco-elastic dampers",
"Equipment Support Maintenance": "Unknown / default",
"Engineered Foundation": "Crawl space masonry",
"Frame Bolt": "Anchor Bolts",
"Masonry Chimney": "Yes, height <= 2 ft",
"Masonry Partitions": "Gypsum boards",
"Equipment Bracing": "Unbraced",
"Ornamentation": "None",
"Veritcal Irregularity": "Vertical Offset",
"Pounding": "0-0.25 m",
"Plan Irregularity": "Non-uniform Floor Area",
"Short Column": "No",
"Soft Story": "Yes",
"Structural Upgrade": "Unknown",
"Purlin Anchoring": "No",
"URMRetrofit": "General",
"Cripple Walls": "No",
"Sprinkler": "N",
"Wind Missiles": "Unknown",
"Mechanical Electrical Equipment": "Generally unbraced 3",
"BI Preparedness": "Resilient",
"BI Redundancy": "Vulnerable",
"Redundancy": "Little or No redundancy 2",
"Tree Density": "Low tree risk",
"Construction Code": "110",
"Sprinkler Leakage Susceptibility": "Low 1",
"Door Resistance": "Not Designed for Wind Protection 3",
"Roof Maintenance": "Resilient",
"Parapets Chimneys": "No Parapets 2",
"Time Element Period": "365",
"Unique Market Reference": "B1526ENSAM1800207"
}
],
"Auto": [
{
"File Name": "vehicle schedule XLSX.xlsx",
"Record ID": "a3ce1a5e-6495-4388-a8d8-839242f4f67c",
"File ID": "HDechKo1UG56oaJKG",
"Named Insured": "ABC Corp.",
"Business Entity": "NA Operations",
"Currency": "usd",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"VIN": "1GDGG31V831905067",
"Vehicle Body": "Truck",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Gross Vehicle Weight Rating": "<10,000",
"Vehicle Year": "2003",
"Class Code": "7398",
"Normalized Vehicle Type": "Light Truck",
"Vehicle Value": 0,
"Vehicle Registered State": "MI",
"Vehicle Use": "commercial",
"Vehicle Radius": "Local",
"Miles Driven": "1340",
"Private Passenger Vehicles Count": 3,
"Light Vehicles Count": 8,
"Medium Vehicles Count": 7,
"Heavy Vehicles Count": 3,
"Extra Heavy Vehicles Count": 9,
"Total Vehicles Count": 100,
"Trailers Count": 40,
"Date Added": "07/01/2017",
"Delete Date": "08/13/2019",
"Active Safety System Note": null,
"Adaptive Cruise Control": null,
"Adaptive Driving Beam": null,
"Adaptive Headlights": null,
"Air bag Location Curtain": null,
"Air Bag Location Front": "1st Row (Driver and Passenger)",
"Air Bag Location Knee": null,
"Air Bag Location Seat Cushion": null,
"Air Bag Location Side": "1st Row (Driver and Passenger)",
"Auto Reverse System": null,
"Automatic Pedestrain Alerting Sound": null,
"Axle Configuration": null,
"Axles": null,
"Battery Amps": null,
"Battery Amps To": null,
"Battery Cells": null,
"Battery Info": null,
"Battery KWH": null,
"Battery KWH To": null,
"Battery Modules": null,
"Battery Packs": null,
"Battery Type": null,
"Battery Voltage": null,
"Battery Voltage To": null,
"Bed Length": null,
"Bed Type": null,
"Blind Spot Monitoring": null,
"Body cab Type": null,
"Body Class": "Sport Utility Vehicle (SUV)/Multi-Purpose Vehicle (MPV)",
"Brake System Description": null,
"Brake System Type": null,
"Bus Floor Configuration Type": "Not Applicable",
"Bus Length": null,
"Controller Area Network Advanced Automatic Collision Notification": null,
"Crash Imminent Brake System": null,
"Charger Level": null,
"Charger Power KWH": null,
"Cooling Type": null,
"Curb Weight Lb": null,
"Daytime Running Lights": null,
"Displacement CC": 2979.1682352,
"Displacement CI": 181.8,
"Diplacement Litres": 3,
"Doors": 4,
"Vehicle Drive Type": null,
"Driver Assist": null,
"Dynamic Brake Support": null,
"Event Data Recorder": null,
"Electronic Stability Control": null,
"EV Drive Unit": null,
"Electrification Level": null,
"Engine Cycles": null,
"Engine Cylinders": 6,
"Engine HP": 300,
"Engine HP To": null,
"Engine Kw": 223.71,
"Engine Manufacturer": null,
"Engine Model": null,
"Entertainment System": null,
"Forward Collision Warning": null,
"Fuel Injection Type": null,
"Fuel Type Primary": "Gasoline",
"Fuel Type Secondary": null,
"Keyless Ignition": null,
"Lane Departure Warning": null,
"Lane Keep System": null,
"Manufacturer": "BMW MANUFACTURER CORPORATION / BMW NORTH AMERICA",
"Other Restraint System Info": "Head Inflatable Restraint for Driver, Front Passenger, Rear Outboard Driver-side and Rear Outboard Passenger-side. Knee Inflatable Restraint for Driver. Pretensioners for Driver and Front Passenger.",
"Other Trailer Info": null,
"Park Assist": null,
"Pedestrian Automatic Emergency Braking": null,
"Pretensioner": "Yes",
"Rear Cross Traffic Alert": null,
"SAE Automation Level": null,
"SAE Automation Level To": null,
"Seat Belts All": "Manual",
"Seat Rows": null,
"Semiautomatic Headlamp Beam Switching": null,
"Tire Pressure Monitoring System": "Direct",
"Top Speed MPH": null,
"Track Width": null,
"Traction Control": null,
"Trailer Body Type": "Not Applicable",
"Trailer Length": null,
"Trailer Type": "Not Applicable",
"Transmission Type": null,
"Trim": "xDrive35i",
"Valve Train Design": null,
"Wheels": null,
"Wheel Base Long": null,
"Wheel Base Short": null,
"Windows": null,
"Rear Automated Emergency Braking": null,
"Blind Spot Intervention System": null,
"Lane Centering Assistance System": null,
"Backup Camera": null,
"Blind Spot Warning System": null,
"Headlamp Light Source": null
}
],
"Payroll": [
{
"File Name": "GL.xlsx",
"Record ID": "caa9171b-e4fa-4941-9867-4d50ea6bca4d",
"File ID": "csrY7oNATgKGDGsFJ",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Industry Class": "Legal Services",
"Class Code": "53377",
"Class Code Description": "Food Products Manufacturing - Not Dry - In Other than Glass Containers",
"Employee Type": "Full-time",
"Full-Time Employee Count": 41,
"Part-Time Employee Count": 55,
"Temp Employee Count": 66,
"Seasonal Employee Count": 0,
"Total Employee Count": 80,
"Experience Modifier": 0.87,
"Payroll": 2300000,
"Rate": 2.07,
"Rate Type": "Prem/Ops",
"Premium Basis Raw": "Dollars of Gross Sales",
"Premium Basis Calculated": "Gross Sales",
"Rated Premium": 820000
}
],
"Revenue": [
{
"File Name": "GL.xlsx",
"Record ID": "606ea4a3-9bb5-400f-9e89-1979a17f06a1",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Occupancy": "Commercial, wholesale trade",
"Revenue": 12040000,
"Estimated Revenue": 6540050,
"Gross Revenue": 5200000,
"Net Revenue": 4010000,
"Cost Of Goods Sold": 1022000,
"Exposure Value": 132501976,
"Rate": 2.07,
"Rate Type": "Prem/Ops",
"Premium Basis Raw": "Dollars of Gross Sales",
"Premium Basis Calculated": "Gross Sales",
"Rated Premium": 820000
}
],
"Equipment": [
{
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Zip Code": "01007",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Policy Year": 2018,
"Vehicle Number": "834",
"VIN": "1GDGG31V831905067",
"Vehicle Body": "Truck",
"Serial Number": "FDP08963",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Vehicle Year": "2000",
"Normalized Vehicle Type": "Light Truck",
"Description": "BACKHOE/LOADER",
"Current Value": 19800,
"Purchase Price": 64923,
"Replacement Cost": 5600,
"Garage Location": "872 Carlsbad Dr",
"Garage City": "Springfield",
"Garage State": "GA",
"Vehicle License Plate State": "OH",
"License Plate Number": "3B-33E",
"Date Added": "01/10/2003",
"Vehicle Radius": "Local",
"Ownership": "Private",
"Connectors": "350 gray",
"attachmentTypeRaw": "Keg fork",
"Fuel Type": "Gas",
"Vehicle Weight": "3000lbs",
"Vehicle Weight With Battery": "2000",
"Use Hours": "50hrs",
"Capacity": "40T",
"Vehicle Status": "added",
"Record ID": "0654a9cb-8152-47f3-9fd3-c6989044ac19",
"File ID": "JIlIWD6TdPhncds9P",
"File Name": "Equipment 6.csv"
}
],
"Drivers": [
{
"ACTION CODE": "MVR",
"ACCOUNT": "3019288",
"BILL CODE": "00",
"STATE": "TX",
"DL NUMBER": "O9204173",
"DATE OF BIRTH": "10/09/1967",
"LAST NAME": "kralovetz",
"SUFFIX": "jr",
"FIRST NAME": "rodger",
"MIDDLE NAME": "eugene",
"GENDER": "male",
"RESERVED": null,
"REQUEST TYPE": null,
"COMMENT": "new",
"FILL OPTION": null,
"GROUP NAME": "CDL-B",
"MEDICAL CERTIFICATION EXPIRATION": "02/01/2024",
"HIRE DATE": "07/11/2011",
"HEIGHT": 69,
"WEIGHT": 171,
"Record ID": "2e5d8fcb-d112-47c7-a57c-7eba1ca5d2ff",
"File ID": "s3oRXTHHzh9zwjFMj"
}
],
"Aircraft": [
{
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Location Street Address": "987 Oak Lane",
"Location City": "Springfield",
"Location State": "MA",
"Location Zip Code": "01007",
"Valuation Date": "03/15/2017",
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Policy Year": 2018,
"Vehicle Number": "834",
"Tail Number": "N44VP",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Vehicle Year": "2000",
"Wingspan": "39",
"Vehicle Weight": "2100",
"Vehicle Type": "aircraft",
"Take Off Method": "Hand launch",
"Auto Take Off Return": "yes",
"Modified From Original": "no",
"Description": "Crew Seats",
"Current Value": 19800,
"Purchase Price": 64923,
"Garage Location": "872 Carlsbad Dr",
"Date Added": "01/10/2003",
"Ownership": "Private",
"Use Hours": "50hrs",
"Record ID": "1b10c1f8-d884-487e-b635-d123386e9107",
"File ID": "Gig7XRmnkg534YwCD",
"File Name": "Aircraft Schedule 22-23.xlsx"
}
]
}
]
[
{
"Cover Sheet": [
{
"File Name": "8188389664.xlsx",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "NA - Warehousing"
}
],
"Property": [
{
"File Name": "8188389664.xlsx",
"Record ID": "606ea4a3-9bb5-400f-9e89-1979a17f06a1",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Latitude": 42.279,
"Longitude": -83.732,
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Location Name": "Warehouse BB",
"Location Number": "1",
"Building Number": "04",
"Date Added": "07/01/2017",
"Delete Date": "08/13/2019",
"Building Value": 700000,
"Contents Value": 500000,
"Other Value": 150000,
"BI Value": 100000,
"Total Insured Value": 1300000,
"Occupancy": "Commercial, wholesale trade",
"Construction": "Block",
"Year Built": "1996",
"Year Upgraded": "1999",
"Area": 34500,
"Number Of Stories": 1,
"Number Of Buildings": 9,
"Number Of Floors Occupied": 9,
"Wind Zone": "Zone A",
"Earthquake Zone": "Zone 10",
"Flood Zone": "VE",
"Construction Quality": "Good",
"Construction Quality Convective Storm": "Medium",
"Construction Quality Earthquake": "Low",
"Roof Covering": "Copper",
"Roof Covering Convective Storm": "Plywood",
"Roof Age": "23",
"Roof Age Convective Storm": "19",
"Roof Geometry": "Gambrel",
"Roof Geometry Convective Storm": "Gambrel",
"Roof Anchor": "Hurricane Ties",
"Roof Anchor Convective Storm": "Adhesive Epoxy",
"Roof Equipment": "No equipment",
"Roof Equipment Convective Storm": "Vulnerable",
"Basement": "No basement",
"Basement Convective Storm": "Unfinished basement",
"Other Structures": "Other fences",
"Other Structures Convective Storm": "Shed",
"Cladding": "Tile",
"Cladding Convective Storm": "Clapboards",
"Cladding Earthquake": "Stucco",
"Frame Connection": "Gravity / Friction",
"Frame Connection Convective Storm": "Structurally Connected",
"Ground Level Equipment": "Vulnerable",
"Ground Level Equipment Convective Storm": "Vulnerable",
"Opening Protection": "No protection",
"Opening Protection Convective Storm": "Engineered shutters",
"Flashing and Coping": "Vulnerable",
"Flashing and Coping Convective Storm": "Resilient",
"Base Isolation": "Visco-elastic dampers",
"Equipment Support Maintenance": "Unknown / default",
"Engineered Foundation": "Crawl space masonry",
"Frame Bolt": "Anchor Bolts",
"Masonry Chimney": "Yes, height <= 2 ft",
"Masonry Partitions": "Gypsum boards",
"Equipment Bracing": "Unbraced",
"Ornamentation": "None",
"Veritcal Irregularity": "Vertical Offset",
"Pounding": "0-0.25 m",
"Plan Irregularity": "Non-uniform Floor Area",
"Short Column": "No",
"Soft Story": "Yes",
"Structural Upgrade": "Unknown",
"Purlin Anchoring": "No",
"URMRetrofit": "General",
"Cripple Walls": "No",
"Sprinkler": "N",
"Wind Missiles": "Unknown",
"Mechanical Electrical Equipment": "Generally unbraced 3",
"BI Preparedness": "Resilient",
"BI Redundancy": "Vulnerable",
"Redundancy": "Little or No redundancy 2",
"Tree Density": "Low tree risk",
"Construction Code": "110",
"Sprinkler Leakage Susceptibility": "Low 1",
"Door Resistance": "Not Designed for Wind Protection 3",
"Roof Maintenance": "Resilient",
"Parapets Chimneys": "No Parapets 2",
"Time Element Period": "365",
"Unique Market Reference": "B1526ENSAM1800207"
}
],
"Auto": [
{
"File Name": "vehicle schedule XLSX.xlsx",
"Record ID": "a3ce1a5e-6495-4388-a8d8-839242f4f67c",
"File ID": "HDechKo1UG56oaJKG",
"Named Insured": "ABC Corp.",
"Business Entity": "NA Operations",
"Currency": "usd",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"VIN": "1GDGG31V831905067",
"Vehicle Body": "Truck",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Gross Vehicle Weight Rating": "<10,000",
"Vehicle Year": "2003",
"Class Code": "7398",
"Normalized Vehicle Type": "Light Truck",
"Vehicle Value": 0,
"Vehicle Registered State": "MI",
"Vehicle Use": "commercial",
"Vehicle Radius": "Local",
"Miles Driven": "1340",
"Private Passenger Vehicles Count": 3,
"Light Vehicles Count": 8,
"Medium Vehicles Count": 7,
"Heavy Vehicles Count": 3,
"Extra Heavy Vehicles Count": 9,
"Total Vehicles Count": 100,
"Trailers Count": 40,
"Date Added": "07/01/2017",
"Delete Date": "08/13/2019"
}
],
"Payroll": [
{
"File Name": "GL.xlsx",
"Record ID": "caa9171b-e4fa-4941-9867-4d50ea6bca4d",
"File ID": "csrY7oNATgKGDGsFJ",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Industry Class": "Legal Services",
"Class Code": "53377",
"Class Code Description": "Food Products Manufacturing - Not Dry - In Other than Glass Containers",
"Employee Type": "Full-time",
"Full-Time Employee Count": 41,
"Part-Time Employee Count": 55,
"Temp Employee Count": 66,
"Seasonal Employee Count": 0,
"Total Employee Count": 80,
"Experience Modifier": 0.87,
"Payroll": 2300000,
"Rate": 2.07,
"Rate Type": "Prem/Ops",
"Premium Basis Raw": "Dollars of Gross Sales",
"Premium Basis Calculated": "Gross Sales",
"Rated Premium": 820000
}
],
"Revenue": [
{
"File Name": "GL.xlsx",
"Record ID": "606ea4a3-9bb5-400f-9e89-1979a17f06a1",
"File ID": "TugpGmo0gRuvAZizw",
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Description Of Operations": "Shipping & Storage",
"Description": "Equipment storage",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location Zip Code": "01007",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Policy Year": 2018,
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Occupancy": "Commercial, wholesale trade",
"Revenue": 12040000,
"Estimated Revenue": 6540050,
"Gross Revenue": 5200000,
"Net Revenue": 4010000,
"Cost Of Goods Sold": 1022000,
"Exposure Value": 132501976,
"Rate": 2.07,
"Rate Type": "Prem/Ops",
"Premium Basis Raw": "Dollars of Gross Sales",
"Premium Basis Calculated": "Gross Sales",
"Rated Premium": 820000
}
],
"Equipment": [
{
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Location Name": "Warehouse",
"Location Street Address": "987 Oak Lane",
"Location City": "Springfield",
"Location County": "Hampton",
"Location State": "MA",
"Location Zip Code": "01007",
"Location Country": "USA",
"Valuation Date": "03/15/2017",
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Policy Year": 2018,
"Vehicle Number": "834",
"VIN": "1GDGG31V831905067",
"Vehicle Body": "Truck",
"Serial Number": "FDP08963",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Vehicle Year": "2000",
"Normalized Vehicle Type": "Light Truck",
"Description": "BACKHOE/LOADER",
"Current Value": 19800,
"Purchase Price": 64923,
"Replacement Cost": 5600,
"Garage Location": "872 Carlsbad Dr",
"Garage City": "Springfield",
"Garage State": "GA",
"Vehicle License Plate State": "OH",
"License Plate Number": "3B-33E",
"Date Added": "01/10/2003",
"Vehicle Radius": "Local",
"Ownership": "Private",
"Connectors": "350 gray",
"attachmentTypeRaw": "Keg fork",
"Fuel Type": "Gas",
"Vehicle Weight": "3000lbs",
"Vehicle Weight With Battery": "2000",
"Use Hours": "50hrs",
"Capacity": "40T",
"Vehicle Status": "added",
"Record ID": "0654a9cb-8152-47f3-9fd3-c6989044ac19",
"File ID": "JIlIWD6TdPhncds9P",
"File Name": "Equipment 6.csv"
}
],
"Drivers": [
{
"ACTION CODE": "MVR",
"ACCOUNT": "3019288",
"BILL CODE": "00",
"STATE": "TX",
"DL NUMBER": "O9204173",
"DATE OF BIRTH": "10/09/1967",
"LAST NAME": "kralovetz",
"SUFFIX": "jr",
"FIRST NAME": "rodger",
"MIDDLE NAME": "eugene",
"GENDER": "male",
"RESERVED": null,
"REQUEST TYPE": null,
"COMMENT": "new",
"FILL OPTION": null,
"GROUP NAME": "CDL-B",
"MEDICAL CERTIFICATION EXPIRATION": "02/01/2024",
"HIRE DATE": "07/11/2011",
"HEIGHT": 69,
"WEIGHT": 171,
"Record ID": "2e5d8fcb-d112-47c7-a57c-7eba1ca5d2ff",
"File ID": "s3oRXTHHzh9zwjFMj"
}
],
"Aircraft": [
{
"Named Insured": "SURF STYLE",
"Business Entity": "ACME",
"Division": "Warehousing",
"Currency": "USD",
"Location Street Address": "987 Oak Lane",
"Location City": "Springfield",
"Location State": "MA",
"Location Zip Code": "01007",
"Valuation Date": "03/15/2017",
"Effective Date": "03/15/2017",
"Expiration Date": "03/15/2017",
"Policy Year": 2018,
"Vehicle Number": "834",
"Tail Number": "N44VP",
"Vehicle Make": "GMC",
"Vehicle Model": "C6500 Topkick",
"Vehicle Year": "2000",
"Wingspan": "39",
"Vehicle Weight": "2100",
"Vehicle Type": "aircraft",
"Take Off Method": "Hand launch",
"Auto Take Off Return": "yes",
"Modified From Original": "no",
"Description": "Crew Seats",
"Current Value": 19800,
"Purchase Price": 64923,
"Garage Location": "872 Carlsbad Dr",
"Date Added": "01/10/2003",
"Ownership": "Private",
"Use Hours": "50hrs",
"Record ID": "1b10c1f8-d884-487e-b635-d123386e9107",
"File ID": "Gig7XRmnkg534YwCD",
"File Name": "Aircraft Schedule 22-23.xlsx"
}
]
}
]