Troon - Irvine - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:05:00	15:05:00	...	1
...	15:05:50	15:05:50	...	2
...	15:06:34	15:06:34	...	3
...	15:08:16	15:08:16	...	4
...	15:08:51	15:08:51	...	5
...	15:09:16	15:09:16	...	6
...	15:10:01	15:10:01	...	7
...	15:10:41	15:10:41	...	8
...	15:11:00	15:11:00	...	9
...	15:11:28	15:11:28	...	10
...	15:14:37	15:14:37	...	11
...	15:16:00	15:16:00	...	12
...	15:16:50	15:16:50	...	13
...	15:17:46	15:17:46	...	14
...	15:18:31	15:18:31	...	15
...	15:20:14	15:20:14	...	16
...	15:22:17	15:22:17	...	17
...	15:23:08	15:23:08	...	18
...	15:23:54	15:23:54	...	19
...	15:24:28	15:24:28	...	20
...	15:24:53	15:24:53	...	21
...	15:25:30	15:25:30	...	22
...	15:26:00	15:26:00	...	23
...	15:27:45	15:27:45	...	24
...	15:30:33	15:30:33	...	25
...	15:31:27	15:31:27	...	26
...	15:32:00	15:32:00	...	27

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

stop_code	stop_name	stop_lat	stop_lon
62968429	Marine Road	55.5945050207	-4.6553313793
62932348	Shewalton Road	55.5978657419	-4.6599400835
62924295	Lamont Drive	55.6056174233	-4.6664035641
62924395	Heatherhouse Road	55.6035934305	-4.6656469374
62923287	Carson Drive	55.6010087697	-4.6638045054
62924567	McKinlay Crescent	55.6109837539	-4.6684671704
62923726	Sanderson Avenue	55.6087050061	-4.6670260729
62924754	Marress Roundabout	55.61308879	-4.672104149
62923939	Bank Street	55.6150789949	-4.6673955154
62924732	Dundonald Camp	55.5736381362	-4.6409600981
62924649	Auchengate Crescent	55.5772425636	-4.6426302167
62924743	Meadowhead Avenue	55.5854029852	-4.6472733359
62924362	Gailes Burns	55.5690961053	-4.6394177392
62925789	Crown Inn	55.615910956	-4.6679920477
62925876	Quarry Road	55.6173781017	-4.6687270823
29724823	West Portland Street	55.543345606	-4.6633890329
29724545	The Knowe	55.565017612	-4.6376371874
29723627	Barassie Bank Lane	55.5600784666	-4.6548946899
29725365	Walker Avenue	55.5519992749	-4.656886704
29723836	Burnfoot Way	55.5545735788	-4.6542378367
29723245	North Shore Road	55.5535574207	-4.6555013133
29723638	Lang Road	55.5630800439	-4.6424559342
29723474	Arran View	55.5473329711	-4.6602500407
29724832	Morrisons Supermarket	55.5458601365	-4.6630835397
29785985	Muir Drive	55.5566830435	-4.6531273036
29786296	Johnston Drive	55.5586814202	-4.6525801052
29785839	Barassiebank Lane	55.5590088848	-4.6540612583