Energy
23 columns
184 rows
8 formats

Municipal Energy Efficiency Audit Logs

This dataset provides granular, facility-level energy efficiency audit logs across municipal buildings, including detailed energy usage, compliance status, and actionable recommendations. It supports benchmarking, policy planning, and compliance monitoring for government sustainability and climate initiatives, enabling data-driven decision-making and progress tracking.

last updated 15 Dec 2025
by GoMask

The brief that made it

Benchmarking energy efficiency across municipal facilities

Sample rows

preview · 8 of 184 rows · all 23 columns

audit_idstring	facility_typestring	energy_consumption_kwhfloat	follow_up_requiredboolean	auditor_namestring	facility_idstring	facility_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	audit_datedate	energy_consumption_period_startdate	energy_consumption_period_enddate	benchmark_scorefloat	compliance_statusstring	identified_issuesstring	recommended_actionsstring	estimated_savings_kwhfloat	estimated_savings_usdfloat	next_audit_due_datedate	notesstring
A-10234	library	18977.4	true	EcoLogic Consulting	F-CA-001	San Mateo Public Library	55 West 3rd Ave	San Mateo	CA	94402	USA	2023-07-14	2023-01-01	2023-06-30	52.1	pending	Lighting schedules not optimized, windows poorly sealed	Automate lighting, weatherize windows	1200.8	245.6	2024-07-14	Awaiting council approval for upgrades
A-20456	office	39780.5	false	Janelle Stewart	F-TX-003	Irving Municipal Office	333 Las Colinas Blvd	Irving	TX	75039	USA	2022-09-22	2022-03-01	2022-08-31	97.7	compliant	blank	blank	0	0	blank	Model office for efficiency
AUD-3101	water treatment	301456.2	true	Green Audit Group	F-ON-002	Toronto Water Treatment North	1799 Lake Shore Blvd E	Toronto	ON	M4L3A2	Canada	2024-03-19	2023-09-01	2024-02-29	13.5	non-compliant	Pump losses, leaks found in supply lines	Replace pumps, repair supply line leaks	45311.9	7032.5	2025-03-19	Major plant overhauls scheduled
A-41290	recreation	42123	true	Sustainergy Partners	F-NY-004	Staten Island Rec Center	102 Bay St	Staten Island	NY	10301	USA	2024-01-15	2023-07-01	2023-12-31	46.8	pending	Pool filter inefficient, solar inverter needs recalibration	Upgrade filter, recalibrate inverter	2100.7	420.8	2025-01-15	High utility potential, upgrades scheduled
AUD-5232	public safety	112830.4	true	EnviroCheck Ltd.	F-UK-001	Leeds City Safety HQ	21 Wellington St	Leeds	WYK	LS1 4DL	UK	2023-04-04	2022-10-01	2023-03-31	30.1	non-compliant	Aging HVAC, excessive lighting after hours	Upgrade HVAC, automate lighting schedules	14500.9	2210	2024-04-04	Urgent action required
A-60220	recreation	35021.2	false	Janelle Stewart	F-CA-005	Redwood City Community Pool	1200 Roosevelt Ave	Redwood City	CA	94061	USA	2023-06-10	2022-12-01	2023-05-31	48.2	compliant	blank	blank	0	0	blank	Best performing city recreation center
AUD-7380	public safety	89310.7	true	EcoLogic Consulting	F-TX-009	Arlington Fire Station #2	3201 Division St	Arlington	TX	76011	USA	2022-11-18	2022-05-01	2022-10-31	42.3	pending	Older lighting fixtures, HVAC inefficient	Replace lighting, upgrade HVAC system	7300.2	1280.7	2023-11-18	Awaiting city budget approval
A-82014	office	51012.8	false	Sustainergy Partners	F-CA-007	San Jose City Hall	200 E Santa Clara St	San Jose	CA	95113	USA	2024-04-01	2023-10-01	2024-03-31	94.9	compliant	blank	blank	0	0	blank	Best performing city office
AUD-9912	library	17890.5	false	Green Audit Group	F-CA-001	San Mateo Public Library	55 West 3rd Ave	San Mateo	CA	94402	USA	2022-07-14	2022-01-01	2022-06-30	44.7	pending	Manual lighting schedules, drafty windows	Install occupancy sensors, weatherize windows	1100.9	220.7	blank	Staff trained for new system
A-10257	school	62713.1	false	EnviroCheck Ltd.	F-NY-011	Brooklyn School of Arts	80 Willoughby St	Brooklyn	NY	11201	USA	2023-09-08	2023-03-01	2023-08-31	60.4	compliant	blank	blank	0	0	blank	School recently upgraded
AUD-1180	library	21000	false	EcoLogic Consulting	F-CA-014	Mountain View Library	585 Franklin St	Mountain View	CA	94041	USA	2022-10-10	2022-04-01	2022-09-30	62.7	compliant	blank	blank	0	0	blank	Library exceeded targets
A-21980	recreation	41023.9	true	Green Audit Group	F-TX-015	Plano Recreation Center	2301 West Parker Rd	Plano	TX	75023	USA	2023-02-16	2022-08-01	2023-01-31	41.9	pending	Pool filter outdated, solar inverter needs recalibration	Upgrade filters, recalibrate inverters	6700	980.4	2024-02-16	Upgrades scheduled for next fiscal year
AUD-3047	recreation	42400.2	false	EcoLogic Consulting	F-NY-004	Staten Island Rec Center	102 Bay St	Staten Island	NY	10301	USA	2023-01-15	2022-07-01	2022-12-31	49.2	compliant	blank	blank	0	0	blank	High utility potential, upgrades completed
A-71182	water treatment	277893.6	true	EnviroCheck Ltd.	F-CA-019	Foster City Water Treatment	100 Shell Blvd	Foster City	CA	94404	USA	2023-12-22	2023-06-01	2023-11-30	18.9	non-compliant	Pump inefficiency, blower losses	Replace motors, repair blowers	35000.4	6680.2	2024-12-22	Major upgrades scheduled
AUD-5551	office	42340	false	EcoLogic Consulting	F-TX-003	Irving Municipal Office	333 Las Colinas Blvd	Irving	TX	75039	USA	2023-09-22	2023-03-01	2023-08-31	99.2	compliant	blank	blank	0	0	blank	Model office for efficiency
A-14110	public safety	118900.7	true	Sustainergy Partners	F-CA-021	Palo Alto Safety Center	250 Hamilton Ave	Palo Alto	CA	94301	USA	2024-02-03	2023-08-01	2024-01-31	31.6	pending	Excessive after-hours lighting, old HVAC	Automate lighting, replace HVAC	15800	2280.6	2025-02-03	Budget planning in progress
AUD-6765	school	64012.6	false	EcoLogic Consulting	F-NY-011	Brooklyn School of Arts	80 Willoughby St	Brooklyn	NY	11201	USA	2022-09-08	2022-03-01	2022-08-31	57.8	compliant	blank	blank	0	0	blank	Energy use trending downward
A-43022	recreation	31890.2	false	Green Audit Group	F-CA-023	Menlo Park Recreation	700 Alma St	Menlo Park	CA	94025	USA	2023-08-25	2023-02-01	2023-07-31	44.3	pending	Solar inverter needs recalibration	Recalibrate inverter	1200	210.9	blank	Utility rebate application submitted
AUD-8055	water treatment	285110.5	true	Green Audit Group	F-CA-019	Foster City Water Treatment	100 Shell Blvd	Foster City	CA	94404	USA	2022-12-22	2022-06-01	2022-11-30	22.1	non-compliant	Pump inefficiency, blower losses	Replace pumps, repair blowers	41000.2	8100.5	2023-12-22	Major upgrades needed
A-93182	water treatment	295600	true	EcoLogic Consulting	F-ON-002	Toronto Water Treatment North	1799 Lake Shore Blvd E	Toronto	ON	M4L3A2	Canada	2022-03-19	2021-09-01	2022-02-28	15.6	non-compliant	Blower losses, leaks	Repair leaks, replace blowers	39000	5800	2023-03-19	Urgent action required

What the 184 rows show

from the 184-row sample

Water treatment (facility type) stands out: mean energy_consumption_kwh is 295,277, against 52,732 for the rest.

47%follow_up_required = true
42,087median energy_consumption_kwh
3address countries
4compliance statuses
22address states
47.0median benchmark_score

Mean energy_consumption_kwh by facility_type184 rows

energy_consumption_kwh184 rows, in bands of 50k

Median 42,087, from 0.0 to 350,000.

auditor_name184 rows · top 10 of 26 values

EcoLogic Consulting16
Green Audit Group13
HydroOptima Ltd.10
Energy Insight Canada9
Efficient Facilities Group9
GreenBridge Solutions9
EcoLogic Inspections9
Urban Efficiency Partners9
Municipal Energy Auditors9
GreenFuture Audit LLC8

23 columns by typefrom the column list below

string 14
float 4
date 4
boolean 1

Columns

23 columns in four groups

blueprint · 23 columns
column	type	description	example
Text 14 columns
`audit_id`	string	Unique identifier for each energy efficiency audit log entryunique	A-10234
`facility_id`	string	Unique identifier for the municipal facility	F-CA-001
`facility_name`	string	Official name of the municipal facility	San Mateo Public Library
`facility_type`	string	Type of municipal facility (e.g., school, library, office, water treatment)7 values	library
`address_street`	string	Street address of the facility	55 West 3rd Ave
`address_city`	string	City where the facility is located	San Mateo
`address_state`	string	State or province of the facility	CA
`address_postal_code`	string	Postal or ZIP code of the facility	94402
`address_country`	string	Country where the facility is located3 countries	USA
`auditor_name`	string	Full name of the person or organization conducting the audit	EcoLogic Consulting
`compliance_status`	string	Indicates if the facility meets local, state, or federal energy efficiency standardscompliant · non-compliant · pending · not-applicable	pending
`identified_issues`	string	Summary of key issues or inefficiencies identified during the auditoptional	Blower losses, leaks
`recommended_actions`	string	Summary of recommended actions for improving energy efficiencyoptional	Recalibrate inverter
`notes`	string	Additional notes or comments relevant to the auditoptional	Urgent action required
Numbers 4 columns
`energy_consumption_kwh`	float	Total energy consumed by the facility during the audit period (in kilowatt-hours)0 or more	18977.4
`benchmark_score`	float	Energy efficiency benchmark score (e.g., percentile or rating compared to similar facilities)0 to 100 · optional	52.1
`estimated_savings_kwh`	float	Estimated annual energy savings (in kWh) if recommended actions are implemented0 or more · optional	1200.8
`estimated_savings_usd`	float	Estimated annual cost savings (in USD) if recommended actions are implemented0 or more · optional	245.6
Dates and times 4 columns
`audit_date`	date	Date when the energy efficiency audit was conducted	2023-07-14
`energy_consumption_period_start`	date	Start date of the period measured for energy consumption	2023-01-01
`energy_consumption_period_end`	date	End date of the period measured for energy consumption	2023-06-30
`next_audit_due_date`	date	Scheduled date for the next audit, if applicableoptional	2024-07-14
True or false 1 column
`follow_up_required`	boolean	Indicates if follow-up actions or audits are required	true

Use it for

An energy dashboard
The follow_up_required rate, energy_consumption_kwh by facility_type and a breakdown of auditor_name. Excel, Power BI or Tableau.
Why do the 33 water treatment rows have a mean energy_consumption_kwh of 295,277?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Audits184
A-1023418977.4library
A-2045639780.5office
AUD-3101301456.2water tr…
A software demo
Believable audits with facility_id, facility_name and facility_type to fill a screen in front of a buyer.

This dataset184 rows23 columns

Yours1,000 rows23 columnsaddress_street: UK only

blueprint · municipal-energy-efficiency-audit-logs

Behind this dataset

Same schema. As many rows as you need.

These 184 rows came out of a blueprint — 23 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 facility's annual audit result
Includes total energy consumed and efficiency score
Flags for compliance with local sustainability standards
Tracks remediation actions and follow-up status
Includes building type and operational hours

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: municipal-energy-efficiency-audit-logs

What should your data show?

No signup. No card.

Sample rows

What the 184 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?