Dumfries - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:55:00 | 09:55:00 | ... | 1 |
|
| ... | 09:55:00 | 09:55:00 | ... | 2 |
|
| ... | 09:57:00 | 09:57:00 | ... | 3 |
|
| ... | 09:58:00 | 09:58:00 | ... | 4 |
|
| ... | 09:59:00 | 09:59:00 | ... | 5 |
|
| ... | 10:00:00 | 10:00:00 | ... | 6 |
|
| ... | 10:02:00 | 10:02:00 | ... | 7 |
|
| ... | 10:04:00 | 10:04:00 | ... | 8 |
|
| ... | 10:05:00 | 10:05:00 | ... | 9 |
|
| ... | 10:05:00 | 10:05:00 | ... | 10 |
|
| ... | 10:05:00 | 10:05:00 | ... | 11 |
|
| ... | 10:05:00 | 10:05:00 | ... | 12 |
|
| ... | 10:06:00 | 10:06:00 | ... | 13 |
|
| ... | 10:07:00 | 10:07:00 | ... | 14 |
|
| ... | 10:10:00 | 10:10:00 | ... | 15 |
|
| ... | 10:11:00 | 10:11:00 | ... | 16 |
|
| ... | 10:14:00 | 10:14:00 | ... | 17 |
|
| ... | 10:15:00 | 10:15:00 | ... | 18 |
|
| ... | 10:15:00 | 10:15:00 | ... | 19 |
|
| ... | 10:18:00 | 10:18:00 | ... | 20 |
|
| ... | 10:21:00 | 10:21:00 | ... | 21 |
|
| ... | 10:25:00 | 10:25:00 | ... | 22 |
|
| ... | 10:27:00 | 10:27:00 | ... | 23 |
|
| ... | 10:28:00 | 10:28:00 | ... | 24 |
|
| ... | 10:30:00 | 10:30:00 | ... | 25 |
|
| ... | 10:30:00 | 10:30:00 | ... | 26 |
|
| ... | 10:33:00 | 10:33:00 | ... | 27 |
|
| ... | 10:34:00 | 10:34:00 | ... | 28 |
|
| ... | 10:35:00 | 10:35:00 | ... | 29 |
|
| ... | 10:35:00 | 10:35:00 | ... | 30 |
|
| ... | 10:35:00 | 10:35:00 | ... | 31 |
|
| ... | 10:56:00 | 10:56:00 | ... | 32 |
|
| ... | 11:03:00 | 11:03:00 | ... | 33 |
|
| ... | 11:08:00 | 11:08:00 | ... | 34 |
|
| ... | 11:13:00 | 11:13:00 | ... | 35 |
|
| ... | 11:18:00 | 11:18:00 | ... | 36 |
|
| ... | 11:23:00 | 11:23:00 | ... | 37 |
|
| ... | 11:26:00 | 11:26:00 | ... | 38 |
|
| ... | 11:27:00 | 11:27:00 | ... | 39 |
|
| ... | 11:28:00 | 11:28:00 | ... | 40 |
|
| ... | 11:28:00 | 11:28:00 | ... | 41 |
|
| ... | 11:28:00 | 11:28:00 | ... | 42 |
|
| ... | 11:32:00 | 11:32:00 | ... | 43 |
|
| ... | 11:38:00 | 11:38:00 | ... | 44 |
|
| ... | 11:38:00 | 11:38:00 | ... | 45 |
|
| ... | 11:39:00 | 11:39:00 | ... | 46 |
|
| ... | 11:40:00 | 11:40:00 | ... | 47 |
|
| ... | 11:46:00 | 11:46:00 | ... | 48 |
|
| ... | 11:50:00 | 11:50:00 | ... | 49 |
|
| ... | 11:52:00 | 11:52:00 | ... | 50 |
|
| ... | 11:54:00 | 11:54:00 | ... | 51 |
|
| ... | 11:56:00 | 11:56:00 | ... | 52 |
|
| ... | 11:57:00 | 11:57:00 | ... | 53 |
|
| ... | 11:59:00 | 11:59:00 | ... | 54 |
|
| ... | 12:00:00 | 12:00:00 | ... | 55 |
|
| ... | 12:00:00 | 12:00:00 | ... | 56 |
|
| ... | 12:00:00 | 12:00:00 | ... | 57 |
|
| ... | 12:01:00 | 12:01:00 | ... | 58 |
|
| ... | 12:01:00 | 12:01:00 | ... | 59 |
|
| ... | 12:01:00 | 12:01:00 | ... | 60 |
|
| ... | 12:01:00 | 12:01:00 | ... | 61 |
|
| ... | 12:02:00 | 12:02:00 | ... | 62 |
|
| ... | 12:02:00 | 12:02:00 | ... | 63 |
|
| ... | 12:03:00 | 12:03:00 | ... | 64 |
|
| ... | 12:03:00 | 12:03:00 | ... | 65 |
|
| ... | 12:04:00 | 12:04:00 | ... | 66 |
|
| ... | 12:04:00 | 12:04:00 | ... | 67 |
|
| ... | 12:05:00 | 12:05:00 | ... | 68 |
|
| ... | 12:06:00 | 12:06:00 | ... | 69 |
|
| ... | 12:07:00 | 12:07:00 | ... | 70 |
|
| ... | 12:08:00 | 12:08:00 | ... | 71 |
|
| ... | 12:08:00 | 12:08:00 | ... | 72 |
|
| ... | 12:11:00 | 12:11:00 | ... | 73 |
|
| ... | 12:12:00 | 12:12:00 | ... | 74 |
|
| ... | 12:15:00 | 12:15:00 | ... | 75 |
|
| ... | 12:16:00 | 12:16:00 | ... | 76 |
|
| ... | 12:17:00 | 12:17:00 | ... | 77 |
|
| ... | 12:17:00 | 12:17:00 | ... | 78 |
|
| ... | 12:18:00 | 12:18:00 | ... | 79 |
|
| ... | 12:19:00 | 12:19:00 | ... | 80 |
|
| ... | 12:19:00 | 12:19:00 | ... | 81 |
|
| ... | 12:20:00 | 12:20:00 | ... | 82 |
|
| ... | 12:21:00 | 12:21:00 | ... | 83 |
|
| ... | 12:22:00 | 12:22:00 | ... | 84 |
|
| ... | 12:22:00 | 12:22:00 | ... | 85 |
|
| ... | 12:23:00 | 12:23:00 | ... | 86 |
|
| ... | 12:26:00 | 12:26:00 | ... | 87 |
|
| ... | 12:26:00 | 12:26:00 | ... | 88 |
|
| ... | 12:29:00 | 12:29:00 | ... | 89 |
|
| ... | 12:32:00 | 12:32:00 | ... | 90 |
|
| ... | 12:33:00 | 12:33:00 | ... | 91 |
|
| ... | 12:34:00 | 12:34:00 | ... | 92 |
|
| ... | 12:36:00 | 12:36:00 | ... | 93 |
|
| ... | 12:37:00 | 12:37:00 | ... | 94 |
|
| ... | 12:40:00 | 12:40:00 | ... | 95 |
|
| ... | 12:41:00 | 12:41:00 | ... | 96 |
|
| ... | 12:44:00 | 12:44:00 | ... | 97 |
|
| ... | 12:45:00 | 12:45:00 | ... | 98 |
|
| ... | 12:48:00 | 12:48:00 | ... | 99 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 19/08/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 75234264 | Dunsyre Junction | 55.7024936861 | -3.430035113 | |
| 75234738 | Broughton Road | 55.6261166199 | -3.5192584976 | |
| 75235372 | John Street | 55.6246409071 | -3.5223142471 | |
| 75234687 | Emahroo | 55.5626405721 | -3.6186089981 | |
| 75232543 | Howgate Road | 55.5391760783 | -3.6721609122 | |
| 75236383 | Hunters Court | 55.4928337071 | -3.6922623478 | |
| 75235459 | Bellstane Avenue | 55.4669308447 | -3.6510199309 | |
| 75236569 | Town Hall | 55.7053263102 | -3.4260008544 | |
| 75232394 | Hillside Gardens | 55.7008419296 | -3.4322025395 | |
| 75232594 | Gasworks Road | 55.6227110644 | -3.5271943388 | |
| 75297262 | Abington Service Area | 55.5069407898 | -3.695670444 | |
| 75297272 | Memorial | 55.5908543484 | -3.5508063052 | |
| 75238386 | Leafield Road | 55.6280792522 | -3.5160624936 | |
| 75239286 | Candymill Road | 55.6588591261 | -3.4746359608 | |
| 75273969 | Moss Side Crescent | 55.6171178735 | -3.5368376244 | |
| 36237239 | Swanston Drive | 55.8969818812 | -3.2036766713 | |
| 36237237 | Swanston Avenue | 55.8990889401 | -3.2041417609 | |
| 36237235 | Fairmilehead Crossroads | 55.9020903677 | -3.2050344871 | |
| 36236989 | Caiystane Crescent | 55.9041992474 | -3.2071472786 | |
| 36236987 | Buckstone Road | 55.9066657983 | -3.2085196117 | |
| 36236985 | Pentland View | 55.9090335212 | -3.2098890436 | |
| 36236983 | Comiston Rise | 55.9105264344 | -3.2115833184 | |
| 36236979 | Comiston Springs Avenue | 55.9129585755 | -3.2137070339 | |
| 36236976 | Riselaw Road | 55.9153758904 | -3.2136865768 | |
| 36236974 | Braid Hills Hotel | 55.9172209863 | -3.2133762264 | |
| 36237242 | Morningside Station | 55.9260754247 | -3.2093478178 | |
| 36237243 | Springvalley Gardens | 55.9280686591 | -3.2095059435 | |
| 36237248 | Holy Corner | 55.9347466545 | -3.2102423149 | |
| 36236387 | Whitehouse Loan | 55.9397620902 | -3.2045871611 | |
| 36236389 | Leven Street | 55.9412900361 | -3.2036259368 | |
| 36245269 | Home Street | 55.9428973276 | -3.2037398446 | |
| 36236435 | Bread Street | 55.9451092463 | -3.2054256958 | |
| 36235967 | Usher Hall | 55.946479066 | -3.2059326276 | |
| 36232692 | Lothian Road | 55.9492015165 | -3.2068659972 | |
| 36235972 | Princes Street (west) | 55.9512566262 | -3.2016130961 | |
| 36235974 | Princes Street (Waverley Steps) | 55.9531880012 | -3.19055826 | |
| 36238543 | Leith Street | 55.9554593258 | -3.1870403387 | |
| 36243734 | Bus Station | 55.9553965367 | -3.1916831382 | |
| 64329254 | Carsewell | 55.8247112641 | -3.2610000527 | |
| 64323843 | Golf Club | 55.8926091015 | -3.2015104759 | |
| 64324562 | Hopelands Road | 55.8282671124 | -3.2717153278 | |
| 64324643 | Harlaw Grove | 55.828980042 | -3.231683868 | |
| 64324352 | Navaar House Hotel | 55.8266189079 | -3.2251759864 | |
| 64324243 | Ninemileburn | 55.8057677327 | -3.3101351153 | |
| 64323642 | Eastside Farm | 55.8197763857 | -3.2888993101 | |
| 64324279 | Craigiebield Crescent | 55.8279244367 | -3.2267176443 | |
| 64324325 | Lambs Pend | 55.8263020735 | -3.2217977772 | |
| 64324374 | Town Centre | 55.8277339983 | -3.221475507 | |
| 64324378 | Wilson Street | 55.828536691 | -3.2229853378 | |
| 64324328 | John Street Lane | 55.8302432123 | -3.2239648656 | |
| 64324267 | Angle Park | 55.8312560531 | -3.224220198 | |
| 64324284 | Cuiken Avenue | 55.833743806 | -3.2225420797 | |
| 64324358 | Queensway | 55.8363466165 | -3.2201328569 | |
| 64323625 | Fulford House | 55.8679087795 | -3.2123972123 | |
| 64323263 | Boghall Farm | 55.8737025882 | -3.2080227251 | |
| 64324347 | Mauricewood Road | 55.8392050277 | -3.2164059185 | |
| 64324269 | Beeslack High School | 55.8411841051 | -3.2125392725 | |
| 64324372 | Samoa Terrace | 55.8428530933 | -3.2091257435 | |
| 64324323 | Glencorse Barracks | 55.8460016852 | -3.2041765802 | |
| 64323939 | Golf Club | 55.8497644528 | -3.1998045899 | |
| 64323943 | Milton Cottages | 55.8517452113 | -3.1929330779 | |
| 64323452 | Gowkley Moss | 55.8575925542 | -3.1885271695 | |
| 64323454 | Pentland Science Park | 55.8581731236 | -3.1935294903 | |
| 64323436 | Bush Research Park | 55.8593654528 | -3.1975123133 | |
| 64323845 | Snowsports Centre | 55.8901337322 | -3.2010342325 | |
| 34232642 | Whitesands | 55.0684986646 | -3.6154951426 | |
| 34238594 | Edinburgh Road | 55.0799558414 | -3.5999625295 | |
| 34232747 | Lochthorn | 55.0979714078 | -3.5844455306 | |
| 34232843 | Garden Centre | 55.0901688229 | -3.5900912702 | |
| 34232872 | The Cross | 55.1256424399 | -3.5685092573 | |
| 34239434 | Shieldhill road end | 55.1401540887 | -3.5603083715 | |
| 34232896 | Ae Inn | 55.1722246659 | -3.5444151098 | |
| 34232928 | Primary School | 55.3053964567 | -3.4510929393 | |
| 34232932 | Old Stables Inn | 55.3070986951 | -3.452289432 | |
| 34239327 | High Street | 55.3331654749 | -3.4442569771 | |
| 34232935 | Esso Garage | 55.3310812782 | -3.4441969155 | |
| 34232936 | Esso Garage | 55.3309839576 | -3.4440672631 | |
| 34239283 | Golfhill Drive | 55.3272160012 | -3.4473191565 | |
| 34239284 | Golfhill Drive | 55.3270561775 | -3.447155706 | |
| 34232827 | Academy Street | 55.0719004393 | -3.6104010107 | |
| 34232897 | Barony College | 55.1763835454 | -3.5403204178 | |
| 34232952 | opp Shelter | 55.2000182764 | -3.4971124565 | |
| 34232323 | Village | 55.2266124388 | -3.4636312552 | |
| 34232893 | Bridgend | 55.1647905458 | -3.5544573542 | |
| 34232826 | Buccleuch Street | 55.0698551744 | -3.6148607006 | |
| 34232839 | Bloomfield | 55.0884079437 | -3.5927947455 | |
| 34232867 | Edinburgh Rd | 55.0929487547 | -3.5878040408 | |
| 34232743 | Gates Factory | 55.0953311767 | -3.5870522362 | |
| 34232868 | Hall | 55.1079563422 | -3.5795891351 | |
| 34232324 | Greystonerigg | 55.2673486922 | -3.4524279797 | |
| 34232325 | Tathhill Rd End | 55.2798920496 | -3.4435184505 | |
| 34232926 | Cleuchbrae Rd End | 55.2946286605 | -3.4497233794 | |
| 34232746 | Edinburgh Road | 55.0966477293 | -3.5860230444 | |
| 34232828 | Woodbank | 55.0746130201 | -3.6078002295 | |
| 34232832 | Edinburgh Road | 55.0782028173 | -3.6034171202 | |
| 34232838 | Edinburgh Road | 55.0837189548 | -3.5974180839 | |
| 72724843 | Bus Shelter | 55.7156462653 | -3.4155682204 | |
| 72724868 | Gordon Arms Hotel | 55.7539126582 | -3.3571059107 | |
| 72726942 | Allan Ramsey Sq | 55.7901977594 | -3.3399148658 |