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