Carluke - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:05:00	17:05:00	...	1
...	17:05:05	17:05:05	...	2
...	17:05:59	17:05:59	...	3
...	17:20:00	17:20:00	...	4
...	17:25:34	17:25:34	...	5
...	17:26:12	17:26:12	...	6
...	17:26:48	17:26:48	...	7
...	17:27:29	17:27:29	...	8
...	17:28:00	17:28:00	...	9
...	17:29:07	17:29:07	...	10
...	17:29:16	17:29:16	...	11
...	17:29:55	17:29:55	...	12
...	17:30:24	17:30:24	...	13
...	17:31:00	17:31:00	...	14
...	17:34:37	17:34:37	...	15
...	17:35:27	17:35:27	...	16
...	17:36:13	17:36:13	...	17
...	17:36:35	17:36:35	...	18
...	17:37:00	17:37: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