Ayr circular- Hillfoot - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	14:47:00	14:47:00	...	1
...	14:49:00	14:49:00	...	2
...	14:50:58	14:50:58	...	3
...	14:53:00	14:53:00	...	4
...	14:54:09	14:54:09	...	5
...	14:55:19	14:55:19	...	6
...	14:56:19	14:56:19	...	7
...	14:57:03	14:57:03	...	8
...	14:57:37	14:57:37	...	9
...	14:58:11	14:58:11	...	10
...	14:58:51	14:58:51	...	11
...	14:59:30	14:59:30	...	12
...	15:00:25	15:00:25	...	13
...	15:00:58	15:00:58	...	14
...	15:02:00	15:02:00	...	15
...	15:03:24	15:03:24	...	16
...	15:04:25	15:04:25	...	17
...	15:05:06	15:05:06	...	18
...	15:05:40	15:05:40	...	19
...	15:06:29	15:06:29	...	20
...	15:07:39	15:07:39	...	21
...	15:08:24	15:08:24	...	22
...	15:09:12	15:09:12	...	23
...	15:09:47	15:09:47	...	24
...	15:10:32	15:10:32	...	25
...	15:11:13	15:11:13	...	26
...	15:12:40	15:12:40	...	27
...	15:14:00	15:14: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
29723896	Town Hall	55.4642952437	-4.6315058457
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