IoT-Enabled Office Energy Logs
This dataset provides detailed, time-stamped energy usage logs from IoT sensors deployed throughout office buildings, capturing electricity consumption, power demand, occupancy, and environmental conditions at a granular level. It enables comprehensive analysis for optimizing energy efficiency, monitoring building performance, and supporting sustainability initiatives in smart office environments.
Sample rows
preview · 8 of 200 rows · all 16 columns| log_idstring | sensor_typestring | temperature_celsiusfloat | occupancy_statusboolean | zone_namestring | timestampdatetime | sensor_idstring | device_idstring | zone_idstring | floorinteger | building_idstring | energy_consumption_kwhfloat | power_demand_kwfloat | humidity_percentfloat | co2_ppmfloat | sensor_statusstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| log001 | electricity | 21.2 | true | Reception Area | 2024-05-01T08:16:23Z | SEN-ELEC-001 | DV-PRINTER-01 | Z-101 | 1 | BLD-NYC-001 | 0.15 | 0.06 | 40.5 | 450 | active |
| log002 | hvac | 22.9 | false | Large Meeting Room | 2024-05-01T09:03:15Z | SEN-HVAC-002 | DV-HVAC-02 | Z-210 | 2 | BLD-NYC-001 | 10.8 | 2.1 | 55.2 | 700 | active |
| log003 | lighting | 16.5 | blank | Exterior Entry | 2024-05-01T10:20:41Z | SEN-LIGHT-003 | DV-LIGHT-03 | Z-EXT | 0 | BLD-NYC-001 | 0.03 | 0.02 | 46.1 | 402 | active |
| log004 | occupancy | 24.7 | true | Open Workspace | 2024-05-01T11:02:55Z | SEN-OCC-004 | blank | Z-318 | 3 | BLD-NYC-001 | 0 | blank | 39.8 | 665 | active |
| log005 | plug_load | 23.5 | false | IT Room | 2024-05-01T12:07:12Z | SEN-PLUG-005 | DV-MONITOR-05 | Z-105 | 1 | BLD-NYC-001 | 0.43 | 0.13 | 41.2 | 430 | active |
| log006 | hvac | 25.3 | true | Open Workspace | 2024-05-01T13:18:26Z | SEN-HVAC-006 | DV-HVAC-06 | Z-318 | 3 | BLD-NYC-001 | 8.5 | 1.8 | 52 | 690 | active |
| log007 | lighting | 15.8 | blank | Exterior Entry | 2024-05-01T14:24:09Z | SEN-LIGHT-007 | blank | Z-EXT | 0 | BLD-NYC-001 | 0.02 | 0.02 | 40.4 | 407 | active |
| log008 | occupancy | 23.4 | false | Large Meeting Room | 2024-05-01T15:35:32Z | SEN-OCC-008 | blank | Z-210 | 2 | BLD-NYC-001 | 0 | blank | 45.7 | 555 | active |
| log009 | hvac | 22.2 | false | IT Room | 2024-05-01T16:42:10Z | SEN-HVAC-009 | DV-HVAC-09 | Z-105 | 1 | BLD-NYC-001 | 12.3 | 2.5 | 60.1 | 700 | active |
| log010 | electricity | 60 | false | Testing Zone | 2024-05-01T17:55:28Z | SEN-ELEC-010 | DV-UPS-10 | Z-999 | 99 | BLD-ATL-003 | 1000 | 250 | 0 | 5000 | error |
| log011 | lighting | 13.2 | blank | Basement Hall | 2024-05-02T08:11:45Z | SEN-LIGHT-011 | DV-LIGHT-11 | Z-B101 | 0 | BLD-NYC-001 | 0.04 | 0.03 | 55.8 | 399 | active |
| log012 | occupancy | 26.2 | true | Exterior Entry | 2024-05-02T09:19:58Z | SEN-OCC-012 | blank | Z-EXT | 0 | BLD-ATL-003 | 0 | blank | 48.3 | 402 | active |
| log013 | plug_load | 23 | true | Open Workspace | 2024-05-02T10:14:18Z | SEN-PLUG-013 | DV-LAPTOP-13 | Z-318 | 3 | BLD-NYC-001 | 0.33 | 0.11 | 39.3 | 410 | active |
| log014 | hvac | blank | false | Exterior Entry | 2024-05-02T11:20:29Z | SEN-HVAC-014 | blank | Z-EXT | 0 | BLD-HOU-005 | 0 | blank | blank | blank | inactive |
| log015 | lighting | blank | blank | IT Room | 2024-05-02T12:26:48Z | SEN-LIGHT-015 | blank | Z-105 | 1 | BLD-HOU-005 | 0 | 0 | blank | blank | inactive |
| log016 | occupancy | 24.1 | false | Large Meeting Room | 2024-05-02T13:05:39Z | SEN-OCC-016 | blank | Z-210 | 2 | BLD-NYC-001 | 0 | blank | 49 | 512 | active |
| log017 | hvac | 27.2 | true | Reception Area | 2024-05-02T14:18:11Z | SEN-HVAC-017 | DV-HVAC-17 | Z-101 | 1 | BLD-LON-007 | 15.1 | 3.1 | 61.2 | 995 | active |
| log018 | lighting | 10.4 | blank | Basement Hall | 2024-05-02T15:10:29Z | SEN-LIGHT-018 | DV-LIGHT-18 | Z-B101 | 0 | BLD-LON-007 | 0.05 | 0.05 | 99.9 | 399 | active |
| log019 | occupancy | 31.2 | true | Open Workspace | 2024-05-02T16:14:31Z | SEN-OCC-019 | blank | Z-318 | 3 | BLD-LON-007 | 0 | blank | 58.5 | 432 | active |
| log020 | electricity | blank | blank | Testing Zone | 2024-05-02T17:05:45Z | SEN-ELEC-020 | DV-WATER-20 | Z-999 | 99 | BLD-CHI-008 | 99.99 | 15.2 | blank | blank | maintenance |
What the 200 rows show
from the 200-row sampleLighting (sensor type) stands out: mean temperature_
- 38%occupancy_
status = true - 22.2median temperature_
celsius - 4sensor statuses
- 12zones
- 19buildings
- 1median floor
Median 22.2, from 10.4 to 60.0.
- string 8
- integer 1
- float 5
- datetime 1
- boolean 1
Columns
16 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
log_id | string | Unique identifier for each energy usage log entryunique | log001 |
sensor_id | string | Unique identifier for the IoT sensor that recorded the data | SEN-ELEC-001 |
sensor_type | string | Type of sensor (e.g., electricity, HVAC, lighting, occupancy)6 values | electricity |
device_id | string | Identifier for the device or appliance being monitored, if applicableoptional | DV-PRINTER-01 |
zone_id | string | Identifier for the office zone, room, or area where the sensor is located12 zones | Z-101 |
zone_name | string | Human-readable name for the office zone or areaoptional | Reception Area |
building_id | string | Identifier for the building in which the sensor is installed | BLD-NYC-001 |
sensor_status | string | Operational status of the sensor at the time of loggingactive · inactive · error · maintenance · optional | active |
| Numbers 6 columns | |||
floor | integer | Floor number where the sensor is located0 or more · optional | 1 |
energy_consumption_kwh | float | Amount of energy consumed in kilowatt-hours (kWh) during the log interval0 or more | 0.15 |
power_demand_kw | float | Instantaneous power demand in kilowatts (kW) at the time of logging0 or more · optional | 0.06 |
temperature_celsius | float | Ambient temperature in degrees Celsius at the time of loggingoptional | 21.2 |
humidity_percent | float | Relative humidity percentage at the time of logging0 to 100 · optional | 40.5 |
co2_ppm | float | CO2 concentration in parts per million (ppm) at the time of logging0 or more · optional | 450 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the energy usage was recorded | 2024-05-01T08:16:23Z |
| True or false 1 column | |||
occupancy_status | boolean | Whether the zone was occupied (true) or unoccupied (false) at the time of loggingoptional | true |
Use it for
An energy dashboard
The occupancy_
status rate, temperature_ celsius by sensor_ type and a breakdown of zone_ name. Excel, Power BI or Tableau. Why do the 38 lighting rows have a mean temperature_
celsius of 15.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs200log00121.2electric…log00222.9hvaclog00424.7occupancy
A software demo
Believable logs with timestamp, sensor_
id and sensor_ type to fill a screen in front of a buyer.
blueprint · iot-enabled-office-energy-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 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.
- Hourly readings per sensor ID
- Include device location and type
- Anomalies flagged for >200% increase
- Data gaps patched with interpolation
- Building IDs anonymized
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
- iot-enabled-office-energy-logs