File Info: trips.txt

trips.txt: Trips for each route. A trip is a sequence of two or more stops that occurs at specific time.

Unrecognised column in trips.txt: trip_type
Unrecognised column in trips.txt: drt_max_travel_time
Unrecognised column in trips.txt: drt_avg_travel_time
Unrecognised column in trips.txt: drt_advance_book_min
Unrecognised column in trips.txt: drt_pickup_message
Unrecognised column in trips.txt: drt_drop_off_message
Unrecognised column in trips.txt: continuous_pickup_message
Unrecognised column in trips.txt: continuous_drop_off_message
Column
route_id
service_id
trip_id
trip_short_name
trip_headsign
direction_id
block_id
shape_id
bikes_allowed
wheelchair_accessible
trip_type
drt_max_travel_time
drt_avg_travel_time
drt_advance_book_min
drt_pickup_message
drt_drop_off_message
continuous_pickup_message
continuous_drop_off_message

File Extract

route_id,service_id,trip_id,trip_short_name,trip_headsign,direction_id,block_id,shape_id,bikes_allowed,wheelchair_accessible,trip_type,drt_max_travel_time,drt_avg_travel_time,drt_advance_book_min,drt_pickup_message,drt_drop_off_message,continuous_pickup_message,continuous_drop_off_message
1441,c_165_b_25896_d_31,t_74603_b_25896_tn_0,,{Loop Route},,,p_512,,,,1t+20.00,1t+10.00,2.00,"To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road. Pickups are at the driver’s discretion.",Coordinate with your bus driver for a deviated drop off.,,
1441,c_165_b_25896_d_31,t_874344_b_25896_tn_0,,,,,p_787728,,,,1t+20.00,1t+10.00,2.00,"To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road. Pickups are at the driver’s discretion.",Coordinate with your bus driver for a deviated drop off.,,
1441,c_165_b_25896_d_31,t_874322_b_25896_tn_0,,{Loop Route},,,p_787718,,,,1t+20.00,1t+10.00,2.00,"To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road. Pickups are at the driver’s discretion.",Coordinate with your bus driver for a deviated drop off.,,
1441,c_165_b_25896_d_31,t_874321_b_25896_tn_0,,{Loop Route},,,p_787716,,,,1t+20.00,1t+10.00,2.00,"To reserve a deviated trip call 541-367-4775 Monday-Friday 8:00am - 5:00pm at least 2 hours in advance of your trip time. Wait in a safe, visible and low speed area and flag the bus from the side of the road. Pickups are at the driver’s discretion.",Coordinate with your bus driver for a deviated drop off.,,