Real Estate
27 columns
120 rows
8 formats

Commercial Building Energy Benchmarking

This dataset provides comprehensive monthly tracking of energy and water usage, efficiency upgrades, and sustainability ratings for commercial property portfolios. It enables property managers and ESG consultants to benchmark building performance, identify opportunities for efficiency improvements, and report on climate impact across real estate assets. The dataset supports actionable insights for sustainability reporting, regulatory compliance, and investment-grade ESG analysis.

last updated 24 Jan 2026
by GoMask

The brief that made it

Benchmarking energy and water usage across commercial property portfolios

Sample rows

preview · 8 of 120 rows · all 27 columns

building_idstring	building_typestring	water_consumption_galfloat	upgrade_typestring	portfolio_idstring	building_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	floor_area_sqftfloat	year_builtinteger	energy_record_idstring	record_monthdate	energy_consumption_kwhfloat	energy_cost_usdfloat	carbon_emissions_kgco2efloat	efficiency_upgrade_idstring	upgrade_datedate	upgrade_cost_usdfloat	sustainability_rating_systemstring	sustainability_rating_scorefloat	sustainability_rating_levelstring	rating_awarded_datedate	property_managerstring	upgrade_descriptionstring
B001	office	91821.8	hvac	P101	Westfield Plaza	123 Market Street	New York	NY	10001	USA	275412.5	1982	B001-2022-11	2022-11-01	312532.7	38400.1	80912.7	U101	2021-10-10	312000	LEED	86.5	Gold	2022-02-15	Metro Property Solutions	Upgraded HVAC system to high efficiency units.
B002	office	120987.1	lighting	P102	Aurora Center	650 S Main Ave	Chicago	IL	60607	USA	430231.9	2003	B002-2022-11	2022-11-01	442133.2	67512.9	110921.9	U102	2022-05-01	87000	LEED	91.8	Platinum	2022-10-15	UrbanEdge Management Co.	Installed LED lighting across all floors.
B003	retail	17000.5	lighting	P103	Fulton Retail Park	980 W Fulton Rd	Phoenix	AZ	85001	USA	83421.9	1988	B003-2022-11	2022-11-01	63100.4	11200	14532.8	U103	2022-02-12	26500	ENERGY STAR	68.7	Certified	2022-04-15	Sunbelt Retail Group	Replaced parking lot lighting with LEDs.
B004	office	112447.1	blank	P101	Grand Tower	2121 Wilshire Blvd	Los Angeles	CA	90025	USA	315920.3	1997	B004-2022-11	2022-11-01	367211.4	50122.8	99512.4	blank	blank	blank	LEED	77.2	Silver	2022-08-12	Wilshire Management Inc.	blank
B005	warehouse	6900.7	insulation	P104	Blue Ridge Warehouse	470 Industrial Park Dr	Fargo	ND	58102	USA	124000	1999	B005-2022-11	2022-11-01	110022.3	15500	31700.9	U104	2022-01-22	47000	LEED	47.3	Pass	2022-06-01	Northern Logistic Partners	Installed new insulation in roof panels.
B006	office	23210.2	blank	P105	blank	8000 Lakeside Ave	Atlanta	GA	30339	USA	141210.6	2016	B006-2022-11	2022-11-01	123900.9	18412.8	30110	blank	blank	blank	ENERGY STAR	80.1	Silver	2022-10-01	Lakeside Corporate LLC	blank
B007	mixed-use	211923.2	renewables	P105	Vista Heights	1200 Sunset Blvd	Los Angeles	CA	90026	USA	350021.1	2011	B007-2022-11	2022-11-01	288932.2	59800.2	122301.4	U105	2021-09-01	185000	LEED	93.2	Platinum	2022-04-03	Sunset Property Group	Installed rooftop solar panels.
B008	retail	24110.5	blank	P106	Maple Retail Hub	4300 Greenwood Ave	Denver	CO	80202	USA	142900	2019	B008-2022-11	2022-11-01	113123.8	18800	22110.7	blank	blank	blank	Green Globes	74.4	Very Good	2022-11-01	Maple Property Group	blank
B009	hotel	111231.1	windows	P107	Starlight Hotel	22 Park Lane	London	ENG	W1K1QA	UK	182300.2	2009	B009-2022-11	2022-11-01	143211.9	29600.3	60123.5	U106	2022-02-11	72000	BREEAM	81.9	Excellent	2022-09-01	Park Lane Hospitality	Replaced windows with triple glazing.
B010	mixed-use	94300.2	blank	P108	blank	2010 Pine Street	Toronto	BC	M4B1B3	Canada	190000	2018	B010-2022-11	2022-11-01	148000	31700	57001.1	blank	blank	blank	LEED	87	Gold	2022-10-01	Pinecrest Management	blank
B011	warehouse	2000	blank	P109	Pacific Storage Depot	800 Alaska Ave	Anchorage	AK	99501	USA	21000	1995	B011-2022-11	2022-11-01	18001.2	2100	4100	blank	blank	blank	Other	22.1	Pass	2022-08-01	Alaska Storage Group	blank
B012	retail	11000.1	blank	P110	Peachtree Plaza	234 Peachtree Lane	Atlanta	GA	30303	USA	57000	1992	B012-2022-11	2022-11-01	49200.7	8800.9	7000.4	blank	blank	blank	ENERGY STAR	73.2	Certified	2022-11-01	Peachtree Retail LLC	blank
B013	office	140110.9	controls	P111	Emerald Tower	700 1st Ave	Seattle	WA	98101	USA	420000	1979	B013-2022-11	2022-11-01	491010.1	72000	126120.9	U107	2021-12-01	128000	LEED	90.2	Gold	2022-09-01	Emerald Real Estate	Installed automated building controls.
B014	office	29000	blank	P101	blank	150 Elm Street	Boston	MA	02110	USA	99500	2010	B014-2022-11	2022-11-01	107000	14000	17000.3	blank	blank	blank	ENERGY STAR	69.8	Silver	2022-09-01	Elm Property Advisors	blank
B015	retail	26100	blank	P112	Sunrise Mall	350 Sunrise Blvd	Denver	CO	80203	USA	148000	2020	B015-2022-11	2022-11-01	122000	19800	22700	blank	blank	blank	Green Globes	76.5	Very Good	2022-10-01	Sunrise Retail Partners	blank
B016	hotel	149000	insulation	P113	Sapphire Hotel	9 Sheikh Zayed Rd	Dubai	DXB	00000	UAE	210000	2001	B016-2022-11	2022-11-01	172000.1	34500	80120	U108	2022-03-01	210000	LEED	88.2	Gold	2022-08-01	Sapphire Hospitality Group	Added advanced insulation to all guest room walls.
B017	warehouse	9000	blank	P114	Harbor Warehouse	2500 Port Road	Seattle	WA	98109	USA	185000	2012	B017-2022-11	2022-11-01	139000	21500	40100	blank	blank	blank	Other	31.2	Good	2022-09-01	Harbor Storage Partners	blank
B018	office	81100	lighting	P115	Greenwood Offices	1260 5th Ave	New York	NY	10021	USA	212500	1986	B018-2022-11	2022-11-01	237100	29200	61200	U109	2022-04-01	62000	LEED	82.1	Gold	2022-09-01	Greenwood Management	LED lighting retrofit throughout the building.
B019	office	18900	blank	P116	blank	5000 Broad Street	Philadelphia	PA	19103	USA	124500	2017	B019-2022-11	2022-11-01	109800	16400	17200	blank	blank	blank	blank	blank	blank	blank	Broad Street Properties	blank
B020	hotel	215000	windows	P117	Oceanview Hotel	100 Seaside Ave	Miami	FL	33139	USA	320000	1995	B020-2022-11	2022-11-01	253200	48500	110200	U110	2022-01-15	195000	LEED	85.6	Gold	2022-07-01	Oceanview Hospitality	Installed hurricane-resistant energy windows.

What the 120 rows show

from the 120-row sample

Mixed-use (building type) stands out: mean water_consumption_gal is 186,105, against 69,422 for the rest.

62,116median water_consumption_gal
4address countries
5sustainability rating systems
9sustainability rating levels
24address states
29address cities

Mean water_consumption_gal by building_type120 rows

water_consumption_gal120 rows, in bands of 50k

Median 62,116, from 0.0 to 420,128.

upgrade_type58 rows with a value · 62 left blank

lighting15
hvac11
controls10
insulation9
windows8
renewables5

27 columns by typefrom the column list below

string 16
integer 1
float 7
date 3

Columns

27 columns in three groups

blueprint · 27 columns
column	type	description	example
Text 16 columns
`building_id`	string	Unique identifier for the commercial buildingunique	B001
`portfolio_id`	string	Identifier for the property portfolio to which the building belongs	P101
`building_name`	string	Name of the commercial buildingoptional	Westfield Plaza
`address_street`	string	Street address of the building	123 Market Street
`address_city`	string	City where the building is located	New York
`address_state`	string	State or province where the building is located	NY
`address_postal_code`	string	Postal code of the building's location	10001
`address_country`	string	Country where the building is located4 countries	USA
`building_type`	string	Type of commercial building (e.g., office, retail, warehouse, hotel)6 values	office
`energy_record_id`	string	Unique identifier for the monthly energy usage recordunique	B001-2022-11
`efficiency_upgrade_id`	string	Unique identifier for the efficiency upgrade eventunique · optional	U101
`upgrade_type`	string	Type of efficiency upgrade (e.g., lighting, HVAC, insulation, controls)7 values · optional	hvac
`upgrade_description`	string	Detailed description of the efficiency upgradeoptional	Upgraded HVAC system to h…
`sustainability_rating_system`	string	Name of the sustainability rating system (e.g., ENERGY STAR, LEED, BREEAM)ENERGY STAR · LEED · BREEAM · Green Globes · Other · optional	LEED
`sustainability_rating_level`	string	Level or certification achieved (e.g., Gold, Silver, Platinum, Certified)10 values · optional	Gold
`property_manager`	string	Name of the property manager or management companyoptional	Metro Property Solutions
Numbers 8 columns
`floor_area_sqft`	float	Total floor area of the building in square feet0 or more	275412.5
`year_built`	integer	Year the building was constructed1,800 to 2,100 · optional	1982
`energy_consumption_kwh`	float	Total energy consumed during the month (in kilowatt-hours)0 or more	312532.7
`energy_cost_usd`	float	Total cost of energy for the month in USD0 or more · optional	38400.1
`water_consumption_gal`	float	Total water consumed during the month (in gallons)0 or more · optional	91821.8
`carbon_emissions_kgco2e`	float	Estimated carbon emissions for the month (in kg CO2 equivalent)0 or more · optional	80912.7
`upgrade_cost_usd`	float	Cost of the efficiency upgrade in USD0 or more · optional	312000
`sustainability_rating_score`	float	Score or rating achieved under the sustainability rating system0 or more · optional	86.5
Dates and times 3 columns
`record_month`	date	The first day of the month for which energy data is recorded	2022-11-01
`upgrade_date`	date	Date the efficiency upgrade was implementedoptional	2021-10-10
`rating_awarded_date`	date	Date the sustainability rating was awardedoptional	2022-02-15

Use it for

A real estate dashboard
Water_consumption_gal by building_type and a breakdown of upgrade_type. Excel, Power BI or Tableau.
Why do the 12 mixed-use rows have a mean water_consumption_gal of 186,105?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Buildings120
B00191821.8office
B002120987.1office
B00317000.5retail
A software demo
Believable buildings with portfolio_id, building_name and address_street to fill a screen in front of a buyer.

This dataset120 rows27 columns

Yours10,000 rows27 columnsaddress_street: UK only

blueprint · commercial-building-energy-benchmarking

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 27 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 one building per month.
Include energy consumption segmented by source (electricity, gas, renewables).
Log efficiency improvement actions (e.g., HVAC upgrade, insulation).
Assign a sustainability score based on usage and upgrades.
Capture occupancy rate for contextual benchmarking.
Exclude properties with incomplete utility data.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

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: commercial-building-energy-benchmarking

What should your data show?

No signup. No card.

Sample rows

What the 120 rows show

Columns

Use it for

A real estate dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Real Estate

What should your data show?