Smart Park Device Uptime Log
This dataset provides detailed logs of IoT device uptime, usage events, downtime causes, and maintenance interventions across public parks, enabling city managers and urban planners to optimize maintenance schedules, reduce device failures, and enhance visitor experience. Each entry includes device location, operational status, event counts, and intervention details for comprehensive operational oversight.
Sample rows
preview · 8 of 121 rows · all 18 columns| log_idstring | device_typestring | usage_event_countinteger | operator_idstring | device_idstring | park_idstring | park_namestring | location_latitudefloat | location_longitudefloat | statusstring | status_timestampdatetime | uptime_duration_minutesinteger | last_downtime_startdatetime | last_downtime_enddatetime | downtime_causestring | maintenance_interventionstring | maintenance_timestampdatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A8X3-1KF | sensor | 89 | TECH-01 | SEN-4321 | PARK-01 | Central Green | 40.785091 | -73.968285 | online | 2024-06-01T09:03:21Z | 2345 | 2024-05-27T13:11:19Z | 2024-05-27T15:18:44Z | network-issue | reset | 2024-05-27T15:30:00Z | Device recovered from network outage after technician reset. |
| B1Q8-7HP | camera | 0 | TECH-02 | CAM-1145 | PARK-02 | Willow Creek Park | 34.052235 | -118.243683 | maintenance | 2024-06-02T12:22:16Z | 0 | 2024-06-02T08:00:00Z | 2024-06-02T08:30:00Z | scheduled-maintenance | firmware-update | 2024-06-02T11:00:00Z | Routine firmware update and calibration completed. |
| D7L2-3NV | lighting | 3200 | blank | LGT-6678 | PARK-03 | Liberty Park | 41.878113 | -87.629799 | online | 2024-06-03T18:41:19Z | 120042 | 2024-05-30T17:00:00Z | 2024-05-30T18:10:00Z | scheduled-maintenance | none | blank | Lighting system has had remarkable uptime since last update. |
| E5M9-2JF | environmental-monitor | blank | TECH-03 | ENV-8453 | PARK-01 | Central Green | 40.785091 | -73.968285 | error | 2024-06-04T07:09:50Z | blank | 2024-06-04T06:30:00Z | blank | software-error | reset | 2024-06-04T07:00:00Z | Monitor entered error state due to software malfunction. Reset performed. |
| F6S1-4QG | access-control | 0 | blank | ACC-2001 | PARK-04 | Oakridge Commons | 37.774929 | -122.419416 | offline | 2024-06-05T11:15:37Z | 0 | 2024-06-05T07:30:00Z | blank | network-issue | reset | blank | Access control offline due to network connectivity loss, awaiting technician. |
| G2K7-5NC | sensor | 70 | TECH-04 | SEN-0432 | PARK-05 | Riverfront Plaza | 35.227087 | -80.843127 | online | 2024-06-06T08:45:12Z | 1540 | 2024-05-31T14:10:00Z | 2024-05-31T15:05:00Z | hardware-failure | repair | 2024-05-31T15:30:00Z | Sensor repaired after hardware issue. Functionality restored. |
| H4B9-6PQ | camera | 0 | TECH-05 | CAM-2789 | PARK-06 | Heritage Fields | 39.739236 | -104.990251 | maintenance | 2024-06-07T16:55:32Z | 0 | 2024-06-07T12:40:00Z | 2024-06-07T13:00:00Z | scheduled-maintenance | inspection | 2024-06-07T14:00:00Z | Camera scheduled for lens cleaning and system inspection. |
| I8U2-7WR | lighting | 9520 | blank | LGT-3221 | PARK-02 | Willow Creek Park | 34.052235 | -118.243683 | online | 2024-06-08T22:17:11Z | 201231 | 2024-06-04T21:00:00Z | 2024-06-04T22:10:00Z | power-outage | none | blank | Lighting online; last downtime caused by brief power outage. |
| J5D3-2UZ | environmental-monitor | blank | TECH-06 | ENV-0524 | PARK-03 | Liberty Park | 41.878113 | -87.629799 | error | 2024-06-09T05:05:08Z | blank | 2024-06-09T04:30:00Z | blank | hardware-failure | replacement | 2024-06-09T04:50:00Z | Environmental monitor replaced due to hardware failure. |
| K3V5-1LM | access-control | 29 | TECH-07 | ACC-9246 | PARK-07 | Summit Gardens | 36.169941 | -115.13983 | online | 2024-06-10T13:31:26Z | 48 | 2024-06-09T22:00:00Z | 2024-06-10T12:40:00Z | unknown | inspection | 2024-06-10T13:00:00Z | Inspection performed after unexplained downtime. |
| L9S3-8QP | sensor | 112 | TECH-08 | SEN-5559 | PARK-08 | Magnolia Park | 30.267153 | -97.743057 | online | 2024-06-11T17:51:19Z | 4012 | 2024-06-08T10:15:00Z | 2024-06-08T11:00:00Z | network-issue | reset | 2024-06-08T11:30:00Z | Sensor reset following intermittent network disruptions. |
| M2T4-6DR | camera | 0 | TECH-09 | CAM-7712 | PARK-09 | Harbor Vista | 47.606209 | -122.332069 | maintenance | 2024-06-12T20:18:09Z | 0 | 2024-06-12T16:30:00Z | 2024-06-12T17:05:00Z | scheduled-maintenance | inspection | 2024-06-12T18:00:00Z | Scheduled inspection for camera lens and housing. |
| N7C6-5EV | lighting | 620 | TECH-10 | LGT-1243 | PARK-04 | Oakridge Commons | 37.774929 | -122.419416 | online | 2024-06-13T07:12:15Z | 87000 | 2024-06-12T05:10:00Z | 2024-06-12T06:00:00Z | hardware-failure | repair | 2024-06-12T06:30:00Z | Lighting system repaired after hardware malfunction. |
| O8P2-9YR | environmental-monitor | blank | TECH-11 | ENV-6142 | PARK-05 | Riverfront Plaza | 35.227087 | -80.843127 | error | 2024-06-14T11:37:50Z | blank | 2024-06-14T10:50:00Z | blank | software-error | reset | 2024-06-14T11:20:00Z | Environmental monitor experiencing repeated software errors. |
| P1A3-6GB | access-control | 0 | blank | ACC-3758 | PARK-06 | Heritage Fields | 39.739236 | -104.990251 | offline | 2024-06-15T14:23:27Z | 0 | 2024-06-15T10:00:00Z | blank | power-outage | inspection | blank | Access control offline due to power outage. Awaiting inspection. |
| Q4F7-3KB | sensor | 85 | TECH-12 | SEN-3942 | PARK-10 | Cypress Meadow | 29.760427 | -95.369803 | online | 2024-06-16T10:13:51Z | 3525 | 2024-06-15T03:00:00Z | 2024-06-15T03:50:00Z | hardware-failure | repair | 2024-06-15T04:30:00Z | Sensor was offline for hardware repair and returned to service. |
| R6H2-8LV | camera | 0 | TECH-13 | CAM-3190 | PARK-07 | Summit Gardens | 36.169941 | -115.13983 | maintenance | 2024-06-17T16:44:41Z | 0 | 2024-06-17T11:30:00Z | 2024-06-17T12:15:00Z | scheduled-maintenance | firmware-update | 2024-06-17T14:00:00Z | Firmware updated during scheduled camera maintenance. |
| S2D8-5JK | lighting | 6218 | blank | LGT-8041 | PARK-08 | Magnolia Park | 30.267153 | -97.743057 | online | 2024-06-18T19:59:11Z | 184023 | 2024-06-15T20:00:00Z | 2024-06-15T23:30:00Z | power-outage | none | blank | Long uptime; last interruption caused by power outage. |
| T3M1-9BE | environmental-monitor | blank | TECH-14 | ENV-2095 | PARK-09 | Harbor Vista | 47.606209 | -122.332069 | error | 2024-06-19T04:26:43Z | blank | 2024-06-19T03:45:00Z | blank | hardware-failure | replacement | 2024-06-19T04:10:00Z | Monitor replaced after repeated hardware failures. |
| U5K4-1XC | access-control | 13 | TECH-15 | ACC-7920 | PARK-10 | Cypress Meadow | 29.760427 | -95.369803 | online | 2024-06-20T13:43:22Z | 27 | 2024-06-20T09:20:00Z | 2024-06-20T09:50:00Z | network-issue | reset | 2024-06-20T10:00:00Z | Reset performed following brief connectivity loss. |
What the 121 rows show
from the 121-row sampleLighting (device type) stands out: mean usage_
- 49median usage_
event_ count - 4statuses
- 6downtime causes
- 6maintenance interventions
- 1,540median uptime_
duration_ minutes
Median 49, from 0 to 9,999.
- string 10
- integer 2
- float 2
- datetime 4
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 10 columns | |||
log_id | string | Unique identifier for each uptime log entryunique | A8X3-1KF |
device_id | string | Unique identifier for the IoT device | SEN-4321 |
device_type | string | Type of IoT device (e.g., sensor, camera, lighting)6 values | sensor |
park_id | string | Unique identifier for the park where the device is located | PARK-01 |
park_name | string | Name of the public park | Central Green |
status | string | Current operational status of the deviceonline · offline · maintenance · error | online |
downtime_cause | string | Reason for the most recent downtime (e.g., hardware failure, network issue, scheduled maintenance)7 values · optional | network-issue |
maintenance_intervention | string | Type of maintenance performed during the last intervention7 values · optional | reset |
operator_id | string | Identifier for the technician or operator who performed maintenanceoptional | TECH-01 |
notes | string | Additional notes or comments related to the log entryoptional | Device recovered from net… |
| Numbers 4 columns | |||
location_latitude | float | Latitude coordinate of the device location in the park-90 to 90 | 40.785091 |
location_longitude | float | Longitude coordinate of the device location in the park-180 to 180 | -73.968285 |
uptime_duration_minutes | integer | Total minutes the device has been online since last downtime0 or more · optional | 2345 |
usage_event_count | integer | Number of usage events recorded since last status change0 or more · optional | 89 |
| Dates and times 4 columns | |||
status_timestamp | datetime | Timestamp when the current status was recorded | 2024-06-01T09:03:21Z |
last_downtime_start | datetime | Timestamp when the most recent downtime period beganoptional | 2024-05-27T13:11:19Z |
last_downtime_end | datetime | Timestamp when the most recent downtime period endedoptional | 2024-05-27T15:18:44Z |
maintenance_timestamp | datetime | Timestamp when the last maintenance intervention occurredoptional | 2024-05-27T15:30:00Z |
Use it for
A government dashboard
Usage_
event_ count by device_ type and a breakdown of operator_ id. Excel, Power BI or Tableau. Why do the 24 lighting rows have a mean usage_
event_ count of 5,547? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs121A8X3-1KF89sensorB1Q8-7HP0cameraD7L2-3NV3200lighting
A software demo
Believable logs with device_
id, device_ type and park_ id to fill a screen in front of a buyer.
This dataset121 rows18 columns
Yours1,000 rows18 columnslocation_latitude: UK only
blueprint · smart-park-device-uptime-log
Behind this dataset
Same schema. As many rows as you need.
These 121 rows came out of a blueprint — 18 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 device entry must include type, location, and unique ID.
- Downtime events require timestamp, duration, and cause classification.
- Maintenance interventions logged only if downtime exceeds 30 minutes.
- Usage events recorded hourly per device if active.
- Devices flagged for replacement after more than three critical faults in 30 days.
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
- smart-park-device-uptime-log