Riccarton - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 01:40:00 | 01:40:00 | ... | 1 |
|
| ... | 01:43:00 | 01:43:00 | ... | 2 |
|
| ... | 01:45:00 | 01:45:00 | ... | 3 |
|
| ... | 01:47:00 | 01:47:00 | ... | 4 |
|
| ... | 01:49:00 | 01:49:00 | ... | 5 |
|
| ... | 01:50:00 | 01:50:00 | ... | 6 |
|
| ... | 01:52:00 | 01:52:00 | ... | 7 |
|
| ... | 01:53:00 | 01:53:00 | ... | 8 |
|
| ... | 01:53:00 | 01:53:00 | ... | 9 |
|
| ... | 01:54:00 | 01:54:00 | ... | 10 |
|
| ... | 01:54:00 | 01:54:00 | ... | 11 |
|
| ... | 01:55:00 | 01:55:00 | ... | 12 |
|
| ... | 01:55:00 | 01:55:00 | ... | 13 |
|
| ... | 01:56:00 | 01:56:00 | ... | 14 |
|
| ... | 01:57:00 | 01:57:00 | ... | 15 |
|
| ... | 01:57:00 | 01:57:00 | ... | 16 |
|
| ... | 01:58:00 | 01:58:00 | ... | 17 |
|
| ... | 01:58:00 | 01:58:00 | ... | 18 |
|
| ... | 01:58:00 | 01:58:00 | ... | 19 |
|
| ... | 01:59:00 | 01:59:00 | ... | 20 |
|
| ... | 01:59:00 | 01:59:00 | ... | 21 |
|
| ... | 02:00:00 | 02:00:00 | ... | 22 |
|
| ... | 02:01:00 | 02:01:00 | ... | 23 |
|
| ... | 02:01:00 | 02:01:00 | ... | 24 |
|
| ... | 02:02:00 | 02:02:00 | ... | 25 |
|
| ... | 02:03:00 | 02:03:00 | ... | 26 |
|
| ... | 02:03:00 | 02:03:00 | ... | 27 |
|
| ... | 02:04:00 | 02:04:00 | ... | 28 |
|
| ... | 02:06:00 | 02:06:00 | ... | 29 |
|
| ... | 02:08:00 | 02:08:00 | ... | 30 |
|
| ... | 02:09:00 | 02:09:00 | ... | 31 |
|
| 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 | |
|---|---|---|---|---|
| 36234873 | The Avenue | 55.9101572474 | -3.3175251856 | |
| 36234874 | Heriot Watt Campus | 55.9090094385 | -3.3198218832 | |
| 36242697 | Leith Street | 55.9556076777 | -3.186564389 | |
| 36235975 | Princes Street (Waverley Steps) | 55.9529530558 | -3.1906951851 | |
| 36243252 | Princes Street (Scott Mon.) | 55.95223858 | -3.1948851908 | |
| 36246256 | Princes Street (west) | 55.9507077341 | -3.2035338303 | |
| 36238748 | Shandwick Place | 55.9491419034 | -3.2101950003 | |
| 36236576 | Atholl Crescent | 55.9480570676 | -3.2126912558 | |
| 36232658 | Haymarket Station | 55.9455337895 | -3.2170797984 | |
| 36232672 | Caledonian Village | 55.9425438902 | -3.2213890404 | |
| 36232673 | Dalry Primary School | 55.9414043761 | -3.2230342794 | |
| 36232674 | Murieston Crescent | 55.9396088527 | -3.2255872884 | |
| 36232675 | Gorgie City Farm | 55.9387712341 | -3.2284905712 | |
| 36232676 | Tynecastle | 55.9378275363 | -3.2321107744 | |
| 36232678 | Stewart Terrace | 55.9372443284 | -3.2347177143 | |
| 36232679 | Gorgie Park Road | 55.936362132 | -3.2402446055 | |
| 36232682 | Balgreen Road | 55.9340003786 | -3.2445552045 | |
| 36232684 | Saughton Park | 55.9329486039 | -3.246378306 | |
| 36232683 | Chesser Cottages | 55.9322592516 | -3.248789212 | |
| 36242373 | Chesser Avenue | 55.931609196 | -3.2508651615 | |
| 36232685 | Chesser Avenue | 55.9306983106 | -3.2538449779 | |
| 36232594 | Stenhouse Mill Lane | 55.9297084698 | -3.2575103504 | |
| 36232592 | HMP Edinburgh | 55.9295771099 | -3.2606912454 | |
| 36232686 | Saughton Mains Avenue | 55.9282338966 | -3.2654972091 | |
| 36234858 | Parkhead Terrace | 55.9259332927 | -3.2716318832 | |
| 36234859 | Sighthill Post office | 55.9247225699 | -3.2766174249 | |
| 36234862 | Sighthill Gardens | 55.9234542417 | -3.2828010066 | |
| 36234863 | Napier University (Sighthill) | 55.9228016586 | -3.2876443725 | |
| 36234864 | Wester Hailes Road | 55.921866566 | -3.2928462368 | |
| 36234867 | Calder View | 55.9208029706 | -3.2982835929 | |
| 36246389 | Hermiston Park & Ride | 55.9171220106 | -3.314081286 |