Urban Building IoT Energy Logs
This dataset contains granular energy consumption logs from IoT sensors in urban commercial buildings, including building and sensor metadata, timestamped readings, and estimated CO2 emissions. It enables smart city planners and engineers to analyze energy patterns, detect inefficiencies, and prioritize sustainability upgrades for emission reduction. The dataset supports actionable insights for optimizing urban infrastructure and advancing sustainability goals.
Sample rows
preview · 8 of 120 rows · all 19 columns| log_idstring | sensor_typestring | floor_area_sqmfloat | is_anomalyboolean | address_citystring | building_idstring | building_namestring | address_streetstring | address_statestring | address_postal_codestring | address_countrystring | sensor_idstring | sensor_locationstring | timestampdatetime | energy_consumption_kwhfloat | peak_load_kwfloat | co2_emissions_kgfloat | energy_sourcestring | building_typestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG0001 | electricity | 2450 | false | New York | BLD-A101 | Sunrise Center | 101 Main Ave | NY | 10001 | USA | SENS-0001 | Floor 2, Room 204 | 2024-06-01T08:14:32Z | 34.6 | 12.3 | 15.8 | grid | office |
| LOG0002 | water | 18200 | false | Chicago | BLD-R205 | Market Plaza | 210 7th St | IL | 60611 | USA | SENS-0002 | Basement, Water Panel | 2024-06-01T09:31:17Z | 0 | blank | 0 | grid | retail |
| LOG0003 | hvac | 1200 | false | Toronto | BLD-H110 | Lakeview Hotel | 502 Lakeshore Dr | ON | M5V2T6 | Canada | SENS-0003 | Floor 3, HVAC Zone | 2024-06-01T10:01:43Z | 41.1 | 13.2 | 18.7 | grid | hotel |
| LOG0004 | electricity | 6100 | false | San Francisco | BLD-O303 | EcoWorks Tower | 33 Green St | CA | 94111 | USA | SENS-0004 | Floor 6, Server Room | 2024-06-01T11:19:08Z | 49.8 | 15 | 23.6 | grid | office |
| LOG0005 | water | 4100 | false | Sydney | BLD-H201 | GoodHealth Center | 17 Wellness Rd | NSW | 2000 | Australia | SENS-0005 | Ground Floor | 2024-06-01T12:42:55Z | 0.2 | blank | 0 | other | hospital |
| LOG0006 | gas | 25000 | false | London | BLD-R311 | Central Mall | 884 Queen St | LDN | W1D3BJ | UK | SENS-0006 | Service Corridor | 2024-06-01T13:59:02Z | 0.8 | 0.7 | 3.5 | gas | retail |
| LOG0007 | hvac | 3200 | false | Boston | BLD-O409 | NorthStar Offices | 45 Market St | MA | 02109 | USA | SENS-0007 | Floor 4, HVAC Room | 2024-06-01T14:16:17Z | 12.7 | 6.4 | 9.2 | grid | office |
| LOG0008 | other | 67000 | true | Berlin | BLD-S504 | blank | 1200 Grand Blvd | BE | 10115 | Germany | SENS-0008 | blank | 2024-06-01T15:01:41Z | 2330.1 | 1250.2 | 1550 | other | other |
| LOG0009 | gas | 3100 | false | Dallas | BLD-H213 | Red Cross Clinic | 48 Elm St | TX | 75201 | USA | SENS-0009 | Boiler Room | 2024-06-01T16:27:17Z | 1 | 0.9 | 4 | gas | hospital |
| LOG0010 | electricity | 4150 | false | Seattle | BLD-O505 | UrbanEdge Suite | 300 5th Ave | WA | 98101 | USA | SENS-0010 | Floor 10, Storage | 2024-06-01T17:02:39Z | 36.4 | 10.9 | 17.2 | grid | office |
| LOG0011 | electricity | 1200 | false | Portland | BLD-R118 | GreenMart | 99 Eco Rd | OR | 97209 | USA | SENS-0011 | Floor 1, Lobby | 2024-06-01T18:08:24Z | 27.5 | 7 | 11.3 | wind | retail |
| LOG0012 | hvac | 800 | false | Brisbane | BLD-H301 | Starlight Inn | 88 Main St | QLD | 4000 | Australia | SENS-0012 | Floor 2, Service Area | 2024-06-01T19:41:07Z | 17.2 | 7.9 | 8.9 | grid | hotel |
| LOG0013 | water | 8200 | false | Vancouver | BLD-R207 | ShopSmart | 17 Commerce Ave | BC | V6B2P4 | Canada | SENS-0013 | blank | 2024-06-01T20:13:59Z | 0 | blank | 0 | solar | retail |
| LOG0014 | electricity | 5300 | false | Los Angeles | BLD-O602 | Metro Offices | 620 Park St | CA | 90017 | USA | SENS-0014 | Floor 12, Executive | 2024-06-01T21:22:44Z | 47.5 | 14.2 | 20.9 | grid | office |
| LOG0015 | water | 5200 | false | Miami | BLD-H402 | City Hospital | 400 Wellness Blvd | FL | 33101 | USA | SENS-0015 | LL-Water Control | 2024-06-01T22:09:03Z | 0.1 | blank | 0 | grid | hospital |
| LOG0016 | electricity | 3600 | false | Denver | BLD-O706 | PeakView Offices | 709 2nd St | CO | 80202 | USA | SENS-0016 | Floor 7, Technology | 2024-06-01T23:57:41Z | 39.1 | 11.5 | 16.6 | grid | office |
| LOG0017 | hvac | 8900 | false | Melbourne | BLD-R405 | Sunshine Market | 45 Grove St | VIC | 3000 | Australia | SENS-0017 | Roof, Compressor | 2024-06-02T08:02:12Z | 14.8 | 5.9 | 7.7 | grid | retail |
| LOG0018 | gas | 250 | false | Phoenix | BLD-H520 | Westside General | 520 Oak St | AZ | 85004 | USA | SENS-0018 | Ground Floor | 2024-06-02T09:14:21Z | 1 | 0.8 | 3.8 | gas | hospital |
| LOG0019 | electricity | 3800 | false | Austin | BLD-O815 | Solaris Corporate | 815 Solar Ave | TX | 73301 | USA | SENS-0019 | Floor 8, East Wing | 2024-06-02T10:30:56Z | 32.7 | 10.2 | 15.1 | solar | office |
| LOG0020 | electricity | 200 | true | Miami | BLD-S101 | BlueBay Studio | 1 Ocean Dr | FL | blank | USA | SENS-0020 | Main Studio | 2024-06-02T11:15:33Z | 1060.3 | 920 | 880 | grid | other |
What the 120 rows show
from the 120-row sampleOther (sensor type) stands out: mean floor_
- 15%is_
anomaly = true - 3,700median floor_
area_ sqm - 5energy sources
- 5building types
- 11address countries
- 29address states
Median 3,700, from 60 to 70,000.
- string 13
- float 4
- datetime 1
- boolean 1
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 13 columns | |||
log_id | string | Unique identifier for each energy log entryunique | LOG0001 |
building_id | string | Unique identifier for the building where the sensor is deployed | BLD-A101 |
building_name | string | Name of the buildingoptional | Sunrise Center |
address_street | string | Street address of the buildingoptional | 101 Main Ave |
address_city | string | City where the building is located | New York |
address_state | string | State or province where the building is located | NY |
address_postal_code | string | Postal code of the buildingoptional | 10001 |
address_country | string | Country where the building is located11 countries | USA |
sensor_id | string | Unique identifier for the IoT sensor | SENS-0001 |
sensor_type | string | Type of sensor (e.g., electricity, water, gas, HVAC)electricity · water · gas · hvac · other | electricity |
sensor_location | string | Physical location of the sensor within the building (e.g., floor, room)optional | Floor 2, Room 204 |
energy_source | string | Primary energy source (e.g., grid, solar, wind, gas)grid · solar · wind · gas · other · optional | grid |
building_type | string | Type of commercial building (e.g., office, retail, hotel, hospital)office · retail · hotel · hospital · other · optional | office |
| Numbers 4 columns | |||
energy_consumption_kwh | float | Measured energy consumption in kilowatt-hours (kWh)0 or more | 34.6 |
peak_load_kw | float | Peak load measured in kilowatts (kW) during the logging period0 or more · optional | 12.3 |
co2_emissions_kg | float | Estimated CO2 emissions in kilograms for the logged energy consumption0 or more · optional | 15.8 |
floor_area_sqm | float | Total floor area of the building in square meters0 or more · optional | 2450 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the energy consumption was recorded | 2024-06-01T08:14:32Z |
| True or false 1 column | |||
is_anomaly | boolean | Indicates if the log entry is flagged as an anomaly (e.g., unusual consumption)optional | false |
Use it for
An energy dashboard
The is_
anomaly rate, floor_ area_ sqm by sensor_ type and a breakdown of address_ city. Excel, Power BI or Tableau. Why do the 11 other rows have a mean floor_
area_ sqm of 52,984? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs120LOG00012450electric…LOG000867000otherLOG0020200electric…
A software demo
Believable logs with building_
id, building_ name and address_ street to fill a screen in front of a buyer.
blueprint · urban-building-iot-energy-logs
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 19 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 row represents a unique building-day combination.
- Energy consumption values are collected hourly via certified IoT devices.
- Sensor anomalies (e.g., missing readings) are flagged and require manual review.
- Buildings must be registered with local smart infrastructure authorities.
- Energy usage is normalized per square meter for cross-building analysis.
- Only buildings with at least 90% sensor uptime per day are included.
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
- urban-building-iot-energy-logs