Penicuik Deanburn - Restalrig
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 14:50:00 | 14:50:00 | ... | 1 |
|
| ... | 14:51:00 | 14:51:00 | ... | 2 |
|
| ... | 14:52:00 | 14:52:00 | ... | 3 |
|
| ... | 14:53:00 | 14:53:00 | ... | 4 |
|
| ... | 14:53:00 | 14:53:00 | ... | 5 |
|
| ... | 14:54:00 | 14:54:00 | ... | 6 |
|
| ... | 14:56:00 | 14:56:00 | ... | 7 |
|
| ... | 14:56:00 | 14:56:00 | ... | 8 |
|
| ... | 14:57:00 | 14:57:00 | ... | 9 |
|
| ... | 14:58:00 | 14:58:00 | ... | 10 |
|
| ... | 14:59:00 | 14:59:00 | ... | 11 |
|
| ... | 14:59:00 | 14:59:00 | ... | 12 |
|
| ... | 15:00:00 | 15:00:00 | ... | 13 |
|
| ... | 15:01:00 | 15:01:00 | ... | 14 |
|
| ... | 15:01:00 | 15:01:00 | ... | 15 |
|
| ... | 15:02:00 | 15:02:00 | ... | 16 |
|
| ... | 15:03:00 | 15:03:00 | ... | 17 |
|
| ... | 15:04:00 | 15:04:00 | ... | 18 |
|
| ... | 15:05:00 | 15:05:00 | ... | 19 |
|
| ... | 15:05:00 | 15:05:00 | ... | 20 |
|
| ... | 15:06:00 | 15:06:00 | ... | 21 |
|
| ... | 15:06:00 | 15:06:00 | ... | 22 |
|
| ... | 15:07:00 | 15:07:00 | ... | 23 |
|
| ... | 15:08:00 | 15:08:00 | ... | 24 |
|
| ... | 15:09:00 | 15:09:00 | ... | 25 |
|
| ... | 15:10:00 | 15:10:00 | ... | 26 |
|
| ... | 15:11:00 | 15:11:00 | ... | 27 |
|
| ... | 15:11:00 | 15:11:00 | ... | 28 |
|
| ... | 15:12:00 | 15:12:00 | ... | 29 |
|
| ... | 15:13:00 | 15:13:00 | ... | 30 |
|
| ... | 15:13:00 | 15:13:00 | ... | 31 |
|
| ... | 15:14:00 | 15:14:00 | ... | 32 |
|
| ... | 15:15:00 | 15:15:00 | ... | 33 |
|
| ... | 15:19:00 | 15:19:00 | ... | 34 |
|
| ... | 15:20:00 | 15:20:00 | ... | 35 |
|
| ... | 15:20:00 | 15:20:00 | ... | 36 |
|
| ... | 15:22:00 | 15:22:00 | ... | 37 |
|
| ... | 15:22:00 | 15:22:00 | ... | 38 |
|
| ... | 15:23:00 | 15:23:00 | ... | 39 |
|
| ... | 15:24:00 | 15:24:00 | ... | 40 |
|
| ... | 15:25:00 | 15:25:00 | ... | 41 |
|
| ... | 15:26:00 | 15:26:00 | ... | 42 |
|
| ... | 15:27:00 | 15:27:00 | ... | 43 |
|
| ... | 15:27:00 | 15:27:00 | ... | 44 |
|
| ... | 15:28:00 | 15:28:00 | ... | 45 |
|
| ... | 15:29:00 | 15:29:00 | ... | 46 |
|
| ... | 15:30:00 | 15:30:00 | ... | 47 |
|
| ... | 15:31:00 | 15:31:00 | ... | 48 |
|
| ... | 15:32:00 | 15:32:00 | ... | 49 |
|
| ... | 15:33:00 | 15:33:00 | ... | 50 |
|
| ... | 15:34:00 | 15:34:00 | ... | 51 |
|
| ... | 15:35:00 | 15:35:00 | ... | 52 |
|
| ... | 15:36:00 | 15:36:00 | ... | 53 |
|
| ... | 15:36:00 | 15:36:00 | ... | 54 |
|
| ... | 15:38:00 | 15:38:00 | ... | 55 |
|
| ... | 15:39:00 | 15:39:00 | ... | 56 |
|
| ... | 15:40:00 | 15:40:00 | ... | 57 |
|
| ... | 15:42:00 | 15:42:00 | ... | 58 |
|
| ... | 15:43:00 | 15:43:00 | ... | 59 |
|
| ... | 15:45:00 | 15:45:00 | ... | 60 |
|
| ... | 15:49:00 | 15:49:00 | ... | 61 |
|
| ... | 15:53:00 | 15:53:00 | ... | 62 |
|
| ... | 15:54:00 | 15:54:00 | ... | 63 |
|
| ... | 15:56:00 | 15:56:00 | ... | 64 |
|
| ... | 15:57:00 | 15:57:00 | ... | 65 |
|
| ... | 15:58:00 | 15:58:00 | ... | 66 |
|
| ... | 16:00:00 | 16:00:00 | ... | 67 |
|
| ... | 16:01:00 | 16:01:00 | ... | 68 |
|
| ... | 16:02:00 | 16:02:00 | ... | 69 |
|
| ... | 16:02:00 | 16:02:00 | ... | 70 |
|
| ... | 16:04:00 | 16:04:00 | ... | 71 |
|
| ... | 16:05:00 | 16:05:00 | ... | 72 |
|
| ... | 16:05:00 | 16:05:00 | ... | 73 |
|
| ... | 16:06:00 | 16:06:00 | ... | 74 |
|
| ... | 16:07:00 | 16:07:00 | ... | 75 |
|
| ... | 16:07:00 | 16:07:00 | ... | 76 |
|
| ... | 16:08:00 | 16:08:00 | ... | 77 |
|
| 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 | |
|---|---|---|---|---|
| 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 | |
| 36236969 | Braid Burn | 55.9198252034 | -3.2126255142 | |
| 36236967 | South Morningside Primary School | 55.9212707941 | -3.21182254 | |
| 36236963 | Comiston Gardens | 55.9238280245 | -3.2103660383 | |
| 36237242 | Morningside Station | 55.9260754247 | -3.2093478178 | |
| 36237243 | Springvalley Gardens | 55.9280686591 | -3.2095059435 | |
| 36237246 | Morningside Place | 55.9302311509 | -3.2098134151 | |
| 36237247 | Churchhill | 55.9325370508 | -3.2101574078 | |
| 36237248 | Holy Corner | 55.9347466545 | -3.2102423149 | |
| 36237249 | Bruntsfield Place | 55.9360757663 | -3.2094033047 | |
| 36237253 | Viewforth | 55.9370669428 | -3.2072890216 | |
| 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 | |
| 36253279 | Princes Street (Scott Mon.) | 55.9525231008 | -3.1942693676 | |
| 36246286 | Princes Street (Waverley Steps) | 55.9532626482 | -3.1902722743 | |
| 36236782 | Waterloo Place | 55.9537687057 | -3.1871807782 | |
| 36235893 | St Andrew's House | 55.953923833 | -3.1831976267 | |
| 36235896 | Regent Terrace | 55.9534527312 | -3.1798520379 | |
| 36236757 | Calton Terrace Brae | 55.9559171965 | -3.1730079051 | |
| 36243925 | Lochend Quadrant | 55.959983406 | -3.1553828409 | |
| 36243952 | Sleigh Drive | 55.9616352504 | -3.1536219443 | |
| 36253564 | Lochend Avenue | 55.9642712901 | -3.153267851 | |
| 36247489 | Findlay Avenue | 55.9656660416 | -3.1511305653 | |
| 36235673 | Findlay Medway | 55.9656366529 | -3.1485023426 | |
| 36234254 | Waverley Place | 55.9573920222 | -3.1681512974 | |
| 36234257 | Marionville Road | 55.9571370588 | -3.1656609891 | |
| 36242743 | Dalgety Avenue | 55.9573243225 | -3.1629597415 | |
| 36236749 | Marionville Park | 55.9587830878 | -3.156900782 | |
| 36232956 | Restalrig Square | 55.9625968714 | -3.1536025012 | |
| 64323843 | Golf Club | 55.8926091015 | -3.2015104759 | |
| 64324365 | Royal Court | 55.8378505473 | -3.230623036 | |
| 64324343 | Laverlock Drive | 55.8365147861 | -3.2347962465 | |
| 64324285 | Silverburn Drive | 55.8336874326 | -3.2380595548 | |
| 64324296 | Gardeners Walk | 55.8328720176 | -3.2405083696 | |
| 64324359 | Ravelsykes Road | 55.830132279 | -3.2457534063 | |
| 64324363 | Ravendean Gardens | 55.8291762163 | -3.2407738499 | |
| 64324276 | Clerk Road | 55.8288862788 | -3.2374440318 | |
| 64324643 | Harlaw Grove | 55.828980042 | -3.231683868 | |
| 64324352 | Navaar House Hotel | 55.8266189079 | -3.2251759864 | |
| 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 | |
| 64324287 | Terminus | 55.8380366812 | -3.2263814076 | |
| 64324358 | Queensway | 55.8363466165 | -3.2201328569 | |
| 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 | |
| 64323462 | Technopole | 55.8625324988 | -3.203537632 | |
| 64323436 | Bush Research Park | 55.8593654528 | -3.1975123133 | |
| 64323458 | Veterinary Centre | 55.8669706724 | -3.1990087835 | |
| 64323439 | Bush Road End | 55.8694079519 | -3.1904542224 | |
| 64323457 | Midlothian Innovation Centre | 55.8684663161 | -3.193973078 | |
| 64323572 | Old Pentland Road | 55.8780834579 | -3.1927817489 | |
| 64323574 | Hillend | 55.8870311038 | -3.1976128551 |