trip_id,arrival_time,departure_time,stop_id,stop_sequence,stop_headsign,pickup_type,drop_off_type,shape_dist_traveled
23847A419B547,09:00:00,09:00:00,20467,1,,0,0,0
23847A419B547,,,20415,2,,0,0,0.24353474388855
23847A419B547,09:03:00,09:03:00,20416,3,,0,0,0.36828985802149
23847A419B547,09:04:00,09:04:00,20417,4,,0,0,0.55049392421797
23847A419B547,,,20418,5,,0,0,0.97522395188214
23847A419B547,09:05:00,09:05:00,20419,6,,0,0,1.2378695853353
23847A419B547,,,20420,7,,0,0,1.3962585337255
23847A419B547,09:07:00,09:07:00,20470,8,,0,0,1.506345030502
23847A419B547,09:08:00,09:08:00,20421,9,,0,0,1.686470688979
23847A419B547,09:09:00,09:09:00,20422,10,,0,0,2.100437243007
23847A419B547,09:10:00,09:10:00,20423,11,,0,0,2.2783783921676
23847A419B547,,,20424,12,,0,0,2.4090168837551
23847A419B547,,,20425,13,,0,0,2.5771402123752
23847A419B547,,,20426,14,,0,0,2.7475845771491
23847A419B547,,,20427,15,,0,0,2.9173948359728
23847A419B547,09:11:00,09:11:00,20428,16,,0,0,3.1835345070217
23847A419B547,09:16:00,09:16:00,20429,17,,0,0,4.6830834362232
23847A419B547,,,20431,18,,0,0,5.5384533103226
23847A419B547,09:20:00,09:20:00,20432,19,,0,0,5.7516979086672
23847A419B547,,,20433,20,,0,0,5.9591327260257
23847A419B547,09:21:00,09:21:00,20434,21,,0,0,6.1120549620006
23847A419B547,,,20435,22,,0,0,6.4131318294588
23847A419B547,,,20436,23,,0,0,7.1446155744627
23847A419B547,,,20437,24,,0,0,7.3506989762591
23847A419B547,,,20438,25,,0,0,7.5533723225888
23847A419B547,09:28:00,09:28:00,20439,26,,0,0,8.0468093499446
23847A419B547,,,20440,27,,0,0,8.2319919499335
23847A419B547,09:30:00,09:30:00,20441,28,,0,0,8.7025112520916
23847A419B547,,,20442,29,,0,0,8.8375575349051
23847A419B547,09:32:00,09:32:00,20443,30,,0,0,9.0981555699388
23847A419B547,,,20444,31,,0,0,9.3077068576517
23847A419B547,09:34:00,09:34:00,20445,32,,0,0,9.749689980334
23847A419B547,09:35:00,09:35:00,20446,33,,0,0,10.229144684528
23847A419B547,,,20447,34,,0,0,10.384593185244
23847A419B547,09:37:00,09:37:00,20448,35,,0,0,10.741038872554
23847A419B547,09:38:00,09:38:00,20449,36,,0,0,11.169829535217
23847A419B547,,,20450,37,,0,0,11.511147161027
23847A419B547,,,20451,38,,0,0,11.731821990857
23847A419B547,09:41:00,09:41:00,20452,39,,0,0,11.977327228437
23847A419B547,,,20453,40,,0,0,12.261203334314
23847A419B547,09:45:00,09:45:00,20414,41,,0,0,12.615488693506
23847A419B547,,,20454,42,,0,0,12.964759858401
23847A419B547,09:47:00,09:47:00,20455,43,,0,0,13.155414366017
23847A419B547,,,20456,44,,0,0,13.303000643429
23847A419B547,,,20457,45,,0,0,13.435307048306
23847A419B547,09:49:00,09:49:00,20458,46,,0,0,13.66285157074
23847A419B547,09:50:00,09:50:00,20459,47,,0,0,13.912241932189
23847A419B547,,,20460,48,,0,0,14.132934640871
23847A419B547,,,20461,49,,0,0,14.443779553111
23847A419B547,09:53:00,09:53:00,20462,50,,0,0,14.636895413043
23847A419B547,09:56:00,09:56:00,20463,51,,0,0,15.07088929444
23847A419B547,,,20464,52,,0,0,15.655558761265
23847A419B547,,,20465,53,,0,0,16.30487457756
23847A419B547,,,20466,54,,0,0,16.497947050665
23847A419B547,10:00:00,10:00:00,20467,55,,0,0,16.7241604249
23864A419B547,08:45:00,08:45:00,20414,1,,0,0,0
23864A419B547,,,20454,2,,0,0,0.34878474380838
23864A419B547,08:47:00,08:47:00,20455,3,,0,0,0.53943925142402
23864A419B547,,,20456,4,,0,0,0.68702552883619
23864A419B547,,,20457,5,,0,0,0.81933193371273
23864A419B547,08:49:00,08:49:00,20458,6,,0,0,1.0468764561465
23864A419B547,08:50:00,08:50:00,20459,7,,0,0,1.2962668175964
23864A419B547,,,20460,8,,0,0,1.5169595262783
23864A419B547,,,20461,9,,0,0,1.8278044385177
23864A419B547,08:53:00,08:53:00,20462,10,,0,0,2.02092029845
23864A419B547,08:56:00,08:56:00,20463,11,,0,0,2.4549141798469
23864A419B547,,,20464,12,,0,0,3.039583646672
23864A419B547,,,20465,13,,0,0,3.6888994629667
23864A419B547,,,20466,14,,0,0,3.8819719360718
23864A419B547,09:00:00,09:00:00,20467,15,,0,0,4.1081853103073
24771A419B547,11:00:00,11:00:00,21048,1,,0,0,0
24771A419B547,11:10:00,11:10:00,21047,2,,0,0,5.352058255797
24771A419B547,11:18:00,11:18:00,21046,3,,0,0,10.597754593771
24771A419B547,11:30:00,11:30:00,20467,4,,0,0,14.579528269907
24772A419B547,11:36:00,11:36:00,20467,1,,0,0,0
24772A419B547,11:46:00,11:46:00,21046,2,,0,0,4.5152410975733
24772A419B547,11:59:00,11:59:00,21047,3,,0,0,9.7521800877766
24772A419B547,12:30:00,12:30:00,21048,4,,0,0,15.20905981161
24774A419B547,10:06:00,10:06:00,20467,1,,0,0,0
24774A419B547,10:15:00,10:15:00,21046,2,,0,0,4.5152410975733
24774A419B547,10:25:00,10:25:00,21047,3,,0,0,9.7521800877766
24774A419B547,11:00:00,11:00:00,21048,4,,0,0,15.20905981161
24775A419B547,13:10:00,13:10:00,20467,1,,0,0,0
24775A419B547,13:20:00,13:20:00,21046,2,,0,0,4.5152410975733
24775A419B547,13:33:00,13:33:00,21047,3,,0,0,9.7521800877766
24775A419B547,14:00:00,14:00:00,21048,4,,0,0,15.20905981161
24776A419B547,12:30:00,12:30:00,21048,1,,0,0,0
24776A419B547,12:42:00,12:42:00,21047,2,,0,0,5.352058255797
24776A419B547,12:51:00,12:51:00,21046,3,,0,0,10.597754593771
24776A419B547,13:05:00,13:10:00,20467,4,,0,0,14.579528269907
24777A419B547,14:00:00,14:00:00,21048,1,,0,0,0
24777A419B547,14:15:00,14:15:00,21047,2,,0,0,5.352058255797
24777A419B547,14:25:00,14:25:00,21046,3,,0,0,10.597754593771
24777A419B547,14:35:00,14:35:00,20467,4,,0,0,14.579528269907
