Glasgow - Irvine - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	17:50:00	17:50:00	...	1
...	17:56:24	17:56:24	...	2
...	18:00:00	18:00:00	...	3
...	18:23:57	18:23:57	...	4
...	18:24:16	18:24:16	...	5
...	18:24:36	18:24:36	...	6
...	18:25:00	18:25:00	...	7
...	18:26:14	18:26:14	...	8
...	18:26:43	18:26:43	...	9
...	18:27:56	18:27:56	...	10
...	18:28:41	18:28:41	...	11
...	18:29:22	18:29:22	...	12
...	18:32:00	18:32:00	...	13
...	18:34:59	18:34:59	...	14
...	18:37:19	18:37:19	...	15
...	18:38:56	18:38:56	...	16
...	18:39:19	18:39:19	...	17
...	18:39:37	18:39:37	...	18
...	18:39:46	18:39:46	...	19
...	18:40:00	18:40: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