Wester Hailes - Musselburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 00:13:00 | 00:13:00 | ... | 1 |
|
| ... | 00:14:00 | 00:14:00 | ... | 2 |
|
| ... | 00:17:00 | 00:17:00 | ... | 3 |
|
| ... | 00:21:00 | 00:21:00 | ... | 4 |
|
| ... | 00:22:00 | 00:22:00 | ... | 5 |
|
| ... | 00:23:00 | 00:23:00 | ... | 6 |
|
| ... | 00:24:00 | 00:24:00 | ... | 7 |
|
| ... | 00:24:00 | 00:24:00 | ... | 8 |
|
| ... | 00:25:00 | 00:25:00 | ... | 9 |
|
| ... | 00:26:00 | 00:26:00 | ... | 10 |
|
| ... | 00:27:00 | 00:27:00 | ... | 11 |
|
| ... | 00:27:00 | 00:27:00 | ... | 12 |
|
| ... | 00:28:00 | 00:28:00 | ... | 13 |
|
| ... | 00:28:00 | 00:28:00 | ... | 14 |
|
| ... | 00:29:00 | 00:29:00 | ... | 15 |
|
| ... | 00:30:00 | 00:30:00 | ... | 16 |
|
| ... | 00:30:00 | 00:30:00 | ... | 17 |
|
| ... | 00:31:00 | 00:31:00 | ... | 18 |
|
| ... | 00:31:00 | 00:31:00 | ... | 19 |
|
| ... | 00:32:00 | 00:32:00 | ... | 20 |
|
| ... | 00:32:00 | 00:32:00 | ... | 21 |
|
| ... | 00:32:00 | 00:32:00 | ... | 22 |
|
| ... | 00:33:00 | 00:33:00 | ... | 23 |
|
| ... | 00:34:00 | 00:34:00 | ... | 24 |
|
| ... | 00:34:00 | 00:34:00 | ... | 25 |
|
| ... | 00:34:00 | 00:34:00 | ... | 26 |
|
| ... | 00:35:00 | 00:35:00 | ... | 27 |
|
| ... | 00:35:00 | 00:35:00 | ... | 28 |
|
| ... | 00:36:00 | 00:36:00 | ... | 29 |
|
| ... | 00:37:00 | 00:37:00 | ... | 30 |
|
| ... | 00:37:00 | 00:37:00 | ... | 31 |
|
| ... | 00:38:00 | 00:38:00 | ... | 32 |
|
| ... | 00:39:00 | 00:39:00 | ... | 33 |
|
| ... | 00:39:00 | 00:39:00 | ... | 34 |
|
| ... | 00:39:00 | 00:39:00 | ... | 35 |
|
| ... | 00:40:00 | 00:40:00 | ... | 36 |
|
| ... | 00:41:00 | 00:41:00 | ... | 37 |
|
| ... | 00:41:00 | 00:41:00 | ... | 38 |
|
| ... | 00:42:00 | 00:42:00 | ... | 39 |
|
| ... | 00:42:00 | 00:42:00 | ... | 40 |
|
| ... | 00:42:00 | 00:42:00 | ... | 41 |
|
| ... | 00:43:00 | 00:43:00 | ... | 42 |
|
| ... | 00:44:00 | 00:44:00 | ... | 43 |
|
| ... | 00:45:00 | 00:45:00 | ... | 44 |
|
| ... | 00:45:00 | 00:45:00 | ... | 45 |
|
| ... | 00:47:00 | 00:47:00 | ... | 46 |
|
| ... | 00:47:00 | 00:47:00 | ... | 47 |
|
| ... | 00:48:00 | 00:48:00 | ... | 48 |
|
| ... | 00:50:00 | 00:50:00 | ... | 49 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 30/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36232692 | Lothian Road | 55.9492015165 | -3.2068659972 | |
| 36235968 | Princes Street (west) | 55.9508461396 | -3.2040826158 | |
| 36243246 | Princes Street (Scott Mon.) | 55.9523426463 | -3.1952727578 | |
| 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 | |
| 36234625 | Jack Kane Sports Centre | 55.9340442384 | -3.1181937769 | |
| 36234626 | Niddrie Mill Avenue | 55.9339090949 | -3.1152605544 | |
| 36234392 | Peacocktail Close | 55.9337094955 | -3.110500689 | |
| 36234393 | Fort Kinnaird West | 55.9335837274 | -3.1075037605 | |
| 36245253 | Fort Kinnaird | 55.935031318 | -3.1023905909 | |
| 36243853 | Newcraighall Road | 55.9337438165 | -3.0996648171 | |
| 36247282 | The Cuddie Brae | 55.9344894033 | -3.0946435927 | |
| 36234375 | Newcraighall Drive | 55.935109082 | -3.0906271289 | |
| 36234376 | Whitehill Street | 55.9358174157 | -3.0877495885 | |
| 36247283 | Newcraighall Bowling Club | 55.9375222839 | -3.0839392827 | |
| 58232838 | Clayknowes Avenue | 55.9370759327 | -3.0733452022 | |
| 58234763 | Tesco | 55.9404361759 | -3.0577965281 | |
| 58232842 | Denholm Drive | 55.9339104357 | -3.0705524436 | |
| 58232839 | Clayknowes Court | 55.9349868257 | -3.0717987145 | |
| 58232837 | Clayknowes Place | 55.9380191061 | -3.0723467228 | |
| 58232836 | Stoneyhill Drive | 55.9396933874 | -3.0730333755 | |
| 58232843 | Whitehill Gardens | 55.9338540884 | -3.0697985535 | |
| 58234753 | Stoneybank Gardens | 55.9356923374 | -3.0650468571 | |
| 58232845 | Whitehill Avenue | 55.9346766391 | -3.0671639852 | |
| 58232758 | Health Centre | 55.9427797241 | -3.055891094 | |
| 58232856 | Eskview Road | 55.9389203453 | -3.0616614541 | |
| 58232854 | Eskview Crescent | 55.937969655 | -3.0624999207 | |
| 58232859 | Newhailes Roundabout | 55.9394224042 | -3.0783410204 | |
| 58234835 | Queen Margaret University | 55.9325830806 | -3.0733650108 |