Hawick - Burnfoot Silverbuthall and Stirches circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:28:00 | 12:28:00 | ... | 1 |
|
| ... | 12:30:00 | 12:30:00 | ... | 2 |
|
| ... | 12:31:00 | 12:31:00 | ... | 3 |
|
| ... | 12:33:00 | 12:33:00 | ... | 4 |
|
| ... | 12:33:00 | 12:33:00 | ... | 5 |
|
| ... | 12:36:00 | 12:36:00 | ... | 6 |
|
| ... | 12:37:00 | 12:37:00 | ... | 7 |
|
| ... | 12:39:00 | 12:39:00 | ... | 8 |
|
| ... | 12:40:00 | 12:40:00 | ... | 9 |
|
| ... | 12:41:00 | 12:41:00 | ... | 10 |
|
| ... | 12:41:00 | 12:41:00 | ... | 11 |
|
| ... | 12:42:00 | 12:42:00 | ... | 12 |
|
| ... | 12:43:00 | 12:43:00 | ... | 13 |
|
| ... | 12:43:00 | 12:43:00 | ... | 14 |
|
| ... | 12:44:00 | 12:44:00 | ... | 15 |
|
| ... | 12:45:00 | 12:45:00 | ... | 16 |
|
| ... | 12:45:00 | 12:45:00 | ... | 17 |
|
| ... | 12:46:00 | 12:46:00 | ... | 18 |
|
| ... | 12:47:00 | 12:47:00 | ... | 19 |
|
| ... | 12:47:00 | 12:47:00 | ... | 20 |
|
| ... | 12:48:00 | 12:48:00 | ... | 21 |
|
| ... | 12:50:00 | 12:50:00 | ... | 22 |
|
| ... | 12:52:00 | 12:52:00 | ... | 23 |
|
| ... | 12:55:00 | 12:55:00 | ... | 24 |
|
| ... | 12:57:00 | 12:57:00 | ... | 25 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 22/05/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 72726428 | Sainsburys | 55.4256773735 | -2.7879869118 | |
| 72726438 | Wallace Court | 55.4281656385 | -2.7908965458 | |
| 72726437 | Bothwell Court | 55.4289203363 | -2.7923021918 | |
| 72798563 | Mansfield Park | 55.4328009052 | -2.7685643609 | |
| 72798628 | Stirches Road | 55.4322233312 | -2.7914991923 | |
| 72798629 | Bowden Road | 55.4349971816 | -2.7863551333 | |
| 72798632 | Alemoor Court | 55.4339679792 | -2.7884997851 | |
| 72728559 | Elim Community Church | 55.4367024161 | -2.7639935695 | |
| 72798635 | Mansfield Bar | 55.4290068158 | -2.7802471565 | |
| 72798638 | Hamilton Road | 55.4337469168 | -2.766733718 | |
| 72723254 | Mart Street | 55.4269020709 | -2.7833816298 | |
| 72798625 | Atkinson Road | 55.4346293655 | -2.7848622397 | |
| 72798627 | Wilson Drive | 55.4337293072 | -2.7681082944 | |
| 72725949 | Shop | 55.4343441132 | -2.7831023429 | |
| 72726528 | Former Bus Office | 55.4247446037 | -2.7849189143 | |
| 72726365 | Lidl | 55.4242399529 | -2.7907232612 | |
| 72726482 | Wilton Church Hall | 55.4285925026 | -2.7888034641 | |
| 72726472 | Telephone Box | 55.4272993219 | -2.788682869 | |
| 72726523 | Howdenbank | 55.4336400871 | -2.7821875942 | |
| 72726525 | Fire Station | 55.4325510215 | -2.782466315 | |
| 72725957 | Wilton Cemetery | 55.4330019577 | -2.7793935778 | |
| 72726945 | Ivanhoe Terrace | 55.4329518802 | -2.7759632625 | |
| 72727286 | Shops | 55.4355655113 | -2.7690448117 |