Hamilton - Glasgow via Bothwell - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:12:00	18:12:00	...	1
...	18:14:00	18:14:00	...	2
...	18:14:00	18:14:00	...	3
...	18:15:00	18:15:00	...	4
...	18:16:00	18:16:00	...	5
...	18:17:00	18:17:00	...	6
...	18:18:00	18:18:00	...	7
...	18:18:00	18:18:00	...	8
...	18:20:00	18:20:00	...	9
...	18:22:00	18:22:00	...	10
...	18:22:00	18:22:00	...	11
...	18:23:00	18:23:00	...	12
...	18:24:00	18:24:00	...	13
...	18:24:00	18:24:00	...	14
...	18:25:00	18:25:00	...	15
...	18:26:00	18:26:00	...	16
...	18:27:00	18:27:00	...	17
...	18:28:00	18:28:00	...	18
...	18:28:00	18:28:00	...	19
...	18:29:00	18:29:00	...	20
...	18:30:00	18:30:00	...	21
...	18:31:00	18:31: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