Municipal Building Energy Benchmarking
This dataset provides monthly energy consumption and efficiency scores for municipal buildings, including detailed facility attributes and compliance indicators. It enables public sector managers to monitor energy performance, benchmark across building types, and support regulatory and ESG reporting initiatives.
Sample rows
preview · 8 of 75 rows · all 14 columns| building_idstring | building_typestring | energy_consumption_kwhfloat | compliance_statusboolean | address_statestring | building_namestring | address_streetstring | address_citystring | address_postal_codestring | address_countrystring | square_footagefloat | reporting_monthdate | efficiency_scorefloat | esg_reporting_flagboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SCH-001 | school | 185300.25 | true | IL | Lincoln High School | 123 Main St | Springfield | 62704 | USA | 125000 | 2024-01-01 | 68.7 | true |
| OFC-002 | office | 38700 | true | NJ | City Hall Annex | 456 Oak Ave | Riverton | 08077 | USA | 34450.5 | 2024-01-01 | 84.2 | false |
| LIB-003 | library | 14650 | true | MA | Eastside Public Library | 78 Library Rd | Marlborough | 01752 | USA | 21500 | 2024-01-01 | 79.1 | true |
| FST-004 | fire station | 10560 | true | OH | Station 7 Firehouse | 15 Firehouse Ln | Brookside | 43081 | USA | 8200 | 2024-01-01 | 58.6 | false |
| PS-005 | police station | 30500 | true | TX | Central Police HQ | 200 Justice Blvd | Fairview | 75069 | USA | 24550 | 2024-01-01 | 62.4 | true |
| CC-006 | community center | 41000 | true | MN | West Community Center | 350 Maple St | Lakeside | 55044 | USA | 28700 | 2024-01-01 | 72.5 | true |
| OTH-007 | other | 54000 | false | KY | Municipal Storage Depot | 910 Warehouse Dr | Georgetown | 40324 | USA | 45000 | 2024-01-01 | 47.8 | false |
| SCH-008 | school | 98300 | true | CA | Jefferson Elementary | 25 Pine St | Oakwood | 94561 | USA | 78000 | 2024-02-01 | 65.3 | false |
| OFC-009 | office | 62000 | true | CO | Civic Admin Building | 88 Civic Center Pl | Brighton | 80601 | USA | 51200 | 2024-02-01 | 80.2 | true |
| LIB-010 | library | 16980 | true | TN | Downtown Branch Library | 300 Elm Ave | Kingsport | 37660 | USA | 28500 | 2024-02-01 | 88.9 | true |
| FST-011 | fire station | 13020 | true | OR | Fire Station #12 | 200 Rescue Rd | Hillview | 97035 | USA | 9500 | 2024-02-01 | 64.7 | false |
| PS-012 | police station | 22900 | true | WA | Northside Precinct | 600 North St | Riverside | 98801 | USA | 19800 | 2024-02-01 | 70.4 | false |
| CC-013 | community center | 44000 | true | FL | South Community Center | 500 Parkview Dr | Bayshore | 33160 | USA | 31100 | 2024-02-01 | 75.8 | true |
| OTH-014 | other | 46000 | false | MD | Fleet Maintenance Garage | 1500 Industrial Way | Rockville | 20850 | USA | 38800 | 2024-02-01 | 52.2 | false |
| SCH-015 | school | 156000 | true | IA | Adams Middle School | 450 Schoolhouse Rd | Cedar Falls | 50613 | USA | 103500 | 2024-03-01 | 62.1 | false |
| OFC-016 | office | 41500 | true | CO | Municipal Office Plaza | 210 First Ave | Montrose | 81401 | USA | 39500 | 2024-03-01 | 77.3 | true |
| LIB-017 | library | 15200 | true | CO | North Branch Library | 800 Library Cir | Lakewood | 80226 | USA | 23750 | 2024-03-01 | 81.9 | true |
| FST-018 | fire station | 11600 | true | NY | Station 3 Firehouse | 72 Ladder Ln | Elmhurst | 11373 | USA | 10200 | 2024-03-01 | 60.5 | false |
| PS-019 | police station | 18800 | true | NC | Westside Police Station | 99 Patrol St | Pineville | 28134 | USA | 17800 | 2024-03-01 | 67.2 | false |
| CC-020 | community center | 39700 | true | AZ | East Community Center | 401 Sunrise Blvd | Sunridge | 85044 | USA | 28900 | 2024-03-01 | 74.3 | true |
What the 75 rows show
from the 75-row sampleSchool (building type) stands out: mean energy_
- 93%compliance_
status = true - 22,900median energy_
consumption_ kwh - 21,500median square_
footage - 77.7median efficiency_
score
Median 22,900, from 10,560 to 189,000.
- string 8
- float 3
- date 1
- boolean 2
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
building_id | string | Unique identifier for each municipal buildingunique | SCH-001 |
building_name | string | Official name of the municipal building | Lincoln High School |
building_type | string | Type of municipal building (e.g., office, library, school, fire station)7 values | school |
address_street | string | Street address of the building | 123 Main St |
address_city | string | City where the building is located | Springfield |
address_state | string | State or province where the building is located | IL |
address_postal_code | string | Postal or ZIP code for the building's location | 62704 |
address_country | string | Country where the building is located | USA |
| Numbers 3 columns | |||
square_footage | float | Total interior square footage of the building0 or more | 125000 |
energy_consumption_kwh | float | Total energy consumed in kilowatt-hours during the reporting month0 or more | 185300.25 |
efficiency_score | float | Building energy efficiency score for the reporting month (0-100 scale)0 to 100 | 68.7 |
| Dates and times 1 column | |||
reporting_month | date | Month and year for which energy consumption is reported (use first day of month) | 2024-01-01 |
| True or false 2 columns | |||
compliance_status | boolean | Indicates if the building is compliant with local energy benchmarking regulations for the reporting month | true |
esg_reporting_flag | boolean | Indicates if this record is included in ESG (Environmental, Social, Governance) reportingoptional | true |
Use it for
An energy dashboard
The compliance_
status rate, energy_ consumption_ kwh by building_ type and a breakdown of address_ state. Excel, Power BI or Tableau. Why do the 13 school rows have a mean energy_
consumption_ kwh of 82,811? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Buildings75SCH-001185300.25schoolOFC-00238700officeOTH-00754000other
A software demo
Believable buildings with building_
name, building_ type and address_ street to fill a screen in front of a buyer.
blueprint · municipal-building-energy-benchmarking
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 14 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.
- Each record represents a unique municipal building.
- Energy consumption must be reported monthly.
- Efficiency score is calculated based on consumption per square foot.
- Only buildings above 10,000 sq ft are included.
- Missing consumption data is flagged for compliance review.
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-benchmarking