Haddington - Pencaitland and Gifford circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:14:00 | 12:14:00 | ... | 1 |
|
| ... | 12:14:00 | 12:14:00 | ... | 2 |
|
| ... | 12:15:00 | 12:15:00 | ... | 3 |
|
| ... | 12:15:00 | 12:15:00 | ... | 4 |
|
| ... | 12:16:00 | 12:16:00 | ... | 5 |
|
| ... | 12:16:00 | 12:16:00 | ... | 6 |
|
| ... | 12:16:00 | 12:16:00 | ... | 7 |
|
| ... | 12:17:00 | 12:17:00 | ... | 8 |
|
| ... | 12:17:00 | 12:17:00 | ... | 9 |
|
| ... | 12:19:00 | 12:19:00 | ... | 10 |
|
| ... | 12:19:00 | 12:19:00 | ... | 11 |
|
| ... | 12:21:00 | 12:21:00 | ... | 12 |
|
| ... | 12:22:00 | 12:22:00 | ... | 13 |
|
| ... | 12:25:00 | 12:25:00 | ... | 14 |
|
| ... | 12:25:00 | 12:25:00 | ... | 15 |
|
| ... | 12:26:00 | 12:26:00 | ... | 16 |
|
| ... | 12:26:00 | 12:26:00 | ... | 17 |
|
| ... | 12:26:00 | 12:26:00 | ... | 18 |
|
| ... | 12:26:00 | 12:26:00 | ... | 19 |
|
| ... | 12:28:00 | 12:28:00 | ... | 20 |
|
| ... | 12:30:00 | 12:30:00 | ... | 21 |
|
| ... | 12:31:00 | 12:31:00 | ... | 22 |
|
| ... | 12:31:00 | 12:31:00 | ... | 23 |
|
| ... | 12:33:00 | 12:33:00 | ... | 24 |
|
| ... | 12:33:00 | 12:33:00 | ... | 25 |
|
| ... | 12:34:00 | 12:34:00 | ... | 26 |
|
| ... | 12:34:00 | 12:34:00 | ... | 27 |
|
| ... | 12:35:00 | 12:35:00 | ... | 28 |
|
| ... | 12:35:00 | 12:35:00 | ... | 29 |
|
| ... | 12:35:00 | 12:35:00 | ... | 30 |
|
| ... | 12:36:00 | 12:36:00 | ... | 31 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 04/05/2015 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 58232965 | School | 55.9113476274 | -2.8912841146 | |
| 58232967 | Old Smiddy Inn | 55.9120904797 | -2.8854619431 | |
| 58232964 | School | 55.911176242 | -2.891376167 | |
| 58232968 | Old Smiddy Inn | 55.9117403442 | -2.8854219659 | |
| 58232948 | Institute | 55.9092113983 | -2.894690383 | |
| 58232937 | Institute | 55.90836712 | -2.8934072283 | |
| 58235286 | Market Street | 55.9558078514 | -2.7783372929 | |
| 58232975 | Corn Exchange | 55.9555756186 | -2.7809591934 | |
| 58232973 | Rosehall Place | 55.9538016026 | -2.7900359443 | |
| 58232986 | High Street | 55.9553027438 | -2.7772220846 | |
| 58232987 | Police Station | 55.9552695991 | -2.7824584872 | |
| 58234827 | Rosehall Place | 55.953742308 | -2.7894742156 | |
| 58232969 | Dobsons Walk | 55.9519040505 | -2.7903015578 | |
| 5823523 | Long Cram | 55.9504294169 | -2.793266037 | |
| 5826525 | Nisbet Road End | 55.9228959322 | -2.8644893234 | |
| 5826725 | Nisbet Road End | 55.9230615697 | -2.8639329297 | |
| 5826735 | Whitelodge RE | 55.9310147483 | -2.8482323874 | |
| 5826825 | Whitelodge RE | 55.9308625749 | -2.8481490342 | |
| 5826827 | Samuelston RE | 55.9355596397 | -2.8353176647 | |
| 5826925 | Samuelston RE | 55.9353800719 | -2.8352977922 | |
| 5827252 | Sunnyside | 55.9383133745 | -2.8280290078 | |
| 5827325 | Sunnyside | 55.9383804561 | -2.827406104 | |
| 5827389 | Blackhouse Bridge | 55.9439636088 | -2.8120426479 | |
| 5827425 | Blackhouse Bridge | 55.9438573852 | -2.811800262 | |
| 5827525 | Letham Mains RE | 55.9456203093 | -2.8074179646 | |
| 5827578 | Letham Mains RE | 55.945477302 | -2.8073029076 | |
| 5827625 | Black House | 55.9479567795 | -2.8018622197 | |
| 5827639 | Black House | 55.9478319431 | -2.8017155269 | |
| 5827825 | Clerkington Mill RE | 55.9502814284 | -2.7967059036 | |
| 5827925 | Clerkington Mill RE | 55.9501657768 | -2.7965273805 |