Bolton - Sharples - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
MANWADTJ	Bolton Interchange	53.575503453	-2.4275146446
MANJWDPD	Market Hall	53.5806519637	-2.4305269899
MANJWGAP	Mackenzie Street	53.6044279401	-2.4423449953
MANJWGDW	Waterside Gardens	53.5958888927	-2.4250310749
MANJWGMD	Slater Street	53.5857787777	-2.4295670366
MANJWGTJ	Three Pigeons	53.6015604156	-2.4325832867
MANJWGTP	Waters Meeting Road	53.5898652841	-2.4304545076
MANJWGWM	Greenwood Vale	53.597704346	-2.4326043096
MANJWGWP	ASDA	53.5994385378	-2.4327580337
MANPADWG	Logan Street	53.6038572668	-2.4362034738
MANPADWM	Miller Street	53.6031950145	-2.4378740747
MANPAGAG	Barlow Park Avenue	53.6047322595	-2.4451137681
MANPAGAM	Turning Circle	53.6059863523	-2.4462604349
MANPAWDM	Blue Boar	53.5793728332	-2.4312993658
MANPAWDP	Knowsley Street	53.5819203085	-2.4302529024
MANPAWGP	Post Office	53.5790356387	-2.4325797161
MANPDMAP	Westminster Road	53.6038814584	-2.4344960433
MANPDPDG	Job Centre	53.577193748	-2.4323796704
MANPDPMG	Waters Meeting Rd	53.5954605665	-2.4316899315
MANPDPMP	Ullswater St	53.5933949057	-2.4312307177
MANPDPMW	Draycott St	53.5914100256	-2.430802587
MANPGAPA	Heywood Street	53.5847551737	-2.4292696489