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...
Ресурс: Private Transportation Companies - Summary and Trip Data
Словарь данных
- ID
- dt
- Тип
- date
- Описание
Date of passenger pick-up
- ID
- pickup_hr
- Тип
- text
- Описание
Date and hour of passenger pick-up
- ID
- pickup_municipality
- Тип
- text
- Описание
Municipality name at the passenger pick-up point
- ID
- pickup_community_council
- Тип
- text
- Описание
Community council district name at the passenger pick-up point (if in Toronto)
- ID
- pickup_ward
- Тип
- text
- Описание
Toronto ward at the passenger pick-up point (if in Toronto)
- ID
- dropoff_municipality
- Тип
- text
- Описание
Municipality name at the passenger drop-off point
- ID
- dropoff_community_council
- Тип
- text
- Описание
Community council district name at the passenger drop-off point (if in Toronto)
- ID
- dropoff_ward
- Тип
- text
- Описание
Toronto ward at passenger the drop-off point (if in Toronto)
- ID
- trips_total
- Тип
- text
- Описание
Count of completed trips
- ID
- fare_avg
- Тип
- text
- Описание
Average fare
- ID
- waittime_avg
- Тип
- text
- Описание
Average distance travelled in kilometres (from pick-up to drop-off)
- ID
- distance_avg
- Тип
- text
- Описание
Average wait time in minutes (time elapsed from passenger request to driver arrival)
- ID
- duration_avg
- Тип
- text
- Описание
Average trip duration in minutes (from pick-up to drop-off)
Дополнительная информация
| Поле | Величина |
|---|---|
| Data last updated | 30 марта 2026 г. |
| Метаданные обновлены | 30 марта 2026 г. |
| Создано | 30 марта 2026 г. |
| Формат | CSV |
| Лицензия | License not specified |
| 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 месяца назад |
| 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 |