Haddington - Edinburgh Royal Infirmary
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:00:00 | 14:00:00 | ... | 1 |
|
| ... | 14:00:00 | 14:00:00 | ... | 2 |
|
| ... | 14:00:00 | 14:00:00 | ... | 3 |
|
| ... | 14:01:00 | 14:01:00 | ... | 4 |
|
| ... | 14:01:00 | 14:01:00 | ... | 5 |
|
| ... | 14:02:00 | 14:02:00 | ... | 6 |
|
| ... | 14:02:00 | 14:02:00 | ... | 7 |
|
| ... | 14:03:00 | 14:03:00 | ... | 8 |
|
| ... | 14:04:00 | 14:04:00 | ... | 9 |
|
| ... | 14:04:00 | 14:04:00 | ... | 10 |
|
| ... | 14:05:00 | 14:05:00 | ... | 11 |
|
| ... | 14:06:00 | 14:06:00 | ... | 12 |
|
| ... | 14:08:00 | 14:08:00 | ... | 13 |
|
| ... | 14:10:00 | 14:10:00 | ... | 14 |
|
| ... | 14:10:00 | 14:10:00 | ... | 15 |
|
| ... | 14:10:00 | 14:10:00 | ... | 16 |
|
| ... | 14:11:00 | 14:11:00 | ... | 17 |
|
| ... | 14:11:00 | 14:11:00 | ... | 18 |
|
| ... | 14:13:00 | 14:13:00 | ... | 19 |
|
| ... | 14:13:00 | 14:13:00 | ... | 20 |
|
| ... | 14:14:00 | 14:14:00 | ... | 21 |
|
| ... | 14:14:00 | 14:14:00 | ... | 22 |
|
| ... | 14:14:00 | 14:14:00 | ... | 23 |
|
| ... | 14:19:00 | 14:19:00 | ... | 24 |
|
| ... | 14:20:00 | 14:20:00 | ... | 25 |
|
| ... | 14:20:00 | 14:20:00 | ... | 26 |
|
| ... | 14:20:00 | 14:20:00 | ... | 27 |
|
| ... | 14:22:00 | 14:22:00 | ... | 28 |
|
| ... | 14:24:00 | 14:24:00 | ... | 29 |
|
| ... | 14:25:00 | 14:25:00 | ... | 30 |
|
| ... | 14:26:00 | 14:26:00 | ... | 31 |
|
| ... | 14:27:00 | 14:27:00 | ... | 32 |
|
| ... | 14:30:00 | 14:30:00 | ... | 33 |
|
| ... | 14:30:00 | 14:30:00 | ... | 34 |
|
| ... | 14:30:00 | 14:30:00 | ... | 35 |
|
| ... | 14:31:00 | 14:31:00 | ... | 36 |
|
| ... | 14:31:00 | 14:31:00 | ... | 37 |
|
| ... | 14:32:00 | 14:32:00 | ... | 38 |
|
| ... | 14:32:00 | 14:32:00 | ... | 39 |
|
| ... | 14:32:00 | 14:32:00 | ... | 40 |
|
| ... | 14:35:00 | 14:35:00 | ... | 41 |
|
| ... | 14:35:00 | 14:35:00 | ... | 42 |
|
| ... | 14:37:00 | 14:37:00 | ... | 43 |
|
| ... | 14:37:00 | 14:37:00 | ... | 44 |
|
| ... | 14:39:00 | 14:39:00 | ... | 45 |
|
| ... | 14:39:00 | 14:39:00 | ... | 46 |
|
| ... | 14:39:00 | 14:39:00 | ... | 47 |
|
| ... | 14:40:00 | 14:40:00 | ... | 48 |
|
| ... | 14:43:00 | 14:43:00 | ... | 49 |
|
| ... | 14:43:00 | 14:43:00 | ... | 50 |
|
| ... | 14:43:00 | 14:43:00 | ... | 51 |
|
| ... | 14:44:00 | 14:44:00 | ... | 52 |
|
| ... | 14:45:00 | 14:45:00 | ... | 53 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 11/06/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36253736 | Bowes Place | 55.9255931499 | -3.1197107746 | |
| 36253734 | Milligan Drive | 55.9256707909 | -3.1230258158 | |
| 36253638 | Royal Infirmary | 55.9223024549 | -3.1327059173 | |
| 36253689 | Sandilands Close | 55.9244021394 | -3.1251815789 | |
| 36253639 | SCRM | 55.9220435049 | -3.1295938977 | |
| 58232478 | Fa'side Inn | 55.9362669631 | -3.016173936 | |
| 58232479 | Dolphin Inn | 55.922193593 | -3.0358724147 | |
| 58232483 | Whitecraig Crescent | 55.9209421303 | -3.0383032998 | |
| 58232494 | The Loan | 55.940835227 | -3.0102578351 | |
| 58232472 | Institute | 55.9393982468 | -3.0123656709 | |
| 58234867 | Albert Place | 55.9380205336 | -3.0138185421 | |
| 58232482 | Dolphin Inn | 55.9215852488 | -3.0366242824 | |
| 58232484 | Whitecraig Crescent | 55.9204531187 | -3.0387542692 | |
| 58232678 | Loretto RC Primary School | 55.9417175373 | -3.0476969065 | |
| 58232784 | Tesco | 55.9405319166 | -3.0571107135 | |
| 58232757 | Police Station | 55.9420868223 | -3.0528622607 | |
| 58235378 | Auction House | 55.9437737537 | -3.0069239844 | |
| 58232684 | Rothesay Place | 55.939772796 | -3.0481567013 | |
| 58234958 | Inveresk Kennels | 55.9299258472 | -3.0406243034 | |
| 58234764 | Inveresk Village | 55.9349077425 | -3.043335095 | |
| 58232794 | Main Road | 55.9224138483 | -3.0669069331 | |
| 58232793 | Golf Club | 55.9306817365 | -3.0605077668 | |
| 58232785 | Eskview Road | 55.9391407695 | -3.0611071591 | |
| 58232786 | Eskview Crescent | 55.9377652495 | -3.062238184 | |
| 58232787 | Haugh Park | 55.9357777486 | -3.062439909 | |
| 58232789 | Stoneybank Place | 55.9346262256 | -3.0615599903 | |
| 58232792 | Mayfield Crescent | 55.933068355 | -3.0598686791 | |
| 58235325 | Tesco Terminus | 55.9392832559 | -3.0549794699 | |
| 58234735 | Links | 55.965775008 | -2.9715621626 | |
| 58232385 | Power Station | 55.9686151314 | -2.9668910451 | |
| 58232386 | East Lorimer Place | 55.9691240795 | -2.9638596539 | |
| 58232389 | School Lane | 55.9695477296 | -2.9613868285 | |
| 58232397 | Post Office | 55.9715159366 | -2.9532321386 | |
| 58232395 | Cope Lane | 55.9710580062 | -2.9555120634 | |
| 58232393 | Inglis Avenue | 55.9706786216 | -2.9569286804 | |
| 58232525 | Hawthorn Road Shops | 55.957233584 | -2.9688335344 | |
| 58235367 | Preston Links | 55.9638633167 | -2.9747021029 | |
| 58232382 | Drummore Drive | 55.9517956266 | -2.9905413048 | |
| 58232496 | Health Centre | 55.9554101445 | -2.9755947185 | |
| 58232378 | Alexander Drive | 55.9532500714 | -2.9862063584 | |
| 58232375 | Northfield House | 55.9545118974 | -2.9800884919 | |
| 58232498 | Polwarth Terrace | 55.9562514383 | -2.9726048365 | |
| 58235369 | Atholl View | 55.9626831906 | -2.9716769045 | |
| 58235373 | McLachlan Gardens | 55.9615490803 | -2.9696461816 | |
| 58235375 | Preston Lodge | 55.959647317 | -2.9681089839 | |
| 5823623 | Rowberry Walk | 55.9504884415 | -2.9933103471 | |
| 64323958 | Newton Church Road | 55.9137045595 | -3.0948256831 | |
| 64323932 | Newton Cottages | 55.9185327855 | -3.0730406259 | |
| 64323928 | Easter Millerhill | 55.9135460611 | -3.0822621473 | |
| 64323936 | Wester Millerhill | 55.9111083336 | -3.0876654753 | |
| 64323956 | Millerhill Road | 55.9151719787 | -3.0965309961 | |
| 64323743 | Moorfield Cottages | 55.9168630961 | -3.0983387663 | |
| 64323739 | Hilltown Terrace | 55.91928454 | -3.1038796651 |