Lanark - Hamilton - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	07:20:00	07:20:00	...	1
...	07:21:15	07:21:15	...	2
...	07:24:46	07:24:46	...	3
...	07:25:02	07:25:02	...	4
...	07:25:27	07:25:27	...	5
...	07:26:02	07:26:02	...	6
...	07:27:00	07:27:00	...	7
...	07:27:26	07:27:26	...	8
...	07:28:07	07:28:07	...	9
...	07:29:24	07:29:24	...	10
...	07:29:49	07:29:49	...	11
...	07:30:38	07:30:38	...	12
...	07:32:09	07:32:09	...	13
...	07:33:00	07:33:00	...	14
...	07:33:31	07:33:31	...	15
...	07:38:59	07:38:59	...	16
...	07:42:20	07:42:20	...	17
...	07:44:06	07:44:06	...	18
...	07:44:45	07:44:45	...	19
...	07:45:14	07:45:14	...	20
...	07:46:00	07:46:00	...	21
...	07:46:41	07:46:41	...	22
...	07:47:00	07:47:00	...	23

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

stop_code	stop_name	stop_lat	stop_lon
75232549	Hyndshaw Road	55.7641058539	-3.8653509075
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