Ayr - Troon - Transport Data Hub

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

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
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