Carluke - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:50:00	07:50:00	...	1
...	07:50:04	07:50:04	...	2
...	07:50:47	07:50:47	...	3
...	08:02:00	08:02:00	...	4
...	08:06:52	08:06:52	...	5
...	08:07:25	08:07:25	...	6
...	08:07:57	08:07:57	...	7
...	08:08:33	08:08:33	...	8
...	08:09:00	08:09:00	...	9
...	08:10:15	08:10:15	...	10
...	08:10:24	08:10:24	...	11
...	08:11:07	08:11:07	...	12
...	08:11:40	08:11:40	...	13
...	08:12:20	08:12:20	...	14
...	08:16:21	08:16:21	...	15
...	08:17:17	08:17:17	...	16
...	08:18:08	08:18:08	...	17
...	08:18:32	08:18:32	...	18
...	08:19:00	08:19: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