Haddington - Pencaitland and Gifford circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 13:00:00 | 13:00:00 | ... | 1 |
|
| ... | 13:00:00 | 13:00:00 | ... | 2 |
|
| ... | 13:02:00 | 13:02:00 | ... | 3 |
|
| ... | 13:03:00 | 13:03:00 | ... | 4 |
|
| ... | 13:04:00 | 13:04:00 | ... | 5 |
|
| ... | 13:04:00 | 13:04:00 | ... | 6 |
|
| ... | 13:04:00 | 13:04:00 | ... | 7 |
|
| ... | 13:04:00 | 13:04:00 | ... | 8 |
|
| ... | 13:04:00 | 13:04:00 | ... | 9 |
|
| ... | 13:05:00 | 13:05:00 | ... | 10 |
|
| ... | 13:05:00 | 13:05:00 | ... | 11 |
|
| ... | 13:07:00 | 13:07:00 | ... | 12 |
|
| ... | 13:07:00 | 13:07:00 | ... | 13 |
|
| ... | 13:09:00 | 13:09:00 | ... | 14 |
|
| ... | 13:09:00 | 13:09:00 | ... | 15 |
|
| ... | 13:10:00 | 13:10:00 | ... | 16 |
|
| ... | 13:11:00 | 13:11:00 | ... | 17 |
|
| ... | 13:11:00 | 13:11:00 | ... | 18 |
|
| ... | 13:13:00 | 13:13:00 | ... | 19 |
|
| ... | 13:14:00 | 13:14:00 | ... | 20 |
|
| ... | 13:16:00 | 13:16:00 | ... | 21 |
|
| ... | 13:18:00 | 13:18:00 | ... | 22 |
|
| ... | 13:18:00 | 13:18:00 | ... | 23 |
|
| ... | 13:19:00 | 13:19:00 | ... | 24 |
|
| ... | 13:21:00 | 13:21:00 | ... | 25 |
|
| ... | 13:22:00 | 13:22:00 | ... | 26 |
|
| ... | 13:22:00 | 13:22:00 | ... | 27 |
|
| ... | 13:23:00 | 13:23:00 | ... | 28 |
|
| ... | 13:26:00 | 13:26:00 | ... | 29 |
|
| ... | 13:26:00 | 13:26:00 | ... | 30 |
|
| ... | 13:26:00 | 13:26:00 | ... | 31 |
|
| ... | 13:29:00 | 13:29:00 | ... | 32 |
|
| ... | 13:30:00 | 13:30:00 | ... | 33 |
|
| ... | 13:32:00 | 13:32:00 | ... | 34 |
|
| ... | 13:32:00 | 13:32:00 | ... | 35 |
|
| ... | 13:34:00 | 13:34:00 | ... | 36 |
|
| ... | 13:34:00 | 13:34:00 | ... | 37 |
|
| ... | 13:35:00 | 13:35:00 | ... | 38 |
|
| ... | 13:35:00 | 13:35:00 | ... | 39 |
|
| ... | 13:36:00 | 13:36:00 | ... | 40 |
|
| ... | 13:36:00 | 13:36:00 | ... | 41 |
|
| ... | 13:37:00 | 13:37:00 | ... | 42 |
|
| ... | 13:38:00 | 13:38:00 | ... | 43 |
|
| ... | 13:39:00 | 13:39:00 | ... | 44 |
|
| 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 | |
| 58235287 | Lempockwells Rd End | 55.8954863348 | -2.8791189795 | |
| 58234656 | Fletcher Hall | 55.9022314447 | -2.8435575264 | |
| 58232947 | Byre Court | 55.9001779378 | -2.8403303653 | |
| 58232948 | Institute | 55.9092113983 | -2.894690383 | |
| 58232939 | Crossroads | 55.8968694429 | -2.8626949471 | |
| 58235286 | Market Street | 55.9558078514 | -2.7783372929 | |
| 58232976 | Victoria Bridge | 55.9564519288 | -2.7730809645 | |
| 58232975 | Corn Exchange | 55.9555756186 | -2.7809591934 | |
| 58232973 | Rosehall Place | 55.9538016026 | -2.7900359443 | |
| 58235345 | Bolton Muir Wood | 55.9054066579 | -2.7971929847 | |
| 58234272 | Monkmains | 55.9509393582 | -2.7652044388 | |
| 58232946 | Goblin Ha' | 55.9031715653 | -2.7466860269 | |
| 58234747 | Golf Course | 55.9551641981 | -2.7649034349 | |
| 58235352 | Dobsons Walk | 55.9515009051 | -2.7901171893 | |
| 58233503 | Seggarsdean Park | 55.9531374941 | -2.7599149519 | |
| 5823424 | Seggarsdean Crescent | 55.9513630889 | -2.7620740825 | |
| 5823524 | Long Cram | 55.9504314784 | -2.7929458088 | |
| 5826525 | Nisbet Road End | 55.9228959322 | -2.8644893234 | |
| 5826735 | Whitelodge RE | 55.9310147483 | -2.8482323874 | |
| 5826827 | Samuelston RE | 55.9355596397 | -2.8353176647 | |
| 5827252 | Sunnyside | 55.9383133745 | -2.8280290078 | |
| 5827389 | Blackhouse Bridge | 55.9439636088 | -2.8120426479 | |
| 5827525 | Letham Mains RE | 55.9456203093 | -2.8074179646 | |
| 5827625 | Black House | 55.9479567795 | -2.8018622197 | |
| 5827825 | Clerkington Mill RE | 55.9502814284 | -2.7967059036 | |
| 5826285 | Lempockwells | 55.8985064307 | -2.8827375776 | |
| 5827684 | West Lodge | 55.8984353027 | -2.8725489192 | |
| 5827686 | South Lodge | 55.9041757716 | -2.857355042 | |
| 5827879 | Oak Cottage | 55.9039643129 | -2.8238420337 | |
| 5827979 | Inglisfield Cottage | 55.9021755397 | -2.7741118748 | |
| 5825786 | Tweeddale Ave | 55.9010939984 | -2.7499726726 | |
| 5827983 | Gifford Vale | 55.9069379197 | -2.7464225104 | |
| 5828687 | Slateford Farm RE | 55.9134850572 | -2.7469162905 | |
| 5828484 | Myreside RE | 55.9180526667 | -2.7434201215 | |
| 5828785 | Beech Hill RE | 55.9300711237 | -2.746979347 | |
| 5827286 | Cockles Smiddy | 55.9360407816 | -2.7508240055 | |
| 5828387 | Monkrigg West Lodge | 55.940014599 | -2.7664778241 | |
| 5823486 | Lennoxlove East Port | 55.9452120091 | -2.7701510392 | |
| 5825683 | Lennoxlove Acredales | 55.9487461294 | -2.7725430647 | |
| 5825384 | Briery Bank east | 55.9506882398 | -2.7680178754 | |
| 5825279 | Briery Bank west | 55.9494809516 | -2.771420771 |