Straiton or Ayr - Dunure - Transport Data Hub

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