Riccarton - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 02:11:00 | 02:11:00 | ... | 1 |
|
| ... | 02:12:00 | 02:12:00 | ... | 2 |
|
| ... | 02:14:00 | 02:14:00 | ... | 3 |
|
| ... | 02:16:00 | 02:16:00 | ... | 4 |
|
| ... | 02:17:00 | 02:17:00 | ... | 5 |
|
| ... | 02:17:00 | 02:17:00 | ... | 6 |
|
| ... | 02:18:00 | 02:18:00 | ... | 7 |
|
| ... | 02:19:00 | 02:19:00 | ... | 8 |
|
| ... | 02:20:00 | 02:20:00 | ... | 9 |
|
| ... | 02:20:00 | 02:20:00 | ... | 10 |
|
| ... | 02:21:00 | 02:21:00 | ... | 11 |
|
| ... | 02:21:00 | 02:21:00 | ... | 12 |
|
| ... | 02:22:00 | 02:22:00 | ... | 13 |
|
| ... | 02:23:00 | 02:23:00 | ... | 14 |
|
| ... | 02:23:00 | 02:23:00 | ... | 15 |
|
| ... | 02:24:00 | 02:24:00 | ... | 16 |
|
| ... | 02:24:00 | 02:24:00 | ... | 17 |
|
| ... | 02:25:00 | 02:25:00 | ... | 18 |
|
| ... | 02:25:00 | 02:25:00 | ... | 19 |
|
| ... | 02:26:00 | 02:26:00 | ... | 20 |
|
| ... | 02:26:00 | 02:26:00 | ... | 21 |
|
| ... | 02:27:00 | 02:27:00 | ... | 22 |
|
| ... | 02:28:00 | 02:28:00 | ... | 23 |
|
| ... | 02:28:00 | 02:28:00 | ... | 24 |
|
| ... | 02:30:00 | 02:30:00 | ... | 25 |
|
| ... | 02:32:00 | 02:32:00 | ... | 26 |
|
| ... | 02:34:00 | 02:34:00 | ... | 27 |
|
| ... | 02:35:00 | 02:35:00 | ... | 28 |
|
| ... | 02:37:00 | 02:37:00 | ... | 29 |
|
| 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 | |
|---|---|---|---|---|
| 36234874 | Heriot Watt Campus | 55.9090094385 | -3.3198218832 | |
| 36234875 | The Avenue | 55.9102648654 | -3.3175448337 | |
| 36246365 | Hermiston Park & Ride | 55.9173201361 | -3.3140399876 | |
| 36234893 | Burtons Biscuits Factory | 55.9215270265 | -3.296083448 | |
| 36236876 | Napier University (Sighthill) | 55.9227043498 | -3.290073604 | |
| 36236878 | Sighthill Green | 55.9233467101 | -3.2853579771 | |
| 36236879 | Broomhouse Road | 55.9243426984 | -3.2794535867 | |
| 36236892 | Sighthill Post Office | 55.9251136283 | -3.2761661685 | |
| 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 | |
| 36232624 | Balgreen Road | 55.9342530247 | -3.2444512526 | |
| 36232625 | Gorgie Park Road | 55.9364691183 | -3.2403280676 | |
| 36232626 | Stewart Terrace | 55.9372387124 | -3.2352778466 | |
| 36232627 | Tynecastle | 55.9383263612 | -3.230749811 | |
| 36232628 | Gorgie City Farm | 55.9389168725 | -3.2283030673 | |
| 36232629 | Murieston Crescent | 55.9397606033 | -3.225688141 | |
| 36232632 | Dalry Primary School | 55.9415197211 | -3.223182011 | |
| 36232634 | Caledonian Village | 55.9435019846 | -3.2199141277 | |
| 36232635 | Haymarket Station | 55.9455403998 | -3.2173201899 | |
| 36232637 | West Maitland Street | 55.9469130734 | -3.2157139433 | |
| 36236572 | Shandwick Place | 55.9496334176 | -3.2095537641 | |
| 36235973 | Princes Street (west) | 55.951361837 | -3.2009597554 | |
| 36253279 | Princes Street (Scott Mon.) | 55.9525231008 | -3.1942693676 | |
| 36235974 | Princes Street (Waverley Steps) | 55.9531880012 | -3.19055826 | |
| 36242697 | Leith Street | 55.9556076777 | -3.186564389 |