Glasgow - Largs - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	16:43:00	16:43:00	...	1
...	16:46:58	16:46:58	...	2
...	16:48:39	16:48:39	...	3
...	16:49:59	16:49:59	...	4
...	16:52:51	16:52:51	...	5
...	16:56:00	16:56:00	...	6
...	16:56:17	16:56:17	...	7
...	17:25:34	17:25:34	...	8
...	17:25:52	17:25:52	...	9
...	17:26:00	17:26:00	...	10
...	17:26:21	17:26:21	...	11
...	17:26:39	17:26:39	...	12
...	17:27:24	17:27:24	...	13
...	17:27:55	17:27:55	...	14
...	17:29:26	17:29:26	...	15
...	17:30:20	17:30:20	...	16
...	17:30:55	17:30:55	...	17
...	17:31:30	17:31:30	...	18
...	17:32:03	17:32:03	...	19
...	17:33:03	17:33:03	...	20
...	17:33:29	17:33:29	...	21
...	17:34:35	17:34:35	...	22
...	17:36:01	17:36:01	...	23
...	17:36:39	17:36:39	...	24
...	17:38:00	17:38:00	...	25

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
45236862	Cathedral Street	55.8620308661	-4.2497367841
45239673	West Campbell Street	55.8604173937	-4.2617566947
45238482	Pitt Street	55.8607800422	-4.2659806912
45238952	Buchanan Bus Station	55.8652655367	-4.2517458503
45239725	Queen St	55.8607847499	-4.251039062
45239784	North Court	55.8609903295	-4.2530645248
45235978	Renfield Street	55.861513707	-4.2573617423
46823868	Bay Street	55.933947724	-4.6827620894
46824329	William Street	55.93524725	-4.6977442926
46823648	Lower Mary Street	55.9356030159	-4.7011959133
46823635	Bogston station	55.9372208876	-4.7110131575
46823275	Gibshill Road	55.9391800476	-4.7159225697
46823474	Pottery Street	55.9402004813	-4.7193732869
46824342	Ladyburn Street	55.941190356	-4.7229822035
46823753	Sinclair Street	55.9421157625	-4.7262504349
46823972	Ratho Street	55.9436804429	-4.7323027214
46823598	Clyde Port Authority	55.9441757937	-4.7350925767
46823935	Knowe Road	55.9434460612	-4.7424409062
46824235	Cathcart Street	55.9461097334	-4.7507664607
46823734	Terrace Road	55.9475703488	-4.7541859508
46823524	West Stewart Street	55.9497055183	-4.7623954808
46823764	Bus Station	55.9355039566	-4.6884743878
46823293	Balfour Street	55.9349346423	-4.6927264487
46823936	Princes Street	55.935308312	-4.6908468065
46823298	Coronation Park	55.9351636611	-4.6867694158