Dumfries - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 09:04:00 | 09:04:00 | ... | 1 |
|
| ... | 09:04:00 | 09:04:00 | ... | 2 |
|
| ... | 09:04:00 | 09:04:00 | ... | 3 |
|
| ... | 09:05:00 | 09:05:00 | ... | 4 |
|
| ... | 09:06:00 | 09:06:00 | ... | 5 |
|
| ... | 09:06:00 | 09:06:00 | ... | 6 |
|
| ... | 09:07:00 | 09:07:00 | ... | 7 |
|
| ... | 09:09:00 | 09:09:00 | ... | 8 |
|
| ... | 09:10:00 | 09:10:00 | ... | 9 |
|
| ... | 09:11:00 | 09:11:00 | ... | 10 |
|
| ... | 09:12:00 | 09:12:00 | ... | 11 |
|
| ... | 09:13:00 | 09:13:00 | ... | 12 |
|
| ... | 09:15:00 | 09:15:00 | ... | 13 |
|
| ... | 09:15:00 | 09:15:00 | ... | 14 |
|
| ... | 09:18:00 | 09:18:00 | ... | 15 |
|
| ... | 09:18:00 | 09:18:00 | ... | 16 |
|
| ... | 09:20:00 | 09:20:00 | ... | 17 |
|
| ... | 09:23:00 | 09:23:00 | ... | 18 |
|
| ... | 09:25:00 | 09:25:00 | ... | 19 |
|
| ... | 09:25:00 | 09:25:00 | ... | 20 |
|
| ... | 09:26:00 | 09:26:00 | ... | 21 |
|
| ... | 09:28:00 | 09:28:00 | ... | 22 |
|
| ... | 09:29:00 | 09:29:00 | ... | 23 |
|
| ... | 09:29:00 | 09:29:00 | ... | 24 |
|
| ... | 09:29:00 | 09:29:00 | ... | 25 |
|
| ... | 09:31:00 | 09:31:00 | ... | 26 |
|
| ... | 09:34:00 | 09:34:00 | ... | 27 |
|
| ... | 09:39:00 | 09:39:00 | ... | 28 |
|
| ... | 09:44:00 | 09:44:00 | ... | 29 |
|
| ... | 09:56:00 | 09:56:00 | ... | 30 |
|
| ... | 10:02:00 | 10:02:00 | ... | 31 |
|
| ... | 10:09:00 | 10:09:00 | ... | 32 |
|
| ... | 10:15:00 | 10:15:00 | ... | 33 |
|
| ... | 10:20:00 | 10:20:00 | ... | 34 |
|
| ... | 10:26:00 | 10:26:00 | ... | 35 |
|
| ... | 10:31:00 | 10:31:00 | ... | 36 |
|
| ... | 10:35:00 | 10:35:00 | ... | 37 |
|
| ... | 10:36:00 | 10:36:00 | ... | 38 |
|
| ... | 10:37:00 | 10:37:00 | ... | 39 |
|
| ... | 10:37:00 | 10:37:00 | ... | 40 |
|
| ... | 10:37:00 | 10:37:00 | ... | 41 |
|
| ... | 10:41:00 | 10:41:00 | ... | 42 |
|
| ... | 10:47:00 | 10:47:00 | ... | 43 |
|
| ... | 10:47:00 | 10:47:00 | ... | 44 |
|
| ... | 10:48:00 | 10:48:00 | ... | 45 |
|
| ... | 10:49:00 | 10:49:00 | ... | 46 |
|
| ... | 10:55:00 | 10:55:00 | ... | 47 |
|
| ... | 10:59:00 | 10:59:00 | ... | 48 |
|
| ... | 11:01:00 | 11:01:00 | ... | 49 |
|
| ... | 11:03:00 | 11:03:00 | ... | 50 |
|
| ... | 11:05:00 | 11:05:00 | ... | 51 |
|
| ... | 11:06:00 | 11:06:00 | ... | 52 |
|
| ... | 11:08:00 | 11:08:00 | ... | 53 |
|
| ... | 11:09:00 | 11:09:00 | ... | 54 |
|
| ... | 11:09:00 | 11:09:00 | ... | 55 |
|
| ... | 11:09:00 | 11:09:00 | ... | 56 |
|
| ... | 11:10:00 | 11:10:00 | ... | 57 |
|
| ... | 11:10:00 | 11:10:00 | ... | 58 |
|
| ... | 11:10:00 | 11:10:00 | ... | 59 |
|
| ... | 11:10:00 | 11:10:00 | ... | 60 |
|
| ... | 11:11:00 | 11:11:00 | ... | 61 |
|
| ... | 11:11:00 | 11:11:00 | ... | 62 |
|
| ... | 11:12:00 | 11:12:00 | ... | 63 |
|
| ... | 11:12:00 | 11:12:00 | ... | 64 |
|
| ... | 11:13:00 | 11:13:00 | ... | 65 |
|
| ... | 11:13:00 | 11:13:00 | ... | 66 |
|
| ... | 11:14:00 | 11:14:00 | ... | 67 |
|
| ... | 11:15:00 | 11:15:00 | ... | 68 |
|
| ... | 11:16:00 | 11:16:00 | ... | 69 |
|
| ... | 11:17:00 | 11:17:00 | ... | 70 |
|
| ... | 11:17:00 | 11:17:00 | ... | 71 |
|
| ... | 11:20:00 | 11:20:00 | ... | 72 |
|
| ... | 11:21:00 | 11:21:00 | ... | 73 |
|
| ... | 11:24:00 | 11:24:00 | ... | 74 |
|
| ... | 11:25:00 | 11:25:00 | ... | 75 |
|
| ... | 11:26:00 | 11:26:00 | ... | 76 |
|
| ... | 11:26:00 | 11:26:00 | ... | 77 |
|
| ... | 11:27:00 | 11:27:00 | ... | 78 |
|
| ... | 11:27:00 | 11:27:00 | ... | 79 |
|
| ... | 11:28:00 | 11:28:00 | ... | 80 |
|
| ... | 11:29:00 | 11:29:00 | ... | 81 |
|
| ... | 11:29:00 | 11:29:00 | ... | 82 |
|
| ... | 11:30:00 | 11:30:00 | ... | 83 |
|
| ... | 11:31:00 | 11:31:00 | ... | 84 |
|
| ... | 11:31:00 | 11:31:00 | ... | 85 |
|
| ... | 11:34:00 | 11:34:00 | ... | 86 |
|
| ... | 11:34:00 | 11:34:00 | ... | 87 |
|
| ... | 11:37:00 | 11:37:00 | ... | 88 |
|
| ... | 11:40:00 | 11:40:00 | ... | 89 |
|
| ... | 11:41:00 | 11:41:00 | ... | 90 |
|
| ... | 11:42:00 | 11:42:00 | ... | 91 |
|
| ... | 11:44:00 | 11:44:00 | ... | 92 |
|
| ... | 11:45:00 | 11:45:00 | ... | 93 |
|
| ... | 11:48:00 | 11:48:00 | ... | 94 |
|
| ... | 11:50:00 | 11:50:00 | ... | 95 |
|
| ... | 11:53:00 | 11:53:00 | ... | 96 |
|
| ... | 11:55:00 | 11:55:00 | ... | 97 |
|
| ... | 11:58:00 | 11:58:00 | ... | 98 |
|
| 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 | |
| 75298249 | Leadhills Road | 55.4372340953 | -3.6579834516 | |
| 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 | |
| 34232648 | Glasgow Road | 55.0798953446 | -3.6282520089 | |
| 34232649 | Jocks Loaning | 55.0834321916 | -3.6312471216 | |
| 34232658 | Old Holywood | 55.1102474779 | -3.6567496032 | |
| 34232539 | Ballochan Road | 55.1639331596 | -3.7097605904 | |
| 34232683 | Main Street | 55.2127819245 | -3.7356359554 | |
| 34232686 | Main Street | 55.2139810706 | -3.7372600055 | |
| 34232694 | Cross | 55.2401938257 | -3.7644029438 | |
| 34232693 | Drumlanrig St | 55.2389759605 | -3.7628547965 | |
| 34232482 | Carronbank | 55.2618221078 | -3.7801549101 | |
| 34232675 | Friars Carse Rd End | 55.1423794488 | -3.69317981 | |
| 34232483 | Drumlanrig St | 55.2432917183 | -3.7683154207 | |
| 34232486 | Drumlanrig St | 55.2417187414 | -3.7664681461 | |
| 34232672 | Portrack | 55.1307577068 | -3.6802804427 | |
| 34239463 | Glengower Farm | 55.1239581881 | -3.670851696 | |
| 34232645 | Glasgow Street | 55.0700384663 | -3.6200051081 | |
| 34232646 | Glasgow Street | 55.0722358722 | -3.6216914961 | |
| 34232647 | Glasgow Street | 55.0750104161 | -3.6225556137 | |
| 34232653 | Farm | 55.0887385499 | -3.6396580972 | |
| 34232628 | Dalawoodie | 55.0960937127 | -3.6460556047 | |
| 34232654 | Village | 55.100995326 | -3.6484514465 | |
| 34232673 | Courthill Caravan Park | 55.1389889595 | -3.6894591657 | |
| 34232678 | Inn | 55.1609586838 | -3.7084559705 | |
| 34232537 | Stepends Rd End | 55.1807077468 | -3.7266711644 | |
| 34232684 | A76 | 55.1984375735 | -3.7230075914 | |
| 34232687 | Trigony House | 55.2210603311 | -3.745004711 | |
| 34232478 | Holestane | 55.2809780444 | -3.7743205977 | |
| 34232475 | Village | 55.3188743815 | -3.7608521426 | |
| 34232472 | Dalveen | 55.3431561186 | -3.7377389123 | |
| 72724843 | Bus Shelter | 55.7156462653 | -3.4155682204 | |
| 72724868 | Gordon Arms Hotel | 55.7539126582 | -3.3571059107 | |
| 72726942 | Allan Ramsey Sq | 55.7901977594 | -3.3399148658 |