Urban Transport Mode Usage
This dataset provides daily aggregated counts of bus, rail, and bike usage across urban districts and cities, including contextual information such as weekday and holiday status. It is ideal for urban planners, mobility researchers, and policy makers seeking to analyze transport trends, optimize public transit, and drive innovation in urban mobility solutions.
Sample rows
preview · 8 of 200 rows · all 10 columns| usage_idinteger | citystring | rail_countinteger | is_holidayboolean | weekdaystring | datedate | districtstring | bus_countinteger | bike_countinteger | total_countinteger |
|---|---|---|---|---|---|---|---|---|---|
| 1 | London | 0 | true | Monday | 2023-12-25 | Westminster | 0 | 0 | 0 |
| 2 | New York | 650 | true | Tuesday | 2023-07-04 | Manhattan | 320 | 45 | 1015 |
| 3 | Berlin | 11 | true | Monday | 2023-05-01 | Kreuzberg | 29 | 67 | 107 |
| 4 | Paris | 0 | true | Sunday | 2023-01-01 | Montmartre | 0 | 0 | 0 |
| 5 | Tokyo | 980 | false | Wednesday | 2023-11-15 | Shibuya | 430 | 33 | 1443 |
| 6 | Sydney | 7 | false | Saturday | 2023-08-19 | Surry Hills | 10 | 3 | 20 |
| 7 | Chicago | 0 | false | Wednesday | 2023-03-15 | Loop | 0 | 0 | 0 |
| 8 | Los Angeles | 17 | false | Sunday | 2023-06-18 | blank | 13 | 2 | 32 |
| 9 | New York | 7 | true | Saturday | 2023-05-27 | Brooklyn | 5 | 1 | 13 |
| 10 | Paris | 18 | false | Tuesday | 2023-02-14 | Le Marais | 22 | 52 | 92 |
| 11 | Berlin | 4 | false | Wednesday | 2023-03-29 | Prenzlauer Berg | 19 | 41 | 64 |
| 12 | Tokyo | 1050 | false | Friday | 2023-04-21 | Minato | 480 | 28 | 1558 |
| 13 | Sydney | 0 | false | Saturday | 2023-05-20 | blank | 0 | 0 | 0 |
| 14 | London | 7 | false | Sunday | 2023-09-10 | Camden | 13 | 62 | 82 |
| 15 | Los Angeles | 4 | false | Tuesday | 2023-10-17 | Hollywood | 3 | 2 | 9 |
| 16 | Chicago | 10 | false | Monday | 2023-06-05 | blank | 17 | 6 | 33 |
| 17 | Berlin | 7 | true | Sunday | 2023-12-31 | Mitte | 11 | 54 | 72 |
| 18 | Los Angeles | 3 | true | Thursday | 2023-11-23 | Venice | 2 | 1 | 6 |
| 19 | Tokyo | 1200 | false | Tuesday | 2023-07-18 | Chiyoda | 285 | 21 | 1506 |
| 20 | Sydney | 4 | false | Wednesday | 2023-08-09 | Bondi | 6 | 2 | 12 |
What the 200 rows show
from the 200-row sampleTokyo city stands out: mean rail_
- 22%is_
holiday = true - 7.5median rail_
count - 12.5median bus_
count - 7median bike_
count - 34.5median total_
count
Median 7.5, from 0 to 1,200.
- string 3
- integer 5
- date 1
- boolean 1
Columns
10 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 3 columns | |||
city | string | Name of the city where the usage was recorded8 cities | London |
district | string | Name of the district or administrative area within the cityoptional | Westminster |
weekday | string | Day of the week corresponding to the date (e.g., Monday, Tuesday)7 values | Monday |
| Numbers 5 columns | |||
usage_id | integer | Unique identifier for each daily transport mode usage recordunique · 1 or more | 1 |
bus_count | integer | Number of bus rides recorded on the given date in the specified area0 or more | 0 |
rail_count | integer | Number of rail rides recorded on the given date in the specified area0 or more | 0 |
bike_count | integer | Number of bike rides recorded on the given date in the specified area0 or more | 0 |
total_count | integer | Total number of rides (bus + rail + bike) recorded for the date and area0 or more | 0 |
| Dates and times 1 column | |||
date | date | Date for which the transport mode usage is recorded | 2023-12-25 |
| True or false 1 column | |||
is_holiday | boolean | Indicates if the date is a public holiday in the specified city | true |
Use it for
A transportation dashboard
The is_
holiday rate, rail_ count by city and a breakdown of weekday. Excel, Power BI or Tableau. Why do the 25 Tokyo rows have a mean rail_
count of 718.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Rows20010London2650New York5980Tokyo
A software demo
Believable rows with date, city and district to fill a screen in front of a buyer.
blueprint · urban-transport-mode-usage
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 10 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.
- Mode and route identified per record
- Daily aggregate counts
- No missing usage values
- Exclude weekend-only 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
- urban-transport-mode-usage