Urban Micro-Mobility Fleet Usage
This dataset contains granular trip-level logs for urban micro-mobility fleets, including vehicle, user, location, timing, and operational details. It enables robust analysis of mobility patterns, peak demand periods, and operational efficiency, supporting data-driven decisions for city planners, fleet operators, and sustainability initiatives.
Sample rows
preview · 8 of 150 rows · all 21 columns| trip_idstring | weather_conditionstring | trip_duration_minutesfloat | operational_issue_flagboolean | payment_typestring | vehicle_idstring | vehicle_typestring | user_idstring | trip_start_datetimedatetime | trip_end_datetimedatetime | start_latitudefloat | start_longitudefloat | end_latitudefloat | end_longitudefloat | distance_kmfloat | trip_costfloat | start_zonestring | end_zonestring | is_peak_periodboolean | battery_level_startinteger | battery_level_endinteger |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TRX1001 | clear | 20 | false | credit_card | VEH001 | e-scooter | USR001A | 2024-06-01T07:14:00 | 2024-06-01T07:34:00 | 35.6895 | 139.6917 | 35.694 | 139.7072 | 4.2 | 7.5 | Shinjuku | Ikebukuro | true | 96 | 81 |
| TRX1002 | cloudy | 23 | false | prepaid | VEH002 | bike | USR002B | 2024-06-01T12:23:00 | 2024-06-01T12:46:00 | 37.7749 | -122.4194 | 37.7811 | -122.4237 | 2.7 | 3.9 | Downtown | Civic Center | false | blank | blank |
| TRX1003 | rain | 35 | false | mobile_wallet | VEH003 | e-bike | USR003C | 2024-06-01T17:45:00 | 2024-06-01T18:20:00 | 51.5074 | -0.1278 | 51.501 | -0.1419 | 5.8 | 9.7 | Westminster | Soho | true | 89 | 74 |
| TRX1004 | clear | 15 | false | other | VEH004 | other | USR004D | 2024-06-01T08:14:00 | 2024-06-01T08:29:00 | 48.8566 | 2.3522 | 48.8627 | 2.35 | 1.9 | 2.5 | Le Marais | Châtelet | true | blank | blank |
| TRX1005 | windy | 1 | true | debit_card | VEH005 | e-scooter | USR005E | 2024-06-01T18:02:00 | 2024-06-01T18:03:00 | 34.0522 | -118.2437 | 34.0523 | -118.2438 | 0.2 | 0.8 | Arts District | Little Tokyo | false | 91 | 91 |
| TRX1006 | cloudy | 15 | false | credit_card | VEH006 | e-bike | USR006F | 2024-06-01T09:44:00 | 2024-06-01T09:59:00 | 40.7128 | -74.006 | 40.7306 | -73.9866 | 3.1 | 5.2 | Tribeca | East Village | true | 87 | 80 |
| TRX1007 | clear | 3 | false | prepaid | VEH007 | bike | USR007G | 2024-06-01T10:34:00 | 2024-06-01T10:37:00 | 52.52 | 13.405 | 52.5218 | 13.4097 | 0.7 | 1.2 | Mitte | Prenzlauer Berg | false | blank | blank |
| TRX1008 | rain | 30 | false | mobile_wallet | VEH008 | e-scooter | USR008H | 2024-06-01T19:26:00 | 2024-06-01T19:56:00 | 41.8781 | -87.6298 | 41.8892 | -87.6275 | 6 | 10.1 | The Loop | River North | false | 83 | 65 |
| TRX1009 | clear | 80 | false | debit_card | VEH009 | e-bike | USR009I | 2024-06-01T13:02:00 | 2024-06-01T14:22:00 | 59.3293 | 18.0686 | 59.3322 | 18.0587 | 12.5 | 22 | Södermalm | Gamla Stan | false | 77 | 54 |
| TRX1010 | clear | 0.0166 | true | prepaid | VEH010 | other | USR010J | 2024-06-01T08:00:00 | 2024-06-01T08:00:01 | 35.6586 | 139.7454 | 35.6586 | 139.7454 | 0 | 0 | Minato | Minato | true | blank | blank |
| TRX1011 | cloudy | 14 | false | credit_card | VEH011 | e-bike | USR011K | 2024-06-01T07:35:00 | 2024-06-01T07:49:00 | 37.5665 | 126.978 | 37.5709 | 126.9832 | 2.8 | 4.7 | Jongno | Insadong | true | 90 | 72 |
| TRX1012 | other | 1 | true | mobile_wallet | VEH012 | e-scooter | USR012L | 2024-06-01T17:10:00 | 2024-06-01T17:11:00 | 45.4642 | 9.19 | 45.4643 | 9.1901 | 0.1 | 0.4 | Centro | Brera | true | 100 | 100 |
| TRX1013 | cloudy | 35 | false | mobile_wallet | VEH013 | bike | USR013M | 2024-06-01T13:13:00 | 2024-06-01T13:48:00 | 40.4168 | -3.7038 | 40.4199 | -3.6874 | 5.9 | 4.2 | Sol | Chamberí | false | blank | blank |
| TRX1014 | rain | 60 | false | debit_card | VEH014 | e-bike | USR014N | 2024-06-01T16:20:00 | 2024-06-01T17:20:00 | 43.6532 | -79.3832 | 43.6665 | -79.3812 | 13.7 | 25.3 | Old Toronto | Yorkville | false | 73 | 47 |
| TRX1015 | snow | 5 | false | other | VEH015 | other | USR015O | 2024-06-01T11:25:00 | 2024-06-01T11:30:00 | 55.7558 | 37.6173 | 55.7559 | 37.6176 | 0.4 | 1.1 | Tverskoy | Arbat | false | blank | blank |
| TRX1016 | clear | 29 | false | credit_card | VEH016 | e-scooter | USR016P | 2024-06-01T17:26:00 | 2024-06-01T17:55:00 | 30.0444 | 31.2357 | 30.0523 | 31.2464 | 5.6 | 9.5 | Zamalek | Garden City | false | 77 | 63 |
| TRX1017 | windy | 40 | false | prepaid | VEH017 | bike | USR017Q | 2024-06-01T08:30:00 | 2024-06-01T09:10:00 | 33.8688 | 151.2093 | 33.877 | 151.2131 | 6.8 | 5.1 | Surry Hills | Darlinghurst | true | blank | blank |
| TRX1018 | cloudy | 74 | true | debit_card | VEH018 | e-scooter | USR018R | 2024-06-01T14:00:00 | 2024-06-01T15:14:00 | 19.4326 | -99.1332 | 19.4378 | -99.1456 | 14.5 | 28.6 | Centro | Condesa | false | 62 | 35 |
| TRX1019 | rain | 30 | false | prepaid | VEH019 | bike | USR019S | 2024-06-01T08:50:00 | 2024-06-01T09:20:00 | 34.6937 | 135.5023 | 34.7006 | 135.4961 | 5.2 | 4 | Umeda | Namba | true | blank | blank |
| TRX1020 | cloudy | 40 | false | mobile_wallet | VEH020 | e-scooter | USR020T | 2024-06-01T07:05:00 | 2024-06-01T07:45:00 | 55.9533 | -3.1883 | 55.957 | -3.175 | 7.2 | 12.8 | Old Town | New Town | true | 93 | 82 |
What the 150 rows show
from the 150-row sampleOther (weather condition) stands out: 12 of its 12 rows have operational_
- 15%operational_
issue_ flag = true - 21.0median trip_
duration_ minutes - 4vehicle types
- 4.5median distance_
km - 5.7median trip_
cost - 88median battery_
level_ start
Median 21.0, from 0.02 to 80.0.
- string 8
- integer 2
- float 7
- datetime 2
- boolean 2
Columns
21 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
trip_id | string | Unique identifier for each micro-mobility tripunique | TRX1001 |
vehicle_id | string | Unique identifier for the vehicle used in the trip | VEH001 |
vehicle_type | string | Type of micro-mobility vehicle (e.g., e-scooter, e-bike)e-scooter · e-bike · bike · other | e-scooter |
user_id | string | Unique identifier for the user taking the trip (anonymized) | USR001A |
payment_type | string | Payment method used for the tripcredit_card · debit_card · mobile_wallet · prepaid · other | credit_card |
start_zone | string | City-defined zone or neighborhood where the trip startedoptional | Shinjuku |
end_zone | string | City-defined zone or neighborhood where the trip endedoptional | Ikebukuro |
weather_condition | string | General weather condition during the trip (e.g., clear, rain, snow)6 values · optional | clear |
| Numbers 9 columns | |||
trip_duration_minutes | float | Total duration of the trip in minutes0 or more | 20 |
start_latitude | float | Latitude of the trip start location-90 to 90 | 35.6895 |
start_longitude | float | Longitude of the trip start location-180 to 180 | 139.6917 |
end_latitude | float | Latitude of the trip end location-90 to 90 | 35.694 |
end_longitude | float | Longitude of the trip end location-180 to 180 | 139.7072 |
distance_km | float | Total distance traveled during the trip in kilometers0 or more | 4.2 |
trip_cost | float | Total cost charged for the trip in local currency0 or more | 7.5 |
battery_level_start | integer | Battery level percentage of the vehicle at trip start (0-100)0 to 100 · optional | 96 |
battery_level_end | integer | Battery level percentage of the vehicle at trip end (0-100)0 to 100 · optional | 81 |
| Dates and times 2 columns | |||
trip_start_datetime | datetime | Date and time when the trip started | 2024-06-01T07:14:00 |
trip_end_datetime | datetime | Date and time when the trip ended | 2024-06-01T07:34:00 |
| True or false 2 columns | |||
is_peak_period | boolean | Indicates if the trip occurred during a defined peak demand period | true |
operational_issue_flag | boolean | Indicates if any operational issue was reported during the tripoptional | false |
Use it for
A transportation dashboard
The operational_
issue_ flag rate, trip_ duration_ minutes by weather_ condition and a breakdown of payment_ type. Excel, Power BI or Tableau. Why do 23 of 150 rows have operational_
issue_ flag = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Trips150TRX100120clearTRX10051windyTRX10100.0166clear
A software demo
Believable trips with vehicle_
id, vehicle_ type and user_ id to fill a screen in front of a buyer.
blueprint · urban-micro-mobility-fleet-usage
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 21 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 trip for an e-scooter or shared bike.
- Trips must include anonymized start/end geolocation, duration, and distance.
- Fleet vehicle ID and vehicle type must be recorded for every entry.
- Trips are only included if initiated in permitted city zones.
- Maintenance flag is set if a vehicle required intervention post-trip.
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
- urban-micro-mobility-fleet-usage