Guildford - Cobham - Esher - Kingston Upon Thames
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:15:00 | 14:15:00 | ... | 1 |
|
| ... | 14:18:00 | 14:18:00 | ... | 2 |
|
| ... | 14:18:00 | 14:18:00 | ... | 3 |
|
| ... | 14:19:00 | 14:19:00 | ... | 4 |
|
| ... | 14:19:00 | 14:19:00 | ... | 5 |
|
| ... | 14:19:00 | 14:19:00 | ... | 6 |
|
| ... | 14:20:00 | 14:20:00 | ... | 7 |
|
| ... | 14:21:00 | 14:21:00 | ... | 8 |
|
| ... | 14:22:00 | 14:22:00 | ... | 9 |
|
| ... | 14:23:00 | 14:23:00 | ... | 10 |
|
| ... | 14:24:00 | 14:24:00 | ... | 11 |
|
| ... | 14:25:00 | 14:25:00 | ... | 12 |
|
| ... | 14:26:00 | 14:26:00 | ... | 13 |
|
| ... | 14:27:00 | 14:27:00 | ... | 14 |
|
| ... | 14:27:00 | 14:27:00 | ... | 15 |
|
| ... | 14:29:00 | 14:29:00 | ... | 16 |
|
| ... | 14:30:00 | 14:30:00 | ... | 17 |
|
| ... | 14:31:00 | 14:31:00 | ... | 18 |
|
| ... | 14:32:00 | 14:32:00 | ... | 19 |
|
| ... | 14:34:00 | 14:34:00 | ... | 20 |
|
| ... | 14:34:00 | 14:34:00 | ... | 21 |
|
| ... | 14:35:00 | 14:35:00 | ... | 22 |
|
| ... | 14:35:00 | 14:35:00 | ... | 23 |
|
| ... | 14:36:00 | 14:36:00 | ... | 24 |
|
| ... | 14:37:00 | 14:37:00 | ... | 25 |
|
| ... | 14:37:00 | 14:37:00 | ... | 26 |
|
| ... | 14:38:00 | 14:38:00 | ... | 27 |
|
| ... | 14:39:00 | 14:39:00 | ... | 28 |
|
| ... | 14:39:00 | 14:39:00 | ... | 29 |
|
| ... | 14:39:00 | 14:39:00 | ... | 30 |
|
| ... | 14:40:00 | 14:40:00 | ... | 31 |
|
| ... | 14:40:00 | 14:40:00 | ... | 32 |
|
| ... | 14:41:00 | 14:41:00 | ... | 33 |
|
| ... | 14:41:00 | 14:41:00 | ... | 34 |
|
| ... | 14:41:00 | 14:41:00 | ... | 35 |
|
| ... | 14:42:00 | 14:42:00 | ... | 36 |
|
| ... | 14:44:00 | 14:44:00 | ... | 37 |
|
| ... | 14:45:00 | 14:45:00 | ... | 38 |
|
| ... | 14:46:00 | 14:46:00 | ... | 39 |
|
| ... | 14:46:00 | 14:46:00 | ... | 40 |
|
| ... | 14:47:00 | 14:47:00 | ... | 41 |
|
| ... | 14:48:00 | 14:48:00 | ... | 42 |
|
| ... | 14:49:00 | 14:49:00 | ... | 43 |
|
| ... | 14:50:00 | 14:50:00 | ... | 44 |
|
| ... | 14:52:00 | 14:52:00 | ... | 45 |
|
| ... | 14:53:00 | 14:53:00 | ... | 46 |
|
| ... | 14:54:00 | 14:54:00 | ... | 47 |
|
| ... | 14:55:00 | 14:55:00 | ... | 48 |
|
| ... | 14:56:00 | 14:56:00 | ... | 49 |
|
| ... | 14:58:00 | 14:58:00 | ... | 50 |
|
| ... | 14:59:00 | 14:59:00 | ... | 51 |
|
| ... | 14:59:00 | 14:59:00 | ... | 52 |
|
| ... | 14:59:00 | 14:59:00 | ... | 53 |
|
| ... | 15:00:00 | 15:00:00 | ... | 54 |
|
| ... | 15:06:00 | 15:06:00 | ... | 55 |
|
| ... | 15:07:00 | 15:07:00 | ... | 56 |
|
| ... | 15:10:00 | 15:10:00 | ... | 57 |
|
| ... | 15:10:00 | 15:10:00 | ... | 58 |
|
| ... | 15:11:00 | 15:11:00 | ... | 59 |
|
| ... | 15:12:00 | 15:12:00 | ... | 60 |
|
| ... | 15:13:00 | 15:13:00 | ... | 61 |
|
| ... | 15:13:00 | 15:13:00 | ... | 62 |
|
| ... | 15:15:00 | 15:15:00 | ... | 63 |
|
| ... | 15:20:00 | 15:20:00 | ... | 64 |
|
| ... | 15:21:00 | 15:21:00 | ... | 65 |
|
| ... | 15:21:00 | 15:21:00 | ... | 66 |
|
| ... | 15:23:00 | 15:23:00 | ... | 67 |
|
| ... | 15:24:00 | 15:24:00 | ... | 68 |
|
| ... | 15:25:00 | 15:25:00 | ... | 69 |
|
| ... | 15:25:00 | 15:25:00 | ... | 70 |
|
| ... | 15:27:00 | 15:27:00 | ... | 71 |
|
| ... | 15:27:00 | 15:27:00 | ... | 72 |
|
| ... | 15:29:00 | 15:29:00 | ... | 73 |
|
| ... | 15:30:00 | 15:30:00 | ... | 74 |
|
| 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 | |
|---|---|---|---|---|
| suradtaw | Painshill Roundabout | 51.3338221694 | -0.4292628164 | |
| suradtgj | Waitrose | 51.3293891822 | -0.4119456873 | |
| suradtgm | Between Streets | 51.3307009052 | -0.4165080835 | |
| suradtgp | Free School | 51.3333933461 | -0.413458184 | |
| suradwag | Community Hospital | 51.3353555654 | -0.4089545404 | |
| suradwap | Icklingham Road | 51.3379149314 | -0.4040708635 | |
| suradwaw | Fairmile Lane | 51.3416221036 | -0.3969929987 | |
| suradwdm | Waterford Close | 51.3433885624 | -0.3933418138 | |
| suradwdp | Blackhills | 51.351662989 | -0.3849385432 | |
| suradwga | Claremont Avenue | 51.3588137378 | -0.3785540326 | |
| suradwgd | Moore Place | 51.3666180488 | -0.3687540613 | |
| suragdmj | High Street | 51.3698997593 | -0.3648446688 | |
| suragdwg | Thorkhill Road | 51.3891657021 | -0.3256536913 | |
| suragdwt | Windmill Lane | 51.390562454 | -0.32271371 | |
| suragjaj | Prospect Road | 51.3914442246 | -0.320237988 | |
| suragpap | Esher Railway Station | 51.3809806419 | -0.3547212968 | |
| suragpda | Woodend | 51.3802537442 | -0.3573914095 | |
| suragpdm | Lower Green | 51.3785936897 | -0.3692336592 | |
| suragpga | Esher High School | 51.3739456703 | -0.3680195014 | |
| suragpgp | Esher Green | 51.3709102733 | -0.3663746628 | |
| suragtgw | West End Lane | 51.3562248871 | -0.3818769456 | |
| suragtjt | Old Chestnut Avenue | 51.3617249324 | -0.3731940098 | |
| suragtmw | Carleton Close | 51.3831216983 | -0.3541415455 | |
| suragtpd | The Drive | 51.3851778053 | -0.3545564114 | |
| suragtpj | Imber Grove | 51.3870111568 | -0.353197178 | |
| suragtpt | Elm Tree Avenue | 51.387520715 | -0.3497870661 | |
| suragtwa | Imber Court | 51.390192635 | -0.3492310081 | |
| suragwgm | College Drive | 51.3904826329 | -0.3442906141 | |
| suragwgt | Thames Ditton Railway Station | 51.3897781973 | -0.3402629003 | |
| suragwjm | Queen's Road | 51.395084214 | -0.3371241073 | |
| suragwjt | Riversdale Road | 51.3936206738 | -0.3341154973 | |
| suragwma | High Street | 51.3916862376 | -0.3321447265 | |
| suragwmg | St Leonard's Road | 51.3892974425 | -0.3292133154 | |
| suragwpt | Ember Gardens | 51.3907318662 | -0.3479323934 | |
| surgpgaj | Farm Road | 51.379893359 | -0.369575453 | |
| suragwtp | Fire Station | 51.3328264137 | -0.4200810058 | |
| surajada | Oakdene Road | 51.3307603019 | -0.4115968813 | |
| surajamt | Arran Way | 51.3797638935 | -0.3673814951 | |
| surajdta | Speer Road | 51.3931777044 | -0.3390187179 | |
| surajdtw | The Woodlands | 51.3804398772 | -0.3591235028 | |
| surajdwa | Cranbrook Drive | 51.3802237869 | -0.3616746876 | |
| surajdwd | Douglas Road | 51.3799983755 | -0.3629185336 | |
| surajdwj | Mill Road | 51.3792538116 | -0.36949759 | |
| surapjtm | Wisley Gardens | 51.3112407281 | -0.4671669022 | |
| surapjtw | Ockham Park Turn | 51.3066864432 | -0.4765004947 | |
| surapjwd | Post Office | 51.3001226915 | -0.4925398782 | |
| surapjwm | Georgelands | 51.2973869225 | -0.4972768496 | |
| surapmad | Grove Heath Road | 51.2907858113 | -0.5021390296 | |
| surapmpa | Send Marsh Road | 51.2868272255 | -0.5055087468 | |
| surapmpj | Burntcommon Lane | 51.2846525498 | -0.508447276 | |
| surapmtd | Great Oaks Park | 51.2624040602 | -0.5411869251 | |
| surapmwa | Burpham Shops | 51.2578497746 | -0.5459171023 | |
| surapmwm | Woodruff Avenue | 51.2560384352 | -0.5477799198 | |
| suraptad | Ganghill | 51.2519152925 | -0.5517644355 | |
| suraptaj | Elgin Gardens | 51.2481215355 | -0.5540328441 | |
| suraptap | Avonmore Avenue | 51.2458220393 | -0.5571567276 | |
| suraptaw | Ennismore Avenue | 51.2436757898 | -0.561049165 | |
| suraptdg | London Road Railway Station | 51.2401883167 | -0.5641090935 | |
| suraptdm | G Live | 51.2379979029 | -0.5658819744 | |
| suratatg | Library | 51.2369213579 | -0.5719748356 | |
| suratjaw | Burntcommon Cottages | 51.2811559561 | -0.5128047642 | |
| suratjwg | Grove Heath North | 51.2957149149 | -0.5001283606 | |
| surawjta | Friary Bus Station | 51.2372363925 | -0.5756895544 | |
| Rose Theatre | 51.408200533 | -0.3073446556 | ||
| Seething Wells Kingston Uni Campus | 51.393581786 | -0.3150425309 | ||
| 54469 | Cromwell Road Bus Station | 51.4123625747 | -0.2985485767 | |
| 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 |