Penicuik or Gowkley Moss - Silverknowes
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 04:19:00 | 04:19:00 | ... | 1 |
|
| ... | 04:21:00 | 04:21:00 | ... | 2 |
|
| ... | 04:23:00 | 04:23:00 | ... | 3 |
|
| ... | 04:24:00 | 04:24:00 | ... | 4 |
|
| ... | 04:25:00 | 04:25:00 | ... | 5 |
|
| ... | 04:26:00 | 04:26:00 | ... | 6 |
|
| ... | 04:27:00 | 04:27:00 | ... | 7 |
|
| ... | 04:28:00 | 04:28:00 | ... | 8 |
|
| ... | 04:29:00 | 04:29:00 | ... | 9 |
|
| ... | 04:29:00 | 04:29:00 | ... | 10 |
|
| ... | 04:29:00 | 04:29:00 | ... | 11 |
|
| ... | 04:30:00 | 04:30:00 | ... | 12 |
|
| ... | 04:30:00 | 04:30:00 | ... | 13 |
|
| ... | 04:31:00 | 04:31:00 | ... | 14 |
|
| ... | 04:31:00 | 04:31:00 | ... | 15 |
|
| ... | 04:31:00 | 04:31:00 | ... | 16 |
|
| ... | 04:32:00 | 04:32:00 | ... | 17 |
|
| ... | 04:32:00 | 04:32:00 | ... | 18 |
|
| ... | 04:33:00 | 04:33:00 | ... | 19 |
|
| ... | 04:33:00 | 04:33:00 | ... | 20 |
|
| ... | 04:34:00 | 04:34:00 | ... | 21 |
|
| ... | 04:34:00 | 04:34:00 | ... | 22 |
|
| ... | 04:35:00 | 04:35:00 | ... | 23 |
|
| ... | 04:35:00 | 04:35:00 | ... | 24 |
|
| ... | 04:36:00 | 04:36:00 | ... | 25 |
|
| ... | 04:37:00 | 04:37:00 | ... | 26 |
|
| ... | 04:37:00 | 04:37:00 | ... | 27 |
|
| ... | 04:37:00 | 04:37:00 | ... | 28 |
|
| ... | 04:38:00 | 04:38:00 | ... | 29 |
|
| ... | 04:38:00 | 04:38:00 | ... | 30 |
|
| ... | 04:40:00 | 04:40:00 | ... | 31 |
|
| ... | 04:40:00 | 04:40:00 | ... | 32 |
|
| ... | 04:41:00 | 04:41:00 | ... | 33 |
|
| ... | 04:41:00 | 04:41:00 | ... | 34 |
|
| ... | 04:42:00 | 04:42:00 | ... | 35 |
|
| ... | 04:43:00 | 04:43:00 | ... | 36 |
|
| ... | 04:43:00 | 04:43:00 | ... | 37 |
|
| ... | 04:44:00 | 04:44:00 | ... | 38 |
|
| ... | 04:45:00 | 04:45:00 | ... | 39 |
|
| ... | 04:45:00 | 04:45:00 | ... | 40 |
|
| ... | 04:46:00 | 04:46:00 | ... | 41 |
|
| ... | 04:46:00 | 04:46:00 | ... | 42 |
|
| ... | 04:47:00 | 04:47:00 | ... | 43 |
|
| ... | 04:47:00 | 04:47:00 | ... | 44 |
|
| ... | 04:48:00 | 04:48:00 | ... | 45 |
|
| ... | 04:48:00 | 04:48:00 | ... | 46 |
|
| ... | 04:49:00 | 04:49:00 | ... | 47 |
|
| ... | 04:49:00 | 04:49:00 | ... | 48 |
|
| ... | 04:50:00 | 04:50:00 | ... | 49 |
|
| ... | 04:51:00 | 04:51:00 | ... | 50 |
|
| ... | 04:51:00 | 04:51:00 | ... | 51 |
|
| ... | 04:52:00 | 04:52:00 | ... | 52 |
|
| ... | 04:52:00 | 04:52:00 | ... | 53 |
|
| ... | 04:52:00 | 04:52:00 | ... | 54 |
|
| ... | 04:53:00 | 04:53:00 | ... | 55 |
|
| ... | 04:53:00 | 04:53:00 | ... | 56 |
|
| ... | 04:54:00 | 04:54:00 | ... | 57 |
|
| ... | 04:55:00 | 04:55:00 | ... | 58 |
|
| ... | 04:56:00 | 04:56:00 | ... | 59 |
|
| ... | 04:56:00 | 04:56:00 | ... | 60 |
|
| ... | 04:57:00 | 04:57:00 | ... | 61 |
|
| ... | 04:57:00 | 04:57:00 | ... | 62 |
|
| ... | 04:58:00 | 04:58:00 | ... | 63 |
|
| ... | 04:59:00 | 04:59:00 | ... | 64 |
|
| ... | 05:00:00 | 05:00:00 | ... | 65 |
|
| 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 | |
|---|---|---|---|---|
| 36234754 | North Bridge | 55.9512188531 | -3.187903456 | |
| 36234757 | South Bridge | 55.9485179212 | -3.1865877051 | |
| 36234759 | Surgeons' Hall | 55.945376453 | -3.184362001 | |
| 36234797 | St Patrick Square | 55.9426353289 | -3.1825491347 | |
| 36234823 | Kings Hall | 55.9405252766 | -3.1805155796 | |
| 36234784 | Newington Road | 55.9389210857 | -3.1791379895 | |
| 36234837 | Salisbury Place | 55.9371032788 | -3.177545918 | |
| 36234838 | Minto Street | 55.9348789583 | -3.175237337 | |
| 36234839 | Mayfield Gardens | 55.9326188134 | -3.1729119335 | |
| 36234842 | East Savile Road | 55.9306785086 | -3.1709645881 | |
| 36234843 | Suffolk Road | 55.9290049248 | -3.1693135678 | |
| 36234845 | Lygon Road | 55.9269410742 | -3.1671228044 | |
| 36237845 | Lady Road | 55.9259042095 | -3.1665474946 | |
| 36237847 | Mid Liberton | 55.9238252137 | -3.1669011117 | |
| 36237848 | Gordon Terrace | 55.9213240188 | -3.1672420006 | |
| 36237852 | Liberton Tower Mains | 55.9186014336 | -3.1672401692 | |
| 36237892 | Orchardhead Loan | 55.9157504693 | -3.1665624873 | |
| 36237856 | Hawkhead Crescent | 55.914258596 | -3.1646937616 | |
| 36237858 | Liberton Cemetery | 55.9130834318 | -3.1635386084 | |
| 36247274 | Liberton Place | 55.9117214986 | -3.1631298527 | |
| 36237862 | Little Road | 55.9088810719 | -3.1632367703 | |
| 36237864 | St Katherines Brae | 55.9070860579 | -3.1639668428 | |
| 36237867 | Mortonhall Crematorium | 55.9041839192 | -3.1658472999 | |
| 36237869 | Balmwell Terrace | 55.9010321463 | -3.1637215235 | |
| 36237872 | Captain's Road | 55.8997691015 | -3.1623562567 | |
| 36237873 | Janefield | 55.8982082455 | -3.1611261165 | |
| 36237874 | Bus Turning Circle | 55.8961590703 | -3.1611768389 | |
| 36237875 | Burdiehouse Village | 55.8937582008 | -3.1613609679 | |
| 36232575 | Elm Row | 55.9585442953 | -3.1839312654 | |
| 36253587 | Leith Street | 55.9554548157 | -3.186575728 | |
| 64323794 | Mayshade Road | 55.8835025179 | -3.1569301018 | |
| 64323785 | Hawthorn Gardens | 55.8819582446 | -3.1539267562 | |
| 64323767 | Edgefield Road | 55.8804154051 | -3.1517229591 | |
| 64323783 | George Drive | 55.8795112412 | -3.1504014026 | |
| 64323835 | Retail Park | 55.8855463531 | -3.159357056 | |
| 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 | |
| 64324293 | East Queensway | 55.8361820262 | -3.2213252492 | |
| 64324564 | Loanhead Road | 55.8875913462 | -3.1635590015 | |
| 64329352 | Straiton Parkway | 55.8858436596 | -3.1640342892 | |
| 64329353 | Straiton Mains | 55.8855714595 | -3.1624114072 | |
| 64324287 | Terminus | 55.8380366812 | -3.2263814076 |