Glasgow - Largs - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:03:00	17:03:00	...	1
...	17:06:58	17:06:58	...	2
...	17:08:39	17:08:39	...	3
...	17:09:59	17:09:59	...	4
...	17:12:51	17:12:51	...	5
...	17:16:00	17:16:00	...	6
...	17:16:17	17:16:17	...	7
...	17:45:34	17:45:34	...	8
...	17:45:52	17:45:52	...	9
...	17:46:00	17:46:00	...	10
...	17:46:21	17:46:21	...	11
...	17:46:39	17:46:39	...	12
...	17:47:24	17:47:24	...	13
...	17:47:55	17:47:55	...	14
...	17:49:26	17:49:26	...	15
...	17:50:20	17:50:20	...	16
...	17:50:55	17:50:55	...	17
...	17:51:30	17:51:30	...	18
...	17:52:03	17:52:03	...	19
...	17:53:03	17:53:03	...	20
...	17:53:29	17:53:29	...	21
...	17:54:35	17:54:35	...	22
...	17:56:01	17:56:01	...	23
...	17:56:39	17:56:39	...	24
...	17:58:00	17:58: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