Haddington - Edinburgh Royal Infirmary
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 08:35:00 | 08:35:00 | ... | 1 |
|
| ... | 08:37:00 | 08:37:00 | ... | 2 |
|
| ... | 08:37:00 | 08:37:00 | ... | 3 |
|
| ... | 08:37:00 | 08:37:00 | ... | 4 |
|
| ... | 08:38:00 | 08:38:00 | ... | 5 |
|
| ... | 08:38:00 | 08:38:00 | ... | 6 |
|
| ... | 08:39:00 | 08:39:00 | ... | 7 |
|
| ... | 08:39:00 | 08:39:00 | ... | 8 |
|
| ... | 08:39:00 | 08:39:00 | ... | 9 |
|
| ... | 08:42:00 | 08:42:00 | ... | 10 |
|
| ... | 08:42:00 | 08:42:00 | ... | 11 |
|
| ... | 08:44:00 | 08:44:00 | ... | 12 |
|
| ... | 08:44:00 | 08:44:00 | ... | 13 |
|
| ... | 08:46:00 | 08:46:00 | ... | 14 |
|
| ... | 08:46:00 | 08:46:00 | ... | 15 |
|
| ... | 08:46:00 | 08:46:00 | ... | 16 |
|
| ... | 08:47:00 | 08:47:00 | ... | 17 |
|
| ... | 08:48:00 | 08:48:00 | ... | 18 |
|
| ... | 08:48:00 | 08:48:00 | ... | 19 |
|
| ... | 08:49:00 | 08:49:00 | ... | 20 |
|
| ... | 08:49:00 | 08:49:00 | ... | 21 |
|
| ... | 08:50:00 | 08:50:00 | ... | 22 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 11/06/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36253736 | Bowes Place | 55.9255931499 | -3.1197107746 | |
| 36253734 | Milligan Drive | 55.9256707909 | -3.1230258158 | |
| 36253638 | Royal Infirmary | 55.9223024549 | -3.1327059173 | |
| 36253689 | Sandilands Close | 55.9244021394 | -3.1251815789 | |
| 36253639 | SCRM | 55.9220435049 | -3.1295938977 | |
| 58232784 | Tesco | 55.9405319166 | -3.0571107135 | |
| 58232757 | Police Station | 55.9420868223 | -3.0528622607 | |
| 58232794 | Main Road | 55.9224138483 | -3.0669069331 | |
| 58232793 | Golf Club | 55.9306817365 | -3.0605077668 | |
| 58232785 | Eskview Road | 55.9391407695 | -3.0611071591 | |
| 58232786 | Eskview Crescent | 55.9377652495 | -3.062238184 | |
| 58232787 | Haugh Park | 55.9357777486 | -3.062439909 | |
| 58232789 | Stoneybank Place | 55.9346262256 | -3.0615599903 | |
| 58232792 | Mayfield Crescent | 55.933068355 | -3.0598686791 | |
| 58235325 | Tesco Terminus | 55.9392832559 | -3.0549794699 | |
| 64323958 | Newton Church Road | 55.9137045595 | -3.0948256831 | |
| 64323932 | Newton Cottages | 55.9185327855 | -3.0730406259 | |
| 64323928 | Easter Millerhill | 55.9135460611 | -3.0822621473 | |
| 64323936 | Wester Millerhill | 55.9111083336 | -3.0876654753 | |
| 64323956 | Millerhill Road | 55.9151719787 | -3.0965309961 | |
| 64323743 | Moorfield Cottages | 55.9168630961 | -3.0983387663 | |
| 64323739 | Hilltown Terrace | 55.91928454 | -3.1038796651 |