Thurso - Bettyhill
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:50:00 | 07:50:00 | ... | 1 |
|
| ... | 07:50:00 | 07:50:00 | ... | 2 |
|
| ... | 07:51:00 | 07:51:00 | ... | 3 |
|
| ... | 07:53:00 | 07:53:00 | ... | 4 |
|
| ... | 07:54:00 | 07:54:00 | ... | 5 |
|
| ... | 07:55:00 | 07:55:00 | ... | 6 |
|
| ... | 07:56:00 | 07:56:00 | ... | 7 |
|
| ... | 07:58:00 | 07:58:00 | ... | 8 |
|
| ... | 07:59:00 | 07:59:00 | ... | 9 |
|
| ... | 08:00:00 | 08:00:00 | ... | 10 |
|
| ... | 08:02:00 | 08:02:00 | ... | 11 |
|
| ... | 08:09:00 | 08:09:00 | ... | 12 |
|
| ... | 08:11:00 | 08:11:00 | ... | 13 |
|
| ... | 08:12:00 | 08:12:00 | ... | 14 |
|
| ... | 08:12:00 | 08:12:00 | ... | 15 |
|
| ... | 08:13:00 | 08:13:00 | ... | 16 |
|
| ... | 08:15:00 | 08:15:00 | ... | 17 |
|
| ... | 08:16:00 | 08:16:00 | ... | 18 |
|
| ... | 08:17:00 | 08:17:00 | ... | 19 |
|
| ... | 08:18:00 | 08:18:00 | ... | 20 |
|
| ... | 08:20:00 | 08:20:00 | ... | 21 |
|
| ... | 08:21:00 | 08:21:00 | ... | 22 |
|
| ... | 08:21:00 | 08:21:00 | ... | 23 |
|
| ... | 08:21:00 | 08:21:00 | ... | 24 |
|
| ... | 08:22:00 | 08:22:00 | ... | 25 |
|
| ... | 08:23:00 | 08:23:00 | ... | 26 |
|
| ... | 08:23:00 | 08:23:00 | ... | 27 |
|
| ... | 08:23:00 | 08:23:00 | ... | 28 |
|
| ... | 08:25:00 | 08:25:00 | ... | 29 |
|
| ... | 08:27:00 | 08:27:00 | ... | 30 |
|
| ... | 08:29:00 | 08:29:00 | ... | 31 |
|
| ... | 08:30:00 | 08:30:00 | ... | 32 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 12/06/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 45345259 | Shebster Rd End | 58.5851784495 | -3.7124233778 | |
| 45345263 | Business Park Rd End | 58.5970389103 | -3.6815640268 | |
| 45345265 | Business Park Rd End | 58.5971780655 | -3.6812265456 | |
| 45345269 | Janetstown Rd End | 58.5981351068 | -3.5545160509 | |
| 45345273 | Scrabster Mains | 58.6065873873 | -3.5537897087 | |
| 45345274 | Scrabster Mains | 58.6067489845 | -3.5537968798 | |
| 45325845 | Pentland View Nursing Home | 58.60137826 | -3.5425444175 | |
| 45325848 | Miller Place | 58.6036420025 | -3.5492530602 | |
| 45325849 | Pentland View Nursing Home | 58.6018649041 | -3.5439082219 | |
| 45325856 | Brims Rd End | 58.6026333661 | -3.6244178994 | |
| 45325857 | School Place | 58.5980730822 | -3.6432732377 | |
| 45325867 | Brownhill Road | 58.5916554004 | -3.530847147 | |
| 45325868 | St Magnus Road | 58.5934838644 | -3.5334390798 | |
| 45325869 | Thorfinn Terrace | 58.5958933831 | -3.5332520418 | |
| 45325874 | St Peters Church | 58.5938972978 | -3.522841142 | |
| 45325875 | Miller Academy | 58.5917487715 | -3.5260166675 | |
| 45326395 | Dirlot Place | 58.593876199 | -3.5404418544 | |
| 45326397 | Hoy Place | 58.5958255961 | -3.5404243397 | |
| 45326424 | Brims Road | 58.5956081189 | -3.5383327565 | |
| 45326425 | Forss Road | 58.5953814881 | -3.5355009128 | |
| 45327568 | Weigh Inn Hotel | 58.5985089464 | -3.5383741203 | |
| 45325854 | Bus Stance | 58.5797696536 | -3.7352755304 | |
| 45325858 | Forss Mains Rd End | 58.5966546249 | -3.6516212558 | |
| 45325859 | Skiall Rd End | 58.5950193379 | -3.6641912504 | |
| 45325847 | Holborn Place | 58.6097826231 | -3.5547405655 | |
| 45325878 | High School | 58.5880483223 | -3.5320313904 | |
| 45326394 | Ravenshill Road | 58.5933743904 | -3.537339973 | |
| 45342343 | Royal Bank of Scotland | 58.5950623153 | -3.5207926021 | |
| 45342478 | Miller Place | 58.6035491163 | -3.5495071115 | |
| 45342765 | Site Road End | 58.5790406402 | -3.7273793168 | |
| 45342828 | Business and Tech Pk | 58.6039307643 | -3.6834612142 | |
| 45342829 | Business and Tech Pk | 58.6039267421 | -3.6830823697 |