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
2842,c_1535_b_970_d_31,t_17323_b_970_tn_0,,Gloucester via Thatcher Rd,0,5870,p_5806,,,,,,,,,,
2842,c_1535_b_970_d_31,t_17324_b_970_tn_0,,Gloucester via Thatcher Rd,0,5876,p_5806,,,,,,,,,,
2842,c_1535_b_970_d_31,t_17351_b_970_tn_0,,Gloucester via Thatcher Rd,0,5870,p_6768,,,,,,,,,,
2842,c_1535_b_970_d_31,t_37793_b_970_tn_0,,Gloucester via Thatcher Rd,0,5870,p_5806,,,,,,,,,,