Troon - Irvine - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	20:55:00	20:55:00	...	1
...	20:55:33	20:55:33	...	2
...	20:56:03	20:56:03	...	3
...	20:57:10	20:57:10	...	4
...	20:57:34	20:57:34	...	5
...	20:57:51	20:57:51	...	6
...	20:58:20	20:58:20	...	7
...	20:58:47	20:58:47	...	8
...	20:59:00	20:59:00	...	9
...	20:59:23	20:59:23	...	10
...	21:01:54	21:01:54	...	11
...	21:03:00	21:03:00	...	12
...	21:03:50	21:03:50	...	13
...	21:04:46	21:04:46	...	14
...	21:05:31	21:05:31	...	15
...	21:07:14	21:07:14	...	16
...	21:09:17	21:09:17	...	17
...	21:10:08	21:10:08	...	18
...	21:10:54	21:10:54	...	19
...	21:11:28	21:11:28	...	20
...	21:11:53	21:11:53	...	21
...	21:12:30	21:12:30	...	22
...	21:13:00	21:13:00	...	23
...	21:13:52	21:13:52	...	24
...	21:15:16	21:15:16	...	25
...	21:15:43	21:15:43	...	26
...	21:16:00	21:16: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