Chichester - Westergate College - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:30:00	07:30:00	...	1
...	07:31:00	07:31:00	...	2
...	07:32:00	07:32:00	...	3
...	07:33:00	07:33:00	...	4
...	07:35:00	07:35:00	...	5
...	07:36:00	07:36:00	...	6
...	07:37:00	07:37:00	...	7
...	07:38:00	07:38:00	...	8
...	07:38:00	07:38:00	...	9
...	07:39:00	07:39:00	...	10
...	07:40:00	07:40:00	...	11
...	07:43:00	07:43:00	...	12
...	07:44:00	07:44:00	...	13
...	07:46:00	07:46:00	...	14
...	07:47:00	07:47:00	...	15
...	07:49:00	07:49:00	...	16
...	07:49:00	07:49:00	...	17
...	07:49:00	07:49:00	...	18
...	07:49:00	07:49:00	...	19
...	07:50:00	07:50:00	...	20
...	07:58:00	07:58:00	...	21
...	07:58:00	07:58:00	...	22
...	07:59:00	07:59:00	...	23
...	08:00:00	08:00:00	...	24
...	08:08:00	08:08:00	...	25
...	08:10:00	08:10:00	...	26

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
wsxagtwa	St Richard's Hospital Entrance	50.8416058541	-0.7724953843
wsxagwaj	Litten Terrace	50.8387218352	-0.7736078043
wsxagwdt	Chichester Park Hotel	50.8461301749	-0.7564392164
wsxagwga	Westhampnett Road	50.841459102	-0.7628553397
wsxajajt	Co-op	50.8515999197	-0.7159339798
wsxajajw	Nettleton Avenue	50.8530320184	-0.716136174
wsxajamg	Tamar Way	50.8506393736	-0.7160882036
wsxajamj	Oakwood Close	50.8519383305	-0.7131828678
wsxajamp	Hawker Close	50.8539664153	-0.7119763022
wsxajamt	Boxgrove Turning	50.8549927466	-0.7153435691
wsxajgjt	Bus Station	50.832074119	-0.7802857012
wsxajgpa	Market	50.8358908947	-0.7737814028
wsxajgpd	Market Avenue	50.8339160334	-0.7758354564
wsxdapga	Woodlands Farm	50.8563992352	-0.6233666815
wsxdapgj	Slindon Common	50.8602808701	-0.626136815
wsxdgmgt	Ormiston Six Villages Academy	50.8408989215	-0.6646991934
wsxdtwjg	Slindon Common	50.8583017422	-0.6322051036
wsxdtwjp	Mid Lane	50.86005786	-0.6278200177
wsxgpmag	Collins Close	50.8424807494	-0.6599100734
wsxdgpdm	Crossroads	50.8493811842	-0.7459401498
wsxdgpdw	Old Arundel Road	50.8518146136	-0.7405901766
wsxdgpga	Strettington Lane	50.8564108306	-0.7307057335
wsxdgpgj	Crossroads	50.8649143617	-0.712299939
wsxdgpgp	Priory Close	50.8575446079	-0.7127018099
wsxdgpgw	Primary School	50.8608181313	-0.7127111468
wsxgpadw	Rolls Royce	50.8507777961	-0.7428484274