Energy
17 columns
120 rows
8 formats

City Facility Energy Benchmarking

This dataset provides monthly electricity, heating, and water consumption data for city-owned facilities, along with facility details, occupancy, and energy efficiency ratings. It enables public sector analysts to benchmark usage, identify inefficiencies, and support climate-resilience planning for sustainable government operations. The data is structured for actionable insights and longitudinal analysis.

last updated 30 Nov 2025
by GoMask

The brief that made it

Benchmarking energy and water usage across city facilities

Sample rows

preview · 8 of 120 rows · all 17 columns

facility_idstring	facility_typestring	water_consumption_m3float	year_monthstring	facility_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	electricity_consumption_kwhfloat	heating_consumption_mwhfloat	occupancyinteger	floor_area_m2float	energy_efficiency_ratingstring	renewable_energy_percentagefloat	notesstring
LIB_001	Library	240.5	2022-07	Downtown Branch Library	123 Maple Ave	Springfield	IL	62701	USA	7400.2	6.1	160	2600	LEED Gold	18.5	Summer reading program, typical usage
LIB_002	Library	320.4	2023-03	Westside Community Library	456 Oak St	Riverton	MO	64112	USA	9500	17.3	210	3200	None	0	Winter surge in heating demand
LIB_003	Library	150.8	2024-01	North End Library	789 Elm Blvd	Lakeside	ON	N2L 3G1	Canada	5100.7	21.2	80	1100	LEED Silver	14.9	Snowstorm closure, reduced occupancy
SCHL_001	School	1900.6	2021-11	Lincoln High School	1010 Adams Rd	Columbus	OH	43215	USA	32000	49.7	1800	8200	ENERGY STAR	8.2	Thanksgiving break, lower occupancy
SCHL_002	School	990	2022-09	Maple Grove Elementary	223 Pine Lane	Vancouver	BC	V5K 0A1	Canada	22500	23.1	900	5200	None	0	Back-to-school, increased water usage
SCHL_003	School	1600.3	2023-05	Westhill Middle School	330 Birch St	Portland	OR	97205	USA	39000.5	15	1100	6700	ENERGY STAR	13.5	Spring concert, high occupancy
OFFC_001	Office	420.1	2022-02	City Hall Office	800 Main St	Hartford	CT	06103	USA	15700	31	150	4100	LEED Gold	55.6	Remote work pilot, some floors closed
OFFC_002	Office	210.2	2021-12	Riverfront Admin Office	456 Waterway Dr	Cincinnati	OH	45202	USA	8000	13.5	60	2000	LEED Platinum	61.3	Holiday closure, reduced usage
OFFC_003	Office	390	2023-07	Metro Planning Office	1555 Commerce Ave	Boston	MA	02110	USA	12100.6	9.2	120	3200	ENERGY STAR	26.8	Summer hours, increased cooling demand
RECR_001	Recreation Center	3800	2022-06	Greenfield Recreation Center	2100 Parkside Rd	Denver	CO	80204	USA	23000	3.5	2400	9000	LEED Gold	68.4	Summer camp, pool usage spike
RECR_002	Recreation Center	4200	2021-10	Oakwood Sports Complex	3200 Stadium Dr	Houston	TX	77001	USA	36500.8	9.3	3700	12000	LEED Platinum	89.4	Annual conference, max occupancy
RECR_003	Recreation Center	3760	2023-02	Maple Leaf Community Center	4100 Cedar Ct	Toronto	ON	M5V 2T6	Canada	29500	45.2	2900	9700	LEED Gold	73.2	Winter sports event, peak heating
FIRE_001	Fire Station	4.8	2022-12	Northside Fire Station	540 First Ave	Madison	WI	53703	USA	120.5	7.2	12	60	None	0	Winter season, heating increased
FIRE_002	Fire Station	2.1	2021-09	Lakeview Fire Outpost	1001 Lake Dr	Buffalo	NY	14202	USA	50	1.5	5	22	None	0	Minimal staff, routine operations
FIRE_003	Fire Station	6.2	2023-03	East End Fire Station	77 Elm St	Winnipeg	MB	R3C 1A2	Canada	310.2	8.7	18	85	None	0	Staff training, increased activity
POLC_001	Police Station	7.5	2022-04	Central Police Station	200 Market St	Seattle	WA	98101	USA	260.8	5.2	16	92	None	0	Routine patrols, typical usage
POLC_002	Police Station	3.9	2024-02	Cedar Grove Police Outpost	400 Willow Rd	Omaha	NE	68102	USA	320.5	7.8	11	32	None	0	Winter patrol, increased heating
POLC_003	Police Station	2.2	2022-05	Westside Police Station	600 Central Ave	Edmonton	AB	T5J 2E7	Canada	110.7	4.3	8	20	None	0	Preservation status, minimal activity
OTH_001	Other	4900.2	2023-11	City Auditorium	900 Grand St	Raleigh	NC	27601	USA	41000.7	41.8	4100	11000	LEED Platinum	95.6	Fall conference, full capacity
OTH_002	Other	12	2021-08	Community Expo Hall	2000 Expo Blvd	San Jose	CA	95113	USA	850	0.5	15	25	None	0	Preservation, minimal usage

What the 120 rows show

from the 120-row sample

Recreation Center (facility type) stands out: mean water_consumption_m3 is 3,678, against 746.4 for the rest.

301.8median water_consumption_m3
2address countries
6energy efficiency ratings
35address states
12,016median electricity_consumption_kwh
8.9median heating_consumption_mwh

Mean water_consumption_m3 by facility_type120 rows

water_consumption_m3120 rows, in bands of 500

Median 301.8, from 1.6 to 4,945.

year_month120 rows · top 10 of 40 values

2023-036
2022-075
2023-055
2024-055
2023-015
2022-094
2023-074
2023-024
2022-124
2024-024

17 columns by typefrom the column list below

string 11
integer 1
float 5

Columns

17 columns in two groups

blueprint · 17 columns
column	type	description	example
Text 11 columns
`facility_id`	string	Unique identifier for each city-owned facilityunique	LIB_001
`facility_name`	string	Official name of the facility	Downtown Branch Library
`facility_type`	string	Type of facility (e.g., library, school, office, recreation center)7 values	Library
`address_street`	string	Street address of the facility	123 Maple Ave
`address_city`	string	City where the facility is located	Springfield
`address_state`	string	State or province where the facility is located	IL
`address_postal_code`	string	Postal code of the facility	62701
`address_country`	string	Country where the facility is located2 countries	USA
`year_month`	string	Reporting period in YYYY-MM format	2022-07
`energy_efficiency_rating`	string	Facility's energy efficiency rating (e.g., LEED, ENERGY STAR, or local standard)6 ratings · optional	LEED Gold
`notes`	string	Additional notes or comments about the facility or reporting periodoptional	Summer reading program, t…
Numbers 6 columns
`electricity_consumption_kwh`	float	Monthly electricity consumption in kilowatt-hours (kWh)0 or more	7400.2
`heating_consumption_mwh`	float	Monthly heating consumption in megawatt-hours (MWh)0 or more	6.1
`water_consumption_m3`	float	Monthly water consumption in cubic meters (m³)0 or more	240.5
`occupancy`	integer	Average number of occupants during the reporting period0 or more · optional	160
`floor_area_m2`	float	Total usable floor area of the facility in square meters0 or more · optional	2600
`renewable_energy_percentage`	float	Percentage of facility's energy sourced from renewables for the reporting period0 to 100 · optional	18.5

Use it for

An energy dashboard
Water_consumption_m3 by facility_type and a breakdown of year_month. Excel, Power BI or Tableau.
Why do the 17 Recreation Center rows have a mean water_consumption_m3 of 3,678?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Facilities120
LIB_001240.5Library
LIB_002320.4Library
LIB_003150.8Library
A software demo
Believable facilities with facility_name, facility_type and address_street to fill a screen in front of a buyer.

This dataset120 rows17 columns

Yours1,000 rows17 columnsaddress_street: UK only

blueprint · city-facility-energy-benchmarking

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 17 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 facility has unique ID and type (library, fire station, admin office, etc.)
Monthly readings must include electricity (kWh), heating (BTU), and water (gallons)
Missing readings flagged and annotated for data quality assessment
Benchmark scores calculated using normalized facility size
Facility location must be mapped to district/zone

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: city-facility-energy-benchmarking

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?