Hounslow - Ashford Hospital
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:50:00 | 15:50:00 | ... | 1 |
|
| ... | 15:52:00 | 15:52:00 | ... | 2 |
|
| ... | 15:53:00 | 15:53:00 | ... | 3 |
|
| ... | 15:54:00 | 15:54:00 | ... | 4 |
|
| ... | 15:57:00 | 15:57:00 | ... | 5 |
|
| ... | 15:58:00 | 15:58:00 | ... | 6 |
|
| ... | 16:00:00 | 16:00:00 | ... | 7 |
|
| ... | 16:01:00 | 16:01:00 | ... | 8 |
|
| ... | 16:03:00 | 16:03:00 | ... | 9 |
|
| ... | 16:03:00 | 16:03:00 | ... | 10 |
|
| ... | 16:04:00 | 16:04:00 | ... | 11 |
|
| ... | 16:06:00 | 16:06:00 | ... | 12 |
|
| ... | 16:07:00 | 16:07:00 | ... | 13 |
|
| ... | 16:08:00 | 16:08:00 | ... | 14 |
|
| ... | 16:08:00 | 16:08:00 | ... | 15 |
|
| ... | 16:09:00 | 16:09:00 | ... | 16 |
|
| ... | 16:10:00 | 16:10:00 | ... | 17 |
|
| ... | 16:10:00 | 16:10:00 | ... | 18 |
|
| ... | 16:11:00 | 16:11:00 | ... | 19 |
|
| ... | 16:12:00 | 16:12:00 | ... | 20 |
|
| ... | 16:13:00 | 16:13:00 | ... | 21 |
|
| ... | 16:14:00 | 16:14:00 | ... | 22 |
|
| ... | 16:15:00 | 16:15:00 | ... | 23 |
|
| ... | 16:16:00 | 16:16:00 | ... | 24 |
|
| ... | 16:17:00 | 16:17:00 | ... | 25 |
|
| ... | 16:18:00 | 16:18:00 | ... | 26 |
|
| ... | 16:20:00 | 16:20:00 | ... | 27 |
|
| 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 | |
|---|---|---|---|---|
| surdatpa | Ashford Hospital Entrance | 51.4440869402 | -0.4749114266 | |
| surdatwd | Short Lane | 51.4452418208 | -0.4628140857 | |
| surdatwm | Long Lane | 51.4441133993 | -0.4679747096 | |
| 74313 | Bedfont Green | 51.4513547931 | -0.438185556 | |
| 74402 | Bedfont Lane | 51.4542491705 | -0.4259967081 | |
| 50153 | Bedfont Library | 51.451883995 | -0.4347133708 | |
| 47532 | Bethany Waye | 51.4536273851 | -0.4285800037 | |
| 75931 | Cassiobury Avenue | 51.4550556719 | -0.4224426324 | |
| 58944 | Clockhouse Roundabout | 51.4482107947 | -0.4492731836 | |
| 76222 | Spinney Drive | 51.449813788 | -0.4446999373 | |
| 52242 | Engleheart Drive | 51.455846479 | -0.4183995939 | |
| 47212 | Green Lane | 51.4601345198 | -0.3964575929 | |
| 50932 | Faggs Road | 51.4575455144 | -0.4090567325 | |
| 50949 | Harrow Road (TW14) | 51.4465168527 | -0.4578785121 | |
| 75878 | Hibernia Road Hounslow | 51.4663650082 | -0.3728731368 | |
| 57391 | Barrack Road | 51.4621582595 | -0.3892752891 | |
| 50124 | Douglas Road (TW3) | 51.4687680993 | -0.3620470297 | |
| 48532 | Fair Street | 51.4692714288 | -0.3600997018 | |
| 71781 | Hounslow Road | 51.4583602752 | -0.4048252751 | |
| 54388 | Islay Gardens | 51.4615250386 | -0.392277409 | |
| 76236 | Staines Road Martindale Road | 51.4640046559 | -0.3836102036 | |
| 76041 | New Road (TW14) | 51.4529541153 | -0.431352096 | |
| 75976 | Shaftesbury Avenue | 51.456592594 | -0.4143867496 | |
| 59521 | Treaty Centre | 51.4669137493 | -0.3638410746 | |
| 72409 | Wellington Road South | 51.4648592123 | -0.3797217838 | |
| 48427 | School Road (TW3) | 51.4701832692 | -0.3558627694 | |
| 72427 | The Bell | 51.4671868359 | -0.3685967547 |