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:57:00 | 07:57:00 | ... | 8 |
|
| ... | 07:58:00 | 07:58:00 | ... | 9 |
|
| ... | 07:59:00 | 07:59:00 | ... | 10 |
|
| ... | 08:01:00 | 08:01:00 | ... | 11 |
|
| ... | 08:07:00 | 08:07:00 | ... | 12 |
|
| ... | 08:08:00 | 08:08:00 | ... | 13 |
|
| ... | 08:08:00 | 08:08:00 | ... | 14 |
|
| ... | 08:09:00 | 08:09:00 | ... | 15 |
|
| ... | 08:10:00 | 08:10:00 | ... | 16 |
|
| 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 | |
| 45325856 | Brims Rd End | 58.6026333661 | -3.6244178994 | |
| 45325857 | School Place | 58.5980730822 | -3.6432732377 | |
| 45325872 | Camp Site | 58.5980014664 | -3.5304705989 | |
| 45327567 | Lidl | 58.5980357039 | -3.5313669076 | |
| 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 | |
| 45342343 | Royal Bank of Scotland | 58.5950623153 | -3.5207926021 | |
| 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 |