Welwyn Garden City - Hertford
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:40:00 | 15:40:00 | ... | 1 |
|
| ... | 15:53:00 | 15:53:00 | ... | 2 |
|
| ... | 15:55:00 | 15:55:00 | ... | 3 |
|
| ... | 15:56:00 | 15:56:00 | ... | 4 |
|
| ... | 15:57:00 | 15:57:00 | ... | 5 |
|
| ... | 15:57:00 | 15:57:00 | ... | 6 |
|
| ... | 15:59:00 | 15:59:00 | ... | 7 |
|
| ... | 16:00:00 | 16:00:00 | ... | 8 |
|
| ... | 16:01:00 | 16:01:00 | ... | 9 |
|
| ... | 16:02:00 | 16:02:00 | ... | 10 |
|
| ... | 16:02:00 | 16:02:00 | ... | 11 |
|
| ... | 16:04:00 | 16:04:00 | ... | 12 |
|
| ... | 16:04:00 | 16:04:00 | ... | 13 |
|
| ... | 16:07:00 | 16:07:00 | ... | 14 |
|
| ... | 16:08:00 | 16:08:00 | ... | 15 |
|
| ... | 16:09:00 | 16:09:00 | ... | 16 |
|
| ... | 16:09:00 | 16:09:00 | ... | 17 |
|
| ... | 16:11:00 | 16:11:00 | ... | 18 |
|
| ... | 16:12:00 | 16:12:00 | ... | 19 |
|
| ... | 16:13:00 | 16:13:00 | ... | 20 |
|
| ... | 16:14:00 | 16:14:00 | ... | 21 |
|
| ... | 16:14:00 | 16:14:00 | ... | 22 |
|
| ... | 16:15:00 | 16:15:00 | ... | 23 |
|
| ... | 16:16:00 | 16:16:00 | ... | 24 |
|
| ... | 16:19:00 | 16:19:00 | ... | 25 |
|
| ... | 16:20:00 | 16:20:00 | ... | 26 |
|
| ... | 16:21:00 | 16:21:00 | ... | 27 |
|
| ... | 16:22:00 | 16:22:00 | ... | 28 |
|
| ... | 16:24:00 | 16:24:00 | ... | 29 |
|
| ... | 16:25:00 | 16:25:00 | ... | 30 |
|
| ... | 16:26:00 | 16:26:00 | ... | 31 |
|
| ... | 16:27:00 | 16:27:00 | ... | 32 |
|
| ... | 16:28:00 | 16:28:00 | ... | 33 |
|
| ... | 16:30:00 | 16:30:00 | ... | 34 |
|
| ... | 16:31:00 | 16:31:00 | ... | 35 |
|
| ... | 16:33:00 | 16:33:00 | ... | 36 |
|
| ... | 16:34:00 | 16:34:00 | ... | 37 |
|
| ... | 16:35:00 | 16:35:00 | ... | 38 |
|
| ... | 16:36:00 | 16:36:00 | ... | 39 |
|
| ... | 16:37:00 | 16:37:00 | ... | 40 |
|
| ... | 16:38:00 | 16:38:00 | ... | 41 |
|
| ... | 16:40:00 | 16:40:00 | ... | 42 |
|
| ... | 16:40:00 | 16:40:00 | ... | 43 |
|
| ... | 16:41:00 | 16:41:00 | ... | 44 |
|
| ... | 16:41:00 | 16:41:00 | ... | 45 |
|
| ... | 16:45:00 | 16:45:00 | ... | 46 |
|
| ... | 16:46:00 | 16:46:00 | ... | 47 |
|
| ... | 16:47:00 | 16:47:00 | ... | 48 |
|
| ... | 16:49:00 | 16:49:00 | ... | 49 |
|
| ... | 16:50:00 | 16:50:00 | ... | 50 |
|
| ... | 16:50:00 | 16:50:00 | ... | 51 |
|
| ... | 16:52:00 | 16:52:00 | ... | 52 |
|
| ... | 16:52:00 | 16:52:00 | ... | 53 |
|
| ... | 16:52:00 | 16:52:00 | ... | 54 |
|
| ... | 16:54:00 | 16:54:00 | ... | 55 |
|
| ... | 16:55:00 | 16:55:00 | ... | 56 |
|
| ... | 16:56:00 | 16:56:00 | ... | 57 |
|
| ... | 16:57:00 | 16:57:00 | ... | 58 |
|
| ... | 16:58:00 | 16:58:00 | ... | 59 |
|
| ... | 16:59:00 | 16:59:00 | ... | 60 |
|
| ... | 17:00:00 | 17:00:00 | ... | 61 |
|
| ... | 17:00:00 | 17:00:00 | ... | 62 |
|
| ... | 17:02:00 | 17:02:00 | ... | 63 |
|
| ... | 17:03:00 | 17:03:00 | ... | 64 |
|
| ... | 17:05:00 | 17:05:00 | ... | 65 |
|
| ... | 17:06:00 | 17:06:00 | ... | 66 |
|
| ... | 17:06:00 | 17:06:00 | ... | 67 |
|
| ... | 17:07:00 | 17:07:00 | ... | 68 |
|
| ... | 17:10:00 | 17:10:00 | ... | 69 |
|
| 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 | |
|---|---|---|---|---|
| hrtgmada | Gun Road | 51.8610082715 | -0.1836751682 | |
| hrtgmadg | Station Road | 51.8673499217 | -0.1844073951 | |
| hrtgmadj | Golf Club | 51.8722003167 | -0.1881487235 | |
| hrtadapd | Bus Station | 51.9017882457 | -0.2025119976 | |
| hrtdwjpj | The Roebuck Hotel | 51.8830576419 | -0.1907489569 | |
| hrtdwjpt | Tesco | 51.8853409933 | -0.1936360686 | |
| hrtdwjpw | Retail Park | 51.8887335256 | -0.197321912 | |
| hrtdwjta | Roaring Meg Retail Park | 51.8928009186 | -0.2004581581 | |
| hrtdwama | Theatre | 51.7967596051 | -0.0800720372 | |
| hrtdwamd | St Andrews Church | 51.7962377158 | -0.082806128 | |
| hrtadamp | Bus Station | 51.7979447078 | -0.0766570421 | |
| hrtdpagm | Park Road | 51.7957764074 | -0.0716445605 | |
| hrtdpagw | Fore Street | 51.7963513266 | -0.0759997304 | |
| hrtdmwjm | The White Horse Hotel | 51.7932172907 | -0.1061652571 | |
| hrtdmwjp | Prince of Wales PH | 51.7904011259 | -0.1082987762 | |
| hrtdmwjt | Old Coach Road | 51.7897178941 | -0.1217689573 | |
| hrtdmwjw | War Memorial | 51.7896700513 | -0.1283539747 | |
| hrtdmwma | Lodge Gates | 51.7877827573 | -0.143163531 | |
| hrtdmwmd | Garden Centre | 51.7873095653 | -0.1479387236 | |
| hrtdmwgd | County Hospital | 51.7973219808 | -0.0886481911 | |
| hrtdmwgj | Hertford North Railway Station | 51.7986245226 | -0.0913341749 | |
| hrtdmwgm | Fordwich Rise | 51.798831257 | -0.0990990869 | |
| hrtdmwgw | Turpins Close | 51.7984611597 | -0.1034655331 | |
| hrtdmwja | Ladywood Road | 51.7964043063 | -0.104726522 | |
| hrtdmwat | Tewin Bury Farm Hotel | 51.8087927087 | -0.1657856354 | |
| hrtdmwaw | Grasswarren Estate | 51.8143980302 | -0.1579413703 | |
| hrtgtdtd | Rose and Crown PH | 51.8174101832 | -0.1562080364 | |
| hrtdmwda | Plume of Feathers PH | 51.8212250453 | -0.1557765952 | |
| hrtdmwdg | Upper Green | 51.8234166318 | -0.1613608298 | |
| hrtdmwdj | Desborough Drive | 51.830114868 | -0.1670673951 | |
| hrtdmdgt | School | 51.8027117707 | -0.0321722394 | |
| hrtgtajp | Node Way Gardens | 51.8242338158 | -0.213799509 | |
| hrtatdgt | Post Office | 51.8327332144 | -0.1689059335 | |
| hrtatdgw | Kitts Corner | 51.8326533702 | -0.1759193306 | |
| hrtatdja | New Road | 51.8282818951 | -0.1822201679 | |
| hrtatdjd | Mornington | 51.8260003582 | -0.1847064382 | |
| hrtatdjg | Welwyn North Railway Station | 51.8231863326 | -0.1917411708 | |
| hrtatdjp | Pumping Station | 51.8221322488 | -0.2015778687 | |
| hrtatdjt | Nursery Hill | 51.8152594343 | -0.193175644 | |
| hrtjawtg | Campus West | 51.8050506266 | -0.208857491 | |
| hrtadagm | Bus Station | 51.8025017894 | -0.204462265 | |
| hrtatagj | Waterside | 51.8088891633 | -0.1864964857 | |
| hrtapwtw | Sir Frederic Osborn School | 51.8016398423 | -0.1811454267 | |
| hrtatadt | Herns Way | 51.8041489096 | -0.1776793679 | |
| hrtdmpwa | Golf Club | 51.8067735261 | -0.1729752854 | |
| hrtapwjw | Cole Green Lane | 51.7919935406 | -0.1691209383 | |
| hrtamtga | Sylvan Way | 51.7949225007 | -0.1753250325 | |
| hrtamtgd | Morrisons | 51.7989706914 | -0.1783377509 | |
| hrtamtgp | Mundells | 51.8059974938 | -0.1896586333 | |
| hrtamtgt | Business Parks South | 51.8064152236 | -0.1928475717 | |
| hrtamtgw | Royal Mail Depot | 51.8042812667 | -0.1967621335 | |
| hrtamtjd | Broadwater Road | 51.80230727 | -0.1999737611 | |
| hrtamtjg | John Lewis | 51.8036907054 | -0.2063586173 | |
| hrtampwp | Pentley Park | 51.8078908967 | -0.2058292416 | |
| 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 | |
| hrtampgj | Carleton Rise | 51.8335855452 | -0.2108459989 | |
| hrtamjwg | The Avenue | 51.8391220931 | -0.2000735343 | |
| hrtamjwj | The North Star PH | 51.8420751034 | -0.1938587101 | |
| hrtamjwm | Mardley Avenue | 51.845533157 | -0.1889293875 | |
| hrtamjwp | The Drive | 51.8476989094 | -0.1853434708 | |
| hrtampad | Red Lion PH | 51.8528612918 | -0.1813314952 | |
| hrtampag | Wickfield | 51.8550777615 | -0.1822005131 | |
| hrtampaj | Monread Lodge | 51.8582809138 | -0.1834945686 | |
| hrtamjgm | Church Place | 51.8326725586 | -0.2123045282 |