Kimpton - Welwyn Garden City
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:15:00 | 07:15:00 | ... | 1 |
|
| ... | 07:15:00 | 07:15:00 | ... | 2 |
|
| ... | 07:16:00 | 07:16:00 | ... | 3 |
|
| ... | 07:17:00 | 07:17:00 | ... | 4 |
|
| ... | 07:18:00 | 07:18:00 | ... | 5 |
|
| ... | 07:19:00 | 07:19:00 | ... | 6 |
|
| ... | 07:21:00 | 07:21:00 | ... | 7 |
|
| ... | 07:22:00 | 07:22:00 | ... | 8 |
|
| ... | 07:22:00 | 07:22:00 | ... | 9 |
|
| ... | 07:23:00 | 07:23:00 | ... | 10 |
|
| ... | 07:23:00 | 07:23:00 | ... | 11 |
|
| ... | 07:25:00 | 07:25:00 | ... | 12 |
|
| ... | 07:26:00 | 07:26:00 | ... | 13 |
|
| ... | 07:26:00 | 07:26:00 | ... | 14 |
|
| ... | 07:27:00 | 07:27:00 | ... | 15 |
|
| ... | 07:28:00 | 07:28:00 | ... | 16 |
|
| ... | 07:28:00 | 07:28:00 | ... | 17 |
|
| ... | 07:29:00 | 07:29:00 | ... | 18 |
|
| ... | 07:30:00 | 07:30:00 | ... | 19 |
|
| ... | 07:30:00 | 07:30:00 | ... | 20 |
|
| ... | 07:31:00 | 07:31:00 | ... | 21 |
|
| ... | 07:32:00 | 07:32:00 | ... | 22 |
|
| ... | 07:32:00 | 07:32:00 | ... | 23 |
|
| ... | 07:33:00 | 07:33:00 | ... | 24 |
|
| ... | 07:34:00 | 07:34:00 | ... | 25 |
|
| ... | 07:36:00 | 07:36:00 | ... | 26 |
|
| ... | 07:40:00 | 07:40:00 | ... | 27 |
|
| ... | 07:40:00 | 07:40:00 | ... | 28 |
|
| ... | 07:41:00 | 07:41:00 | ... | 29 |
|
| 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 | |
| hrtgmajt | Hill Road | 51.8491455626 | -0.2403123595 | |
| hrtgmajw | Codicote Mill | 51.8477182303 | -0.2476998703 | |
| hrtgmamd | Mill | 51.8516409676 | -0.2617913726 | |
| 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 | |
| hrtamjgm | Church Place | 51.8326725586 | -0.2123045282 |