Government
25 columns
72 rows
8 formats

Government Office Energy Audit Logs

This dataset provides detailed, structured records of energy audits conducted in local government offices, including building characteristics, energy consumption, costs, carbon emissions, compliance status, and recommendations. It enables tracking of sustainability initiatives, benchmarking of public sector buildings, and identification of energy efficiency improvements for ESG reporting and civic innovation.

last updated 12 Jan 2026
by GoMask

The brief that made it

Tracking and benchmarking energy consumption and efficiency across government buildings

Sample rows

preview · 8 of 72 rows · all 25 columns

audit_idstring	energy_efficiency_ratingstring	renewable_percentagefloat	auditor_namestring	office_idstring	office_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	building_typestring	floor_area_sqmfloat	audit_datedate	auditor_organizationstring	energy_consumption_kwhfloat	audit_period_startdate	audit_period_enddate	energy_cost_usdfloat	energy_sourcestring	carbon_emissions_kgco2efloat	compliance_statusstring	recommendationsstring	actions_takenstring	last_updateddatetime
AUDIT-0001	B	18.5	Linda Q. Harris	OFF-1001	Downtown Administrative Center	100 Main St	Springfield	IL	62701	USA	administrative	4200.5	2023-04-15	Green Audit Group	38500.7	2023-03-01	2023-03-31	4600.25	electricity	14250.3	compliant	Upgrade to LED lighting, install occupancy sensors.	Replaced old lighting in lobby with LEDs.	2023-04-16T09:12:45
AUDIT-0002	C	22	Samuel Lee	OFF-1002	Eastside Community Center	202 Oak Ave	Madison	WI	53703	USA	community center	2500	2023-05-10	EcoVeritas	15890	2023-04-01	2023-04-30	1755.5	mixed	6100.7	pending	Increase insulation, optimize HVAC scheduling.	Scheduled HVAC maintenance.	2023-05-11T14:22:01
AUDIT-0003	D	10	Rachel Martinez	OFF-1003	Westside Police Station	15 Elm St	Boulder	CO	80301	USA	police station	3600	2023-06-07	EnviroCheck	20980.4	2023-05-01	2023-05-31	2350.8	electricity	8250.1	non-compliant	Replace outdated HVAC system.	None reported.	2023-06-08T10:04:33
AUDIT-0004	B	40	Tina Chen	OFF-1004	Greenfield Library	88 Maple Dr	Greenfield	MA	01301	USA	library	1800.25	2022-09-19	Green Audit Group	9250.5	2022-08-01	2022-08-31	1015	electricity	3200	compliant	Install solar panels.	Applied for solar grant.	2022-09-20T08:45:14
AUDIT-0005	C	0	Michael Nguyen	OFF-1005	Riverbend Fire Station	73 River Rd	Columbus	OH	43215	USA	fire station	2100	2023-02-12	EnviroCheck	12100	2023-01-01	2023-01-31	1300	gas	4300	pending	Seal air leaks, upgrade insulation.	Sealed some windows.	2023-02-13T11:06:22
AUDIT-0006	C	15	James O'Donnell	OFF-1006	Central Courthouse	200 Justice Plaza	Albany	NY	12207	USA	courthouse	5200	2023-07-20	EcoVeritas	44500	2023-06-01	2023-06-30	5060	electricity	16750	compliant	Implement demand response program.	None reported.	2023-07-21T15:21:17
AUDIT-0007	B	25	Karen Patel	OFF-1007	Northside Administrative Annex	400 Grant Blvd	Raleigh	NC	27601	USA	administrative	2950	2022-11-10	Green Audit Group	17250	2022-10-01	2022-10-31	1900	electricity	6500	compliant	Upgrade water heaters.	Water heaters replaced.	2022-11-11T10:44:28
AUDIT-0008	B	21	Linda Q. Harris	OFF-1001	Downtown Administrative Center	100 Main St	Springfield	IL	62701	USA	administrative	4200.5	2024-01-19	Green Audit Group	39550	2023-12-01	2023-12-31	4720	electricity	14400	compliant	Add smart thermostats.	Thermostats pilot started.	2024-01-20T09:37:11
AUDIT-0009	D	0	Rachel Martinez	OFF-1008	Hillside Fire Station	18 Sunset Dr	Denver	CO	80203	USA	fire station	1700	2023-09-22	EnviroCheck	10600	2023-08-01	2023-08-31	1150	gas	3900	non-compliant	Upgrade boiler system.	Boiler replacement approved.	2023-09-23T13:52:36
AUDIT-0010	B	29	James O'Donnell	OFF-1009	Lakeview Community Center	55 Lakeside Ave	Rochester	NY	14604	USA	community center	3200	2023-10-04	EcoVeritas	18900	2023-09-01	2023-09-30	2100	mixed	5700	compliant	Retrofit windows.	Windows retrofit in progress.	2023-10-05T08:14:01
AUDIT-0011	A	35	Karen Patel	OFF-1010	Central Library	120 Library Way	Akron	OH	44308	USA	library	2250	2022-08-13	Green Audit Group	9850	2022-07-01	2022-07-31	1080	electricity	3300	compliant	Expand solar capacity.	Solar expansion grant submitted.	2022-08-14T11:19:55
AUDIT-0012	C	13	Tina Chen	OFF-1011	Heritage Courthouse	1 Justice Road	Lancaster	PA	17603	USA	courthouse	4700	2023-03-28	Green Audit Group	43200	2023-02-01	2023-02-28	4880	electricity	16000	compliant	Install motion sensor lighting.	Motion sensors installed in courtrooms.	2023-03-29T14:36:18
AUDIT-0013	B	24	Samuel Lee	OFF-1002	Eastside Community Center	202 Oak Ave	Madison	WI	53703	USA	community center	2500	2024-03-14	EcoVeritas	16000	2024-02-01	2024-02-29	1780	mixed	6150	compliant	Upgrade to variable speed drives.	Drives installed on gym HVAC.	2024-03-15T09:16:02
AUDIT-0014	B	19	Linda Q. Harris	OFF-1012	City Hall Annex	310 Civic Plaza	Baltimore	MD	21201	USA	administrative	3800	2023-11-09	Green Audit Group	29500	2023-10-01	2023-10-31	3380	electricity	10800	compliant	Install daylight harvesting system.	Daylight sensors installed on 2nd floor.	2023-11-10T10:00:29
AUDIT-0015	C	11	Michael Nguyen	OFF-1013	Southside Police Station	410 South St	Tucson	AZ	85701	USA	police station	3400	2023-12-17	EnviroCheck	21400	2023-11-01	2023-11-30	2390	electricity	8300	non-compliant	Upgrade exterior insulation.	Insulation upgrade scheduled.	2023-12-18T16:38:04
AUDIT-0016	D	0	Samuel Lee	OFF-1014	West End Fire Station	25 Pine St	Helena	MT	59601	USA	fire station	2150	2022-12-05	EcoVeritas	12200	2022-11-01	2022-11-30	1340	gas	4350	pending	Weatherproof garage doors.	Weatherproofing completed.	2022-12-06T08:59:41
AUDIT-0017	C	14	Tina Chen	OFF-1015	Historic Town Hall	1 Main Plaza	Charleston	SC	29401	USA	administrative	3100	2023-07-02	Green Audit Group	21800	2023-06-01	2023-06-30	2490	electricity	8400	compliant	Replace window glazing.	Glazing replaced throughout.	2023-07-03T10:51:11
AUDIT-0018	B	32	James O'Donnell	OFF-1016	Central Community Center	77 Community Dr	San Diego	CA	92101	USA	community center	2750	2024-02-09	EcoVeritas	16200	2024-01-01	2024-01-31	1820	mixed	5800	compliant	Add solar carport.	Solar carport project launched.	2024-02-10T09:28:54
AUDIT-0019	A	37	Linda Q. Harris	OFF-1017	East Branch Library	230 East St	Providence	RI	02903	USA	library	2000	2023-08-26	Green Audit Group	9600	2023-07-01	2023-07-31	1050	electricity	3250	compliant	Increase solar panel coverage.	Panel expansion completed.	2023-08-27T12:11:24
AUDIT-0020	C	13	Rachel Martinez	OFF-1003	Westside Police Station	15 Elm St	Boulder	CO	80301	USA	police station	3600	2024-04-10	EnviroCheck	21200	2024-03-01	2024-03-31	2370	electricity	8300	pending	Install rooftop solar panels.	Solar installation pending.	2024-04-11T08:47:30

What the 72 rows show

from the 72-row sample

A (energy efficiency rating) stands out: mean renewable_percentage is 35.9, against 15.4 for the rest.

18.1median renewable_percentage
3energy sources
3compliance statuses
6building types
10auditor organizations
3,500median floor_area_sqm

Mean renewable_percentage by energy_efficiency_rating72 rows

renewable_percentage72 rows, in bands of 5

Median 18.1, from 0.0 to 43.5.

auditor_name72 rows · top 10 of 25 values

Samuel Lee6
Rachel Martinez6
Tina Chen6
James O'Donnell5
Karen Patel5
Linda Q. Harris4
Michael Nguyen4
Clara Evans2
Mackenzie Ford2
Jessica Wu2

25 columns by typefrom the column list below

string 16
float 5
date 3
datetime 1

Columns

25 columns in three groups

blueprint · 25 columns
column	type	description	example
Text 16 columns
`audit_id`	string	Unique identifier for each energy audit recordunique	AUDIT-0001
`office_id`	string	Unique identifier for the government office/building	OFF-1001
`office_name`	string	Official name of the government office or building	Westside Police Station
`address_street`	string	Street address of the government office	100 Main St
`address_city`	string	City where the government office is located	Springfield
`address_state`	string	State or region of the government office	IL
`address_postal_code`	string	Postal code for the government office address	62701
`address_country`	string	Country where the government office is located	USA
`building_type`	string	Type of government building (e.g., administrative, courthouse, police station)7 values	administrative
`auditor_name`	string	Name of the auditor or audit team lead	Linda Q. Harris
`auditor_organization`	string	Organization or company responsible for the audit10 organizations	Green Audit Group
`energy_source`	string	Primary source of energy used (e.g., electricity, gas, solar, mixed)6 values	electricity
`energy_efficiency_rating`	string	Energy efficiency rating assigned to the building (e.g., A, B, C, D, E)6 values · optional	B
`compliance_status`	string	Compliance status with relevant energy or sustainability standardscompliant · non-compliant · pending · not assessed	compliant
`recommendations`	string	Summary of energy-saving recommendations provided by the auditoroptional	Install solar panels.
`actions_taken`	string	Summary of actions taken in response to previous audit recommendationsoptional	None reported.
Numbers 5 columns
`floor_area_sqm`	float	Total floor area of the building in square meters0 or more	4200.5
`energy_consumption_kwh`	float	Total energy consumed by the building during the audit period, in kilowatt-hours0 or more	38500.7
`energy_cost_usd`	float	Total energy cost incurred during the audit period, in US dollars0 or more · optional	4600.25
`renewable_percentage`	float	Percentage of total energy consumption from renewable sources (0-100)0 to 100 · optional	18.5
`carbon_emissions_kgco2e`	float	Estimated carbon emissions produced during the audit period, in kilograms of CO2 equivalent0 or more · optional	14250.3
Dates and times 4 columns
`audit_date`	date	Date when the energy audit was conducted	2023-04-15
`audit_period_start`	date	Start date of the period covered by the audit	2023-03-01
`audit_period_end`	date	End date of the period covered by the audit	2023-03-31
`last_updated`	datetime	Timestamp of the last update to this audit record	2023-04-16T09:12:45

Use it for

A government dashboard
Renewable_percentage by energy_efficiency_rating and a breakdown of auditor_name. Excel, Power BI or Tableau.
Why do the 14 A rows have a mean renewable_percentage of 35.9?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Audits72
AUDIT-000118.5B
AUDIT-000222C
AUDIT-000310D
A software demo
Believable audits with office_id, office_name and address_street to fill a screen in front of a buyer.

This dataset72 rows25 columns

Yours1,000 rows25 columnsaddress_street: UK only

blueprint · government-office-energy-audit-logs

Behind this dataset

Same schema. As many rows as you need.

These 72 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 government office audit event
Includes kilowatt-hour usage, audit date, recommended improvements, and estimated savings
Flag offices that exceed benchmark consumption by over 15%
Track follow-up status for remediation actions
Categorize audits by building type (administrative, service, emergency)

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: government-office-energy-audit-logs

What should your data show?

No signup. No card.

Sample rows

What the 72 rows show

Columns

Use it for

A government dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Government

What should your data show?