ROYAL PRESTON HOSPITAL - RPH - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:23:00	08:23:00	...	1
...	08:24:00	08:24:00	...	2
...	08:25:00	08:25:00	...	3
...	08:29:00	08:29:00	...	4
...	08:30:00	08:30:00	...	5
...	08:31:00	08:31:00	...	6
...	08:31:00	08:31:00	...	7
...	08:32:00	08:32:00	...	8
...	08:33:00	08:33:00	...	9
...	08:34:00	08:34:00	...	10
...	08:35:00	08:35:00	...	11
...	08:37:00	08:37:00	...	12

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

stop_code	stop_name	stop_lat	stop_lon
lanadmjt	Booths	53.7919545785	-2.707231423
lanagmdj	Preston College	53.7864714315	-2.6980931033
lanamjtg	Post Office	53.7784148236	-2.6986422165
lanaptja	St Vincents Road	53.7872862698	-2.6986226963
landgjdm	St Clares Church	53.7902224273	-2.7022082804
landgjmp	Lulworth Road	53.7808638814	-2.6979089385
landpadp	Royal Preston Hospital Grounds	53.7918038073	-2.7053617593
landpjtw	St Clare's Church	53.7903825978	-2.7024841851
landpmdg	Lulworth Road	53.7814825036	-2.6981772021
landpmdm	Fairfield Road	53.7801077984	-2.698093672
lanpapdj	Preston Business Centre	53.7797107248	-2.6999081417