Real Estate Retrofit Tracking
This dataset provides granular tracking of energy retrofit projects across real estate assets, including project types, costs, progress, and measured efficiency gains. It enables facilities managers and property owners to monitor sustainability initiatives, quantify ESG impact, and optimize future retrofit investments. The structured format supports detailed analysis and reporting for compliance and strategic planning.
Sample rows
preview · 8 of 75 rows · all 22 columns| retrofit_idstring | retrofit_typestring | total_costfloat | esg_reporting_includedboolean | address_statestring | property_idstring | property_namestring | address_streetstring | address_citystring | address_postal_codestring | address_countrystring | start_datedate | end_datedate | progress_statusstring | currencystring | estimated_annual_energy_savings_kwhfloat | estimated_annual_cost_savingsfloat | pre_retrofit_energy_consumption_kwhfloat | post_retrofit_energy_consumption_kwhfloat | facility_managerstring | property_ownerstring | retrofit_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RF-1001 | hvac | 85000.5 | true | CA | P-2001 | Sunset Plaza | 800 Sunset Blvd | Los Angeles | 90046 | USA | 2022-01-10 | 2022-05-03 | completed | USD | 26000.5 | 14000 | 120000 | 94000 | Maria Lopez | Sunset Real Estate LLC | Upgraded central HVAC to high efficiency units. |
| RF-1002 | lighting | 34000 | true | TX | P-2002 | Greenview Corporate Center | 145 Greenview Rd | Austin | 78701 | USA | 2022-03-14 | 2022-04-20 | completed | USD | 15600.75 | 4800 | 62000 | 46400 | James Carter | Greenview Holdings | Replaced all fluorescent lighting with LED fixtures. |
| RF-1003 | windows | 23000 | true | ON | P-2003 | Maple Residence | 12 Maple St | Toronto | M5J 2N8 | CAN | 2023-02-01 | 2023-03-15 | completed | CAD | 4100 | 980 | 22000 | 17900 | Sophie Tremblay | Maple Living Inc. | Installed triple-glazed windows. |
| RF-1004 | insulation | 19000 | true | IL | P-2004 | Riverside Lofts | 30 Riverside Dr | Chicago | 60601 | USA | 2022-10-15 | 2022-12-12 | completed | USD | 5200 | 1100 | 31500 | 26300 | Kimberly Drew | Riverside Properties LLC | Installed spray foam insulation in attics. |
| RF-1005 | solar | 97000 | true | NY | P-2005 | Parkside Towers | 88 Parkside Ave | New York | 10013 | USA | 2023-05-12 | 2023-06-28 | completed | USD | 18500 | 5200 | 85000 | 66500 | Edward Han | Parkside Holdings | Installed rooftop solar PV system. |
| RF-1006 | water_heating | 42000 | true | FL | P-2006 | Oceanview Estates | 220 Oceanview Dr | Miami | 33139 | USA | 2022-09-05 | 2022-11-10 | completed | USD | 7500 | 1900 | 39000 | 31500 | Liam Nash | Oceanview Residential | Upgraded water heaters to solar thermal units. |
| RF-1007 | other | 27000 | true | OR | P-2007 | Cedar Hill Business Park | 60 Cedar Hill Rd | Portland | 97201 | USA | 2023-04-02 | 2023-06-01 | completed | USD | 3800 | 940 | 18300 | 14500 | Chris Jordan | Cedar Hill Group | Installed demand-controlled ventilation in office spaces. |
| RF-1008 | lighting | 14000 | false | MN | P-2008 | Lakeside Apartments | 210 Lakeside Cir | Minneapolis | 55401 | USA | 2023-01-10 | 2023-02-15 | completed | USD | 4100 | 1400 | 16000 | 11900 | Jenna Fox | Lakeside Properties | Retrofit of all hallway lighting to LED. |
| RF-1009 | insulation | 21000 | true | ENG | P-2009 | Willow Court | 99 Willow St | London | EC1A 7AJ | UK | 2022-06-18 | 2022-07-30 | completed | GBP | 2700 | 650 | 14500 | 11800 | Oliver Smith | Willow Estates | Installed cavity wall insulation. |
| RF-1010 | hvac | 61000 | false | CO | P-2010 | Summit Offices | 100 Summit Blvd | Denver | 80202 | USA | 2023-07-05 | blank | in_progress | USD | blank | blank | 53000 | blank | Kevin Lee | Summit Real Estate | Replaced rooftop chillers with variable speed units. |
| RF-1011 | solar | 32000 | true | BC | P-2011 | Pine Grove Retail | 18 Pine Grove Ave | Vancouver | V6H 1B2 | CAN | 2022-08-20 | 2022-09-30 | completed | CAD | 3900 | 890 | 15400 | 11500 | Emily Wong | Pine Grove Inc. | Installed solar panels for parking lot lighting. |
| RF-1012 | windows | 28000 | false | CA | P-2012 | Highland Terraces | 47 Highland Rd | San Francisco | 94110 | USA | 2023-03-18 | 2023-05-01 | completed | USD | 5100 | 1300 | 22000 | 16900 | Rachel Kim | Highland Investments | Replaced old windows with double-pane glass. |
| RF-1013 | hvac | 35000 | true | OR | P-2007 | Cedar Hill Business Park | 60 Cedar Hill Rd | Portland | 97201 | USA | 2022-11-01 | 2023-01-25 | completed | USD | 5400 | 1230 | 29800 | 24400 | Chris Jordan | Cedar Hill Group | Installed new heat recovery ventilators. |
| RF-1014 | lighting | 11500 | false | MA | P-2013 | Eastside Offices | 234 Eastside St | Boston | 02108 | USA | 2023-04-07 | 2023-04-29 | completed | USD | 2600 | 700 | 8700 | 6100 | Veronica Allen | Eastside Investments | Replaced lighting in conference rooms with smart LED. |
| RF-1015 | other | 42000 | true | WA | P-2014 | Lakeview Business Center | 89 Lakeview Dr | Seattle | 98101 | USA | 2023-02-20 | 2023-04-15 | completed | USD | 4300 | 1080 | 19000 | 14700 | Jason Miller | Lakeview Partners | Installed building automation system for HVAC. |
| RF-1016 | water_heating | 27000 | false | CA | P-2015 | Redwood Tower | 300 Redwood St | San Jose | 95110 | USA | 2022-05-15 | 2022-08-11 | completed | USD | 3100 | 700 | 12200 | 9500 | Marc Chen | Redwood Properties | Replaced old boilers with high-efficiency units. |
| RF-1017 | windows | 19500 | true | PA | P-2016 | Liberty Center | 45 Liberty Rd | Philadelphia | 19103 | USA | 2023-06-10 | 2023-07-25 | completed | USD | 3200 | 820 | 13700 | 10500 | Daniel Evans | Liberty Management | Installed low-emissivity glass in windows. |
| RF-1018 | insulation | 15800 | false | TX | P-2017 | Hilltop Residences | 77 Hilltop Ln | Dallas | 75201 | USA | 2022-04-18 | 2022-06-05 | completed | USD | 2100 | 490 | 8100 | 6200 | Sarah Patel | Hilltop Living | Insulated crawl spaces throughout property. |
| RF-1019 | hvac | 57000 | true | GA | P-2018 | Oakridge Plaza | 110 Oakridge Ave | Atlanta | 30303 | USA | 2023-05-23 | 2023-08-05 | in_progress | USD | blank | blank | 41000 | blank | Anthony Gomez | Oakridge Properties | Installed rooftop VRF system. |
| RF-1020 | lighting | 19500 | true | CA | P-2019 | Golden Gate Offices | 280 Golden Gate Ave | San Francisco | 94102 | USA | 2023-02-12 | 2023-03-10 | completed | USD | 5100 | 1450 | 21700 | 16600 | Grace Lin | Golden Gate Holdings | Upgrade to motion sensor LED lighting. |
What the 75 rows show
from the 75-row sampleSolar (retrofit type) stands out: mean total_
- 83%esg_
reporting_ included = true - 21,000median total_
cost - 2progress statuses
- 4currencies
- 6address countries
- 3,550median estimated_
annual_ energy_ savings_ kwh
Median 21,000, from 5,201 to 185,000.
- string 14
- float 5
- date 2
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
retrofit_id | string | Unique identifier for each retrofit project or action.unique | RF-1001 |
property_id | string | Unique identifier for the property where the retrofit is performed. | P-2001 |
property_name | string | Name or label of the property. | Sunset Plaza |
address_street | string | Street address of the property. | 800 Sunset Blvd |
address_city | string | City where the property is located. | Los Angeles |
address_state | string | State or region of the property. | CA |
address_postal_code | string | Postal or ZIP code of the property. | 90046 |
address_country | string | Country where the property is located.6 countries | USA |
retrofit_type | string | Type of retrofit performed (e.g., insulation, HVAC upgrade, lighting replacement).7 values | hvac |
retrofit_description | string | Detailed description of the retrofit action.optional | Upgraded central HVAC to … |
progress_status | string | Current status of the retrofit project.planned · in_progress · completed · on_hold · cancelled | completed |
currency | string | Currency code for the cost (e.g., USD, EUR, GBP).4 currencies | USD |
facility_manager | string | Name of the facility manager responsible for the retrofit.optional | Maria Lopez |
property_owner | string | Name of the property owner.optional | Sunset Real Estate LLC |
| Numbers 5 columns | |||
total_cost | float | Total cost of the retrofit project in local currency.0 or more | 85000.5 |
estimated_annual_energy_savings_kwh | float | Estimated annual energy savings resulting from the retrofit (in kWh).0 or more · optional | 26000.5 |
estimated_annual_cost_savings | float | Estimated annual cost savings resulting from the retrofit (in local currency).0 or more · optional | 14000 |
pre_retrofit_energy_consumption_kwh | float | Measured annual energy consumption before retrofit (in kWh).0 or more · optional | 120000 |
post_retrofit_energy_consumption_kwh | float | Measured annual energy consumption after retrofit (in kWh).0 or more · optional | 94000 |
| Dates and times 2 columns | |||
start_date | date | Date when the retrofit project started. | 2022-01-10 |
end_date | date | Date when the retrofit project was completed.optional | 2022-05-03 |
| True or false 1 column | |||
esg_reporting_included | boolean | Indicates if this retrofit is included in ESG reporting. | true |
Use it for
A real estate dashboard
The esg_
reporting_ included rate, total_ cost by retrofit_ type and a breakdown of address_ state. Excel, Power BI or Tableau. Why do the 10 solar rows have a mean total_
cost of 58,290? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Retrofits75RF-100185000.5hvacRF-100234000lightingRF-100814000lighting
A software demo
Believable retrofits with property_
id, property_ name and address_ street to fill a screen in front of a buyer.
blueprint · real-estate-retrofit-tracking
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 22 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.
- Each property entry must include a unique identifier
- Retrofit projects must record start and projected end dates
- Energy efficiency improvement measured as percentage reduction in consumption
- At least one cost and one sustainability rating per retrofit
- Categorize retrofits by type (HVAC, insulation, lighting, etc.)
- Status field required (planned, in-progress, completed)
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- real-estate-retrofit-tracking