Ayr - Troon
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 05:30:00 | 05:30:00 | ... | 1 |
|
| ... | 05:30:47 | 05:30:47 | ... | 2 |
|
| ... | 05:32:05 | 05:32:05 | ... | 3 |
|
| ... | 05:33:02 | 05:33:02 | ... | 4 |
|
| ... | 05:33:33 | 05:33:33 | ... | 5 |
|
| ... | 05:34:24 | 05:34:24 | ... | 6 |
|
| ... | 05:34:58 | 05:34:58 | ... | 7 |
|
| ... | 05:35:25 | 05:35:25 | ... | 8 |
|
| ... | 05:36:17 | 05:36:17 | ... | 9 |
|
| ... | 05:37:00 | 05:37:00 | ... | 10 |
|
| ... | 05:37:27 | 05:37:27 | ... | 11 |
|
| ... | 05:38:06 | 05:38:06 | ... | 12 |
|
| ... | 05:38:52 | 05:38:52 | ... | 13 |
|
| ... | 05:39:41 | 05:39:41 | ... | 14 |
|
| ... | 05:40:19 | 05:40:19 | ... | 15 |
|
| ... | 05:41:03 | 05:41:03 | ... | 16 |
|
| ... | 05:41:41 | 05:41:41 | ... | 17 |
|
| ... | 05:42:14 | 05:42:14 | ... | 18 |
|
| ... | 05:43:00 | 05:43:00 | ... | 19 |
|
| ... | 05:43:36 | 05:43:36 | ... | 20 |
|
| ... | 05:44:41 | 05:44:41 | ... | 21 |
|
| ... | 05:45:24 | 05:45:24 | ... | 22 |
|
| ... | 05:46:32 | 05:46:32 | ... | 23 |
|
| ... | 05:48:00 | 05:48:00 | ... | 24 |
|
| ... | 05:48:42 | 05:48:42 | ... | 25 |
|
| ... | 05:55:58 | 05:55:58 | ... | 26 |
|
| ... | 05:57:15 | 05:57:15 | ... | 27 |
|
| ... | 05:57:54 | 05:57:54 | ... | 28 |
|
| ... | 05:58:24 | 05:58:24 | ... | 29 |
|
| ... | 05:59:12 | 05:59:12 | ... | 30 |
|
| ... | 05:59:54 | 05:59:54 | ... | 31 |
|
| ... | 06:00:38 | 06:00:38 | ... | 32 |
|
| ... | 06:01:00 | 06:01:00 | ... | 33 |
|
| 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 | |
|---|---|---|---|---|
| 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 | |
| 29724695 | Prestwick Airport | 55.5089356295 | -4.6137991276 | |
| 29724254 | Oswald Drive | 55.5039138852 | -4.6086041949 | |
| 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 | |
| 29723572 | Prestwick Holiday Park | 55.5127305113 | -4.6149853911 | |
| 29723927 | Kilmarnock Road | 55.5167148675 | -4.6030670657 | |
| 29723746 | Coronation Street | 55.5192590345 | -4.6034727831 | |
| 29723947 | Fullerton Drive | 55.5345161253 | -4.6410936831 | |
| 29724353 | Bentinck Drive | 55.5330536908 | -4.6488725696 | |
| 29724746 | Lochend Road | 55.534326388 | -4.6523658292 | |
| 29724845 | Lochend Road | 55.5360498465 | -4.6533061276 | |
| 29724383 | Victoria Drive | 55.5386334057 | -4.6556201495 | |
| 29724735 | Dallas Road | 55.5406514911 | -4.6583084628 | |
| 29723278 | Council Offices | 55.5423637143 | -4.661832437 | |
| 29724823 | West Portland Street | 55.543345606 | -4.6633890329 | |
| 29723272 | Citadel Place | 55.4641408711 | -4.6345015994 | |
| 29796238 | Douglas Street | 55.4616380154 | -4.6334328613 | |
| 29795963 | Dow Avenue | 55.5187956321 | -4.6163543077 |