Watford - Kingswood - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:40:00	07:40:00	...	1
...	07:43:00	07:43:00	...	2
...	07:44:00	07:44:00	...	3
...	07:46:00	07:46:00	...	4
...	07:48:00	07:48:00	...	5
...	07:51:00	07:51:00	...	6
...	07:52:00	07:52:00	...	7
...	07:53:00	07:53:00	...	8
...	07:54:00	07:54:00	...	9
...	07:55:00	07:55:00	...	10
...	07:57:00	07:57:00	...	11
...	07:57:00	07:57:00	...	12
...	07:58:00	07:58:00	...	13
...	07:58:00	07:58:00	...	14
...	07:59:00	07:59:00	...	15
...	08:00:00	08:00:00	...	16
...	08:01:00	08:01:00	...	17
...	08:02:00	08:02:00	...	18
...	08:03:00	08:03:00	...	19
...	08:05:00	08:05:00	...	20
...	08:07:00	08:07:00	...	21
...	08:10:00	08:10:00	...	22
...	08:15:00	08:15:00	...	23

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
hrtadwjp	Watford Junction Railway Station	51.6631592165	-0.3964288182
hrtjdatm	Market Street	51.655169635	-0.3974047275
hrtadmwj	Clarendon Road	51.6581326184	-0.3970833463
hrtadmjg	St John's Road	51.6601826022	-0.3970688463
hrtadmdg	Railway Bridge	51.6660160546	-0.3988729222
hrtadjta	Regent Street	51.6701586268	-0.3973530368
hrtadgwd	Windsor Road	51.6734904022	-0.3963821579
hrtadgwg	Buckingham Road	51.6758909888	-0.3970205292
hrtadgpg	Bushey Mill Crescent	51.6779255724	-0.3958783668
hrtadgpm	Watford North Railway Station	51.6759489253	-0.3913922927
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
hrtadgtj	The Gossamers Shops	51.681224475	-0.3794164455
hrtadgjg	The Gossamers	51.6834202548	-0.378238661
hrtadgjm	Phillipers	51.6870909705	-0.3790333671
hrtadgjp	Garston Railway Station	51.6876175645	-0.3820092187
hrtadgjt	Park Parade	51.6894356254	-0.3860531765
hrtadgmd	Bus Garage	51.6915609176	-0.3856303479
hrtadgmp	Three Horseshoes PH West	51.6944388886	-0.3863237502
hrtadgmt	Francis Combe Academy	51.6971393436	-0.3924353207