St Helens - St Helens - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:43:00	08:43:00	...	1
...	08:44:00	08:44:00	...	2
...	08:45:00	08:45:00	...	3
...	08:47:00	08:47:00	...	4
...	08:48:00	08:48:00	...	5
...	08:49:00	08:49:00	...	6
...	08:51:00	08:51:00	...	7
...	08:52:00	08:52:00	...	8
...	08:54:00	08:54:00	...	9
...	08:54:00	08:54:00	...	10
...	08:54:00	08:54:00	...	11
...	08:54:00	08:54:00	...	12
...	08:55:00	08:55:00	...	13
...	08:55:00	08:55:00	...	14
...	08:55:00	08:55:00	...	15
...	08:56:00	08:56:00	...	16
...	08:56:00	08:56:00	...	17
...	08:57:00	08:57:00	...	18
...	08:57:00	08:57:00	...	19
...	08:57:00	08:57:00	...	20
...	08:58:00	08:58:00	...	21
...	08:58:00	08:58:00	...	22
...	08:59:00	08:59:00	...	23
...	09:00:00	09:00:00	...	24
...	09:04:00	09:04:00	...	25
...	09:07:00	09:07:00	...	26
...	09:10:00	09:10:00	...	27
...	09:11:00	09:11:00	...	28
...	09:13:00	09:13:00	...	29
...	09:13:00	09:13:00	...	30
...	09:14:00	09:14:00	...	31
...	09:15:00	09:15:00	...	32
...	09:15:00	09:15:00	...	33
...	09:16:00	09:16:00	...	34
...	09:17:00	09:17:00	...	35
...	09:18:00	09:18:00	...	36
...	09:18:00	09:18:00	...	37

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
01/12/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
meradpmw	Langtree Street	53.4528443373	-2.7214303977
meradpta	Traverse Street	53.4531288522	-2.7219472226
meradptd	Johnson Street	53.4549101607	-2.7187095361
meradptg	Pocket Nook Street	53.4543908754	-2.7198603316
meradptj	Blackhorse Street	53.4558402126	-2.7165114528
meradptm	Merton Bank Road	53.4556907134	-2.7174577004
meradptp	Mulcrow Close	53.457041843	-2.7124804845
meradptw	Mulcrow Close	53.4572406519	-2.71230309
meradpwa	Boardmans Lane	53.4590176266	-2.7082362672
meradpwd	Blackbrook Road	53.4582837188	-2.7092180543
meradtgd	Hunter Street	53.4460751573	-2.7230320858
meradtgp	Manville Street	53.442855468	-2.7218332013
meradtgw	St Helens Hospital	53.440307122	-2.7210974939
meragdjp	Longridge Avenue	53.4620093058	-2.7084969427
	Longridge Avenue	53.4622075728	-2.7084098726
	Ashurst Drive	53.4612565654	-2.7081078629
	Ashurst Drive	53.4611772822	-2.7078354326
	Ashurst Drive	53.463344874	-2.712149242
	Parold Avenue	53.4628157644	-2.7134508023
meragmat	St Helens Retail Park	53.4487987703	-2.7245088018
meragmdj	Billinge Crescent	53.4632750628	-2.7087740864
	Longridge Avenue	53.4620901512	-2.7100195533
	Parbold Avenue	53.4618573904	-2.7143836312
	Singleton Avenue	53.4610618907	-2.7136322509
	Ashurst Drive	53.4647629195	-2.7094917754
merajdpm	Bickerstaffe Street	53.4530797862	-2.7329544091
mergjtwg	Bickerstaffe Street	53.4530537469	-2.7328033721
merajdpw	St Helens Central Station	53.4534782558	-2.7310036032
merajdta	St Helens Central Station	53.4532967879	-2.7298108305
merajdtd	Phoenix Brow	53.4531428266	-2.7270524162
merajdtg	Phoenix Brow	53.4529729759	-2.7268989261
mergjtwm	St Marys Market	53.450535531	-2.7344916746
mergjwad	Todd Road	53.4515130079	-2.7289972077
merajdtm	Baldwin Street	53.4539185792	-2.738329916
merajgaj	Parr Street	53.4511525837	-2.7261902143
merajgmt	Exchange Street	53.451469447	-2.7390102218
mergjwaw	Market Street	53.4512417535	-2.7365818961