Colmonell - Girvan - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	15:45:00	15:45:00	...	1
...	15:45:17	15:45:17	...	2
...	15:52:31	15:52:31	...	3
...	15:53:59	15:53:59	...	4
...	15:56:16	15:56:16	...	5
...	16:00:00	16:00:00	...	6
...	16:04:17	16:04:17	...	7
...	16:11:08	16:11:08	...	8
...	16:14:27	16:14:27	...	9
...	16:15:00	16:15:00	...	10
...	16:15:38	16:15:38	...	11
...	16:16:06	16:16:06	...	12
...	16:17:21	16:17:21	...	13
...	16:18:17	16:18:17	...	14
...	16:19:00	16:19:00	...	15
...	16:19:43	16:19:43	...	16
...	16:20:12	16:20:12	...	17
...	16:20:33	16:20:33	...	18
...	16:21:01	16:21:01	...	19
...	16:21:28	16:21:28	...	20
...	16:22:00	16:22:00	...	21

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

stop_code	stop_name	stop_lat	stop_lon
29784356	Daljarrock Caravan Park	55.1557032487	-4.832652701
29797275	Holmhead Farm	55.1679622733	-4.8246494505
29724327	Asda	55.2466129258	-4.8512981705
29723428	George street	55.2350794933	-4.8562770478
29724575	Kirkpatrick Street	55.2333737229	-4.8565636918
29723942	McMillan Court	55.2442861834	-4.8527679193
29724576	McConnell Square	55.2453790971	-4.8525472783
29723648	Henrietta Street	55.2434150401	-4.8588733815
29724328	Firth Terrace	55.2363504343	-4.8561322411
29724674	Road to Tormitchell	55.1894109518	-4.8250681939
29724692	Bynehill Cemetery	55.2216022608	-4.8509704222
29724862	Elder Avenue	55.2316619204	-4.8567240429
29723574	Duncan Street	55.239745126	-4.8555104529
29724373	Sacred Heart Primary	55.241497053	-4.8586255094
29724868	High Street	55.2434718753	-4.8549123829
29725382	Telephone Exchange	55.1474587589	-4.8353957647
29725387	Craigneil Road	55.1333885648	-4.9067493614
29725468	Hyslop Crescent	55.1343297247	-4.9042286839
29727298	Rail station	55.2471791851	-4.8489940892
29727234	Hospital	55.2483049392	-4.8469817422
29742652	Pinmacher	55.2010868032	-4.8375264341