Glasgow - Largs - Transport Data Hub

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