Humbie - Haddington
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:00:00 | 16:00:00 | ... | 1 |
|
| ... | 16:02:00 | 16:02:00 | ... | 2 |
|
| ... | 16:02:00 | 16:02:00 | ... | 3 |
|
| ... | 16:04:00 | 16:04:00 | ... | 4 |
|
| ... | 16:05:00 | 16:05:00 | ... | 5 |
|
| ... | 16:06:00 | 16:06:00 | ... | 6 |
|
| ... | 16:06:00 | 16:06:00 | ... | 7 |
|
| ... | 16:07:00 | 16:07:00 | ... | 8 |
|
| ... | 16:10:00 | 16:10:00 | ... | 9 |
|
| ... | 16:11:00 | 16:11:00 | ... | 10 |
|
| ... | 16:13:00 | 16:13:00 | ... | 11 |
|
| ... | 16:14:00 | 16:14:00 | ... | 12 |
|
| ... | 16:15:00 | 16:15:00 | ... | 13 |
|
| ... | 16:17:00 | 16:17:00 | ... | 14 |
|
| ... | 16:18:00 | 16:18:00 | ... | 15 |
|
| ... | 16:19:00 | 16:19:00 | ... | 16 |
|
| ... | 16:19:00 | 16:19:00 | ... | 17 |
|
| ... | 16:20:00 | 16:20:00 | ... | 18 |
|
| ... | 16:22:00 | 16:22:00 | ... | 19 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 18/09/2017 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 58234957 | Kippithill | 55.8542402224 | -2.8682673651 | |
| 58232984 | War Memorial | 55.856813692 | -2.865193652 | |
| 58232986 | High Street | 55.9553027438 | -2.7772220846 | |
| 58232987 | Police Station | 55.9552695991 | -2.7824584872 | |
| 58232989 | Angle Park | 55.9554258308 | -2.7847358499 | |
| 58234362 | Caponflat Crescent | 55.9566190345 | -2.7878350812 | |
| 58235356 | Parkend | 55.931268056 | -2.7884728301 | |
| 58234364 | Roodlands Hospital | 55.9572699712 | -2.7956002146 | |
| 58232983 | Council Houses | 55.9202253762 | -2.7912727815 | |
| 58233501 | Maitlandfield House | 55.9532898227 | -2.7744112042 | |
| 5828267 | Post Office | 55.8549050685 | -2.8657263043 | |
| 5828352 | Humbie House | 55.8657456262 | -2.8457224114 | |
| 5828525 | Bughtknowe RE | 55.8709202665 | -2.8366459138 | |
| 5828596 | Humbie Station Cottages | 55.8755547674 | -2.8302885719 | |
| 5828725 | Ford Cottages | 55.876014245 | -2.8274374368 | |
| 5828938 | Petersmuir RE | 55.8825689427 | -2.8187048962 | |
| 5829268 | Bankrugg RE | 55.8987609964 | -2.8008308171 | |
| 5829438 | Upper Bolton Cottages | 55.9111185055 | -2.7948306243 | |
| 5829523 | Lennoxlove RE | 55.9423567947 | -2.7868890218 |