Carluke - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:23:00	08:23:00	...	1
...	08:23:38	08:23:38	...	2
...	08:24:19	08:24:19	...	3
...	08:24:34	08:24:34	...	4
...	08:25:03	08:25:03	...	5
...	08:25:34	08:25:34	...	6
...	08:26:11	08:26:11	...	7
...	08:29:24	08:29:24	...	8
...	08:29:52	08:29:52	...	9
...	08:30:17	08:30:17	...	10
...	08:30:54	08:30:54	...	11
...	08:31:01	08:31:01	...	12
...	08:31:34	08:31:34	...	13
...	08:32:00	08:32:00	...	14
...	08:33:09	08:33:09	...	15
...	08:33:46	08:33:46	...	16
...	08:34:23	08:34:23	...	17
...	08:40:00	08:40:00	...	18
...	08:56:11	08:56:11	...	19
...	08:57:00	08:57:00	...	20

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
75232454	Manse Court	55.7458919267	-3.880525179
75232838	Castleknowe Gardens	55.7412894178	-3.8426604977
75235935	Kirk Road	55.7382527894	-3.8414023337
75232846	Burton Lane	55.7352890982	-3.8406734199
75232963	Station Road	55.7500390264	-3.88435769
75248787	Bus Station	55.7737909047	-4.0386290345
75262726	Avon Avenue	55.7382801198	-3.8497504168
75265752	Hemmingen Court	55.7402562985	-3.8474225976
75238572	Allan Avenue	55.7418194414	-3.8444696926
75234936	Miller Street	55.7733809508	-4.032453251
75237898	Pillans Avenue	55.7382025787	-3.8548918115
75239476	Stravenhouse Road	55.7438796987	-3.8792972307
75258737	Birks Road	55.7475878726	-3.8906445334
75278632	Carmichael Street	55.7488120922	-3.8870072069
75256858	Braefoot Court	55.7478036947	-3.8812704288
75234292	Cornsilloch Cottage	55.7385649144	-3.9253641373