trip_id,arrival_time,departure_time,stop_id,stop_sequence,pickup_type,drop_off_type,shape_dist_traveled
R1AM_Run1,6:30:00,6:30:00,MAS,1,,,0.0
R1AM_Run1,6:50:00,6:50:00,LCC,2,,,28.776700069655227
R1AM_Run2,6:50:00,6:50:00,LCC,3,,,0.00010441583126107147
R1AM_Run2,6:53:00,6:53:00,MAIN,4,,,0.7720551413629568
R1AM_Run2,7:09:00,7:09:00,ILD_LIB,5,,,15.014376904069017
R1AM_Run2,7:20:00,7:20:00,MED_ARV,6,,,25.530714508048874
R1AM_Run2,7:30:00,7:30:00,MAS,7,,,28.689140910106392
R1AM_Run2,7:50:00,7:50:00,FAN,8,,,38.64506959606509
R1AM_Run3,7:50:00,7:50:00,FAN,10,,,0.0
R1AM_Run3,8:10:00,8:10:00,MAS,11,,,9.97625573854433
R1AM_Run3,8:20:00,8:20:00,MED_ARV,12,,,13.132198158276024
R1AM_Run3,8:31:00,8:31:00,ILD_LIB,13,,,23.672002497465225
R1AM_Run3,8:50:00,8:50:00,LCC,16,,,39.52748288193511
R1AM_Run4,8:50:00,8:50:00,LCC,17,,,0.00011685427953578738
R1AM_Run4,8:53:00,8:53:00,MAIN,20,,,0.7721201960690822
R1AM_Run4,9:09:00,9:09:00,ILD_LIB,21,,,15.009307292209543
R1AM_Run4,9:20:00,9:20:00,MED_ARV,22,,,25.525797393097903
R1AM_Run4,9:30:00,9:30:00,MAS,23,,,28.684670216554327
R1AM_Run4,9:50:00,9:50:00,FAN,24,,,38.66092595509929
R1PM_Run5,15:30:00,15:30:00,FAN,37,,,0.0
R1PM_Run5,15:50:00,15:50:00,MAS,38,,,9.964724350608785
R1PM_Run5,16:00:00,16:00:00,MED_ARV,39,,,13.123597174065456
R1PM_Run5,16:11:00,16:11:00,ILD_LIB,40,,,23.669942414879127
R1PM_Run5,16:30:00,16:30:00,LCC,43,,,39.52605698222699
R1PM_Run6,16:30:00,16:30:00,LCC,44,,,9.870379693364339e-05
R1PM_Run6,16:33:00,16:33:00,MAIN,46,,,1.2148251654283784
R1PM_Run6,16:49:00,16:49:00,ILD_LIB,47,,,15.45136019568623
R1PM_Run6,17:00:00,17:00:00,MED_ARV,48,,,25.965902165689663
R1PM_Run6,17:10:00,17:10:00,MAS,49,,,29.12432856774718
R1PM_Run6,17:30:00,17:30:00,FAN,50,,,39.08992533288685
R1PM_Run7,17:30:00,17:30:00,FAN,51,,,0.0
R1PM_Run7,17:50:00,17:50:00,MAS,52,,,9.964781614171748
R1PM_Run7,18:00:00,18:00:00,MED_ARV,53,,,13.123209952337929
R1PM_Run7,18:11:00,18:11:00,ILD_LIB,54,,,23.66301429152713
R1PM_Run7,18:30:00,18:30:00,LCC,55,,,39.51840387700011
R1PM_Run8,18:30:00,18:30:00,LCC,56,,,0.0
R1PM_Run8,18:33:00,18:33:00,MAIN,57,,,1.2148265219630032
R1PM_Run8,18:50:00,18:50:00,MAS,59,,,28.352509028573976
R2AM_Run1,6:30:00,6:30:00,WTT,60,,,0.0
R2AM_Run1,6:50:00,6:50:00,OX,61,,,15.716079536744369
R2AM_Run1,7:00:00,7:00:00,HAM_PUT2,62,,,23.70365776295297
R2AM_Run1,7:06:00,7:06:00,WOOD_FOX,63,,,30.941346926381772
R2AM_Run1,7:11:00,7:11:00,CATH_CANPOST,67,,,35.65765160956568
R2AM_Run1,7:16:00,7:16:00,NEW_LUD,68,,,38.38635767131798
R2AM_Run1,7:30:00,7:30:00,ARGYLE,69,,,49.53758804654676
R2AM_Run1,7:40:00,7:40:00,FAN,70,,,52.75938867866275
R2AM_Run1,8:00:00,8:00:00,MAS,71,,,62.6683111698313
R2AM_Run2,8:00:00,8:00:00,MAS,72,,,0.0008794353971074408
R2AM_Run2,8:40:00,8:40:00,WOOD_FOX,73,,,27.736232463929767
R2AM_Run3,8:40:00,8:40:00,WOOD_FOX,81,,,0.00023168791589559386
R2AM_Run3,8:45:00,8:45:00,OAK_BYR2,82,,,1.1109417566170847
R2AM_Run3,8:50:00,8:50:00,FXC,83,,,3.267201845434551
R2AM_Run3,8:55:00,8:55:00,CATH_CANPOST,84,,,4.698384648220968
R2AM_Run3,9:00:00,9:00:00,NEW_LUD,85,,,7.426664859599328
R2AM_Run3,9:15:00,9:15:00,ARGYLE,86,,,18.577895234828095
R2AM_Run3,9:28:00,9:28:00,FAN,87,,,21.79969586694409
R2AM_Run3,9:50:00,9:50:00,MAS,88,,,31.70861835811464
R2PM_Run4,9:50:00,9:50:00,MAS,93,,,0.0008794353971074408
R2PM_Run4,10:10:00,10:10:00,FAN,94,,,9.90973593843348
R2PM_Run4,10:20:00,10:20:00,ARGYLE,95,,,13.131536570574468
R2PM_Run4,10:32:00,10:32:00,NEW_LUD,96,,,24.28422807065531
R2PM_Run4,10:37:00,10:37:00,CATH_CANPOST,97,,,27.01482697556028
R2PM_Run4,10:42:00,10:42:00,FXC,99,,,28.343498230903375
R2PM_Run4,10:47:00,10:47:00,OAK_BYR,100,,,30.595379038291632
R2PM_Run4,10:52:00,10:52:00,WOOD_FOX,101,,,31.724765276069473
R2PM_Run4,11:00:00,11:00:00,HAM_PUT,102,,,38.96219369262587
R2PM_Run4,11:10:00,11:10:00,OX,103,,,46.94977191883261
R2PM_Run4,11:30:00,11:30:00,WTT,104,,,62.665875586457965
R2PM_Run5,15:00:00,15:00:00,WTT,105,,,0.0001650377238945428
R2PM_Run5,15:20:00,15:20:00,OX,106,,,15.716258514510024
R2PM_Run5,15:30:00,15:30:00,HAM_PUT2,107,,,23.70383674071863
R2PM_Run5,15:38:00,15:38:00,WOOD_FOX,108,,,30.948445980711465
R2PM_Run5,15:43:00,15:43:00,OAK_BYR2,109,,,32.07477095743208
R2PM_Run5,15:48:00,15:48:00,FXC,110,,,34.22517875785334
R2PM_Run5,15:53:00,15:53:00,CATH_CANPOST,111,,,35.656778191943665
R2PM_Run5,15:58:00,15:58:00,NEW_LUD,112,,,38.39339612816116
R2PM_Run5,16:13:00,16:13:00,ARGYLE,113,,,49.54608762826896
R2PM_Run5,16:25:00,16:25:00,FAN,114,,,52.76788826038462
R2PM_Run5,16:45:00,16:45:00,MAS,115,,,62.67681075155383
R2PM_Run6,16:45:00,16:45:00,MAS,116,,,0.00019385576047819316
R2PM_Run6,17:05:00,17:05:00,FAN,117,,,9.909325637473682
R2PM_Run6,17:15:00,17:15:00,ARGYLE,118,,,13.131126269615331
R2PM_Run6,17:27:00,17:27:00,NEW_LUD,119,,,24.282356644817792
R2PM_Run6,17:32:00,17:32:00,CATH_CANPOST,120,,,27.013044394626636
R2PM_Run6,17:37:00,17:37:00,FXC,121,,,28.347133571332744
R2PM_Run6,17:42:00,17:42:00,OAK_BYR,122,,,30.596711806076982
R2PM_Run6,17:47:00,17:47:00,WOOD_FOX,123,,,31.72623249528106
R2PM_Run6,17:55:00,17:55:00,HAM_PUT,124,,,38.96106350546699
R2PM_Run6,18:05:00,18:05:00,OX,125,,,46.94864173167373
R2PM_Run6,18:25:00,18:25:00,WTT,126,,,62.66474539938503
R3AM_Run1,06:10:00,6:10:00,FXC,127,,,0.0023457208445247387
R3AM_Run1,06:25:00,6:25:00,WIL_COM_EB,128,,,18.350770808824716
R3AM_Run1,06:32:00,6:32:00,WIL_PON_WB,129,,,20.04043328158282
R3AM_Run1,06:40:00,6:40:00,WHITE_OAKS_SB,130,,,24.429162310877473
R3AM_Run1,07:05:00,7:05:00,VAL_HOME,131,,,44.30103726631387
R3AM_Run1,07:11:00,07:11:00,GAYLORD_MICH,132,,,47.69809999264089
R3AM_Run1,07:15:00,07:15:00,STTHOM_HUB,133,,,49.116728010311434
R3AM_Run2,07:15:00,07:15:00,STTHOM_HUB,134,,,0.0
R3AM_Run2,07:30:00,07:30:00,AMAZON,135,,,12.337177905256963
R3AM_Run2,07:45:00,07:45:00,WHITE_OAKS_EB,136,,,27.75575834325847
R3AM_Run2,07:55:00,07:55:00,ENT_PON_EB,137,,,31.616476669142827
R3AM_Run2,08:00:00,08:00:00,WIL_COM_EB,138,,,33.77070263119279
R3AM_Run2,08:15:00,08:15:00,FXC,139,,,48.40960767126972
R3AM_Run3,08:20:00,08:20:00,FXC,140,,,0.0023457208445247387
R3AM_Run3,08:35:00,08:35:00,WIL_COM_EB,141,,,18.350770808824716
R3AM_Run3,08:42:00,08:42:00,WIL_PON_WB,142,,,20.04043328158282
R3AM_Run3,08:50:00,08:50:00,WHITE_OAKS_SB,143,,,24.429162310877473
R3AM_Run3,09:15:00,09:15:00,VAL_HOME,144,,,44.30103726631387
R3AM_Run3,09:21:00,09:21:00,GAYLORD_MICH,145,,,47.69809999264089
R3AM_Run3,09:25:00,09:25:00,STTHOM_HUB,146,,,49.116728010311434
R3AM_Run4,09:25:00,09:25:00,STTHOM_HUB,147,,,0.0
R3AM_Run4,09:40:00,09:40:00,AMAZON,148,,,12.337177905256963
R3AM_Run4,09:55:00,09:55:00,WHITE_OAKS_EB,149,,,27.75575834325847
R3AM_Run4,10:05:00,10:05:00,ENT_PON_EB,150,,,30.21772833666856
R3AM_Run4,10:10:00,10:10:00,WIL_COM_EB,151,,,32.90648928036325
R3AM_Run4,10:25:00,10:25:00,FXC,152,,,47.545922643093384
R3PM_Run1,15:00:00,15:00:00,FXC,153,,,0.0023457208445247387
R3PM_Run1,15:15:00,15:15:00,WIL_COM_EB,154,,,18.350770808824716
R3PM_Run1,15:22:00,15:22:00,WIL_PON_WB,155,,,20.04043328158282
R3PM_Run1,15:30:00,15:30:00,WHITE_OAKS_SB,156,,,24.429162310877473
R3PM_Run1,15:55:00,15:55:00,VAL_HOME,157,,,44.30103726631387
R3PM_Run1,16:01:00,16:01:00,GAYLORD_MICH,158,,,47.69809999264089
R3PM_Run1,16:05:00,16:05:00,STTHOM_HUB,159,,,49.116728010311434
R3PM_Run2,16:05:00,16:05:00,STTHOM_HUB,160,,,0.0
R3PM_Run2,16:20:00,16:20:00,AMAZON,161,,,12.337177905256963
R3PM_Run2,16:35:00,16:35:00,WHITE_OAKS_EB,162,,,27.75575834325847
R3PM_Run2,16:45:00,16:45:00,ENT_PON_EB,163,,,31.616476669142827
R3PM_Run2,16:50:00,16:50:00,WIL_COM_EB,164,,,33.77070263119279
R3PM_Run2,17:05:00,17:05:00,FXC,165,,,48.40960767126972
R3PM_Run3,17:05:00,17:05:00,FXC,166,,,0.0023457208445247387
R3PM_Run3,17:20:00,17:20:00,WIL_COM_EB,167,,,18.350770808824716
R3PM_Run3,17:27:00,17:27:00,WIL_PON_WB,168,,,20.04043328158282
R3PM_Run3,17:35:00,17:35:00,WHITE_OAKS_SB,169,,,24.429162310877473
R3PM_Run3,18:00:00,18:00:00,VAL_HOME,170,,,44.30103726631387
R3PM_Run3,18:06:00,18:06:00,GAYLORD_MICH,171,,,47.69809999264089
R3PM_Run3,18:10:00,18:10:00,STTHOM_HUB,172,,,49.116728010311434
R3PM_Run4,18:10:00,18:10:00,STTHOM_HUB,173,,,0.0
R3PM_Run4,18:25:00,18:25:00,AMAZON,174,,,12.337177905256963
R3PM_Run4,18:40:00,18:40:00,WHITE_OAKS_EB,175,,,27.75575834325847
R3PM_Run4,18:50:00,18:50:00,ENT_PON_EB,176,,,31.616476669142827
R3PM_Run4,18:55:00,18:55:00,WIL_COM_EB,177,,,33.77070263119279
R3PM_Run4,19:10:00,19:10:00,FXC,178,,,48.40960767126972
R3AM_Run1Weekend,08:10:00,08:10:00,FXC,179,,,0.0023457208445247387
R3AM_Run1Weekend,08:25:00,08:25:00,WIL_COM_EB,180,,,18.350770808824716
R3AM_Run1Weekend,08:32:00,08:32:00,WIL_PON_WB,181,,,20.04043328158282
R3AM_Run1Weekend,08:40:00,08:40:00,WHITE_OAKS_SB,182,,,24.429162310877473
R3AM_Run1Weekend,09:05:00,09:05:00,VAL_HOME,183,,,44.30103726631387
R3AM_Run1Weekend,09:11:00,09:11:00,GAYLORD_MICH,184,,,47.69809999264089
R3AM_Run1Weekend,09:15:00,09:15:00,STTHOM_HUB,185,,,49.116728010311434
R3AM_Run2Weekend,09:15:00,09:15:00,STTHOM_HUB,186,,,0.0
R3AM_Run2Weekend,09:30:00,09:30:00,AMAZON,187,,,12.337177905256963
R3AM_Run2Weekend,09:45:00,09:45:00,WHITE_OAKS_EB,188,,,27.75575834325847
R3AM_Run2Weekend,09:55:00,09:55:00,ENT_PON_EB,189,,,31.616476669142827
R3AM_Run2Weekend,10:00:00,10:00:00,WIL_COM_EB,190,,,33.77070263119279
R3AM_Run2Weekend,10:15:00,10:15:00,FXC,191,,,48.40960767126972
R3AM_Run3Weekend,10:20:00,10:20:00,FXC,192,,,0.0023457208445247387
R3AM_Run3Weekend,10:35:00,10:35:00,WIL_COM_EB,193,,,18.350770808824716
R3AM_Run3Weekend,10:42:00,10:42:00,WIL_PON_WB,194,,,20.04043328158282
R3AM_Run3Weekend,10:50:00,10:50:00,WHITE_OAKS_SB,195,,,24.429162310877473
R3AM_Run3Weekend,11:15:00,11:15:00,VAL_HOME,196,,,44.30103726631387
R3AM_Run3Weekend,11:21:00,11:21:00,GAYLORD_MICH,197,,,47.69809999264089
R3AM_Run3Weekend,11:25:00,11:25:00,STTHOM_HUB,198,,,49.116728010311434
R3AM_Run4Weekend,11:25:00,11:25:00,STTHOM_HUB,199,,,0.0
R3AM_Run4Weekend,11:40:00,11:40:00,AMAZON,200,,,12.337177905256963
R3AM_Run4Weekend,11:55:00,11:55:00,WHITE_OAKS_EB,201,,,27.75575834325847
R3AM_Run4Weekend,12:05:00,12:05:00,ENT_PON_EB,202,,,31.616476669142827
R3AM_Run4Weekend,12:10:00,12:10:00,WIL_COM_EB,203,,,33.77070263119279
R3AM_Run4Weekend,12:25:00,12:25:00,FXC,204,,,48.40960767126972
R3PM_Run1Weekend,15:00:00,15:00:00,FXC,205,,,0.0023457208445247387
R3PM_Run1Weekend,15:15:00,15:15:00,WIL_COM_EB,206,,,18.350770808824716
R3PM_Run1Weekend,15:22:00,15:22:00,WIL_PON_WB,207,,,20.04043328158282
R3PM_Run1Weekend,15:30:00,15:30:00,WHITE_OAKS_SB,208,,,24.429162310877473
R3PM_Run1Weekend,15:55:00,15:55:00,VAL_HOME,209,,,44.30103726631387
R3PM_Run1Weekend,16:01:00,16:01:00,GAYLORD_MICH,210,,,47.69809999264089
R3PM_Run1Weekend,16:05:00,16:05:00,STTHOM_HUB,211,,,49.116728010311434
R3PM_Run2Weekend,16:05:00,16:05:00,STTHOM_HUB,212,,,0.0
R3PM_Run2Weekend,16:20:00,16:20:00,AMAZON,213,,,12.337177905256963
R3PM_Run2Weekend,16:35:00,16:35:00,WHITE_OAKS_EB,214,,,27.75575834325847
R3PM_Run2Weekend,16:45:00,16:45:00,ENT_PON_EB,215,,,30.21772833666856
R3PM_Run2Weekend,16:50:00,16:50:00,WIL_COM_EB,216,,,32.90648928036325
R3PM_Run2Weekend,17:05:00,17:05:00,FXC,217,,,47.545922643093384
R3PM_Run3Weekend,17:05:00,17:05:00,FXC,218,,,0.0023457208445247387
R3PM_Run3Weekend,17:20:00,17:20:00,WIL_COM_EB,219,,,18.350770808824716
R3PM_Run3Weekend,17:27:00,17:27:00,WIL_PON_WB,220,,,20.04043328158282
R3PM_Run3Weekend,17:35:00,17:35:00,WHITE_OAKS_SB,221,,,24.429162310877473
R3PM_Run3Weekend,18:00:00,18:00:00,VAL_HOME,222,,,44.30103726631387
R3PM_Run3Weekend,18:06:00,18:06:00,GAYLORD_MICH,223,,,47.69809999264089
R3PM_Run3Weekend,18:10:00,18:10:00,STTHOM_HUB,224,,,49.116728010311434
R3PM_Run4Weekend,18:10:00,18:10:00,STTHOM_HUB,225,,,0.0
R3PM_Run4Weekend,18:25:00,18:25:00,AMAZON,226,,,12.337177905256963
R3PM_Run4Weekend,18:40:00,18:40:00,WHITE_OAKS_EB,227,,,27.75575834325847
R3PM_Run4Weekend,18:50:00,18:50:00,ENT_PON_EB,228,,,30.21772833666856
R3PM_Run4Weekend,18:55:00,18:55:00,WIL_COM_EB,229,,,32.90648928036325
R3PM_Run4Weekend,19:10:00,19:10:00,FXC,230,,,47.545922643093384
