Watford - Shenley - St Albans - Hatfield
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:13:00 | 14:13:00 | ... | 1 |
|
| ... | 14:14:00 | 14:14:00 | ... | 2 |
|
| ... | 14:15:00 | 14:15:00 | ... | 3 |
|
| ... | 14:18:00 | 14:18:00 | ... | 4 |
|
| ... | 14:19:00 | 14:19:00 | ... | 5 |
|
| ... | 14:20:00 | 14:20:00 | ... | 6 |
|
| ... | 14:21:00 | 14:21:00 | ... | 7 |
|
| ... | 14:23:00 | 14:23:00 | ... | 8 |
|
| ... | 14:25:00 | 14:25:00 | ... | 9 |
|
| ... | 14:28:00 | 14:28:00 | ... | 10 |
|
| ... | 14:30:00 | 14:30:00 | ... | 11 |
|
| ... | 14:31:00 | 14:31:00 | ... | 12 |
|
| ... | 14:34:00 | 14:34:00 | ... | 13 |
|
| ... | 14:34:00 | 14:34:00 | ... | 14 |
|
| ... | 14:35:00 | 14:35:00 | ... | 15 |
|
| ... | 14:37:00 | 14:37:00 | ... | 16 |
|
| ... | 14:38:00 | 14:38:00 | ... | 17 |
|
| ... | 14:39:00 | 14:39:00 | ... | 18 |
|
| ... | 14:39:00 | 14:39:00 | ... | 19 |
|
| ... | 14:41:00 | 14:41:00 | ... | 20 |
|
| ... | 14:41:00 | 14:41:00 | ... | 21 |
|
| ... | 14:43:00 | 14:43:00 | ... | 22 |
|
| ... | 14:44:00 | 14:44:00 | ... | 23 |
|
| ... | 14:46:00 | 14:46:00 | ... | 24 |
|
| ... | 14:46:00 | 14:46:00 | ... | 25 |
|
| ... | 14:47:00 | 14:47:00 | ... | 26 |
|
| ... | 14:48:00 | 14:48:00 | ... | 27 |
|
| ... | 14:50:00 | 14:50:00 | ... | 28 |
|
| ... | 14:57:00 | 14:57:00 | ... | 29 |
|
| ... | 15:00:00 | 15:00:00 | ... | 30 |
|
| ... | 15:00:00 | 15:00:00 | ... | 31 |
|
| ... | 15:02:00 | 15:02:00 | ... | 32 |
|
| ... | 15:04:00 | 15:04:00 | ... | 33 |
|
| ... | 15:04:00 | 15:04:00 | ... | 34 |
|
| ... | 15:05:00 | 15:05:00 | ... | 35 |
|
| ... | 15:07:00 | 15:07:00 | ... | 36 |
|
| ... | 15:10:00 | 15:10:00 | ... | 37 |
|
| ... | 15:10:00 | 15:10:00 | ... | 38 |
|
| ... | 15:12:00 | 15:12:00 | ... | 39 |
|
| ... | 15:13:00 | 15:13:00 | ... | 40 |
|
| ... | 15:15:00 | 15:15:00 | ... | 41 |
|
| ... | 15:16:00 | 15:16:00 | ... | 42 |
|
| ... | 15:17:00 | 15:17:00 | ... | 43 |
|
| ... | 15:18:00 | 15:18:00 | ... | 44 |
|
| ... | 15:20:00 | 15:20:00 | ... | 45 |
|
| ... | 15:21:00 | 15:21:00 | ... | 46 |
|
| ... | 15:22:00 | 15:22:00 | ... | 47 |
|
| ... | 15:23:00 | 15:23:00 | ... | 48 |
|
| ... | 15:23:00 | 15:23:00 | ... | 49 |
|
| ... | 15:26:00 | 15:26:00 | ... | 50 |
|
| ... | 15:27:00 | 15:27:00 | ... | 51 |
|
| ... | 15:29:00 | 15:29:00 | ... | 52 |
|
| ... | 15:30:00 | 15:30:00 | ... | 53 |
|
| ... | 15:31:00 | 15:31:00 | ... | 54 |
|
| ... | 15:33:00 | 15:33:00 | ... | 55 |
|
| ... | 15:34:00 | 15:34:00 | ... | 56 |
|
| ... | 15:36:00 | 15:36:00 | ... | 57 |
|
| ... | 15:38:00 | 15:38:00 | ... | 58 |
|
| ... | 15:39:00 | 15:39:00 | ... | 59 |
|
| ... | 15:40:00 | 15:40:00 | ... | 60 |
|
| ... | 15:42:00 | 15:42:00 | ... | 61 |
|
| ... | 15:44:00 | 15:44:00 | ... | 62 |
|
| ... | 15:45:00 | 15:45:00 | ... | 63 |
|
| ... | 15:46:00 | 15:46:00 | ... | 64 |
|
| ... | 15:47:00 | 15:47:00 | ... | 65 |
|
| ... | 15:47:00 | 15:47:00 | ... | 66 |
|
| ... | 15:48:00 | 15:48:00 | ... | 67 |
|
| ... | 15:49:00 | 15:49:00 | ... | 68 |
|
| ... | 15:50:00 | 15:50:00 | ... | 69 |
|
| ... | 15:52:00 | 15:52:00 | ... | 70 |
|
| ... | 15:52:00 | 15:52:00 | ... | 71 |
|
| ... | 15:55:00 | 15:55:00 | ... | 72 |
|
| ... | 15:57:00 | 15:57:00 | ... | 73 |
|
| ... | 15:59:00 | 15:59:00 | ... | 74 |
|
| ... | 16:00:00 | 16:00:00 | ... | 75 |
|
| ... | 16:01:00 | 16:01:00 | ... | 76 |
|
| ... | 16:02:00 | 16:02:00 | ... | 77 |
|
| ... | 16:03:00 | 16:03:00 | ... | 78 |
|
| ... | 16:05:00 | 16:05:00 | ... | 79 |
|
| ... | 16:06:00 | 16:06:00 | ... | 80 |
|
| ... | 16:08:00 | 16:08:00 | ... | 81 |
|
| ... | 16:10:00 | 16:10:00 | ... | 82 |
|
| ... | 16:11:00 | 16:11:00 | ... | 83 |
|
| ... | 16:12:00 | 16:12:00 | ... | 84 |
|
| 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 | |
|---|---|---|---|---|
| hrtgptdg | Bell Lane | 51.7164243794 | -0.276781347 | |
| hrtgmwmw | Shenleybury Lane | 51.7080761484 | -0.2937867215 | |
| hrtgmwpa | Park Avenue | 51.6644309119 | -0.3634594825 | |
| hrtgmwdw | Queens School | 51.6587417667 | -0.3675391209 | |
| hrtgmwga | Leisure Centre | 51.6557085845 | -0.3712189375 | |
| hrtgmwgd | The Avenue | 51.6541360619 | -0.3745424327 | |
| hrtgmwdt | James Close | 51.6515041006 | -0.3779902474 | |
| hrtgmtpm | Hillside Road | 51.648687325 | -0.3804324209 | |
| hrtgmpwa | Nell Gwynn Close | 51.6977857491 | -0.2886027003 | |
| hrtgmpwd | Cockle Way | 51.6956021901 | -0.2917960483 | |
| hrtgmpwg | Fielders Way | 51.6932105528 | -0.2918137485 | |
| hrtgmpwj | Andrew Close | 51.6940861079 | -0.2864850654 | |
| hrtgmpwm | Bell Lane Cottages | 51.712370563 | -0.2861125905 | |
| hrtgmpwp | Shenleybury Cottages | 51.7025260466 | -0.2893211 | |
| hrtgmpmt | Shenley Park | 51.6905014734 | -0.2922629667 | |
| hrtgmpmw | Woodhall Gate Lodge | 51.6865251311 | -0.3001957127 | |
| hrtgmpta | Faggots Close | 51.6866191044 | -0.3067022394 | |
| hrtgmptd | Williams Way | 51.6866087743 | -0.3116068554 | |
| hrtgmptg | Red Lion Hotel | 51.6845365902 | -0.3182226138 | |
| hrtgmpgm | Gills Hill Lane | 51.6851171037 | -0.3261286125 | |
| hrtgmpgp | Dellfield Close | 51.6833077029 | -0.329146339 | |
| hrtgmpgt | Watford Road | 51.6812328661 | -0.3318408799 | |
| hrtgmpgw | Shops | 51.6799657527 | -0.3306290245 | |
| hrtgmpja | Kendals Close | 51.6781416642 | -0.3326198165 | |
| hrtgmpjg | New Road | 51.6792428395 | -0.3373526104 | |
| hrtgmpjm | Edge Grove School | 51.6770677207 | -0.3405998136 | |
| hrtgmpjp | Roundbush Lane | 51.6731729835 | -0.3456159901 | |
| hrtgmpjt | St John's Church | 51.6739504477 | -0.3529491522 | |
| hrtgmpjw | Morgan Gardens | 51.6724630391 | -0.354608407 | |
| hrtgmpap | Hilfield Lane | 51.6679203825 | -0.3596317977 | |
| hrtawpwp | St Peter's Street | 51.7537722814 | -0.3369785549 | |
| hrtawmja | Telford Court | 51.7487256594 | -0.3304855986 | |
| hrtawmga | Alma Road | 51.7472916049 | -0.3308137052 | |
| hrtawmgd | Grosvenor Road | 51.7453620123 | -0.3272779388 | |
| hrtawmgj | Cunningham Avenue | 51.743571047 | -0.3240125532 | |
| hrtawmgm | Mile House Lane | 51.7394763078 | -0.316227037 | |
| hrtawmgp | Drakes Drive | 51.7374804646 | -0.3124921944 | |
| hrtawmgt | Birklands Park | 51.7346267645 | -0.3085145421 | |
| hrtawmgw | North Orbital Road | 51.7322120567 | -0.3038113726 | |
| hrtawmag | Leisure Centre | 51.7289145872 | -0.3008794685 | |
| hrtawmaj | Kings Road | 51.726420885 | -0.2981929068 | |
| hrtawmam | Haseldine Road | 51.7233088599 | -0.2950376219 | |
| hrtawmap | War Memorial | 51.7218300476 | -0.2935151451 | |
| hrtawjwd | Willowside | 51.719286961 | -0.2880661097 | |
| hrtawjwg | Thamesdale | 51.7184369792 | -0.2852752036 | |
| hrtawjwj | Colney Fields Retail Park | 51.7169447893 | -0.2859251825 | |
| hrtawjwm | The Bell Roundabout | 51.7173608594 | -0.2805531013 | |
| hrtawjtg | Police Station | 51.7520320505 | -0.3379117318 | |
| hrtawjtj | Lattimore Road | 51.7509528244 | -0.3321854142 | |
| hrtawdwm | Smallford Roundabout | 51.7546089544 | -0.2703441973 | |
| hrtawdwp | Lyon Way | 51.7529185157 | -0.275856272 | |
| hrtawdwt | Acrewood Way | 51.7519767606 | -0.2797024006 | |
| hrtawgad | Ryecroft Court | 51.7513807174 | -0.2844479731 | |
| hrtawgap | Colney Heath Lane | 51.751501376 | -0.2933532312 | |
| hrtawgat | Wynches Farm Drive | 51.7519049748 | -0.2963804237 | |
| hrtawgaw | Oakwood Drive | 51.7519852065 | -0.3006802417 | |
| hrtawdpt | Ashley Road | 51.7525288529 | -0.3047019423 | |
| hrtawdwg | Morrisons | 51.7518727724 | -0.3109706701 | |
| hrtawdmg | Harlesden Road | 51.7520173677 | -0.3141525594 | |
| hrtawdmj | Cemetery | 51.7524493927 | -0.3179467601 | |
| hrtawdmp | Alban City School | 51.7541620831 | -0.3346605968 | |
| hrtgwmaw | Granville Road | 51.7517340284 | -0.3245217075 | |
| hrtawdgw | St Albans City Railway Station | 51.7504015904 | -0.3269324121 | |
| hrtapmwm | Memorial Hall | 51.7627657044 | -0.2216028476 | |
| hrtapmtw | Town Centre | 51.7619409325 | -0.2277214714 | |
| hrtapmwj | St Albans Road West | 51.7611807694 | -0.2333736424 | |
| hrtapmjg | Meadow Dell | 51.7601020814 | -0.2357921681 | |
| hrtapmjp | Bishop's Close | 51.7586578611 | -0.240224412 | |
| hrtapmgp | The Galleria | 51.7597537214 | -0.2407469256 | |
| hrtapmad | Ellenbrook Lane | 51.7594158156 | -0.2524536007 | |
| hrtapmaj | Great Nast Hyde | 51.7584678491 | -0.2576485753 | |
| hrtgtgjt | UH de Havilland Campus | 51.7613457186 | -0.2510169548 | |
| hrtapdpw | Bishop's Close | 51.7587065778 | -0.2398747598 | |
| hrtapdgt | Todd Building | 51.7534656549 | -0.2429761759 | |
| hrtjadwj | Todd Building | 51.7545918241 | -0.2431208194 | |
| hrtapajd | St Etheldreda's Drive | 51.7619818277 | -0.2173443112 | |
| hrtjdgda | Hatfield Railway Station | 51.7635748207 | -0.2156585113 | |
| hrtjadwt | The Forum | 51.7498594429 | -0.2423483033 | |
| hrtadtwj | Bushey Railway Station East | 51.6459876543 | -0.3841998601 | |
| hrtadpat | Bushey Arches | 51.6475757964 | -0.385256371 | |
| hrtadpaw | Dalton Way | 51.6492977073 | -0.3888522385 | |
| hrtadpda | Watford High Street Railway Station | 51.6517475605 | -0.3904566742 | |
| hrtadmtd | King Street | 51.6543032954 | -0.3945440203 | |
| hrtadmtm | High Street | 51.6553150414 | -0.3961996977 |