Penicuik - Musselburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 05:31:00 | 05:31:00 | ... | 1 |
|
| ... | 05:32:00 | 05:32:00 | ... | 2 |
|
| ... | 05:33:00 | 05:33:00 | ... | 3 |
|
| ... | 05:35:00 | 05:35:00 | ... | 4 |
|
| ... | 05:36:00 | 05:36:00 | ... | 5 |
|
| ... | 05:39:00 | 05:39:00 | ... | 6 |
|
| ... | 05:39:00 | 05:39:00 | ... | 7 |
|
| ... | 05:41:00 | 05:41:00 | ... | 8 |
|
| ... | 05:45:00 | 05:45:00 | ... | 9 |
|
| ... | 05:46:00 | 05:46:00 | ... | 10 |
|
| ... | 05:47:00 | 05:47:00 | ... | 11 |
|
| ... | 05:47:00 | 05:47:00 | ... | 12 |
|
| ... | 05:48:00 | 05:48:00 | ... | 13 |
|
| ... | 05:48:00 | 05:48:00 | ... | 14 |
|
| ... | 05:49:00 | 05:49:00 | ... | 15 |
|
| ... | 05:50:00 | 05:50:00 | ... | 16 |
|
| ... | 05:50:00 | 05:50:00 | ... | 17 |
|
| ... | 05:51:00 | 05:51:00 | ... | 18 |
|
| ... | 05:52:00 | 05:52:00 | ... | 19 |
|
| ... | 05:52:00 | 05:52:00 | ... | 20 |
|
| ... | 05:53:00 | 05:53:00 | ... | 21 |
|
| ... | 05:54:00 | 05:54:00 | ... | 22 |
|
| ... | 05:55:00 | 05:55:00 | ... | 23 |
|
| ... | 05:56:00 | 05:56:00 | ... | 24 |
|
| ... | 05:57:00 | 05:57:00 | ... | 25 |
|
| ... | 05:57:00 | 05:57:00 | ... | 26 |
|
| ... | 05:58:00 | 05:58:00 | ... | 27 |
|
| ... | 05:59:00 | 05:59:00 | ... | 28 |
|
| ... | 06:00:00 | 06:00:00 | ... | 29 |
|
| ... | 06:01:00 | 06:01:00 | ... | 30 |
|
| ... | 06:02:00 | 06:02:00 | ... | 31 |
|
| ... | 06:03:00 | 06:03:00 | ... | 32 |
|
| ... | 06:05:00 | 06:05:00 | ... | 33 |
|
| ... | 06:05:00 | 06:05:00 | ... | 34 |
|
| ... | 06:06:00 | 06:06:00 | ... | 35 |
|
| ... | 06:07:00 | 06:07:00 | ... | 36 |
|
| ... | 06:07:00 | 06:07:00 | ... | 37 |
|
| ... | 06:08:00 | 06:08:00 | ... | 38 |
|
| ... | 06:08:00 | 06:08:00 | ... | 39 |
|
| ... | 06:09:00 | 06:09:00 | ... | 40 |
|
| ... | 06:10:00 | 06:10:00 | ... | 41 |
|
| ... | 06:11:00 | 06:11:00 | ... | 42 |
|
| ... | 06:11:00 | 06:11:00 | ... | 43 |
|
| ... | 06:11:00 | 06:11:00 | ... | 44 |
|
| ... | 06:12:00 | 06:12:00 | ... | 45 |
|
| ... | 06:13:00 | 06:13:00 | ... | 46 |
|
| ... | 06:13:00 | 06:13:00 | ... | 47 |
|
| ... | 06:14:00 | 06:14:00 | ... | 48 |
|
| ... | 06:14:00 | 06:14:00 | ... | 49 |
|
| ... | 06:14:00 | 06:14:00 | ... | 50 |
|
| ... | 06:15:00 | 06:15:00 | ... | 51 |
|
| ... | 06:16:00 | 06:16:00 | ... | 52 |
|
| ... | 06:16:00 | 06:16:00 | ... | 53 |
|
| ... | 06:18:00 | 06:18:00 | ... | 54 |
|
| ... | 06:19:00 | 06:19:00 | ... | 55 |
|
| ... | 06:20:00 | 06:20:00 | ... | 56 |
|
| ... | 06:21:00 | 06:21:00 | ... | 57 |
|
| ... | 06:22:00 | 06:22:00 | ... | 58 |
|
| ... | 06:22:00 | 06:22:00 | ... | 59 |
|
| ... | 06:23:00 | 06:23:00 | ... | 60 |
|
| ... | 06:24:00 | 06:24:00 | ... | 61 |
|
| ... | 06:24:00 | 06:24:00 | ... | 62 |
|
| ... | 06:24:00 | 06:24:00 | ... | 63 |
|
| ... | 06:25:00 | 06:25:00 | ... | 64 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 29/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 58232679 | Loretto RC Primary School | 55.9422668774 | -3.0475516348 | |
| 58232864 | Police Station | 55.9423500722 | -3.0525491921 | |
| 58232482 | Dolphin Inn | 55.9215852488 | -3.0366242824 | |
| 58232484 | Whitecraig Crescent | 55.9204531187 | -3.0387542692 | |
| 58234976 | Smeaton Road End | 55.9149544406 | -3.0419030551 | |
| 58232683 | Rothesay Place | 55.9390761865 | -3.0476576065 | |
| 58234959 | Inveresk Kennels | 55.9299282804 | -3.0403362701 | |
| 58234765 | Inveresk Village | 55.9348388581 | -3.0429810781 | |
| 64323539 | Dalkeith Parish Church | 55.8950669738 | -3.0684428809 | |
| 64323564 | Thornybank | 55.8968175573 | -3.056129286 | |
| 64323525 | Kings Park | 55.89159357 | -3.0741836666 | |
| 64323489 | Glenesk Crescent | 55.8903804002 | -3.0772840377 | |
| 64323486 | Eskbank Toll | 55.8887212171 | -3.0800040849 | |
| 64323649 | Station Road | 55.8875469396 | -3.0817301554 | |
| 64323652 | Westfield Park | 55.885180628 | -3.0851495163 | |
| 64323647 | Muirpark | 55.8829873062 | -3.0883015411 | |
| 64323285 | Mayshade Garden Centre | 55.8814258471 | -3.0911192643 | |
| 64323294 | Pendreich Avenue | 55.8797902138 | -3.0951974866 | |
| 64323425 | Waverley Crescent | 55.8776095826 | -3.1009223064 | |
| 64323283 | Maryfield Place | 55.8757248721 | -3.103682018 | |
| 64323832 | Muirfield Gardens | 55.8773374944 | -3.1503211221 | |
| 64323769 | George Avenue | 55.8767328107 | -3.1544430419 | |
| 64323796 | McNeil Avenue | 55.8760427791 | -3.1590258158 | |
| 64323828 | Park Avenue | 55.8757036666 | -3.1616369871 | |
| 64323787 | Herd Terrace | 55.875085633 | -3.1652307202 | |
| 64323764 | Dryden Road | 55.8747499124 | -3.1684172658 | |
| 64323826 | Nivensknowe Road | 55.8743463545 | -3.1739991435 | |
| 64323248 | Seafield Road | 55.8711730129 | -3.1769718365 | |
| 64323246 | Roslin Road | 55.8698422745 | -3.1780023059 | |
| 64323237 | Bilston Cottages | 55.8690351837 | -3.1778340421 | |
| 64324532 | Langhill Farm | 55.8651640746 | -3.1720123259 | |
| 64324538 | Roslin Institute | 55.8613001173 | -3.1691957605 | |
| 64324542 | Springfield Place | 55.8596566493 | -3.1681558251 | |
| 64324545 | Station Road | 55.8580021189 | -3.1654381527 | |
| 64324534 | Original Rosslyn Hotel | 55.857054844 | -3.163940021 | |
| 64324536 | Penicuik Road | 55.8555914357 | -3.1676024955 | |
| 64324547 | Woodend Park | 55.8563415269 | -3.1756446788 | |
| 64324745 | Roslin Surgery | 55.8571936977 | -3.1795525438 | |
| 64324678 | Gowkley Moss | 55.8576927217 | -3.1827948268 | |
| 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 | |
| 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 | |
| 64324373 | Town Centre | 55.8279932339 | -3.2216113449 | |
| 64323278 | High Street | 55.8755002651 | -3.1066804855 | |
| 64323293 | Park Road | 55.8770296329 | -3.1074752412 | |
| 64323297 | Rockville Terrace | 55.8783180321 | -3.1080873657 | |
| 64323267 | Broomieknowe Gardens | 55.8800983941 | -3.1099444089 | |
| 64323748 | Elm Row | 55.8833256211 | -3.1127702049 | |
| 64323752 | Laird and Dog | 55.8834382366 | -3.1152193583 | |
| 64324575 | Lasswade Road | 55.8831437041 | -3.1238915075 | |
| 64324579 | Kevock Road | 55.8810790712 | -3.1285795399 | |
| 64323793 | Hunter Avenue | 55.8777540113 | -3.1422614179 | |
| 64323763 | Academy Lane | 55.8775406302 | -3.1458835446 | |
| 64323568 | Thornyhall | 55.8975377112 | -3.0538779696 | |
| 64323549 | Shadepark | 55.8974402869 | -3.0631187758 | |
| 64323524 | Jarnac Court | 55.8940129229 | -3.0708285079 | |
| 64323496 | Corn Exchange | 55.8962990994 | -3.0672773771 |