Kingston - Esher - Hersham - Walton on Thames - Staines
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:20:00 | 14:20:00 | ... | 1 |
|
| ... | 14:21:00 | 14:21:00 | ... | 2 |
|
| ... | 14:22:00 | 14:22:00 | ... | 3 |
|
| ... | 14:23:00 | 14:23:00 | ... | 4 |
|
| ... | 14:24:00 | 14:24:00 | ... | 5 |
|
| ... | 14:25:00 | 14:25:00 | ... | 6 |
|
| ... | 14:26:00 | 14:26:00 | ... | 7 |
|
| ... | 14:27:00 | 14:27:00 | ... | 8 |
|
| ... | 14:28:00 | 14:28:00 | ... | 9 |
|
| ... | 14:31:00 | 14:31:00 | ... | 10 |
|
| ... | 14:33:00 | 14:33:00 | ... | 11 |
|
| ... | 14:33:00 | 14:33:00 | ... | 12 |
|
| ... | 14:35:00 | 14:35:00 | ... | 13 |
|
| ... | 14:36:00 | 14:36:00 | ... | 14 |
|
| ... | 14:37:00 | 14:37:00 | ... | 15 |
|
| ... | 14:37:00 | 14:37:00 | ... | 16 |
|
| ... | 14:39:00 | 14:39:00 | ... | 17 |
|
| ... | 14:40:00 | 14:40:00 | ... | 18 |
|
| ... | 14:42:00 | 14:42:00 | ... | 19 |
|
| ... | 14:44:00 | 14:44:00 | ... | 20 |
|
| ... | 14:46:00 | 14:46:00 | ... | 21 |
|
| ... | 14:46:00 | 14:46:00 | ... | 22 |
|
| ... | 14:47:00 | 14:47:00 | ... | 23 |
|
| ... | 14:48:00 | 14:48:00 | ... | 24 |
|
| ... | 14:49:00 | 14:49:00 | ... | 25 |
|
| ... | 14:50:00 | 14:50:00 | ... | 26 |
|
| ... | 14:51:00 | 14:51:00 | ... | 27 |
|
| ... | 14:52:00 | 14:52:00 | ... | 28 |
|
| ... | 14:54:00 | 14:54:00 | ... | 29 |
|
| ... | 14:55:00 | 14:55:00 | ... | 30 |
|
| ... | 14:56:00 | 14:56:00 | ... | 31 |
|
| ... | 14:57:00 | 14:57:00 | ... | 32 |
|
| ... | 14:58:00 | 14:58:00 | ... | 33 |
|
| ... | 14:59:00 | 14:59:00 | ... | 34 |
|
| ... | 15:00:00 | 15:00:00 | ... | 35 |
|
| ... | 15:02:00 | 15:02:00 | ... | 36 |
|
| ... | 15:03:00 | 15:03:00 | ... | 37 |
|
| ... | 15:04:00 | 15:04:00 | ... | 38 |
|
| ... | 15:06:00 | 15:06:00 | ... | 39 |
|
| ... | 15:08:00 | 15:08:00 | ... | 40 |
|
| ... | 15:09:00 | 15:09:00 | ... | 41 |
|
| ... | 15:10:00 | 15:10:00 | ... | 42 |
|
| ... | 15:13:00 | 15:13:00 | ... | 43 |
|
| ... | 15:14:00 | 15:14:00 | ... | 44 |
|
| ... | 15:15:00 | 15:15:00 | ... | 45 |
|
| ... | 15:16:00 | 15:16:00 | ... | 46 |
|
| ... | 15:17:00 | 15:17:00 | ... | 47 |
|
| ... | 15:19:00 | 15:19:00 | ... | 48 |
|
| ... | 15:19:00 | 15:19:00 | ... | 49 |
|
| ... | 15:20:00 | 15:20:00 | ... | 50 |
|
| ... | 15:22:00 | 15:22:00 | ... | 51 |
|
| ... | 15:22:00 | 15:22:00 | ... | 52 |
|
| ... | 15:23:00 | 15:23:00 | ... | 53 |
|
| ... | 15:26:00 | 15:26:00 | ... | 54 |
|
| ... | 15:28:00 | 15:28:00 | ... | 55 |
|
| ... | 15:29:00 | 15:29:00 | ... | 56 |
|
| ... | 15:30:00 | 15:30:00 | ... | 57 |
|
| ... | 15:31:00 | 15:31:00 | ... | 58 |
|
| ... | 15:31:00 | 15:31:00 | ... | 59 |
|
| ... | 15:32:00 | 15:32:00 | ... | 60 |
|
| ... | 15:33:00 | 15:33:00 | ... | 61 |
|
| ... | 15:33:00 | 15:33:00 | ... | 62 |
|
| ... | 15:35:00 | 15:35:00 | ... | 63 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 16/10/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| surdgjtm | Shepperton Station Approach | 51.3959458971 | -0.4471167837 | |
| surdgjwa | Manygate Lane | 51.3963639573 | -0.4413527295 | |
| surdgmdw | Russington Road | 51.396744654 | -0.4361792111 | |
| surdgmga | Swan Walk | 51.3889376823 | -0.4326941591 | |
| surdgmtg | Marshalls Roundabout | 51.3917664416 | -0.4350984621 | |
| surdgmtj | West Way | 51.3952709364 | -0.4355826131 | |
| surdjpmd | Manor Farm Avenue | 51.3966337002 | -0.4508453235 | |
| surdjtga | Tanglyn Avenue | 51.3985287697 | -0.4554389396 | |
| surdjtjm | The Bull | 51.4006153212 | -0.4609321924 | |
| surdjwag | Fairview Drive | 51.4013089003 | -0.4651355359 | |
| surdjwam | Ashurst Drive | 51.4024545818 | -0.4702296392 | |
| surdjwat | Abbey Drive | 51.4058155008 | -0.4845958028 | |
| surdjwda | All Saints Church | 51.4089899733 | -0.4901848078 | |
| surdjwjm | Waterworks | 51.4137615633 | -0.4934213432 | |
| surdjwjt | Wrabness Way | 51.4165665166 | -0.4954719063 | |
| surdjwmd | Sweeps Bridge | 51.4194927071 | -0.4978639075 | |
| surdjwpa | Wheatsheaf Lane | 51.4217359299 | -0.5009976952 | |
| surdjwpg | Carlyle Road | 51.4235089109 | -0.5032266157 | |
| surdjwpj | Park Avenue | 51.4262819494 | -0.5063148937 | |
| surdmdag | Edgell Road | 51.4281388616 | -0.5080811959 | |
| surdtagp | Elmsleigh Bus Station | 51.432553273 | -0.5094335576 | |
| suragadj | Hepworth Way | 51.3857507009 | -0.4210328211 | |
| suragadp | High Street | 51.385544984 | -0.4191141347 | |
| suragadw | Ashley C of E Primary School | 51.3835018908 | -0.4176468605 | |
| suragagm | Stompond Lane | 51.3811560583 | -0.4144082815 | |
| suragagt | Midway | 51.3782761042 | -0.4115764888 | |
| suragajg | Halfway Green | 51.3755675719 | -0.4107793993 | |
| suragajm | Walton Railway Station | 51.3736052344 | -0.4139507609 | |
| suragatp | Ashley Road | 51.3708797203 | -0.422550081 | |
| suragawa | Mayfield Road | 51.3706687687 | -0.4189081808 | |
| suragdad | Westcar Lane | 51.3675120737 | -0.4089177764 | |
| suragdaj | Brampton Gardens | 51.3675185672 | -0.4054266706 | |
| suragdap | The Green | 51.3659805112 | -0.4007826414 | |
| suragdgm | Thrupps Lane | 51.3672089551 | -0.3972346232 | |
| suragdgt | Barley Mow | 51.3683044362 | -0.3938347258 | |
| suragdja | Riverside Road | 51.3688268688 | -0.3873516571 | |
| suragdjg | Ramornie Close | 51.3691360774 | -0.3823844193 | |
| suragdjw | Princess Alice Hospice | 51.3675064771 | -0.3770402989 | |
| suragdmg | Council Offices | 51.3711986975 | -0.3625571473 | |
| suragdmj | High Street | 51.3698997593 | -0.3648446688 | |
| suragdmw | Sandown Park | 51.3736525569 | -0.3592655944 | |
| suragdpd | Littleworth Common | 51.3769224612 | -0.3532574873 | |
| suragdpj | Scilly Isles | 51.3791783811 | -0.3461498439 | |
| suragdpt | Couchmore Avenue | 51.3801178881 | -0.34327076 | |
| suragdta | Brooklands Road | 51.3825078057 | -0.3361428888 | |
| suragdtj | Giggshill Green | 51.384267813 | -0.3328024446 | |
| suragdwa | Angel Road | 51.3861233525 | -0.3304930258 | |
| suragdwg | Thorkhill Road | 51.3891657021 | -0.3256536913 | |
| suragdwt | Windmill Lane | 51.390562454 | -0.32271371 | |
| suragjaj | Prospect Road | 51.3914442246 | -0.320237988 | |
| surptmag | Woodside Avenue | 51.3690000082 | -0.4132048047 | |
| surgdwjm | Wolsey Road | 51.3703464772 | -0.3685066343 | |
| surgtgtg | Ashley Rise | 51.372512773 | -0.4216175532 | |
| Seething Wells Kingston Uni Campus | 51.393581786 | -0.3150425309 | ||
| Cromwell Road Bus Station | 51.4124277831 | -0.2987043361 | ||
| 55881 | East Lane (KT1) | 51.4065605606 | -0.3077359078 | |
| 48219 | Eden Street | 51.4102545226 | -0.302005973 | |
| 47985 | St James Road | 51.4088829889 | -0.3047887699 | |
| 74981 | Guildhall Rose Theatre | 51.4088423075 | -0.3063288145 | |
| St Raphael's Church | 51.4025702354 | -0.3078975713 | ||
| Cleaveland Road | 51.3970915856 | -0.310859772 | ||
| Uxbridge Road Surbiton | 51.3989141757 | -0.3094125617 | ||
| 47983 | Woodbines Avenue | 51.4042637208 | -0.3074756319 |