Connected Vehicle Telemetry Dataset

This dataset provides granular, time-stamped telemetry logs from connected vehicles, including GPS coordinates, speed, engine diagnostics, and driver behavior events. It is designed for predictive maintenance, fleet management, and safety analytics, enabling advanced machine learning and operational insights for transportation and mobility solutions.

  • opened 15 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Predictive maintenance modeling for vehicle fleets

Sample rows

preview · 8 of 200 rows · all 20 columns
log_idstringfuel_level_percentfloatbrake_eventbooleandriver_idstringvehicle_idstringtimestampdatetimegps_latitudefloatgps_longitudefloatspeed_kphfloatengine_rpmintegerodometer_kmfloatdiagnostic_codestringacceleration_eventbooleanharsh_turn_eventbooleanseatbelt_fastenedbooleanambient_temperature_cfloatlocation_citystringlocation_statestringlocation_countrystringdiagnostic_code_descriptionstring
TLOG0000167.3falseDR001VH10012024-03-01T07:18:25Z37.7749-122.419452.1210015432.5blanktruefalsetrue18.3San FranciscoCAUSAblank
TLOG00002100falseDR002VH10022024-03-02T12:42:13Z34.0522-118.2437000P0456falsefalsetrue23.5Los AngelesCAUSAEvaporative emission system leak detected
TLOG0000341.8trueDR003VH10032024-03-03T18:19:07Z35.6895139.691774.831009321.6blankfalsetruetrue16.7TokyoTokyoJapanblank
TLOG0000463.9trueDR001VH10012024-03-04T15:37:10Z37.8044-122.271158.3225015468.1blankfalsefalsetrue18.1OaklandCAUSAblank
TLOG000050falseblankVH10042024-03-05T07:09:58Z-900000blankfalsefalseblank-89.2South Pole StationAntarcticaAntarcticablank
TLOG0000677.4falseDR004VH10052024-03-06T20:16:33Z48.85662.352283.2327062482.9C1234truetruetrue14.9ParisÎle-de-FranceFranceABS wheel speed sensor malfunction
TLOG0000734.5trueDR005VH10062024-03-07T11:03:44Z51.5074-0.127847.6184020981.8blankfalsefalsetrue12.6LondonEnglandUKblank
TLOG0000857falseDR006VH10072024-03-08T16:23:28Z40.7128-74.00629.412005329.2blankfalsefalsetrue9.8New YorkNYUSAblank

What the 200 rows show

from the 200-row sample
  • 24%brake_event = true
  • 48.8median fuel_level_percent
  • 35location countries
  • 54vehicles
  • 39.6median speed_kph
  • 1,559median engine_rpm
fuel_level_percent174 rows, in bands of 10
020403325242624321684050100fuel_level_percent →

Median 48.8, from 0.0 to 100.0.

driver_id142 rows with a value · 58 left blank
  1. DR00111
  2. DR00611
  3. DR0028
  4. DR0178
  5. DR0076
  6. DR0116
  7. DR0226
  8. DR0196
  9. DR0035
  10. DR0085
20 columns by typefrom the column list below
  • string 8
  • integer 1
  • float 6
  • datetime 1
  • boolean 4

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 8 columns
log_idstringUnique identifier for each telemetry log entryuniqueTLOG00001
vehicle_idstringUnique identifier for the vehicle generating the telemetry logVH1001
driver_idstringUnique identifier for the driver operating the vehicleoptionalDR001
diagnostic_codestringVehicle diagnostic trouble code (DTC) reported at the time of loggingoptionalP0456
diagnostic_code_descriptionstringHuman-readable description of the diagnostic trouble codeoptionalEvaporative emission syst…
location_citystringCity where the vehicle was located at the time of loggingoptionalSan Francisco
location_statestringState or region where the vehicle was located at the time of loggingoptionalCA
location_countrystringCountry where the vehicle was located at the time of loggingoptionalUSA
Numbers 7 columns
gps_latitudefloatLatitude coordinate of the vehicle at the time of logging-90 to 9037.7749
gps_longitudefloatLongitude coordinate of the vehicle at the time of logging-180 to 180-122.4194
speed_kphfloatInstantaneous speed of the vehicle in kilometers per hour0 or more52.1
engine_rpmintegerEngine revolutions per minute at the time of logging0 or more · optional2100
fuel_level_percentfloatCurrent fuel level as a percentage (0-100%)0 to 100 · optional67.3
odometer_kmfloatTotal distance traveled by the vehicle in kilometers0 or more · optional15432.5
ambient_temperature_cfloatAmbient temperature outside the vehicle in degrees Celsiusoptional18.3
Dates and times 1 column
timestampdatetimeDate and time when the telemetry log was recorded (UTC)2024-03-01T07:18:25Z
True or false 4 columns
brake_eventbooleanIndicates if a braking event occurred at the time of loggingoptionalfalse
acceleration_eventbooleanIndicates if a rapid acceleration event occurred at the time of loggingoptionaltrue
harsh_turn_eventbooleanIndicates if a harsh turn event occurred at the time of loggingoptionalfalse
seatbelt_fastenedbooleanIndicates if the driver's seatbelt was fastened at the time of loggingoptionaltrue

15 SQL practice questions for the Connected Vehicle Telemetry Dataset

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    Fast readings

    Return log_id, vehicle_id and speed_kph for every log where speed_kph is greater than 120. Order the results by speed_kph descending, then log_id ascending.

    Tables: connected_vehicle_telemetry_dataset · your result: 3 columns, 4 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Countries in the data

    Return each distinct location_country value once, in a single column named location_country, sorted alphabetically.

    Tables: connected_vehicle_telemetry_dataset · your result: 1 columns, 35 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Logs per vehicle

    Return vehicle_id and the number of logs for each vehicle as log_count. Order by log_count descending, then vehicle_id ascending.

    Tables: connected_vehicle_telemetry_dataset · your result: 2 columns, 54 rows
  1. 04Average speed by countryBeginner
  2. 05Harsh turn total cardPower BI
  3. 06Cities with many logsIntermediate
  4. 07Speed bucketsIntermediate
  5. 08Monthly logs and brakingIntermediate
  6. 09Vehicles faster than fleet averageIntermediate
  7. 10Seatbelt compliance by countryPower BI
  8. 11Rank vehicles by max speedAdvanced
  9. 12Odometer change per vehicleAdvanced
  10. 13Running harsh turns by monthAdvanced
  11. 14Share of logs by countryAdvanced
  12. 15Speed anomaly tablePower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • brake event24%47 of 200 rows

    A transportation dashboard

    The brake_event rate, fuel_level_percent and a breakdown of driver_id. Excel, Power BI or Tableau.

  • Why do 47 of 200 rows have brake_event = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 200 rows.

  • A software demo

    Believable logs with vehicle_id, driver_id and timestamp to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows20 columns
Yours1,000 rows20 columnslocation_city: UK only

blueprint · connected-vehicle-telemetry-dataset

Behind this dataset

Same schema. As many rows as you need.

These 200 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
  • Vehicle ID anonymized
  • Telemetry readings per minute
  • Diagnostic events labeled
  • Driver behavior features included
  • Geospatial data encoded
Rows
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
connected-vehicle-telemetry-dataset

What should your data show?

Preview 20 rows free
No signup. No card.