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
6279,c_15975_b_17412_d_31,t_501036_b_17412_tn_0,,BART (5th and Market),0,6,p_180228,,,,,,,,,,
6279,c_15975_b_17412_d_31,t_501034_b_17412_tn_0,,BART (5th and Market),0,4,p_180228,,,,,,,,,,
6279,c_15975_b_17412_d_31,t_501035_b_17412_tn_0,,BART (5th and Market),0,5,p_180228,,,,,,,,,,
6279,c_15975_b_17412_d_31,t_501031_b_17412_tn_0,,16th and 4th,1,4,p_180227,,,,,,,,,,