Glasgow - Largs - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	09:55:00	09:55:00	...	1
...	09:56:30	09:56:30	...	2
...	09:57:40	09:57:40	...	3
...	09:58:25	09:58:25	...	4
...	09:59:39	09:59:39	...	5
...	10:00:09	10:00:09	...	6
...	10:00:57	10:00:57	...	7
...	10:01:32	10:01:32	...	8
...	10:02:16	10:02:16	...	9
...	10:02:43	10:02:43	...	10
...	10:03:33	10:03:33	...	11
...	10:05:03	10:05:03	...	12
...	10:05:58	10:05:58	...	13
...	10:06:35	10:06:35	...	14
...	10:07:00	10:07:00	...	15
...	10:07:11	10:07:11	...	16
...	10:07:34	10:07:34	...	17
...	10:31:20	10:31:20	...	18
...	10:32:00	10:32:00	...	19
...	10:45:00	10:45:00	...	20
...	10:46:43	10:46:43	...	21
...	10:49:33	10:49:33	...	22
...	10:50:49	10:50:49	...	23
...	10:53:00	10:53: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