Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:50:00 | 16:50:00 | ... | 1 |
|
| ... | 16:50:00 | 16:50:00 | ... | 2 |
|
| ... | 16:51:00 | 16:51:00 | ... | 3 |
|
| ... | 16:52:00 | 16:52:00 | ... | 4 |
|
| ... | 16:52:00 | 16:52:00 | ... | 5 |
|
| ... | 16:52:00 | 16:52:00 | ... | 6 |
|
| ... | 16:53:00 | 16:53:00 | ... | 7 |
|
| ... | 16:54:00 | 16:54:00 | ... | 8 |
|
| ... | 16:55:00 | 16:55:00 | ... | 9 |
|
| ... | 16:55:00 | 16:55:00 | ... | 10 |
|
| ... | 16:55:00 | 16:55:00 | ... | 11 |
|
| ... | 16:56:00 | 16:56:00 | ... | 12 |
|
| ... | 16:56:00 | 16:56:00 | ... | 13 |
|
| ... | 16:57:00 | 16:57:00 | ... | 14 |
|
| ... | 16:57:00 | 16:57:00 | ... | 15 |
|
| ... | 16:58:00 | 16:58:00 | ... | 16 |
|
| ... | 16:59:00 | 16:59:00 | ... | 17 |
|
| ... | 16:59:00 | 16:59:00 | ... | 18 |
|
| ... | 17:00:00 | 17:00:00 | ... | 19 |
|
| ... | 17:02:00 | 17:02:00 | ... | 20 |
|
| ... | 17:02:00 | 17:02:00 | ... | 21 |
|
| ... | 17:03:00 | 17:03:00 | ... | 22 |
|
| ... | 17:03:00 | 17:03:00 | ... | 23 |
|
| ... | 17:04:00 | 17:04:00 | ... | 24 |
|
| ... | 17:05:00 | 17:05:00 | ... | 25 |
|
| ... | 17:06:00 | 17:06:00 | ... | 26 |
|
| ... | 17:06:00 | 17:06:00 | ... | 27 |
|
| ... | 17:07:00 | 17:07:00 | ... | 28 |
|
| ... | 17:08:00 | 17:08:00 | ... | 29 |
|
| ... | 17:10:00 | 17:10:00 | ... | 30 |
|
| ... | 17:10:00 | 17:10:00 | ... | 31 |
|
| ... | 17:10:00 | 17:10:00 | ... | 32 |
|
| ... | 17:11:00 | 17:11:00 | ... | 33 |
|
| ... | 17:12:00 | 17:12:00 | ... | 34 |
|
| ... | 17:12:00 | 17:12:00 | ... | 35 |
|
| ... | 17:12:00 | 17:12:00 | ... | 36 |
|
| ... | 17:12:00 | 17:12:00 | ... | 37 |
|
| ... | 17:13:00 | 17:13:00 | ... | 38 |
|
| ... | 17:14:00 | 17:14:00 | ... | 39 |
|
| ... | 17:15:00 | 17:15:00 | ... | 40 |
|
| ... | 17:16:00 | 17:16:00 | ... | 41 |
|
| ... | 17:18:00 | 17:18:00 | ... | 42 |
|
| ... | 17:19:00 | 17:19:00 | ... | 43 |
|
| ... | 17:19:00 | 17:19:00 | ... | 44 |
|
| ... | 17:20:00 | 17:20:00 | ... | 45 |
|
| ... | 17:21:00 | 17:21:00 | ... | 46 |
|
| ... | 17:22:00 | 17:22:00 | ... | 47 |
|
| ... | 17:22:00 | 17:22:00 | ... | 48 |
|
| ... | 17:23:00 | 17:23:00 | ... | 49 |
|
| ... | 17:25:00 | 17:25:00 | ... | 50 |
|
| ... | 17:25:00 | 17:25:00 | ... | 51 |
|
| ... | 17:26:00 | 17:26:00 | ... | 52 |
|
| ... | 17:26:00 | 17:26:00 | ... | 53 |
|
| ... | 17:28:00 | 17:28:00 | ... | 54 |
|
| ... | 17:29:00 | 17:29:00 | ... | 55 |
|
| ... | 17:30:00 | 17:30:00 | ... | 56 |
|
| ... | 17:31:00 | 17:31:00 | ... | 57 |
|
| ... | 17:32:00 | 17:32:00 | ... | 58 |
|
| ... | 17:32:00 | 17:32:00 | ... | 59 |
|
| ... | 17:33:00 | 17:33:00 | ... | 60 |
|
| ... | 17:33:00 | 17:33:00 | ... | 61 |
|
| ... | 17:34:00 | 17:34:00 | ... | 62 |
|
| ... | 17:34:00 | 17:34:00 | ... | 63 |
|
| ... | 17:35:00 | 17:35:00 | ... | 64 |
|
| 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 | |
|---|---|---|---|---|
| 58232537 | Rowanhill Drive | 55.9657927754 | -2.9543409659 | |
| 58232539 | Sycamore Avenue | 55.9668068741 | -2.9498481431 | |
| 58232543 | Poplar Park | 55.9675225105 | -2.9479271602 | |
| 58232546 | Seton Wynd | 55.968761945 | -2.943311287 | |
| 58232547 | Forth Wynd | 55.9700815187 | -2.9399467677 | |
| 58232529 | Bankton Terrace | 55.9559132918 | -2.9630347677 | |
| 58232534 | Johnny Cope Stone | 55.9568149176 | -2.959181186 | |
| 58232526 | Gardiner Crescent | 55.9558900401 | -2.967150314 | |
| 58234735 | Links | 55.965775008 | -2.9715621626 | |
| 58232385 | Power Station | 55.9686151314 | -2.9668910451 | |
| 58232386 | East Lorimer Place | 55.9691240795 | -2.9638596539 | |
| 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 | |
| 58235367 | Preston Links | 55.9638633167 | -2.9747021029 | |
| 58235369 | Atholl View | 55.9626831906 | -2.9716769045 | |
| 58235373 | McLachlan Gardens | 55.9615490803 | -2.9696461816 | |
| 58235375 | Preston Lodge | 55.959647317 | -2.9681089839 | |
| 58232748 | St Joseph's | 55.955500782 | -2.9513649695 | |
| 58232876 | Police Station | 55.9435516342 | -2.9500472319 | |
| 58232742 | Fire Station | 55.9472310694 | -2.9552773409 | |
| 58232746 | Fowler Street | 55.9487610383 | -2.9561156744 | |
| 58232737 | Fa'side Lodge | 55.9455231602 | -2.9542105318 | |
| 58234949 | Research Centre | 55.927725992 | -2.952716728 | |
| 58234686 | Buxley Farm Road End | 55.9274784286 | -2.9381467487 | |
| 58232745 | A1 Roundabout | 55.9507262721 | -2.9552833548 | |
| 58232892 | Health Centre | 55.9427130417 | -2.951595734 | |
| 58232898 | Fleets Road | 55.9401962114 | -2.9609796441 | |
| 58232689 | Duries Park | 55.9231109351 | -2.9661256049 | |
| 58232693 | War Memorial | 55.9219567771 | -2.9666409565 | |
| 58232965 | School | 55.9113476274 | -2.8912841146 | |
| 58234964 | Kiloran | 55.9080988054 | -2.9224822288 | |
| 58232936 | Beech Terrace | 55.9099673554 | -2.8994589018 | |
| 58232967 | Old Smiddy Inn | 55.9120904797 | -2.8854619431 | |
| 58234734 | Dovecot Park | 55.9098673705 | -2.897153025 | |
| 58232935 | Wolfstar | 55.9067063262 | -2.9331822816 | |
| 58234675 | Ormiston Road End | 55.90602719 | -2.9374207552 | |
| 58232934 | Cross | 55.9128114402 | -2.9397282475 | |
| 58232957 | Cross Loan | 55.913265566 | -2.9367315315 | |
| 58235239 | East Mains Road End | 55.9201577038 | -2.9354896771 | |
| 58235286 | Market Street | 55.9558078514 | -2.7783372929 | |
| 58232975 | Corn Exchange | 55.9555756186 | -2.7809591934 | |
| 58232973 | Rosehall Place | 55.9538016026 | -2.7900359443 | |
| 58235292 | Harkness Crescent | 55.9421672264 | -2.9524629166 | |
| 58233500 | Lidl | 55.9631707873 | -2.9770555138 | |
| 5826525 | Nisbet Road End | 55.9228959322 | -2.8644893234 | |
| 5826735 | Whitelodge RE | 55.9310147483 | -2.8482323874 | |
| 5826827 | Samuelston RE | 55.9355596397 | -2.8353176647 | |
| 5827252 | Sunnyside | 55.9383133745 | -2.8280290078 | |
| 5827389 | Blackhouse Bridge | 55.9439636088 | -2.8120426479 | |
| 5827525 | Letham Mains RE | 55.9456203093 | -2.8074179646 | |
| 5827625 | Black House | 55.9479567795 | -2.8018622197 | |
| 5827825 | Clerkington Mill RE | 55.9502814284 | -2.7967059036 | |
| 5823786 | Swan Road | 55.9404527237 | -2.958040219 | |
| 5823984 | King's Road | 55.9415958774 | -2.9543060653 | |
| 5823489 | West Windygoul | 55.9385323763 | -2.9623312108 | |
| 5824579 | Castle Road | 55.936953634 | -2.963140496 | |
| 5824289 | Fa'side View | 55.9357633056 | -2.9636872325 | |
| 5824379 | Research Centre RE | 55.9318292478 | -2.9646459565 | |
| 5823289 | North Elphinstone | 55.9273200625 | -2.9633175808 |