PRESTON - PRESTON - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:46:00	08:46:00	...	1
...	08:47:00	08:47:00	...	2
...	08:47:00	08:47:00	...	3
...	08:48:00	08:48:00	...	4
...	08:49:00	08:49:00	...	5
...	08:49:00	08:49:00	...	6
...	08:50:00	08:50:00	...	7
...	08:51:00	08:51:00	...	8
...	08:51:00	08:51:00	...	9
...	08:52:00	08:52:00	...	10
...	08:53:00	08:53:00	...	11
...	08:54:00	08:54:00	...	12
...	08:54:00	08:54:00	...	13
...	08:55:00	08:55:00	...	14
...	08:56:00	08:56:00	...	15
...	08:57:00	08:57:00	...	16
...	08:58:00	08:58:00	...	17
...	08:58:00	08:58:00	...	18
...	08:59:00	08:59:00	...	19
...	09:00:00	09:00:00	...	20
...	09:00:00	09:00:00	...	21
...	09:05:00	09:05:00	...	22

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
03/09/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
lanagmjt	53 Degrees	53.7636592728	-2.708833937
lanagwgm	The Avenue	53.7885235126	-2.7410526056
lanagwjg	Dovedale Avenue	53.7817896131	-2.7427854206
lanajptp	Maudland Bank	53.7648590572	-2.7126466959
lanamgdw	Kidsgrove	53.7864487593	-2.7466015323
lanamjtd	Cottam Hall Lane	53.7838186961	-2.744596985
lanatwgw	Oaktree Ave	53.7798043232	-2.739700054
landapda	Threefields	53.7849542732	-2.7412021707
landapdw	Mayfield Ave	53.7793587534	-2.7361563401
landapga	Cadley Causeway	53.7776153961	-2.7316947783
landgtgj	Lane Ends	53.7713878282	-2.7285367535
landgtwt	Carlton Street	53.7650370744	-2.7174586785
landgwmj	Walker Street	53.7619339945	-2.7057103705
landgwmp	Heatley Street	53.7607212641	-2.7040669815
landgwpa	Ring Way	53.7614341775	-2.7005142122
landmwtw	Drakes Croft	53.7750945849	-2.729420357
landpajw	Lane Ends	53.7703338731	-2.7274412742
langmdpm	The Guild Merchant	53.7894891784	-2.7476573578
langmdpt	Bowling Field	53.7892570904	-2.7445111739
langmpgw	Water Lane	53.7653031827	-2.7210434178
langmtgj	Fazackerley Street	53.7678458951	-2.7256687239
langmtmw	Bus Station	53.7615047461	-2.6961163907