Carluke - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:29:00	15:29:00	...	1
...	15:29:38	15:29:38	...	2
...	15:30:19	15:30:19	...	3
...	15:30:34	15:30:34	...	4
...	15:31:03	15:31:03	...	5
...	15:31:34	15:31:34	...	6
...	15:32:11	15:32:11	...	7
...	15:35:24	15:35:24	...	8
...	15:35:52	15:35:52	...	9
...	15:36:17	15:36:17	...	10
...	15:36:54	15:36:54	...	11
...	15:37:01	15:37:01	...	12
...	15:37:34	15:37:34	...	13
...	15:38:00	15:38:00	...	14
...	15:39:00	15:39:00	...	15
...	15:39:33	15:39:33	...	16
...	15:40:05	15:40:05	...	17
...	15:45:00	15:45:00	...	18
...	15:57:22	15:57:22	...	19
...	15:58:00	15:58: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