Haddington - Edinburgh Royal Infirmary
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:10:00 | 07:10:00 | ... | 1 |
|
| ... | 07:10:00 | 07:10:00 | ... | 2 |
|
| ... | 07:10:00 | 07:10:00 | ... | 3 |
|
| ... | 07:11:00 | 07:11:00 | ... | 4 |
|
| ... | 07:11:00 | 07:11:00 | ... | 5 |
|
| ... | 07:12:00 | 07:12:00 | ... | 6 |
|
| ... | 07:13:00 | 07:13:00 | ... | 7 |
|
| ... | 07:14:00 | 07:14:00 | ... | 8 |
|
| ... | 07:14:00 | 07:14:00 | ... | 9 |
|
| ... | 07:15:00 | 07:15:00 | ... | 10 |
|
| ... | 07:15:00 | 07:15:00 | ... | 11 |
|
| ... | 07:16:00 | 07:16:00 | ... | 12 |
|
| ... | 07:17:00 | 07:17:00 | ... | 13 |
|
| ... | 07:18:00 | 07:18:00 | ... | 14 |
|
| ... | 07:19:00 | 07:19:00 | ... | 15 |
|
| ... | 07:21:00 | 07:21:00 | ... | 16 |
|
| ... | 07:21:00 | 07:21:00 | ... | 17 |
|
| ... | 07:21:00 | 07:21:00 | ... | 18 |
|
| ... | 07:22:00 | 07:22:00 | ... | 19 |
|
| ... | 07:22:00 | 07:22:00 | ... | 20 |
|
| ... | 07:22:00 | 07:22:00 | ... | 21 |
|
| ... | 07:23:00 | 07:23:00 | ... | 22 |
|
| ... | 07:24:00 | 07:24:00 | ... | 23 |
|
| ... | 07:27:00 | 07:27:00 | ... | 24 |
|
| ... | 07:27:00 | 07:27:00 | ... | 25 |
|
| ... | 07:28:00 | 07:28:00 | ... | 26 |
|
| ... | 07:29:00 | 07:29:00 | ... | 27 |
|
| ... | 07:31:00 | 07:31:00 | ... | 28 |
|
| ... | 07:33:00 | 07:33:00 | ... | 29 |
|
| ... | 07:33:00 | 07:33:00 | ... | 30 |
|
| ... | 07:34:00 | 07:34:00 | ... | 31 |
|
| ... | 07:34:00 | 07:34:00 | ... | 32 |
|
| ... | 07:37:00 | 07:37:00 | ... | 33 |
|
| ... | 07:37:00 | 07:37:00 | ... | 34 |
|
| ... | 07:38:00 | 07:38:00 | ... | 35 |
|
| ... | 07:38:00 | 07:38:00 | ... | 36 |
|
| ... | 07:38:00 | 07:38:00 | ... | 37 |
|
| ... | 07:40:00 | 07:40:00 | ... | 38 |
|
| ... | 07:40:00 | 07:40:00 | ... | 39 |
|
| ... | 07:41:00 | 07:41:00 | ... | 40 |
|
| ... | 07:41:00 | 07:41:00 | ... | 41 |
|
| ... | 07:42:00 | 07:42:00 | ... | 42 |
|
| ... | 07:42:00 | 07:42:00 | ... | 43 |
|
| ... | 07:43:00 | 07:43:00 | ... | 44 |
|
| ... | 07:44:00 | 07:44:00 | ... | 45 |
|
| ... | 07:44:00 | 07:44:00 | ... | 46 |
|
| ... | 07:44:00 | 07:44:00 | ... | 47 |
|
| ... | 07:45:00 | 07:45:00 | ... | 48 |
|
| ... | 07:45:00 | 07:45:00 | ... | 49 |
|
| ... | 07:46:00 | 07:46:00 | ... | 50 |
|
| ... | 07:47:00 | 07:47:00 | ... | 51 |
|
| ... | 07:47:00 | 07:47:00 | ... | 52 |
|
| ... | 07:48:00 | 07:48:00 | ... | 53 |
|
| ... | 07:48:00 | 07:48:00 | ... | 54 |
|
| ... | 07:49:00 | 07:49:00 | ... | 55 |
|
| ... | 07:49:00 | 07:49:00 | ... | 56 |
|
| ... | 07:49:00 | 07:49:00 | ... | 57 |
|
| ... | 07:50:00 | 07:50:00 | ... | 58 |
|
| ... | 07:51:00 | 07:51:00 | ... | 59 |
|
| ... | 07:51:00 | 07:51:00 | ... | 60 |
|
| ... | 07:53:00 | 07:53:00 | ... | 61 |
|
| ... | 07:54:00 | 07:54:00 | ... | 62 |
|
| ... | 07:54:00 | 07:54:00 | ... | 63 |
|
| ... | 07:54:00 | 07:54:00 | ... | 64 |
|
| ... | 07:55:00 | 07:55:00 | ... | 65 |
|
| ... | 07:55:00 | 07:55:00 | ... | 66 |
|
| ... | 07:56:00 | 07:56:00 | ... | 67 |
|
| ... | 07:56:00 | 07:56:00 | ... | 68 |
|
| ... | 07:57:00 | 07:57:00 | ... | 69 |
|
| ... | 07:57:00 | 07:57:00 | ... | 70 |
|
| ... | 07:57:00 | 07:57:00 | ... | 71 |
|
| ... | 07:58:00 | 07:58:00 | ... | 72 |
|
| ... | 07:59:00 | 07:59:00 | ... | 73 |
|
| ... | 08:00:00 | 08:00:00 | ... | 74 |
|
| ... | 08:01:00 | 08:01:00 | ... | 75 |
|
| ... | 08:01:00 | 08:01:00 | ... | 76 |
|
| ... | 08:02:00 | 08:02:00 | ... | 77 |
|
| ... | 08:02:00 | 08:02:00 | ... | 78 |
|
| ... | 08:05:00 | 08:05:00 | ... | 79 |
|
| ... | 08:08:00 | 08:08:00 | ... | 80 |
|
| ... | 08:08:00 | 08:08:00 | ... | 81 |
|
| ... | 08:08:00 | 08:08:00 | ... | 82 |
|
| ... | 08:08:00 | 08:08:00 | ... | 83 |
|
| ... | 08:09:00 | 08:09:00 | ... | 84 |
|
| ... | 08:10:00 | 08:10:00 | ... | 85 |
|
| ... | 08:11:00 | 08:11:00 | ... | 86 |
|
| ... | 08:16:00 | 08:16:00 | ... | 87 |
|
| ... | 08:19:00 | 08:19:00 | ... | 88 |
|
| ... | 08:22:00 | 08:22:00 | ... | 89 |
|
| ... | 08:24:00 | 08:24:00 | ... | 90 |
|
| ... | 08:25:00 | 08:25:00 | ... | 91 |
|
| ... | 08:25:00 | 08:25:00 | ... | 92 |
|
| ... | 08:26:00 | 08:26:00 | ... | 93 |
|
| ... | 08:27:00 | 08:27:00 | ... | 94 |
|
| ... | 08:28:00 | 08:28:00 | ... | 95 |
|
| ... | 08:29:00 | 08:29:00 | ... | 96 |
|
| ... | 08:30:00 | 08:30:00 | ... | 97 |
|
| 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 | |
|---|---|---|---|---|
| 36253732 | Milligan Drive | 55.9261186903 | -3.1221905572 | |
| 36253735 | Bowes Place | 55.925381483 | -3.1192725686 | |
| 36253638 | Royal Infirmary | 55.9223024549 | -3.1327059173 | |
| 36253686 | SCRM | 55.9220371931 | -3.130281817 | |
| 36253687 | Sandilands Close | 55.9247483181 | -3.1246634961 | |
| 58232493 | The Loan | 55.9406874227 | -3.0107502921 | |
| 58232473 | Institute | 55.9398665654 | -3.012233804 | |
| 58232475 | Albert Place | 55.9384712822 | -3.0136382113 | |
| 58232479 | Dolphin Inn | 55.922193593 | -3.0358724147 | |
| 58232483 | Whitecraig Crescent | 55.9209421303 | -3.0383032998 | |
| 58232679 | Loretto RC Primary School | 55.9422668774 | -3.0475516348 | |
| 58234763 | Tesco | 55.9404361759 | -3.0577965281 | |
| 58232864 | Police Station | 55.9423500722 | -3.0525491921 | |
| 58232495 | Auction House | 55.9436609797 | -3.0075294782 | |
| 58232474 | Fa'side Inn | 55.936663419 | -3.0160402436 | |
| 58232482 | Dolphin Inn | 55.9215852488 | -3.0366242824 | |
| 58232484 | Whitecraig Crescent | 55.9204531187 | -3.0387542692 | |
| 58232795 | Main Road | 55.9227372446 | -3.0669158195 | |
| 58232796 | Golf Club | 55.9313239544 | -3.060013119 | |
| 58232856 | Eskview Road | 55.9389203453 | -3.0616614541 | |
| 58232854 | Eskview Crescent | 55.937969655 | -3.0624999207 | |
| 58232853 | Haugh Park | 55.9360703289 | -3.0628961443 | |
| 58232852 | Stoneybank Place | 55.93417734 | -3.0615156975 | |
| 58232849 | Mayfield Crescent | 55.9335543046 | -3.0608263628 | |
| 58232683 | Rothesay Place | 55.9390761865 | -3.0476576065 | |
| 58234959 | Inveresk Kennels | 55.9299282804 | -3.0403362701 | |
| 58234765 | Inveresk Village | 55.9348388581 | -3.0429810781 | |
| 58235325 | Tesco Terminus | 55.9392832559 | -3.0549794699 | |
| 58232585 | Goose Green | 56.0344710561 | -2.8334092208 | |
| 58232587 | Maule Terrace | 56.0352067466 | -2.8309054397 | |
| 58232592 | Lammermuir Court | 56.0361071095 | -2.8279557198 | |
| 58232596 | Muirfield House | 56.0384543213 | -2.8195636935 | |
| 58232594 | Broadgait | 56.0370646306 | -2.8245095513 | |
| 58235246 | Luffness Golf Club | 56.0201494105 | -2.8399668027 | |
| 58235236 | Craigielaw | 56.0036596901 | -2.8764267277 | |
| 58232576 | The Pleasance | 56.0065864338 | -2.8691481199 | |
| 58232583 | Community Hall | 56.0106720281 | -2.8592639093 | |
| 58232578 | Parish Church | 56.0082344938 | -2.8647748101 | |
| 58232579 | Poplars | 56.0092647938 | -2.8613496729 | |
| 58232383 | Links | 55.965907865 | -2.9718057954 | |
| 58232384 | Power Station | 55.968793669 | -2.9670396913 | |
| 58232437 | Longniddry Inn | 55.9748267458 | -2.8939133585 | |
| 58232438 | Railway Station | 55.9757554387 | -2.8909863427 | |
| 58232573 | Gosford House | 55.9792341852 | -2.890777881 | |
| 58234768 | Gosford Road | 55.9818065096 | -2.8929044629 | |
| 58232427 | Links View | 55.9722049157 | -2.9419209971 | |
| 58232387 | East Lorimer Place | 55.969436029 | -2.9630342864 | |
| 58232424 | Fishers Road | 55.9721677916 | -2.950267941 | |
| 58232426 | Castle Terrace | 55.9722987682 | -2.9449195393 | |
| 58232398 | Post Office | 55.9717718095 | -2.9526776416 | |
| 58232396 | Cope Lane | 55.9713117787 | -2.9552299169 | |
| 58232394 | Inglis Avenue | 55.9709494937 | -2.9567591237 | |
| 58232392 | School Lane | 55.9700776375 | -2.960262418 | |
| 58232524 | Hawthorn Road Shops | 55.957358345 | -2.9689647848 | |
| 58235365 | Preston Links | 55.9639981948 | -2.9746894747 | |
| 58232379 | Drummore Drive | 55.9519124108 | -2.9905442874 | |
| 58232497 | Health Centre | 55.9556815493 | -2.9753613068 | |
| 58232376 | Alexander Drive | 55.9535026323 | -2.9860846602 | |
| 58232374 | Northfield House | 55.9546462666 | -2.9801399345 | |
| 58232523 | Polwarth Terrace | 55.9567445038 | -2.9716081697 | |
| 58232452 | Road End | 55.9721586568 | -2.9314570382 | |
| 58235243 | Gosford House North Lodge | 55.9983351761 | -2.8847237538 | |
| 58235257 | Ferny Ness | 55.9866857322 | -2.8965753009 | |
| 58235368 | Atholl View | 55.9628836187 | -2.9724668564 | |
| 58235372 | McLachlan Gardens | 55.9613971179 | -2.969546271 | |
| 58235374 | Preston Lodge | 55.9596282176 | -2.9682526654 | |
| 58234927 | Post Office | 55.9751433161 | -2.8960999094 | |
| 58234929 | Seton Road | 55.9763310238 | -2.8983387404 | |
| 58234937 | Archerfield | 56.041626929 | -2.7960997714 | |
| 58234876 | Queenstonbank | 56.0415525808 | -2.7880886732 | |
| 58234987 | West Garleton | 55.9760664816 | -2.8066902276 | |
| 58234757 | Railway Station | 56.005939112 | -2.7862247716 | |
| 58235286 | Market Street | 55.9558078514 | -2.7783372929 | |
| 58234525 | Angle Park | 55.9555609973 | -2.7846745228 | |
| 58234363 | Caponflat Crescent | 55.9568896775 | -2.7876644021 | |
| 58232975 | Corn Exchange | 55.9555756186 | -2.7809591934 | |
| 58234367 | Garleton Drive | 55.9585374887 | -2.7913176864 | |
| 58234365 | Roodlands Hospital | 55.957334616 | -2.7953292627 | |
| 58234543 | Herdmanflat Hospital | 55.9595594277 | -2.787478379 | |
| 58235256 | Harperdean | 55.9643241722 | -2.7940629649 | |
| 5823624 | Rowberry Walk | 55.9506036764 | -2.9935054652 | |
| 5823823 | Cottages | 55.9926294839 | -2.8305046115 | |
| 5824972 | Campbell Road | 55.976591818 | -2.9019983702 | |
| 5825459 | King's Avenue | 55.9751198481 | -2.9054573135 | |
| 5825625 | King's Grove | 55.9737062456 | -2.9058569131 | |
| 5825725 | Old Dean Road | 55.9726213502 | -2.9055431423 | |
| 5825825 | Dean Park | 55.9718550805 | -2.9083291824 | |
| 5826325 | Seton Dean Lodge | 55.9728616703 | -2.9240072207 | |
| 64324586 | Cauldcoats | 55.9262183561 | -3.111198628 | |
| 64323738 | Hilltown Terrace | 55.9196076457 | -3.1039208528 | |
| 64323742 | Moorfield Cottages | 55.9169199907 | -3.0980043707 | |
| 64323957 | Millerhill Road | 55.9149267156 | -3.0958200981 | |
| 64323959 | Millerhill Road | 55.9129710374 | -3.0934451272 | |
| 64323935 | Wester Millerhill | 55.9112957089 | -3.0878147029 | |
| 64323927 | Easter Millerhill | 55.9139303703 | -3.0824968413 | |
| 64323929 | Newton Cottages | 55.9187111953 | -3.0731895639 | |
| 64323963 | Newton Church Road | 55.9141086596 | -3.094853073 |