Glasgow - Largs - Transport Data Hub

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