Queensbury - Hatfield
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:09:00 | 16:09:00 | ... | 1 |
|
| ... | 16:10:00 | 16:10:00 | ... | 2 |
|
| ... | 16:10:00 | 16:10:00 | ... | 3 |
|
| ... | 16:12:00 | 16:12:00 | ... | 4 |
|
| ... | 16:15:00 | 16:15:00 | ... | 5 |
|
| ... | 16:17:00 | 16:17:00 | ... | 6 |
|
| ... | 16:21:00 | 16:21:00 | ... | 7 |
|
| ... | 16:21:00 | 16:21:00 | ... | 8 |
|
| ... | 16:24:00 | 16:24:00 | ... | 9 |
|
| ... | 16:26:00 | 16:26:00 | ... | 10 |
|
| ... | 16:26:00 | 16:26:00 | ... | 11 |
|
| ... | 16:30:00 | 16:30:00 | ... | 12 |
|
| ... | 16:33:00 | 16:33:00 | ... | 13 |
|
| ... | 16:33:00 | 16:33:00 | ... | 14 |
|
| ... | 16:47:00 | 16:47:00 | ... | 15 |
|
| ... | 16:47:00 | 16:47:00 | ... | 16 |
|
| ... | 16:48:00 | 16:48:00 | ... | 17 |
|
| ... | 16:48:00 | 16:48:00 | ... | 18 |
|
| ... | 16:48:00 | 16:48:00 | ... | 19 |
|
| ... | 16:49:00 | 16:49:00 | ... | 20 |
|
| ... | 16:50:00 | 16:50:00 | ... | 21 |
|
| ... | 16:52:00 | 16:52:00 | ... | 22 |
|
| ... | 16:53:00 | 16:53:00 | ... | 23 |
|
| ... | 16:54:00 | 16:54:00 | ... | 24 |
|
| ... | 16:55:00 | 16:55:00 | ... | 25 |
|
| ... | 16:57:00 | 16:57:00 | ... | 26 |
|
| ... | 17:00:00 | 17:00:00 | ... | 27 |
|
| ... | 17:02:00 | 17:02:00 | ... | 28 |
|
| ... | 17:04:00 | 17:04:00 | ... | 29 |
|
| ... | 17:05:00 | 17:05:00 | ... | 30 |
|
| ... | 17:07:00 | 17:07:00 | ... | 31 |
|
| ... | 17:08:00 | 17:08:00 | ... | 32 |
|
| ... | 17:09:00 | 17:09:00 | ... | 33 |
|
| ... | 17:10:00 | 17:10:00 | ... | 34 |
|
| ... | 17:10:00 | 17:10:00 | ... | 35 |
|
| ... | 17:12:00 | 17:12:00 | ... | 36 |
|
| ... | 17:13:00 | 17:13:00 | ... | 37 |
|
| ... | 17:14:00 | 17:14:00 | ... | 38 |
|
| ... | 17:16:00 | 17:16:00 | ... | 39 |
|
| ... | 17:16:00 | 17:16:00 | ... | 40 |
|
| ... | 17:17:00 | 17:17:00 | ... | 41 |
|
| ... | 17:19:00 | 17:19:00 | ... | 42 |
|
| ... | 17:19:00 | 17:19:00 | ... | 43 |
|
| ... | 17:21:00 | 17:21:00 | ... | 44 |
|
| ... | 17:21:00 | 17:21:00 | ... | 45 |
|
| ... | 17:23:00 | 17:23:00 | ... | 46 |
|
| ... | 17:25:00 | 17:25:00 | ... | 47 |
|
| ... | 17:27:00 | 17:27:00 | ... | 48 |
|
| ... | 17:29:00 | 17:29:00 | ... | 49 |
|
| 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 | |
|---|---|---|---|---|
| hrtjawpg | Rowley Lane | 51.6570824436 | -0.2516363611 | |
| hrtgpjpj | Warwick Road | 51.6593504438 | -0.2560021866 | |
| hrtgpjpm | Studio Way | 51.6599135067 | -0.2630506952 | |
| hrtgpjdj | Civic Offices | 51.658989993 | -0.2681029435 | |
| hrtgpjgp | Tesco | 51.6572069654 | -0.2703684509 | |
| hrtgpgwm | Elstree Studios | 51.6583102529 | -0.2701818667 | |
| hrtgpgwp | Furzehill Road | 51.6554519166 | -0.2763770484 | |
| hrtgmwpt | Oakwood Avenue | 51.6517048231 | -0.2716620752 | |
| hrtgmwta | Summerswood Primary School | 51.6501864542 | -0.268698685 | |
| hrtgmwtm | Cranes Way | 51.6483248188 | -0.2650258588 | |
| hrtgmwjp | Ashley Drive | 51.6457633605 | -0.2614668253 | |
| hrtgmwjt | Stirling Corner | 51.6435032254 | -0.2558009371 | |
| hrtapmwm | Memorial Hall | 51.7627657044 | -0.2216028476 | |
| hrtapmgw | Tudor Close | 51.7474836674 | -0.2422232272 | |
| hrtapgap | Ellenbrook Lane | 51.7596860328 | -0.2500667724 | |
| hrtjadjg | UH de Havilland Campus | 51.7611388052 | -0.2510104599 | |
| 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 | |
| hrtapatm | Burfield Close | 51.7669867105 | -0.2301904909 | |
| hrtgwpmt | Gypsy Moth Avenue | 51.7707677703 | -0.2406665429 | |
| hrtgwpmw | Eisai | 51.7672490701 | -0.2422816061 | |
| hrtapajd | St Etheldreda's Drive | 51.7619818277 | -0.2173443112 | |
| hrtjdgdg | Hatfield Railway Station | 51.7634312534 | -0.2156786634 | |
| hrtjagad | The Forum | 51.7500308425 | -0.2423851111 | |
| Edgware | 51.6145442829 | -0.27561613 | ||
| 58791 | Queensbury | 51.5947376384 | -0.2850433304 | |
| 72171 | Broadfields Avenue | 51.6215064054 | -0.2733153229 | |
| 49905 | Apex Corner | 51.6228345366 | -0.2542821635 | |
| 52312 | North Road (HA8) | 51.6036006095 | -0.270716679 | |
| 58482 | Deansbrook Road | 51.6077189565 | -0.2756003568 | |
| 71350 | Edgwarebury Gardens | 51.6174704683 | -0.2770941508 | |
| 50689 | Edgwarebury Lane Edgware Way | 51.6206054333 | -0.2774810216 | |
| 56878 | Edgware Community Hospital | 51.6051735427 | -0.2731118728 | |
| 54276 | The Parade Queensbury | 51.5979038999 | -0.2783545081 | |
| 48734 | Highview Avenue | 51.6221602259 | -0.2670352534 | |
| 74338 | Edgware Way Mill Hill | 51.6218154565 | -0.263176805 | |
| 51149 | Moat Mount Park | 51.6319506334 | -0.2535420664 | |
| 59294 | Oak Gardens | 51.599906268 | -0.2677670197 | |
| 50049 | Oakmede Gardens | 51.6214035832 | -0.2590465055 | |
| 56985 | Scratchwood Park | 51.6383775619 | -0.2551883189 | |
| 55869 | Manor Park Crescent | 51.612072327 | -0.2775151934 | |
| 57798 | Burnt Oak Broadway | 51.6012740256 | -0.2678304902 | |
| 59095 | The Fairway Mill Hill | 51.6266711669 | -0.2540771088 | |
| 48933 | The Grove (HA8) | 51.6220341865 | -0.2700737718 | |
| 71128 | The Highlands | 51.5985077112 | -0.2723251387 | |
| 53824 | Turner Road | 51.5965074422 | -0.2861605954 | |
| 50025 | Whitchurch Lane | 51.6101801627 | -0.2784822487 |