Ettrick - Hawick
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 10:00:00 | 10:00:00 | ... | 1 |
|
| ... | 10:15:00 | 10:15:00 | ... | 2 |
|
| ... | 10:40:00 | 10:40:00 | ... | 3 |
|
| ... | 10:43:00 | 10:43:00 | ... | 4 |
|
| ... | 10:47:00 | 10:47:00 | ... | 5 |
|
| ... | 10:48:00 | 10:48:00 | ... | 6 |
|
| ... | 10:49:00 | 10:49:00 | ... | 7 |
|
| ... | 10:50:00 | 10:50:00 | ... | 8 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 21/09/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 72725368 | Boston Hall | 55.4188153044 | -3.1609046023 | |
| 72726454 | Teviotsyde | 55.41560065 | -2.8118916445 | |
| 72726428 | Sainsburys | 55.4256773735 | -2.7879869118 | |
| 72798482 | Hopehouse Rd End | 55.4371496955 | -3.1152271637 | |
| 72798493 | Highchesters Rd End | 55.4173226027 | -2.8584339172 | |
| 72798496 | Primary School | 55.4197569138 | -2.9034643024 | |
| 72726494 | High School | 55.4213174692 | -2.7924343099 | |
| 72726487 | Cottage Hospital | 55.4206858592 | -2.7997363573 |