Lookups · For Developers & Bulk Analysis
Storm data for any list of addresses.
Query the API from your software. Or upload a CSV and download an enriched spreadsheet. Same data, same lookup pool, same pricing.
How Lookups work
Send addresses in
Call the API with an address or lat/lng — or upload a CSV of addresses through the dashboard.
We query NOAA + NEXRAD
PostGIS spatial search across millions of radar-estimated hail data points and ground reports.
Get storm history back
JSON for API calls, an enriched CSV for uploads. Score, event counts, hail size, dates — everything you need.
Two ways to use it
Call the API
Embed storm history in your software with a few lines of code.
- ✓JSON over simple REST
- ✓Address or lat/lng input
- ✓Used in pricing engines, risk models, property listings
Upload a CSV
Drop in a list of addresses. Download an enriched CSV with storm columns appended.
- ✓Drag-and-drop in the dashboard
- ✓Original columns preserved, storm columns added
- ✓Opens in Excel, Google Sheets, or Numbers
- + stormpull_score96
- + stormpull_tierSevere
- + stormpull_largest_hail_inches4.37
- + stormpull_largest_hail_date2024-06-12
- + stormpull_total_events_10yr1,548
- + stormpull_damaging_events_10yr412
- + stormpull_events_last_12mo101
- + stormpull_events_last_36mo317
- + stormpull_most_recent_event_date2026-04-26
- + stormpull_days_since_last_event8
- + stormpull_lookup_timestamp2026-05-04T18:30Z
Same lookup pool as the API. 1 row = 1 lookup.
Start in minutes
Median response: <200ms · 99.9% uptime · Any language
curl "https://stormpull.com/api/v1/hail/address?address=4521+Oak+Creek+Dr+Austin+TX" \
-H "X-API-Key: ht_live_xxxxxxxxxxxx"Who uses Lookups
Insurance Underwriting
Enrich property risk scoring at scale. Automate hail exposure analysis for any portfolio.
PropTech / SaaS
Embed hail risk in your property reports. One API call adds storm history to any listing.
Portfolio Adjusters
Score every property in a claim portfolio in minutes. Upload a CSV of claims, get exposure scores back.
Restoration & Canvassing
Find storm-exposed neighborhoods to canvass. Upload your lead list or territory list as a CSV.
Lookups pricing — pay per lookup
Every plan includes API access and CSV upload. Same lookup pool either way.
Need more than 40,000 lookups/month? Contact us for Enterprise pricing
Frequently asked
What's the difference between Reports and Lookups?
Reports is for sending one polished PDF per address — branded with your logo, ready to share. Lookups is for processing data: query the API or upload a CSV and download an enriched spreadsheet. See /reports for details.
Can I use both the API and CSV upload on the same plan?
Yes. Every Lookups plan includes both access modes against the same monthly lookup pool. One row of a CSV upload = one lookup.
How big can my CSV upload be?
Up to 25 rows on Sandbox, 500 on Starter, 2,000 on Growth, 10,000 on Scale. Enterprise plans go higher.
What columns does the enriched CSV include?
All your original columns are preserved, plus a Storm Exposure Score, score tier, largest hail size and date, total event counts over 10 years and the last 12 and 36 months, the most recent event date, and a lookup timestamp.
What counts as a lookup?
One address checked = one lookup. Whether you call the API or upload a CSV row, both consume one lookup from your monthly pool.
Can I cancel anytime?
Yes. Cancel through the Stripe billing portal — no lock-in, no cancellation fees.