Lanark - Glasgow - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:15:00	07:15:00	...	1
...	07:18:03	07:18:03	...	2
...	07:18:17	07:18:17	...	3
...	07:18:39	07:18:39	...	4
...	07:19:10	07:19:10	...	5
...	07:20:00	07:20:00	...	6
...	07:20:20	07:20:20	...	7
...	07:20:52	07:20:52	...	8
...	07:21:52	07:21:52	...	9
...	07:22:12	07:22:12	...	10
...	07:22:50	07:22:50	...	11
...	07:24:01	07:24:01	...	12
...	07:24:41	07:24:41	...	13
...	07:25:04	07:25:04	...	14
...	07:29:05	07:29:05	...	15
...	07:31:33	07:31:33	...	16
...	07:32:52	07:32:52	...	17
...	07:33:20	07:33:20	...	18
...	07:33:42	07:33:42	...	19
...	07:34:16	07:34:16	...	20
...	07:34:46	07:34:46	...	21
...	07:35:00	07:35:00	...	22

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
03/03/2018 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
75235453	Law Hospital	55.7587646432	-3.8602189928
75235979	Castlehill Road	55.7441216642	-3.8449606912
75235765	Castleknowe Gardens	55.7411857126	-3.842384796
75236294	Sandy Road	55.7383716826	-3.8412645728
75234853	Station Road	55.733814483	-3.8401261843
75235463	Hamilton Street	55.7321120944	-3.8391860403
75232592	Shieldhill Road	55.7298431792	-3.8364675399
75236847	Goremire Road	55.7252223582	-3.832365199
75236825	Goremire Road	55.7235744182	-3.832590535
75232635	Scotts Country Style	55.7202875605	-3.8324365556
75232434	Braidwood Road	55.7141477512	-3.8319579799
75232793	Beanshields Road	55.710816733	-3.8311494124
75236248	Cartland Road	55.6914070196	-3.8104339837
75232892	Craig Cottage	55.6804006661	-3.7992687797
75232983	Mousebank Road	55.6754135068	-3.7863171728
75232753	St Patricks Lane	55.6743481676	-3.7835651338
75236245	Hunters Close	55.6736662064	-3.7785407065
75235495	Bus Station	55.673076089	-3.7721212179
75234828	Meadow Road	55.708889513	-3.8302156382
75297942	Threave Court	55.743035721	-3.8436668184
75237986	Woodstock Street	55.6735609019	-3.7740196298
75248984	Lockhart Drive	55.6757829731	-3.7905643189