Your Swiftly data can be downloaded directly from the On-Time Performance (OTP) Module by clicking on the down arrow button highlighted in the image below. This can be found in the middle-right region of the OTP screen, below your agency's “High-Level Stats” or from a route’s OTP Stops view.
Your data can be downloaded from system-wide or route-level pages, and these downloads will generate an exported CSV file based on the filters that you’ve set.
What do the downloads include?
The downloaded data will include all assignment stats, including block_id, trip_id, route information, and vehicle_id. Details for many of these can be found in our Glossary. Here's some additional information about other data included in this CSV:
- sched_adherence_secs: refers to "schedule adherence in seconds". This is the same as on-time performance. Negative values mean that the vehicle departed/arrived earlier than the scheduled time, and positive values mean that the vehicle departed/arrived late.
- scheduled_date & scheduled_time: when the vehicle was scheduled to depart or arrive at the stop.
- actual_date & actual_time: when the vehicle departed or arrived at the stop.
- is_arrival: refers to whether on-time performance is determined by the arrival or departure of vehicles that service that stop. In most cases, this will display as "FALSE", because most stops are defined as having scheduled departure times. "TRUE" means that the data for that stop is stored as an arrival.
This file can then be merged with internal ridership, fare type, lift event data, etc. to get the most comprehensive stop/timepoint level data.