line_itemEvery row
Sample:hail_damaged_solar
The product purchased. For this store, every row is a hail-affected solar permit.
addressEvery row
Sample:6017 Sharpsburg Dr
Street address of the solar installation permit property.
cityEvery row
Sample:Madison
City where the permit property is located.
stateEvery row
Sample:WI
Two-letter state abbreviation.
zipEvery row
Sample:53718
5-digit ZIP code. This is the market level purchased.
countyEvery row
Sample:Dane
County for the property.
latitudeEvery row
Sample:43.086653
Decimal latitude for mapping and route planning.
longitudeEvery row
Sample:-89.275900
Decimal longitude for mapping and route planning.
owner_nameEvery row
Sample:Jamie Carter
Current homeowner from Scout enrichment, appended before delivery.
owner_phoneEvery row
Sample:(608) 555-0194
Primary phone for the homeowner, mobile where available and landline otherwise.
owner_phone_typeEvery row
Sample:mobile
Line type of owner_phone: mobile or landline.
owner_phone_dncEvery row
Sample:N
Do-Not-Call flag on owner_phone. "Y" means the number is on the federal DNC registry; "N" means it is not.
owner_phone_alt
Sample:(608) 555-0217
Second number on file for the homeowner, when enrichment returns more than one.
owner_email
Sample:jcarter@example.com
Homeowner email from recent enrichment, when available.
alt_contact_name
Sample:Morgan Carter
Second adult on file, usually a spouse or relative sharing the address.
alt_contact_phone
Sample:(608) 555-0337
Phone number for alt_contact_name, when available.
permit_idEvery row
Sample:975052306
Original permit identifier from the normalized permit row.
building_permit_idEvery row
Sample:975052306
Scout building permit identifier for joining back to normalized permit data.
permit_dateEvery row
Sample:2025-03-10
Solar permit date from the source permit record.
effective_dateEvery row
Sample:2025-03-10
Normalized permit effective date used for sorting and recency filters.
status_normalized
Sample:COMPLETE
Normalized permit status where the source record provides it.
installer
Sample:Sunburn Construction LLC
Installer listed on the underlying solar permit, when present.
permit_description
Sample:Residential solar PV, roof-mounted array
Free-text description filed with the permit. Often mentions system size, modules, or roof mount context.
permit_value
Sample:$24,000
Dollar value filed on the permit application, when available.
roof_panel_verifiedEvery row
Sample:Y
Roof intelligence verification that visible solar panels are present on the property.
max_hail_inEvery row
Sample:4.00
Largest hail magnitude matched to this property during the season.
worst_hail_dateEvery row
Sample:2026-04-14
Date of the largest matched hail event for the property.
hail_daysEvery row
Sample:1
Number of distinct hail days matched to this property.
first_hail_dateEvery row
Sample:2026-04-14
First matched hail exposure date in the season window.
last_hail_dateEvery row
Sample:2026-04-14
Last matched hail exposure date in the season window.
hail_event_datesEvery row
Sample:2026-04-14
Pipe-delimited list of matched hail exposure dates for this property.
owner_ageEvery row
Sample:52
Age of the primary owner in years, from the enrichment record.
owner_occupation
Sample:Operations Manager
Self-reported occupation from the enrichment record, when present.
home_value
Sample:$486,000
Most recent market value from county tax rolls.
sqftEvery row
Sample:2,180
Living square footage from the parcel assessor record.
year_builtEvery row
Sample:2012
Year the home was originally built.
bedrooms
Sample:4
Bedroom count from the parcel assessor record.
bathrooms
Sample:2.5
Bathroom count from the parcel assessor record.
stories
Sample:2
Number of floors, useful for scoping access and roof work complexity.
lot_size_sqftEvery row
Sample:8,712
Parcel lot size in square feet.
has_poolEvery row
Sample:N
"Y" if the parcel record shows a pool; "N" if it does not.
roof_material
Sample:Asphalt Shingle
Primary roof material from the parcel record, when available.
hvac_cooling
Sample:Central
Cooling-system type from the parcel record.
garage
Sample:Attached, 2-car
Garage description from the parcel record, when available.
purchase_date
Sample:2018-07-12
Date the current owner bought the home, when available.
purchase_price
Sample:$332,500
What the current owner paid for the home, when available.
annual_property_tax
Sample:$5,842
Most recent annual property-tax bill from the assessor record.