Ayr circular- Hillfoot - Transport Data Hub

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

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

stop_code	stop_name	stop_lat	stop_lon
29723832	Lothian Road	55.4566482855	-4.6200817419
29723596	Leslie Crescent	55.4548015587	-4.6190101932
29724289	Hamilton Crescent	55.4547626103	-4.6191499677
29723976	Caledonia Road	55.4525010319	-4.604670253
29723926	Forehill road	55.4538915616	-4.6052206382
29723827	Clarendon Place	55.4505106801	-4.6082240801
29724292	Glencairn Road	55.451285357	-4.6136210427
29723594	Lochlea Drive	55.4523521363	-4.6158584799
29723249	Mount Oliphant Place	55.4534871152	-4.6178474895
29723473	Killoch Place	55.4583596952	-4.6291329683
29724738	Burns Statue Square	55.4585300909	-4.6287330177
29723835	Carrick Street	55.4614826655	-4.6293725298
29723549	Newmarket Street	55.4630278462	-4.630250641
29723797	Ashgrove Street	55.4564642036	-4.624894066
29723626	Masonhill Road	55.4511965618	-4.6042995567
29724786	Ashgrove Street	55.4565055313	-4.6246437218
29724792	Lothian Road	55.4563388367	-4.6190014022
29723967	Lochlea Drive	55.4524688257	-4.6158662071
29723697	Mount Oliphant Place	55.4532770978	-4.6175805015
29743486	Armour Drive	55.4535684199	-4.6077300326
29743754	Armour Drive	55.4534647469	-4.6075333859
29743759	Glenconner Place	55.4521623117	-4.6117020164
29743849	Glenconner Place	55.4524728966	-4.6114694866
29724942	Fullarton Street	55.4611605861	-4.6313918729
29726924	Ellisland Square	55.450921924	-4.6138026046
29763972	Armour Drive	55.4513959647	-4.6059101224
29724357	Shavin Brae	55.4536499627	-4.6005228914