Troon - Irvine - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	12:32:00	12:32:00	...	1
...	12:32:58	12:32:58	...	2
...	12:34:56	12:34:56	...	3
...	12:38:28	12:38:28	...	4
...	12:40:00	12:40:00	...	5
...	12:40:36	12:40:36	...	6
...	12:41:09	12:41:09	...	7
...	12:41:29	12:41:29	...	8
...	12:42:11	12:42:11	...	9
...	12:42:57	12:42:57	...	10
...	12:43:47	12:43:47	...	11
...	12:45:53	12:45:53	...	12
...	12:47:31	12:47:31	...	13
...	12:48:09	12:48:09	...	14
...	12:49:05	12:49:05	...	15
...	12:50:00	12:50:00	...	16
...	12:51:36	12:51:36	...	17
...	12:55:00	12:55:00	...	18
...	12:55:38	12:55:38	...	19
...	12:56:28	12:56:28	...	20
...	12:57:24	12:57:24	...	21
...	12:58:10	12:58:10	...	22
...	12:58:48	12:58:48	...	23
...	13:00:21	13:00:21	...	24
...	13:01:47	13:01:47	...	25
...	13:02:23	13:02:23	...	26
...	13:03:00	13:03: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
62925796	Auchengate Crescent	55.5772449559	-4.6425193098
62989532	Cemetery	55.594527437	-4.655126534
62958264	Shewalton Road	55.5977555966	-4.6596309974
62923947	Lamont Drive	55.6058994589	-4.6662480481
62924757	Heatherhouse Road	55.6041861602	-4.6656712865
62923764	Carson Drive	55.6009341922	-4.6635136712
62923498	McKinlay Crescent	55.6114149214	-4.6688934905
62923678	Sanderson Avenue	55.6085845244	-4.6667796965
62923679	Fullerton Centre	55.6132828179	-4.6714503294
62924878	Marress Road	55.6186343157	-4.669654318
62923939	Bank Street	55.6150789949	-4.6673955154
62924257	Dundonald Camp	55.574203267	-4.6410139192
62923739	Meadowhead Avenue	55.5850166141	-4.6468505639
62924978	Gailes Burns	55.5696297714	-4.6392631895
62924687	Irvine Central	55.6163752491	-4.666070021
29724823	West Portland Street	55.543345606	-4.6633890329
29724352	Academy Street	55.5440938902	-4.6612201632
29724784	Lang Road	55.5628577916	-4.6427582254
29723868	Walker Avenue	55.5517051388	-4.656771707
29723427	Panrock Court	55.5481596174	-4.6586094083
29724867	Wallace Avenue	55.559149853	-4.6550223424
29723762	Greenside	55.5586209912	-4.6524650157
29723424	Muir Drive	55.5566771551	-4.6529841794
29724632	Burnfoot Avenue	55.5545576865	-4.6541416184
29724767	Morrisons Supermarket	55.5454209672	-4.6621977083
29745243	North Shore Road	55.5531822549	-4.6562212846
29725427	Kilmarnock Road	55.5651542952	-4.6375511812