Watford - Shenley - St Albans - Hatfield
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 11:22:00 | 11:22:00 | ... | 1 |
|
| ... | 11:25:00 | 11:25:00 | ... | 2 |
|
| ... | 11:27:00 | 11:27:00 | ... | 3 |
|
| ... | 11:28:00 | 11:28:00 | ... | 4 |
|
| ... | 11:29:00 | 11:29:00 | ... | 5 |
|
| ... | 11:29:00 | 11:29:00 | ... | 6 |
|
| ... | 11:31:00 | 11:31:00 | ... | 7 |
|
| ... | 11:32:00 | 11:32:00 | ... | 8 |
|
| ... | 11:33:00 | 11:33:00 | ... | 9 |
|
| ... | 11:34:00 | 11:34:00 | ... | 10 |
|
| ... | 11:35:00 | 11:35:00 | ... | 11 |
|
| ... | 11:36:00 | 11:36:00 | ... | 12 |
|
| ... | 11:38:00 | 11:38:00 | ... | 13 |
|
| ... | 11:39:00 | 11:39:00 | ... | 14 |
|
| ... | 11:39:00 | 11:39:00 | ... | 15 |
|
| ... | 11:40:00 | 11:40:00 | ... | 16 |
|
| ... | 11:42:00 | 11:42:00 | ... | 17 |
|
| ... | 11:43:00 | 11:43:00 | ... | 18 |
|
| ... | 11:44:00 | 11:44:00 | ... | 19 |
|
| ... | 11:45:00 | 11:45:00 | ... | 20 |
|
| ... | 11:46:00 | 11:46:00 | ... | 21 |
|
| ... | 11:47:00 | 11:47:00 | ... | 22 |
|
| ... | 11:48:00 | 11:48:00 | ... | 23 |
|
| ... | 11:48:00 | 11:48:00 | ... | 24 |
|
| ... | 11:49:00 | 11:49:00 | ... | 25 |
|
| ... | 11:51:00 | 11:51:00 | ... | 26 |
|
| ... | 11:53:00 | 11:53:00 | ... | 27 |
|
| ... | 11:54:00 | 11:54:00 | ... | 28 |
|
| ... | 11:55:00 | 11:55:00 | ... | 29 |
|
| ... | 11:56:00 | 11:56:00 | ... | 30 |
|
| ... | 11:58:00 | 11:58:00 | ... | 31 |
|
| ... | 11:59:00 | 11:59:00 | ... | 32 |
|
| ... | 12:00:00 | 12:00:00 | ... | 33 |
|
| ... | 12:01:00 | 12:01:00 | ... | 34 |
|
| ... | 12:02:00 | 12:02:00 | ... | 35 |
|
| ... | 12:03:00 | 12:03:00 | ... | 36 |
|
| ... | 12:04:00 | 12:04:00 | ... | 37 |
|
| ... | 12:06:00 | 12:06:00 | ... | 38 |
|
| ... | 12:08:00 | 12:08:00 | ... | 39 |
|
| ... | 12:09:00 | 12:09:00 | ... | 40 |
|
| ... | 12:10:00 | 12:10:00 | ... | 41 |
|
| ... | 12:11:00 | 12:11:00 | ... | 42 |
|
| ... | 12:11:00 | 12:11:00 | ... | 43 |
|
| ... | 12:12:00 | 12:12:00 | ... | 44 |
|
| ... | 12:13:00 | 12:13:00 | ... | 45 |
|
| ... | 12:15:00 | 12:15:00 | ... | 46 |
|
| ... | 12:15:00 | 12:15:00 | ... | 47 |
|
| ... | 12:17:00 | 12:17:00 | ... | 48 |
|
| ... | 12:18:00 | 12:18:00 | ... | 49 |
|
| ... | 12:19:00 | 12:19:00 | ... | 50 |
|
| ... | 12:21:00 | 12:21:00 | ... | 51 |
|
| ... | 12:23:00 | 12:23:00 | ... | 52 |
|
| ... | 12:26:00 | 12:26:00 | ... | 53 |
|
| ... | 12:28:00 | 12:28:00 | ... | 54 |
|
| ... | 12:29:00 | 12:29:00 | ... | 55 |
|
| ... | 12:29:00 | 12:29:00 | ... | 56 |
|
| ... | 12:33:00 | 12:33:00 | ... | 57 |
|
| ... | 12:34:00 | 12:34:00 | ... | 58 |
|
| ... | 12:36:00 | 12:36:00 | ... | 59 |
|
| ... | 12:39:00 | 12:39:00 | ... | 60 |
|
| ... | 12:43:00 | 12:43:00 | ... | 61 |
|
| ... | 12:45:00 | 12:45:00 | ... | 62 |
|
| ... | 12:46:00 | 12:46:00 | ... | 63 |
|
| ... | 12:47:00 | 12:47:00 | ... | 64 |
|
| ... | 12:48:00 | 12:48:00 | ... | 65 |
|
| ... | 12:49:00 | 12:49:00 | ... | 66 |
|
| ... | 12:50:00 | 12:50:00 | ... | 67 |
|
| ... | 12:52:00 | 12:52:00 | ... | 68 |
|
| ... | 12:53:00 | 12:53:00 | ... | 69 |
|
| ... | 12:53:00 | 12:53:00 | ... | 70 |
|
| ... | 12:54:00 | 12:54:00 | ... | 71 |
|
| ... | 12:56:00 | 12:56:00 | ... | 72 |
|
| ... | 12:57:00 | 12:57:00 | ... | 73 |
|
| ... | 12:59:00 | 12:59:00 | ... | 74 |
|
| ... | 12:59:00 | 12:59:00 | ... | 75 |
|
| ... | 13:01:00 | 13:01:00 | ... | 76 |
|
| ... | 13:02:00 | 13:02:00 | ... | 77 |
|
| ... | 13:03:00 | 13:03:00 | ... | 78 |
|
| ... | 13:07:00 | 13:07:00 | ... | 79 |
|
| ... | 13:10:00 | 13:10:00 | ... | 80 |
|
| ... | 13:11:00 | 13:11:00 | ... | 81 |
|
| ... | 13:13:00 | 13:13:00 | ... | 82 |
|
| ... | 13:13:00 | 13:13:00 | ... | 83 |
|
| ... | 13:14:00 | 13:14:00 | ... | 84 |
|
| ... | 13:15:00 | 13:15:00 | ... | 85 |
|
| ... | 13:16:00 | 13:16:00 | ... | 86 |
|
| ... | 13:17:00 | 13:17:00 | ... | 87 |
|
| ... | 13:18:00 | 13:18:00 | ... | 88 |
|
| ... | 13:18:00 | 13:18:00 | ... | 89 |
|
| ... | 13:20:00 | 13:20:00 | ... | 90 |
|
| 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 | |
|---|---|---|---|---|
| hrtgptda | Bell Lane | 51.7157584881 | -0.276748754 | |
| hrtgmtpt | Hillside Road | 51.6494115376 | -0.3801319706 | |
| hrtgmtpw | James Close | 51.6514629538 | -0.3782663695 | |
| hrtgmtmg | The Avenue | 51.654314214 | -0.3744204087 | |
| hrtgmtmj | Leisure Centre | 51.6561499462 | -0.370624837 | |
| hrtgmtmp | Queens School | 51.6591791442 | -0.3673065352 | |
| hrtgmtmt | Hilfield Brook | 51.6618811386 | -0.3643899566 | |
| hrtgmtmw | Park Avenue | 51.6646845767 | -0.3635949393 | |
| hrtgmtgd | Shenleybury Lane | 51.7085257608 | -0.2944066506 | |
| hrtgmtaw | Recreation Ground | 51.685842026 | -0.3183333709 | |
| hrtgmtga | Porters Park Drive | 51.6992205313 | -0.2883315074 | |
| hrtgmptp | Shenleybury Cottages | 51.7030026433 | -0.2899398931 | |
| hrtgmptw | Bell Lane Cottages | 51.7126503409 | -0.2855664356 | |
| hrtgmtad | Cockle Way | 51.6955656644 | -0.2923762093 | |
| hrtgmpmd | Fielders Way | 51.693496342 | -0.2904429042 | |
| hrtgmpmj | Andrew Close | 51.693952904 | -0.2859836762 | |
| hrtgmpat | Elton Way | 51.6664513375 | -0.3619695761 | |
| hrtgmpaw | Hilfield Lane | 51.6687884378 | -0.3586894002 | |
| hrtgmpda | Morgan Gardens | 51.6726258263 | -0.3546748192 | |
| hrtgmpdg | St John's Church | 51.6741800677 | -0.3526515683 | |
| hrtgmpdj | Roundbush Lane | 51.6733501115 | -0.3447851755 | |
| hrtgmpdm | Edge Grove School | 51.6777991738 | -0.3401825522 | |
| hrtgmpdp | New Road | 51.6791335736 | -0.3378917924 | |
| hrtgmpgd | Kendals Close | 51.6778357233 | -0.3332385379 | |
| hrtgmjtw | Shops | 51.6801542819 | -0.3306076266 | |
| hrtgmjwd | Watford Road | 51.6813728092 | -0.3321973632 | |
| hrtgmjwj | Dellfield Close | 51.6831537441 | -0.3297017001 | |
| hrtgmjwp | Newlands Avenue | 51.6859971235 | -0.3222625235 | |
| hrtgmjwt | Williams Way | 51.6869816669 | -0.3112747112 | |
| hrtgmpad | Faggots Close | 51.686732395 | -0.3064520767 | |
| hrtgmpag | Woodhall Gate Lodge | 51.6867882605 | -0.2997373854 | |
| hrtgmpaj | Shenley Park | 51.6913364769 | -0.2903217254 | |
| hrtawtdw | St Peter's Street | 51.7539142338 | -0.3368429467 | |
| hrtawmpj | Alexandra Road | 51.7498579895 | -0.3298064238 | |
| hrtjadgp | Telford Court | 51.7482301871 | -0.3310543496 | |
| hrtawjpa | Colney Fields Retail Park | 51.7168398989 | -0.2861318187 | |
| hrtawjtg | Police Station | 51.7520320505 | -0.3379117318 | |
| hrtawjtj | Lattimore Road | 51.7509528244 | -0.3321854142 | |
| hrtawjgj | St Albans City Railway Station | 51.750598073 | -0.3268382289 | |
| hrtawjdg | The Crown PH | 51.7515748502 | -0.3228180739 | |
| hrtawjdj | Cemetery | 51.7524362285 | -0.3195409045 | |
| hrtawjdm | Harlesden Road | 51.7525639504 | -0.3158997215 | |
| hrtawjdp | Morrisons | 51.7520463056 | -0.3130359321 | |
| hrtawgwd | Ashley Road | 51.7526211763 | -0.307364251 | |
| hrtawgtg | Oakwood Drive | 51.7520895075 | -0.301053007 | |
| hrtawgtj | Wynches Farm Drive | 51.7519406735 | -0.2957416235 | |
| hrtawgtm | Colney Heath Lane | 51.7513764325 | -0.291561493 | |
| hrtawgtp | Ryecroft Court | 51.75148518 | -0.2842122145 | |
| hrtawgtw | Acrewood Way | 51.7523310242 | -0.2787182564 | |
| hrtawgjp | Three Horseshoes PH | 51.755137973 | -0.2690199995 | |
| hrtawdmp | Alban City School | 51.7541620831 | -0.3346605968 | |
| hrtawdpj | Iceland | 51.7505766234 | -0.3303883765 | |
| hrtawdjt | The Bell Roundabout | 51.7171721308 | -0.2805602598 | |
| hrtawdjw | Thamesdale | 51.7184046203 | -0.2855225357 | |
| hrtawdma | Willowside | 51.7189597602 | -0.2872098396 | |
| hrtawdgd | War Memorial | 51.7213848443 | -0.2931989154 | |
| hrtawdgm | Haseldine Road | 51.7234399285 | -0.2953946548 | |
| hrtawdgp | Kings Road | 51.7268911734 | -0.2990005852 | |
| hrtawdgt | Leisure Centre | 51.7288362138 | -0.3010561703 | |
| hrtawawa | North Orbital Road | 51.7324797785 | -0.3049164189 | |
| hrtawawd | Birklands Park | 51.7348765011 | -0.3089976118 | |
| hrtawawg | Drakes Drive | 51.7375711168 | -0.3131695198 | |
| hrtawawj | Mile House Lane | 51.7401024984 | -0.3178838841 | |
| hrtawawm | Cunningham Avenue | 51.7432327376 | -0.3236194975 | |
| hrtawawp | Grosvenor Road | 51.7459563527 | -0.3286031547 | |
| hrtapmwp | St Etheldreda's Drive | 51.7617753327 | -0.2167728068 | |
| hrtapmjp | Bishop's Close | 51.7586578611 | -0.240224412 | |
| hrtapgaj | Great Nast Hyde | 51.7588206694 | -0.2571858064 | |
| hrtapgat | The Comet Hotel | 51.7609230894 | -0.2443820924 | |
| hrtapdta | The Galleria | 51.7595224263 | -0.2397126223 | |
| hrtapdpw | Bishop's Close | 51.7587065778 | -0.2398747598 | |
| hrtapdgt | Todd Building | 51.7534656549 | -0.2429761759 | |
| hrtjadwj | Todd Building | 51.7545918241 | -0.2431208194 | |
| hrtapdja | Meadow Dell | 51.7600377939 | -0.2363018364 | |
| hrtapdjd | St Albans Road West | 51.7613923161 | -0.2330900599 | |
| hrtapdjg | ASDA | 51.7619563924 | -0.2293438563 | |
| hrtapdjw | Town Centre | 51.7621621656 | -0.2262926848 | |
| hrtapawt | Memorial Hall | 51.7634712651 | -0.2224735934 | |
| hrtjapaj | Old Rectory Drive | 51.7624662849 | -0.2196438154 | |
| hrtjdgda | Hatfield Railway Station | 51.7635748207 | -0.2156585113 | |
| hrtjadjd | UH de Havilland Campus | 51.7613309772 | -0.2512348856 | |
| hrtgtjmw | Albatross Way | 51.7631770286 | -0.2483957077 | |
| hrtjagam | The Forum | 51.7496752659 | -0.2426596803 | |
| hrtadwgw | Beechen Grove | 51.656927009 | -0.3950585087 | |
| hrtadtwt | Water Lane | 51.6534979357 | -0.392201681 | |
| hrtadwag | Watford High Street Railway Station | 51.6523103408 | -0.3908414994 | |
| hrtadwam | Tesco | 51.6507954771 | -0.3885678531 | |
| hrtadwat | Waterfields Way | 51.6493735664 | -0.3871727967 | |
| hrtadwda | Bushey Arches | 51.6475534502 | -0.3849391728 | |
| hrtjdjtj | King Street | 51.6534186488 | -0.3949511342 |