Wick - John o' Groats or Gills Bay
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 08:32:00 | 08:32:00 | ... | 1 |
|
| ... | 08:33:00 | 08:33:00 | ... | 2 |
|
| ... | 08:34:00 | 08:34:00 | ... | 3 |
|
| ... | 08:35:00 | 08:35:00 | ... | 4 |
|
| ... | 08:36:00 | 08:36:00 | ... | 5 |
|
| ... | 08:36:00 | 08:36:00 | ... | 6 |
|
| ... | 08:37:00 | 08:37:00 | ... | 7 |
|
| ... | 08:39:00 | 08:39:00 | ... | 8 |
|
| ... | 08:40:00 | 08:40:00 | ... | 9 |
|
| ... | 08:40:00 | 08:40:00 | ... | 10 |
|
| ... | 08:42:00 | 08:42:00 | ... | 11 |
|
| ... | 08:43:00 | 08:43:00 | ... | 12 |
|
| ... | 08:44:00 | 08:44:00 | ... | 13 |
|
| ... | 08:45:00 | 08:45:00 | ... | 14 |
|
| ... | 08:47:00 | 08:47:00 | ... | 15 |
|
| ... | 08:48:00 | 08:48:00 | ... | 16 |
|
| ... | 08:50:00 | 08:50:00 | ... | 17 |
|
| ... | 08:51:00 | 08:51:00 | ... | 18 |
|
| ... | 08:51:00 | 08:51:00 | ... | 19 |
|
| ... | 08:53:00 | 08:53:00 | ... | 20 |
|
| ... | 08:55:00 | 08:55:00 | ... | 21 |
|
| ... | 08:55:00 | 08:55:00 | ... | 22 |
|
| ... | 08:58:00 | 08:58:00 | ... | 23 |
|
| ... | 08:59:00 | 08:59:00 | ... | 24 |
|
| ... | 09:00:00 | 09:00:00 | ... | 25 |
|
| ... | 09:01:00 | 09:01:00 | ... | 26 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 05/02/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 45343696 | Business Park | 58.4563391842 | -3.1078238065 | |
| 45343763 | Crossroads | 58.4763439941 | -3.1444109331 | |
| 45343764 | Lyth Rd End | 58.5139347741 | -3.1462527449 | |
| 45343765 | Sands Rd End | 58.4727176489 | -3.1360632448 | |
| 45343768 | Lower Reiss Rd End | 58.4817379389 | -3.1408476986 | |
| 45343782 | Quoys of Reiss | 58.4966916769 | -3.148024032 | |
| 45343784 | Killimster Rd End | 58.5082524399 | -3.1529153793 | |
| 45343786 | Beach Rd End | 58.5283138474 | -3.135233548 | |
| 45343789 | Hawkhill Rd End | 58.5432946194 | -3.1054815483 | |
| 45343793 | Road End | 58.5517499088 | -3.0903683353 | |
| 45343795 | Park View Rd End | 58.5648364325 | -3.0818534019 | |
| 45343797 | Freswick House Rd End | 58.5841904541 | -3.0820379844 | |
| 45343823 | Tofts House | 58.6000280088 | -3.0880852477 | |
| 45343825 | Canisbay Rd End | 58.6246980228 | -3.0862693443 | |
| 45343827 | Hilltop House | 58.631292397 | -3.0699745967 | |
| 45343829 | Post Office | 58.6372008334 | -3.0690701296 | |
| 45325982 | Elm Tree Garage | 58.4463997836 | -3.0959126083 | |
| 45325983 | Hill Avenue | 58.4487746196 | -3.0954895996 | |
| 45326235 | Petrol Station | 58.5582316067 | -3.0864964559 | |
| 45326237 | Car Park | 58.643382182 | -3.0688284002 | |
| 45326234 | Old Garage | 58.5345699173 | -3.1234644346 | |
| 45342462 | Tesco | 58.4521759285 | -3.1000162693 | |
| 45342463 | Tesco | 58.451529846 | -3.099944691 | |
| 45342786 | Road End | 58.4601868444 | -3.1136521961 | |
| 45342845 | Skirza Rd End | 58.5939491941 | -3.0868125555 | |
| 45326348 | Bus Terminal | 58.4428557464 | -3.094414807 |