Ayr - Troon
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 05:20:00 | 05:20:00 | ... | 1 |
|
| ... | 05:20:36 | 05:20:36 | ... | 2 |
|
| ... | 05:21:36 | 05:21:36 | ... | 3 |
|
| ... | 05:22:20 | 05:22:20 | ... | 4 |
|
| ... | 05:22:44 | 05:22:44 | ... | 5 |
|
| ... | 05:23:23 | 05:23:23 | ... | 6 |
|
| ... | 05:23:49 | 05:23:49 | ... | 7 |
|
| ... | 05:24:10 | 05:24:10 | ... | 8 |
|
| ... | 05:24:50 | 05:24:50 | ... | 9 |
|
| ... | 05:25:23 | 05:25:23 | ... | 10 |
|
| ... | 05:25:44 | 05:25:44 | ... | 11 |
|
| ... | 05:26:13 | 05:26:13 | ... | 12 |
|
| ... | 05:26:49 | 05:26:49 | ... | 13 |
|
| ... | 05:27:27 | 05:27:27 | ... | 14 |
|
| ... | 05:27:56 | 05:27:56 | ... | 15 |
|
| ... | 05:28:30 | 05:28:30 | ... | 16 |
|
| ... | 05:28:59 | 05:28:59 | ... | 17 |
|
| ... | 05:29:25 | 05:29:25 | ... | 18 |
|
| ... | 05:30:00 | 05:30:00 | ... | 19 |
|
| ... | 05:30:36 | 05:30:36 | ... | 20 |
|
| ... | 05:31:41 | 05:31:41 | ... | 21 |
|
| ... | 05:32:24 | 05:32:24 | ... | 22 |
|
| ... | 05:33:32 | 05:33:32 | ... | 23 |
|
| ... | 05:35:00 | 05:35:00 | ... | 24 |
|
| ... | 05:35:39 | 05:35:39 | ... | 25 |
|
| ... | 05:42:21 | 05:42:21 | ... | 26 |
|
| ... | 05:43:32 | 05:43:32 | ... | 27 |
|
| ... | 05:44:08 | 05:44:08 | ... | 28 |
|
| ... | 05:44:36 | 05:44:36 | ... | 29 |
|
| ... | 05:45:20 | 05:45:20 | ... | 30 |
|
| ... | 05:45:59 | 05:45:59 | ... | 31 |
|
| ... | 05:46:39 | 05:46:39 | ... | 32 |
|
| ... | 05:47:00 | 05:47:00 | ... | 33 |
|
| ... | 05:47:33 | 05:47:33 | ... | 34 |
|
| ... | 05:48:03 | 05:48:03 | ... | 35 |
|
| ... | 05:49:10 | 05:49:10 | ... | 36 |
|
| ... | 05:49:34 | 05:49:34 | ... | 37 |
|
| ... | 05:49:51 | 05:49:51 | ... | 38 |
|
| ... | 05:50:20 | 05:50:20 | ... | 39 |
|
| ... | 05:50:47 | 05:50:47 | ... | 40 |
|
| ... | 05:51:00 | 05:51:00 | ... | 41 |
|
| ... | 05:51:31 | 05:51:31 | ... | 42 |
|
| ... | 05:55:00 | 05:55:00 | ... | 43 |
|
| ... | 05:55:37 | 05:55:37 | ... | 44 |
|
| ... | 05:56:25 | 05:56:25 | ... | 45 |
|
| ... | 05:57:17 | 05:57:17 | ... | 46 |
|
| ... | 05:57:59 | 05:57:59 | ... | 47 |
|
| ... | 05:59:36 | 05:59:36 | ... | 48 |
|
| ... | 06:01:31 | 06:01:31 | ... | 49 |
|
| ... | 06:02:19 | 06:02:19 | ... | 50 |
|
| ... | 06:03:02 | 06:03:02 | ... | 51 |
|
| ... | 06:03:34 | 06:03:34 | ... | 52 |
|
| ... | 06:03:57 | 06:03:57 | ... | 53 |
|
| ... | 06:04:32 | 06:04:32 | ... | 54 |
|
| ... | 06:05:00 | 06:05:00 | ... | 55 |
|
| ... | 06:05:52 | 06:05:52 | ... | 56 |
|
| ... | 06:07:16 | 06:07:16 | ... | 57 |
|
| ... | 06:07:43 | 06:07:43 | ... | 58 |
|
| ... | 06:08:00 | 06:08:00 | ... | 59 |
|
| ... | 06:09:08 | 06:09:08 | ... | 60 |
|
| ... | 06:09:37 | 06:09:37 | ... | 61 |
|
| ... | 06:10:39 | 06:10:39 | ... | 62 |
|
| ... | 06:11:26 | 06:11:26 | ... | 63 |
|
| ... | 06:12:19 | 06:12:19 | ... | 64 |
|
| ... | 06:12:42 | 06:12:42 | ... | 65 |
|
| ... | 06:13:08 | 06:13:08 | ... | 66 |
|
| ... | 06:13:37 | 06:13:37 | ... | 67 |
|
| ... | 06:14:16 | 06:14:16 | ... | 68 |
|
| ... | 06:14:40 | 06:14:40 | ... | 69 |
|
| ... | 06:15:00 | 06:15:00 | ... | 70 |
|
| 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 | |
|---|---|---|---|---|
| 62923658 | Burns Crescent | 55.6270944107 | -4.6401079789 | |
| 62956452 | West Bowhouse Head | 55.6286619433 | -4.638275151 | |
| 62923793 | Stane Castle | 55.6257404711 | -4.6416214267 | |
| 62968429 | Marine Road | 55.5945050207 | -4.6553313793 | |
| 62932348 | Shewalton Road | 55.5978657419 | -4.6599400835 | |
| 62924295 | Lamont Drive | 55.6056174233 | -4.6664035641 | |
| 62924395 | Heatherhouse Road | 55.6035934305 | -4.6656469374 | |
| 62923287 | Carson Drive | 55.6010087697 | -4.6638045054 | |
| 62924567 | McKinlay Crescent | 55.6109837539 | -4.6684671704 | |
| 62923726 | Sanderson Avenue | 55.6087050061 | -4.6670260729 | |
| 62924754 | Marress Roundabout | 55.61308879 | -4.672104149 | |
| 62923939 | Bank Street | 55.6150789949 | -4.6673955154 | |
| 62924697 | Clark Drive | 55.6220215884 | -4.6523317558 | |
| 62924862 | Stanecastle Roundabout | 55.6235804956 | -4.6471630838 | |
| 62923432 | Galt Avenue | 55.6183776555 | -4.6566441189 | |
| 62924929 | Ballot Road | 55.6173654004 | -4.6597998906 | |
| 62924732 | Dundonald Camp | 55.5736381362 | -4.6409600981 | |
| 62924649 | Auchengate Crescent | 55.5772425636 | -4.6426302167 | |
| 62924743 | Meadowhead Avenue | 55.5854029852 | -4.6472733359 | |
| 62924362 | Gailes Burns | 55.5690961053 | -4.6394177392 | |
| 62925789 | Crown Inn | 55.615910956 | -4.6679920477 | |
| 62936525 | Bowhouse Way | 55.6294096676 | -4.6273151236 | |
| 62925876 | Quarry Road | 55.6173781017 | -4.6687270823 | |
| 62953496 | Perceton Roundabout | 55.6301470235 | -4.6252037055 | |
| 62925389 | Ladyha Court | 55.6285982159 | -4.6299457877 | |
| 62925323 | West Bowhouse Head | 55.6281901673 | -4.6347164303 | |
| 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 | |
| 29724545 | The Knowe | 55.565017612 | -4.6376371874 | |
| 29723627 | Barassie Bank Lane | 55.5600784666 | -4.6548946899 | |
| 29725365 | Walker Avenue | 55.5519992749 | -4.656886704 | |
| 29723836 | Burnfoot Way | 55.5545735788 | -4.6542378367 | |
| 29723272 | Citadel Place | 55.4641408711 | -4.6345015994 | |
| 29723245 | North Shore Road | 55.5535574207 | -4.6555013133 | |
| 29723638 | Lang Road | 55.5630800439 | -4.6424559342 | |
| 29723474 | Arran View | 55.5473329711 | -4.6602500407 | |
| 29724832 | Morrisons Supermarket | 55.5458601365 | -4.6630835397 | |
| 29785985 | Muir Drive | 55.5566830435 | -4.6531273036 | |
| 29786296 | Johnston Drive | 55.5586814202 | -4.6525801052 | |
| 29785839 | Barassiebank Lane | 55.5590088848 | -4.6540612583 | |
| 29796238 | Douglas Street | 55.4616380154 | -4.6334328613 | |
| 29795963 | Dow Avenue | 55.5187956321 | -4.6163543077 |