Glasgow - Ardrossan
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 10:00:00 | 10:00:00 | ... | 1 |
|
| ... | 10:00:43 | 10:00:43 | ... | 2 |
|
| ... | 10:01:04 | 10:01:04 | ... | 3 |
|
| ... | 10:01:53 | 10:01:53 | ... | 4 |
|
| ... | 10:02:25 | 10:02:25 | ... | 5 |
|
| ... | 10:02:49 | 10:02:49 | ... | 6 |
|
| ... | 10:03:41 | 10:03:41 | ... | 7 |
|
| ... | 10:04:24 | 10:04:24 | ... | 8 |
|
| ... | 10:05:07 | 10:05:07 | ... | 9 |
|
| ... | 10:06:03 | 10:06:03 | ... | 10 |
|
| ... | 10:06:46 | 10:06:46 | ... | 11 |
|
| ... | 10:07:27 | 10:07:27 | ... | 12 |
|
| ... | 10:08:00 | 10:08:00 | ... | 13 |
|
| ... | 10:08:57 | 10:08:57 | ... | 14 |
|
| ... | 10:10:00 | 10:10:00 | ... | 15 |
|
| ... | 10:10:45 | 10:10:45 | ... | 16 |
|
| ... | 10:11:48 | 10:11:48 | ... | 17 |
|
| ... | 10:13:19 | 10:13:19 | ... | 18 |
|
| ... | 10:14:25 | 10:14:25 | ... | 19 |
|
| ... | 10:15:03 | 10:15:03 | ... | 20 |
|
| ... | 10:15:54 | 10:15:54 | ... | 21 |
|
| ... | 10:16:34 | 10:16:34 | ... | 22 |
|
| ... | 10:17:32 | 10:17:32 | ... | 23 |
|
| ... | 10:18:00 | 10:18:00 | ... | 24 |
|
| ... | 10:18:30 | 10:18:30 | ... | 25 |
|
| ... | 10:18:54 | 10:18:54 | ... | 26 |
|
| ... | 10:19:07 | 10:19:07 | ... | 27 |
|
| ... | 10:20:17 | 10:20:17 | ... | 28 |
|
| ... | 10:21:18 | 10:21:18 | ... | 29 |
|
| ... | 10:25:26 | 10:25:26 | ... | 30 |
|
| ... | 10:25:57 | 10:25:57 | ... | 31 |
|
| ... | 10:26:23 | 10:26:23 | ... | 32 |
|
| ... | 10:26:38 | 10:26:38 | ... | 33 |
|
| ... | 10:27:04 | 10:27:04 | ... | 34 |
|
| ... | 10:27:40 | 10:27:40 | ... | 35 |
|
| ... | 10:28:41 | 10:28:41 | ... | 36 |
|
| ... | 10:32:18 | 10:32:18 | ... | 37 |
|
| ... | 10:32:42 | 10:32:42 | ... | 38 |
|
| ... | 10:33:00 | 10:33:00 | ... | 39 |
|
| ... | 10:33:20 | 10:33:20 | ... | 40 |
|
| ... | 10:33:50 | 10:33:50 | ... | 41 |
|
| ... | 10:34:28 | 10:34:28 | ... | 42 |
|
| ... | 10:35:06 | 10:35:06 | ... | 43 |
|
| ... | 10:35:37 | 10:35:37 | ... | 44 |
|
| ... | 10:36:20 | 10:36:20 | ... | 45 |
|
| ... | 10:37:10 | 10:37:10 | ... | 46 |
|
| ... | 10:39:48 | 10:39:48 | ... | 47 |
|
| ... | 10:40:34 | 10:40:34 | ... | 48 |
|
| ... | 10:41:05 | 10:41:05 | ... | 49 |
|
| ... | 10:41:39 | 10:41:39 | ... | 50 |
|
| ... | 10:42:25 | 10:42:25 | ... | 51 |
|
| ... | 10:43:00 | 10:43:00 | ... | 52 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 04/06/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 62956549 | Sharon Street | 55.7087194562 | -4.7224290021 | |
| 62927545 | James Street | 55.7102459356 | -4.7216914119 | |
| 62925784 | Grotholm Way | 55.6621361015 | -4.7063277889 | |
| 62923794 | Western Crescent | 55.7451524672 | -4.6897342965 | |
| 62923849 | Loadingbank | 55.7426563237 | -4.6912514862 | |
| 62924636 | Park Lane | 55.6606857635 | -4.705655208 | |
| 62923824 | Claremont Crescent | 55.6547378146 | -4.7047200249 | |
| 62923263 | Central Avenue | 55.7467087212 | -4.6876263614 | |
| 62924527 | McGavin Way | 55.6546721698 | -4.708101869 | |
| 62923926 | Segton Avenue | 55.6533203399 | -4.7147651125 | |
| 62923987 | West Doura Way | 55.6517038487 | -4.7187546864 | |
| 62923637 | Pennyburn Road | 55.6502480185 | -4.7244083573 | |
| 62923698 | Pennyburn Bridge | 55.6491644226 | -4.7286727627 | |
| 62924239 | Ardeer Roundabout | 55.6428085019 | -4.7440130703 | |
| 62925252 | Schoolwell Street | 55.6408677318 | -4.756798361 | |
| 62923549 | Garnock Road | 55.6415464289 | -4.7513946402 | |
| 62924646 | Glenriddet Avenue | 55.7462462225 | -4.6853476191 | |
| 62923298 | Valefield Football Ground | 55.7447684412 | -4.6830470141 | |
| 62924389 | Canal place | 55.6341812435 | -4.779035933 | |
| 62923534 | Robertson Crescent | 55.6353175361 | -4.7749053253 | |
| 62923623 | Swimming Pool | 55.6364400555 | -4.7709800996 | |
| 62924789 | Garnock View | 55.7425276648 | -4.681108525 | |
| 62924967 | Hillside Court | 55.6389072331 | -4.7624294842 | |
| 62925263 | Montgomerie Crescent | 55.6394793626 | -4.7982441582 | |
| 62924846 | South Crescent Road | 55.6391678769 | -4.795742688 | |
| 62923278 | Caledonian Road | 55.6366325258 | -4.7926061544 | |
| 62925262 | Garnockside | 55.7403331195 | -4.6791097005 | |
| 62923259 | North Ayrshire Museum | 55.6350175968 | -4.7889157382 | |
| 62923264 | Saltcoats Station | 55.6337604913 | -4.7849014481 | |
| 62923489 | Railway Station | 55.738991272 | -4.6763410237 | |
| 62923829 | South Beach Road | 55.6400781652 | -4.8015449442 | |
| 62923859 | Garnock Campus | 55.7384887021 | -4.6713516249 | |
| 62924346 | Verona Place | 55.640554713 | -4.8066489191 | |
| 62923687 | Crathie Drive | 55.640359523 | -4.808891779 | |
| 62923452 | Hill Street | 55.6397170104 | -4.8133911369 | |
| 62925275 | Longbar Avenue | 55.7382645207 | -4.6655369453 | |
| 62925392 | Willowburn Road | 55.7431096398 | -4.6493277493 | |
| 62923986 | Grahamfield Place | 55.7462816956 | -4.6401887391 | |
| 62924925 | Glebe Road | 55.7488677598 | -4.6373833936 | |
| 62923723 | Strand | 55.7501698198 | -4.6340926597 | |
| 62923692 | Auchenharvie Academy | 55.6371600638 | -4.7677572778 | |
| 62925238 | Pennyburn Roundabout | 55.6459203563 | -4.734280503 | |
| 62923437 | Manuel Avenue | 55.7440265287 | -4.6405621882 | |
| 62924293 | Old Woodwynd Road | 55.6581200502 | -4.7050170052 | |
| 62923954 | Spiers Avenue | 55.7433691657 | -4.6439595618 | |
| 62923984 | Ryeside Place | 55.7131837573 | -4.7213544653 | |
| 62923925 | Dalry Inn | 55.7233582896 | -4.7165201495 | |
| 62924627 | Dalgarven Mill Bridge | 55.6760722056 | -4.7126830998 | |
| 62925264 | Merksworth Avenue | 55.7058392 | -4.7221967503 | |
| 62923484 | Cartleburn Bridge | 55.6694896645 | -4.7103665033 | |
| 62924328 | Putyan Bridge | 55.702738137 | -4.7246234179 | |
| 62923982 | Rye Bridgend | 55.7171278295 | -4.7210397119 |