Glasgow - Largs - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:25:00	17:25:00	...	1
...	17:26:30	17:26:30	...	2
...	17:27:40	17:27:40	...	3
...	17:28:25	17:28:25	...	4
...	17:29:39	17:29:39	...	5
...	17:30:09	17:30:09	...	6
...	17:30:57	17:30:57	...	7
...	17:31:32	17:31:32	...	8
...	17:32:16	17:32:16	...	9
...	17:32:43	17:32:43	...	10
...	17:33:33	17:33:33	...	11
...	17:35:03	17:35:03	...	12
...	17:35:58	17:35:58	...	13
...	17:36:35	17:36:35	...	14
...	17:37:00	17:37:00	...	15
...	17:37:11	17:37:11	...	16
...	17:37:34	17:37:34	...	17
...	18:01:20	18:01:20	...	18
...	18:02:00	18:02:00	...	19
...	18:15:00	18:15:00	...	20
...	18:16:43	18:16:43	...	21
...	18:19:33	18:19:33	...	22
...	18:20:49	18:20:49	...	23
...	18:23:00	18:23:00	...	24

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

stop_code	stop_name	stop_lat	stop_lon
45242327	Cathedral Street	55.8625515871	-4.2497668956
45235639	Blythswood Street	55.861537786	-4.2633879622
45234765	Waterloo Lane	55.8611275209	-4.2593049724
45238952	Buchanan Bus Station	55.8652655367	-4.2517458503
45242643	Dundas Street	55.8619330974	-4.2526237074
46823274	Coronation Park	55.934958128	-4.6858904716
46823258	Lower Mary Street	55.935795345	-4.7010331577
46824378	Bogston station	55.9374056628	-4.7107858586
46823589	Pottery Street	55.9399867668	-4.718061058
46823642	Ladyburn Street	55.9412738224	-4.7224595392
46823942	Ratho Street	55.9435048945	-4.7308968842
46823729	Clyde Port Authority	55.9441550725	-4.7340019485
46823974	Knowe Road	55.9436384429	-4.7422783253
46823739	Victoria Quay	55.9445829338	-4.7470862662
46824259	Terrace Road	55.9474611268	-4.7530408702
46824393	Sinclair Street	55.9422208561	-4.7259695295
46823967	Gibshill Road	55.9392027772	-4.7152995758
46823743	Bus Station	55.935572716	-4.6882069259
46858624	Fire Station	55.9340033667	-4.6806202356
46824548	Bus Station	55.9488594258	-4.7628478097
46824387	Jean Street	55.9350468605	-4.6949920984
46824295	Water Street	55.9354042397	-4.6909815676
73926498	Bus Station	55.8752473419	-4.3612258401
73924856	Rocep Drive	55.8723427755	-4.3687866247