Carluke - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	11:00:00	11:00:00	...	1
...	11:00:04	11:00:04	...	2
...	11:00:47	11:00:47	...	3
...	11:12:00	11:12:00	...	4
...	11:16:52	11:16:52	...	5
...	11:17:25	11:17:25	...	6
...	11:17:57	11:17:57	...	7
...	11:18:33	11:18:33	...	8
...	11:19:00	11:19:00	...	9
...	11:20:07	11:20:07	...	10
...	11:20:16	11:20:16	...	11
...	11:20:55	11:20:55	...	12
...	11:21:24	11:21:24	...	13
...	11:22:00	11:22:00	...	14
...	11:25:37	11:25:37	...	15
...	11:26:27	11:26:27	...	16
...	11:27:13	11:27:13	...	17
...	11:27:35	11:27:35	...	18
...	11:28:00	11:28:00	...	19

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

stop_code	stop_name	stop_lat	stop_lon
75235743	Buchanan Drive	55.7536000005	-3.8783465126
75236473	Brackenhill Road	55.7521009023	-3.8805849827
75235473	Shawfield Crescent	55.7505370883	-3.8841108288
75236826	Shawfield Crescent	55.7505528506	-3.8842549961
75232474	Braefoot Court	55.7479575773	-3.8811981716
75232586	Quarry Road	55.7438294708	-3.879055845
75232846	Burton Lane	55.7352890982	-3.8406734199
75235486	Station Road	55.7499725579	-3.8840039389
75235823	Manse Court	55.7460547891	-3.8804533543
75248787	Bus Station	55.7737909047	-4.0386290345
75298264	The Beeches	55.738593601	-3.9252540444
75237976	Kirkton Avenue	55.7347990169	-3.8433898894
75237982	Kirk Road	55.7355116417	-3.8456056069
75237985	Clyde Court	55.7371411601	-3.8501903116
75237897	Pillans Avenue	55.7385616363	-3.855514156
75243829	Leechlee Road	55.7740959286	-4.0392030133
75265486	Bourne Street	55.7762540588	-4.0320766559
75298989	Blueknowes Road	55.7476480379	-3.8908227069
75238623	Blueknowes Road	55.7488722628	-3.8871853805