Edinburgh - Carlisle
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 22:25:00 | 22:25:00 | ... | 1 |
|
| ... | 22:29:00 | 22:29:00 | ... | 2 |
|
| ... | 22:31:00 | 22:31:00 | ... | 3 |
|
| ... | 22:32:00 | 22:32:00 | ... | 4 |
|
| ... | 22:34:00 | 22:34:00 | ... | 5 |
|
| ... | 22:39:00 | 22:39:00 | ... | 6 |
|
| ... | 22:42:00 | 22:42:00 | ... | 7 |
|
| ... | 22:47:00 | 22:47:00 | ... | 8 |
|
| ... | 22:49:00 | 22:49:00 | ... | 9 |
|
| ... | 22:50:00 | 22:50:00 | ... | 10 |
|
| ... | 22:52:00 | 22:52:00 | ... | 11 |
|
| ... | 22:54:00 | 22:54:00 | ... | 12 |
|
| ... | 22:54:00 | 22:54:00 | ... | 13 |
|
| ... | 22:55:00 | 22:55:00 | ... | 14 |
|
| ... | 22:56:00 | 22:56:00 | ... | 15 |
|
| ... | 22:57:00 | 22:57:00 | ... | 16 |
|
| ... | 22:57:00 | 22:57:00 | ... | 17 |
|
| ... | 22:58:00 | 22:58:00 | ... | 18 |
|
| ... | 23:00:00 | 23:00:00 | ... | 19 |
|
| ... | 23:03:00 | 23:03:00 | ... | 20 |
|
| ... | 23:04:00 | 23:04:00 | ... | 21 |
|
| ... | 23:04:00 | 23:04:00 | ... | 22 |
|
| ... | 23:05:00 | 23:05:00 | ... | 23 |
|
| ... | 23:05:00 | 23:05:00 | ... | 24 |
|
| ... | 23:06:00 | 23:06:00 | ... | 25 |
|
| ... | 23:06:00 | 23:06:00 | ... | 26 |
|
| ... | 23:08:00 | 23:08:00 | ... | 27 |
|
| ... | 23:09:00 | 23:09:00 | ... | 28 |
|
| ... | 23:09:00 | 23:09:00 | ... | 29 |
|
| ... | 23:09:00 | 23:09:00 | ... | 30 |
|
| ... | 23:12:00 | 23:12:00 | ... | 31 |
|
| ... | 23:13:00 | 23:13:00 | ... | 32 |
|
| ... | 23:14:00 | 23:14:00 | ... | 33 |
|
| ... | 23:15:00 | 23:15:00 | ... | 34 |
|
| ... | 23:16:00 | 23:16:00 | ... | 35 |
|
| ... | 23:17:00 | 23:17:00 | ... | 36 |
|
| ... | 23:19:00 | 23:19:00 | ... | 37 |
|
| ... | 23:20:00 | 23:20:00 | ... | 38 |
|
| ... | 23:22:00 | 23:22:00 | ... | 39 |
|
| ... | 23:25:00 | 23:25:00 | ... | 40 |
|
| ... | 23:28:00 | 23:28:00 | ... | 41 |
|
| ... | 23:31:00 | 23:31:00 | ... | 42 |
|
| ... | 23:32:00 | 23:32:00 | ... | 43 |
|
| ... | 23:32:00 | 23:32:00 | ... | 44 |
|
| ... | 23:32:00 | 23:32:00 | ... | 45 |
|
| ... | 23:33:00 | 23:33:00 | ... | 46 |
|
| ... | 23:36:00 | 23:36:00 | ... | 47 |
|
| ... | 23:40:00 | 23:40:00 | ... | 48 |
|
| ... | 23:41:00 | 23:41:00 | ... | 49 |
|
| ... | 23:46:00 | 23:46:00 | ... | 50 |
|
| ... | 23:46:00 | 23:46:00 | ... | 51 |
|
| ... | 23:46:00 | 23:46:00 | ... | 52 |
|
| ... | 23:47:00 | 23:47:00 | ... | 53 |
|
| ... | 23:48:00 | 23:48:00 | ... | 54 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 28/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36234753 | North Bridge | 55.9517819915 | -3.1882089701 | |
| 36234757 | South Bridge | 55.9485179212 | -3.1865877051 | |
| 36234758 | Surgeons' Hall | 55.9458042428 | -3.1847273323 | |
| 36234796 | St Partick Square | 55.9430717999 | -3.1829467067 | |
| 36234824 | Royal Commonwealth Pool | 55.9383865885 | -3.1730062212 | |
| 36235256 | Cameron Toll | 55.9285104511 | -3.1598396386 | |
| 36253645 | Royal Infirmary | 55.9199994518 | -3.1388473452 | |
| 36243734 | Bus Station | 55.9553965367 | -3.1916831382 | |
| 64329252 | Campend | 55.902713185 | -3.0960834153 | |
| 64329259 | Shank Bridge | 55.8412185941 | -3.0599707091 | |
| 64329262 | Tynehead Road | 55.8058837513 | -2.9769083042 | |
| 64323596 | The Wisp | 55.9133798391 | -3.1169748387 | |
| 64323587 | Old Dalkeith Road | 55.9105769975 | -3.1099512667 | |
| 64323535 | Melville Gate Road | 55.8974853413 | -3.0867724351 | |
| 64329326 | Elginhaugh Bridge | 55.8930144735 | -3.0873510078 | |
| 64329269 | Eskbank Court | 55.8894334194 | -3.0817826466 | |
| 64323646 | Eskbank Toll | 55.8882768221 | -3.0794481342 | |
| 64323945 | Ancrum Bank | 55.8869530945 | -3.0756702256 | |
| 64324675 | Newbattle Cemetery | 55.8861203346 | -3.0732810364 | |
| 64323949 | Newbattle Abbey Crescent | 55.8799089074 | -3.0704720917 | |
| 64324235 | Station Road | 55.8694138664 | -3.0684094543 | |
| 64324234 | St Anne's Court | 55.8674574733 | -3.0670933258 | |
| 64323972 | Dean Park Place | 55.8662324376 | -3.0664045774 | |
| 64323974 | Fourth Street | 55.865120998 | -3.0660864977 | |
| 64323984 | Mining Museum | 55.8612046921 | -3.0648927604 | |
| 64324238 | Cockpen Road | 55.8569342924 | -3.065159337 | |
| 64323252 | Harvieston Toll | 55.8349989147 | -3.0486408999 | |
| 64329292 | Harvieston Cemetery | 55.8320469857 | -3.0449692628 | |
| 64324245 | Borthwick Castle Road | 55.8186274391 | -3.027341046 | |
| 64324247 | Middleton | 55.815776113 | -3.0092487147 | |
| 64324249 | Middleton Mains | 55.811130341 | -2.9849063422 | |
| 64329345 | Dewar Park | 55.8510877988 | -3.0648076975 | |
| 64329357 | Hole in the Wa' | 55.8362109773 | -3.0508610027 | |
| 64323534 | Melville Gate | 55.8959423757 | -3.0885203458 | |
| 72724873 | Gilston Rd End | 55.7606176515 | -2.9266775512 | |
| 72725475 | Halkburn Rd End | 55.6441606637 | -2.8503615778 | |
| 72725462 | Road End | 55.6533466553 | -2.8653880846 | |
| 72798769 | Torquhan North Lodge | 55.7205931072 | -2.8857076662 | |
| 72798783 | Stagebank Cotts | 55.7702334571 | -2.9395140866 | |
| 72798786 | Falahill Farm Rd End | 55.7964493765 | -2.9654907088 | |
| 72798798 | Road End | 55.6675817893 | -2.8764969945 | |
| 72798478 | Killochyett | 55.697671531 | -2.8718405113 | |
| 72728486 | Falahill Cottages | 55.7902782395 | -2.9629617581 | |
| 72728501 | Transport Interchange | 55.6173880251 | -2.8058010389 | |
| 72724854 | Road End | 55.7397296974 | -2.9118318689 | |
| 72728483 | Galabank | 55.7015446752 | -2.8855949242 | |
| 72724523 | Plumtreehall Brae | 55.6246957973 | -2.8216726742 | |
| 72724393 | Magdala Terrace | 55.6238568431 | -2.8194795385 | |
| 72724392 | Halliburton Terrace | 55.6228410191 | -2.8168540633 | |
| 72724374 | Ladhope Inn | 55.62102062 | -2.8122430481 | |
| 72724949 | Heriot Rd End | 55.7812423425 | -2.9521358673 | |
| 72724764 | Craigend Rd | 55.6966768762 | -2.8663772396 | |
| 72724759 | Old School | 55.694572068 | -2.8628625416 | |
| 72724758 | Townfoot | 55.6923434042 | -2.8616203432 |