trips_sample
Dataset description:
The City of Toronto collects trip and vehicle operating data from Private Transportation Companies (PTCs). This page contains two datasets: Summary Data Trip Data Summary Data (From...
Source: Private Transportation Companies - Summary and Trip Data
Data Dictionary
- ID
- dt
- Type
- date
- Description
Date of passenger pick-up
- ID
- pickup_hr
- Type
- text
- Description
Date and hour of passenger pick-up
- ID
- pickup_municipality
- Type
- text
- Description
Municipality name at the passenger pick-up point
- ID
- pickup_community_council
- Type
- text
- Description
Community council district name at the passenger pick-up point (if in Toronto)
- ID
- pickup_ward
- Type
- text
- Description
Toronto ward at the passenger pick-up point (if in Toronto)
- ID
- dropoff_municipality
- Type
- text
- Description
Municipality name at the passenger drop-off point
- ID
- dropoff_community_council
- Type
- text
- Description
Community council district name at the passenger drop-off point (if in Toronto)
- ID
- dropoff_ward
- Type
- text
- Description
Toronto ward at passenger the drop-off point (if in Toronto)
- ID
- trips_total
- Type
- text
- Description
Count of completed trips
- ID
- fare_avg
- Type
- text
- Description
Average fare
- ID
- waittime_avg
- Type
- text
- Description
Average distance travelled in kilometres (from pick-up to drop-off)
- ID
- distance_avg
- Type
- text
- Description
Average wait time in minutes (time elapsed from passenger request to driver arrival)
- ID
- duration_avg
- Type
- text
- Description
Average trip duration in minutes (from pick-up to drop-off)
Additional Information
| Field | Value |
|---|---|
| Data last updated | 30 March 2026 |
| Metadata last updated | 30 March 2026 |
| Created | 30 March 2026 |
| Format | CSV |
| License | No License Provided |
| Datastore active | True |
| Datastore cache | {'CSV': '749dec62-c305-4266-aaef-7cdf008f10e3', 'XML': '0f6657d2-bff4-4d39-a5d0-322fd825bd44', 'JSON': '8d9ef182-17fa-4be0-b4dc-5d98fcd0496a'} |
| Datastore cache last update | 3 days ago |
| Extract job | Airflow: Integration Pipeline private-transportation-companies-summary-and-trip-data |
| Has views | True |
| Id | 8c434d44-73d1-4409-b8cf-e556c9ee41d3 |
| Is preview | True |
| Mimetype | text/csv |
| Package id | fbac8e59-4883-4252-b73c-4a5caf19126d |
| Position | 1 |
| Record count | 8,133 |
| State | active |
| Url type | datastore |
| Extract Job | Airflow: Integration Pipeline private-transportation-companies-summary-and-trip-data |
| Is Datastore Cache File? | |
| Datastore Cache |
|
| Datastore Cache Last Updated | |
| Datastore resource's ID |