Urban Sensor Uptime Monitoring
This dataset provides detailed operational uptime, alert history, and location information for urban IoT sensors deployed by city governments. It enables city managers and IT teams to monitor sensor reliability, prioritize maintenance, and support smart city resilience planning through comprehensive benchmarking and alert tracking. The dataset is ideal for infrastructure analysis, predictive maintenance, and urban technology optimization.
Sample rows
preview · 8 of 120 rows · all 20 columns| sensor_idstring | statusstring | alert_countinteger | last_alert_typestring | sensor_typestring | location_latitudefloat | location_longitudefloat | installation_datedate | last_maintenance_datedate | uptime_percentagefloat | monitoring_period_startdate | monitoring_period_enddate | last_alert_timestampdatetime | citystring | districtstring | address_streetstring | postal_codestring | countrystring | manufacturerstring | firmware_versionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AQ-0001-NYC | online | 1 | low_battery | air_quality | 40.7128 | -74.006 | 2021-03-15 | 2024-02-20 | 98.4 | 2024-01-01 | 2024-06-01 | 2024-04-12T10:22:33 | New York | Manhattan | 5th Avenue | 10001 | USA | SensAirTech | v3.2.0 |
| NO-0002-LON | online | 2 | data_anomaly | noise | 51.5074 | -0.1278 | 2020-09-08 | 2023-11-30 | 94.7 | 2024-01-01 | 2024-06-01 | 2024-05-29T14:18:55 | London | Westminster | Regent Street | W1B 2EL | UK | NoisePro | 2.8.1 |
| TR-0003-TYO | online | 0 | blank | traffic | 35.6895 | 139.6917 | 2018-06-21 | 2024-01-18 | 99.3 | 2024-01-01 | 2024-06-01 | blank | Tokyo | Shinjuku | Yasukuni Dori | 160-0022 | Japan | TrafficFlow | v5.1.0 |
| WE-0004-BER | online | 1 | other | weather | 52.52 | 13.405 | 2019-11-30 | 2024-03-03 | 97.8 | 2024-01-01 | 2024-06-01 | 2024-03-07T07:41:12 | Berlin | Mitte | Unter den Linden | 10117 | Germany | WeatherWorks | 3.9.2 |
| AQ-0005-SF | online | 0 | blank | air_quality | 37.7749 | -122.4194 | 2023-03-20 | blank | 100 | 2024-05-01 | 2024-06-01 | blank | San Francisco | Mission | Valencia Street | 94110 | USA | SensAirTech | v4.0.0 |
| NO-0006-PAR | maintenance | 17 | maintenance_required | noise | 48.8566 | 2.3522 | 2017-05-15 | 2022-12-28 | 45.2 | 2024-01-01 | 2024-06-01 | 2024-02-15T15:34:20 | Paris | Montmartre | Rue Lepic | 75018 | France | NoisePro | 2.3.7-beta |
| TR-0007-MEX | offline | 22 | offline | traffic | 19.4326 | -99.1332 | 2016-12-05 | 2023-09-11 | 59.9 | 2024-01-01 | 2024-06-01 | 2024-02-03T10:03:45 | Mexico City | Centro | Avenida Juárez | 06040 | Mexico | TrafficFlow | 4.4.2 |
| WE-0008-SYD | online | 2 | low_battery | weather | -33.8688 | 151.2093 | 2022-04-23 | 2024-02-12 | 96.1 | 2024-01-01 | 2024-06-01 | 2024-03-20T03:12:18 | Sydney | CBD | George Street | 2000 | Australia | WeatherWorks | v3.6.0 |
| OT-0009-ANC | retired | 14 | offline | other | 61.2181 | -149.9003 | 2016-12-20 | blank | 5.1 | 2024-01-01 | 2024-06-01 | 2024-01-03T04:01:21 | Anchorage | blank | blank | blank | USA | PolarSense | 1.0.1 |
| AQ-0010-BOM | online | 0 | blank | air_quality | 19.076 | 72.8777 | 2021-08-29 | 2023-10-10 | 99.7 | 2024-01-01 | 2024-06-01 | blank | Mumbai | Andheri | SV Road | 400053 | India | AirGuard | v2.9.5 |
| NO-0011-JHB | maintenance | 5 | maintenance_required | noise | -26.2041 | 28.0473 | 2019-02-15 | 2023-12-10 | 83.2 | 2024-01-01 | 2024-06-01 | 2024-04-19T18:29:55 | Johannesburg | Sandton | Maude Street | 2196 | South Africa | NoisePro | 2.7.0 |
| TR-0012-IST | online | 1 | other | traffic | 41.0082 | 28.9784 | 2018-09-10 | 2024-01-10 | 97.1 | 2024-01-01 | 2024-06-01 | 2024-03-22T09:15:42 | Istanbul | Fatih | Divan Yolu Cd. | 34091 | Turkey | TrafficFlow | 4.7.3 |
| WE-0013-DEL | online | 0 | blank | weather | 28.6139 | 77.209 | 2022-08-01 | 2023-12-20 | 95.5 | 2024-01-01 | 2024-06-01 | blank | Delhi | Connaught Place | Janpath | 110001 | India | WeatherWorks | v3.7.1 |
| OT-0014-NUK | retired | 11 | offline | other | 64.1835 | -51.7216 | 2017-10-05 | blank | 9.8 | 2024-01-01 | 2024-06-01 | 2024-01-04T02:14:07 | Nuuk | blank | blank | blank | Greenland | PolarSense | 1.0.3 |
| AQ-0015-CHI | online | 0 | blank | air_quality | 41.8781 | -87.6298 | 2022-06-10 | 2024-02-14 | 99.6 | 2024-01-01 | 2024-06-01 | blank | Chicago | Loop | State Street | 60601 | USA | SensAirTech | v3.4.1 |
| NO-0016-BRU | online | 1 | other | noise | 50.8503 | 4.3517 | 2021-11-09 | 2024-01-25 | 97.9 | 2024-01-01 | 2024-06-01 | 2024-02-09T14:48:05 | Brussels | Ixelles | Avenue Louise | 1050 | Belgium | NoisePro | 2.9.0 |
| TR-0017-MAD | offline | 26 | data_anomaly | traffic | 40.4168 | -3.7038 | 2016-12-12 | 2023-07-19 | 25.1 | 2024-01-01 | 2024-06-01 | 2024-02-01T22:44:15 | Madrid | Centro | Gran Via | 28013 | Spain | TrafficFlow | 4.1.0-alpha |
| WE-0018-AMS | online | 1 | low_battery | weather | 52.3676 | 4.9041 | 2019-09-27 | 2023-11-23 | 96.8 | 2024-01-01 | 2024-06-01 | 2024-04-15T13:21:09 | Amsterdam | De Pijp | Ferdinand Bolstraat | 1072 | Netherlands | WeatherWorks | v3.5.7 |
| OT-0019-YVR | maintenance | 19 | maintenance_required | other | 49.2827 | -123.1207 | 2018-05-18 | blank | 54.7 | 2024-01-01 | 2024-06-01 | 2024-01-29T04:17:03 | Vancouver | Downtown | Robson Street | V6E 1C7 | Canada | SensorPlus | 2.3.4 |
| AQ-0020-ROM | online | 0 | blank | air_quality | 41.9028 | 12.4964 | 2023-10-01 | blank | 100 | 2024-04-01 | 2024-06-01 | blank | Rome | Trastevere | Viale di Trastevere | 00153 | Italy | AirGuard | v3.3.2 |
What the 120 rows show
from the 120-row sampleOffline status stands out: mean alert_
- 1median alert_
count - 5sensor types
- 31manufacturers
- 97.0median uptime_
percentage
Median 1, from 0 to 27.
- string 11
- integer 1
- float 3
- date 4
- datetime 1
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 11 columns | |||
sensor_id | string | Unique identifier for each IoT sensor deviceunique | AQ-0001-NYC |
sensor_type | string | Type of sensor (e.g., air quality, noise, traffic, weather)air_quality · noise · traffic · weather · other | air_quality |
last_alert_type | string | Type of the most recent alert (e.g., offline, low battery, data anomaly, maintenance required)5 values · optional | low_battery |
status | string | Current operational status of the sensoronline · offline · maintenance · retired | online |
city | string | City where the sensor is deployed | New York |
district | string | Administrative district or neighborhood within the cityoptional | Manhattan |
address_street | string | Street address of the sensor's locationoptional | 5th Avenue |
postal_code | string | Postal code of the sensor's locationoptional | 10001 |
country | string | Country where the sensor is located | USA |
manufacturer | string | Name of the sensor's manufactureroptional | SensAirTech |
firmware_version | string | Current firmware version installed on the sensoroptional | v3.2.0 |
| Numbers 4 columns | |||
location_latitude | float | Latitude coordinate of the sensor's location-90 to 90 | 40.7128 |
location_longitude | float | Longitude coordinate of the sensor's location-180 to 180 | -74.006 |
uptime_percentage | float | Percentage of time the sensor has been operational over the monitoring period (0-100)0 to 100 | 98.4 |
alert_count | integer | Total number of operational alerts generated by the sensor during the monitoring period0 or more | 1 |
| Dates and times 5 columns | |||
installation_date | date | Date the sensor was installed | 2021-03-15 |
last_maintenance_date | date | Date of the most recent maintenance performed on the sensoroptional | 2024-02-20 |
monitoring_period_start | date | Start date of the monitoring period for uptime calculation | 2024-01-01 |
monitoring_period_end | date | End date of the monitoring period for uptime calculation | 2024-06-01 |
last_alert_timestamp | datetime | Timestamp of the most recent alert triggered by the sensoroptional | 2024-04-12T10:22:33 |
Use it for
A government dashboard
Alert_
count by status and a breakdown of last_ alert_ type. Excel, Power BI or Tableau. Why do the 14 offline rows have a mean alert_
count of 19.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sensors120AQ-0001-NYC1onlineNO-0002-LON2onlineTR-0003-TYO0online
A software demo
Believable sensors with sensor_
type, location_ latitude and location_ longitude to fill a screen in front of a buyer.
This dataset120 rows20 columns
Yours1,000 rows20 columnslocation_latitude: UK only
blueprint · urban-sensor-uptime-monitoring
Behind this dataset
Same schema. As many rows as you need.
These 120 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
- Logs every sensor status update (active/inactive/alert) per hour.
- Includes sensor type, location code, and maintenance date.
- Alerts must specify cause (power, network, hardware, external event).
- Uptime calculated as percent per device per week.
- Flag sensors below 95% weekly uptime for review.
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
- urban-sensor-uptime-monitoring