Ashford - Shepperton - Sunbury
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:40:00 | 09:40:00 | ... | 1 |
|
| ... | 09:40:00 | 09:40:00 | ... | 2 |
|
| ... | 09:40:00 | 09:40:00 | ... | 3 |
|
| ... | 09:43:00 | 09:43:00 | ... | 4 |
|
| ... | 09:45:00 | 09:45:00 | ... | 5 |
|
| ... | 09:45:00 | 09:45:00 | ... | 6 |
|
| ... | 09:45:00 | 09:45:00 | ... | 7 |
|
| ... | 09:47:00 | 09:47:00 | ... | 8 |
|
| ... | 09:50:00 | 09:50:00 | ... | 9 |
|
| ... | 09:51:00 | 09:51:00 | ... | 10 |
|
| ... | 09:53:00 | 09:53:00 | ... | 11 |
|
| ... | 09:54:00 | 09:54:00 | ... | 12 |
|
| ... | 09:54:00 | 09:54:00 | ... | 13 |
|
| ... | 09:54:00 | 09:54:00 | ... | 14 |
|
| ... | 09:55:00 | 09:55:00 | ... | 15 |
|
| ... | 09:56:00 | 09:56:00 | ... | 16 |
|
| ... | 10:01:00 | 10:01:00 | ... | 17 |
|
| ... | 10:01:00 | 10:01:00 | ... | 18 |
|
| ... | 10:01:00 | 10:01:00 | ... | 19 |
|
| ... | 10:01:00 | 10:01:00 | ... | 20 |
|
| ... | 10:02:00 | 10:02:00 | ... | 21 |
|
| ... | 10:03:00 | 10:03:00 | ... | 22 |
|
| ... | 10:04:00 | 10:04:00 | ... | 23 |
|
| ... | 10:05:00 | 10:05:00 | ... | 24 |
|
| ... | 10:05:00 | 10:05:00 | ... | 25 |
|
| ... | 10:06:00 | 10:06:00 | ... | 26 |
|
| ... | 10:07:00 | 10:07:00 | ... | 27 |
|
| ... | 10:08:00 | 10:08:00 | ... | 28 |
|
| ... | 10:10:00 | 10:10:00 | ... | 29 |
|
| ... | 10:12:00 | 10:12:00 | ... | 30 |
|
| 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 | |
|---|---|---|---|---|
| surdjpgm | Windmill Road | 51.4205580757 | -0.4289089512 | |
| surdjpgp | Napier Road | 51.4215407985 | -0.4364980679 | |
| surdjtwp | Fairview Drive | 51.4011782555 | -0.4634003856 | |
| surdjwap | Ashurst Drive | 51.4022620548 | -0.4692584566 | |
| surdjwaw | Abbey Drive | 51.4060703365 | -0.4848318009 | |
| surdjwga | All Saints Church | 51.4093628603 | -0.4898130576 | |
| surdmdpa | Magdalene Road | 51.4059154481 | -0.4625802421 | |
| surgpgwg | New Road | 51.4076107845 | -0.4554205305 | |
| surdmdta | Village Stores | 51.4123303503 | -0.4437576955 | |
| surdmgdm | Ashford Road | 51.4163404736 | -0.4430462833 | |
| surdmgdw | Thorne Close | 51.4203723858 | -0.4426216438 | |
| surdmgtm | Littleton Road | 51.4215471813 | -0.4417043721 | |
| surdpmjm | Woodthorpe Road | 51.4266183313 | -0.4814049302 | |
| surdtwtm | The Harrow | 51.4099557058 | -0.4443847188 | |
| surdwpja | Tesco | 51.4177176116 | -0.4256410705 | |
| surdwpjm | Edinburgh Drive | 51.4245815766 | -0.4831409322 | |
| surdwpjp | Charles Road | 51.4240298997 | -0.4808147069 | |
| surdwtad | Boundary Road End | 51.4301344171 | -0.4862800617 | |
| surdwtag | Boundary Road | 51.4301058539 | -0.4854610448 | |
| surdwtaj | Brookside Avenue | 51.430156508 | -0.4845099406 | |
| surdwtat | Charles Road 1a | 51.4230814092 | -0.4777106447 | |
| surdwtaw | Gravel Pits | 51.4172313856 | -0.4821762052 | |
| surdwtwa | Watersplash Road | 51.4025879976 | -0.4584506964 | |
| surdwtwd | Stewart Avenue | 51.4047953287 | -0.4594547828 | |
| surdwtwg | Stewart Avenue End | 51.4044886216 | -0.4614347745 | |
| surdwtwj | Ash Road | 51.4042666172 | -0.4623336108 | |
| surdwtwm | Rosewood Drive | 51.3993804918 | -0.4648263149 | |
| surdwtwp | Rosewood Drive Top | 51.4006940133 | -0.4635028691 | |
| surgadad | Bush Road | 51.3993749815 | -0.4637195734 | |
| surgadag | Rosewood Drive Top | 51.4008206042 | -0.4635561318 |