Watford & Meriden Circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 10:55:00 | 10:55:00 | ... | 1 |
|
| ... | 10:58:00 | 10:58:00 | ... | 2 |
|
| ... | 10:59:00 | 10:59:00 | ... | 3 |
|
| ... | 11:02:00 | 11:02:00 | ... | 4 |
|
| ... | 11:04:00 | 11:04:00 | ... | 5 |
|
| ... | 11:05:00 | 11:05:00 | ... | 6 |
|
| ... | 11:07:00 | 11:07:00 | ... | 7 |
|
| ... | 11:07:00 | 11:07:00 | ... | 8 |
|
| ... | 11:08:00 | 11:08:00 | ... | 9 |
|
| ... | 11:10:00 | 11:10:00 | ... | 10 |
|
| ... | 11:10:00 | 11:10:00 | ... | 11 |
|
| ... | 11:11:00 | 11:11:00 | ... | 12 |
|
| ... | 11:11:00 | 11:11:00 | ... | 13 |
|
| ... | 11:12:00 | 11:12:00 | ... | 14 |
|
| ... | 11:13:00 | 11:13:00 | ... | 15 |
|
| ... | 11:13:00 | 11:13:00 | ... | 16 |
|
| ... | 11:15:00 | 11:15:00 | ... | 17 |
|
| ... | 11:15:00 | 11:15:00 | ... | 18 |
|
| ... | 11:16:00 | 11:16:00 | ... | 19 |
|
| ... | 11:18:00 | 11:18:00 | ... | 20 |
|
| ... | 11:18:00 | 11:18:00 | ... | 21 |
|
| ... | 11:19:00 | 11:19:00 | ... | 22 |
|
| ... | 11:20:00 | 11:20:00 | ... | 23 |
|
| ... | 11:21:00 | 11:21:00 | ... | 24 |
|
| ... | 11:22:00 | 11:22:00 | ... | 25 |
|
| ... | 11:23:00 | 11:23:00 | ... | 26 |
|
| ... | 11:24:00 | 11:24:00 | ... | 27 |
|
| ... | 11:24:00 | 11:24:00 | ... | 28 |
|
| ... | 11:25:00 | 11:25:00 | ... | 29 |
|
| ... | 11:26:00 | 11:26:00 | ... | 30 |
|
| ... | 11:27:00 | 11:27:00 | ... | 31 |
|
| ... | 11:28:00 | 11:28:00 | ... | 32 |
|
| ... | 11:30:00 | 11:30:00 | ... | 33 |
|
| ... | 11:37:00 | 11:37:00 | ... | 34 |
|
| ... | 11:39:00 | 11:39:00 | ... | 35 |
|
| 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 | |
|---|---|---|---|---|
| hrtagdwj | Phillipers | 51.6866278151 | -0.37870271 | |
| hrtagdwm | The Gossamers | 51.6836888839 | -0.3781567343 | |
| hrtagdwp | The Gossamers Shops | 51.6811062401 | -0.3793194124 | |
| hrtgwtga | Garsmouth Way | 51.6791740949 | -0.3800537487 | |
| hrtagdwt | Widgeon Way | 51.6773204808 | -0.3786590591 | |
| hrtagjag | Douglas Avenue | 51.6752311484 | -0.3797316186 | |
| hrtagdpd | Woodmere Avenue | 51.6732452271 | -0.3817838308 | |
| hrtagdpj | Balmoral Road | 51.6686735756 | -0.3847810768 | |
| hrtagdpm | Balmoral Road | 51.66871211 | -0.3849676983 | |
| hrtagdpt | Hillrise Avenue | 51.672358144 | -0.383970296 | |
| hrtagdpw | Hibbert Avenue | 51.6713196495 | -0.3882300864 | |
| hrtagdta | Tudor Arms PH | 51.6733075237 | -0.3856575314 | |
| hrtagdgt | Raphael Drive | 51.6645606641 | -0.3871396618 | |
| hrtagdgw | Eastfield Avenue | 51.6697727542 | -0.3862459524 | |
| hrtadwjp | Watford Junction Railway Station | 51.6631592165 | -0.3964288182 | |
| hrtjdatm | Market Street | 51.655169635 | -0.3974047275 | |
| hrtadmtd | King Street | 51.6543032954 | -0.3945440203 | |
| hrtadmwj | Clarendon Road | 51.6581326184 | -0.3970833463 | |
| hrtadmjg | St John's Road | 51.6601826022 | -0.3970688463 | |
| hrtadmjw | Watford Junction Railway Station | 51.6632179861 | -0.3961231012 | |
| hrtadmdt | Reeds Crescent | 51.6619666134 | -0.3894439607 | |
| hrtadjdg | Hibbert Avenue | 51.6712864757 | -0.3884337282 | |
| hrtadjdm | Knutsford Avenue | 51.6704243187 | -0.3878569437 | |
| hrtadjdp | Eastfield Avenue | 51.6694780458 | -0.3850850705 | |
| hrtadgtp | Raphael Drive | 51.6648075543 | -0.3867838625 | |
| hrtadgwa | Reeds Crescent | 51.6618685418 | -0.3895052728 | |
| hrtadgpt | Tudor Arms PH | 51.673339699 | -0.3853816019 | |
| hrtadgta | Woodmere Avenue | 51.6725381641 | -0.3826767581 | |
| hrtadgtd | Douglas Avenue | 51.6751444627 | -0.3799661198 | |
| hrtadgtg | Widgeon Way | 51.6773694093 | -0.3789465856 | |
| hrtgwtdw | Garsmouth Way | 51.6792214253 | -0.3802256311 | |
| hrtjapam | York Way | 51.6811728888 | -0.3815446279 | |
| hrtjapap | The Pelhams | 51.6828659427 | -0.3817301729 | |
| hrtjapat | Tibbles Close | 51.6861392589 | -0.380441675 |