Ayr circular- Hillfoot
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:47:00 | 07:47:00 | ... | 1 |
|
| ... | 07:49:00 | 07:49:00 | ... | 2 |
|
| ... | 07:50:58 | 07:50:58 | ... | 3 |
|
| ... | 07:53:00 | 07:53:00 | ... | 4 |
|
| ... | 07:54:10 | 07:54:10 | ... | 5 |
|
| ... | 07:55:16 | 07:55:16 | ... | 6 |
|
| ... | 07:55:45 | 07:55:45 | ... | 7 |
|
| ... | 07:56:15 | 07:56:15 | ... | 8 |
|
| ... | 07:57:00 | 07:57:00 | ... | 9 |
|
| ... | 07:57:34 | 07:57:34 | ... | 10 |
|
| ... | 07:58:09 | 07:58:09 | ... | 11 |
|
| ... | 07:58:49 | 07:58:49 | ... | 12 |
|
| ... | 07:59:28 | 07:59:28 | ... | 13 |
|
| ... | 08:00:24 | 08:00:24 | ... | 14 |
|
| ... | 08:00:58 | 08:00:58 | ... | 15 |
|
| ... | 08:02:00 | 08:02:00 | ... | 16 |
|
| ... | 08:03:25 | 08:03:25 | ... | 17 |
|
| ... | 08:04:26 | 08:04:26 | ... | 18 |
|
| ... | 08:05:07 | 08:05:07 | ... | 19 |
|
| ... | 08:05:42 | 08:05:42 | ... | 20 |
|
| ... | 08:06:31 | 08:06:31 | ... | 21 |
|
| ... | 08:07:42 | 08:07:42 | ... | 22 |
|
| ... | 08:08:27 | 08:08:27 | ... | 23 |
|
| ... | 08:09:15 | 08:09:15 | ... | 24 |
|
| ... | 08:09:50 | 08:09:50 | ... | 25 |
|
| ... | 08:10:36 | 08:10:36 | ... | 26 |
|
| ... | 08:11:17 | 08:11:17 | ... | 27 |
|
| ... | 08:12:21 | 08:12:21 | ... | 28 |
|
| ... | 08:14:00 | 08:14:00 | ... | 29 |
|
| 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 | |
|---|---|---|---|---|
| 29724787 | Mill Brae | 55.4576549884 | -4.6226004128 | |
| 29724629 | Castlehill Road | 55.4569311337 | -4.624498003 | |
| 29723276 | Dongola Road | 55.456788375 | -4.6223530483 | |
| 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 | |
| 29723626 | Masonhill Road | 55.4511965618 | -4.6042995567 | |
| 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 |