Penicuik Deanburn - Restalrig
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:43:00 | 16:43:00 | ... | 1 |
|
| ... | 16:44:00 | 16:44:00 | ... | 2 |
|
| ... | 16:45:00 | 16:45:00 | ... | 3 |
|
| ... | 16:46:00 | 16:46:00 | ... | 4 |
|
| ... | 16:46:00 | 16:46:00 | ... | 5 |
|
| ... | 16:47:00 | 16:47:00 | ... | 6 |
|
| ... | 16:49:00 | 16:49:00 | ... | 7 |
|
| ... | 16:49:00 | 16:49:00 | ... | 8 |
|
| ... | 16:50:00 | 16:50:00 | ... | 9 |
|
| ... | 16:51:00 | 16:51:00 | ... | 10 |
|
| ... | 16:52:00 | 16:52:00 | ... | 11 |
|
| ... | 16:52:00 | 16:52:00 | ... | 12 |
|
| ... | 16:53:00 | 16:53:00 | ... | 13 |
|
| ... | 16:54:00 | 16:54:00 | ... | 14 |
|
| ... | 16:54:00 | 16:54:00 | ... | 15 |
|
| ... | 16:55:00 | 16:55:00 | ... | 16 |
|
| ... | 16:56:00 | 16:56:00 | ... | 17 |
|
| ... | 16:57:00 | 16:57:00 | ... | 18 |
|
| ... | 16:58:00 | 16:58:00 | ... | 19 |
|
| ... | 16:58:00 | 16:58:00 | ... | 20 |
|
| ... | 16:59:00 | 16:59:00 | ... | 21 |
|
| ... | 16:59:00 | 16:59:00 | ... | 22 |
|
| ... | 17:00:00 | 17:00:00 | ... | 23 |
|
| ... | 17:01:00 | 17:01:00 | ... | 24 |
|
| ... | 17:02:00 | 17:02:00 | ... | 25 |
|
| ... | 17:03:00 | 17:03:00 | ... | 26 |
|
| ... | 17:04:00 | 17:04:00 | ... | 27 |
|
| ... | 17:04:00 | 17:04:00 | ... | 28 |
|
| ... | 17:05:00 | 17:05:00 | ... | 29 |
|
| ... | 17:06:00 | 17:06:00 | ... | 30 |
|
| ... | 17:06:00 | 17:06:00 | ... | 31 |
|
| ... | 17:08:00 | 17:08:00 | ... | 32 |
|
| ... | 17:10:00 | 17:10:00 | ... | 33 |
|
| ... | 17:16:00 | 17:16:00 | ... | 34 |
|
| ... | 17:17:00 | 17:17:00 | ... | 35 |
|
| ... | 17:17:00 | 17:17:00 | ... | 36 |
|
| ... | 17:19:00 | 17:19:00 | ... | 37 |
|
| ... | 17:19:00 | 17:19:00 | ... | 38 |
|
| ... | 17:20:00 | 17:20:00 | ... | 39 |
|
| ... | 17:21:00 | 17:21:00 | ... | 40 |
|
| ... | 17:22:00 | 17:22:00 | ... | 41 |
|
| ... | 17:23:00 | 17:23:00 | ... | 42 |
|
| ... | 17:24:00 | 17:24:00 | ... | 43 |
|
| ... | 17:24:00 | 17:24:00 | ... | 44 |
|
| ... | 17:25:00 | 17:25:00 | ... | 45 |
|
| ... | 17:26:00 | 17:26:00 | ... | 46 |
|
| ... | 17:27:00 | 17:27:00 | ... | 47 |
|
| ... | 17:28:00 | 17:28:00 | ... | 48 |
|
| ... | 17:29:00 | 17:29:00 | ... | 49 |
|
| ... | 17:30:00 | 17:30:00 | ... | 50 |
|
| ... | 17:31:00 | 17:31:00 | ... | 51 |
|
| ... | 17:32:00 | 17:32:00 | ... | 52 |
|
| ... | 17:33:00 | 17:33:00 | ... | 53 |
|
| ... | 17:34:00 | 17:34:00 | ... | 54 |
|
| ... | 17:36:00 | 17:36:00 | ... | 55 |
|
| ... | 17:36:00 | 17:36:00 | ... | 56 |
|
| ... | 17:38:00 | 17:38:00 | ... | 57 |
|
| ... | 17:40:00 | 17:40:00 | ... | 58 |
|
| ... | 17:41:00 | 17:41:00 | ... | 59 |
|
| ... | 17:44:00 | 17:44:00 | ... | 60 |
|
| ... | 17:47:00 | 17:47:00 | ... | 61 |
|
| ... | 17:51:00 | 17:51:00 | ... | 62 |
|
| ... | 17:53:00 | 17:53:00 | ... | 63 |
|
| ... | 17:59:00 | 17:59: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 | |
|---|---|---|---|---|
| 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 | |
| 36235979 | Elm Row | 55.9588662918 | -3.1840852566 | |
| 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 |