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