PRESTON - PRESTON - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	23:30:00	23:30:00	...	1
...	23:32:00	23:32:00	...	2
...	23:33:00	23:33:00	...	3
...	23:34:00	23:34:00	...	4
...	23:34:00	23:34:00	...	5
...	23:35:00	23:35:00	...	6
...	23:36:00	23:36:00	...	7
...	23:37:00	23:37:00	...	8
...	23:38:00	23:38:00	...	9
...	23:39:00	23:39:00	...	10
...	23:40:00	23:40:00	...	11
...	23:40:00	23:40:00	...	12
...	23:41:00	23:41:00	...	13
...	23:42:00	23:42:00	...	14
...	23:42:00	23:42:00	...	15
...	23:43:00	23:43:00	...	16
...	23:44:00	23:44:00	...	17
...	23:45:00	23:45:00	...	18
...	23:46:00	23:46:00	...	19
...	23:47:00	23:47:00	...	20

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
landmwgw	Drakes Croft	53.7753442886	-2.7297433416
landpama	Lane Ends	53.7702245524	-2.7276821375
landptpd	Boots	53.7581866961	-2.6994439092
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