Troon - Irvine - Transport Data Hub

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