Guildford - Cobham - Esher - Kingston Upon Thames
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:50:00 | 12:50:00 | ... | 1 |
|
| ... | 12:50:00 | 12:50:00 | ... | 2 |
|
| ... | 12:52:00 | 12:52:00 | ... | 3 |
|
| ... | 12:53:00 | 12:53:00 | ... | 4 |
|
| ... | 12:54:00 | 12:54:00 | ... | 5 |
|
| ... | 12:55:00 | 12:55:00 | ... | 6 |
|
| ... | 12:55:00 | 12:55:00 | ... | 7 |
|
| ... | 12:57:00 | 12:57:00 | ... | 8 |
|
| ... | 12:58:00 | 12:58:00 | ... | 9 |
|
| ... | 13:00:00 | 13:00:00 | ... | 10 |
|
| ... | 13:05:00 | 13:05:00 | ... | 11 |
|
| ... | 13:05:00 | 13:05:00 | ... | 12 |
|
| ... | 13:06:00 | 13:06:00 | ... | 13 |
|
| ... | 13:07:00 | 13:07:00 | ... | 14 |
|
| ... | 13:08:00 | 13:08:00 | ... | 15 |
|
| ... | 13:09:00 | 13:09:00 | ... | 16 |
|
| ... | 13:10:00 | 13:10:00 | ... | 17 |
|
| ... | 13:11:00 | 13:11:00 | ... | 18 |
|
| ... | 13:13:00 | 13:13:00 | ... | 19 |
|
| ... | 13:18:00 | 13:18:00 | ... | 20 |
|
| ... | 13:20:00 | 13:20:00 | ... | 21 |
|
| ... | 13:21:00 | 13:21:00 | ... | 22 |
|
| ... | 13:22:00 | 13:22:00 | ... | 23 |
|
| ... | 13:22:00 | 13:22:00 | ... | 24 |
|
| ... | 13:23:00 | 13:23:00 | ... | 25 |
|
| ... | 13:23:00 | 13:23:00 | ... | 26 |
|
| ... | 13:23:00 | 13:23:00 | ... | 27 |
|
| ... | 13:24:00 | 13:24:00 | ... | 28 |
|
| ... | 13:25:00 | 13:25:00 | ... | 29 |
|
| ... | 13:25:00 | 13:25:00 | ... | 30 |
|
| ... | 13:27:00 | 13:27:00 | ... | 31 |
|
| ... | 13:28:00 | 13:28:00 | ... | 32 |
|
| ... | 13:28:00 | 13:28:00 | ... | 33 |
|
| ... | 13:29:00 | 13:29:00 | ... | 34 |
|
| ... | 13:30:00 | 13:30:00 | ... | 35 |
|
| ... | 13:31:00 | 13:31:00 | ... | 36 |
|
| ... | 13:31:00 | 13:31:00 | ... | 37 |
|
| ... | 13:32:00 | 13:32:00 | ... | 38 |
|
| ... | 13:33:00 | 13:33:00 | ... | 39 |
|
| ... | 13:33:00 | 13:33:00 | ... | 40 |
|
| ... | 13:34:00 | 13:34:00 | ... | 41 |
|
| ... | 13:35:00 | 13:35:00 | ... | 42 |
|
| ... | 13:35:00 | 13:35:00 | ... | 43 |
|
| ... | 13:35:00 | 13:35:00 | ... | 44 |
|
| ... | 13:36:00 | 13:36:00 | ... | 45 |
|
| ... | 13:36:00 | 13:36:00 | ... | 46 |
|
| ... | 13:37:00 | 13:37:00 | ... | 47 |
|
| ... | 13:37:00 | 13:37:00 | ... | 48 |
|
| ... | 13:38:00 | 13:38:00 | ... | 49 |
|
| ... | 13:38:00 | 13:38:00 | ... | 50 |
|
| ... | 13:39:00 | 13:39:00 | ... | 51 |
|
| ... | 13:40:00 | 13:40:00 | ... | 52 |
|
| ... | 13:40:00 | 13:40:00 | ... | 53 |
|
| ... | 13:41:00 | 13:41:00 | ... | 54 |
|
| ... | 13:42:00 | 13:42:00 | ... | 55 |
|
| ... | 13:43:00 | 13:43:00 | ... | 56 |
|
| ... | 13:44:00 | 13:44:00 | ... | 57 |
|
| ... | 13:45:00 | 13:45:00 | ... | 58 |
|
| ... | 13:46:00 | 13:46:00 | ... | 59 |
|
| ... | 13:47:00 | 13:47:00 | ... | 60 |
|
| ... | 13:48:00 | 13:48:00 | ... | 61 |
|
| ... | 13:48:00 | 13:48:00 | ... | 62 |
|
| ... | 13:49:00 | 13:49:00 | ... | 63 |
|
| ... | 13:50:00 | 13:50:00 | ... | 64 |
|
| ... | 13:51:00 | 13:51:00 | ... | 65 |
|
| ... | 13:52:00 | 13:52:00 | ... | 66 |
|
| ... | 13:53:00 | 13:53:00 | ... | 67 |
|
| ... | 13:54:00 | 13:54:00 | ... | 68 |
|
| ... | 13:56:00 | 13:56:00 | ... | 69 |
|
| ... | 13:59:00 | 13:59:00 | ... | 70 |
|
| 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 | |
|---|---|---|---|---|
| suradtat | Painshill Roundabout | 51.3341175412 | -0.4305016322 | |
| suradtgj | Waitrose | 51.3293891822 | -0.4119456873 | |
| suradtgm | Between Streets | 51.3307009052 | -0.4165080835 | |
| suradtgt | Free School | 51.3329665989 | -0.4158127699 | |
| suradwam | Community Hospital | 51.3355589814 | -0.4087034507 | |
| suradwat | Icklingham Road | 51.338480791 | -0.4033620919 | |
| suradwdj | Fairmile Lane | 51.3427040705 | -0.3952322906 | |
| surgpdpd | Waterford Close | 51.3438140884 | -0.3928961831 | |
| suradwdt | Blackhills | 51.3513627353 | -0.3853368402 | |
| suradwdw | Claremont Avenue | 51.3589155869 | -0.3787658831 | |
| suradwgj | Moore Place | 51.36618643 | -0.3694014754 | |
| suragdwd | Thorkhill Road | 51.3892841855 | -0.3257643482 | |
| suragdwp | Windmill Lane | 51.3907248509 | -0.3227508911 | |
| suragjag | Prospect Road | 51.3917074728 | -0.3197827693 | |
| suragpat | Esher Railway Station | 51.3812376616 | -0.3544534183 | |
| suragpaw | Woodend | 51.3803137115 | -0.3578203583 | |
| suragpdw | Lower Green | 51.378615863 | -0.3695346265 | |
| suragpgm | Esher High School | 51.3752825045 | -0.369092689 | |
| surgdwgt | Esher Green | 51.3710221334 | -0.3666580202 | |
| suragpgt | Church Street | 51.3697825678 | -0.3661130987 | |
| suragtjp | West End Lane | 51.3564326047 | -0.3819414387 | |
| suragtmj | Old Chestnut Avenue | 51.3634776276 | -0.3718391004 | |
| suragtpa | Carleton Close | 51.3829184053 | -0.3543931394 | |
| suragtpg | The Drive | 51.3855609454 | -0.3549450717 | |
| suragtpm | Imber Grove | 51.3871299106 | -0.3539690025 | |
| suragtpw | Elm Tree Avenue | 51.3881069517 | -0.3499097003 | |
| suragtwd | Imber Court | 51.3898463563 | -0.3495452997 | |
| suragwgp | College Drive | 51.3905064025 | -0.3434273722 | |
| suragwgw | Thames Ditton Railway Station | 51.3898640061 | -0.3399723381 | |
| suragwjg | Queen's Road | 51.3957497023 | -0.3377612142 | |
| suragwjp | Riversdale Road | 51.3940051054 | -0.3345902557 | |
| suragwjw | High Street | 51.3913440871 | -0.3321140479 | |
| suragwmd | St Leonard's Road | 51.3893435848 | -0.3286654712 | |
| suragwpw | Ember Gardens | 51.3908576967 | -0.3479278613 | |
| suragwtg | Farm Road | 51.3800581407 | -0.3697851444 | |
| suragwtw | Fire Station | 51.333068043 | -0.4206612543 | |
| surajada | Oakdene Road | 51.3307603019 | -0.4115968813 | |
| surajamw | Arran Way | 51.3799235749 | -0.3646455682 | |
| surajdpw | Speer Road | 51.3931899502 | -0.3392482571 | |
| surajdtd | Mill Road | 51.3792484207 | -0.3697564325 | |
| surajdtj | Douglas Road | 51.3800551125 | -0.363117686 | |
| surajdtm | Cranbrook Drive | 51.3804047512 | -0.3617544457 | |
| surajdtp | The Woodlands | 51.3804364577 | -0.358879337 | |
| surgtjma | Anyards Road | 51.3341460737 | -0.4125995934 | |
| surapjtj | Wisley Gardens | 51.3119363893 | -0.466727621 | |
| surapjtp | Ockham Park Turn | 51.305468295 | -0.4796396227 | |
| surapjwa | Post Office | 51.3003815167 | -0.4923879535 | |
| surapjwj | Georgelands | 51.2979968352 | -0.4964536769 | |
| surapjwt | Grove Heath Road | 51.291284041 | -0.5024239968 | |
| surapmpd | Send Marsh Road | 51.2876610024 | -0.5046069019 | |
| surapmpg | Burntcommon Lane | 51.2842406657 | -0.5092923147 | |
| surapmtw | Burpham Shops | 51.2593916882 | -0.5448079023 | |
| surapmwj | Highclere | 51.2551828477 | -0.5491252808 | |
| surapmwt | Ganghill | 51.2511712019 | -0.5526762233 | |
| suraptag | Elgin Gardens | 51.2476264653 | -0.5547217923 | |
| suraptam | Avonmore Avenue | 51.2468486913 | -0.5558207637 | |
| suraptat | Ennismore Avenue | 51.2434385429 | -0.5615006997 | |
| suraptda | London Road Railway Station | 51.2411203657 | -0.5638508577 | |
| suraptdj | G Live | 51.2381429558 | -0.5659777407 | |
| suratatj | Library | 51.2369903947 | -0.5724740669 | |
| suratjda | Boughton Hall Avenue | 51.2822987333 | -0.5135708427 | |
| suratjwa | Grove Heath North | 51.2951097467 | -0.5013242064 | |
| surawjta | Friary Bus Station | 51.2372363925 | -0.5756895544 | |
| Seething Wells Kingston Uni Campus | 51.3934058475 | -0.3159401839 | ||
| 54469 | Cromwell Road Bus Station | 51.4123625747 | -0.2985485767 | |
| 54370 | East Lane (KT1) | 51.4063525327 | -0.3082755766 | |
| 56052 | Eden Street | 51.4104574559 | -0.3023579401 | |
| St Raphael's Church | 51.4032284114 | -0.3080170511 | ||
| St Leonard's Road | 51.3967031663 | -0.3113628312 | ||
| Uxbridge Road Surbiton | 51.399307769 | -0.3092686675 |