Ayr - Cumnock or Muirkirk - Transport Data Hub

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

start_date	end_date	monday	tuesday	wednesday	thursday	friday	saturday	sunday
17/07/2016 @ 00:00	01/01/0001 @ 00:00

stop_code	stop_name	stop_lat	stop_lon
56546876	Coyle Avenue	55.4319582837	-4.459416967
56525395	Mill of South Road	55.4352868526	-4.4548023213
56573426	Hoyle Crescent	55.4600751232	-4.2797924911
56549472	Highfield Place	55.4586828278	-4.3733217422
56572458	Barony A frame	55.4690255415	-4.3271418801
56594979	B730	55.4482556295	-4.4580117384
56524863	Bus Stance	55.454064759	-4.2670777452
56523765	Holm	55.4551913418	-4.2688505406
56523949	Holmhead Road	55.4570469898	-4.2749200952
56524824	Coal Road	55.4664925916	-4.2908578078
56524646	Main Street	55.4677713525	-4.2921660577
56524279	Park Road	55.4695912534	-4.2938539119
56524852	Well Road	55.4711905279	-4.2953234022
56523269	Sorn Road	55.4720893358	-4.2977174674
56524987	Arran Drive	55.4735911223	-4.3024570292
56523758	Mauchline Road	55.4620838589	-4.3587350782
56524969	Burnock Street	55.4617840126	-4.3612324156
56524768	Broom Crescent	55.4606017175	-4.3656700591
56523723	Gallowlee Avenue	55.459358663	-4.3690597941
56524826	Killoch Colliery	55.4535132351	-4.4028558728
56524848	Evergreen	55.4480177016	-4.4631365059
56525245	Watson Terrace	55.4372557654	-4.4579126347
56523454	Littlemill Road	55.4333430024	-4.4522313548
56523735	Barbieston Avenue	55.4325220607	-4.4555158858
56523625	Coronation Road	55.431797499	-4.4620468287
56523496	Coyle Avenue	55.4330342769	-4.4631197588
56524857	Drumwhill Road	55.4341272691	-4.4632985183
56523298	Glencraig Street	55.4352204336	-4.4625761893
56524679	Taiglum Place	55.4356008725	-4.4637697624
56524529	Lane Crescent	55.4374492277	-4.4585728671
56524545	Taiglum Place	55.4367571249	-4.4625928745
56587976	The Avenue	55.4692538133	-4.3055899847
29723462	Allenfield Road	55.4556568474	-4.6012560957
29724267	Ayr cemetery	55.4562784906	-4.610471477
29724754	Lothian Road	55.4569063593	-4.6189441252
29745683	Old Toll	55.4538849619	-4.5856229465
29723492	Mill Brae	55.4577466118	-4.6229386889
29723569	Smith Street	55.4581268872	-4.6278361438
29723293	Coylton Parish Church	55.4466834687	-4.4965781783
29723829	Coylton Primary School	55.4441541714	-4.5086099655
29724387	Hole Road	55.4439377134	-4.5130237634
29724348	The Beeches	55.4459909294	-4.5198276341
29723767	Arthurston Terrace	55.4468603722	-4.5229984101
29723867	Holmston Roundabout	55.4551227174	-4.5912717156
29723782	Racecourse Road	55.4582254998	-4.6345340978
29723975	Hillhead	55.4454310132	-4.5024448058
29723247	Bus Station	55.4620991148	-4.6341438916
29796239	Holmston Crescent	55.4559991728	-4.6058658255
29767343	Sundrum Castle Holiday Park	55.4491261151	-4.5377401575