Ayr - Troon - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:00:00	08:00:00	...	1
...	08:00:54	08:00:54	...	2
...	08:02:24	08:02:24	...	3
...	08:03:30	08:03:30	...	4
...	08:04:06	08:04:06	...	5
...	08:05:04	08:05:04	...	6
...	08:05:44	08:05:44	...	7
...	08:06:15	08:06:15	...	8
...	08:07:15	08:07:15	...	9
...	08:08:04	08:08:04	...	10
...	08:08:36	08:08:36	...	11
...	08:09:20	08:09:20	...	12
...	08:10:14	08:10:14	...	13
...	08:11:10	08:11:10	...	14
...	08:11:55	08:11:55	...	15
...	08:12:45	08:12:45	...	16
...	08:13:29	08:13:29	...	17
...	08:14:07	08:14:07	...	18
...	08:15:00	08:15:00	...	19
...	08:15:36	08:15:36	...	20
...	08:16:41	08:16:41	...	21
...	08:17:24	08:17:24	...	22
...	08:18:32	08:18:32	...	23
...	08:20:00	08:20:00	...	24
...	08:20:42	08:20:42	...	25
...	08:27:58	08:27:58	...	26
...	08:29:15	08:29:15	...	27
...	08:29:54	08:29:54	...	28
...	08:30:24	08:30:24	...	29
...	08:31:12	08:31:12	...	30
...	08:31:54	08:31:54	...	31
...	08:32:38	08:32:38	...	32
...	08:33:00	08:33:00	...	33

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
29724582	Woodfield Avenue	55.4822181359	-4.6189777118
29724768	Woodfield Crescent	55.4800469806	-4.6204638571
29724852	Marchfield Road	55.4836317492	-4.6180268264
29723429	Bellesleyhill Road	55.4774192163	-4.6222835181
29723543	Lansdowne Road	55.4760873725	-4.6231920663
29724835	Tig Road	55.4743355069	-4.624404962
29724695	Prestwick Airport	55.5089356295	-4.6137991276
29724254	Oswald Drive	55.5039138852	-4.6086041949
29724842	Elmbank Street	55.4718399526	-4.6263436776
29724284	Crown Street	55.467569893	-4.6301260252
29723457	Waggon Road	55.4703784954	-4.6278446436
29724368	Lilybank Road	55.4856835162	-4.6174981218
29723728	Bruce Avenue	55.4881915535	-4.6174903897
29724869	Kingscroft Road	55.4906719163	-4.6158343134
29724645	Brandon Gardens	55.4926885918	-4.6148439387
29723526	Grangemuir Road	55.4949679295	-4.6137600391
29724686	St. Quivox Road	55.4969520606	-4.6126089583
29724354	Kyle Street	55.4985539217	-4.611258265
29724243	Station Road	55.5010118128	-4.6110726427
29723572	Prestwick Holiday Park	55.5127305113	-4.6149853911
29723927	Kilmarnock Road	55.5167148675	-4.6030670657
29723746	Coronation Street	55.5192590345	-4.6034727831
29723947	Fullerton Drive	55.5345161253	-4.6410936831
29724353	Bentinck Drive	55.5330536908	-4.6488725696
29724746	Lochend Road	55.534326388	-4.6523658292
29724845	Lochend Road	55.5360498465	-4.6533061276
29724383	Victoria Drive	55.5386334057	-4.6556201495
29724735	Dallas Road	55.5406514911	-4.6583084628
29723278	Council Offices	55.5423637143	-4.661832437
29724823	West Portland Street	55.543345606	-4.6633890329
29723272	Citadel Place	55.4641408711	-4.6345015994
29796238	Douglas Street	55.4616380154	-4.6334328613
29795963	Dow Avenue	55.5187956321	-4.6163543077