Municipal Edge Sensor Health Metrics
This dataset provides comprehensive health and performance metrics for edge IoT sensors deployed across smart city infrastructure. It includes device status, uptime, maintenance history, error logs, and location data, enabling city technology teams to monitor sensor reliability, anticipate maintenance needs, and optimize municipal operations. The dataset is ideal for predictive maintenance, compliance auditing, and resource planning in smart city environments.
Sample rows
preview · 8 of 120 rows · all 18 columns| sensor_idstring | health_statusstring | signal_strength_dbmfloat | maintenance_requiredboolean | sensor_typestring | location_latitudefloat | location_longitudefloat | location_descriptionstring | installation_datedate | last_maintenance_datedate | uptime_percentage_30dfloat | last_reported_atdatetime | battery_levelfloat | error_codestring | firmware_versionstring | citystring | districtstring | error_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AQ-1001X | operational | -58.4 | false | air_quality | 35.6895 | 139.6917 | Tokyo Station North Entrance | 2022-03-12 | 2024-03-04 | 99.7 | 2024-06-10T11:15:00Z | 97.2 | blank | v2.3.1 | Tokyo | Chiyoda | blank |
| TR-1002B | operational | -62.7 | false | traffic | 51.5074 | -0.1278 | London Bridge South | 2021-11-07 | 2024-02-10 | 96.8 | 2024-06-09T19:45:00Z | 81.6 | blank | v2.1.5 | London | Southwark | blank |
| WD-1003C | operational | -59.3 | false | weather_station | 48.8566 | 2.3522 | Paris Riverbank Quai d'Orsay | 2023-01-21 | 2024-05-02 | 98.9 | 2024-06-10T00:30:00Z | 89.1 | blank | v2.2.4 | Paris | 7th Arrondissement | blank |
| SO-1004A | operational | -65.1 | false | soil_temperature | 40.7128 | -74.006 | NYC Central Park West | 2020-06-19 | 2024-01-12 | 97.3 | 2024-06-08T16:42:00Z | 85.4 | blank | v1.9.7 | New York | Manhattan | blank |
| HU-1005Q | operational | -69.5 | false | humidity | 52.52 | 13.405 | Berlin Alexanderplatz Square | 2022-07-08 | 2024-03-15 | 95.9 | 2024-06-10T06:05:00Z | 76.8 | blank | v2.0.2 | Berlin | Mitte | blank |
| FL-1006D | operational | -57.8 | false | flood_level | 41.9028 | 12.4964 | Rome Tiber Riverside Dock | 2021-09-23 | 2024-04-18 | 98.2 | 2024-06-09T22:10:00Z | 92.5 | blank | v2.1.9 | Rome | Trastevere | blank |
| TP-1007J | operational | -56.2 | false | temperature | 35.6762 | 139.6503 | Shibuya Crossing | 2023-06-02 | 2024-05-22 | 100 | 2024-06-10T13:55:00Z | 100 | blank | v2.4.3 | Tokyo | Shibuya | blank |
| AQ-1008Y | operational | -60.3 | false | air_quality | 55.7558 | 37.6173 | Moscow Red Square East | 2022-10-28 | 2024-04-29 | 98.6 | 2024-06-09T08:35:00Z | 94.1 | blank | v2.2.7 | Moscow | Tverskoy | blank |
| TR-1009K | operational | -66.7 | false | traffic | 19.4326 | -99.1332 | Mexico City Reforma Avenue | 2021-05-15 | 2024-03-12 | 97.8 | 2024-06-10T01:25:00Z | 87.3 | blank | v1.8.4 | Mexico City | Cuauhtémoc | blank |
| WD-1010S | operational | -59.8 | false | weather_station | 34.0522 | -118.2437 | LA Griffith Park Observatory | 2024-03-25 | 2024-05-29 | 99.1 | 2024-06-10T17:10:00Z | 93.8 | blank | v2.5.0 | Los Angeles | Hollywood | blank |
| SO-1011T | operational | -67.5 | false | soil_temperature | 37.7749 | -122.4194 | San Francisco Market St & 7th | 2022-02-16 | 2024-04-01 | 98.4 | 2024-06-09T10:20:00Z | 79.2 | blank | v2.1.3 | San Francisco | SoMa | blank |
| HU-1012E | operational | -64.3 | false | humidity | 31.2304 | 121.4737 | Shanghai Bund Waterfront | 2023-05-10 | 2024-04-14 | 96.4 | 2024-06-09T23:55:00Z | 83.6 | blank | v2.4.1 | Shanghai | Huangpu | blank |
| FL-1013F | operational | -65.9 | false | flood_level | 59.9343 | 30.3351 | St Petersburg Neva River Pier | 2021-03-12 | 2024-02-19 | 98.7 | 2024-06-08T15:33:00Z | 82.9 | blank | v1.9.2 | St Petersburg | Petrogradsky | blank |
| TP-1014G | operational | -69.8 | false | temperature | -33.8688 | 151.2093 | Sydney Opera House Steps | 2022-09-05 | 2024-03-09 | 95.7 | 2024-06-08T07:11:00Z | 77.9 | blank | v2.0.7 | Sydney | Circular Quay | blank |
| AQ-1015H | operational | -63.7 | false | air_quality | 28.6139 | 77.209 | Delhi Rajiv Chowk Metro | 2022-01-26 | 2024-03-17 | 97.9 | 2024-06-10T03:09:00Z | 86.3 | blank | v2.1.8 | Delhi | Connaught Place | blank |
| TR-1016M | operational | -61.5 | false | traffic | 39.9042 | 116.4074 | Beijing Tiananmen East | 2022-06-18 | 2024-04-24 | 98.1 | 2024-06-10T09:45:00Z | 90.5 | blank | v2.3.2 | Beijing | Dongcheng | blank |
| WD-1017N | operational | -57.6 | false | weather_station | 55.9533 | -3.1883 | Edinburgh Princes Street Park | 2023-08-09 | 2024-05-15 | 99.4 | 2024-06-10T18:25:00Z | 98.2 | blank | v2.5.2 | Edinburgh | New Town | blank |
| SO-1018P | operational | -68.2 | false | soil_temperature | 43.6532 | -79.3832 | Toronto City Hall Gardens | 2022-10-14 | 2024-04-20 | 97.1 | 2024-06-09T11:30:00Z | 80.6 | blank | v2.1.6 | Toronto | Old Toronto | blank |
| HU-1019V | operational | -67.4 | false | humidity | 35.2271 | -80.8431 | Charlotte Uptown Plaza | 2023-04-17 | 2024-05-05 | 96.6 | 2024-06-10T15:29:00Z | 79.8 | blank | v2.3.8 | Charlotte | Mecklenburg | blank |
| FL-1020W | operational | -66.1 | false | flood_level | 1.3521 | 103.8198 | Singapore Marina Bay Dock | 2021-12-20 | 2024-02-27 | 97.5 | 2024-06-09T05:40:00Z | 86.7 | blank | v1.9.9 | Singapore | Downtown Core | blank |
What the 120 rows show
from the 120-row sampleOffline (health status) stands out: mean signal_
- 46%maintenance_
required = true - -69.3median signal_
strength_ dbm - 95.9median uptime_
percentage_ 30d - 77.4median battery_
level
Every row with signal_
- string 9
- float 5
- date 2
- datetime 1
- boolean 1
Columns
18 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
sensor_id | string | Unique identifier for the edge IoT sensor deviceunique | AQ-1001X |
sensor_type | string | Type or model of the sensor (e.g., temperature, air quality, traffic)7 types | air_quality |
location_description | string | Human-readable description of the sensor's location (e.g., 'Main St & 3rd Ave traffic light')optional | London Bridge South |
health_status | string | Current health status of the sensoroperational · warning · faulty · offline · maintenance | operational |
error_code | string | Most recent error code reported by the sensor, if anyoptional | WARN-BATT |
error_description | string | Description of the most recent error, if anyoptional | Weather data sync issue. |
firmware_version | string | Current firmware version running on the sensoroptional | v2.3.1 |
city | string | City where the sensor is deployed | Tokyo |
district | string | Administrative district, neighborhood, or zone for the sensor locationoptional | Chiyoda |
| Numbers 5 columns | |||
location_latitude | float | Latitude coordinate of the sensor's physical deployment location-90 to 90 | 35.6895 |
location_longitude | float | Longitude coordinate of the sensor's physical deployment location-180 to 180 | 139.6917 |
uptime_percentage_30d | float | Percentage of time the sensor has been operational in the past 30 days (0-100)0 to 100 | 99.7 |
battery_level | float | Current battery level of the sensor as a percentage (0-100)0 to 100 · optional | 97.2 |
signal_strength_dbm | float | Current wireless signal strength in dBmoptional | -58.4 |
| Dates and times 3 columns | |||
installation_date | date | Date when the sensor was installed | 2022-03-12 |
last_maintenance_date | date | Date of the most recent maintenance performed on the sensoroptional | 2024-03-04 |
last_reported_at | datetime | Timestamp when the sensor last reported data | 2024-06-10T11:15:00Z |
| True or false 1 column | |||
maintenance_required | boolean | Indicates if the sensor requires maintenance | false |
Use it for
A government dashboard
The maintenance_
required rate, signal_ strength_ dbm by health_ status and a breakdown of sensor_ type. Excel, Power BI or Tableau. Why do the 12 offline rows have a mean signal_
strength_ dbm of -144.5? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sensors120AQ-1001X-58.4operatio…AQ-1029A-82.3warningTR-1030B-85warning
A software demo
Believable sensors with sensor_
type, location_ latitude and location_ longitude to fill a screen in front of a buyer.
This dataset120 rows18 columns
Yours10,000 rows18 columnslocation_latitude: UK only
blueprint · municipal-edge-sensor-health-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 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 row represents a unique sensor reading event.
- Status codes must reflect online, degraded, or offline.
- Maintenance flags are triggered after consecutive degraded readings.
- All sensors must be geo-tagged to city zones.
- Unusual readings automatically create incident logs.
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- municipal-edge-sensor-health-metrics