Government IoT Sensor Maintenance Logs
This dataset provides detailed logs of operational status and maintenance activities for municipal IoT sensors deployed in smart city infrastructure. It includes sensor location, type, maintenance history, downtime, costs, and responsible teams, enabling public sector organizations to optimize asset uptime, prioritize repairs, and support budgeting and reliability analysis.
Sample rows
preview · 8 of 86 rows · all 20 columns| log_idstring | maintenance_typestring | maintenance_costfloat | priority_levelstring | sensor_idstring | sensor_typestring | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring | installation_datedate | operational_statusstring | last_maintenance_datedate | maintenance_descriptionstring | maintenance_teamstring | downtime_minutesinteger | failure_reasonstring | next_scheduled_maintenancedate | asset_owner_departmentstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LOG-10001 | scheduled | 120.5 | medium | SENS-AQ-001 | air_quality | 101 Maple Ave | Springfield | IL | 62704 | USA | 2019-03-12 | active | 2024-03-14 | Quarterly filter replacement. | EnviroOps | 0 | blank | 2024-06-10 | Environmental Services |
| LOG-10002 | emergency | 375.75 | high | SENS-TR-017 | traffic | 55 Lincoln St | Madison | WI | 53703 | USA | 2020-10-01 | maintenance | 2024-04-21 | Replaced malfunctioning camera. | TrafficTech | 180 | Camera sensor failure. | 2024-07-21 | Transportation |
| LOG-10003 | scheduled | 90 | medium | SENS-NO-005 | noise | 200 Elm St | Cleveland | OH | 44114 | USA | 2018-07-25 | inactive | 2024-02-15 | Battery replacement and calibration. | UrbanSound | 240 | Low battery voltage. | 2024-08-15 | Public Safety |
| LOG-10004 | emergency | 670.2 | critical | SENS-WL-022 | water_level | 820 River Rd | Des Moines | IA | 50309 | USA | 2017-11-03 | faulty | 2024-05-02 | Sensor replaced after hardware failure. | FloodWatch | 480 | PCB short circuit. | 2024-09-02 | Water Management |
| LOG-10005 | inspection | blank | low | SENS-WTH-008 | weather | 12 Pine Crescent | Portland | OR | 97201 | USA | 2021-06-14 | active | 2024-03-08 | Routine annual inspection. | SkyGrid | 0 | blank | 2025-03-08 | Meteorology |
| LOG-10006 | scheduled | 124.6 | medium | SENS-AQ-002 | air_quality | 305 Oak Blvd | Madison | WI | 53703 | USA | 2018-04-28 | maintenance | 2024-04-19 | Filter replacement and software update. | EnviroOps | 60 | Sensor error log detected. | 2024-07-19 | Environmental Services |
| LOG-10007 | scheduled | 210.4 | medium | SENS-TR-018 | traffic | 123 Main St | Springfield | IL | 62704 | USA | 2020-02-10 | active | 2024-03-11 | Firmware updated for improved detection. | TrafficTech | 0 | blank | 2024-09-11 | Transportation |
| LOG-10008 | inspection | blank | low | SENS-NO-006 | noise | 654 Vine Ave | Portland | OR | 97201 | USA | 2019-08-30 | active | 2024-05-07 | Microphone quality checked. | UrbanSound | 0 | blank | 2025-05-07 | Public Safety |
| LOG-10009 | emergency | 445.1 | high | SENS-WTH-009 | weather | 88 Birch St | Des Moines | IA | 50309 | USA | 2017-09-21 | inactive | 2024-03-30 | Repaired damaged wind sensor. | SkyGrid | 360 | Wind sensor jammed. | 2024-09-30 | Meteorology |
| LOG-10010 | upgrade | 200 | low | SENS-WL-023 | water_level | 940 Lake Shore Dr | Cleveland | OH | 44114 | USA | 2016-10-19 | decommissioned | 2023-12-05 | Final data backup before decommission. | FloodWatch | 0 | End of service life. | blank | Water Management |
| LOG-10011 | inspection | blank | low | SENS-OTH-003 | other | 341 Market St | Madison | WI | 53703 | USA | 2020-04-17 | active | 2024-05-06 | General operational check. | TechOps | 0 | blank | 2025-05-06 | IT Services |
| LOG-10012 | emergency | 160 | high | SENS-AQ-003 | air_quality | 51 Walnut St | Des Moines | IA | 50309 | USA | 2018-02-11 | inactive | 2024-04-02 | Emergency filter replacement due to clog. | EnviroOps | 120 | Filter clog detected. | 2024-07-02 | Environmental Services |
| LOG-10013 | scheduled | 70.2 | medium | SENS-NO-007 | noise | 790 Cedar Rd | Portland | OR | 97201 | USA | 2019-01-19 | maintenance | 2024-04-17 | Replaced aging microphone. | UrbanSound | 45 | Microphone signal loss. | 2024-07-17 | Public Safety |
| LOG-10014 | emergency | 545.8 | critical | SENS-TR-019 | traffic | 23 Oak St | Cleveland | OH | 44114 | USA | 2021-05-12 | faulty | 2024-05-01 | Sensor replaced after electrical short. | TrafficTech | 275 | Electrical short. | 2024-08-01 | Transportation |
| LOG-10015 | scheduled | 95.3 | medium | SENS-WTH-010 | weather | 14 Willow Ave | Springfield | IL | 62704 | USA | 2017-05-07 | active | 2024-04-13 | Rain gauge calibration. | SkyGrid | 0 | blank | 2024-07-13 | Meteorology |
| LOG-10016 | inspection | blank | low | SENS-WL-024 | water_level | 212 Canal St | Madison | WI | 53703 | USA | 2016-08-14 | active | 2024-05-10 | Inspection for spring flooding risk. | FloodWatch | 0 | blank | 2025-05-10 | Water Management |
| LOG-10017 | scheduled | 60 | medium | SENS-OTH-004 | other | 580 Ash St | Des Moines | IA | 50309 | USA | 2020-12-11 | active | 2024-03-22 | Software upgrade applied. | TechOps | 0 | blank | 2024-09-22 | IT Services |
| LOG-10018 | scheduled | 80.25 | medium | SENS-NO-008 | noise | 44 Chestnut St | Springfield | IL | 62704 | USA | 2018-03-09 | maintenance | 2024-04-12 | Amplifier replaced. | UrbanSound | 75 | Amplifier malfunction. | 2024-07-12 | Public Safety |
| LOG-10019 | emergency | 295 | high | SENS-WTH-011 | weather | 775 Spruce St | Cleveland | OH | 44114 | USA | 2016-12-22 | inactive | 2024-04-04 | Power supply replaced after outage. | SkyGrid | 405 | Power outage. | 2024-07-04 | Meteorology |
| LOG-10020 | scheduled | 180.9 | medium | SENS-TR-020 | traffic | 99 King St | Madison | WI | 53703 | USA | 2019-09-02 | active | 2024-04-15 | LED signal lamp replaced. | TrafficTech | 0 | blank | 2024-10-15 | Transportation |
What the 86 rows show
from the 86-row sampleEmergency (maintenance type) stands out: mean maintenance_
- 97.7median maintenance_
cost - 2location countries
- 5operational statuses
- 6sensor types
- 9asset owner departments
- 11location states
Median 97.7, from 20.0 to 670.2.
- string 15
- integer 1
- float 1
- date 3
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
log_id | string | Unique identifier for each maintenance log entryunique | LOG-10001 |
sensor_id | string | Unique identifier for each IoT sensor device | SENS-AQ-001 |
sensor_type | string | Type or category of the sensor (e.g., air quality, traffic, noise)6 values | air_quality |
location_street_address | string | Street address where the sensor is installed | 101 Maple Ave |
location_city | string | City where the sensor is installed | Springfield |
location_state | string | State or region where the sensor is installed11 states | IL |
location_postal_code | string | Postal code of the sensor's location | 62704 |
location_country | string | Country where the sensor is installed2 countries | USA |
operational_status | string | Current operational status of the sensoractive · inactive · faulty · maintenance · decommissioned | active |
maintenance_type | string | Type of maintenance performed (e.g., scheduled, emergency, upgrade)scheduled · emergency · upgrade · inspection · other · optional | scheduled |
maintenance_description | string | Detailed description of maintenance activity performedoptional | Rain gauge calibration. |
maintenance_team | string | Name or identifier of the team responsible for maintenanceoptional | EnviroOps |
failure_reason | string | Reason for sensor failure, if applicableoptional | Camera sensor failure. |
priority_level | string | Priority assigned to the maintenance activitylow · medium · high · critical · optional | medium |
asset_owner_department | string | Municipal department responsible for the sensor asset9 departments · optional | Environmental Services |
| Numbers 2 columns | |||
maintenance_cost | float | Cost incurred for the maintenance activity0 or more · optional | 120.5 |
downtime_minutes | integer | Total downtime in minutes due to sensor failure or maintenance0 or more · optional | 0 |
| Dates and times 3 columns | |||
installation_date | date | Date when the sensor was installed | 2019-03-12 |
last_maintenance_date | date | Date of the most recent maintenance activityoptional | 2024-03-14 |
next_scheduled_maintenance | date | Date for the next scheduled maintenance activityoptional | 2024-06-10 |
Use it for
A government dashboard
Maintenance_
cost by maintenance_ type and a breakdown of priority_ level. Excel, Power BI or Tableau. Why do the 17 emergency rows have a mean maintenance_
cost of 323.1? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs86LOG-10001120.5scheduledLOG-10002375.75emergencyLOG-1000390scheduled
A software demo
Believable logs with sensor_
id, sensor_ type and location_ street_ address to fill a screen in front of a buyer.
This dataset86 rows20 columns
Yours1,000 rows20 columnslocation_street_address: UK only
blueprint · government-iot-sensor-maintenance-logs
Behind this dataset
Same schema. As many rows as you need.
These 86 rows came out of a blueprint — 20 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 records a unique sensor with last maintenance date
- Status field must be one of: operational, needs repair, offline
- Maintenance type categorized: routine, emergency, upgrade
- Include reason for maintenance for non-routine visits
- Assign responsible technician by unique staff ID
- Downtime in hours calculated for each incident
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-iot-sensor-maintenance-logs