Ayr - Cumnock + New Cumnock - Transport Data Hub

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