Property Climate Resilience Scorecard
This dataset provides a comprehensive scorecard for evaluating the climate resilience of real estate assets, including detailed risk exposure scores, mitigation investments, adaptation readiness, and insurance coverage. Designed for property managers and asset owners, it enables benchmarking, strategic planning, and compliance reporting to enhance building climate risk strategies. The dataset supports informed decision-making for climate adaptation and risk management in the real estate sector.
Sample rows
preview · 8 of 50 rows · all 26 columns| property_idstring | property_typestring | physical_risk_scorefloat | adaptation_plan_existsboolean | statestring | property_namestring | street_addressstring | citystring | postal_codestring | countrystring | year_builtinteger | number_of_floorsinteger | total_floor_area_sqftfloat | flood_risk_scorefloat | wildfire_risk_scorefloat | heat_risk_scorefloat | storm_risk_scorefloat | mitigation_investment_usdfloat | adaptation_readiness_scorefloat | last_adaptation_plan_updatedate | insurance_coverage_typestring | insurance_coverage_amount_usdfloat | manager_idstring | owner_idstring | scorecard_datedate | mitigation_measuresstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PROP-0001 | residential | 62.4 | true | CO | Greenview Towers | 1050 Elm Street | Denver | 80205 | USA | 1998 | 12 | 95000.2 | 15.2 | 28.9 | 55.6 | 34.1 | 480000 | 80.5 | 2024-03-08 | comprehensive | 12000000 | MGR-102 | OWN-401 | 2024-05-15 | green roofs,flood barriers,energy efficient windows |
| PROP-0002 | office | 45.1 | true | CA | Riverside Complex | 2201 River Road | Sacramento | 95818 | USA | 2003 | 6 | 78000 | 67.8 | 8.9 | 41.7 | 36 | 310000 | 72.9 | 2023-12-12 | flood | 8500000 | MGR-205 | OWN-601 | 2024-05-18 | flood barriers,solar panels |
| PROP-0003 | mixed-use | 69.5 | true | CA | Sunset Lofts | 890 Sunset Blvd | Los Angeles | 90046 | USA | 2018 | 22 | 210000 | 22 | 55.3 | 80 | 18.2 | 680000 | 91.3 | 2024-01-19 | wildfire | 17000000 | MGR-316 | OWN-725 | 2024-05-11 | fire-resistant materials,green roofs,cool pavements |
| PROP-0004 | office | 53.2 | false | MA | Harbor Point Offices | 301 Harbor Dr | Boston | 02110 | USA | 1981 | 8 | 63000 | 45.7 | 0 | 31.5 | 65.1 | 210000 | 68 | blank | comprehensive | 7000000 | MGR-102 | OWN-519 | 2024-05-09 | flood barriers,storm shutters |
| PROP-0005 | residential | 77.8 | true | TX | Silver Pine Residences | 1545 Pine St | Houston | 77019 | USA | 2011 | 9 | 104000 | 82.3 | 5.6 | 88.2 | 74.9 | 950000 | 85.9 | 2023-09-22 | flood | 20000000 | MGR-215 | OWN-645 | 2024-05-12 | elevated foundation,flood barriers,storm shutters |
| PROP-0006 | retail | 44.2 | false | WA | The Market Place | 320 Main St | Seattle | 98101 | USA | 1972 | 3 | 52000 | 12.4 | 10.2 | 29.8 | 52.6 | 160000 | 59.1 | blank | comprehensive | 5000000 | MGR-412 | OWN-915 | 2024-05-13 | storm shutters,drainage upgrade |
| PROP-0007 | industrial | 38.3 | false | OH | Parkside Industrial | 800 Industrial Ave | Cleveland | 44115 | USA | 1964 | 1 | 135000 | 19 | 0 | 25.7 | 41.6 | 110000 | 54.6 | blank | none | 0 | MGR-101 | OWN-101 | 2024-05-16 | storm shutters,heat resistant paint |
| PROP-0008 | mixed-use | 89.2 | true | FL | Central Square | 101 Center St | Miami | 33130 | USA | 2009 | 19 | 195000.5 | 91 | 3.3 | 92.1 | 93.4 | 2200000 | 94.7 | 2024-02-05 | comprehensive | 21000000 | MGR-515 | OWN-701 | 2024-05-14 | elevated foundation,storm shutters,green roofs |
| PROP-0009 | retail | 51.9 | false | CA | The Galleria | 501 Market St | San Francisco | 94105 | USA | 1987 | 5 | 69000 | 26.8 | 18.2 | 44.4 | 51 | 290000 | 57.5 | blank | comprehensive | 8000000 | MGR-412 | OWN-910 | 2024-05-13 | storm shutters,solar panels |
| PROP-0010 | residential | 88.6 | true | FL | Willow Creek Estates | 3320 Willow Creek Dr | Orlando | 32801 | USA | 2005 | 7 | 85000 | 90.5 | 2.6 | 90 | 89.8 | 1800000 | 92.3 | 2024-03-29 | flood | 19000000 | MGR-610 | OWN-820 | 2024-05-20 | elevated foundation,flood barriers,storm shutters |
| PROP-0011 | industrial | 39.5 | true | TX | TechWorks Campus | 400 Technology Dr | Austin | 78758 | USA | 2015 | 2 | 155000 | 24.7 | 11.4 | 64.8 | 42 | 430000 | 74.3 | 2023-10-16 | comprehensive | 14000000 | MGR-425 | OWN-301 | 2024-05-10 | solar panels,heat resistant paint |
| PROP-0012 | office | 69.9 | true | FL | Bayfront Plaza | 202 Bayfront Ave | Tampa | 33602 | USA | 1996 | 10 | 99000 | 68.7 | 2.8 | 73.2 | 75.9 | 520000 | 83.4 | 2024-02-11 | comprehensive | 9500000 | MGR-305 | OWN-245 | 2024-05-19 | storm shutters,flood barriers,green roofs |
| PROP-0013 | retail | 36.7 | false | IL | Northridge Commons | 4800 North Ave | Chicago | 60625 | USA | 2000 | 4 | 70000 | 24.9 | 0 | 37.4 | 49.3 | 150000 | 56.2 | blank | comprehensive | 6000000 | MGR-215 | OWN-511 | 2024-05-22 | solar panels,storm shutters |
| PROP-0014 | residential | 60 | true | NJ | Atlantic Heights | 1200 Atlantic Ave | Jersey City | 07304 | USA | 1984 | 7 | 89000 | 52.1 | 0 | 40.9 | 61.5 | 370000 | 74.8 | 2024-03-15 | comprehensive | 8500000 | MGR-519 | OWN-601 | 2024-05-17 | storm shutters,flood barriers,drainage upgrade |
| PROP-0015 | retail | 29.3 | false | OR | Cedar Grove Mall | 200 Cedar Grove Rd | Portland | 97209 | USA | 1978 | 2 | 48000 | 5.4 | 18.9 | 23.6 | 39.7 | 90000 | 51.5 | blank | wildfire | 3800000 | MGR-101 | OWN-201 | 2024-05-21 | fire-resistant materials,drainage upgrade |
| PROP-0016 | office | 63.9 | true | GA | Skyline Offices | 888 Skyline Dr | Atlanta | 30303 | USA | 1974 | 15 | 98000 | 38.5 | 0 | 66 | 57.6 | 330000 | 70.3 | 2023-11-30 | comprehensive | 9000000 | MGR-510 | OWN-820 | 2024-05-12 | green roofs,storm shutters |
| PROP-0017 | industrial | 52.7 | false | CA | Redwood Industrial Park | 1600 Redwood Rd | San Jose | 95112 | USA | 2007 | 1 | 180000 | 23.6 | 34.1 | 49.8 | 44 | 370000 | 71.6 | blank | comprehensive | 11000000 | MGR-316 | OWN-511 | 2024-05-18 | solar panels,fire-resistant materials |
| PROP-0018 | mixed-use | 84.2 | true | TX | Horizon Plaza | 4100 Horizon St | Dallas | 75205 | USA | 2012 | 18 | 175000 | 75.5 | 11.8 | 86.2 | 79.4 | 1300000 | 89.1 | 2024-03-24 | comprehensive | 20000000 | MGR-425 | OWN-725 | 2024-05-21 | elevated foundation,green roofs,fire-resistant materials |
| PROP-0019 | residential | 59.8 | true | CO | Aspen Ridge Apartments | 125 Aspen Ridge Rd | Aspen | 81611 | USA | 1991 | 6 | 72000 | 11.5 | 56.2 | 48.4 | 30.9 | 340000 | 73 | 2024-03-11 | wildfire | 8700000 | MGR-102 | OWN-401 | 2024-05-19 | fire-resistant materials,solar panels |
| PROP-0020 | office | 41.2 | false | UT | Summit Business Center | 700 Summit Ave | Salt Lake City | 84101 | USA | 1994 | 11 | 87000 | 18.7 | 16.5 | 52.6 | 37.8 | 220000 | 63.9 | blank | other | 7000000 | MGR-305 | OWN-201 | 2024-05-15 | solar panels,storm shutters |
What the 50 rows show
from the 50-row sample- 52%adaptation_
plan_ exists = true - 54.9median physical_
risk_ score - 5insurance coverage types
- 12managers
- 14owners
- 8median number_
of_ floors
Median 54.9, from 29.3 to 89.2.
- string 12
- integer 2
- float 9
- date 2
- boolean 1
Columns
26 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
property_id | string | Unique identifier for the property or real estate assetunique | PROP-0001 |
property_name | string | Official name or designation of the property | Greenview Towers |
street_address | string | Street address of the property | 1050 Elm Street |
city | string | City where the property is located | Denver |
state | string | State or province where the property is located | CO |
postal_code | string | Postal or ZIP code of the property location | 80205 |
country | string | Country where the property is located | USA |
property_type | string | Type of property (e.g., office, residential, retail, industrial)6 values | residential |
mitigation_measures | string | Comma-separated list of mitigation measures implemented (e.g., flood barriers, fire-resistant materials, green roofs)optional | green roofs,solar panels |
insurance_coverage_type | string | Type of climate-related insurance coverage held (e.g., flood, wildfire, comprehensive, none)flood · wildfire · comprehensive · none · other · optional | comprehensive |
manager_id | string | Unique identifier for the property manager or management company12 managers · optional | MGR-102 |
owner_id | string | Unique identifier for the property owner or asset owneroptional | OWN-401 |
| Numbers 11 columns | |||
year_built | integer | Year the property was originally constructed1,800 to 2,100 · optional | 1998 |
number_of_floors | integer | Total number of floors in the property1 or more · optional | 12 |
total_floor_area_sqft | float | Total floor area of the property in square feet0 or more · optional | 95000.2 |
physical_risk_score | float | Composite score (0-100) representing the property's exposure to physical climate risks (e.g., flood, wildfire, heat, storm)0 to 100 | 62.4 |
flood_risk_score | float | Score (0-100) indicating the property's exposure to flood risk0 to 100 · optional | 15.2 |
wildfire_risk_score | float | Score (0-100) indicating the property's exposure to wildfire risk0 to 100 · optional | 28.9 |
heat_risk_score | float | Score (0-100) indicating the property's exposure to extreme heat events0 to 100 · optional | 55.6 |
storm_risk_score | float | Score (0-100) indicating the property's exposure to storm or wind risk0 to 100 · optional | 34.1 |
mitigation_investment_usd | float | Total amount (USD) invested in climate risk mitigation measures for the property0 or more · optional | 480000 |
adaptation_readiness_score | float | Score (0-100) reflecting the property's readiness and planning for climate adaptation0 to 100 | 80.5 |
insurance_coverage_amount_usd | float | Total amount of insurance coverage (USD) for climate-related risks0 or more · optional | 12000000 |
| Dates and times 2 columns | |||
last_adaptation_plan_update | date | Date when the adaptation plan was last updatedoptional | 2024-03-08 |
scorecard_date | date | Date when the climate resilience scorecard was completed or last updated | 2024-05-15 |
| True or false 1 column | |||
adaptation_plan_exists | boolean | Indicates if a formal climate adaptation plan exists for the property | true |
Use it for
A real estate dashboard
The adaptation_
plan_ exists rate, physical_ risk_ score by property_ type and a breakdown of state. Excel, Power BI or Tableau. Why do 26 of 50 rows have adaptation_
plan_ exists = true? A class exercise
Hand out the rows and one question. Everyone works from the same 50 rows.
- Properties50PROP-000162.4resident…PROP-000245.1officePROP-000453.2office
A software demo
Believable properties with property_
name, street_ address and city to fill a screen in front of a buyer.
This dataset50 rows26 columns
Yours1,000 rows26 columnsstreet_address: UK only
blueprint · property-climate-resilience-scorecard
Behind this dataset
Same schema. As many rows as you need.
These 50 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Each property must be scored across at least three climate hazard types (e.g., flood, heat, storm).
- Include both current resilience measures and planned adaptation investments.
- Scorecard must assign a weighted overall resilience score (0-100).
- Include binary flags for compliance with relevant local climate adaptation codes.
- All mitigation actions must be matched to documented risk factors.
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- property-climate-resilience-scorecard