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
Unrecognised column in trips.txt: booking_rule_id
Unrecognised column in trips.txt: operator_id
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
booking_rule_id
operator_id

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,booking_rule_id,operator_id
11043,BOP00_MTWThF_20201219_20210131,5,,The Boulevard,0,5,11043_0,,,,1.0t+0.00,1.0t+0.00,0.00,,,,,,24
11043,BOP00_MTWThF_20201219_20210131,2,,Domain Road,0,2,11043_1,,,,1.0t+0.00,1.0t+0.00,0.00,,,,,,24
11043,BOP00_MTWThF_20201219_20210131,3,,The Boulevard,0,3,11043_0,,,,1.0t+0.00,1.0t+0.00,0.00,,,,,,24
11043,BOP00_MTWThF_20201219_20210131,4,,The Boulevard,0,4,11043_0,,,,1.0t+0.00,1.0t+0.00,0.00,,,,,,24