Clovenstone - Musselburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 19:14:00 | 19:14:00 | ... | 1 |
|
| ... | 19:14:00 | 19:14:00 | ... | 2 |
|
| ... | 19:16:00 | 19:16:00 | ... | 3 |
|
| ... | 19:17:00 | 19:17:00 | ... | 4 |
|
| ... | 19:18:00 | 19:18:00 | ... | 5 |
|
| ... | 19:18:00 | 19:18:00 | ... | 6 |
|
| ... | 19:19:00 | 19:19:00 | ... | 7 |
|
| ... | 19:20:00 | 19:20:00 | ... | 8 |
|
| ... | 19:21:00 | 19:21:00 | ... | 9 |
|
| ... | 19:22:00 | 19:22:00 | ... | 10 |
|
| ... | 19:23:00 | 19:23:00 | ... | 11 |
|
| ... | 19:23:00 | 19:23:00 | ... | 12 |
|
| ... | 19:24:00 | 19:24:00 | ... | 13 |
|
| ... | 19:25:00 | 19:25:00 | ... | 14 |
|
| ... | 19:26:00 | 19:26:00 | ... | 15 |
|
| ... | 19:27:00 | 19:27:00 | ... | 16 |
|
| ... | 19:28:00 | 19:28:00 | ... | 17 |
|
| ... | 19:28:00 | 19:28:00 | ... | 18 |
|
| ... | 19:29:00 | 19:29:00 | ... | 19 |
|
| ... | 19:30:00 | 19:30:00 | ... | 20 |
|
| ... | 19:30:00 | 19:30:00 | ... | 21 |
|
| ... | 19:31:00 | 19:31:00 | ... | 22 |
|
| ... | 19:32:00 | 19:32:00 | ... | 23 |
|
| ... | 19:33:00 | 19:33:00 | ... | 24 |
|
| ... | 19:34:00 | 19:34:00 | ... | 25 |
|
| ... | 19:35:00 | 19:35:00 | ... | 26 |
|
| ... | 19:36:00 | 19:36:00 | ... | 27 |
|
| ... | 19:36:00 | 19:36:00 | ... | 28 |
|
| ... | 19:37:00 | 19:37:00 | ... | 29 |
|
| ... | 19:37:00 | 19:37:00 | ... | 30 |
|
| ... | 19:41:00 | 19:41:00 | ... | 31 |
|
| ... | 19:42:00 | 19:42:00 | ... | 32 |
|
| ... | 19:44:00 | 19:44:00 | ... | 33 |
|
| ... | 19:44:00 | 19:44:00 | ... | 34 |
|
| ... | 19:46:00 | 19:46:00 | ... | 35 |
|
| ... | 19:49:00 | 19:49:00 | ... | 36 |
|
| ... | 19:52:00 | 19:52:00 | ... | 37 |
|
| ... | 19:53:00 | 19:53:00 | ... | 38 |
|
| ... | 19:55:00 | 19:55:00 | ... | 39 |
|
| ... | 19:57:00 | 19:57:00 | ... | 40 |
|
| ... | 19:59:00 | 19:59:00 | ... | 41 |
|
| ... | 20:01:00 | 20:01:00 | ... | 42 |
|
| ... | 20:03:00 | 20:03:00 | ... | 43 |
|
| ... | 20:04:00 | 20:04:00 | ... | 44 |
|
| ... | 20:05:00 | 20:05:00 | ... | 45 |
|
| ... | 20:06:00 | 20:06:00 | ... | 46 |
|
| ... | 20:07:00 | 20:07:00 | ... | 47 |
|
| ... | 20:08:00 | 20:08:00 | ... | 48 |
|
| ... | 20:08:00 | 20:08:00 | ... | 49 |
|
| ... | 20:09:00 | 20:09:00 | ... | 50 |
|
| ... | 20:10:00 | 20:10:00 | ... | 51 |
|
| ... | 20:11:00 | 20:11:00 | ... | 52 |
|
| ... | 20:11:00 | 20:11:00 | ... | 53 |
|
| ... | 20:12:00 | 20:12:00 | ... | 54 |
|
| ... | 20:12:00 | 20:12:00 | ... | 55 |
|
| ... | 20:13:00 | 20:13:00 | ... | 56 |
|
| ... | 20:14:00 | 20:14:00 | ... | 57 |
|
| ... | 20:15:00 | 20:15:00 | ... | 58 |
|
| ... | 20:15:00 | 20:15:00 | ... | 59 |
|
| ... | 20:16:00 | 20:16:00 | ... | 60 |
|
| ... | 20:17:00 | 20:17:00 | ... | 61 |
|
| ... | 20:17:00 | 20:17:00 | ... | 62 |
|
| ... | 20:20:00 | 20:20:00 | ... | 63 |
|
| ... | 20:21:00 | 20:21:00 | ... | 64 |
|
| ... | 20:21:00 | 20:21:00 | ... | 65 |
|
| ... | 20:22:00 | 20:22:00 | ... | 66 |
|
| ... | 20:23:00 | 20:23:00 | ... | 67 |
|
| ... | 20:23:00 | 20:23:00 | ... | 68 |
|
| ... | 20:24:00 | 20:24:00 | ... | 69 |
|
| ... | 20:25:00 | 20:25:00 | ... | 70 |
|
| ... | 20:26:00 | 20:26:00 | ... | 71 |
|
| ... | 20:26:00 | 20:26:00 | ... | 72 |
|
| ... | 20:27:00 | 20:27:00 | ... | 73 |
|
| ... | 20:27:00 | 20:27:00 | ... | 74 |
|
| ... | 20:28:00 | 20:28:00 | ... | 75 |
|
| ... | 20:29:00 | 20:29:00 | ... | 76 |
|
| ... | 20:29:00 | 20:29:00 | ... | 77 |
|
| ... | 20:30:00 | 20:30:00 | ... | 78 |
|
| ... | 20:30:00 | 20:30:00 | ... | 79 |
|
| ... | 20:31:00 | 20:31:00 | ... | 80 |
|
| ... | 20:32:00 | 20:32:00 | ... | 81 |
|
| ... | 20:32:00 | 20:32:00 | ... | 82 |
|
| ... | 20:32:00 | 20:32:00 | ... | 83 |
|
| ... | 20:33:00 | 20:33:00 | ... | 84 |
|
| ... | 20:34:00 | 20:34:00 | ... | 85 |
|
| ... | 20:34:00 | 20:34:00 | ... | 86 |
|
| ... | 20:37:00 | 20:37:00 | ... | 87 |
|
| ... | 20:37:00 | 20:37:00 | ... | 88 |
|
| ... | 20:38:00 | 20:38:00 | ... | 89 |
|
| ... | 20:39:00 | 20:39:00 | ... | 90 |
|
| ... | 20:40:00 | 20:40:00 | ... | 91 |
|
| ... | 20:41:00 | 20:41:00 | ... | 92 |
|
| ... | 20:42:00 | 20:42:00 | ... | 93 |
|
| ... | 20:43:00 | 20:43:00 | ... | 94 |
|
| 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 | |
|---|---|---|---|---|
| 36237453 | Murrayburn Park | 55.9176513709 | -3.2808972162 | |
| 36237469 | Clovenstone Road | 55.9119474008 | -3.277253422 | |
| 36237483 | Wester Hailes Road | 55.9099498128 | -3.2740521841 | |
| 36247287 | Clovenstone Drive | 55.910626312 | -3.2711947318 | |
| 36237484 | Clovenstone Gardens | 55.9131024679 | -3.2706998063 | |
| 36247697 | Clovenstone Road | 55.9131900835 | -3.275262405 | |
| 36247329 | Barn Park | 55.9109537055 | -3.279492485 | |
| 36247698 | Greenacre | 55.9117300331 | -3.2817418456 | |
| 36247232 | Healthy Living Centre | 55.9128499658 | -3.2846426136 | |
| 36237454 | Hailesland Grove | 55.9175041016 | -3.2769081467 | |
| 36237467 | Dumbryden Grove | 55.9183559705 | -3.2736079094 | |
| 36237465 | Dumbryden Road | 55.9200394624 | -3.2724309809 | |
| 36237463 | Dumbryden Drive | 55.9215025713 | -3.2717108081 | |
| 36237436 | Dumbryden Drive | 55.923267781 | -3.2713205357 | |
| 36237437 | Bus Depot | 55.9246294437 | -3.2673641826 | |
| 36232589 | Saughton Mains | 55.9268600981 | -3.2688934311 | |
| 36239469 | Saughton Mains Avenue | 55.9285941865 | -3.2654129224 | |
| 36232595 | HMP Edinburgh | 55.9296994265 | -3.2610313406 | |
| 36232593 | Stenhouse Mill Lane | 55.9298423922 | -3.2575947184 | |
| 36232596 | Chesser Avenue | 55.9318913948 | -3.2505061016 | |
| 36232597 | Saughton Park | 55.9328123172 | -3.2474143901 | |
| 36232687 | Stevenson Grove | 55.9358853645 | -3.2456401897 | |
| 36232689 | Westfield Avenue | 55.9373827717 | -3.2432869104 | |
| 36238934 | Roseburn Street | 55.9404237827 | -3.2393337665 | |
| 36245439 | Westfield Sainsbury's | 55.939165967 | -3.2411026878 | |
| 36243526 | Fountain Park | 55.9414810787 | -3.2189219715 | |
| 36253268 | Morrison Crescent | 55.9438449414 | -3.2143048496 | |
| 36236753 | The Exchange | 55.9480399177 | -3.2071180953 | |
| 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 | |
| 36232598 | Stevenson Road | 55.9347526582 | -3.2465803145 | |
| 36232586 | Longstone Gardens | 55.9253640399 | -3.267580212 | |
| 36232587 | Longstone Terrace | 55.9257574635 | -3.2695135651 | |
| 36237478 | Westside Plaza | 55.9164447869 | -3.2854495419 | |
| 36237474 | Westside Plaza | 55.9145322639 | -3.2870342053 | |
| 58232838 | Clayknowes Avenue | 55.9370759327 | -3.0733452022 | |
| 58232783 | Health Centre | 55.9428905409 | -3.0555418713 | |
| 58232782 | Brunton Theatre | 55.9440253423 | -3.0583747267 | |
| 58232679 | Loretto RC Primary School | 55.9422668774 | -3.0475516348 | |
| 58232848 | Loretto Court | 55.9330155863 | -3.0607796247 | |
| 58232864 | Police Station | 55.9423500722 | -3.0525491921 | |
| 58232847 | Stoneybank Avenue | 55.9353367476 | -3.0635643857 | |
| 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 | |
| 58232846 | Stoneybank Grove | 55.9336336558 | -3.0620450666 | |
| 58232769 | Ship Inn | 55.9440642848 | -3.0642839739 | |
| 58232843 | Whitehill Gardens | 55.9338540884 | -3.0697985535 | |
| 58234753 | Stoneybank Gardens | 55.9356923374 | -3.0650468571 | |
| 58232845 | Whitehill Avenue | 55.9346766391 | -3.0671639852 | |
| 58232856 | Eskview Road | 55.9389203453 | -3.0616614541 | |
| 58232854 | Eskview Crescent | 55.937969655 | -3.0624999207 | |
| 58232853 | Haugh Park | 55.9360703289 | -3.0628961443 | |
| 58232852 | Stoneybank Place | 55.93417734 | -3.0615156975 | |
| 58232849 | Mayfield Crescent | 55.9335543046 | -3.0608263628 | |
| 58232859 | Newhailes Roundabout | 55.9394224042 | -3.0783410204 | |
| 58232875 | Dunedin House | 55.9437567176 | -3.0676378933 | |
| 58232683 | Rothesay Place | 55.9390761865 | -3.0476576065 | |
| 58234835 | Queen Margaret University | 55.9325830806 | -3.0733650108 | |
| 58232685 | Musselburgh Grammar School | 55.9386494799 | -3.0481743856 |