Dumfries - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 13:45:00 | 13:45:00 | ... | 1 |
|
| ... | 13:48:00 | 13:48:00 | ... | 2 |
|
| ... | 13:50:00 | 13:50:00 | ... | 3 |
|
| ... | 13:53:00 | 13:53:00 | ... | 4 |
|
| ... | 13:54:00 | 13:54:00 | ... | 5 |
|
| ... | 13:56:00 | 13:56:00 | ... | 6 |
|
| ... | 13:59:00 | 13:59:00 | ... | 7 |
|
| ... | 13:59:00 | 13:59:00 | ... | 8 |
|
| ... | 14:00:00 | 14:00:00 | ... | 9 |
|
| ... | 14:02:00 | 14:02:00 | ... | 10 |
|
| ... | 14:05:00 | 14:05:00 | ... | 11 |
|
| ... | 14:07:00 | 14:07:00 | ... | 12 |
|
| ... | 14:09:00 | 14:09:00 | ... | 13 |
|
| ... | 14:10:00 | 14:10:00 | ... | 14 |
|
| ... | 14:10:00 | 14:10:00 | ... | 15 |
|
| ... | 14:11:00 | 14:11:00 | ... | 16 |
|
| ... | 14:12:00 | 14:12:00 | ... | 17 |
|
| ... | 14:13:00 | 14:13:00 | ... | 18 |
|
| ... | 14:14:00 | 14:14:00 | ... | 19 |
|
| ... | 14:14:00 | 14:14:00 | ... | 20 |
|
| ... | 14:15:00 | 14:15:00 | ... | 21 |
|
| ... | 14:16:00 | 14:16:00 | ... | 22 |
|
| ... | 14:17:00 | 14:17:00 | ... | 23 |
|
| ... | 14:20:00 | 14:20:00 | ... | 24 |
|
| ... | 14:22:00 | 14:22:00 | ... | 25 |
|
| ... | 14:24:00 | 14:24:00 | ... | 26 |
|
| ... | 14:25:00 | 14:25:00 | ... | 27 |
|
| ... | 14:25:00 | 14:25:00 | ... | 28 |
|
| ... | 14:26:00 | 14:26:00 | ... | 29 |
|
| ... | 14:26:00 | 14:26:00 | ... | 30 |
|
| ... | 14:27:00 | 14:27:00 | ... | 31 |
|
| ... | 14:29:00 | 14:29:00 | ... | 32 |
|
| ... | 14:29:00 | 14:29:00 | ... | 33 |
|
| ... | 14:30:00 | 14:30:00 | ... | 34 |
|
| ... | 14:31:00 | 14:31:00 | ... | 35 |
|
| ... | 14:32:00 | 14:32:00 | ... | 36 |
|
| ... | 14:32:00 | 14:32:00 | ... | 37 |
|
| ... | 14:33:00 | 14:33:00 | ... | 38 |
|
| ... | 14:34:00 | 14:34:00 | ... | 39 |
|
| ... | 14:34:00 | 14:34:00 | ... | 40 |
|
| ... | 14:35:00 | 14:35:00 | ... | 41 |
|
| ... | 14:35:00 | 14:35:00 | ... | 42 |
|
| ... | 14:35:00 | 14:35:00 | ... | 43 |
|
| ... | 14:35:00 | 14:35:00 | ... | 44 |
|
| ... | 14:36:00 | 14:36:00 | ... | 45 |
|
| ... | 14:38:00 | 14:38:00 | ... | 46 |
|
| ... | 14:40:00 | 14:40:00 | ... | 47 |
|
| ... | 14:41:00 | 14:41:00 | ... | 48 |
|
| ... | 14:42:00 | 14:42:00 | ... | 49 |
|
| ... | 14:45:00 | 14:45:00 | ... | 50 |
|
| ... | 14:50:00 | 14:50:00 | ... | 51 |
|
| ... | 14:55:00 | 14:55:00 | ... | 52 |
|
| ... | 14:57:00 | 14:57:00 | ... | 53 |
|
| ... | 14:57:00 | 14:57:00 | ... | 54 |
|
| ... | 14:57:00 | 14:57:00 | ... | 55 |
|
| ... | 15:03:00 | 15:03:00 | ... | 56 |
|
| ... | 15:07:00 | 15:07:00 | ... | 57 |
|
| ... | 15:07:00 | 15:07:00 | ... | 58 |
|
| ... | 15:08:00 | 15:08:00 | ... | 59 |
|
| ... | 15:08:00 | 15:08:00 | ... | 60 |
|
| ... | 15:09:00 | 15:09:00 | ... | 61 |
|
| ... | 15:14:00 | 15:14:00 | ... | 62 |
|
| ... | 15:19:00 | 15:19:00 | ... | 63 |
|
| ... | 15:25:00 | 15:25:00 | ... | 64 |
|
| ... | 15:30:00 | 15:30:00 | ... | 65 |
|
| ... | 15:34:00 | 15:34:00 | ... | 66 |
|
| ... | 15:41:00 | 15:41:00 | ... | 67 |
|
| ... | 15:46:00 | 15:46:00 | ... | 68 |
|
| ... | 15:58:00 | 15:58:00 | ... | 69 |
|
| ... | 16:04:00 | 16:04:00 | ... | 70 |
|
| ... | 16:09:00 | 16:09:00 | ... | 71 |
|
| ... | 16:12:00 | 16:12:00 | ... | 72 |
|
| ... | 16:15:00 | 16:15:00 | ... | 73 |
|
| ... | 16:15:00 | 16:15:00 | ... | 74 |
|
| ... | 16:16:00 | 16:16:00 | ... | 75 |
|
| ... | 16:16:00 | 16:16:00 | ... | 76 |
|
| ... | 16:18:00 | 16:18:00 | ... | 77 |
|
| ... | 16:19:00 | 16:19:00 | ... | 78 |
|
| ... | 16:20:00 | 16:20:00 | ... | 79 |
|
| ... | 16:21:00 | 16:21:00 | ... | 80 |
|
| ... | 16:23:00 | 16:23:00 | ... | 81 |
|
| ... | 16:25:00 | 16:25:00 | ... | 82 |
|
| ... | 16:26:00 | 16:26:00 | ... | 83 |
|
| ... | 16:28:00 | 16:28:00 | ... | 84 |
|
| ... | 16:28:00 | 16:28:00 | ... | 85 |
|
| ... | 16:29:00 | 16:29:00 | ... | 86 |
|
| ... | 16:30:00 | 16:30:00 | ... | 87 |
|
| ... | 16:31:00 | 16:31:00 | ... | 88 |
|
| ... | 16:33:00 | 16:33:00 | ... | 89 |
|
| ... | 16:33:00 | 16:33:00 | ... | 90 |
|
| ... | 16:35:00 | 16:35:00 | ... | 91 |
|
| ... | 16:36:00 | 16:36:00 | ... | 92 |
|
| ... | 16:37:00 | 16:37:00 | ... | 93 |
|
| ... | 16:39:00 | 16:39:00 | ... | 94 |
|
| ... | 16:39:00 | 16:39:00 | ... | 95 |
|
| ... | 16:40:00 | 16:40:00 | ... | 96 |
|
| ... | 16:41:00 | 16:41:00 | ... | 97 |
|
| 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 | |
|---|---|---|---|---|
| 75234784 | Roselea | 55.7054564965 | -3.4256236508 | |
| 75232839 | Dunsyre Junction | 55.7023413573 | -3.4299977225 | |
| 75232482 | Hillside Gardens | 55.7006609845 | -3.4323073078 | |
| 75235758 | Candymill Road | 55.6583685488 | -3.4750784801 | |
| 75234968 | Cross Road | 55.6264730159 | -3.5187799273 | |
| 75235263 | John Street | 55.6247796567 | -3.5212714177 | |
| 75234794 | Gasworks Road | 55.6224364631 | -3.5275965652 | |
| 75232568 | Emahroo | 55.5622161278 | -3.6187659677 | |
| 75296454 | Colebrooke Terrace | 55.4930878134 | -3.6920832939 | |
| 75295467 | Bellstane Avenue | 55.4666064115 | -3.6504210791 | |
| 75254537 | Howgate Road | 55.5391889514 | -3.6718761976 | |
| 75239839 | Station Road | 55.4373021059 | -3.6576069372 | |
| 75297262 | Abington Service Area | 55.5069407898 | -3.695670444 | |
| 75297269 | Memorial | 55.5909896801 | -3.5507640386 | |
| 75238387 | Leafield Road | 55.6279257719 | -3.5161200994 | |
| 75298592 | Moss Side Crescent | 55.6170659704 | -3.5366768047 | |
| 36232525 | Princes Street (Scott Mon.) | 55.9523439105 | -3.1942158046 | |
| 36232543 | Princes Street (west) | 55.9510309639 | -3.2017182064 | |
| 36232548 | Lothian Road | 55.949204339 | -3.2065778373 | |
| 36232549 | Usher Hall | 55.9471002869 | -3.2058078239 | |
| 36232562 | Bread Street | 55.9453453041 | -3.2051768361 | |
| 36232564 | Home Street | 55.9426219893 | -3.2034110811 | |
| 36232565 | Leven Street | 55.9413557303 | -3.2033397855 | |
| 36232567 | Whitehouse Loan | 55.9389066915 | -3.20476873 | |
| 36232568 | Holy Corner | 55.9347847867 | -3.2100193945 | |
| 36238593 | Springvalley Gardens | 55.9287617471 | -3.2093834909 | |
| 36232573 | Morningside Station | 55.9256182454 | -3.2092375522 | |
| 36236973 | Braid Hills Hotel | 55.9174395674 | -3.213079043 | |
| 36236975 | Riselaw Road | 55.9153251463 | -3.2133649949 | |
| 36236978 | Comiston Springs Avenue | 55.912826671 | -3.2134149342 | |
| 36236982 | Comiston Rise | 55.9111691033 | -3.2120193143 | |
| 36236984 | Pentland View | 55.9092229458 | -3.2098149569 | |
| 36236986 | Buckstone Road | 55.9064531926 | -3.2082090716 | |
| 36237232 | Caiystane Crescent | 55.9036690544 | -3.2062350869 | |
| 36237234 | Fairmilehead Crossroads | 55.9022988507 | -3.2048490195 | |
| 36237236 | Swanston Avenue | 55.8993428051 | -3.203909729 | |
| 36237238 | Swanston Drive | 55.897576312 | -3.203535157 | |
| 36243734 | Bus Station | 55.9553965367 | -3.1916831382 | |
| 64323624 | Fulford House | 55.8679484878 | -3.2120149221 | |
| 64323639 | Eastside Farm | 55.8191598776 | -3.2894215804 | |
| 64324242 | Ninemileburn | 55.8056177473 | -3.3098747967 | |
| 64329253 | Carsewell | 55.8243606094 | -3.2610206315 | |
| 64328253 | Hopelands Road | 55.8292031993 | -3.272432356 | |
| 64323846 | Snowsports Centre | 55.8911156711 | -3.2007767539 | |
| 64323728 | Bush Access | 55.858559961 | -3.1860484149 | |
| 64323437 | Bush Research Park | 55.8593871488 | -3.1971295384 | |
| 64323453 | Pentland Science Park | 55.8581382749 | -3.1924899656 | |
| 64325843 | Gowkley Moss | 55.8578192876 | -3.1883104276 | |
| 64323942 | Milton Cottages | 55.8526217945 | -3.190563842 | |
| 64323938 | Golf Club | 55.8496890556 | -3.1992432187 | |
| 64324298 | Glencorse Barracks | 55.8461417416 | -3.2036378855 | |
| 64324369 | Samoa Terrace | 55.8433505103 | -3.2069692384 | |
| 64324272 | Beeslack High School | 55.8403934627 | -3.2134408603 | |
| 64323262 | Boghall Farm | 55.8738787507 | -3.2074687999 | |
| 64324346 | Mauricewood Road | 55.8388423967 | -3.2167299295 | |
| 64324357 | Queensway | 55.8357794284 | -3.2202428284 | |
| 64324283 | Cuiken Avenue | 55.8334213744 | -3.2224361644 | |
| 64324265 | Angle Park | 55.8312327577 | -3.2238522646 | |
| 64324376 | Wilson Street | 55.8291385439 | -3.2230042284 | |
| 64329264 | Town Centre | 55.8279437743 | -3.2211628044 | |
| 64324324 | Lambs Pend | 55.8261698665 | -3.2215382208 | |
| 64324349 | Navaar House Hotel | 55.8263664335 | -3.2252638282 | |
| 64324278 | Craigiebield Crescent | 55.8273519205 | -3.2264601653 | |
| 64324368 | Harlaw Grove | 55.8287349476 | -3.2319315489 | |
| 64323727 | Bush Access | 55.8583584864 | -3.1864416835 | |
| 34232825 | Whitesands | 55.0688715659 | -3.6158390553 | |
| 34232797 | Rhino | 55.0798203652 | -3.627810328 | |
| 34235484 | Jocks Loaning | 55.0848839383 | -3.6322306134 | |
| 34232657 | Old Holywood | 55.1101086638 | -3.6563832763 | |
| 34232542 | Ballochan Road | 55.1639910125 | -3.7094804896 | |
| 34232682 | Main Street | 55.2130233129 | -3.7357250538 | |
| 34232685 | Main Street | 55.2139920661 | -3.7371190181 | |
| 34232695 | Cross | 55.2400389771 | -3.7639242189 | |
| 34232692 | Drumlanrig St | 55.2388922768 | -3.7624264263 | |
| 34232479 | Carronbank | 55.2618515756 | -3.7799831154 | |
| 34232676 | Friars Carse Rd End | 55.1429153188 | -3.6934221721 | |
| 34232484 | Drumlanrig St | 55.2433950714 | -3.7680054059 | |
| 34232485 | Drumlanrig St | 55.2418234551 | -3.7660638217 | |
| 34232659 | Portrack | 55.1307795625 | -3.67999902 | |
| 34239464 | Glengower Farm | 55.1239780871 | -3.6707113809 | |
| 34232824 | Glasgow Street | 55.0699459077 | -3.6195315187 | |
| 34232823 | Glasgow Street | 55.0726538604 | -3.6213481657 | |
| 34232789 | Goldie Park | 55.075344644 | -3.6224281712 | |
| 34238656 | Farm | 55.0876993648 | -3.6374062871 | |
| 34232627 | Dalawoodie | 55.0966349795 | -3.6459054595 | |
| 34232656 | Village | 55.1007604366 | -3.6478775208 | |
| 34232674 | Courthill Caravan Park | 55.1389753433 | -3.6891448134 | |
| 34232679 | Inn | 55.1609970305 | -3.7082849373 | |
| 34232538 | Stepends Rd End | 55.178933351 | -3.7263117358 | |
| 34232563 | A76 | 55.1982641497 | -3.7225601581 | |
| 34232689 | Trigony House | 55.2210735832 | -3.7447065863 | |
| 34232476 | Holestane | 55.2809448632 | -3.7741301766 | |
| 34232474 | Village | 55.3187962735 | -3.7606595591 | |
| 34232473 | Dalveen | 55.3430404798 | -3.7376549999 | |
| 72724963 | Allan Ramsey Sq | 55.7904707105 | -3.3396052613 | |
| 72723314 | Old Creamery Bus Shelter | 55.7156165714 | -3.4150259162 | |
| 72724869 | Gordon Arms Hotel | 55.7542192824 | -3.3561923822 |