Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:45:00 | 16:45:00 | ... | 1 |
|
| ... | 16:45:00 | 16:45:00 | ... | 2 |
|
| ... | 16:46:00 | 16:46:00 | ... | 3 |
|
| ... | 16:48:00 | 16:48:00 | ... | 4 |
|
| ... | 16:48:00 | 16:48:00 | ... | 5 |
|
| ... | 16:49:00 | 16:49:00 | ... | 6 |
|
| ... | 16:49:00 | 16:49:00 | ... | 7 |
|
| ... | 16:50:00 | 16:50:00 | ... | 8 |
|
| ... | 16:51:00 | 16:51:00 | ... | 9 |
|
| ... | 16:52:00 | 16:52:00 | ... | 10 |
|
| ... | 16:52:00 | 16:52:00 | ... | 11 |
|
| ... | 16:53:00 | 16:53:00 | ... | 12 |
|
| ... | 16:54:00 | 16:54:00 | ... | 13 |
|
| ... | 16:56:00 | 16:56:00 | ... | 14 |
|
| ... | 16:56:00 | 16:56:00 | ... | 15 |
|
| ... | 16:56:00 | 16:56:00 | ... | 16 |
|
| ... | 16:57:00 | 16:57:00 | ... | 17 |
|
| ... | 16:58:00 | 16:58:00 | ... | 18 |
|
| ... | 16:58:00 | 16:58:00 | ... | 19 |
|
| ... | 16:58:00 | 16:58:00 | ... | 20 |
|
| ... | 16:58:00 | 16:58:00 | ... | 21 |
|
| ... | 16:59:00 | 16:59:00 | ... | 22 |
|
| ... | 17:00:00 | 17:00:00 | ... | 23 |
|
| ... | 17:01:00 | 17:01:00 | ... | 24 |
|
| 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 | |
|---|---|---|---|---|
| 58232529 | Bankton Terrace | 55.9559132918 | -2.9630347677 | |
| 58232534 | Johnny Cope Stone | 55.9568149176 | -2.959181186 | |
| 58232526 | Gardiner Crescent | 55.9558900401 | -2.967150314 | |
| 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 | |
| 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 | |
| 58235292 | Harkness Crescent | 55.9421672264 | -2.9524629166 | |
| 58233500 | Lidl | 55.9631707873 | -2.9770555138 | |
| 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 |