Compare your markets.
Keep the workbook.
Compare county hazards for your acquisition or asset-management shortlist. Keep a workbook with sources, a summary and follow-up tasks.
Inside the example report.
25 locations screened.
Follow 25 synthetic location rows through county matching and reporting. Evidence comes from five reviewed counties reconciled to the FEMA National Risk Index (December 2025 release). Unmatched rows remain visible; no county matches are invented.
Portfolio concentration
Distribution of 23 valid locations across the five reviewed markets:
Which rows need follow-up?
Unmatched rows stay in the Exceptions sheet with a reason and next action. They are never dropped or given invented values:
| Row ID | Supplied FIPS | Diagnosed status | Resolution action |
|---|---|---|---|
| SYN-24 | 99999 | exception: unreviewed_fips | County FIPS not in reviewed snapshot. Provide valid county code or request custom review. |
| SYN-25 | — | exception: missing_or_malformed_fips | Invalid or missing FIPS code. Verify county parcel boundaries or coordinates. |
Download the demonstration deliverable
Download the XLSX workbook and summary PDF for this 25-location example:
Six sheets: Summary · County Evidence (27 metrics) · Locations · Exceptions · Dictionary (27 definitions) · Sources
Open the workbook.
Check each sheet.
Six sheets keep county values, your shortlist and review tasks together.
| County / FIPS | Wildfire rating | Hurricane rating | Total expected annual loss ($/year) |
|---|---|---|---|
| Los Angeles, CA06037 | Very High | No Rating | $7,601,846,373 |
| Denver, CO08031 | Very Low | Not Applicable | $221,992,551 |
| Miami-Dade, FL12086 | Relatively Moderate | Very High | $824,686,737 |
| Harris, TX48201 | Relatively Low | Very High | $2,217,702,383 |
| Chittenden, VT50007 | Very Low | Relatively Low | $40,136,955 |
Rounded county losses · source precision in download
Not Applicable ≠ No Rating
01 / Summary The shortlist at a glance
Location counts, county concentration and a separate count of unresolved rows.
02 / County Evidence The values behind the comparison
27 reviewed metrics: 7 hazard ratings, 15 expected annual loss figures, 3 exposure values and 2 vulnerability/resilience scores. Original county codes (FIPS) stay attached.
03 / Locations Your list, organized
A stable row ID and supplied county FIPS connect each location to its county context.
04 / Exceptions The work still to resolve
Invalid or unsupported FIPS remain visible, with a reason and next action.
05 / Dictionary A definition beside every measure
27 metric definitions, units, geographic levels and source formulas.
06 / Sources A trail back to the input
Sources, releases and observation periods stay together. Sources: FEMA National Risk Index (NRI), Social Vulnerability Index (SoVI), Baseline Resilience Indicators for Communities (BRIC), U.S. Census.
Free /sample/: two sheets, County context and Read me
Example report: six custom-report sheets
Choose the output you need
| Included | Free sample | Custom report · $499 pilot proposal |
|---|---|---|
| County evidence | Five published counties, all 27 reviewed metrics | 27 reviewed metrics organized around up to 25 supplied location rows; county coverage confirmed first |
| Files | Two-sheet XLSX and CSV | Six-sheet XLSX (27 metrics) plus 3-page PDF summary |
| Review workflow | Compare and explore yourself | Location-to-county list, concentration summary, exceptions and source notes |
| Follow-up | Field dictionary and guides | One source-to-output clarification or correction round |
Three questions this report helps you answer
- How do the county hazard labels differ across the markets on our shortlist?
- What is the scale of modeled county loss, with building loss shown separately?
- Which supplied rows need a county match or another source before review?
Each measure keeps its original geographic level; the example above explains how to handle county loss totals.
What must be confirmed before ordering?
The $499 pilot proposal covers up to 25 supplied rows after county coverage confirmation. Agree delivery timing with the scope. Five counties are reviewed; additional counties and regional water or mineral research need separate coverage checks.
Before choosing your report
What am I paying for if the underlying data is public?
Your county-linked shortlist, comparison, source definitions, unresolved rows and PDF summary. Inspect the free sample before choosing the format.
Can I use this for an individual property?
Attach county context using a known county FIPS. Flood-zone determinations, building loss estimates and site inspections need separate evidence.
Are water rights and mineral rights included?
They are separate research scopes. The county report shown here contains the 27 reviewed FEMA and resilience measures. It does not establish water availability, ownership or extraction rights.
Which counties can I inspect now?
Los Angeles, Denver, Miami-Dade, Harris and Chittenden. Open the interactive comparison or download the same records as Excel.