Ayr - Girvan or Stranraer - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:57:00	18:57:00	...	1
...	18:57:00	18:57:00	...	2
...	18:58:00	18:58:00	...	3
...	19:00:00	19:00:00	...	4
...	19:04:00	19:04:00	...	5
...	19:10:00	19:10:00	...	6
...	19:11:00	19:11:00	...	7
...	19:11:00	19:11:00	...	8
...	19:15:00	19:15:00	...	9
...	19:16:00	19:16:00	...	10
...	19:17:00	19:17:00	...	11
...	19:19:00	19:19:00	...	12
...	19:19:00	19:19:00	...	13
...	19:20:00	19:20:00	...	14
...	19:21:00	19:21:00	...	15
...	19:26:00	19:26:00	...	16
...	19:27:00	19:27:00	...	17
...	19:27:00	19:27:00	...	18
...	19:27:00	19:27:00	...	19
...	19:28:00	19:28:00	...	20
...	19:28:00	19:28:00	...	21
...	19:29:00	19:29:00	...	22
...	19:29:00	19:29:00	...	23
...	19:30:00	19:30:00	...	24
...	19:31:00	19:31:00	...	25
...	19:31:00	19:31:00	...	26
...	19:31:00	19:31:00	...	27
...	19:32:00	19:32:00	...	28
...	19:32:00	19:32:00	...	29
...	19:33:00	19:33:00	...	30
...	19:33:00	19:33:00	...	31
...	19:34:00	19:34:00	...	32
...	19:34:00	19:34:00	...	33
...	19:36:00	19:36:00	...	34

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
56567298	A713	55.4173311513	-4.5628322479
56524549	Glebe Avenue	55.3978169457	-4.5943422541
56523868	Garden Street	55.3975612797	-4.5919879179
56525254	Primpton Avenue	55.3989763072	-4.5845937473
29743934	B742	55.3709623216	-4.650684483
29723858	Mure Place	55.392472368	-4.642411952
29723578	Kirland Street	55.3565307881	-4.6776630451
29724537	Kirkmichael Road	55.3581750799	-4.6744131587
29724636	Carrick Gardens	55.451108392	-4.6294253342
29723739	Maybole Station	55.3546977301	-4.6845919011
29723546	Ailsa Hospital	55.4353232697	-4.5928351358
29723856	Ballantine Drive	55.4541804178	-4.6291078605
29724264	Barnes Crescent	55.4581322077	-4.6342747726
29724572	Beresford Terrace	55.4579912928	-4.6299626584
29723672	Bellevue Street	55.4560792576	-4.6294240719
29724846	St Leonards Court	55.4486406098	-4.6263036771
29724272	Robsland Avenue	55.4471128541	-4.6241936928
29723236	Hazelwood Road	55.4499769637	-4.628116413
29724534	Bellevale Avenue	55.4452094241	-4.6228338136
29723954	Shawfield Avenue	55.4422620084	-4.619855193
29723636	Bus Station	55.461989362	-4.6342314928
29723939	Auchenbeg Crescent	55.4390972502	-4.6173685929
29725968	Mosshill Ind Estate	55.4250555389	-4.575518756
29724538	Taybank Drive	55.4374830469	-4.6167715709
29723859	Barnford Crescent	55.436040578	-4.620328174
29724235	St Vincent Crescent	55.4337373205	-4.6237799584
29725398	Ayr Hospital	55.4311555953	-4.5948065149
29725423	Ayr Hospital Day Centre	55.4292686977	-4.5939239347
29796832	Burness Avenue	55.4322133922	-4.6260975062
29725498	Ailsa Hospital East Entrance	55.4340180911	-4.5899513298
29726896	Doonholm Farm	55.4257490339	-4.6194564696
29726952	Woodend Road	55.4307978129	-4.6283904664
29726957	The Loaning	55.4292601929	-4.6284147026
29764593	Carrick Glen Hospital	55.4312400347	-4.5831774426