IoT Supply Chain Sensor Health
This dataset provides comprehensive, real-time monitoring of IoT sensor health across diverse supply chain assets, including operational status, maintenance records, health scoring, and digital twin synchronization. It empowers operations managers to anticipate failures, schedule predictive maintenance, and optimize asset reliability, ensuring minimal downtime and resilient supply chain operations.
Sample rows
preview · 8 of 120 rows · all 18 columns| sensor_idstring | sensor_statusstring | health_scorefloat | alert_typestring | asset_idstring | asset_typestring | location_latitudefloat | location_longitudefloat | sensor_typestring | last_communication_timedatetime | battery_levelfloat | signal_strengthfloat | last_maintenance_datedate | next_maintenance_duedate | firmware_versionstring | digital_twin_sync_statusstring | last_alert_timedatetime | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SENS0001 | active | 0.95 | blank | TRUCK001 | truck | 34.0522 | -118.2437 | temperature | 2024-06-08T09:15:23Z | 87.4 | -54.2 | 2024-05-10 | 2024-10-10 | 2.3.1 | synced | blank | Operating within normal parameters. |
| SENS0002 | maintenance_required | 0.32 | battery_low | TRUCK002 | truck | 29.7604 | -95.3698 | humidity | 2024-05-28T13:47:06Z | 14.8 | -80.4 | 2024-02-13 | 2024-06-13 | 1.7.4 | out_of_sync | 2024-05-29T08:16:42Z | Sensor scheduled for urgent maintenance. |
| SENS0003 | inactive | 0.65 | signal_loss | TRUCK003 | truck | 40.7128 | -74.006 | pressure | 2024-04-10T16:37:14Z | 48.2 | -68.6 | 2024-03-08 | 2024-07-08 | 1.8.2 | out_of_sync | 2024-04-12T13:38:21Z | Inactive due to route change. |
| SENS0004 | active | 0.99 | blank | WH001 | warehouse | blank | blank | vibration | 2024-06-07T15:41:02Z | 99.1 | -48.7 | blank | 2024-11-07 | 2.2.0 | synced | blank | Recently upgraded. |
| SENS0005 | active | 0.84 | blank | CONT001 | container | 51.5074 | -0.1278 | gps | 2024-06-08T10:22:17Z | 78.7 | -62.8 | 2024-04-18 | 2024-09-18 | 1.10.0 | synced | blank | blank |
| SENS0006 | active | 0.97 | blank | PAL001 | pallet | blank | blank | pressure | 2024-06-08T08:05:44Z | 96.2 | -50.5 | 2024-05-03 | 2024-11-03 | 2.1.2 | synced | blank | Recently upgraded. |
| SENS0007 | failed | 0.05 | hardware_failure | PAL002 | pallet | 48.8566 | 2.3522 | humidity | 2024-03-19T14:17:52Z | 1.4 | -92.3 | 2023-12-11 | 2024-02-11 | 1.2.3 | error | 2024-03-20T10:13:44Z | Sensor failed. Awaiting replacement. |
| SENS0008 | maintenance_required | 0.29 | maintenance_due | CONT002 | container | 35.6895 | 139.6917 | pressure | 2024-05-10T17:22:51Z | 10.5 | -81.7 | 2024-01-28 | 2024-06-28 | 1.6.1-beta | out_of_sync | 2024-05-12T11:45:34Z | Urgent maintenance needed due to low battery. |
| SENS0009 | active | 0.97 | blank | WH002 | warehouse | 37.7749 | -122.4194 | humidity | 2024-06-07T07:56:28Z | 92.6 | -47.9 | 2024-05-14 | 2024-10-14 | 2.0.4 | synced | blank | Operating within normal parameters. |
| SENS0010 | failed | 0.01 | hardware_failure | TRUCK004 | truck | 41.8781 | -87.6298 | vibration | 2024-04-01T11:45:06Z | 0 | -99.9 | 2023-11-15 | 2024-03-15 | 0.9.8 | error | 2024-04-02T09:21:18Z | Sensor failed. No response since last alert. |
| SENS0011 | active | 0.99 | blank | PAL003 | pallet | blank | blank | temperature | 2024-06-08T11:01:39Z | 98.8 | -46 | 2024-05-04 | 2024-11-04 | 2.2.2 | synced | blank | blank |
| SENS0012 | inactive | 0.63 | signal_loss | PAL004 | pallet | 52.52 | 13.405 | humidity | 2024-04-18T20:22:09Z | 25.1 | -71.2 | 2024-02-15 | 2024-06-15 | 1.6.3 | out_of_sync | 2024-04-20T16:25:14Z | Inactive—awaiting relocation. |
| SENS0013 | active | 0.98 | blank | WH003 | warehouse | blank | blank | temperature | 2024-06-07T18:13:49Z | 93.7 | -49.5 | blank | 2024-11-07 | 2.0.1 | synced | blank | Recently upgraded. |
| SENS0014 | active | 0.81 | blank | CONT003 | container | -33.8688 | 151.2093 | humidity | 2024-06-08T13:19:07Z | 69.4 | -64.1 | 2024-04-22 | 2024-09-22 | 1.12.0 | synced | blank | blank |
| SENS0015 | maintenance_required | 0.21 | maintenance_due | TRUCK005 | truck | 19.4326 | -99.1332 | vibration | 2024-05-17T19:37:37Z | 15.9 | -82.9 | 2024-01-23 | 2024-06-23 | 1.5.6 | out_of_sync | 2024-05-18T14:20:11Z | Sensor scheduled for urgent maintenance. |
| SENS0016 | active | 0.91 | blank | PAL005 | pallet | 45.4642 | 9.19 | temperature | 2024-06-08T12:32:27Z | 85.3 | -53.1 | 2024-05-09 | 2024-11-09 | 2.0.5 | synced | blank | blank |
| SENS0017 | active | 0.85 | blank | CONT004 | container | 55.7558 | 37.6173 | gps | 2024-06-07T23:14:03Z | 76.6 | -61.4 | 2024-04-23 | 2024-09-23 | 1.11.2 | synced | blank | Operating within normal parameters. |
| SENS0018 | active | 0.99 | blank | PAL006 | pallet | blank | blank | humidity | 2024-06-08T15:43:21Z | 97.5 | -47.8 | 2024-05-07 | 2024-11-07 | 2.2.3 | synced | blank | Recently upgraded. |
| SENS0019 | inactive | 0.66 | signal_loss | WH004 | warehouse | blank | blank | vibration | 2024-04-09T10:30:44Z | 58.3 | -70.5 | 2024-02-19 | 2024-07-19 | 1.7.2 | out_of_sync | 2024-04-10T08:22:51Z | Inactive due to seasonal closure. |
| SENS0020 | active | 0.96 | blank | TRUCK006 | truck | 28.6139 | 77.209 | temperature | 2024-06-07T05:05:15Z | 90.4 | -53.9 | 2024-05-05 | 2024-10-05 | 2.1.1 | synced | blank | Operating within normal parameters. |
What the 120 rows show
from the 120-row sampleFailed (sensor status) stands out: mean health_
- 0.81median health_
score - 3digital twin sync statuses
- 4asset types
- 5sensor types
- 66.0median battery_
level - -62.6median signal_
strength
Median 0.81, from 0.0 to 1.0.
- string 9
- float 5
- date 2
- datetime 2
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
sensor_id | string | Unique identifier for each IoT sensor deviceunique | SENS0001 |
asset_id | string | Unique identifier for the supply chain asset to which the sensor is attached | TRUCK001 |
asset_type | string | Type or category of the supply chain asset (e.g., truck, warehouse, pallet, container)4 types | truck |
sensor_type | string | Type of sensor (e.g., temperature, humidity, vibration, GPS, pressure)5 types | temperature |
sensor_status | string | Operational status of the sensor (e.g., active, inactive, maintenance_required, failed)active · inactive · maintenance_required · failed | active |
firmware_version | string | Current firmware version installed on the sensoroptional | 2.3.1 |
digital_twin_sync_status | string | Synchronization status with the digital twin model (e.g., synced, out_of_sync, error)synced · out_of_sync · error · optional | synced |
alert_type | string | Type of the most recent alert (e.g., battery_low, signal_loss, hardware_failure, maintenance_due)4 types · optional | battery_low |
notes | string | Additional notes or comments about the sensor's health or maintenance actionsoptional | Recently upgraded. |
| Numbers 5 columns | |||
location_latitude | float | Current latitude of the sensor or asset-90 to 90 · optional | 34.0522 |
location_longitude | float | Current longitude of the sensor or asset-180 to 180 · optional | -118.2437 |
battery_level | float | Current battery level of the sensor as a percentage (0-100)0 to 100 · optional | 87.4 |
signal_strength | float | Current wireless signal strength of the sensor in dBmoptional | -54.2 |
health_score | float | Calculated health score of the sensor (0-1, where 1 is optimal health)0 to 1 | 0.95 |
| Dates and times 4 columns | |||
last_communication_time | datetime | Timestamp of the last successful communication from the sensor | 2024-06-08T09:15:23Z |
last_maintenance_date | date | Date of the most recent maintenance performed on the sensoroptional | 2024-05-10 |
next_maintenance_due | date | Scheduled date for the next maintenance of the sensoroptional | 2024-10-10 |
last_alert_time | datetime | Timestamp of the last alert generated for this sensoroptional | 2024-05-29T08:16:42Z |
Use it for
A logistics dashboard
Health_
score by sensor_ status and a breakdown of alert_ type. Excel, Power BI or Tableau. Why do the 15 failed rows have a mean health_
score of 0.04? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sensors120SENS00010.95activeSENS00020.32maintena…SENS00030.65inactive
A software demo
Believable sensors with asset_
id, asset_ type and location_ latitude to fill a screen in front of a buyer.
This dataset120 rows18 columns
Yours1,000 rows18 columnslocation_latitude: UK only
blueprint · iot-supply-chain-sensor-health
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 and asset pairing
- Sensor status can be 'active', 'warning', or 'offline'
- Includes last maintenance date and status update timestamp
- Health score is calculated based on error rates, uptime, and environmental factors
- Assets are categorized by type: vehicle, warehouse, container, or machinery
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
- iot-supply-chain-sensor-health