Straiton or Ayr - Dunure - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	11:17:00	11:17:00	...	1
...	11:26:30	11:26:30	...	2
...	11:26:49	11:26:49	...	3
...	11:31:00	11:31:00	...	4
...	11:31:19	11:31:19	...	5
...	11:37:38	11:37:38	...	6
...	11:38:08	11:38:08	...	7
...	11:38:53	11:38:53	...	8
...	11:39:00	11:39:00	...	9
...	11:39:44	11:39:44	...	10
...	11:40:09	11:40:09	...	11
...	11:43:17	11:43:17	...	12
...	11:47:00	11:47:00	...	13
...	11:54:37	11:54:37	...	14
...	11:55:00	11:55:00	...	15
...	11:55:46	11:55:46	...	16
...	11:59:39	11:59:39	...	17
...	12:01:30	12:01:30	...	18
...	12:02:50	12:02:50	...	19
...	12:04:00	12:04:00	...	20
...	12:04:35	12:04:35	...	21
...	12:06:09	12:06:09	...	22
...	12:06:47	12:06:47	...	23
...	12:09:42	12:09:42	...	24
...	12:10:04	12:10:04	...	25
...	12:10:51	12:10:51	...	26
...	12:11:30	12:11:30	...	27
...	12:12:28	12:12:28	...	28
...	12:12:59	12:12:59	...	29
...	12:13:30	12:13:30	...	30
...	12:13:57	12:13:57	...	31
...	12:14:31	12:14:31	...	32
...	12:15:16	12:15:16	...	33
...	12:16:11	12:16:11	...	34
...	12:17:08	12:17:08	...	35
...	12:17:37	12:17:37	...	36
...	12:18:03	12:18:03	...	37
...	12:19:00	12:19:00	...	38

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
26/03/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
29746245	Carrick Drive	55.3251118251	-4.636033682
29723473	Killoch Place	55.4583596952	-4.6291329683
29723835	Carrick Street	55.4614826655	-4.6293725298
29723549	Newmarket Street	55.4630278462	-4.630250641
29723896	Town Hall	55.4642952437	-4.6315058457
29723797	Ashgrove Street	55.4564642036	-4.624894066
29723536	Inverkar Road	55.4540557569	-4.6236109939
29724586	Belmont Avenue	55.452427363	-4.6220002697
29723858	Mure Place	55.392472368	-4.642411952
29724283	McDowall Terrace	55.3577456309	-4.6751415755
29723578	Kirland Street	55.3565307881	-4.6776630451
29724297	Merrick View	55.3558869303	-4.6787398113
29724364	Belmont Road	55.4488712863	-4.6159601199
29724537	Kirkmichael Road	55.3581750799	-4.6744131587
29723279	Kirkbride Crescent	55.3245120427	-4.6388316492
29723739	Maybole Station	55.3546977301	-4.6845919011
29724236	Town Green	55.3543117152	-4.6853861994
29723546	Ailsa Hospital	55.4353232697	-4.5928351358
29723592	Birch Road	55.4431090396	-4.6062965647
29723563	Lochlea Drive	55.4500850224	-4.6180490665
29723793	Castlehill Crescent	55.4513425867	-4.6201884992
29725968	Mosshill Ind Estate	55.4250555389	-4.575518756
29725727	Kirkmichael Playing Fields	55.3444898419	-4.6160745943
29725235	Kirkmichael Arms	55.3456450656	-4.6183749099
29724942	Fullarton Street	55.4611605861	-4.6313918729
29725398	Ayr Hospital	55.4311555953	-4.5948065149
29725423	Ayr Hospital Day Centre	55.4292686977	-4.5939239347
29725498	Ailsa Hospital East Entrance	55.4340180911	-4.5899513298
29723567	Forest Way	55.4467522641	-4.6116448665
29723532	Peggieshill Road	55.4451442578	-4.6090716683
29796756	The Black Bull	55.3115941909	-4.5521901896
29723748	Queen Margaret Academy	55.4420437807	-4.6052459457
29764593	Carrick Glen Hospital	55.4312400347	-4.5831774426