Haddington - Edinburgh Royal Infirmary
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:55:00 | 12:55:00 | ... | 1 |
|
| ... | 12:55:00 | 12:55:00 | ... | 2 |
|
| ... | 12:56:00 | 12:56:00 | ... | 3 |
|
| ... | 12:56:00 | 12:56:00 | ... | 4 |
|
| ... | 12:58:00 | 12:58:00 | ... | 5 |
|
| ... | 12:58:00 | 12:58:00 | ... | 6 |
|
| ... | 12:58:00 | 12:58:00 | ... | 7 |
|
| ... | 12:59:00 | 12:59:00 | ... | 8 |
|
| ... | 13:01:00 | 13:01:00 | ... | 9 |
|
| ... | 13:04:00 | 13:04:00 | ... | 10 |
|
| ... | 13:09:00 | 13:09:00 | ... | 11 |
|
| ... | 13:13:00 | 13:13:00 | ... | 12 |
|
| ... | 13:14:00 | 13:14:00 | ... | 13 |
|
| ... | 13:16:00 | 13:16:00 | ... | 14 |
|
| ... | 13:16:00 | 13:16:00 | ... | 15 |
|
| ... | 13:16:00 | 13:16:00 | ... | 16 |
|
| ... | 13:17:00 | 13:17:00 | ... | 17 |
|
| ... | 13:17:00 | 13:17:00 | ... | 18 |
|
| ... | 13:19:00 | 13:19:00 | ... | 19 |
|
| ... | 13:22:00 | 13:22:00 | ... | 20 |
|
| ... | 13:23:00 | 13:23:00 | ... | 21 |
|
| ... | 13:23:00 | 13:23:00 | ... | 22 |
|
| ... | 13:23:00 | 13:23:00 | ... | 23 |
|
| ... | 13:24:00 | 13:24:00 | ... | 24 |
|
| ... | 13:25:00 | 13:25:00 | ... | 25 |
|
| ... | 13:26:00 | 13:26:00 | ... | 26 |
|
| ... | 13:27:00 | 13:27:00 | ... | 27 |
|
| ... | 13:28:00 | 13:28:00 | ... | 28 |
|
| ... | 13:28:00 | 13:28:00 | ... | 29 |
|
| ... | 13:28:00 | 13:28:00 | ... | 30 |
|
| ... | 13:29:00 | 13:29:00 | ... | 31 |
|
| ... | 13:29:00 | 13:29:00 | ... | 32 |
|
| ... | 13:30:00 | 13:30:00 | ... | 33 |
|
| ... | 13:30:00 | 13:30:00 | ... | 34 |
|
| ... | 13:30:00 | 13:30:00 | ... | 35 |
|
| ... | 13:31:00 | 13:31:00 | ... | 36 |
|
| ... | 13:33:00 | 13:33:00 | ... | 37 |
|
| ... | 13:34:00 | 13:34:00 | ... | 38 |
|
| ... | 13:35:00 | 13:35:00 | ... | 39 |
|
| ... | 13:35:00 | 13:35:00 | ... | 40 |
|
| ... | 13:36:00 | 13:36:00 | ... | 41 |
|
| ... | 13:37:00 | 13:37:00 | ... | 42 |
|
| ... | 13:37:00 | 13:37:00 | ... | 43 |
|
| ... | 13:37:00 | 13:37:00 | ... | 44 |
|
| ... | 13:37:00 | 13:37:00 | ... | 45 |
|
| ... | 13:38:00 | 13:38:00 | ... | 46 |
|
| ... | 13:38:00 | 13:38:00 | ... | 47 |
|
| ... | 13:39:00 | 13:39:00 | ... | 48 |
|
| ... | 13:39:00 | 13:39:00 | ... | 49 |
|
| ... | 13:40:00 | 13:40:00 | ... | 50 |
|
| ... | 13:40:00 | 13:40:00 | ... | 51 |
|
| ... | 13:41:00 | 13:41:00 | ... | 52 |
|
| ... | 13:42:00 | 13:42:00 | ... | 53 |
|
| ... | 13:43:00 | 13:43:00 | ... | 54 |
|
| ... | 13:44:00 | 13:44:00 | ... | 55 |
|
| ... | 13:44:00 | 13:44:00 | ... | 56 |
|
| ... | 13:45:00 | 13:45:00 | ... | 57 |
|
| ... | 13:45:00 | 13:45:00 | ... | 58 |
|
| ... | 13:46:00 | 13:46:00 | ... | 59 |
|
| ... | 13:47:00 | 13:47:00 | ... | 60 |
|
| ... | 13:48:00 | 13:48:00 | ... | 61 |
|
| ... | 13:49:00 | 13:49:00 | ... | 62 |
|
| ... | 13:49:00 | 13:49:00 | ... | 63 |
|
| ... | 13:49:00 | 13:49:00 | ... | 64 |
|
| ... | 13:54:00 | 13:54:00 | ... | 65 |
|
| ... | 13:55:00 | 13:55:00 | ... | 66 |
|
| ... | 13:55:00 | 13:55:00 | ... | 67 |
|
| ... | 13:55:00 | 13:55:00 | ... | 68 |
|
| ... | 13:58:00 | 13:58:00 | ... | 69 |
|
| ... | 13:59:00 | 13:59:00 | ... | 70 |
|
| ... | 14:01:00 | 14:01:00 | ... | 71 |
|
| ... | 14:02:00 | 14:02:00 | ... | 72 |
|
| ... | 14:03:00 | 14:03:00 | ... | 73 |
|
| ... | 14:05:00 | 14:05:00 | ... | 74 |
|
| ... | 14:05:00 | 14:05:00 | ... | 75 |
|
| ... | 14:06:00 | 14:06:00 | ... | 76 |
|
| ... | 14:07:00 | 14:07:00 | ... | 77 |
|
| ... | 14:08:00 | 14:08:00 | ... | 78 |
|
| ... | 14:09:00 | 14:09:00 | ... | 79 |
|
| ... | 14:09:00 | 14:09:00 | ... | 80 |
|
| ... | 14:10:00 | 14:10:00 | ... | 81 |
|
| ... | 14:10:00 | 14:10:00 | ... | 82 |
|
| ... | 14:10:00 | 14:10:00 | ... | 83 |
|
| ... | 14:11:00 | 14:11:00 | ... | 84 |
|
| ... | 14:11:00 | 14:11:00 | ... | 85 |
|
| ... | 14:12:00 | 14:12:00 | ... | 86 |
|
| ... | 14:12:00 | 14:12:00 | ... | 87 |
|
| ... | 14:15:00 | 14:15:00 | ... | 88 |
|
| ... | 14:15:00 | 14:15:00 | ... | 89 |
|
| ... | 14:17:00 | 14:17:00 | ... | 90 |
|
| ... | 14:18:00 | 14:18:00 | ... | 91 |
|
| ... | 14:20:00 | 14:20:00 | ... | 92 |
|
| ... | 14:20:00 | 14:20:00 | ... | 93 |
|
| ... | 14:20:00 | 14:20:00 | ... | 94 |
|
| ... | 14:21:00 | 14:21:00 | ... | 95 |
|
| ... | 14:23:00 | 14:23:00 | ... | 96 |
|
| ... | 14:23:00 | 14:23:00 | ... | 97 |
|
| ... | 14:24:00 | 14:24:00 | ... | 98 |
|
| ... | 14:24:00 | 14:24:00 | ... | 99 |
|
| ... | 14:25:00 | 14:25:00 | ... | 100 |
|
| 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 | |
| 58232843 | Whitehill Gardens | 55.9338540884 | -3.0697985535 | |
| 58234753 | Stoneybank Gardens | 55.9356923374 | -3.0650468571 | |
| 58232845 | Whitehill Avenue | 55.9346766391 | -3.0671639852 | |
| 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 | |
| 58232825 | Whitehill Gardens | 55.9339072016 | -3.0688555947 | |
| 58232824 | Whitehill Avenue | 55.9345630458 | -3.0667926907 | |
| 58234729 | Stoneybank Gardens | 55.9355046584 | -3.0649296517 | |
| 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 | |
| 58232586 | Goose Green | 56.0343014504 | -2.8332450819 | |
| 58232646 | West Links Road | 56.03355068 | -2.8353151392 | |
| 58232589 | Lammermuir Court | 56.0358183389 | -2.8281421224 | |
| 58232595 | Muirfield House | 56.0376305202 | -2.8218413285 | |
| 58232593 | Broadgait | 56.0368484856 | -2.8245851881 | |
| 58235247 | Luffness Golf Club | 56.0203032255 | -2.8398097177 | |
| 58234735 | Links | 55.965775008 | -2.9715621626 | |
| 58235237 | Craigielaw | 56.0035991977 | -2.8760886098 | |
| 58232575 | The Pleasance | 56.0063718439 | -2.8689989701 | |
| 58232584 | Community Hall | 56.0105203117 | -2.8591161943 | |
| 58232574 | Parish Church | 56.0077071415 | -2.8656611161 | |
| 58232582 | Poplars | 56.0090680497 | -2.861216991 | |
| 58232385 | Power Station | 55.9686151314 | -2.9668910451 | |
| 58232386 | East Lorimer Place | 55.9691240795 | -2.9638596539 | |
| 58232436 | Longniddry Inn | 55.9744567903 | -2.8941291547 | |
| 58232439 | Railway Station | 55.9757882941 | -2.890169867 | |
| 58232572 | Gosford House | 55.9785644655 | -2.8902015984 | |
| 58232428 | Links View | 55.9720443145 | -2.9417728896 | |
| 58232389 | School Lane | 55.9695477296 | -2.9613868285 | |
| 58232423 | Fishers Road | 55.972009053 | -2.9498795044 | |
| 58232425 | Castle Terrace | 55.9720791098 | -2.9454429327 | |
| 58232397 | Post Office | 55.9715159366 | -2.9532321386 | |
| 58232395 | Cope Lane | 55.9710580062 | -2.9555120634 | |
| 58232393 | Inglis Avenue | 55.9706786216 | -2.9569286804 | |
| 58232452 | Road End | 55.9721586568 | -2.9314570382 | |
| 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 | |
| 58235245 | Gosford House North Lodge | 55.9983553288 | -2.8844195784 | |
| 58235258 | Ferny Ness | 55.98667873 | -2.8963026517 | |
| 58235369 | Atholl View | 55.9626831906 | -2.9716769045 | |
| 58235373 | McLachlan Gardens | 55.9615490803 | -2.9696461816 | |
| 58235375 | Preston Lodge | 55.959647317 | -2.9681089839 | |
| 58234926 | Post Office | 55.9750168465 | -2.8961931277 | |
| 58234928 | Seton Road | 55.9762395525 | -2.8985609605 | |
| 58234938 | Archerfield | 56.0414959001 | -2.7955192288 | |
| 58232597 | Queenstonbank | 56.0414092507 | -2.7880215462 | |
| 58234986 | West Garleton | 55.9759662961 | -2.8068964549 | |
| 58232564 | Railway Station | 56.0059374757 | -2.7864813217 | |
| 58234368 | Garleton Drive | 55.9586341509 | -2.7916560141 | |
| 58232986 | High Street | 55.9553027438 | -2.7772220846 | |
| 58232987 | Police Station | 55.9552695991 | -2.7824584872 | |
| 58232989 | Angle Park | 55.9554258308 | -2.7847358499 | |
| 58234362 | Caponflat Crescent | 55.9566190345 | -2.7878350812 | |
| 58234364 | Roodlands Hospital | 55.9572699712 | -2.7956002146 | |
| 58234369 | Herdmanflat Hospital | 55.9592807225 | -2.7875047528 | |
| 58235254 | Harperdean | 55.9642328883 | -2.7942853641 | |
| 5823623 | Rowberry Walk | 55.9504884415 | -2.9933103471 | |
| 5823724 | Cottages | 55.9927179173 | -2.8307149118 | |
| 5824962 | Campbell Road | 55.9764490185 | -2.9018668506 | |
| 5825382 | King's Avenue | 55.9750131043 | -2.9053106047 | |
| 5825482 | King's Grove | 55.97401157 | -2.9058800737 | |
| 5825692 | Old Dean Road | 55.9725693318 | -2.9052855614 | |
| 5825732 | Dean Park | 55.9717211532 | -2.908213886 | |
| 5825925 | Seton Dean Lodge | 55.9727091902 | -2.9239715392 | |
| 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 |