trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled
30921A53B615,09:20:00,09:20:00,1533,1,,0,0,0
30921A53B615,09:21:00,09:21:00,2803,2,,0,0,0.28020121775327
30921A53B615,09:31:00,09:31:00,27689,3,,0,0,1.5057647751648
30921A53B615,,,27690,4,,0,0,1.6884050146816
30921A53B615,09:32:00,09:32:00,1528,5,,0,0,1.8315889560058
30921A53B615,09:33:00,09:33:00,1560,6,,0,0,2.1715595255071
30921A53B615,09:35:00,09:35:00,1562,7,,0,0,2.6275651447982
30921A53B615,09:42:00,09:42:00,9773,8,,0,0,3.4261565484655
30921A53B615,09:46:00,09:46:00,1553,9,,0,0,4.6648610158199
30921A53B615,09:46:00,09:46:00,1576,10,,0,0,4.7698270409801
30917A53B615,17:30:00,17:30:00,1576,1,,0,0,0
30917A53B615,17:35:00,17:35:00,27738,2,,0,0,2.2351605800469
30917A53B615,17:37:00,17:37:00,27692,3,,0,0,2.4267217901593
30917A53B615,,,27693,4,,0,0,2.5434063267461
30917A53B615,17:39:00,17:39:00,27685,5,,0,0,2.6979387752242
30917A53B615,,,27686,6,,0,0,3.3423776496141
30917A53B615,17:45:00,17:45:00,27687,7,,0,0,3.6174565332117
30917A53B615,17:47:00,17:47:00,27688,8,,0,0,4.6670284171231
30917A53B615,17:50:00,17:50:00,1533,9,,0,0,4.9789343919609
30915A53B615,05:00:00,05:00:00,1557,1,,0,0,0
30915A53B615,,,27694,2,,0,0,0.055244925986937
30915A53B615,05:01:00,05:01:00,27705,3,,0,0,0.30864990913643
30915A53B615,,,27726,4,,0,0,0.4054164993651
30915A53B615,05:02:00,05:02:00,27695,5,,0,0,0.54609085765856
30915A53B615,05:03:00,05:03:00,27696,6,,0,0,0.60075198442011
30915A53B615,05:10:00,05:10:00,27697,7,,0,0,0.77370503029337
30915A53B615,05:11:00,05:11:00,27698,8,,0,0,0.87463180381151
30915A53B615,,,27699,9,,0,0,1.0606599250315
30915A53B615,05:12:00,05:12:00,27700,10,,0,0,1.4781816946685
30915A53B615,05:13:00,05:13:00,27701,11,,0,0,1.7795493265475
30915A53B615,05:15:00,05:15:00,27727,12,,0,0,1.8803763280823
30915A53B615,,,27702,13,,0,0,2.0629490775008
30915A53B615,05:16:00,05:16:00,27703,14,,0,0,2.1428424921568
30915A53B615,05:17:00,05:17:00,27728,15,,0,0,2.9459298767827
30915A53B615,,,27710,16,,0,0,3.1716030140683
30915A53B615,05:18:00,05:18:00,27734,17,,0,0,3.3214918951399
30915A53B615,,,27708,18,,0,0,3.4331265340278
30915A53B615,05:19:00,05:19:00,27707,19,,0,0,3.5409443107732
30915A53B615,,,27713,20,,0,0,3.9766200621469
30915A53B615,05:20:00,05:20:00,27729,21,,0,0,4.093370898352
30915A53B615,05:30:00,05:30:00,27706,22,,0,0,4.300300651552
30915A53B615,05:55:00,05:55:00,1576,23,,0,0,24.039883160884
30915A53B615,06:00:00,06:00:00,27738,24,,2,2,26.277040613019
30915A53B615,06:02:00,06:02:00,27692,25,,2,2,26.468601823132
30915A53B615,,,27693,26,,2,2,26.585286359719
30915A53B615,06:03:00,06:03:00,27685,27,,2,2,26.739818808197
30915A53B615,,,27686,28,,2,2,27.384257682587
30915A53B615,06:04:00,06:04:00,27687,29,,2,2,27.659336566184
30915A53B615,06:06:00,06:06:00,27688,30,,2,2,28.708908450096
30915A53B615,06:10:00,06:10:00,1533,31,,0,0,29.020814424933
30914A53B615,07:45:00,07:45:00,1538,1,,2,2,0
30914A53B615,07:53:00,07:53:00,13519,2,,2,2,1.9742232463001
30914A53B615,07:57:00,07:57:00,1563,3,,2,2,5.5949941907395
30914A53B615,07:58:00,07:58:00,27725,4,,2,2,5.8968928294281
30914A53B615,07:59:00,07:59:00,1537,5,,2,2,6.0896206715476
30914A53B615,08:00:00,08:00:00,1557,6,,0,0,6.2207006151953
30914A53B615,,,27694,7,,0,0,6.281982444528
30914A53B615,08:01:00,08:01:00,27705,8,,0,0,6.5353874276775
30914A53B615,,,27726,9,,0,0,6.6321540179062
30914A53B615,08:02:00,08:02:00,27695,10,,0,0,6.7728283761996
30914A53B615,08:03:00,08:03:00,27696,11,,0,0,6.8274895029612
30914A53B615,08:10:00,08:10:00,27697,12,,0,0,7.0004425488344
30914A53B615,08:11:00,08:11:00,27698,13,,0,0,7.1013693223526
30914A53B615,,,27699,14,,0,0,7.2873974435726
30914A53B615,08:12:00,08:12:00,27700,15,,0,0,7.7049192132096
30914A53B615,08:13:00,08:13:00,27701,16,,0,0,8.0062868450886
30914A53B615,08:15:00,08:15:00,27727,17,,0,0,8.1071138466233
30914A53B615,,,27702,18,,0,0,8.2896865960419
30914A53B615,08:16:00,08:16:00,27703,19,,0,0,8.3695800106979
30914A53B615,08:17:00,08:17:00,27728,20,,0,0,9.1726673953237
30914A53B615,,,27710,21,,0,0,9.3983405326094
30914A53B615,08:18:00,08:18:00,27734,22,,0,0,9.548229413681
30914A53B615,,,27708,23,,0,0,9.6598640525689
30914A53B615,,,27707,24,,0,0,9.7676818293143
30914A53B615,08:19:00,08:19:00,27713,25,,0,0,10.203357580688
30914A53B615,08:20:00,08:20:00,27729,26,,0,0,10.320108416893
30914A53B615,08:30:00,08:30:00,27706,27,,0,0,10.527038170093
30914A53B615,08:48:00,08:48:00,1540,28,,2,2,19.875813170935
30914A53B615,08:55:00,08:55:00,1576,29,,0,0,30.311562488242
30914A53B615,09:00:00,09:00:00,27738,30,,0,0,32.547974376212
30914A53B615,09:02:00,09:02:00,27692,31,,0,0,32.739535586325
30914A53B615,,,27693,32,,0,0,32.856220122912
30914A53B615,09:03:00,09:03:00,27685,33,,0,0,33.01075257139
30914A53B615,,,27686,34,,0,0,33.65519144578
30914A53B615,09:10:00,09:10:00,27687,35,,0,0,33.930270329377
30914A53B615,09:12:00,09:12:00,27688,36,,0,0,34.979842213289
30914A53B615,09:20:00,09:20:00,1533,37,,0,0,35.291748188127
30919A53B615,13:20:00,13:20:00,1533,1,,0,0,0
30919A53B615,13:21:00,13:21:00,2803,2,,0,0,0.28020121775327
30919A53B615,13:31:00,13:31:00,27689,3,,0,0,1.5057647751648
30919A53B615,,,27690,4,,0,0,1.6884050146816
30919A53B615,13:32:00,13:32:00,1528,5,,0,0,1.8315889560058
30919A53B615,13:33:00,13:33:00,1560,6,,0,0,2.1715595255071
30919A53B615,13:35:00,13:35:00,1562,7,,0,0,2.6275651447982
30919A53B615,13:42:00,13:42:00,9773,8,,0,0,3.4261565484655
30919A53B615,13:46:00,13:46:00,1553,9,,0,0,4.6648610158199
30919A53B615,13:56:00,13:56:00,1576,10,,0,0,4.7698270409801
30919A53B615,14:10:00,14:10:00,1540,11,,0,0,15.265849677246
30919A53B615,14:25:00,14:25:00,1526,12,,0,0,24.231991825767
30919A53B615,14:26:00,14:26:00,27706,13,,0,0,24.602004997374
30919A53B615,14:27:00,14:27:00,27736,14,,0,0,24.840449010191
30919A53B615,,,27732,15,,0,0,25.390934335541
30919A53B615,,,27733,16,,0,0,25.505522494371
30919A53B615,14:28:00,14:28:00,27709,17,,0,0,25.630938388791
30919A53B615,,,27735,18,,0,0,25.78750978693
30919A53B615,,,27737,19,,0,0,26.00700691515
30919A53B615,14:29:00,14:29:00,27711,20,,0,0,26.793404772413
30919A53B615,,,27712,21,,0,0,26.876455676867
30919A53B615,,,27715,22,,0,0,27.040149969108
30919A53B615,,,27716,23,,0,0,27.164220139867
30919A53B615,14:30:00,14:30:00,27717,24,,0,0,27.512324521177
30919A53B615,,,27731,25,,0,0,27.839462315858
30919A53B615,,,27718,26,,0,0,28.057345589473
30919A53B615,14:31:00,14:31:00,27719,27,,0,0,28.161664852931
30919A53B615,,,27720,28,,0,0,28.254880996915
30919A53B615,14:32:00,14:32:00,27721,29,,0,0,28.409130620025
30919A53B615,,,27722,30,,0,0,28.489219402565
30919A53B615,14:33:00,14:33:00,27723,31,,0,0,28.616496248853
30919A53B615,14:34:00,14:34:00,27724,32,,0,0,28.860022160907
30919A53B615,14:35:00,14:35:00,1537,33,,0,0,29.010132228666
30919A53B615,,,1557,34,,0,0,29.141510017622
30919A53B615,14:36:00,14:36:00,1552,35,,0,0,29.266633962219
30919A53B615,,,27730,36,,0,0,29.514720803408
30919A53B615,14:50:00,14:50:00,1538,37,,0,0,35.229363087822
30918A53B615,10:20:00,10:20:00,1533,1,,0,0,0
30918A53B615,10:21:00,10:21:00,2803,2,,0,0,0.28020121775327
30918A53B615,10:31:00,10:31:00,27689,3,,0,0,1.5057647751648
30918A53B615,,,27690,4,,0,0,1.6884050146816
30918A53B615,10:32:00,10:32:00,1528,5,,0,0,1.8315889560058
30918A53B615,10:33:00,10:33:00,1560,6,,0,0,2.1715595255071
30918A53B615,10:35:00,10:35:00,1562,7,,0,0,2.6275651447982
30918A53B615,10:42:00,10:42:00,9773,8,,0,0,3.4261565484655
30918A53B615,10:46:00,10:46:00,1553,9,,0,0,4.6648610158199
30918A53B615,,,1576,10,,0,0,4.7698270409801
30918A53B615,11:00:00,11:00:00,1540,11,,0,0,15.265849677246
30918A53B615,11:15:00,11:15:00,1526,12,,0,0,24.231991825767
30918A53B615,11:16:00,11:16:00,27706,13,,0,0,24.602004997374
30918A53B615,11:17:00,11:17:00,27736,14,,0,0,24.840449010191
30918A53B615,,,27732,15,,0,0,25.390934335541
30918A53B615,,,27733,16,,0,0,25.505522494371
30918A53B615,11:18:00,11:18:00,27709,17,,0,0,25.630938388791
30918A53B615,,,27735,18,,0,0,25.78750978693
30918A53B615,,,27737,19,,0,0,26.00700691515
30918A53B615,11:19:00,11:19:00,27711,20,,0,0,26.793404772413
30918A53B615,,,27712,21,,0,0,26.876455676867
30918A53B615,,,27715,22,,0,0,27.040149969108
30918A53B615,,,27716,23,,0,0,27.164220139867
30918A53B615,11:20:00,11:20:00,27717,24,,0,0,27.512324521177
30918A53B615,,,27731,25,,0,0,27.839462315858
30918A53B615,,,27718,26,,0,0,28.057345589473
30918A53B615,11:21:00,11:21:00,27719,27,,0,0,28.161664852931
30918A53B615,,,27720,28,,0,0,28.254880996915
30918A53B615,11:22:00,11:22:00,27721,29,,0,0,28.409130620025
30918A53B615,,,27722,30,,0,0,28.489219402565
30918A53B615,11:23:00,11:23:00,27723,31,,0,0,28.616496248853
30918A53B615,11:24:00,11:24:00,27724,32,,0,0,28.860022160907
30918A53B615,11:25:00,11:25:00,1537,33,,0,0,29.010132228666
30918A53B615,,,1557,34,,0,0,29.141510017622
30918A53B615,11:26:00,11:26:00,1552,35,,0,0,29.266633962219
30918A53B615,,,27730,36,,0,0,29.514720803408
30918A53B615,11:40:00,11:40:00,1538,37,,0,0,35.229363087822
30922A53B615,05:15:00,05:15:00,27706,1,,0,0,0
30922A53B615,05:16:00,05:16:00,27736,2,,0,0,0.23836059228938
30922A53B615,,,27732,3,,0,0,0.78884591763907
30922A53B615,05:17:00,05:17:00,27733,4,,0,0,0.90343407646897
30922A53B615,,,27709,5,,0,0,1.0288499708893
30922A53B615,05:18:00,05:18:00,27735,6,,0,0,1.185421369028
30922A53B615,,,27737,7,,0,0,1.404918497248
30922A53B615,05:19:00,05:19:00,27703,8,,0,0,2.1907321399354
30922A53B615,,,27712,9,,0,0,2.2737830443898
30922A53B615,05:20:00,05:20:00,27715,10,,0,0,2.4374773366304
30922A53B615,05:25:00,05:25:00,27716,11,,0,0,2.5615475073897
30922A53B615,05:26:00,05:26:00,27717,12,,0,0,2.9096518886998
30922A53B615,,,27731,13,,0,0,3.2367896833804
30922A53B615,05:27:00,05:27:00,27718,14,,0,0,3.4546729569953
30922A53B615,05:30:00,05:30:00,27719,15,,0,0,3.5589922204533
30922A53B615,,,27720,16,,0,0,3.652208364437
30922A53B615,,,27721,17,,0,0,3.8064579875474
30922A53B615,05:31:00,05:31:00,27722,18,,0,0,3.8865467700871
30922A53B615,05:32:00,05:32:00,27723,19,,0,0,4.013823616375
30922A53B615,,,27724,20,,0,0,4.2573495284295
30922A53B615,05:35:00,05:35:00,1537,21,,0,0,4.4074595961885
30922A53B615,,,1557,22,,0,0,4.5388373851443
30922A53B615,,,1552,23,,0,0,4.6639613297411
30922A53B615,05:36:00,05:36:00,27730,24,,0,0,4.9120481709305
30922A53B615,05:45:00,05:45:00,1538,25,,2,2,10.626690455345
30922A53B615,05:48:00,05:48:00,13519,26,,2,2,12.607752404414
30922A53B615,06:05:00,06:05:00,27691,27,,2,2,30.113028144589
30922A53B615,06:25:00,06:25:00,1531,28,,0,0,39.597744684984
30916A53B615,11:45:00,11:45:00,1538,1,,2,2,0
30916A53B615,11:53:00,11:53:00,13519,2,,2,2,1.9742232463001
30916A53B615,11:57:00,11:57:00,1563,3,,2,2,5.5949941907395
30916A53B615,11:58:00,11:58:00,27725,4,,2,2,5.8968928294281
30916A53B615,11:59:00,11:59:00,1537,5,,2,2,6.0896206715476
30916A53B615,12:00:00,12:00:00,1557,6,,0,0,6.2207006151953
30916A53B615,,,27694,7,,0,0,6.281982444528
30916A53B615,12:01:00,12:01:00,27705,8,,0,0,6.5353874276775
30916A53B615,,,27726,9,,0,0,6.6321540179062
30916A53B615,12:02:00,12:02:00,27695,10,,0,0,6.7728283761996
30916A53B615,12:03:00,12:03:00,27696,11,,0,0,6.8274895029612
30916A53B615,12:10:00,12:10:00,27697,12,,0,0,7.0004425488344
30916A53B615,12:11:00,12:11:00,27698,13,,0,0,7.1013693223526
30916A53B615,,,27699,14,,0,0,7.2873974435726
30916A53B615,12:12:00,12:12:00,27700,15,,0,0,7.7049192132096
30916A53B615,12:13:00,12:13:00,27701,16,,0,0,8.0062868450886
30916A53B615,12:15:00,12:15:00,27727,17,,0,0,8.1071138466233
30916A53B615,,,27702,18,,0,0,8.2896865960419
30916A53B615,12:16:00,12:16:00,27703,19,,0,0,8.3695800106979
30916A53B615,12:17:00,12:17:00,27728,20,,0,0,9.1726673953237
30916A53B615,,,27710,21,,0,0,9.3983405326094
30916A53B615,12:18:00,12:18:00,27734,22,,0,0,9.548229413681
30916A53B615,,,27708,23,,0,0,9.6598640525689
30916A53B615,,,27707,24,,0,0,9.7676818293143
30916A53B615,12:19:00,12:19:00,27713,25,,0,0,10.203357580688
30916A53B615,12:20:00,12:20:00,27729,26,,0,0,10.320108416893
30916A53B615,12:30:00,12:30:00,27706,27,,0,0,10.527038170093
30916A53B615,12:48:00,12:48:00,1540,28,,2,2,19.875813170935
30916A53B615,12:55:00,12:55:00,1576,29,,0,0,30.311562488242
30916A53B615,13:00:00,13:00:00,27738,30,,0,0,32.547974376212
30916A53B615,13:02:00,13:02:00,27692,31,,0,0,32.739535586325
30916A53B615,,,27693,32,,0,0,32.856220122912
30916A53B615,13:03:00,13:03:00,27685,33,,0,0,33.01075257139
30916A53B615,,,27686,34,,0,0,33.65519144578
30916A53B615,13:10:00,13:10:00,27687,35,,0,0,33.930270329377
30916A53B615,13:12:00,13:12:00,27688,36,,0,0,34.979842213289
30916A53B615,13:20:00,13:20:00,1533,37,,0,0,35.291748188127
30920A53B615,17:50:00,17:50:00,1533,1,,0,0,0
30920A53B615,17:51:00,17:51:00,2803,2,,0,0,0.28020121775327
30920A53B615,18:01:00,18:01:00,27689,3,,0,0,1.5057647751648
30920A53B615,,,27690,4,,0,0,1.6884050146816
30920A53B615,18:02:00,18:02:00,1528,5,,0,0,1.8315889560058
30920A53B615,18:03:00,18:03:00,1560,6,,0,0,2.1715595255071
30920A53B615,18:05:00,18:05:00,1562,7,,0,0,2.6275651447982
30920A53B615,18:12:00,18:12:00,9773,8,,0,0,3.4261565484655
30920A53B615,18:16:00,18:16:00,1553,9,,0,0,4.6648610158199
30920A53B615,18:26:00,18:26:00,1576,10,,0,0,4.7698270409801
30920A53B615,18:40:00,18:40:00,1540,11,,0,0,15.265849677246
30920A53B615,18:55:00,18:55:00,1526,12,,0,0,24.231991825767
30920A53B615,18:56:00,18:56:00,27706,13,,0,0,24.602004997374
30920A53B615,18:57:00,18:57:00,27736,14,,0,0,24.840449010191
30920A53B615,,,27732,15,,0,0,25.390934335541
30920A53B615,,,27733,16,,0,0,25.505522494371
30920A53B615,18:58:00,18:58:00,27709,17,,0,0,25.630938388791
30920A53B615,,,27735,18,,0,0,25.78750978693
30920A53B615,,,27737,19,,0,0,26.00700691515
30920A53B615,18:59:00,18:59:00,27711,20,,0,0,26.793404772413
30920A53B615,,,27712,21,,0,0,26.876455676867
30920A53B615,,,27715,22,,0,0,27.040149969108
30920A53B615,,,27716,23,,0,0,27.164220139867
30920A53B615,19:00:00,19:00:00,27717,24,,0,0,27.512324521177
30920A53B615,,,27731,25,,0,0,27.839462315858
30920A53B615,,,27718,26,,0,0,28.057345589473
30920A53B615,19:01:00,19:01:00,27719,27,,0,0,28.161664852931
30920A53B615,,,27720,28,,0,0,28.254880996915
30920A53B615,19:02:00,19:02:00,27721,29,,0,0,28.409130620025
30920A53B615,,,27722,30,,0,0,28.489219402565
30920A53B615,19:03:00,19:03:00,27723,31,,0,0,28.616496248853
30920A53B615,19:04:00,19:04:00,27724,32,,0,0,28.860022160907
30920A53B615,19:05:00,19:05:00,1537,33,,0,0,29.010132228666
30920A53B615,,,1557,34,,0,0,29.141510017622
30920A53B615,19:06:00,19:06:00,1552,35,,0,0,29.266633962219
30920A53B615,,,27730,36,,0,0,29.514720803408
30920A53B615,19:20:00,19:20:00,1538,37,,0,0,35.229363087822
30926A53B615,18:00:00,18:00:00,1531,1,,0,0,0
30926A53B615,18:23:00,18:23:00,27691,2,,0,0,9.2951633868329
30926A53B615,18:45:00,18:45:00,1538,3,,0,0,29.281717428088
30926A53B615,18:48:00,18:48:00,13519,4,,0,0,31.262781157705
30926A53B615,18:58:00,18:58:00,1563,5,,0,0,34.883552102145
30926A53B615,18:59:00,18:59:00,27725,6,,0,0,35.185450740833
30926A53B615,,,1537,7,,0,0,35.378178582953
30926A53B615,19:00:00,19:00:00,1557,8,,0,0,35.509258526601
30926A53B615,19:01:00,19:01:00,27694,9,,0,0,35.570540355933
30926A53B615,,,27705,10,,0,0,35.823945339083
30926A53B615,19:02:00,19:02:00,27726,11,,0,0,35.920711929311
30926A53B615,19:03:00,19:03:00,27695,12,,0,0,36.061386287605
30926A53B615,,,27696,13,,0,0,36.116047414366
30926A53B615,19:05:00,19:05:00,27697,14,,0,0,36.28900046024
30926A53B615,,,27698,15,,0,0,36.389927233758
30926A53B615,19:06:00,19:06:00,27699,16,,0,0,36.575955354978
30926A53B615,19:07:00,19:07:00,27700,17,,0,0,36.993477124615
30926A53B615,19:08:00,19:08:00,27701,18,,0,0,37.294844756494
30926A53B615,19:15:00,19:15:00,27727,19,,0,0,37.395671758029
30926A53B615,19:16:00,19:16:00,27702,20,,0,0,37.578244507447
30926A53B615,,,27703,21,,0,0,37.658137922103
30926A53B615,19:17:00,19:17:00,27728,22,,0,0,38.461225306729
30926A53B615,,,27710,23,,0,0,38.686898444015
30926A53B615,19:18:00,19:18:00,27734,24,,0,0,38.836787325086
30926A53B615,,,27708,25,,0,0,38.948421963974
30926A53B615,19:19:00,19:19:00,27707,26,,0,0,39.05623974072
30926A53B615,19:20:00,19:20:00,27713,27,,0,0,39.491915492093
30926A53B615,,,27729,28,,0,0,39.608666328298
30926A53B615,19:25:00,19:25:00,27706,29,,0,0,39.815596081498
