Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:40:00 | 09:40:00 | ... | 1 |
|
| ... | 09:40:00 | 09:40:00 | ... | 2 |
|
| ... | 09:40:00 | 09:40:00 | ... | 3 |
|
| ... | 09:40:00 | 09:40:00 | ... | 4 |
|
| ... | 09:41:00 | 09:41:00 | ... | 5 |
|
| ... | 09:42:00 | 09:42:00 | ... | 6 |
|
| ... | 09:42:00 | 09:42:00 | ... | 7 |
|
| ... | 09:42:00 | 09:42:00 | ... | 8 |
|
| ... | 09:44:00 | 09:44:00 | ... | 9 |
|
| ... | 09:44:00 | 09:44:00 | ... | 10 |
|
| ... | 09:45:00 | 09:45:00 | ... | 11 |
|
| ... | 09:47:00 | 09:47:00 | ... | 12 |
|
| ... | 09:49:00 | 09:49:00 | ... | 13 |
|
| ... | 09:50:00 | 09:50:00 | ... | 14 |
|
| ... | 09:50:00 | 09:50:00 | ... | 15 |
|
| ... | 09:50:00 | 09:50:00 | ... | 16 |
|
| ... | 09:53:00 | 09:53:00 | ... | 17 |
|
| ... | 09:54:00 | 09:54:00 | ... | 18 |
|
| ... | 09:54:00 | 09:54:00 | ... | 19 |
|
| ... | 09:55:00 | 09:55:00 | ... | 20 |
|
| ... | 09:56:00 | 09:56:00 | ... | 21 |
|
| ... | 09:56:00 | 09:56:00 | ... | 22 |
|
| ... | 09:58:00 | 09:58:00 | ... | 23 |
|
| ... | 10:00:00 | 10:00:00 | ... | 24 |
|
| ... | 10:02:00 | 10:02:00 | ... | 25 |
|
| ... | 10:03:00 | 10:03:00 | ... | 26 |
|
| ... | 10:03:00 | 10:03:00 | ... | 27 |
|
| ... | 10:04:00 | 10:04:00 | ... | 28 |
|
| ... | 10:04:00 | 10:04:00 | ... | 29 |
|
| ... | 10:05:00 | 10:05:00 | ... | 30 |
|
| ... | 10:06:00 | 10:06:00 | ... | 31 |
|
| ... | 10:06:00 | 10:06:00 | ... | 32 |
|
| ... | 10:06:00 | 10:06:00 | ... | 33 |
|
| ... | 10:07:00 | 10:07:00 | ... | 34 |
|
| ... | 10:07:00 | 10:07:00 | ... | 35 |
|
| ... | 10:08:00 | 10:08:00 | ... | 36 |
|
| ... | 10:08:00 | 10:08:00 | ... | 37 |
|
| ... | 10:09:00 | 10:09:00 | ... | 38 |
|
| ... | 10:11:00 | 10:11:00 | ... | 39 |
|
| ... | 10:11:00 | 10:11:00 | ... | 40 |
|
| ... | 10:12:00 | 10:12:00 | ... | 41 |
|
| ... | 10:12:00 | 10:12:00 | ... | 42 |
|
| ... | 10:13:00 | 10:13:00 | ... | 43 |
|
| ... | 10:14:00 | 10:14:00 | ... | 44 |
|
| ... | 10:15:00 | 10:15:00 | ... | 45 |
|
| ... | 10:16:00 | 10:16:00 | ... | 46 |
|
| ... | 10:16:00 | 10:16:00 | ... | 47 |
|
| ... | 10:17:00 | 10:17:00 | ... | 48 |
|
| ... | 10:18:00 | 10:18:00 | ... | 49 |
|
| ... | 10:18:00 | 10:18:00 | ... | 50 |
|
| ... | 10:20:00 | 10:20:00 | ... | 51 |
|
| ... | 10:20:00 | 10:20:00 | ... | 52 |
|
| ... | 10:20:00 | 10:20:00 | ... | 53 |
|
| ... | 10:21:00 | 10:21:00 | ... | 54 |
|
| ... | 10:22:00 | 10:22:00 | ... | 55 |
|
| ... | 10:22:00 | 10:22:00 | ... | 56 |
|
| ... | 10:23:00 | 10:23:00 | ... | 57 |
|
| ... | 10:23:00 | 10:23:00 | ... | 58 |
|
| ... | 10:24:00 | 10:24:00 | ... | 59 |
|
| ... | 10:24:00 | 10:24:00 | ... | 60 |
|
| ... | 10:25:00 | 10:25:00 | ... | 61 |
|
| ... | 10:26:00 | 10:26:00 | ... | 62 |
|
| ... | 10:26:00 | 10:26:00 | ... | 63 |
|
| ... | 10:27:00 | 10:27:00 | ... | 64 |
|
| ... | 10:27:00 | 10:27:00 | ... | 65 |
|
| ... | 10:28:00 | 10:28:00 | ... | 66 |
|
| ... | 10:29:00 | 10:29:00 | ... | 67 |
|
| 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 | |
|---|---|---|---|---|
| 58232383 | Links | 55.965907865 | -2.9718057954 | |
| 58232384 | Power Station | 55.968793669 | -2.9670396913 | |
| 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 | |
| 58235365 | Preston Links | 55.9639981948 | -2.9746894747 | |
| 58232536 | Rowanhill Drive | 55.9655784122 | -2.9541754881 | |
| 58232538 | Sycamore Avenue | 55.9664547893 | -2.9500638009 | |
| 58232542 | Poplar Park | 55.9673444422 | -2.9477145358 | |
| 58232545 | Seton Wynd | 55.9685094259 | -2.9434333111 | |
| 58232548 | Forth Wynd | 55.9706019513 | -2.9400394998 | |
| 58232528 | Bankton Terrace | 55.9555313537 | -2.9636178707 | |
| 58232532 | Johnny Cope Stone | 55.9565064868 | -2.9595579477 | |
| 58232527 | Gardiner Crescent | 55.9554105222 | -2.9675707827 | |
| 58235368 | Atholl View | 55.9628836187 | -2.9724668564 | |
| 58235372 | McLachlan Gardens | 55.9613971179 | -2.969546271 | |
| 58235374 | Preston Lodge | 55.9596282176 | -2.9682526654 | |
| 58232749 | St Joseph's | 55.9558398054 | -2.9516775909 | |
| 58232743 | A1 Roundabout | 55.9506602833 | -2.9556820762 | |
| 58232879 | Health Centre | 55.9427905959 | -2.9508611479 | |
| 58234953 | Fleets Road | 55.9403007718 | -2.960245792 | |
| 58232897 | Police Station | 55.9433607577 | -2.950330753 | |
| 58232739 | Fire Station | 55.9473076989 | -2.9558236525 | |
| 58232747 | Fowler Street | 55.9486869335 | -2.9564020828 | |
| 58232738 | Fa'side Lodge | 55.9457084651 | -2.9546474091 | |
| 58234952 | Research Centre | 55.9277218343 | -2.9520924542 | |
| 58232958 | Buxley Farm Road End | 55.9272429051 | -2.9383971238 | |
| 58235289 | Harkness Crescent | 55.9424677136 | -2.9531107127 | |
| 58232689 | Duries Park | 55.9231109351 | -2.9661256049 | |
| 58232693 | War Memorial | 55.9219567771 | -2.9666409565 | |
| 58232964 | School | 55.911176242 | -2.891376167 | |
| 58234965 | Kiloran | 55.9079642904 | -2.9224470422 | |
| 58232952 | Beech Terrace | 55.9096963042 | -2.9008923457 | |
| 58232968 | Old Smiddy Inn | 55.9117403442 | -2.8854219659 | |
| 58232949 | Dovecot Park | 55.9096253931 | -2.8970674522 | |
| 58232928 | Cross | 55.9130082248 | -2.9398449968 | |
| 58232927 | Cross Loan | 55.9135019379 | -2.9363692664 | |
| 58232953 | Wolfstar | 55.9065374553 | -2.9329382907 | |
| 58232956 | Bowling Club | 55.9104255977 | -2.9415262104 | |
| 58232954 | Ormiston Road End | 55.905996829 | -2.9378678946 | |
| 58235238 | East Mains Road End | 55.9200927523 | -2.9357601332 | |
| 58232986 | High Street | 55.9553027438 | -2.7772220846 | |
| 58232987 | Police Station | 55.9552695991 | -2.7824584872 | |
| 58234827 | Rosehall Place | 55.953742308 | -2.7894742156 | |
| 58233500 | Lidl | 55.9631707873 | -2.9770555138 | |
| 5826725 | Nisbet Road End | 55.9230615697 | -2.8639329297 | |
| 5826825 | Whitelodge RE | 55.9308625749 | -2.8481490342 | |
| 5826925 | Samuelston RE | 55.9353800719 | -2.8352977922 | |
| 5827325 | Sunnyside | 55.9383804561 | -2.827406104 | |
| 5827425 | Blackhouse Bridge | 55.9438573852 | -2.811800262 | |
| 5827578 | Letham Mains RE | 55.945477302 | -2.8073029076 | |
| 5827639 | Black House | 55.9478319431 | -2.8017155269 | |
| 5827925 | Clerkington Mill RE | 55.9501657768 | -2.7965273805 | |
| 5825984 | Knox Court | 55.9547595942 | -2.7849465819 | |
| 5823287 | Swan Road | 55.9407712535 | -2.9575197608 | |
| 5824286 | King's Road | 55.9417391176 | -2.9543736292 | |
| 5823286 | West Windygoul | 55.9384850825 | -2.9626342062 | |
| 5823985 | Castle Road | 55.9374381171 | -2.9632325629 | |
| 5824679 | Fa'side View | 55.9361487195 | -2.9638088586 | |
| 5824782 | Research Centre RE | 55.9318628001 | -2.9649509069 | |
| 5823289 | North Elphinstone | 55.9273200625 | -2.9633175808 | |
| 5824786 | North Elphinstone | 55.9271582342 | -2.9633295693 |