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