Energy
21 columns
120 rows
8 formats

Municipal Building Energy Optimization Metrics

This dataset provides comprehensive, sensor-based energy usage metrics for municipal buildings, including consumption, cost, carbon emissions, and optimization actions. It enables local governments and property managers to benchmark performance, identify savings opportunities, and monitor sustainability compliance, supporting smart city and energy efficiency initiatives.

last updated 25 Jan 2026
by GoMask

The brief that made it

Benchmarking energy performance across public buildings

Sample rows

preview · 8 of 120 rows · all 21 columns

building_idstring	building_typestring	occupancyinteger	compliance_certificationstring	building_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	year_builtinteger	floor_area_sqftfloat	energy_meter_idstring	energy_typestring	measurement_datetimedatetime	energy_consumptionfloat	energy_costfloat	carbon_emissions_kgfloat	sensor_statusstring	last_optimization_datedate	optimization_actionstring
BLDG-0001	school	1120	LEED Gold	Lincoln High School North	1520 Elmwood Ave	Springfield	IL	62704	USA	2016	165324.7	EM-001-A	electricity	2024-04-20T13:10:00	33924.2	4207.8	5785.4	active	2023-06-12	HVAC retrofit
BLDG-0002	library	87	ENERGY STAR	Jefferson Municipal Library	880 Oak Street	Riverton	CA	95670	USA	2019	41420	EM-002-B	electricity	2024-04-08T15:40:00	8322.5	910.3	1102.2	active	2023-11-04	lighting upgrade
BLDG-0003	office	278	National Register	City Office Tower West	3401 Main Blvd	Fairview	TX	75069	USA	1927	75620.5	EM-003-C	electricity	2024-05-01T09:20:00	11237.3	1683.5	1843.7	active	2021-03-18	insulation improvement
BLDG-0004	recreation center	234	LEED Platinum	Madison Recreation Center	512 West Lake Dr	Madison	WI	53703	USA	2022	65190.4	EM-004-D	water	2024-03-14T11:50:00	46328	1697.6	0	active	2023-01-19	low-flow fixtures
BLDG-0005	other	0	blank	Franklin Utility Annex	127 Industrial Way	Franklin	MA	02038	USA	1982	1650	EM-005-E	steam	2024-03-29T16:30:00	0	0	0	inactive	blank	blank
BLDG-0006	school	989	LEED Silver	Washington Elementary West	2242 Grant Rd	Salem	OR	97302	USA	2004	112430.6	EM-006-F	natural gas	2024-04-17T10:05:00	23980.8	2266.2	4426.9	active	2022-12-16	geothermal HVAC
BLDG-0007	office	62	blank	Roosevelt City Hall	113 Center St	Roosevelt	UT	84066	USA	1942	32100.5	EM-007-G	electricity	2024-04-03T14:15:00	2216	367.9	246.5	maintenance	2021-02-04	lighting upgrade
BLDG-0008	recreation center	144	ENERGY STAR	Civic Community Center	401 South Broad St	Civic	PA	19147	USA	2015	42780	EM-008-H	electricity	2024-04-26T12:25:00	8419.2	1792.1	651.4	active	2022-05-11	window upgrade
BLDG-0009	library	60	blank	Downtown Branch Library	600 East Park Ave	Columbus	OH	43215	USA	1972	38000	EM-009-I	natural gas	2024-03-16T15:40:00	6692.5	1120.4	811.8	active	blank	blank
BLDG-0010	recreation center	302	LEED Platinum	Westside Field House	901 River Road	Westfield	NJ	07090	USA	2021	84300	EM-010-J	water	2024-03-20T13:35:00	146002.1	3908.8	0	active	2022-07-08	low-flow fixtures
BLDG-0011	other	12	blank	Eastside Operations Depot	77 Depot Lane	Eastvale	FL	32004	USA	1967	12840	EM-011-K	steam	2024-05-02T10:20:00	7817	932.2	2520.1	error	blank	blank
BLDG-0012	school	1052	LEED Gold	Martin Middle School	2101 Pinecrest Rd	Greenville	NC	27834	USA	2013	120338	EM-012-L	electricity	2024-04-14T14:10:00	29940.1	3912.6	6512.8	active	2023-08-18	solar installation
BLDG-0013	office	310	National Register	Central Government Offices	500 Capitol Ave	Frankfort	KY	40601	USA	1800	118600	EM-013-M	electricity	2024-05-04T13:00:00	14602.7	2104.2	1682.5	maintenance	2020-04-24	insulation improvement
BLDG-0014	library	39	blank	Jackson Community Library	1840 Maple St	Jackson	MS	39201	USA	1987	30644.5	EM-014-N	water	2024-04-19T10:18:00	2124.1	206.3	0	active	blank	blank
BLDG-0015	recreation center	88	ENERGY STAR	Bayview Rec Center	317 Beachside Ave	Bayview	WA	98225	USA	2017	52345	EM-015-O	electricity	2024-05-02T16:50:00	4167	1012	320.1	active	2023-04-03	high-efficiency HVAC
BLDG-0016	school	836	LEED Gold	Harrison Elementary School	1461 Harrison St	Harrison	AR	72601	USA	2007	93424.5	EM-016-P	natural gas	2024-05-05T09:46:00	17680.4	1852.2	3820.2	active	2023-06-02	geothermal HVAC
BLDG-0017	other	0	blank	Municipal Garage East	210 Industrial Dr	Lakeside	MN	55408	USA	1979	950	EM-017-Q	water	2024-04-25T10:09:00	0	0	0	inactive	blank	blank
BLDG-0018	office	48	blank	Adams Government Annex	155 South Church St	Adams	OH	45601	USA	1955	21850.9	EM-018-R	electricity	2024-05-06T13:30:00	1888.1	256.1	153.3	active	2020-09-08	lighting upgrade
BLDG-0019	library	98	LEED Silver	Riverbend Public Library	1900 Riverbend Ave	Riverbend	MO	64110	USA	2014	43410	EM-019-S	electricity	2024-03-23T12:40:00	9012.7	1181.9	1240.4	active	2023-02-11	roof insulation
BLDG-0020	other	6	blank	South District Utility Plant	880 Utility Rd	Southport	SC	29902	USA	2010	12000	EM-020-T	steam	2024-04-21T08:18:00	1927.7	220.6	850	error	blank	blank

What the 120 rows show

from the 120-row sample

School (building type) stands out: mean occupancy is 960.2, against 80.9 for the rest.

98median occupancy
4sensor statuses
5energy types
9optimization actions
42,890median floor_area_sqft
6,236median energy_consumption

Mean occupancy by building_type120 rows

occupancy120 rows, in bands of 200

Median 98, from 0 to 1,400.

compliance_certification70 rows with a value · 50 left blank

ENERGY STAR20
LEED Silver19
LEED Platinum16
LEED Gold11
National Register4

21 columns by typefrom the column list below

string 13
integer 2
float 4
date 1
datetime 1

Columns

21 columns in three groups

blueprint · 21 columns
column	type	description	example
Text 13 columns
`building_id`	string	Unique identifier for the municipal buildingunique	BLDG-0001
`building_name`	string	Official name of the building	City Office Tower West
`address_street`	string	Street address of the building	1520 Elmwood Ave
`address_city`	string	City where the building is located	Springfield
`address_state`	string	State or region of the building	IL
`address_postal_code`	string	Postal code of the building	62704
`address_country`	string	Country of the building	USA
`building_type`	string	Type of building (e.g., office, library, school, recreation center)office · library · school · recreation center · other	school
`energy_meter_id`	string	Unique identifier for the energy meter or sensor	EM-001-A
`energy_type`	string	Type of energy measured (e.g., electricity, natural gas, water, steam)electricity · natural gas · water · steam · other	electricity
`sensor_status`	string	Operational status of the sensor (active, inactive, maintenance, error)active · inactive · maintenance · error · optional	active
`compliance_certification`	string	Sustainability or energy compliance certification held by the building (e.g., LEED, ENERGY STAR)5 certifications · optional	LEED Gold
`optimization_action`	string	Type of energy optimization action taken (e.g., lighting upgrade, HVAC retrofit, insulation improvement)9 actions · optional	HVAC retrofit
Numbers 6 columns
`year_built`	integer	Year the building was constructed1,800 to 2,024 · optional	2016
`floor_area_sqft`	float	Total floor area of the building in square feet0 or more	165324.7
`occupancy`	integer	Average number of occupants in the building0 or more · optional	1120
`energy_consumption`	float	Amount of energy consumed during the measurement period (kWh, therms, gallons, etc.)0 or more	33924.2
`energy_cost`	float	Cost of energy consumed during the measurement period (in local currency)0 or more · optional	4207.8
`carbon_emissions_kg`	float	Estimated carbon emissions generated during the measurement period (in kilograms)0 or more · optional	5785.4
Dates and times 2 columns
`measurement_datetime`	datetime	Date and time of the energy measurement	2024-04-20T13:10:00
`last_optimization_date`	date	Date of last energy optimization intervention or upgradeoptional	2023-06-12

Use it for

An energy dashboard
Occupancy by building_type and a breakdown of compliance_certification. Excel, Power BI or Tableau.
Why do the 31 school rows have a mean occupancy of 960.2?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Buildings120
BLDG-00011120school
BLDG-000287library
BLDG-0003278office
A software demo
Believable buildings with building_name, address_street and address_city to fill a screen in front of a buyer.

This dataset120 rows21 columns

Yours10,000 rows21 columnsaddress_street: UK only

blueprint · municipal-building-energy-optimization-metrics

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 21 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 daily energy usage for a unique municipal building.
Metrics must include total kWh, peak demand, and HVAC efficiency score.
Data incorporates IoT sensor alerts for anomalies in usage.
Include building age, square footage, and occupancy type.
Highlight any days with above-threshold energy waste incidents.

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: municipal-building-energy-optimization-metrics

What should your data show?

No signup. No card.

Sample rows

What the 120 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?