Clovenstone - Musselburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 06:20:00 | 06:20:00 | ... | 1 |
|
| ... | 06:21:00 | 06:21:00 | ... | 2 |
|
| ... | 06:22:00 | 06:22:00 | ... | 3 |
|
| ... | 06:23:00 | 06:23:00 | ... | 4 |
|
| ... | 06:23:00 | 06:23:00 | ... | 5 |
|
| ... | 06:24:00 | 06:24:00 | ... | 6 |
|
| ... | 06:25:00 | 06:25:00 | ... | 7 |
|
| ... | 06:26:00 | 06:26:00 | ... | 8 |
|
| ... | 06:27:00 | 06:27:00 | ... | 9 |
|
| ... | 06:28:00 | 06:28:00 | ... | 10 |
|
| ... | 06:28:00 | 06:28:00 | ... | 11 |
|
| ... | 06:29:00 | 06:29:00 | ... | 12 |
|
| ... | 06:30:00 | 06:30:00 | ... | 13 |
|
| ... | 06:30:00 | 06:30:00 | ... | 14 |
|
| ... | 06:31:00 | 06:31:00 | ... | 15 |
|
| ... | 06:32:00 | 06:32:00 | ... | 16 |
|
| ... | 06:32:00 | 06:32:00 | ... | 17 |
|
| ... | 06:32:00 | 06:32:00 | ... | 18 |
|
| ... | 06:33:00 | 06:33:00 | ... | 19 |
|
| ... | 06:33:00 | 06:33:00 | ... | 20 |
|
| ... | 06:34:00 | 06:34:00 | ... | 21 |
|
| ... | 06:34:00 | 06:34:00 | ... | 22 |
|
| ... | 06:35:00 | 06:35:00 | ... | 23 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 29/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36234752 | North Bridge | 55.9524973734 | -3.1885672039 | |
| 36234756 | South Bridge | 55.9490191088 | -3.1867952007 | |
| 36234758 | Surgeons' Hall | 55.9458042428 | -3.1847273323 | |
| 36234796 | St Partick Square | 55.9430717999 | -3.1829467067 | |
| 36234798 | Bernard Terrace | 55.9413630671 | -3.1812295202 | |
| 36234787 | East Preston Street | 55.9393145473 | -3.1783974938 | |
| 36234824 | Royal Commonwealth Pool | 55.9383865885 | -3.1730062212 | |
| 36234825 | Marchhall Place | 55.936845795 | -3.1706223932 | |
| 36234826 | Priestfield Road | 55.9343066071 | -3.1673923187 | |
| 36236286 | Prestonfield Terrace | 55.9335321252 | -3.1647278339 | |
| 36236289 | Clearburn Crescent | 55.9336561008 | -3.1611139153 | |
| 36236293 | Prestonfield Park | 55.9329955972 | -3.157780712 | |
| 36234543 | Prestonfield Avenue | 55.9324335153 | -3.1544825647 | |
| 36234545 | Kings Haugh | 55.9323868129 | -3.1508316462 | |
| 36234546 | Craigmillar Castle Gardens | 55.9320738388 | -3.1448839295 | |
| 36234594 | Craigmillar Castle | 55.9327464378 | -3.1401817534 | |
| 36234595 | Craigmillar Castle Loan | 55.9330035232 | -3.1376442035 | |
| 36234596 | Harewood Drive | 55.9327340975 | -3.1347070588 | |
| 36234597 | Wauchope Avenue | 55.9322225013 | -3.1317148747 | |
| 36234598 | Wauchope Road | 55.9328806359 | -3.1275562736 | |
| 36234623 | Hay Avenue | 55.9337429052 | -3.123659558 | |
| 36234624 | Hay Drive | 55.9342488916 | -3.1203926881 | |
| 36253587 | Leith Street | 55.9554548157 | -3.186575728 |