Hitchin - Sandridge - St Albans - Colney Heath / Welham Green
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 15:50:00 | 15:50:00 | ... | 1 |
|
| ... | 15:50:00 | 15:50:00 | ... | 2 |
|
| ... | 15:51:00 | 15:51:00 | ... | 3 |
|
| ... | 15:52:00 | 15:52:00 | ... | 4 |
|
| ... | 15:54:00 | 15:54:00 | ... | 5 |
|
| ... | 15:55:00 | 15:55:00 | ... | 6 |
|
| ... | 15:59:00 | 15:59:00 | ... | 7 |
|
| ... | 16:00:00 | 16:00:00 | ... | 8 |
|
| ... | 16:02:00 | 16:02:00 | ... | 9 |
|
| ... | 16:05:00 | 16:05:00 | ... | 10 |
|
| ... | 16:05:00 | 16:05:00 | ... | 11 |
|
| ... | 16:06:00 | 16:06:00 | ... | 12 |
|
| ... | 16:08:00 | 16:08:00 | ... | 13 |
|
| ... | 16:09:00 | 16:09:00 | ... | 14 |
|
| ... | 16:10:00 | 16:10:00 | ... | 15 |
|
| ... | 16:13:00 | 16:13:00 | ... | 16 |
|
| ... | 16:14:00 | 16:14:00 | ... | 17 |
|
| ... | 16:15:00 | 16:15:00 | ... | 18 |
|
| ... | 16:18:00 | 16:18:00 | ... | 19 |
|
| ... | 16:19:00 | 16:19:00 | ... | 20 |
|
| ... | 16:21:00 | 16:21:00 | ... | 21 |
|
| ... | 16:21:00 | 16:21:00 | ... | 22 |
|
| ... | 16:24:00 | 16:24:00 | ... | 23 |
|
| ... | 16:27:00 | 16:27:00 | ... | 24 |
|
| ... | 16:28:00 | 16:28:00 | ... | 25 |
|
| ... | 16:28:00 | 16:28:00 | ... | 26 |
|
| ... | 16:29:00 | 16:29:00 | ... | 27 |
|
| ... | 16:30:00 | 16:30:00 | ... | 28 |
|
| ... | 16:32:00 | 16:32:00 | ... | 29 |
|
| ... | 16:33:00 | 16:33:00 | ... | 30 |
|
| ... | 16:33:00 | 16:33:00 | ... | 31 |
|
| ... | 16:34:00 | 16:34:00 | ... | 32 |
|
| ... | 16:36:00 | 16:36:00 | ... | 33 |
|
| ... | 16:37:00 | 16:37:00 | ... | 34 |
|
| ... | 16:38:00 | 16:38:00 | ... | 35 |
|
| ... | 16:38:00 | 16:38:00 | ... | 36 |
|
| ... | 16:38:00 | 16:38:00 | ... | 37 |
|
| ... | 16:39:00 | 16:39:00 | ... | 38 |
|
| ... | 16:40:00 | 16:40:00 | ... | 39 |
|
| ... | 16:44:00 | 16:44:00 | ... | 40 |
|
| ... | 16:45:00 | 16:45:00 | ... | 41 |
|
| ... | 16:45:00 | 16:45:00 | ... | 42 |
|
| ... | 16:46:00 | 16:46:00 | ... | 43 |
|
| ... | 16:47:00 | 16:47:00 | ... | 44 |
|
| ... | 16:48:00 | 16:48:00 | ... | 45 |
|
| ... | 16:50:00 | 16:50:00 | ... | 46 |
|
| ... | 16:51:00 | 16:51:00 | ... | 47 |
|
| ... | 16:53:00 | 16:53:00 | ... | 48 |
|
| ... | 16:57:00 | 16:57:00 | ... | 49 |
|
| ... | 17:00:00 | 17:00:00 | ... | 50 |
|
| 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 | |
|---|---|---|---|---|
| hrtgjgpt | Crossroads | 51.9193934524 | -0.2604989777 | |
| hrtgjgpw | The Rusty Gun PH | 51.9125235061 | -0.2568388385 | |
| hrtgjgjp | Stagenhoe Lodges | 51.890878977 | -0.265276931 | |
| hrtgjgjt | Strathmore Arms PH | 51.8860177947 | -0.2667282759 | |
| hrtgjdwj | South Lodge | 51.8812376824 | -0.2681907084 | |
| hrtgjdwm | War Memorial | 51.8742965407 | -0.2755756338 | |
| hrtgjdwp | The Maidens Head PH | 51.8760533592 | -0.280723819 | |
| hrtgjdwt | King George's Way | 51.8741835979 | -0.2856907192 | |
| hrtgjgad | Strathmore Road | 51.8730779921 | -0.2881877593 | |
| hrtgjgag | Hitchin Road Footpath | 51.8608935377 | -0.2924842702 | |
| hrtgjgaj | The White Horse PH | 51.8514162688 | -0.2924945293 | |
| hrtgjgam | The Boot PH | 51.85100949 | -0.2960671951 | |
| hrtgjgap | Lloyd Way | 51.8506526262 | -0.3012350413 | |
| hrtgjgat | Luton Road | 51.8491314067 | -0.306112576 | |
| hrtgjdpw | The Broadway | 51.8356259281 | -0.3005233318 | |
| hrtgjdta | Beech Way | 51.8387858714 | -0.3026542569 | |
| hrtgjdtd | The Lodge | 51.8447952753 | -0.3040977325 | |
| hrtgjdjg | Grammar School Walk | 51.9498086104 | -0.2804218478 | |
| hrtgjdjm | Waitrose | 51.9507021184 | -0.282497663 | |
| hrtgdwdp | ASDA | 51.9453286687 | -0.2765919559 | |
| hrtadatp | St Mary's Square | 51.9478741202 | -0.2754176206 | |
| hrtgdtpa | Lister Avenue | 51.9394087866 | -0.2732982067 | |
| hrtgdtpd | Newlands Lane | 51.9377135773 | -0.271748521 | |
| hrtgdtpg | New England Close | 51.9367111627 | -0.2708414747 | |
| hrtgdtpj | London Road Crossroads | 51.9288993991 | -0.2648730009 | |
| hrtgdpwt | Bancroft | 51.9492709705 | -0.2774739628 | |
| hrtgdpjt | Wellingham Avenue | 51.9602520851 | -0.2862516859 | |
| hrtgdpjw | Angel's Reply PH | 51.9580818363 | -0.2860288114 | |
| hrtgdpma | Fishponds Road | 51.9546411583 | -0.2850103377 | |
| hrtgagwt | The Priory School | 51.9626401921 | -0.2847632723 | |
| hrtdagta | The Slype | 51.8329359604 | -0.2979395753 | |
| hrtdagtd | Lamer Park | 51.8278362651 | -0.294126506 | |
| hrtdagtg | Lamer Lodge | 51.821798932 | -0.2907705715 | |
| hrtdagtj | Garden Court | 51.8168129922 | -0.2923230418 | |
| hrtdagtm | St Helen's Church | 51.8123369692 | -0.2936963217 | |
| hrtdagmj | Walnut Court | 51.8090048975 | -0.2939672181 | |
| hrtdagmp | Hill Dyke Road | 51.805695157 | -0.2939181179 | |
| hrtdagmt | The Wicked Lady PH | 51.7999608026 | -0.2965710954 | |
| hrtdagpa | Langley Grove | 51.783861046 | -0.3031217169 | |
| hrtdagpd | St Leonard's Church | 51.7814374635 | -0.3046623568 | |
| hrtdagdm | Village Hall | 51.7788679505 | -0.307310009 | |
| hrtdagdp | Reynolds Crescent | 51.7767232682 | -0.3101154308 | |
| hrtdagdw | Sandringham Crescent | 51.7727170687 | -0.3160482928 | |
| hrtdagja | Sandridge Gate Business Centre | 51.7696372953 | -0.3188731586 | |
| hrtdadgt | Lancaster Road | 51.7651191985 | -0.3236204216 | |
| hrtdadja | Seymour Road | 51.7629375402 | -0.3263820904 | |
| hrtdadjd | Boundary Road | 51.760763154 | -0.3290272976 | |
| hrtdadjg | Chime Square | 51.756969352 | -0.3341516271 | |
| hrtawtdw | St Peter's Street | 51.7539142338 | -0.3368429467 | |
| hrtjampg | St Helens School | 51.8107203622 | -0.293829909 |