Data Dictionary

ID
vehid
Typ
text
Beskrivning

Unique vehicle identifier to which the summarized operating metrics pertain

ID
hr
Typ
text
Beskrivning

Date and hour to which the operating metrics pertain

ID
reported_trips_started
Typ
text
Beskrivning

Count of completed trips as reported by PTCs that started in the specified hour

ID
reported_trip_fractions
Typ
text
Beskrivning

Count of completed trips and portions of completed trips that occurred during the specified hour

ID
pooled_trips_started
Typ
text
Beskrivning

Count of pooled trips as reported by PTCs that started in the specified hour

ID
pooled_trip_fractions
Typ
text
Beskrivning

Count of pooled trips and portions of pooled trips that occurred during the specified hour

ID
routed_trips_started
Typ
text
Beskrivning

Count of all trips that were routed through City's routing processes that started in the specified hour

ID
driver_cancelled_trips
Typ
text
Beskrivning

Count of trips cancelled by the driver, based on the hour the trip was requested

ID
passenger_cancelled_trips
Typ
text
Beskrivning

Count of trips cancelled by the passenger, based on the hour the trip was requested

ID
toronto_boundary_crossed
Typ
text
Beskrivning

A value of true indicates that the vehicle crossed Toronto's boundary during the specified hour

ID
fares
Typ
text
Beskrivning

Fares collected in Canadian dollars during the specified hour

ID
time_available
Typ
text
Beskrivning

Minutes the vehicle spent available and not carrying customers during the specified hour, whether inside or outside the City of Toronto

ID
time_enroute
Typ
text
Beskrivning

Minutes the vehicle spent en route to a passenger pick-up point during the specified hour, whether inside or outside the City of Toronto

ID
time_waiting
Typ
text
Beskrivning

Minutes the vehicle spent waiting for a passenger at the pick-up point during the specified hour, whether inside or outside the City of Toronto

ID
time_ontrip
Typ
text
Beskrivning

Minutes the vehicle spent on trip during the specified hour, whether inside our outside the City of Toronto

ID
dist_available_routed
Typ
text
Beskrivning

Routed kilometres the vehicle travelled while available and not carrying customers within the City of Toronto during the specified hour

ID
dist_enroute_routed
Typ
text
Beskrivning

Routed kilometres the vehicle travelled within the City of Toronto en route to the passenger pick-up point during the specified hour

ID
dist_ontrip_routed
Typ
text
Beskrivning

Routed kilometres the vehicle travelled within the City of Toronto on a trip during the specified hour

ID
dist_ontrip_reported
Typ
text
Beskrivning

Kilometres the vehicle travelled while on trip during the specified hour as reported by PTCs

Mer information

Fält Värde
Data senast uppdaterad 30 mars 2026
Metadata senast uppdaterad 30 mars 2026
Skapad 30 mars 2026
Format CSV
Licens License not specified
Datastore activeTrue
Datastore cache{'CSV': 'ed5ed874-3a55-434f-b0a0-3dbbc29e637c', 'XML': '8df9fa81-eeb7-4214-b10f-11ac004c2a6f', 'JSON': '7d46c100-f7c6-49ad-92c4-136d15603c7a'}
Datastore cache last updateför 2 månader sedan
Extract jobAirflow: Integration Pipeline private-transportation-companies-vehicle-operating-data
Has viewsTrue
Id53edf43b-71ce-419a-a2c3-85fd9ddcb00f
Is previewTrue
Mimetypetext/csv
Package id082c6a32-dcf2-43da-b4ab-8a2b9ec2e35b
Position1
Record count9 003
Stateactive
Url typedatastore
Extract Job Airflow: Integration Pipeline private-transportation-companies-vehicle-operating-data
Is Datastore Cache File?
Datastore Cache
  1. CSV
  2. XML
  3. JSON
Datastore Cache Last Updated
Datastore resource's ID