Prestwick Marchburn - Ayr
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 22:00:00 | 22:00:00 | ... | 1 |
|
| ... | 22:02:06 | 22:02:06 | ... | 2 |
|
| ... | 22:03:11 | 22:03:11 | ... | 3 |
|
| ... | 22:03:59 | 22:03:59 | ... | 4 |
|
| ... | 22:04:56 | 22:04:56 | ... | 5 |
|
| ... | 22:06:36 | 22:06:36 | ... | 6 |
|
| ... | 22:08:03 | 22:08:03 | ... | 7 |
|
| ... | 22:10:00 | 22:10:00 | ... | 8 |
|
| ... | 22:11:18 | 22:11:18 | ... | 9 |
|
| ... | 22:12:03 | 22:12:03 | ... | 10 |
|
| ... | 22:12:53 | 22:12:53 | ... | 11 |
|
| ... | 22:13:23 | 22:13:23 | ... | 12 |
|
| ... | 22:13:59 | 22:13:59 | ... | 13 |
|
| ... | 22:15:35 | 22:15:35 | ... | 14 |
|
| ... | 22:16:20 | 22:16:20 | ... | 15 |
|
| ... | 22:17:18 | 22:17:18 | ... | 16 |
|
| ... | 22:17:46 | 22:17:46 | ... | 17 |
|
| ... | 22:18:23 | 22:18:23 | ... | 18 |
|
| ... | 22:18:54 | 22:18:54 | ... | 19 |
|
| ... | 22:19:44 | 22:19:44 | ... | 20 |
|
| ... | 22:20:12 | 22:20:12 | ... | 21 |
|
| ... | 22:20:53 | 22:20:53 | ... | 22 |
|
| ... | 22:21:14 | 22:21:14 | ... | 23 |
|
| ... | 22:22:24 | 22:22:24 | ... | 24 |
|
| ... | 22:22:58 | 22:22:58 | ... | 25 |
|
| ... | 22:24:00 | 22:24:00 | ... | 26 |
|
| ... | 22:25:04 | 22:25:04 | ... | 27 |
|
| ... | 22:26:07 | 22:26:07 | ... | 28 |
|
| ... | 22:27:16 | 22:27:16 | ... | 29 |
|
| ... | 22:28:20 | 22:28:20 | ... | 30 |
|
| ... | 22:28:55 | 22:28:55 | ... | 31 |
|
| ... | 22:29:51 | 22:29:51 | ... | 32 |
|
| ... | 22:30:30 | 22:30:30 | ... | 33 |
|
| ... | 22:30:59 | 22:30:59 | ... | 34 |
|
| ... | 22:31:58 | 22:31:58 | ... | 35 |
|
| ... | 22:32:46 | 22:32:46 | ... | 36 |
|
| ... | 22:33:17 | 22:33:17 | ... | 37 |
|
| ... | 22:34:00 | 22:34:00 | ... | 38 |
|
| ... | 22:34:50 | 22:34:50 | ... | 39 |
|
| ... | 22:35:44 | 22:35:44 | ... | 40 |
|
| ... | 22:36:26 | 22:36:26 | ... | 41 |
|
| ... | 22:37:14 | 22:37:14 | ... | 42 |
|
| ... | 22:37:56 | 22:37:56 | ... | 43 |
|
| ... | 22:38:32 | 22:38:32 | ... | 44 |
|
| ... | 22:39:22 | 22:39:22 | ... | 45 |
|
| ... | 22:40:08 | 22:40:08 | ... | 46 |
|
| ... | 22:40:52 | 22:40:52 | ... | 47 |
|
| ... | 22:42:00 | 22:42:00 | ... | 48 |
|
| ... | 22:42:39 | 22:42:39 | ... | 49 |
|
| ... | 22:43:19 | 22:43:19 | ... | 50 |
|
| ... | 22:44:10 | 22:44:10 | ... | 51 |
|
| ... | 22:45:00 | 22:45:00 | ... | 52 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 15/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 29724643 | Ayr Railway Station | 55.4589170475 | -4.6241079443 | |
| 29723786 | Fire Station | 55.4601774281 | -4.6223407961 | |
| 29724365 | Craigie Way | 55.4629088059 | -4.6190416259 | |
| 29723625 | Beech Grove | 55.4619261152 | -4.6086616137 | |
| 29724374 | Craigie Lea | 55.4623328093 | -4.6127701566 | |
| 29724834 | Craigie way | 55.4615034164 | -4.6145662351 | |
| 29723948 | Churchill Crescent | 55.4625224898 | -4.6009173266 | |
| 29724345 | Robertson Crescent | 55.4638714635 | -4.596655404 | |
| 29724535 | Dunlop Terrace | 55.4649900594 | -4.5935013927 | |
| 29723824 | Mainholm Road | 55.4704864866 | -4.6009198361 | |
| 29724549 | Glenmuir Place | 55.4713948813 | -4.597086977 | |
| 29723974 | Whitletts Court | 55.4725397516 | -4.5939657584 | |
| 29724582 | Woodfield Avenue | 55.4822181359 | -4.6189777118 | |
| 29724768 | Woodfield Crescent | 55.4800469806 | -4.6204638571 | |
| 29724852 | Marchfield Road | 55.4836317492 | -4.6180268264 | |
| 29723429 | Bellesleyhill Road | 55.4774192163 | -4.6222835181 | |
| 29723543 | Lansdowne Road | 55.4760873725 | -4.6231920663 | |
| 29724835 | Tig Road | 55.4743355069 | -4.624404962 | |
| 29723846 | Caelaverock Road | 55.5022273003 | -4.6076057687 | |
| 29724625 | Merrick Avenue | 55.5012840479 | -4.6042019806 | |
| 29724789 | Manson Avenue | 55.5001084584 | -4.5986135636 | |
| 29724842 | Elmbank Street | 55.4718399526 | -4.6263436776 | |
| 29724284 | Crown Street | 55.467569893 | -4.6301260252 | |
| 29723457 | Waggon Road | 55.4703784954 | -4.6278446436 | |
| 29724368 | Lilybank Road | 55.4856835162 | -4.6174981218 | |
| 29723728 | Bruce Avenue | 55.4881915535 | -4.6174903897 | |
| 29724869 | Kingscroft Road | 55.4906719163 | -4.6158343134 | |
| 29724645 | Brandon Gardens | 55.4926885918 | -4.6148439387 | |
| 29723526 | Grangemuir Road | 55.4949679295 | -4.6137600391 | |
| 29724686 | St. Quivox Road | 55.4969520606 | -4.6126089583 | |
| 29724354 | Kyle Street | 55.4985539217 | -4.611258265 | |
| 29724243 | Station Road | 55.5010118128 | -4.6110726427 | |
| 29724324 | St Ninians Pr School | 55.498193423 | -4.5990574212 | |
| 29723686 | Sanquhar Avenue | 55.4967703375 | -4.596651839 | |
| 29724689 | Raith Avenue | 55.4945110005 | -4.5946822601 | |
| 29723485 | Carnell Crescent | 55.4936970343 | -4.5987294524 | |
| 29724745 | Calvinston Road | 55.4862967246 | -4.6051913548 | |
| 29723285 | Ardfin Road | 55.4842738393 | -4.6060550262 | |
| 29723473 | Killoch Place | 55.4583596952 | -4.6291329683 | |
| 29723835 | Carrick Street | 55.4614826655 | -4.6293725298 | |
| 29723896 | Town Hall | 55.4642952437 | -4.6315058457 | |
| 29723928 | Campbell Court | 55.4618011458 | -4.6060904824 | |
| 29724385 | Moor Park Place | 55.4818329944 | -4.6071284233 | |
| 29724953 | Craigie Road | 55.4626570774 | -4.6173637654 | |
| 29785927 | Parks Garage | 55.4788509451 | -4.6015343906 | |
| 29786257 | Craigie Way | 55.4619205983 | -4.6030134159 | |
| 29792462 | Heathfield Road | 55.4758159327 | -4.5907943584 | |
| 29789598 | Asda Superstore | 55.4802053032 | -4.5953243072 | |
| 29796325 | Dalmilling Crescent | 55.4690481849 | -4.6013472385 | |
| 29795975 | Westwood Avenue | 55.4675078262 | -4.6002331054 | |
| 29796598 | Fairview | 55.4890467794 | -4.6039481639 |