Watford & Meriden Circular
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:25:00 | 14:25:00 | ... | 1 |
|
| ... | 14:28:00 | 14:28:00 | ... | 2 |
|
| ... | 14:29:00 | 14:29:00 | ... | 3 |
|
| ... | 14:32:00 | 14:32:00 | ... | 4 |
|
| ... | 14:34:00 | 14:34:00 | ... | 5 |
|
| ... | 14:35:00 | 14:35:00 | ... | 6 |
|
| ... | 14:37:00 | 14:37:00 | ... | 7 |
|
| ... | 14:37:00 | 14:37:00 | ... | 8 |
|
| ... | 14:38:00 | 14:38:00 | ... | 9 |
|
| ... | 14:40:00 | 14:40:00 | ... | 10 |
|
| ... | 14:41:00 | 14:41:00 | ... | 11 |
|
| ... | 14:41:00 | 14:41:00 | ... | 12 |
|
| ... | 14:42:00 | 14:42:00 | ... | 13 |
|
| ... | 14:42:00 | 14:42:00 | ... | 14 |
|
| ... | 14:43:00 | 14:43:00 | ... | 15 |
|
| ... | 14:43:00 | 14:43:00 | ... | 16 |
|
| ... | 14:45:00 | 14:45:00 | ... | 17 |
|
| ... | 14:45:00 | 14:45:00 | ... | 18 |
|
| ... | 14:46:00 | 14:46:00 | ... | 19 |
|
| ... | 14:48:00 | 14:48:00 | ... | 20 |
|
| ... | 14:48:00 | 14:48:00 | ... | 21 |
|
| ... | 14:49:00 | 14:49:00 | ... | 22 |
|
| ... | 14:49:00 | 14:49:00 | ... | 23 |
|
| ... | 14:50:00 | 14:50:00 | ... | 24 |
|
| ... | 14:51:00 | 14:51:00 | ... | 25 |
|
| ... | 14:52:00 | 14:52:00 | ... | 26 |
|
| ... | 14:56:00 | 14:56:00 | ... | 27 |
|
| ... | 14:57:00 | 14:57:00 | ... | 28 |
|
| 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 | |
| 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 | |
| hrtadmtm | High Street | 51.6553150414 | -0.3961996977 | |
| hrtadmwj | Clarendon Road | 51.6581326184 | -0.3970833463 | |
| hrtadmjg | St John's Road | 51.6601826022 | -0.3970688463 | |
| hrtadmdt | Reeds Crescent | 51.6619666134 | -0.3894439607 | |
| hrtadjdg | Hibbert Avenue | 51.6712864757 | -0.3884337282 | |
| hrtadgpt | Tudor Arms PH | 51.673339699 | -0.3853816019 | |
| hrtadgpw | Radlett Road | 51.6714054928 | -0.3833534191 | |
| 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 |