Urban Noise Sensor Reliability Log
This dataset provides detailed reliability logs for urban noise pollution sensors, including operational uptime, incident records, location data, and maintenance actions. It enables smart city managers and IoT teams to monitor sensor health, optimize maintenance schedules, and ensure continuous environmental monitoring for urban planning and public health initiatives.
Sample rows
preview · 8 of 75 rows · all 19 columns| log_idstring | maintenance_actionstring | incident_countinteger | resolvedboolean | incident_typestring | sensor_idstring | installation_datedate | last_maintenance_datedate | location_street_addressstring | location_citystring | location_statestring | location_postal_codestring | location_countrystring | uptime_hoursfloat | incident_severitystring | incident_datetimedatetime | resolution_datetimedatetime | maintenance_notesstring | incident_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A3K9J7L2 | firmware_update | 2 | true | sensor_error | SN-1001A | 2023-06-15 | 2024-05-10 | 125 Market St | San Francisco | CA | 94105 | USA | 712.5 | medium | 2024-05-08T14:20:00 | 2024-05-09T10:30:00 | Updated firmware to latest version. | Sensor intermittently failing to record data. |
| B7Q2D1F8 | cleaned_device | 0 | blank | blank | SN-1002B | 2022-10-21 | 2024-04-29 | 967 Canal Ave | Chicago | IL | 60607 | USA | 1052.7 | blank | blank | blank | Routine cleaning and calibration. | blank |
| L8Z3T6R1 | rebooted | 1 | true | connectivity_issue | SN-1003C | 2023-03-04 | 2024-03-16 | 240 Queen St | Toronto | ON | M5V 2B6 | Canada | 1307.8 | low | 2024-03-12T16:45:00 | 2024-03-12T17:30:00 | Rebooted gateway, connection restored. | Brief loss of wireless connection during rain. |
| P2W8U3F4 | blank | 0 | blank | blank | SN-1004D | 2024-01-08 | blank | 44 Broadway | New York | NY | 10007 | USA | 1891.6 | blank | blank | blank | blank | blank |
| V6C2N7H9 | other | 3 | false | environmental_damage | SN-1005E | 2022-11-19 | 2024-05-05 | 390 Pacific Ave | Seattle | WA | 98104 | USA | 548.2 | high | 2024-05-03T09:10:00 | blank | Temporary repairs performed; needs replacement. | Sensor casing cracked due to fallen branch. |
| T4E1B9K5 | rebooted | 1 | true | power_failure | SN-1006F | 2023-07-12 | 2024-02-06 | 12 King St E | Toronto | ON | M5C 1C3 | Canada | 1560.3 | critical | 2024-02-05T21:10:00 | 2024-02-06T08:20:00 | Power restored, system rebooted. | Complete power outage for 2 hours. |
| M3R9Q1V8 | cleaned_device | 0 | blank | blank | SN-1007G | 2022-09-27 | 2024-04-01 | 201 Main St | Vancouver | BC | V6A 2S5 | Canada | 1238.4 | blank | blank | blank | Device cleaned and humidity checked. | blank |
| X2V7O1A4 | blank | 0 | blank | blank | SN-1008H | 2023-12-03 | blank | 11 E Madison St | Chicago | IL | 60602 | USA | 987.3 | blank | blank | blank | blank | blank |
| S7Q6L2M3 | rebooted | 2 | true | power_failure | SN-1009I | 2024-02-14 | 2024-05-13 | 88 Granville St | Vancouver | BC | V6Z 1E3 | Canada | 265.1 | medium | 2024-05-12T18:12:00 | 2024-05-12T20:00:00 | Rebooted after power restored. | Short power cut, backup battery engaged. |
| K5J1V8D2 | firmware_update | 1 | true | sensor_error | SN-1010J | 2023-04-25 | 2024-03-11 | 73 Pine St | Seattle | WA | 98101 | USA | 1176.9 | low | 2024-03-06T13:05:00 | 2024-03-11T10:05:00 | Applied patch to improve accuracy. | Occasional false positive readings. |
| N8P3Z2F5 | cleaned_device | 0 | blank | blank | SN-1011K | 2022-12-15 | 2024-04-24 | 50 Queen St W | Toronto | ON | M5H 2N2 | Canada | 934.2 | blank | blank | blank | Filter cleaned, sensor recalibrated. | blank |
| W4D2A5Q8 | firmware_update | 1 | true | connectivity_issue | SN-1012L | 2023-09-09 | 2024-01-20 | 212 5th Ave | New York | NY | 10010 | USA | 1520.1 | medium | 2024-01-19T22:30:00 | 2024-01-20T09:00:00 | Firmware module patched. | Wi-Fi module failed intermittently. |
| H3F8C4K7 | cleaned_device | 0 | blank | blank | SN-1013M | 2023-05-01 | 2024-03-28 | 322 Clark Dr | Vancouver | BC | V5L 3E6 | Canada | 1284.6 | blank | blank | blank | Cleaned sensor and checked mounting. | blank |
| Z9S3L8V1 | blank | 0 | blank | blank | SN-1014N | 2024-03-18 | blank | 55 Wacker Dr | Chicago | IL | 60606 | USA | 412.7 | blank | blank | blank | blank | blank |
| E2P9N3J5 | other | 2 | false | sensor_error | SN-1015O | 2023-10-28 | 2024-04-10 | 148 2nd Ave | New York | NY | 10003 | USA | 1078.3 | high | 2024-04-09T12:45:00 | blank | Temporary fix applied, monitoring closely. | Sensor overheating repeatedly. |
| Q1D6T4F7 | cleaned_device | 1 | true | environmental_damage | SN-1016P | 2022-07-14 | 2024-02-23 | 7 E 42nd St | New York | NY | 10017 | USA | 1642.5 | medium | 2024-02-22T08:12:00 | 2024-02-23T15:00:00 | Cleaned filters and interior. | Dust buildup affecting readings. |
| R7B3F2W6 | cleaned_device | 0 | blank | blank | SN-1017Q | 2023-08-05 | 2024-03-30 | 234 Water St | Vancouver | BC | V6B 1B6 | Canada | 1523.8 | blank | blank | blank | Routine cleaning performed. | blank |
| Y8W1S4N9 | rebooted | 1 | true | connectivity_issue | SN-1018R | 2023-02-17 | 2024-01-08 | 99 King St W | Toronto | ON | M5X 1A1 | Canada | 1472.2 | low | 2024-01-07T22:52:00 | 2024-01-08T09:10:00 | System rebooted, upload normal. | Minor data upload delay. |
| U5M7Z2E1 | firmware_update | 0 | blank | blank | SN-1019S | 2023-05-19 | 2024-04-11 | 45 Michigan Ave | Chicago | IL | 60601 | USA | 1023.7 | blank | blank | blank | Version 6.2 installed. | blank |
| G3R1X9L4 | replaced_sensor | 3 | false | sensor_error | SN-1020T | 2023-11-21 | 2024-03-13 | 161 Bay St | Toronto | ON | M5J 2S1 | Canada | 1342.1 | critical | 2024-03-11T15:30:00 | blank | Replaced with new sensor unit. | Sensor failed calibration three times. |
What the 75 rows show
from the 75-row sampleCleaned_
- 82%resolved = true
- 1median incident_
count - 4location countries
- 4incident severities
- 13location states
- 14location cities
Median 1, from 0 to 4.
- string 12
- integer 1
- float 1
- date 2
- datetime 2
- boolean 1
Columns
19 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
log_id | string | Unique identifier for each reliability log entryunique | A3K9J7L2 |
sensor_id | string | Unique identifier for the noise sensor device | SN-1001A |
location_street_address | string | Street address where the sensor is installed | 125 Market St |
location_city | string | City where the sensor is installed | San Francisco |
location_state | string | State or province where the sensor is installed | CA |
location_postal_code | string | Postal code of the sensor's location | 94105 |
location_country | string | Country where the sensor is installed4 countries | USA |
incident_type | string | Type of incident encountered (e.g., power failure, sensor error, connectivity issue)5 values · optional | sensor_error |
incident_severity | string | Severity level of the incidentlow · medium · high · critical · optional | medium |
incident_description | string | Detailed description of the incidentoptional | Minor data upload delay. |
maintenance_action | string | Type of maintenance action taken (e.g., replaced sensor, firmware update, cleaned device)5 values · optional | firmware_update |
maintenance_notes | string | Additional notes or comments about maintenance actionsoptional | Firmware module patched. |
| Numbers 2 columns | |||
uptime_hours | float | Total operational hours recorded for the sensor since last maintenance0 or more | 712.5 |
incident_count | integer | Number of reliability incidents recorded for the sensor during the log period0 or more | 2 |
| Dates and times 4 columns | |||
installation_date | date | Date when the sensor was installed at its current location | 2023-06-15 |
last_maintenance_date | date | Date of the most recent maintenance performed on the sensoroptional | 2024-05-10 |
incident_datetime | datetime | Date and time when the incident occurredoptional | 2024-05-08T14:20:00 |
resolution_datetime | datetime | Date and time when the incident was resolvedoptional | 2024-05-09T10:30:00 |
| True or false 1 column | |||
resolved | boolean | Indicates whether the incident has been resolvedoptional | true |
Use it for
A technology dashboard
The resolved rate, incident_
count by maintenance_ action and a breakdown of incident_ type. Excel, Power BI or Tableau. Why do the 22 cleaned_
device rows have a mean incident_ count of 0.23? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs75A3K9J7L22firmware…L8Z3T6R11rebootedV6C2N7H93other
A software demo
Believable logs with sensor_
id, installation_ date and last_ maintenance_ date to fill a screen in front of a buyer.
blueprint · urban-noise-sensor-reliability-log
Behind this dataset
Same schema. As many rows as you need.
These 75 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 record represents a unique sensor for a specific day.
- Device status must be one of: Operational, Partial Outage, Full Outage.
- Incident field logs noise threshold breaches or sensor malfunctions.
- Maintenance response time (in hours) is recorded when incidents occur.
- Includes sensor location type: School Zone, Residential, Commercial, Park, or Industrial.
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-noise-sensor-reliability-log