Kimpton - Welwyn Garden City
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:25:00 | 15:25:00 | ... | 1 |
|
| ... | 15:25:00 | 15:25:00 | ... | 2 |
|
| ... | 15:26:00 | 15:26:00 | ... | 3 |
|
| ... | 15:27:00 | 15:27:00 | ... | 4 |
|
| ... | 15:29:00 | 15:29:00 | ... | 5 |
|
| ... | 15:30:00 | 15:30:00 | ... | 6 |
|
| ... | 15:31:00 | 15:31:00 | ... | 7 |
|
| ... | 15:33:00 | 15:33:00 | ... | 8 |
|
| ... | 15:34:00 | 15:34:00 | ... | 9 |
|
| ... | 15:34:00 | 15:34:00 | ... | 10 |
|
| ... | 15:35:00 | 15:35:00 | ... | 11 |
|
| ... | 15:37:00 | 15:37:00 | ... | 12 |
|
| ... | 15:39:00 | 15:39:00 | ... | 13 |
|
| ... | 15:41:00 | 15:41:00 | ... | 14 |
|
| ... | 15:42:00 | 15:42:00 | ... | 15 |
|
| ... | 15:43:00 | 15:43:00 | ... | 16 |
|
| ... | 15:44:00 | 15:44:00 | ... | 17 |
|
| ... | 15:44:00 | 15:44:00 | ... | 18 |
|
| ... | 15:45:00 | 15:45:00 | ... | 19 |
|
| ... | 15:46:00 | 15:46:00 | ... | 20 |
|
| ... | 15:47:00 | 15:47:00 | ... | 21 |
|
| ... | 15:47:00 | 15:47:00 | ... | 22 |
|
| ... | 15:49:00 | 15:49:00 | ... | 23 |
|
| ... | 15:49:00 | 15:49:00 | ... | 24 |
|
| ... | 15:50:00 | 15:50:00 | ... | 25 |
|
| ... | 15:52:00 | 15:52:00 | ... | 26 |
|
| ... | 15:54:00 | 15:54:00 | ... | 27 |
|
| ... | 15:56:00 | 15:56:00 | ... | 28 |
|
| ... | 15:59:00 | 15:59:00 | ... | 29 |
|
| ... | 16:00:00 | 16:00:00 | ... | 30 |
|
| ... | 16:01:00 | 16:01:00 | ... | 31 |
|
| 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 | |
|---|---|---|---|---|
| hrtgmawp | Park Lane | 51.8513290256 | -0.2957792546 | |
| hrtgmdag | Hampden | 51.8519259583 | -0.2991252885 | |
| hrtgmatm | Rollswood Road | 51.8409345688 | -0.2246645674 | |
| hrtgmatp | Hollards Farm | 51.8430513764 | -0.2278911728 | |
| hrtgmatw | New Town | 51.8472163121 | -0.2321847331 | |
| hrtgmajp | Peace Memorial Hall | 51.8489097349 | -0.2347753394 | |
| hrtgmajw | Codicote Mill | 51.8477182303 | -0.2476998703 | |
| hrtgmamd | Mill | 51.8516409676 | -0.2617913726 | |
| hrtgmamj | The Bell Inn | 51.8505033788 | -0.2373119587 | |
| hrtgmagp | Tower Road | 51.8533613481 | -0.2390153246 | |
| hrtgjgaj | The White Horse PH | 51.8514162688 | -0.2924945293 | |
| hrtgtajp | Node Way Gardens | 51.8242338158 | -0.213799509 | |
| hrtjawtg | Campus West | 51.8050506266 | -0.208857491 | |
| hrtadagm | Bus Station | 51.8025017894 | -0.204462265 | |
| hrtamtjg | John Lewis | 51.8036907054 | -0.2063586173 | |
| hrtampwp | Pentley Park | 51.8078908967 | -0.2058292416 | |
| hrtamptg | Great Dell | 51.8122855075 | -0.2038993449 | |
| hrtamptj | Shoplands | 51.81497081 | -0.2042713393 | |
| hrtamptp | Oakdale | 51.8172077809 | -0.2088542245 | |
| hrtampgp | Monks Walk School | 51.8199237822 | -0.209471993 | |
| hrtampgt | Digswell Park Road | 51.8213341035 | -0.2023061374 | |
| hrtampja | Pumping Station | 51.8222068023 | -0.2017490242 | |
| hrtampma | Sherrardswood School | 51.8243503327 | -0.2037387448 | |
| hrtampda | Fire Station | 51.8271529271 | -0.2112170013 | |
| hrtampdg | The Crescent | 51.8247489967 | -0.2151576909 | |
| hrtampdj | St Mary's School | 51.827531539 | -0.214830017 | |
| hrtampdp | St Mary's Church | 51.8313396505 | -0.2145343035 | |
| hrtampga | The Vineyards | 51.8357023256 | -0.2187887176 | |
| hrtampgd | Reynards Road | 51.8394888301 | -0.2224134122 | |
| The Frythe | 51.8215585379 | -0.2217988355 | ||
| hrtamjgm | Church Place | 51.8326725586 | -0.2123045282 |