School Bus Sensor Uptime Log
This dataset provides granular, real-time logs of IoT sensor uptime and operational status across school bus fleets. It includes sensor health, location, maintenance indicators, and route information, empowering transportation administrators to monitor sensor reliability, optimize bus routes, and proactively address safety or maintenance concerns. Ideal for smart mobility initiatives and data-driven fleet management.
Sample rows
preview · 8 of 75 rows · all 14 columns| log_idstring | statusstring | uptime_secondsinteger | maintenance_requiredboolean | bus_idstring | sensor_idstring | sensor_typestring | last_checked_atdatetime | error_codestring | location_latitudefloat | location_longitudefloat | route_idstring | operator_idstring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SENSLOG-001A | online | 13600 | false | BUS-1001 | SNS-2001 | GPS | 2024-06-10T07:15:23Z | blank | 40.7132 | -73.9387 | RT-33N | OP-201 | Normal operation |
| SENSLOG-001B | error | 0 | true | BUS-1002 | SNS-2002 | temperature | 2024-06-10T08:04:32Z | TMP-ERR-01 | 40.7201 | -73.9299 | RT-12S | OP-203 | Sensor overheating, needs replacement |
| SENSLOG-001C | maintenance | 9200 | true | BUS-1003 | SNS-2003 | camera | 2024-06-09T16:43:11Z | blank | 40.7159 | -73.9436 | RT-45W | OP-205 | Camera lens cleaning scheduled |
| SENSLOG-001D | online | 15200 | false | BUS-1001 | SNS-2004 | RFID | 2024-06-10T07:50:41Z | blank | 40.7128 | -73.936 | RT-33N | OP-201 | Normal operation |
| SENSLOG-001E | offline | 0 | true | BUS-1004 | SNS-2005 | temperature | 2024-06-10T09:33:15Z | blank | 40.7182 | -73.9405 | RT-88E | OP-209 | Sensor not responding |
| SENSLOG-001F | online | 14123 | false | BUS-1005 | SNS-2006 | camera | 2024-06-10T10:10:38Z | blank | 40.7162 | -73.9448 | RT-56S | OP-212 | Normal operation |
| SENSLOG-001G | online | 13887 | false | BUS-1003 | SNS-2007 | RFID | 2024-06-10T08:17:09Z | blank | 40.7155 | -73.9483 | RT-45W | OP-205 | Normal operation |
| SENSLOG-001H | online | 14766 | false | BUS-1002 | SNS-2008 | GPS | 2024-06-10T09:31:27Z | blank | 40.721 | -73.9282 | RT-12S | OP-203 | Normal operation |
| SENSLOG-001I | error | 0 | true | BUS-1006 | SNS-2009 | other | 2024-06-10T08:55:13Z | GEN-ERR-03 | 40.7198 | -73.9423 | RT-22N | OP-215 | Unexpected shutdown, technician notified |
| SENSLOG-001J | online | 13400 | false | BUS-1004 | SNS-2010 | GPS | 2024-06-10T07:58:44Z | blank | 40.7174 | -73.9417 | RT-88E | OP-209 | Normal operation |
| SENSLOG-001K | offline | 0 | true | BUS-1005 | SNS-2011 | camera | 2024-06-10T08:22:37Z | blank | 40.7168 | -73.9462 | RT-56S | OP-212 | Camera power failure |
| SENSLOG-001L | online | 14285 | false | BUS-1001 | SNS-2012 | temperature | 2024-06-10T09:01:10Z | blank | 40.7138 | -73.9355 | RT-33N | OP-201 | Temperature within range |
| SENSLOG-001M | maintenance | 9000 | true | BUS-1003 | SNS-2013 | other | 2024-06-09T15:30:19Z | blank | 40.7161 | -73.9479 | RT-45W | OP-205 | Firmware update scheduled |
| SENSLOG-001N | online | 13999 | false | BUS-1006 | SNS-2014 | RFID | 2024-06-10T07:45:58Z | blank | 40.7189 | -73.9431 | RT-22N | OP-215 | Normal operation |
| SENSLOG-001O | online | 14320 | false | BUS-1002 | SNS-2015 | camera | 2024-06-10T08:59:17Z | blank | 40.7205 | -73.9301 | RT-12S | OP-203 | Normal operation |
| SENSLOG-001P | error | 0 | true | BUS-1007 | SNS-2016 | temperature | 2024-06-10T09:48:03Z | TMP-ERR-02 | 40.7192 | -73.9396 | RT-77N | OP-217 | Temperature reading out of bounds |
| SENSLOG-001Q | online | 13780 | false | BUS-1004 | SNS-2017 | RFID | 2024-06-10T08:35:29Z | blank | 40.7178 | -73.9402 | RT-88E | OP-209 | Normal operation |
| SENSLOG-001R | maintenance | 9100 | true | BUS-1005 | SNS-2018 | GPS | 2024-06-09T16:20:02Z | blank | 40.7172 | -73.9455 | RT-56S | OP-212 | GPS recalibration scheduled |
| SENSLOG-001S | online | 14028 | false | BUS-1003 | SNS-2019 | temperature | 2024-06-10T08:44:55Z | blank | 40.7157 | -73.949 | RT-45W | OP-205 | Temperature readings stable |
| SENSLOG-001T | offline | 0 | true | BUS-1006 | SNS-2020 | camera | 2024-06-10T10:22:12Z | blank | 40.7202 | -73.9412 | RT-22N | OP-215 | Camera disconnected |
What the 75 rows show
from the 75-row sampleError status stands out: 12 of its 12 rows have maintenance_
- 44%maintenance_
required = true - 10,500median uptime_
seconds - 5sensor types
Error status's mean uptime_
Median 10,500, from 0 to 79,436.
- string 9
- integer 1
- float 2
- datetime 1
- boolean 1
Columns
14 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
log_id | string | Unique identifier for each sensor uptime log entryunique | SENSLOG-001A |
bus_id | string | Unique identifier for the school bus | BUS-1001 |
sensor_id | string | Unique identifier for the IoT sensor installed on the bus | SNS-2001 |
sensor_type | string | Type of sensor (e.g., GPS, temperature, camera, RFID)GPS · temperature · camera · RFID · other | GPS |
status | string | Current operational status of the sensoronline · offline · error · maintenance | online |
error_code | string | Error code reported by the sensor, if anyoptional | TMP-ERR-01 |
route_id | string | Identifier for the bus route at the time of loggingoptional | RT-33N |
operator_id | string | Identifier for the bus operator or driveroptional | OP-201 |
notes | string | Additional notes or comments regarding the sensor status or maintenanceoptional | Normal operation |
| Numbers 3 columns | |||
uptime_seconds | integer | Total number of seconds the sensor has been online since last reset0 or more | 13600 |
location_latitude | float | Latitude coordinate of the bus when the log was recorded-90 to 90 | 40.7132 |
location_longitude | float | Longitude coordinate of the bus when the log was recorded-180 to 180 | -73.9387 |
| Dates and times 1 column | |||
last_checked_at | datetime | Timestamp when the sensor status was last checked | 2024-06-10T07:15:23Z |
| True or false 1 column | |||
maintenance_required | boolean | Indicates if the sensor requires maintenance | false |
Use it for
A transportation dashboard
The maintenance_
required rate, uptime_ seconds by status and a breakdown of bus_ id. Excel, Power BI or Tableau. Why do 33 of 75 rows have maintenance_
required = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs75SENSLOG-001A13600onlineSENSLOG-001B0errorSENSLOG-001C9200maintena…
A software demo
Believable logs with bus_
id, sensor_ id and sensor_ type to fill a screen in front of a buyer.
blueprint · school-bus-sensor-uptime-log
Behind this dataset
Same schema. As many rows as you need.
These 75 rows came out of a blueprint — 14 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 row represents a single bus sensor’s daily uptime.
- Include sensor type, bus ID, uptime percentage, downtime reason, and last maintenance date.
- Flag sensors with uptime below 95% for immediate attention.
- Only one sensor log per bus per day.
- If downtime exceeds 2 hours, require incident review.
- Audit sensor health weekly for compliance.
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
- school-bus-sensor-uptime-log