Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:58:00 | 12:58:00 | ... | 1 |
|
| ... | 12:58:00 | 12:58:00 | ... | 2 |
|
| ... | 12:58:00 | 12:58:00 | ... | 3 |
|
| ... | 12:58:00 | 12:58:00 | ... | 4 |
|
| ... | 12:59:00 | 12:59:00 | ... | 5 |
|
| ... | 13:00:00 | 13:00:00 | ... | 6 |
|
| ... | 13:00:00 | 13:00:00 | ... | 7 |
|
| ... | 13:00:00 | 13:00:00 | ... | 8 |
|
| ... | 13:02:00 | 13:02:00 | ... | 9 |
|
| ... | 13:02:00 | 13:02:00 | ... | 10 |
|
| ... | 13:03:00 | 13:03:00 | ... | 11 |
|
| ... | 13:05:00 | 13:05:00 | ... | 12 |
|
| ... | 13:07:00 | 13:07:00 | ... | 13 |
|
| ... | 13:08:00 | 13:08:00 | ... | 14 |
|
| ... | 13:08:00 | 13:08:00 | ... | 15 |
|
| ... | 13:08:00 | 13:08:00 | ... | 16 |
|
| ... | 13:11:00 | 13:11:00 | ... | 17 |
|
| ... | 13:12:00 | 13:12:00 | ... | 18 |
|
| ... | 13:12:00 | 13:12:00 | ... | 19 |
|
| ... | 13:13:00 | 13:13:00 | ... | 20 |
|
| ... | 13:14:00 | 13:14:00 | ... | 21 |
|
| ... | 13:14:00 | 13:14:00 | ... | 22 |
|
| ... | 13:15:00 | 13:15:00 | ... | 23 |
|
| ... | 13:16:00 | 13:16:00 | ... | 24 |
|
| ... | 13:17:00 | 13:17:00 | ... | 25 |
|
| ... | 13:18:00 | 13:18:00 | ... | 26 |
|
| ... | 13:19:00 | 13:19:00 | ... | 27 |
|
| ... | 13:20:00 | 13:20:00 | ... | 28 |
|
| ... | 13:20:00 | 13:20:00 | ... | 29 |
|
| ... | 13:21:00 | 13:21:00 | ... | 30 |
|
| ... | 13:22:00 | 13:22:00 | ... | 31 |
|
| ... | 13:22:00 | 13:22:00 | ... | 32 |
|
| ... | 13:22:00 | 13:22:00 | ... | 33 |
|
| ... | 13:23:00 | 13:23:00 | ... | 34 |
|
| ... | 13:23:00 | 13:23:00 | ... | 35 |
|
| ... | 13:24:00 | 13:24:00 | ... | 36 |
|
| ... | 13:24:00 | 13:24:00 | ... | 37 |
|
| ... | 13:25:00 | 13:25:00 | ... | 38 |
|
| ... | 13:27:00 | 13:27:00 | ... | 39 |
|
| ... | 13:27:00 | 13:27:00 | ... | 40 |
|
| ... | 13:28:00 | 13:28:00 | ... | 41 |
|
| ... | 13:28:00 | 13:28:00 | ... | 42 |
|
| ... | 13:29:00 | 13:29:00 | ... | 43 |
|
| ... | 13:30:00 | 13:30:00 | ... | 44 |
|
| ... | 13:31:00 | 13:31:00 | ... | 45 |
|
| ... | 13:32:00 | 13:32:00 | ... | 46 |
|
| ... | 13:32:00 | 13:32:00 | ... | 47 |
|
| ... | 13:33:00 | 13:33:00 | ... | 48 |
|
| ... | 13:34:00 | 13:34:00 | ... | 49 |
|
| ... | 13:34:00 | 13:34:00 | ... | 50 |
|
| ... | 13:36:00 | 13:36:00 | ... | 51 |
|
| 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 | |
|---|---|---|---|---|
| 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 |