Real Estate Energy Benchmark Log

This dataset provides a comprehensive log of real estate properties' energy usage, efficiency upgrades, and compliance status, enabling agencies to benchmark performance, identify high-consumption outliers, and prioritize retrofit actions. It supports sustainability initiatives and ESG reporting, making it ideal for operational tracking and strategic planning in real estate portfolios.

  • last updated 23 Dec 2025
  • by GoMask
The brief that made it

Benchmarking energy consumption across property portfolios

Sample rows

preview · 8 of 65 rows · all 25 columns
property_idstringproperty_typestringenergy_consumption_kwhfloatis_high_consumption_outlierbooleanefficiency_upgrade_typestringagency_idstringproperty_namestringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringyear_builtintegerfloor_area_sqftfloatenergy_consumption_period_startdateenergy_consumption_period_enddateenergy_intensity_kwh_per_sqftfloatefficiency_upgrade_datedateefficiency_upgrade_cost_usdfloatcompliance_statusstringcompliance_last_checkeddateesg_certification_typestringesg_certification_datedateretrofit_priority_scorefloatnotesstring
PROP001office1450000.5falseLED lightingAGENCY_AHarbor View Tower101 Main StSan FranciscoCA94105USA19871200002023-01-012023-12-3112.082022-09-1575000compliant2024-01-05LEED2023-03-1534.7Major upgrade in 2022, performance improved.
PROP002retail340000.2falseblankAGENCY_BSunrise Retail202 Market AveAustinTX78701USA1995260002023-04-012024-03-3113.08blankblankpending2024-04-02blankblank41.2Compliance review scheduled.
PROP003residential670000falseHVAC upgradeAGENCY_CLakeside Residences303 Willow LaneMadisonWI53703USA2004520002023-05-012024-04-3012.882023-06-1048000.5compliant2024-05-02ENERGY STAR2023-08-0129.8HVAC upgrade reduced usage.
PROP004industrial3000000trueInsulationAGENCY_DGreenfield Industrial404 Commerce RdColumbusOH43215USA19782000002023-07-012024-06-30152023-07-20120000non-compliant2024-07-02blankblank89.4High usage, insulation recently added.
PROP005office1200000falseLED lightingAGENCY_AParkside Offices505 Park BlvdDenverCO80202USA1982950002023-02-012023-12-3112.632022-11-3060000compliant2024-02-02LEED2023-04-1532.5Lighting upgrade completed.
PROP006mixed-use550000falseHVAC upgradeAGENCY_BBroadway Plaza606 Broadway StNew YorkNY10012USA2012450002023-03-012024-02-2912.222023-02-1532000compliant2024-03-02ENERGY STAR2023-05-1030.1Mixed-use property, recent HVAC upgrade.
PROP007residential480000falseInsulationAGENCY_CCedar Heights707 Cedar DrSeattleWA98101USA2018380002023-11-012024-10-3112.632023-12-0127000compliant2024-11-02blankblank31.4New insulation added.
PROP008industrial3200000trueInsulationAGENCY_DRiverfront Industrial808 River RdSt LouisMO63101USA19651900002023-08-012024-07-3116.842023-09-15100000non-compliant2024-08-02blankblank93.2High usage, urgent retrofit needed.

What the 65 rows show

from the 65-row sample

Industrial (property type) stands out: mean energy_consumption_kwh is 2,518,992, against 602,393 for the rest.

  • 32%is_high_consumption_outlier = true
  • 600,000median energy_consumption_kwh
  • 2esg certification types
  • 3compliance statuses
  • 14agencies
  • 37,451median floor_area_sqft
Mean energy_consumption_kwh by property_type65 rows
02M4M1.2Moffice14 rows380.2kretail14 rows325.7kresid…17 rows2.5Mindus…13 rows583kmixed…6 rows509.4kother1 rows
energy_consumption_kwh65 rows, in bands of 500k
01530241811305402M3.5Menergy_consumption_kwh →

Median 600,000, from 65,500 to 3,400,000.

efficiency_upgrade_type56 rows with a value · 9 left blank
  1. LED lighting21
  2. HVAC upgrade17
  3. Insulation9
  4. insulation5
  5. window insulation4
25 columns by typefrom the column list below
  • string 13
  • integer 1
  • float 5
  • date 5
  • boolean 1

Columns

25 columns in four groups
blueprint · 25 columns
columntypedescriptionexample
Text 13 columns
property_idstringUnique identifier for the property.uniquePROP001
agency_idstringUnique identifier for the real estate agency managing the property.AGENCY_A
property_namestringName or label of the property.optionalHarbor View Tower
address_streetstringStreet address of the property.101 Main St
address_citystringCity where the property is located.San Francisco
address_statestringState or region where the property is located.CA
address_postal_codestringPostal code of the property.94105
address_countrystringCountry where the property is located.USA
property_typestringType of property (e.g., office, retail, residential, industrial).6 valuesoffice
efficiency_upgrade_typestringType of energy efficiency upgrade performed (e.g., LED lighting, insulation, HVAC upgrade).5 types · optionalLED lighting
compliance_statusstringCurrent compliance status with local energy or ESG regulations.compliant · non-compliant · pending · exemptcompliant
esg_certification_typestringType of ESG or sustainability certification held by the property (e.g., LEED, ENERGY STAR).2 types · optionalLEED
notesstringAdditional notes or comments about the property, upgrades, or compliance.optionalNew insulation added.
Numbers 6 columns
year_builtintegerYear the property was built.1,800 to 2,100 · optional1987
floor_area_sqftfloatTotal floor area of the property in square feet.0 or more120000
energy_consumption_kwhfloatTotal energy consumption (kWh) for the reporting period.0 or more1450000.5
energy_intensity_kwh_per_sqftfloatEnergy intensity, calculated as kWh per square foot for the reporting period.0 or more · optional12.08
efficiency_upgrade_cost_usdfloatCost of the most recent efficiency upgrade in USD.0 or more · optional75000
retrofit_priority_scorefloatPriority score for retrofitting actions based on energy consumption and compliance (higher = higher priority).0 to 100 · optional34.7
Dates and times 5 columns
energy_consumption_period_startdateStart date of the energy consumption reporting period.2023-01-01
energy_consumption_period_enddateEnd date of the energy consumption reporting period.2023-12-31
efficiency_upgrade_datedateDate when the most recent efficiency upgrade was completed.optional2022-09-15
compliance_last_checkeddateDate when compliance status was last verified.optional2024-01-05
esg_certification_datedateDate when the property received its ESG certification.optional2023-03-15
True or false 1 column
is_high_consumption_outlierbooleanFlag indicating if the property is a high energy consumption outlier compared to similar properties.optionalfalse

Use it for

  • is high consum…32%21 of 65 rowsmean energy consumpti…1.2Moffi…380.2kreta…325.7kresi…2.5Mindu…

    A real estate dashboard

    The is_high_consumption_outlier rate, energy_consumption_kwh by property_type and a breakdown of efficiency_upgrade_type. Excel, Power BI or Tableau.

  • Why do the 13 industrial rows have a mean energy_consumption_kwh of 2,518,992?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable properties with agency_id, property_name and address_street to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset65 rows25 columns
Yours1,000 rows25 columnsaddress_street: UK only

blueprint · real-estate-energy-benchmark-log

Behind this dataset

Same schema. As many rows as you need.

These 65 rows came out of a blueprint — 25 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 row represents a unique property under management.
  • Include monthly energy usage (kWh), energy efficiency rating, and compliance status.
  • Record details of recent upgrades (insulation, smart meters, etc.) and the date performed.
  • Flag properties not meeting local ESG/energy compliance standards.
  • Capture building type (residential/commercial) and square footage.
Rows
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
real-estate-energy-benchmark-log

More in Real Estate

Browse all
Also in Real EstateGreen Retrofit Impact MetricsOpen House Visitor Feedback DatasetGreen Building Certification RecordsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.