Carluke - Hamilton - Transport Data Hub

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