Troon - Irvine
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:05:00 | 14:05:00 | ... | 1 |
|
| ... | 14:05:50 | 14:05:50 | ... | 2 |
|
| ... | 14:06:34 | 14:06:34 | ... | 3 |
|
| ... | 14:08:16 | 14:08:16 | ... | 4 |
|
| ... | 14:08:51 | 14:08:51 | ... | 5 |
|
| ... | 14:09:16 | 14:09:16 | ... | 6 |
|
| ... | 14:10:01 | 14:10:01 | ... | 7 |
|
| ... | 14:10:41 | 14:10:41 | ... | 8 |
|
| ... | 14:11:00 | 14:11:00 | ... | 9 |
|
| ... | 14:11:28 | 14:11:28 | ... | 10 |
|
| ... | 14:14:37 | 14:14:37 | ... | 11 |
|
| ... | 14:16:00 | 14:16:00 | ... | 12 |
|
| ... | 14:16:50 | 14:16:50 | ... | 13 |
|
| ... | 14:17:46 | 14:17:46 | ... | 14 |
|
| ... | 14:18:31 | 14:18:31 | ... | 15 |
|
| ... | 14:20:14 | 14:20:14 | ... | 16 |
|
| ... | 14:22:17 | 14:22:17 | ... | 17 |
|
| ... | 14:23:08 | 14:23:08 | ... | 18 |
|
| ... | 14:23:54 | 14:23:54 | ... | 19 |
|
| ... | 14:24:28 | 14:24:28 | ... | 20 |
|
| ... | 14:24:53 | 14:24:53 | ... | 21 |
|
| ... | 14:25:30 | 14:25:30 | ... | 22 |
|
| ... | 14:26:00 | 14:26:00 | ... | 23 |
|
| ... | 14:27:45 | 14:27:45 | ... | 24 |
|
| ... | 14:30:33 | 14:30:33 | ... | 25 |
|
| ... | 14:31:27 | 14:31:27 | ... | 26 |
|
| ... | 14:32:00 | 14:32: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 | |
|---|---|---|---|---|
| 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 | |
| 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 | |
| 62925876 | Quarry Road | 55.6173781017 | -4.6687270823 | |
| 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 | |
| 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 |