Glasgow - Ardrossan - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:15:00	17:15:00	...	1
...	17:21:24	17:21:24	...	2
...	17:25:00	17:25:00	...	3
...	17:48:59	17:48:59	...	4
...	17:49:19	17:49:19	...	5
...	17:49:39	17:49:39	...	6
...	17:50:02	17:50:02	...	7
...	17:50:52	17:50:52	...	8
...	17:51:11	17:51:11	...	9
...	17:52:00	17:52:00	...	10
...	17:52:31	17:52:31	...	11
...	17:53:00	17:53:00	...	12
...	17:54:50	17:54:50	...	13
...	17:58:38	17:58:38	...	14
...	18:01:36	18:01:36	...	15
...	18:03:39	18:03:39	...	16
...	18:04:08	18:04:08	...	17
...	18:04:31	18:04:31	...	18
...	18:04:42	18:04:42	...	19
...	18:05:00	18:05:00	...	20

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
04/06/2017 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
45234845	West Regent Lane	55.8631579896	-4.259342981
45239673	West Campbell Street	55.8604173937	-4.2617566947
45242868	Buchanan Bus Station	55.8654933569	-4.2505923115
73926347	Midton Road	55.8102841889	-4.5566550872
73926363	Bellstree Road	55.8041819819	-4.579841947
73925364	Auchengreoch Road	55.8221296835	-4.5319506283
73925296	Hallhill Road	55.8204167242	-4.5352558756
73923964	Corseford Avenue	55.8242893243	-4.532266628
73923754	Milliken Park Road	55.8263421168	-4.5334060395
73924837	Corseford School	55.8169564374	-4.5426455026
73937494	Midton Road	55.8155941936	-4.5454938707
73923985	Mayfield Drive	55.8130771841	-4.5537416147
73924879	Wellbank	55.8089808505	-4.5614056875
73923686	A737 Roundabout	55.7859837829	-4.6065214621
73924847	Clarksbridge Roundabout	55.7688601252	-4.6183886872
62925269	Strand	55.7499838229	-4.634382919
62925296	Reform Street	55.7516404792	-4.6329965148
62924653	Laigh Road	55.7525311289	-4.6317018277
62924364	Trinity Crescent	55.7543261345	-4.628890061
62925376	Beech Avenue	55.757127057	-4.6273730468