Troon - Irvine - Transport Data Hub

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