Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 06:48:00 | 06:48:00 | ... | 1 |
|
| ... | 06:48:00 | 06:48:00 | ... | 2 |
|
| ... | 06:48:00 | 06:48:00 | ... | 3 |
|
| ... | 06:48:00 | 06:48:00 | ... | 4 |
|
| ... | 06:49:00 | 06:49:00 | ... | 5 |
|
| ... | 06:50:00 | 06:50:00 | ... | 6 |
|
| ... | 06:50:00 | 06:50:00 | ... | 7 |
|
| ... | 06:50:00 | 06:50:00 | ... | 8 |
|
| ... | 06:52:00 | 06:52:00 | ... | 9 |
|
| ... | 06:52:00 | 06:52:00 | ... | 10 |
|
| ... | 06:53:00 | 06:53:00 | ... | 11 |
|
| ... | 06:55:00 | 06:55:00 | ... | 12 |
|
| ... | 06:57:00 | 06:57:00 | ... | 13 |
|
| ... | 06:58:00 | 06:58:00 | ... | 14 |
|
| ... | 06:58:00 | 06:58:00 | ... | 15 |
|
| ... | 06:58:00 | 06:58:00 | ... | 16 |
|
| ... | 07:00:00 | 07:00:00 | ... | 17 |
|
| ... | 07:00:00 | 07:00:00 | ... | 18 |
|
| ... | 07:01:00 | 07:01:00 | ... | 19 |
|
| ... | 07:01:00 | 07:01:00 | ... | 20 |
|
| ... | 07:02:00 | 07:02:00 | ... | 21 |
|
| ... | 07:02:00 | 07:02:00 | ... | 22 |
|
| ... | 07:03:00 | 07:03:00 | ... | 23 |
|
| ... | 07:04:00 | 07:04:00 | ... | 24 |
|
| ... | 07:05:00 | 07:05:00 | ... | 25 |
|
| ... | 07:06:00 | 07:06:00 | ... | 26 |
|
| ... | 07:07:00 | 07:07:00 | ... | 27 |
|
| ... | 07:08:00 | 07:08:00 | ... | 28 |
|
| ... | 07:08:00 | 07:08:00 | ... | 29 |
|
| ... | 07:09:00 | 07:09:00 | ... | 30 |
|
| ... | 07:10:00 | 07:10:00 | ... | 31 |
|
| ... | 07:10:00 | 07:10:00 | ... | 32 |
|
| ... | 07:10:00 | 07:10:00 | ... | 33 |
|
| ... | 07:11:00 | 07:11:00 | ... | 34 |
|
| ... | 07:11:00 | 07:11:00 | ... | 35 |
|
| ... | 07:12:00 | 07:12:00 | ... | 36 |
|
| ... | 07:12:00 | 07:12:00 | ... | 37 |
|
| ... | 07:13:00 | 07:13:00 | ... | 38 |
|
| ... | 07:15:00 | 07:15:00 | ... | 39 |
|
| 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 | |
|---|---|---|---|---|
| 58232879 | Health Centre | 55.9427905959 | -2.9508611479 | |
| 58234953 | Fleets Road | 55.9403007718 | -2.960245792 | |
| 58232897 | Police Station | 55.9433607577 | -2.950330753 | |
| 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 | |
| 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 |