Fleet IoT Sustainability Metrics
This dataset provides granular, time-stamped IoT sensor data for urban transport fleets, capturing vehicle activity, energy consumption, maintenance status, and ESG compliance metrics. Designed for small and medium businesses, it enables actionable insights to optimize routes, reduce carbon emissions, and improve sustainability reporting and regulatory compliance.
Sample rows
preview · 8 of 120 rows · all 22 columns| fleet_idstring | maintenance_statusstring | esg_compliance_scorefloat | incident_reportedboolean | vehicle_typestring | vehicle_idstring | registration_platestring | sensor_idstring | timestampdatetime | location_latitudefloat | location_longitudefloat | distance_travelled_kmfloat | energy_consumed_kwhfloat | fuel_typestring | carbon_emissions_kgfloat | last_maintenance_datedate | next_maintenance_due_datedate | route_idstring | route_namestring | incident_descriptionstring | driver_idstring | driver_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FLEET_NYC_001 | ok | 68.8 | false | van | VAN_001_A | NY-AB1234 | SENSOR_VAN_001 | 2024-05-12T08:32:19Z | 40.7128 | -74.006 | 24.7 | 14.5 | cng | 18.7 | 2024-04-15 | 2024-07-15 | NYC_DELIVERY_01 | Midtown Manhattan Delivery | blank | DR_001_J | Jamal Carter |
| FLEET_SF_002 | ok | 91.7 | false | car | CAR_002_B | CA-BC2345 | SENSOR_CAR_002 | 2024-05-13T09:10:02Z | 37.7749 | -122.4194 | 12.4 | 1.5 | hybrid | 0.3 | 2024-05-01 | 2024-11-01 | SF_COMMUTE_02 | Downtown SF Commute | blank | DR_002_L | Lily Nguyen |
| FLEET_LON_003 | completed | 99.1 | false | e-bike | EBIKE_003_C | LDN-E3456 | SENSOR_EBIKE_003 | 2024-05-13T11:55:21Z | 51.5074 | -0.1278 | 6.2 | 1.3 | electric | 0.01 | 2024-05-10 | 2024-08-10 | LON_DELIVERY_03 | Westminster Urban Parcel | blank | DR_003_A | Alex Turner |
| FLEET_MUM_004 | due | 34.7 | true | truck | TRUCK_004_D | MH-TR4567 | SENSOR_TRUCK_004 | 2024-05-12T18:40:32Z | 19.076 | 72.8777 | 518.3 | 289.7 | diesel | 1720.6 | 2024-03-22 | 2024-06-22 | MUM_FREIGHT_04 | Eastern Corridor Freight | Brake issue reported | DR_004_K | Kiran Desai |
| FLEET_SP_005 | in_progress | 24.2 | false | bus | BUS_005_E | SP-BU5678 | SENSOR_BUS_005 | 2024-05-14T06:32:41Z | -23.5505 | -46.6333 | 342.6 | 621.5 | diesel | 1438.9 | 2024-04-05 | 2024-09-05 | SP_TRANSIT_05 | Centro North Bus Transit | blank | DR_005_F | Felipe Souza |
| FLEET_BER_006 | ok | 88.9 | false | car | CAR_006_F | BER-C6789 | SENSOR_CAR_006 | 2024-05-13T14:05:07Z | 52.52 | 13.405 | 17.3 | 1.8 | petrol | 1.5 | 2024-04-28 | 2024-10-28 | BER_COMMUTE_06 | Prenzlauer Berg Commute | blank | DR_006_S | Sarah Becker |
| FLEET_SYD_007 | ok | 70.2 | false | van | VAN_007_G | SY-VA7890 | SENSOR_VAN_007 | 2024-05-13T22:16:49Z | -33.8688 | 151.2093 | 34.8 | 16.7 | petrol | 27.3 | 2024-05-03 | 2024-08-03 | SYD_DELIVERY_07 | CBD Delivery Circuit | blank | DR_007_M | Megan Walsh |
| FLEET_DEL_008 | critical | 12.5 | true | truck | TRUCK_008_H | DL-TR8901 | SENSOR_TRUCK_008 | 2024-05-14T02:21:11Z | 28.6139 | 77.209 | 688.2 | 1065.3 | diesel | 2119.6 | 2024-02-17 | 2024-05-17 | blank | blank | Engine overheated | blank | blank |
| FLEET_SF_009 | ok | 97.5 | false | e-bike | EBIKE_009_I | SF-E9012 | SENSOR_EBIKE_009 | 2024-05-14T17:32:41Z | 37.779 | -122.419 | 8.2 | 1.7 | electric | 0.02 | 2024-05-12 | 2024-08-12 | SF_EBIKE_09 | Market St Urban Delivery | blank | DR_009_T | Tommy Lee |
| FLEET_MUM_010 | completed | 29.8 | false | bus | BUS_010_J | MH-BU0123 | SENSOR_BUS_010 | 2024-05-13T15:50:23Z | 19.0213 | 72.8424 | 278.3 | 489.2 | diesel | 1098.3 | 2024-05-09 | 2024-08-09 | MUM_TRANSIT_10 | Western Express Bus | blank | DR_010_P | Pooja Sharma |
| FLEET_PAR_011 | ok | 94.3 | false | car | CAR_011_K | PAR-C1234 | SENSOR_CAR_011 | 2024-05-14T12:07:38Z | 48.8566 | 2.3522 | 9.8 | 0.9 | hybrid | 0.1 | 2024-03-17 | 2024-09-17 | PAR_COMMUTE_11 | Montmartre Morning Commute | blank | DR_011_V | Vincent Laurent |
| FLEET_NYC_012 | in_progress | 27.7 | true | truck | TRUCK_012_L | NY-TR2345 | SENSOR_TRUCK_012 | 2024-05-14T14:45:12Z | 40.7127 | -74.0049 | 302.1 | 609.7 | diesel | 1412.5 | 2024-04-12 | 2024-07-12 | NYC_FREIGHT_12 | Brooklyn Export Run | Transmission warning | DR_012_D | Derek Wilson |
| FLEET_BER_013 | ok | 74.5 | false | van | VAN_013_M | BER-VA3456 | SENSOR_VAN_013 | 2024-05-12T20:20:45Z | 52.5163 | 13.3777 | 42.1 | 19.6 | petrol | 33.2 | 2024-04-30 | 2024-08-30 | BER_DELIVERY_13 | Tiergarten Parcel Run | blank | DR_013_O | Oliver Meyer |
| FLEET_SP_014 | ok | 95.3 | false | car | CAR_014_N | SP-C4567 | SENSOR_CAR_014 | 2024-05-13T16:38:17Z | -23.551 | -46.634 | 19.9 | 1.7 | hybrid | 0.18 | 2024-04-12 | 2024-10-12 | SP_COMMUTE_14 | Paulista Ave Commute | blank | DR_014_J | Joao Mendes |
| FLEET_LON_015 | due | 32.1 | true | truck | TRUCK_015_O | LDN-TR5678 | SENSOR_TRUCK_015 | 2024-05-14T06:09:53Z | 51.5285 | -0.0847 | 487.2 | 820.8 | diesel | 1782.2 | 2024-03-10 | 2024-06-10 | LON_EXPORT_15 | Docklands Export Route | Delayed delivery | DR_015_E | Edward James |
| FLEET_SYD_016 | ok | 73.9 | false | van | VAN_016_P | SY-VA6789 | SENSOR_VAN_016 | 2024-05-12T10:49:35Z | -33.8704 | 151.207 | 27.7 | 12.8 | cng | 15.5 | 2024-03-23 | 2024-06-23 | SYD_DELIVERY_16 | South Sydney Goods | blank | DR_016_S | Samir Patel |
| FLEET_DEL_017 | critical | 6.9 | true | truck | TRUCK_017_Q | DL-TR0123 | SENSOR_TRUCK_017 | 2024-05-14T23:40:10Z | 28.7041 | 77.1025 | 803.7 | 1185.8 | diesel | 2389.3 | 2024-01-31 | 2024-05-31 | blank | blank | Major breakdown | blank | blank |
| FLEET_SF_018 | ok | 98.2 | false | e-bike | EBIKE_018_R | SF-E2345 | SENSOR_EBIKE_018 | 2024-05-12T13:22:40Z | 37.7755 | -122.4183 | 3.9 | 0.8 | electric | 0.01 | 2024-05-09 | 2024-09-09 | SF_EBIKE_18 | Mission St Urban Delivery | blank | DR_018_B | Bailey Wong |
| FLEET_MUM_019 | due | 21.7 | true | bus | BUS_019_S | MH-BU2345 | SENSOR_BUS_019 | 2024-05-13T06:28:31Z | 19.0632 | 72.8774 | 398.1 | 821.9 | diesel | 1739.6 | 2024-03-12 | 2024-06-12 | MUM_TRANSIT_19 | South Mumbai Bus | Flat tire | DR_019_A | Anil Kumar |
| FLEET_PAR_020 | ok | 89.7 | false | car | CAR_020_T | PAR-C5678 | SENSOR_CAR_020 | 2024-05-14T18:03:17Z | 48.8584 | 2.2945 | 6.5 | 0.7 | petrol | 0.7 | 2024-04-04 | 2024-10-04 | PAR_COMMUTE_20 | Eiffel Tower Delivery | blank | DR_020_F | Florence Martin |
What the 120 rows show
from the 120-row sampleCritical (maintenance status) stands out: mean esg_
- 25%incident_
reported = true - 72.8median esg_
compliance_ score - 5fuel types
- 29.4median distance_
travelled_ km - 12.9median energy_
consumed_ kwh - 16.9median carbon_
emissions_ kg
Median 72.8, from 0.70 to 99.8.
- string 12
- float 6
- date 2
- datetime 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
fleet_id | string | Unique identifier for the fleet or business entity | FLEET_NYC_001 |
vehicle_id | string | Unique identifier for each vehicle in the fleetunique | VAN_001_A |
vehicle_type | string | Type of vehicle (e.g., van, truck, e-bike, bus)6 values | van |
registration_plate | string | Official vehicle registration plateunique | NY-AB1234 |
sensor_id | string | Unique identifier for the IoT sensor installed on the vehicle | SENSOR_VAN_001 |
fuel_type | string | Type of fuel or energy source used by the vehicle6 values | cng |
maintenance_status | string | Current maintenance status of the vehicleok · due · in_progress · completed · critical | ok |
route_id | string | Identifier for the route assigned to the vehicleoptional | NYC_DELIVERY_01 |
route_name | string | Human-readable name or description of the routeoptional | Downtown SF Commute |
incident_description | string | Description of the incident, if anyoptional | Brake issue reported |
driver_id | string | Unique identifier for the driver assigned to the vehicleoptional | DR_001_J |
driver_name | string | Name of the driver assigned to the vehicleoptional | Jamal Carter |
| Numbers 6 columns | |||
location_latitude | float | Latitude coordinate of the vehicle at the time of data capture-90 to 90 | 40.7128 |
location_longitude | float | Longitude coordinate of the vehicle at the time of data capture-180 to 180 | -74.006 |
distance_travelled_km | float | Distance travelled by the vehicle since last reading, in kilometers0 or more | 24.7 |
energy_consumed_kwh | float | Energy consumed by the vehicle since last reading, in kilowatt-hours0 or more | 14.5 |
carbon_emissions_kg | float | Estimated carbon emissions produced since last reading, in kilograms0 or more | 18.7 |
esg_compliance_score | float | Environmental, Social, and Governance compliance score for the vehicle or route (0-100)0 to 100 · optional | 68.8 |
| Dates and times 3 columns | |||
timestamp | datetime | Date and time when the sensor data was recorded | 2024-05-12T08:32:19Z |
last_maintenance_date | date | Date of the last completed maintenance for the vehicleoptional | 2024-04-15 |
next_maintenance_due_date | date | Scheduled date for the next maintenanceoptional | 2024-07-15 |
| True or false 1 column | |||
incident_reported | boolean | Indicates if any incident (accident, breakdown, etc.) was reported during this activityoptional | false |
Use it for
A transportation dashboard
The incident_
reported rate, esg_ compliance_ score by maintenance_ status and a breakdown of vehicle_ type. Excel, Power BI or Tableau. Why do the 12 critical rows have a mean esg_
compliance_ score of 6.6? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Fleets120FLEET_NYC_00168.8okFLEET_MUM_00434.7dueFLEET_DEL_00812.5critical
A software demo
Believable fleets with vehicle_
id, vehicle_ type and registration_ plate to fill a screen in front of a buyer.
blueprint · fleet-iot-sustainability-metrics
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 22 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 vehicle entry must include IoT sensor readings for location, energy consumption, and maintenance status.
- All trips must record start/end timestamps and calculated emissions values.
- Maintenance events are only valid if scheduled within recommended intervals (based on usage hours).
- Daily route efficiency scores must be calculated for fleet optimization.
- ESG impact ratings must be updated monthly per vehicle based on cumulative data.
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
- fleet-iot-sustainability-metrics