Straiton or Ayr - Dunure - Transport Data Hub

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