Colmonell - Girvan - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	08:05:00	08:05:00	...	1
...	08:05:17	08:05:17	...	2
...	08:12:31	08:12:31	...	3
...	08:13:59	08:13:59	...	4
...	08:16:16	08:16:16	...	5
...	08:20:00	08:20:00	...	6
...	08:23:42	08:23:42	...	7
...	08:29:38	08:29:38	...	8
...	08:31:51	08:31:51	...	9
...	08:32:22	08:32:22	...	10
...	08:32:45	08:32:45	...	11
...	08:33:45	08:33:45	...	12
...	08:34:04	08:34:04	...	13
...	08:35:00	08:35:00	...	14
...	08:37:27	08:37:27	...	15
...	08:42:00	08:42:00	...	16
...	08:42:43	08:42:43	...	17
...	08:43:12	08:43:12	...	18
...	08:43:33	08:43:33	...	19
...	08:44:01	08:44:01	...	20
...	08:44:28	08:44:28	...	21
...	08:45:00	08:45:00	...	22

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
29723942	McMillan Court	55.2442861834	-4.8527679193
29724576	McConnell Square	55.2453790971	-4.8525472783
29723648	Henrietta Street	55.2434150401	-4.8588733815
29724674	Road to Tormitchell	55.1894109518	-4.8250681939
29724692	Bynehill Cemetery	55.2216022608	-4.8509704222
29723683	Gregg Place	55.2368068983	-4.8454516407
29723598	Urnfield	55.2357812045	-4.8462593007
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
29726262	Girvan Academy	55.2402385362	-4.8455553005
29727298	Rail station	55.2471791851	-4.8489940892
29727234	Hospital	55.2483049392	-4.8469817422
29764835	Orchard Avenue	55.242040133	-4.8496332672
29764865	Hawthorn Drive	55.2297015772	-4.8525253534
29764875	Willow Drive	55.2314086958	-4.851027471
29764929	Rowan Road	55.2326361016	-4.8496681696
29742652	Pinmacher	55.2010868032	-4.8375264341