PRESTON - PRESTON - Transport Data Hub

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

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
lanadmdp	Lane Ends Booths	53.7712522813	-2.7286557856
lanadpaw	Ingol Shops	53.780859735	-2.7419950181
lanagjdp	53 Degrees	53.7634345002	-2.7088453197
lanagwgm	The Avenue	53.7885235126	-2.7410526056
lanagwjd	Cottam Hall Lane	53.7840409249	-2.7449955263
lanagwjm	The Coppice	53.7792339909	-2.7374440635
landapda	Threefields	53.7849542732	-2.7412021707
landapdj	Hillcrest Avenue	53.7797303647	-2.7400326154
landgtwp	Carlton Street	53.7648665881	-2.7174102605
landgwmg	Hope Street	53.7618430493	-2.7058908741
landgwmw	Hill Street	53.7603280487	-2.7036811885
landgwpg	Ring Way	53.7609451358	-2.7011431578
landmwgw	Drakes Croft	53.7753442886	-2.7297433416
landpama	Lane Ends	53.7702245524	-2.7276821375
landtadp	The Guild	53.7646658441	-2.7118849176
langmdpm	The Guild Merchant	53.7894891784	-2.7476573578
langmdpt	Bowling Field	53.7892570904	-2.7445111739
langmdwa	Cadley Causeway	53.7775395133	-2.732345973
langmpgd	Water Lane	53.7652288195	-2.7214517419
langmtgm	Fazackerley Street	53.7677005369	-2.7259241269
langmtmw	Bus Station	53.7615047461	-2.6961163907