Ayr circular- Hillfoot - Transport Data Hub

trip_id	arrival_time	departure_time	stop_id	stop_sequence
...	18:14:00	18:14:00	...	1
...	18:16:00	18:16:00	...	2
...	18:17:58	18:17:58	...	3
...	18:20:00	18:20:00	...	4
...	18:21:09	18:21:09	...	5
...	18:22:19	18:22:19	...	6
...	18:23:19	18:23:19	...	7
...	18:24:03	18:24:03	...	8
...	18:24:37	18:24:37	...	9
...	18:25:11	18:25:11	...	10
...	18:25:51	18:25:51	...	11
...	18:26:30	18:26:30	...	12
...	18:27:25	18:27:25	...	13
...	18:27:58	18:27:58	...	14
...	18:29:00	18:29:00	...	15
...	18:30:47	18:30:47	...	16
...	18:31:22	18:31:22	...	17
...	18:33:00	18:33:00	...	18
...	18:34:36	18:34:36	...	19
...	18:35:44	18:35:44	...	20
...	18:36:45	18:36:45	...	21
...	18:38:11	18:38:11	...	22
...	18:39:06	18:39:06	...	23
...	18:40:05	18:40:05	...	24
...	18:40:48	18:40:48	...	25
...	18:41:44	18:41:44	...	26
...	18:42:34	18:42:34	...	27
...	18:44:21	18:44:21	...	28
...	18:46:00	18:46:00	...	29
...	18:47:00	18:47:00	...	30
...	18:48:00	18:48:00	...	31

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
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
29723695	Alderbank	55.450587158	-4.6029466791
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
29724357	Shavin Brae	55.4536499627	-4.6005228914
29723434	Masonhill Road	55.448900545	-4.5985655011
29723252	Alderbank	55.4507561243	-4.6026098651