Prestwick and Marchburn circular - Ayr + Dalmilling
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 19:02:00 | 19:02:00 | ... | 1 |
|
| ... | 19:03:08 | 19:03:08 | ... | 2 |
|
| ... | 19:03:58 | 19:03:58 | ... | 3 |
|
| ... | 19:04:48 | 19:04:48 | ... | 4 |
|
| ... | 19:06:15 | 19:06:15 | ... | 5 |
|
| ... | 19:07:08 | 19:07:08 | ... | 6 |
|
| ... | 19:07:40 | 19:07:40 | ... | 7 |
|
| ... | 19:08:34 | 19:08:34 | ... | 8 |
|
| ... | 19:09:09 | 19:09:09 | ... | 9 |
|
| ... | 19:09:40 | 19:09:40 | ... | 10 |
|
| ... | 19:10:18 | 19:10:18 | ... | 11 |
|
| ... | 19:11:02 | 19:11:02 | ... | 12 |
|
| ... | 19:12:00 | 19:12:00 | ... | 13 |
|
| ... | 19:12:42 | 19:12:42 | ... | 14 |
|
| ... | 19:13:38 | 19:13:38 | ... | 15 |
|
| ... | 19:14:04 | 19:14:04 | ... | 16 |
|
| ... | 19:14:40 | 19:14:40 | ... | 17 |
|
| ... | 19:15:09 | 19:15:09 | ... | 18 |
|
| ... | 19:15:57 | 19:15:57 | ... | 19 |
|
| ... | 19:16:23 | 19:16:23 | ... | 20 |
|
| ... | 19:17:02 | 19:17:02 | ... | 21 |
|
| ... | 19:17:22 | 19:17:22 | ... | 22 |
|
| ... | 19:18:29 | 19:18:29 | ... | 23 |
|
| ... | 19:19:01 | 19:19:01 | ... | 24 |
|
| ... | 19:20:00 | 19:20:00 | ... | 25 |
|
| ... | 19:20:30 | 19:20:30 | ... | 26 |
|
| ... | 19:21:00 | 19:21:00 | ... | 27 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 17/09/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 29724678 | Ayr Railway Station | 55.4585434314 | -4.6247633361 | |
| 29724643 | Ayr Railway Station | 55.4589170475 | -4.6241079443 | |
| 29724857 | John Street | 55.4603452637 | -4.6224784987 | |
| 29723786 | Fire Station | 55.4601774281 | -4.6223407961 | |
| 29724365 | Craigie Way | 55.4629088059 | -4.6190416259 | |
| 29723625 | Beech Grove | 55.4619261152 | -4.6086616137 | |
| 29723469 | Lymburn Place | 55.4631772002 | -4.6178412245 | |
| 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 | |
| 29723473 | Killoch Place | 55.4583596952 | -4.6291329683 | |
| 29724738 | Burns Statue Square | 55.4585300909 | -4.6287330177 | |
| 29723835 | Carrick Street | 55.4614826655 | -4.6293725298 | |
| 29723896 | Town Hall | 55.4642952437 | -4.6315058457 | |
| 29723928 | Campbell Court | 55.4618011458 | -4.6060904824 | |
| 29723258 | Churchill Crescent | 55.4627762675 | -4.6003961424 | |
| 29724234 | Beech Grove | 55.4619628134 | -4.6082052496 | |
| 29723635 | Craigie Lea | 55.4623588597 | -4.612392189 | |
| 29724839 | Robertson Crescent | 55.463712079 | -4.5973885069 | |
| 29723787 | Campbell Court | 55.4618415361 | -4.6054603388 | |
| 29724942 | Fullarton Street | 55.4611605861 | -4.6313918729 | |
| 29724953 | Craigie Road | 55.4626570774 | -4.6173637654 | |
| 29786248 | Churchill Crescent | 55.462010024 | -4.603035131 | |
| 29786257 | Craigie Way | 55.4619205983 | -4.6030134159 | |
| 29725232 | Craigie Way | 55.4617271437 | -4.6146126887 |