Haddington - Port Seton
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:04:00 | 16:04:00 | ... | 1 |
|
| ... | 16:04:00 | 16:04:00 | ... | 2 |
|
| ... | 16:05:00 | 16:05:00 | ... | 3 |
|
| ... | 16:06:00 | 16:06:00 | ... | 4 |
|
| ... | 16:06:00 | 16:06:00 | ... | 5 |
|
| ... | 16:06:00 | 16:06:00 | ... | 6 |
|
| ... | 16:07:00 | 16:07:00 | ... | 7 |
|
| ... | 16:07:00 | 16:07:00 | ... | 8 |
|
| ... | 16:08:00 | 16:08:00 | ... | 9 |
|
| ... | 16:08:00 | 16:08:00 | ... | 10 |
|
| ... | 16:09:00 | 16:09:00 | ... | 11 |
|
| ... | 16:11:00 | 16:11:00 | ... | 12 |
|
| ... | 16:11:00 | 16:11:00 | ... | 13 |
|
| ... | 16:12:00 | 16:12:00 | ... | 14 |
|
| ... | 16:12:00 | 16:12:00 | ... | 15 |
|
| ... | 16:13:00 | 16:13:00 | ... | 16 |
|
| ... | 16:14:00 | 16:14:00 | ... | 17 |
|
| ... | 16:15:00 | 16:15:00 | ... | 18 |
|
| ... | 16:16:00 | 16:16:00 | ... | 19 |
|
| ... | 16:16:00 | 16:16:00 | ... | 20 |
|
| ... | 16:17:00 | 16:17:00 | ... | 21 |
|
| ... | 16:18:00 | 16:18:00 | ... | 22 |
|
| ... | 16:18:00 | 16:18:00 | ... | 23 |
|
| ... | 16:20:00 | 16:20: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 | |
|---|---|---|---|---|
| 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 | |
| 58235289 | Harkness Crescent | 55.9424677136 | -2.9531107127 | |
| 58232693 | War Memorial | 55.9219567771 | -2.9666409565 | |
| 58233500 | Lidl | 55.9631707873 | -2.9770555138 | |
| 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 |