Hamilton - Glasgow via Bothwell - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:41:00	08:41:00	...	1
...	08:43:00	08:43:00	...	2
...	08:43:00	08:43:00	...	3
...	08:44:00	08:44:00	...	4
...	08:45:00	08:45:00	...	5
...	08:46:00	08:46:00	...	6
...	08:47:00	08:47:00	...	7
...	08:47:00	08:47:00	...	8
...	08:49:00	08:49:00	...	9
...	08:51:00	08:51:00	...	10
...	08:52:00	08:52:00	...	11
...	08:54:00	08:54:00	...	12
...	08:54:00	08:54:00	...	13
...	08:55:00	08:55:00	...	14
...	08:56:00	08:56:00	...	15
...	08:57:00	08:57:00	...	16
...	08:58:00	08:58:00	...	17
...	09:00:00	09:00:00	...	18
...	09:00:00	09:00:00	...	19
...	09:01:00	09:01:00	...	20
...	09:02:00	09:02:00	...	21
...	09:03:00	09:03:00	...	22

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

stop_code	stop_name	stop_lat	stop_lon
75248787	Bus Station	55.7737909047	-4.0386290345
75237946	Blantyre Road	55.8066429719	-4.0732989679
75236876	Auchingramont Road	55.7769754054	-4.0373602597
75236858	Muirhill Court	55.7781336628	-4.0412158496
75239239	Caird Street	55.7820797604	-4.0465733048
75234759	St Andrews Avenue	55.8003801382	-4.0646852844
75236359	Griqua Terrace	55.8024875671	-4.0670945269
75234392	Blantyre Road	55.8050502797	-4.0712834746
75236429	Woodlands Avenue	55.8085866203	-4.0752854349
75235279	Woodlands Gardens	55.8108698215	-4.0773859537
75232723	Hornal Road	55.8133111759	-4.080229342
75235856	Douglas Gardens	55.8157731914	-4.0813184325
75235343	Church Street	55.8188223419	-4.0822315222
75234858	Lower Mill Gate	55.821351843	-4.0835799309
75236985	Station Road	55.8235287124	-4.0850533326
75235727	Belmont Avenue	55.8255655078	-4.0873655737
75232542	New Edinburgh Road	55.8276846943	-4.0895866815
75236892	May Street	55.7850445252	-4.0493284489
75237264	The Paddock	55.7880266499	-4.0521168321
75237257	Hamilton Park Racecourse	55.7907348811	-4.0546200531
75234232	Training Centre	55.7940547987	-4.0565496903
75236292	Arthur Street	55.7807701948	-4.0453404985