Penicuik Deanburn - Restalrig
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 16:55:00 | 16:55:00 | ... | 1 |
|
| ... | 16:56:00 | 16:56:00 | ... | 2 |
|
| ... | 16:57:00 | 16:57:00 | ... | 3 |
|
| ... | 16:58:00 | 16:58:00 | ... | 4 |
|
| ... | 16:59:00 | 16:59:00 | ... | 5 |
|
| ... | 17:00:00 | 17:00:00 | ... | 6 |
|
| ... | 17:00:00 | 17:00:00 | ... | 7 |
|
| ... | 17:02:00 | 17:02:00 | ... | 8 |
|
| ... | 17:03:00 | 17:03:00 | ... | 9 |
|
| ... | 17:04:00 | 17:04:00 | ... | 10 |
|
| ... | 17:05:00 | 17:05:00 | ... | 11 |
|
| ... | 17:06:00 | 17:06:00 | ... | 12 |
|
| ... | 17:07:00 | 17:07:00 | ... | 13 |
|
| ... | 17:09:00 | 17:09:00 | ... | 14 |
|
| ... | 17:13:00 | 17:13:00 | ... | 15 |
|
| ... | 17:17:00 | 17:17:00 | ... | 16 |
|
| ... | 17:19:00 | 17:19:00 | ... | 17 |
|
| ... | 17:20:00 | 17:20:00 | ... | 18 |
|
| ... | 17:24:00 | 17:24:00 | ... | 19 |
|
| ... | 17:27:00 | 17:27:00 | ... | 20 |
|
| ... | 17:28:00 | 17:28:00 | ... | 21 |
|
| ... | 17:30:00 | 17:30:00 | ... | 22 |
|
| ... | 17:31:00 | 17:31:00 | ... | 23 |
|
| ... | 17:33:00 | 17:33:00 | ... | 24 |
|
| ... | 17:35:00 | 17:35:00 | ... | 25 |
|
| ... | 17:38:00 | 17:38:00 | ... | 26 |
|
| ... | 17:39:00 | 17:39:00 | ... | 27 |
|
| ... | 17:40:00 | 17:40:00 | ... | 28 |
|
| ... | 17:41:00 | 17:41:00 | ... | 29 |
|
| ... | 17:42:00 | 17:42:00 | ... | 30 |
|
| ... | 17:43:00 | 17:43:00 | ... | 31 |
|
| ... | 17:44:00 | 17:44:00 | ... | 32 |
|
| ... | 17:45:00 | 17:45:00 | ... | 33 |
|
| ... | 17:47:00 | 17:47:00 | ... | 34 |
|
| ... | 17:50:00 | 17:50:00 | ... | 35 |
|
| ... | 17:50:00 | 17:50:00 | ... | 36 |
|
| ... | 17:51:00 | 17:51:00 | ... | 37 |
|
| ... | 17:52:00 | 17:52:00 | ... | 38 |
|
| ... | 17:52:00 | 17:52:00 | ... | 39 |
|
| ... | 17:53:00 | 17:53:00 | ... | 40 |
|
| ... | 17:54:00 | 17:54:00 | ... | 41 |
|
| ... | 17:55:00 | 17:55:00 | ... | 42 |
|
| ... | 17:56:00 | 17:56:00 | ... | 43 |
|
| ... | 17:57:00 | 17:57:00 | ... | 44 |
|
| ... | 17:58:00 | 17:58:00 | ... | 45 |
|
| ... | 17:58:00 | 17:58:00 | ... | 46 |
|
| ... | 17:59:00 | 17:59:00 | ... | 47 |
|
| ... | 18:00:00 | 18:00:00 | ... | 48 |
|
| ... | 18:01:00 | 18:01:00 | ... | 49 |
|
| ... | 18:02:00 | 18:02:00 | ... | 50 |
|
| ... | 18:02:00 | 18:02:00 | ... | 51 |
|
| ... | 18:03:00 | 18:03:00 | ... | 52 |
|
| ... | 18:04:00 | 18:04:00 | ... | 53 |
|
| ... | 18:04:00 | 18:04:00 | ... | 54 |
|
| ... | 18:05:00 | 18:05:00 | ... | 55 |
|
| ... | 18:06:00 | 18:06:00 | ... | 56 |
|
| ... | 18:07:00 | 18:07:00 | ... | 57 |
|
| ... | 18:07:00 | 18:07:00 | ... | 58 |
|
| ... | 18:08:00 | 18:08:00 | ... | 59 |
|
| ... | 18:09:00 | 18:09:00 | ... | 60 |
|
| ... | 18:09:00 | 18:09:00 | ... | 61 |
|
| ... | 18:10:00 | 18:10:00 | ... | 62 |
|
| ... | 18:10:00 | 18:10:00 | ... | 63 |
|
| ... | 18:11:00 | 18:11:00 | ... | 64 |
|
| ... | 18:12:00 | 18:12:00 | ... | 65 |
|
| ... | 18:13:00 | 18:13:00 | ... | 66 |
|
| 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 | |
|---|---|---|---|---|
| 36235673 | Findlay Medway | 55.9656366529 | -3.1485023426 | |
| 36247485 | Findlay Medway | 55.9634345754 | -3.1466429188 | |
| 36232954 | Findlay Avenue | 55.9623411391 | -3.1492377049 | |
| 36243968 | Sleigh Drive | 55.961302133 | -3.1536921256 | |
| 36243957 | Lochend Quadrant | 55.9601488517 | -3.1549873168 | |
| 36236748 | Marionville Park | 55.9579699191 | -3.1583340923 | |
| 36236747 | Wishaw Terrace | 55.9574586851 | -3.1601447663 | |
| 36234743 | Carlyle Place | 55.9571890591 | -3.1677607757 | |
| 36243272 | Calton Terrace Brae | 55.9558844659 | -3.1726705697 | |
| 36235895 | Regent Terrace | 55.953350149 | -3.179304393 | |
| 36235894 | St Andrew's House | 55.9538747666 | -3.183628552 | |
| 36236783 | Waterloo Place | 55.9536067065 | -3.1872078502 | |
| 36235975 | Princes Street (Waverley Steps) | 55.9529530558 | -3.1906951851 | |
| 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 | |
| 36237252 | Bruntsfield Place | 55.9363935874 | -3.2081485396 | |
| 36232568 | Holy Corner | 55.9347847867 | -3.2100193945 | |
| 36232569 | Churchhill | 55.9316682373 | -3.2098742148 | |
| 36238593 | Springvalley Gardens | 55.9287617471 | -3.2093834909 | |
| 36232573 | Morningside Station | 55.9256182454 | -3.2092375522 | |
| 36236973 | Braid Hills Hotel | 55.9174395674 | -3.213079043 | |
| 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 | |
| 64329294 | Seafield Moor Road | 55.8689320113 | -3.1904236786 | |
| 64323456 | Midlothian Innovation Centre | 55.8681771576 | -3.1941399884 | |
| 64323459 | Veterinary Centre | 55.8663125855 | -3.1992281986 | |
| 64323463 | Technopole | 55.862391272 | -3.203277616 | |
| 64323573 | Old Pentland Road | 55.8794075066 | -3.192454703 | |
| 64323846 | Snowsports Centre | 55.8911156711 | -3.2007767539 | |
| 64323575 | Hillend | 55.8873193334 | -3.1975417924 | |
| 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 | |
| 64324346 | Mauricewood Road | 55.8388423967 | -3.2167299295 | |
| 64324348 | Monksrig Road | 55.8314060266 | -3.2441975938 | |
| 64324297 | Gardeners Walk | 55.8329194737 | -3.241148521 | |
| 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 | |
| 64324275 | Clerk Road | 55.8286971576 | -3.2374859185 | |
| 64324364 | Ravendean Gardens | 55.8291671029 | -3.2398955138 | |
| 64324692 | Lowrie Avenue | 55.8283356826 | -3.2439239473 | |
| 64324362 | Ravelsykes Road | 55.8302456602 | -3.2460922949 | |
| 64324286 | Silverburn Drive | 55.8338106212 | -3.2383189316 | |
| 64324345 | Laverlock Drive | 55.8363912773 | -3.2354629629 | |
| 64324367 | Royal Court | 55.8379702368 | -3.2312336036 | |
| 64324287 | Terminus | 55.8380366812 | -3.2263814076 |