APC Data - dssg/cta-sim GitHub Wiki

select id, serial_number, sort_order, signup_name, stop_id, main_cross_street, travel_direction,
       timepoint, time_actual_arrive, time_actual_depart, serviced_stop, next_day, segment_miles,
       passenger_miles, passengers_on, passengers_off, passengers_in, trip_early, trip_ontime,
       trip_late, fon raw_fon, foff raw_foff, ron raw_ron, roff raw_roff, running_time_scheduled,
       running_time_actual, trip_diff_minutes, time_scheduled, timepoint_miles
from ridecheck_plus.ride_check_detail
where signup_name in ('N-23');