Prestwick Marchburn - Ayr
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 20:00:00 | 20:00:00 | ... | 1 |
|
| ... | 20:02:06 | 20:02:06 | ... | 2 |
|
| ... | 20:03:11 | 20:03:11 | ... | 3 |
|
| ... | 20:03:59 | 20:03:59 | ... | 4 |
|
| ... | 20:04:56 | 20:04:56 | ... | 5 |
|
| ... | 20:06:36 | 20:06:36 | ... | 6 |
|
| ... | 20:08:03 | 20:08:03 | ... | 7 |
|
| ... | 20:10:00 | 20:10:00 | ... | 8 |
|
| ... | 20:11:18 | 20:11:18 | ... | 9 |
|
| ... | 20:12:03 | 20:12:03 | ... | 10 |
|
| ... | 20:12:53 | 20:12:53 | ... | 11 |
|
| ... | 20:13:23 | 20:13:23 | ... | 12 |
|
| ... | 20:13:59 | 20:13:59 | ... | 13 |
|
| ... | 20:15:35 | 20:15:35 | ... | 14 |
|
| ... | 20:16:20 | 20:16:20 | ... | 15 |
|
| ... | 20:17:18 | 20:17:18 | ... | 16 |
|
| ... | 20:17:46 | 20:17:46 | ... | 17 |
|
| ... | 20:18:23 | 20:18:23 | ... | 18 |
|
| ... | 20:18:54 | 20:18:54 | ... | 19 |
|
| ... | 20:19:44 | 20:19:44 | ... | 20 |
|
| ... | 20:20:12 | 20:20:12 | ... | 21 |
|
| ... | 20:20:53 | 20:20:53 | ... | 22 |
|
| ... | 20:21:14 | 20:21:14 | ... | 23 |
|
| ... | 20:22:24 | 20:22:24 | ... | 24 |
|
| ... | 20:22:58 | 20:22:58 | ... | 25 |
|
| ... | 20:24:00 | 20:24:00 | ... | 26 |
|
| ... | 20:25:17 | 20:25:17 | ... | 27 |
|
| ... | 20:26:33 | 20:26:33 | ... | 28 |
|
| ... | 20:27:56 | 20:27:56 | ... | 29 |
|
| ... | 20:29:12 | 20:29:12 | ... | 30 |
|
| ... | 20:29:54 | 20:29:54 | ... | 31 |
|
| ... | 20:31:02 | 20:31:02 | ... | 32 |
|
| ... | 20:31:48 | 20:31:48 | ... | 33 |
|
| ... | 20:32:23 | 20:32:23 | ... | 34 |
|
| ... | 20:33:33 | 20:33:33 | ... | 35 |
|
| ... | 20:34:31 | 20:34:31 | ... | 36 |
|
| ... | 20:35:08 | 20:35:08 | ... | 37 |
|
| ... | 20:36:00 | 20:36:00 | ... | 38 |
|
| ... | 20:36:46 | 20:36:46 | ... | 39 |
|
| ... | 20:37:34 | 20:37:34 | ... | 40 |
|
| ... | 20:38:13 | 20:38:13 | ... | 41 |
|
| ... | 20:38:56 | 20:38:56 | ... | 42 |
|
| ... | 20:39:35 | 20:39:35 | ... | 43 |
|
| ... | 20:40:07 | 20:40:07 | ... | 44 |
|
| ... | 20:40:52 | 20:40:52 | ... | 45 |
|
| ... | 20:41:35 | 20:41:35 | ... | 46 |
|
| ... | 20:42:14 | 20:42:14 | ... | 47 |
|
| ... | 20:43:17 | 20:43:17 | ... | 48 |
|
| ... | 20:43:52 | 20:43:52 | ... | 49 |
|
| ... | 20:44:28 | 20:44:28 | ... | 50 |
|
| ... | 20:45:15 | 20:45:15 | ... | 51 |
|
| ... | 20:46:00 | 20:46:00 | ... | 52 |
|
| ... | 20:46:20 | 20:46:20 | ... | 53 |
|
| ... | 20:46:44 | 20:46:44 | ... | 54 |
|
| ... | 20:47:12 | 20:47:12 | ... | 55 |
|
| ... | 20:47:49 | 20:47:49 | ... | 56 |
|
| ... | 20:48:24 | 20:48:24 | ... | 57 |
|
| ... | 20:48:49 | 20:48:49 | ... | 58 |
|
| ... | 20:49:20 | 20:49:20 | ... | 59 |
|
| ... | 20:50:13 | 20:50:13 | ... | 60 |
|
| ... | 20:51:00 | 20:51:00 | ... | 61 |
|
| ... | 20:52:18 | 20:52:18 | ... | 62 |
|
| ... | 20:53:46 | 20:53:46 | ... | 63 |
|
| ... | 20:54:22 | 20:54:22 | ... | 64 |
|
| ... | 20:54:45 | 20:54:45 | ... | 65 |
|
| ... | 20:55:27 | 20:55:27 | ... | 66 |
|
| ... | 20:55:50 | 20:55:50 | ... | 67 |
|
| ... | 20:56:11 | 20:56:11 | ... | 68 |
|
| ... | 20:56:41 | 20:56:41 | ... | 69 |
|
| ... | 20:57:17 | 20:57:17 | ... | 70 |
|
| ... | 20:57:47 | 20:57:47 | ... | 71 |
|
| ... | 20:58:40 | 20:58:40 | ... | 72 |
|
| ... | 20:59:06 | 20:59:06 | ... | 73 |
|
| ... | 20:59:37 | 20:59:37 | ... | 74 |
|
| ... | 21:00:05 | 21:00:05 | ... | 75 |
|
| ... | 21:00:41 | 21:00:41 | ... | 76 |
|
| ... | 21:01:16 | 21:01:16 | ... | 77 |
|
| ... | 21:02:15 | 21:02:15 | ... | 78 |
|
| ... | 21:02:55 | 21:02:55 | ... | 79 |
|
| ... | 21:04:06 | 21:04:06 | ... | 80 |
|
| ... | 21:05:00 | 21:05:00 | ... | 81 |
|
| 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 | |
|---|---|---|---|---|
| 29724643 | Ayr Railway Station | 55.4589170475 | -4.6241079443 | |
| 29723786 | Fire Station | 55.4601774281 | -4.6223407961 | |
| 29724365 | Craigie Way | 55.4629088059 | -4.6190416259 | |
| 29723625 | Beech Grove | 55.4619261152 | -4.6086616137 | |
| 29724374 | Craigie Lea | 55.4623328093 | -4.6127701566 | |
| 29724834 | Craigie way | 55.4615034164 | -4.6145662351 | |
| 29723948 | Churchill Crescent | 55.4625224898 | -4.6009173266 | |
| 29724345 | Robertson Crescent | 55.4638714635 | -4.596655404 | |
| 29724535 | Dunlop Terrace | 55.4649900594 | -4.5935013927 | |
| 29723898 | Walker Road | 55.4685024264 | -4.6109316015 | |
| 29723678 | Hawkhill Avenue | 55.4680092884 | -4.6133989798 | |
| 29723478 | Craigie Road | 55.4675567793 | -4.6164860704 | |
| 29724726 | Newton Primary School | 55.4667377086 | -4.6249283424 | |
| 29723538 | Craigie Road | 55.4671400972 | -4.6195754703 | |
| 29723824 | Mainholm Road | 55.4704864866 | -4.6009198361 | |
| 29724549 | Glenmuir Place | 55.4713948813 | -4.597086977 | |
| 29723974 | Whitletts Court | 55.4725397516 | -4.5939657584 | |
| 29724848 | Gould Street | 55.4699712114 | -4.6120256257 | |
| 29723629 | Walker Road | 55.4706567618 | -4.6140173142 | |
| 29723589 | St Georges Rd | 55.4735230457 | -4.6182741479 | |
| 29723946 | Cambuslea Road | 55.4753382098 | -4.6174608454 | |
| 29723294 | Ettrick Place | 55.4789414033 | -4.6154207204 | |
| 29724582 | Woodfield Avenue | 55.4822181359 | -4.6189777118 | |
| 29724768 | Woodfield Crescent | 55.4800469806 | -4.6204638571 | |
| 29724852 | Marchfield Road | 55.4836317492 | -4.6180268264 | |
| 29723429 | Bellesleyhill Road | 55.4774192163 | -4.6222835181 | |
| 29723543 | Lansdowne Road | 55.4760873725 | -4.6231920663 | |
| 29724835 | Tig Road | 55.4743355069 | -4.624404962 | |
| 29723846 | Caelaverock Road | 55.5022273003 | -4.6076057687 | |
| 29724625 | Merrick Avenue | 55.5012840479 | -4.6042019806 | |
| 29724789 | Manson Avenue | 55.5001084584 | -4.5986135636 | |
| 29723468 | Underwood Road | 55.4943573964 | -4.6040296044 | |
| 29724842 | Elmbank Street | 55.4718399526 | -4.6263436776 | |
| 29724579 | Police Station | 55.466614457 | -4.6285750849 | |
| 29724284 | Crown Street | 55.467569893 | -4.6301260252 | |
| 29723457 | Waggon Road | 55.4703784954 | -4.6278446436 | |
| 29724368 | Lilybank Road | 55.4856835162 | -4.6174981218 | |
| 29723728 | Bruce Avenue | 55.4881915535 | -4.6174903897 | |
| 29724869 | Kingscroft Road | 55.4906719163 | -4.6158343134 | |
| 29724645 | Brandon Gardens | 55.4926885918 | -4.6148439387 | |
| 29723526 | Grangemuir Road | 55.4949679295 | -4.6137600391 | |
| 29724686 | St. Quivox Road | 55.4969520606 | -4.6126089583 | |
| 29724354 | Kyle Street | 55.4985539217 | -4.611258265 | |
| 29724243 | Station Road | 55.5010118128 | -4.6110726427 | |
| 29724324 | St Ninians Pr School | 55.498193423 | -4.5990574212 | |
| 29723686 | Sanquhar Avenue | 55.4967703375 | -4.596651839 | |
| 29724689 | Raith Avenue | 55.4945110005 | -4.5946822601 | |
| 29723485 | Carnell Crescent | 55.4936970343 | -4.5987294524 | |
| 29724745 | Calvinston Road | 55.4862967246 | -4.6051913548 | |
| 29723285 | Ardfin Road | 55.4842738393 | -4.6060550262 | |
| 29723789 | Mosside Road | 55.4807715215 | -4.6092741889 | |
| 29723472 | Cathcart Street | 55.4638202686 | -4.6326924187 | |
| 29723473 | Killoch Place | 55.4583596952 | -4.6291329683 | |
| 29723835 | Carrick Street | 55.4614826655 | -4.6293725298 | |
| 29723896 | Town Hall | 55.4642952437 | -4.6315058457 | |
| 29723928 | Campbell Court | 55.4618011458 | -4.6060904824 | |
| 29724343 | West Sanquhar Road | 55.4719778099 | -4.6182349488 | |
| 29723632 | Biggart Hospital | 55.4920596247 | -4.6047170216 | |
| 29724385 | Moor Park Place | 55.4818329944 | -4.6071284233 | |
| 29723894 | Tweed Street | 55.4778450136 | -4.6162501813 | |
| 29724232 | Heathpark | 55.4816815836 | -4.612120132 | |
| 29724248 | Heathfield Road | 55.4808496329 | -4.6136161928 | |
| 29725848 | East Park Road | 55.476809912 | -4.6167354831 | |
| 29724942 | Fullarton Street | 55.4611605861 | -4.6313918729 | |
| 29724953 | Craigie Road | 55.4626570774 | -4.6173637654 | |
| 29725475 | Parks Garage | 55.4788495023 | -4.6020249335 | |
| 29785927 | Parks Garage | 55.4788509451 | -4.6015343906 | |
| 29786257 | Craigie Way | 55.4619205983 | -4.6030134159 | |
| 29792462 | Heathfield Road | 55.4758159327 | -4.5907943584 | |
| 29789598 | Asda Superstore | 55.4802053032 | -4.5953243072 | |
| 29726938 | Outdale Avenue | 55.4949210223 | -4.6007734524 | |
| 29796325 | Dalmilling Crescent | 55.4690481849 | -4.6013472385 | |
| 29795975 | Westwood Avenue | 55.4675078262 | -4.6002331054 | |
| 29796598 | Fairview | 55.4890467794 | -4.6039481639 |