Welwyn Garden City - St Albans (New Greens Est)
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:02:00 | 09:02:00 | ... | 1 |
|
| ... | 09:03:00 | 09:03:00 | ... | 2 |
|
| ... | 09:05:00 | 09:05:00 | ... | 3 |
|
| ... | 09:06:00 | 09:06:00 | ... | 4 |
|
| ... | 09:07:00 | 09:07:00 | ... | 5 |
|
| ... | 09:07:00 | 09:07:00 | ... | 6 |
|
| ... | 09:08:00 | 09:08:00 | ... | 7 |
|
| ... | 09:09:00 | 09:09:00 | ... | 8 |
|
| ... | 09:13:00 | 09:13:00 | ... | 9 |
|
| ... | 09:15:00 | 09:15:00 | ... | 10 |
|
| ... | 09:16:00 | 09:16:00 | ... | 11 |
|
| ... | 09:19:00 | 09:19:00 | ... | 12 |
|
| ... | 09:22:00 | 09:22:00 | ... | 13 |
|
| ... | 09:24:00 | 09:24:00 | ... | 14 |
|
| ... | 09:25:00 | 09:25:00 | ... | 15 |
|
| ... | 09:26:00 | 09:26:00 | ... | 16 |
|
| ... | 09:27:00 | 09:27:00 | ... | 17 |
|
| ... | 09:28:00 | 09:28:00 | ... | 18 |
|
| ... | 09:29:00 | 09:29:00 | ... | 19 |
|
| ... | 09:30:00 | 09:30:00 | ... | 20 |
|
| ... | 09:30:00 | 09:30:00 | ... | 21 |
|
| ... | 09:32:00 | 09:32:00 | ... | 22 |
|
| ... | 09:32:00 | 09:32:00 | ... | 23 |
|
| ... | 09:33:00 | 09:33:00 | ... | 24 |
|
| ... | 09:33:00 | 09:33:00 | ... | 25 |
|
| ... | 09:34:00 | 09:34:00 | ... | 26 |
|
| ... | 09:35:00 | 09:35:00 | ... | 27 |
|
| ... | 09:36:00 | 09:36:00 | ... | 28 |
|
| ... | 09:37:00 | 09:37:00 | ... | 29 |
|
| ... | 09:38:00 | 09:38:00 | ... | 30 |
|
| ... | 09:38:00 | 09:38:00 | ... | 31 |
|
| ... | 09:39:00 | 09:39:00 | ... | 32 |
|
| ... | 09:40:00 | 09:40:00 | ... | 33 |
|
| ... | 09:41:00 | 09:41:00 | ... | 34 |
|
| ... | 09:42:00 | 09:42:00 | ... | 35 |
|
| ... | 09:44:00 | 09:44:00 | ... | 36 |
|
| ... | 09:45:00 | 09:45:00 | ... | 37 |
|
| ... | 09:46:00 | 09:46:00 | ... | 38 |
|
| ... | 09:48:00 | 09:48:00 | ... | 39 |
|
| ... | 09:48:00 | 09:48:00 | ... | 40 |
|
| ... | 09:50:00 | 09:50:00 | ... | 41 |
|
| ... | 09:51:00 | 09:51:00 | ... | 42 |
|
| ... | 09:51:00 | 09:51:00 | ... | 43 |
|
| ... | 09:53:00 | 09:53:00 | ... | 44 |
|
| ... | 09:54:00 | 09:54:00 | ... | 45 |
|
| ... | 09:54:00 | 09:54:00 | ... | 46 |
|
| ... | 09:55:00 | 09:55:00 | ... | 47 |
|
| ... | 09:57:00 | 09:57:00 | ... | 48 |
|
| ... | 10:00:00 | 10:00:00 | ... | 49 |
|
| ... | 10:01:00 | 10:01:00 | ... | 50 |
|
| ... | 10:02:00 | 10:02:00 | ... | 51 |
|
| ... | 10:04:00 | 10:04:00 | ... | 52 |
|
| ... | 10:04:00 | 10:04:00 | ... | 53 |
|
| ... | 10:05:00 | 10:05:00 | ... | 54 |
|
| ... | 10:06:00 | 10:06:00 | ... | 55 |
|
| ... | 10:07:00 | 10:07:00 | ... | 56 |
|
| ... | 10:08:00 | 10:08:00 | ... | 57 |
|
| ... | 10:09:00 | 10:09:00 | ... | 58 |
|
| ... | 10:10:00 | 10:10:00 | ... | 59 |
|
| ... | 10:12:00 | 10:12:00 | ... | 60 |
|
| ... | 10:14:00 | 10:14:00 | ... | 61 |
|
| ... | 10:15:00 | 10:15:00 | ... | 62 |
|
| ... | 10:17:00 | 10:17:00 | ... | 63 |
|
| ... | 10:18:00 | 10:18:00 | ... | 64 |
|
| ... | 10:19:00 | 10:19:00 | ... | 65 |
|
| ... | 10:21:00 | 10:21:00 | ... | 66 |
|
| ... | 10:24:00 | 10:24:00 | ... | 67 |
|
| ... | 10:25:00 | 10:25:00 | ... | 68 |
|
| ... | 10:26:00 | 10:26:00 | ... | 69 |
|
| ... | 10:27:00 | 10:27:00 | ... | 70 |
|
| ... | 10:27:00 | 10:27:00 | ... | 71 |
|
| ... | 10:28:00 | 10:28:00 | ... | 72 |
|
| ... | 10:29:00 | 10:29:00 | ... | 73 |
|
| ... | 10:30:00 | 10:30:00 | ... | 74 |
|
| ... | 10:32:00 | 10:32:00 | ... | 75 |
|
| ... | 10:33:00 | 10:33:00 | ... | 76 |
|
| ... | 10:34:00 | 10:34:00 | ... | 77 |
|
| ... | 10:35:00 | 10:35:00 | ... | 78 |
|
| ... | 10:37:00 | 10:37:00 | ... | 79 |
|
| ... | 10:38:00 | 10:38:00 | ... | 80 |
|
| 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 | |
|---|---|---|---|---|
| hrtjamjp | Stanton Close | 51.7673245657 | -0.2937854933 | |
| hrtdadtw | Newgate Close | 51.7637607503 | -0.2904853825 | |
| hrtdadwg | Central Drive | 51.7549768957 | -0.305479587 | |
| hrtjajwm | Chestnut Drive | 51.7582826593 | -0.3071235783 | |
| hrtdadmd | Sandpit Lane | 51.7606197126 | -0.3076882385 | |
| hrtawtgm | High Oaks Terminus | 51.7710144987 | -0.3404900813 | |
| hrtawtgw | Maple Avenue | 51.769608411 | -0.3434402986 | |
| hrtawtja | Alverton | 51.7656399125 | -0.3432232723 | |
| hrtawtjd | Green Lane | 51.7676937102 | -0.343481408 | |
| hrtawtjp | Batchwood Hall | 51.7646441422 | -0.344665416 | |
| hrtawtjt | Batchwood Drive | 51.7632288028 | -0.3463257044 | |
| hrtawtjw | Hospital | 51.7611973334 | -0.342545444 | |
| hrtawtaw | Goldsmith Way | 51.7593982359 | -0.3412202858 | |
| hrtawtda | Catherine Street | 51.7552413059 | -0.3372143643 | |
| hrtawtdw | St Peter's Street | 51.7539142338 | -0.3368429467 | |
| 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 | |
| hrtawgjp | Three Horseshoes PH | 51.755137973 | -0.2690199995 | |
| hrtjdmdw | Jove Gardens | 51.757017243 | -0.2732949362 | |
| hrtatpap | The Quadrant | 51.763529919 | -0.3055941038 | |
| hrtatpat | Barnfield Road | 51.7636873069 | -0.3027913702 | |
| hrtatpaw | Woodfield Way | 51.7667765152 | -0.3000234001 | |
| hrtatpda | Chandlers Road | 51.7681561661 | -0.3009136033 | |
| hrtatpdg | Sherwood Avenue | 51.7700606279 | -0.3026537695 | |
| hrtatpdj | Quantock Close | 51.7713393052 | -0.3052726699 | |
| hrtatmtm | Wilstone Drive | 51.7732767129 | -0.300576357 | |
| hrtatmtp | Portman Close | 51.7720848972 | -0.2983745384 | |
| hrtatmtw | Blackberry Jack PH | 51.7702552448 | -0.29745779 | |
| hrtatmwa | Ripon Way | 51.7690436173 | -0.2938945895 | |
| hrtatmwd | Harness Way | 51.7657232874 | -0.2949762497 | |
| hrtjamjt | Elizabeth Court | 51.7645819845 | -0.2931643108 | |
| hrtgwawa | Bus Station | 51.8023548132 | -0.2036703853 | |
| hrtapmwp | St Etheldreda's Drive | 51.7617753327 | -0.2167728068 | |
| hrtapmjp | Bishop's Close | 51.7586578611 | -0.240224412 | |
| hrtapmjt | Vigors Croft | 51.7570860519 | -0.237344169 | |
| hrtapmpd | St Peter's Church | 51.7540596848 | -0.2340137552 | |
| hrtapmdt | High View | 51.7495496155 | -0.2342765879 | |
| hrtjdmdp | UH Student Estate | 51.7525823015 | -0.2344335834 | |
| hrtapmdw | Northdown Road | 51.7468095767 | -0.2338474459 | |
| hrtapmga | Garden Avenue | 51.742490618 | -0.2342621159 | |
| hrtapgaj | Great Nast Hyde | 51.7588206694 | -0.2571858064 | |
| hrtapgat | The Comet Hotel | 51.7609230894 | -0.2443820924 | |
| hrtapgda | Tudor Close | 51.7470157016 | -0.2421979341 | |
| hrtapdta | The Galleria | 51.7595224263 | -0.2397126223 | |
| 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 | |
| hrtapapj | Clarke's Road | 51.7680540578 | -0.2204819497 | |
| hrtapata | Hopfields PH | 51.7714518965 | -0.2233775605 | |
| hrtapatg | Hillfield | 51.7736900089 | -0.2185643753 | |
| hrtapatj | Mount Pleasant Lane | 51.774933011 | -0.2181095615 | |
| hrtapajp | Cecil Crescent | 51.7669269294 | -0.21730892 | |
| hrtjdgdp | Hatfield Railway Station | 51.7633652683 | -0.2154783846 | |
| hrtamwjg | Museum | 51.7741178925 | -0.2053136703 | |
| hrtamwjm | Boundary Lane | 51.7853816503 | -0.2021554386 | |
| hrtamwjp | Hollybush Lane | 51.7837888712 | -0.1956221543 | |
| hrtamwma | Ryelands | 51.7836306468 | -0.1911775822 | |
| hrtamwmg | New QEII Hospital | 51.7847071578 | -0.1875099342 | |
| hrtamwdp | Sheepcote | 51.7857358604 | -0.1795959116 | |
| hrtamwdt | Howlands House | 51.7850668706 | -0.1840158828 | |
| hrtamwdw | Archers Ride | 51.7876783088 | -0.1772848121 | |
| hrtamtmd | Ganett Roundabout | 51.7916512243 | -0.1777626638 | |
| hrtamtmp | Ridgeway | 51.794981743 | -0.182051415 | |
| hrtamtmt | Salisbury Road | 51.7961376006 | -0.186442549 | |
| hrtamtmw | Fire Station | 51.7986665122 | -0.1900828086 | |
| hrtamtpa | Tewin Road | 51.8003168607 | -0.1939036172 | |
| hrtamtjd | Broadwater Road | 51.80230727 | -0.1999737611 | |
| hrtjadjd | UH de Havilland Campus | 51.7613309772 | -0.2512348856 | |
| hrtgtjmw | Albatross Way | 51.7631770286 | -0.2483957077 | |
| hrtjagam | The Forum | 51.7496752659 | -0.2426596803 |