Ayr - Cumnock + New Cumnock - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:00:00	18:00:00	...	1
...	18:00:31	18:00:31	...	2
...	18:01:04	18:01:04	...	3
...	18:01:46	18:01:46	...	4
...	18:02:18	18:02:18	...	5
...	18:02:40	18:02:40	...	6
...	18:03:03	18:03:03	...	7
...	18:04:02	18:04:02	...	8
...	18:04:33	18:04:33	...	9
...	18:05:24	18:05:24	...	10
...	18:05:53	18:05:53	...	11
...	18:06:49	18:06:49	...	12
...	18:08:00	18:08:00	...	13
...	18:08:46	18:08:46	...	14
...	18:09:10	18:09:10	...	15
...	18:09:35	18:09:35	...	16
...	18:11:01	18:11:01	...	17
...	18:17:40	18:17:40	...	18
...	18:20:46	18:20:46	...	19
...	18:21:10	18:21:10	...	20
...	18:22:08	18:22:08	...	21
...	18:22:24	18:22:24	...	22
...	18:22:45	18:22:45	...	23
...	18:23:39	18:23:39	...	24
...	18:23:59	18:23:59	...	25
...	18:24:08	18:24:08	...	26
...	18:24:32	18:24:32	...	27
...	18:25:00	18:25:00	...	28
...	18:28:11	18:28:11	...	29
...	18:29:25	18:29:25	...	30
...	18:31:00	18:31:00	...	31

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

stop_code	stop_name	stop_lat	stop_lon
56546893	Craigens Road	55.440871164	-4.252929547
56545389	New Cumnock Golf Club	55.4064651408	-4.1976258061
56545375	Borland Bridge	55.4304276407	-4.2337938726
56564374	Dalhanna Drive	55.3916821884	-4.1789305418
56596462	Lime Road	55.3907964387	-4.1741605778
56564685	Afton Bridgend	55.3922684496	-4.1742729777
56524593	Bus Stance	55.4539845386	-4.2670415104
56524268	Hall Terrace	55.4520378115	-4.2629602728
56523982	Shankston Crescent	55.4499070101	-4.261051253
56523965	Holmburn Road	55.4444999595	-4.2559825336
56524698	John Allan Drive	55.4426592643	-4.2539327032
56523264	Lamont Crescent	55.4408947227	-4.2516502504
56524525	James Young Avenue	55.441498762	-4.2491075335
56524856	James Young Avenue	55.4416598196	-4.2486581892
56523584	Avisyard Avenue	55.4433589409	-4.2422722185
56523878	Avisyard Avenue	55.443467255	-4.2412664371
56523974	Craigens Road	55.4423576502	-4.2400176971
56524953	Lochview	55.404032651	-4.1864181725
56523476	Polquheys Road	55.4032357658	-4.183230939
56523642	Afton Cottage	55.4014186584	-4.182814834
56524936	Castlehill	55.3977514722	-4.1838286929
56524727	Castle Primary school	55.3944507253	-4.1849573421
56524945	Mason Avenue	55.3934495868	-4.1806226998
56523939	Greenhead Road	55.393204731	-4.1782247697
56524743	Lochbrowan Crescent	55.3912909541	-4.180709106
56524396	Redree Place	55.3902216016	-4.1806975909
56523795	Milray Avenue	55.3887257297	-4.1809152203
56523586	Connel View	55.3874163025	-4.1782379769
56525239	Cairnhill Primary School	55.3885985024	-4.1764556618
56524578	Lime Road	55.3891375496	-4.1739431928
56523698	Lamont Crescent	55.4409740759	-4.2517338228