Haddington - Edinburgh Royal Infirmary
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 06:10:00 | 06:10:00 | ... | 1 |
|
| ... | 06:10:00 | 06:10:00 | ... | 2 |
|
| ... | 06:10:00 | 06:10:00 | ... | 3 |
|
| ... | 06:11:00 | 06:11:00 | ... | 4 |
|
| ... | 06:11:00 | 06:11:00 | ... | 5 |
|
| ... | 06:12:00 | 06:12:00 | ... | 6 |
|
| ... | 06:12:00 | 06:12:00 | ... | 7 |
|
| ... | 06:13:00 | 06:13:00 | ... | 8 |
|
| ... | 06:14:00 | 06:14:00 | ... | 9 |
|
| ... | 06:15:00 | 06:15:00 | ... | 10 |
|
| ... | 06:17:00 | 06:17:00 | ... | 11 |
|
| ... | 06:19:00 | 06:19:00 | ... | 12 |
|
| ... | 06:19:00 | 06:19:00 | ... | 13 |
|
| ... | 06:19:00 | 06:19:00 | ... | 14 |
|
| ... | 06:20:00 | 06:20:00 | ... | 15 |
|
| ... | 06:20:00 | 06:20:00 | ... | 16 |
|
| ... | 06:21:00 | 06:21:00 | ... | 17 |
|
| ... | 06:23:00 | 06:23:00 | ... | 18 |
|
| ... | 06:24:00 | 06:24:00 | ... | 19 |
|
| ... | 06:24:00 | 06:24:00 | ... | 20 |
|
| ... | 06:25:00 | 06:25:00 | ... | 21 |
|
| ... | 06:25:00 | 06:25:00 | ... | 22 |
|
| ... | 06:25:00 | 06:25:00 | ... | 23 |
|
| ... | 06:26:00 | 06:26:00 | ... | 24 |
|
| ... | 06:26:00 | 06:26:00 | ... | 25 |
|
| ... | 06:27:00 | 06:27:00 | ... | 26 |
|
| ... | 06:28:00 | 06:28:00 | ... | 27 |
|
| ... | 06:28:00 | 06:28:00 | ... | 28 |
|
| ... | 06:28:00 | 06:28:00 | ... | 29 |
|
| ... | 06:29:00 | 06:29:00 | ... | 30 |
|
| ... | 06:29:00 | 06:29:00 | ... | 31 |
|
| ... | 06:30:00 | 06:30:00 | ... | 32 |
|
| ... | 06:30:00 | 06:30:00 | ... | 33 |
|
| ... | 06:31:00 | 06:31:00 | ... | 34 |
|
| ... | 06:31:00 | 06:31:00 | ... | 35 |
|
| ... | 06:32:00 | 06:32:00 | ... | 36 |
|
| ... | 06:33:00 | 06:33:00 | ... | 37 |
|
| ... | 06:34:00 | 06:34:00 | ... | 38 |
|
| ... | 06:35:00 | 06:35:00 | ... | 39 |
|
| ... | 06:35:00 | 06:35:00 | ... | 40 |
|
| ... | 06:36:00 | 06:36:00 | ... | 41 |
|
| ... | 06:42:00 | 06:42:00 | ... | 42 |
|
| ... | 06:43:00 | 06:43:00 | ... | 43 |
|
| ... | 06:43:00 | 06:43:00 | ... | 44 |
|
| ... | 06:43:00 | 06:43:00 | ... | 45 |
|
| ... | 06:46:00 | 06:46:00 | ... | 46 |
|
| ... | 06:47:00 | 06:47:00 | ... | 47 |
|
| ... | 06:49:00 | 06:49:00 | ... | 48 |
|
| ... | 06:50:00 | 06:50:00 | ... | 49 |
|
| ... | 06:51:00 | 06:51:00 | ... | 50 |
|
| ... | 06:51:00 | 06:51:00 | ... | 51 |
|
| ... | 06:52:00 | 06:52:00 | ... | 52 |
|
| ... | 06:52:00 | 06:52:00 | ... | 53 |
|
| ... | 06:53:00 | 06:53:00 | ... | 54 |
|
| ... | 06:53:00 | 06:53:00 | ... | 55 |
|
| ... | 06:54:00 | 06:54:00 | ... | 56 |
|
| ... | 06:54:00 | 06:54:00 | ... | 57 |
|
| ... | 06:57:00 | 06:57:00 | ... | 58 |
|
| ... | 06:57:00 | 06:57:00 | ... | 59 |
|
| ... | 06:59:00 | 06:59:00 | ... | 60 |
|
| ... | 06:59:00 | 06:59:00 | ... | 61 |
|
| ... | 07:01:00 | 07:01:00 | ... | 62 |
|
| ... | 07:01:00 | 07:01:00 | ... | 63 |
|
| ... | 07:01:00 | 07:01:00 | ... | 64 |
|
| ... | 07:02:00 | 07:02:00 | ... | 65 |
|
| ... | 07:03:00 | 07:03:00 | ... | 66 |
|
| ... | 07:03:00 | 07:03:00 | ... | 67 |
|
| ... | 07:04:00 | 07:04:00 | ... | 68 |
|
| ... | 07:04:00 | 07:04:00 | ... | 69 |
|
| ... | 07:05:00 | 07:05:00 | ... | 70 |
|
| 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 | |
| 58232528 | Bankton Terrace | 55.9555313537 | -2.9636178707 | |
| 58232525 | Hawthorn Road Shops | 55.957233584 | -2.9688335344 | |
| 58232532 | Johnny Cope Stone | 55.9565064868 | -2.9595579477 | |
| 58232382 | Drummore Drive | 55.9517956266 | -2.9905413048 | |
| 58232527 | Gardiner Crescent | 55.9554105222 | -2.9675707827 | |
| 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 | |
| 58232749 | St Joseph's | 55.9558398054 | -2.9516775909 | |
| 58232743 | A1 Roundabout | 55.9506602833 | -2.9556820762 | |
| 58234242 | Gladsmuir Farmhouse | 55.9492933991 | -2.8671752965 | |
| 58234247 | Whiteloch Road | 55.941483396 | -2.9085786209 | |
| 58232897 | Police Station | 55.9433607577 | -2.950330753 | |
| 58234239 | Liberty Hall | 55.9517780969 | -2.8510245095 | |
| 58235232 | Coates Road | 55.9535209396 | -2.8366333586 | |
| 58235275 | Industrial Estate East | 55.947468398 | -2.888751268 | |
| 58234246 | St Germains Terrace | 55.9422261295 | -2.9053299117 | |
| 58234245 | Penston Rd End | 55.9453458958 | -2.8964682528 | |
| 58234243 | Roundabout | 55.9489316235 | -2.8789207642 | |
| 58232739 | Fire Station | 55.9473076989 | -2.9558236525 | |
| 58232747 | Fowler Street | 55.9486869335 | -2.9564020828 | |
| 58232738 | Fa'side Lodge | 55.9457084651 | -2.9546474091 | |
| 58232925 | St Martin's School | 55.9429955528 | -2.9475839785 | |
| 58234249 | Veterinary Surgery | 55.9424243745 | -2.9435674149 | |
| 58234248 | Tranmere Hotel | 55.941887778 | -2.9397119111 | |
| 58232986 | High Street | 55.9553027438 | -2.7772220846 | |
| 58234236 | Gateside Road | 55.9535637675 | -2.8045725521 | |
| 58234237 | Gateside Commerce Park | 55.9538947461 | -2.8102807473 | |
| 58232987 | Police Station | 55.9552695991 | -2.7824584872 | |
| 58234234 | Park Lane | 55.9546364614 | -2.79434504 | |
| 58232989 | Angle Park | 55.9554258308 | -2.7847358499 | |
| 58234232 | Letham Drive | 55.9552710566 | -2.790674471 | |
| 58234235 | Knowes Road | 55.9538470093 | -2.7997098867 | |
| 58234238 | Letham Mains Rd End | 55.9538932458 | -2.8240535998 | |
| 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 |