Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	21:09:00	21:09:00	...	1
...	21:12:00	21:12:00	...	2
...	21:13:00	21:13:00	...	3
...	21:17:00	21:17:00	...	4
...	21:20:00	21:20:00	...	5
...	21:21:00	21:21:00	...	6
...	21:23:00	21:23:00	...	7
...	21:24:00	21:24:00	...	8
...	21:24:00	21:24:00	...	9
...	21:25:00	21:25:00	...	10
...	21:25:00	21:25:00	...	11
...	21:26:00	21:26:00	...	12
...	21:29:00	21:29:00	...	13
...	21:33:00	21:33:00	...	14
...	21:34:00	21:34:00	...	15
...	21:35:00	21:35:00	...	16
...	21:37:00	21:37:00	...	17
...	21:37:00	21:37:00	...	18
...	21:38:00	21:38:00	...	19
...	21:39:00	21:39:00	...	20

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
29738939	Kilantringan Loch	55.0682502316	-4.9856936891
29724753	Arrol Avenue	55.0999473347	-5.0044265399
29724729	Old Smyrton	55.0804179286	-4.9767281109
29748567	Glenapp Church	55.0286857756	-5.0144104292
29739525	Finnarts Bay	55.0080519653	-5.0472598815
34234727	Port Rodie	54.9052714766	-5.024630926
34237262	P & O Ferry Terminal	54.964138457	-5.0128054357
34239238	P & O Ferry Terminal	54.9660476089	-5.0152142806
34237267	Post Office	54.9710744393	-5.0198733849
34237264	Claddyburn Terr	54.9677687719	-5.0161403071
34239279	Old Pier	54.9734323573	-5.0241141043
34237279	Sandmill	54.9127903143	-4.9958721057
34237276	Innermessan	54.9218784254	-4.9900857374
34237273	Innermessan	54.9275450192	-4.9870563021
34237258	Leffnoll	54.9486337181	-5.0043033768
34237272	Burnfoot Bridge	54.9772938597	-5.0293439249
34239469	Marchburn	54.9977987407	-5.0377242417
34234673	Cairnryan Rd	54.9084287866	-5.0068295802
34234675	Cairnryan Rd	54.9068421248	-5.0117199092
34234676	Marine Gardens	54.9055233244	-5.0166767176