Edinburgh Airport - Fort Kinnaird
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 19:20:00 | 19:20:00 | ... | 1 |
|
| ... | 19:21:00 | 19:21:00 | ... | 2 |
|
| ... | 19:22:00 | 19:22:00 | ... | 3 |
|
| ... | 19:23:00 | 19:23:00 | ... | 4 |
|
| ... | 19:23:00 | 19:23:00 | ... | 5 |
|
| ... | 19:24:00 | 19:24:00 | ... | 6 |
|
| ... | 19:24:00 | 19:24:00 | ... | 7 |
|
| ... | 19:25:00 | 19:25:00 | ... | 8 |
|
| ... | 19:25:00 | 19:25:00 | ... | 9 |
|
| ... | 19:26:00 | 19:26:00 | ... | 10 |
|
| ... | 19:27:00 | 19:27:00 | ... | 11 |
|
| ... | 19:28:00 | 19:28:00 | ... | 12 |
|
| ... | 19:29:00 | 19:29:00 | ... | 13 |
|
| ... | 19:31:00 | 19:31:00 | ... | 14 |
|
| ... | 19:32:00 | 19:32:00 | ... | 15 |
|
| ... | 19:33:00 | 19:33:00 | ... | 16 |
|
| ... | 19:33:00 | 19:33:00 | ... | 17 |
|
| ... | 19:34:00 | 19:34:00 | ... | 18 |
|
| ... | 19:35:00 | 19:35:00 | ... | 19 |
|
| ... | 19:36:00 | 19:36:00 | ... | 20 |
|
| ... | 19:37:00 | 19:37:00 | ... | 21 |
|
| ... | 19:38:00 | 19:38:00 | ... | 22 |
|
| ... | 19:38:00 | 19:38:00 | ... | 23 |
|
| ... | 19:39:00 | 19:39:00 | ... | 24 |
|
| ... | 19:39:00 | 19:39:00 | ... | 25 |
|
| ... | 19:40:00 | 19:40:00 | ... | 26 |
|
| ... | 19:41:00 | 19:41:00 | ... | 27 |
|
| ... | 19:42:00 | 19:42:00 | ... | 28 |
|
| ... | 19:43:00 | 19:43:00 | ... | 29 |
|
| ... | 19:44:00 | 19:44:00 | ... | 30 |
|
| ... | 19:45:00 | 19:45:00 | ... | 31 |
|
| ... | 19:46:00 | 19:46:00 | ... | 32 |
|
| ... | 19:46:00 | 19:46:00 | ... | 33 |
|
| ... | 19:48:00 | 19:48:00 | ... | 34 |
|
| ... | 19:49:00 | 19:49:00 | ... | 35 |
|
| ... | 19:49:00 | 19:49:00 | ... | 36 |
|
| ... | 19:50:00 | 19:50:00 | ... | 37 |
|
| ... | 19:50:00 | 19:50:00 | ... | 38 |
|
| ... | 19:51:00 | 19:51:00 | ... | 39 |
|
| ... | 19:51:00 | 19:51:00 | ... | 40 |
|
| ... | 19:52:00 | 19:52:00 | ... | 41 |
|
| ... | 19:52:00 | 19:52:00 | ... | 42 |
|
| ... | 19:53:00 | 19:53:00 | ... | 43 |
|
| ... | 19:53:00 | 19:53:00 | ... | 44 |
|
| ... | 19:53:00 | 19:53:00 | ... | 45 |
|
| ... | 19:54:00 | 19:54:00 | ... | 46 |
|
| ... | 19:55:00 | 19:55:00 | ... | 47 |
|
| ... | 19:55:00 | 19:55:00 | ... | 48 |
|
| ... | 19:56:00 | 19:56:00 | ... | 49 |
|
| ... | 19:56:00 | 19:56:00 | ... | 50 |
|
| ... | 19:57:00 | 19:57:00 | ... | 51 |
|
| ... | 19:58:00 | 19:58:00 | ... | 52 |
|
| ... | 19:59:00 | 19:59:00 | ... | 53 |
|
| ... | 19:59:00 | 19:59:00 | ... | 54 |
|
| ... | 20:00:00 | 20:00:00 | ... | 55 |
|
| ... | 20:01:00 | 20:01:00 | ... | 56 |
|
| ... | 20:02:00 | 20:02:00 | ... | 57 |
|
| ... | 20:04:00 | 20:04:00 | ... | 58 |
|
| ... | 20:05:00 | 20:05:00 | ... | 59 |
|
| ... | 20:05:00 | 20:05:00 | ... | 60 |
|
| ... | 20:06:00 | 20:06:00 | ... | 61 |
|
| ... | 20:08:00 | 20:08:00 | ... | 62 |
|
| ... | 20:10:00 | 20:10:00 | ... | 63 |
|
| ... | 20:11:00 | 20:11:00 | ... | 64 |
|
| ... | 20:12:00 | 20:12:00 | ... | 65 |
|
| ... | 20:13:00 | 20:13:00 | ... | 66 |
|
| ... | 20:13:00 | 20:13:00 | ... | 67 |
|
| ... | 20:14:00 | 20:14:00 | ... | 68 |
|
| ... | 20:15:00 | 20:15:00 | ... | 69 |
|
| ... | 20:15:00 | 20:15:00 | ... | 70 |
|
| ... | 20:16:00 | 20:16:00 | ... | 71 |
|
| ... | 20:16:00 | 20:16:00 | ... | 72 |
|
| ... | 20:17:00 | 20:17:00 | ... | 73 |
|
| ... | 20:17:00 | 20:17:00 | ... | 74 |
|
| ... | 20:18:00 | 20:18:00 | ... | 75 |
|
| ... | 20:19:00 | 20:19:00 | ... | 76 |
|
| ... | 20:20:00 | 20:20:00 | ... | 77 |
|
| ... | 20:21:00 | 20:21:00 | ... | 78 |
|
| ... | 20:22:00 | 20:22:00 | ... | 79 |
|
| ... | 20:23:00 | 20:23:00 | ... | 80 |
|
| ... | 20:25:00 | 20:25:00 | ... | 81 |
|
| ... | 20:26:00 | 20:26:00 | ... | 82 |
|
| ... | 20:28:00 | 20:28:00 | ... | 83 |
|
| ... | 20:30:00 | 20:30:00 | ... | 84 |
|
| 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 | |
|---|---|---|---|---|
| 36236874 | Bankhead Loan | 55.9231989127 | -3.2917543723 | |
| 36236867 | Bankhead Crossway South | 55.9249321174 | -3.2927082608 | |
| 36236869 | Bankhead Medway | 55.9268359811 | -3.2936679227 | |
| 36236864 | Edinburgh College (Sighthill) | 55.9280073214 | -3.2925065673 | |
| 36242432 | Gyle Centre | 55.9379487167 | -3.3142741821 | |
| 36237829 | Cockit Hat | 55.9044458125 | -3.2231342734 | |
| 36237828 | Oxgangs Library | 55.9055012509 | -3.2245271419 | |
| 36237826 | Oxgangs Avenue | 55.9070077856 | -3.2266381632 | |
| 36237825 | Oxgangs Terrace | 55.9085691799 | -3.2295509378 | |
| 36237823 | Colinton Mains Road | 55.9095747113 | -3.2332301894 | |
| 36237697 | Colinton Mains Loan | 55.9102524368 | -3.2355393854 | |
| 36237696 | Oxgangs Primary School | 55.9118441035 | -3.2381017664 | |
| 36237694 | Firrhill High School | 55.9134421936 | -3.2391286519 | |
| 36234983 | Moredun Park Road | 55.9116472495 | -3.1422660275 | |
| 36234985 | Gaurdwell Glen | 55.9102567772 | -3.1400814659 | |
| 36234986 | Gilmerton Primary School | 55.9087408267 | -3.1368855799 | |
| 36234987 | Gilmerton Crossroads | 55.9063613881 | -3.1337767199 | |
| 36234524 | St Teresa Church | 55.9319645919 | -3.1294664463 | |
| 36234525 | Niddrie Marischal Drive | 55.9300744541 | -3.1258901925 | |
| 36253697 | Niddrie House Avenue | 55.9291368681 | -3.124262467 | |
| 36253692 | Greendykes Terrace | 55.9277362425 | -3.1241418793 | |
| 36253636 | Royal Infirmary | 55.9219434279 | -3.1326634389 | |
| 36234394 | Fort Kinnaird West | 55.933468445 | -3.1083328381 | |
| 36234395 | Peacocktail Close | 55.9335966474 | -3.1110577093 | |
| 36234396 | Jack Kane Sports Centre | 55.9338596779 | -3.1167478077 | |
| 36234397 | Hay Drive | 55.9340454833 | -3.1200346549 | |
| 36234398 | Hay Avenue | 55.9336827974 | -3.1233536813 | |
| 36234523 | Wauchope Road | 55.9326229564 | -3.1282210713 | |
| 36243582 | Nether Craigour | 55.9187945438 | -3.1389400173 | |
| 36235268 | Newtoft Street | 55.9053470366 | -3.1346428689 | |
| 36253595 | Hyvot Park | 55.9036149963 | -3.1383030878 | |
| 36235273 | Burndale Place | 55.9036520271 | -3.1401275845 | |
| 36235274 | Gilmerton Dykes Avenue | 55.9040604591 | -3.1435625026 | |
| 36235275 | Gilmerton Dykes Crescent | 55.9042187602 | -3.1468301594 | |
| 36238356 | Craigour Drive | 55.9173962135 | -3.1366269363 | |
| 36234978 | Craigour Avenue | 55.9163389963 | -3.1372679971 | |
| 36234979 | Craigour Grove | 55.9143340081 | -3.1374012784 | |
| 36234982 | Moredun Park Drive | 55.9132204351 | -3.1402484492 | |
| 36235276 | Lasswade Grove | 55.9032776117 | -3.1504331794 | |
| 36235279 | Gracemount Leisure Centre | 55.9025498597 | -3.1533066216 | |
| 36235278 | Southhouse Loan | 55.9012352209 | -3.1583856452 | |
| 36235282 | Kaimes Crossroads | 55.8999618129 | -3.1638334111 | |
| 36235283 | Mortonhall Park Gardens | 55.8995412612 | -3.170282072 | |
| 36235284 | Mortonhall Park Avenue | 55.8996496806 | -3.1730521713 | |
| 36235285 | Marie Curie Hospice | 55.8989843118 | -3.190880286 | |
| 36235286 | Margaret Rose Avenue | 55.8988616487 | -3.1942670393 | |
| 36235287 | Winton Drive | 55.8992612983 | -3.1975259314 | |
| 36235289 | Frogston Avenue | 55.9004709684 | -3.2015616241 | |
| 36235292 | Fairmilehead Crossroads | 55.9017306435 | -3.205982983 | |
| 36235293 | Fairmile Avenue | 55.9020880506 | -3.2089370345 | |
| 36235294 | Caiystane View | 55.9020892359 | -3.213383501 | |
| 36235295 | Swanston Road | 55.902105379 | -3.2181183379 | |
| 36235296 | New Swanston | 55.9024996941 | -3.220945738 | |
| 36237985 | Gogar Roundabout | 55.9387457406 | -3.3254279228 | |
| 36232428 | Gogarburn A8 | 55.9365699445 | -3.3371841367 | |
| 36236597 | Gogarstone Road | 55.936631684 | -3.3521065527 | |
| 36232425 | Airport Hotel | 55.9435592087 | -3.3611224359 | |
| 36246358 | Ingliston Park & Ride | 55.9390678603 | -3.3560978632 | |
| 36247349 | Airport | 55.9481834165 | -3.3622455189 | |
| 36237692 | Elliot Road | 55.9132301879 | -3.2441135781 | |
| 36237687 | Redford Barracks | 55.9113046596 | -3.2479234747 | |
| 36237685 | Merchiston Castle School | 55.9088166829 | -3.2513629352 | |
| 36236345 | Rustic Cottages | 55.9078574323 | -3.2537955463 | |
| 36235343 | Colinton Village | 55.9072326159 | -3.2586703314 | |
| 36235346 | Spylaw Bank | 55.9071157718 | -3.2674326477 | |
| 36235934 | Viewfield Road | 55.9089911061 | -3.2729169255 | |
| 36237472 | Clovenstone Road | 55.9124702146 | -3.2770946274 | |
| 36247452 | Wester Hailes Park | 55.9142966619 | -3.276866692 | |
| 36245293 | Hailesland Place | 55.9164693201 | -3.2787781736 | |
| 36237459 | Murrayburn Park | 55.9174745358 | -3.2823474605 | |
| 36237479 | Westside Plaza | 55.9163514548 | -3.2857824608 | |
| 36234928 | Calder Drive | 55.9199462158 | -3.2900299745 | |
| 36253274 | Bankhead Drive | 55.9298803808 | -3.2921207685 | |
| 36236829 | Forrester High School | 55.9318514025 | -3.2935309554 | |
| 36243989 | Redheughs Avenue | 55.9330725816 | -3.3089226762 | |
| 36247457 | Lochside Place | 55.9332397168 | -3.3143228116 | |
| 36247456 | Lochside Crescent | 55.9346935222 | -3.316180953 | |
| 36236832 | Gyle Square | 55.931368003 | -3.2950674857 | |
| 36236834 | South Gyle Trade Park | 55.9300024154 | -3.2993115436 | |
| 36236835 | South Gyle Crescent Lane | 55.9297221811 | -3.3020231727 | |
| 36236836 | Teviot House | 55.9311216004 | -3.3056395703 | |
| 36236837 | Drummond House | 55.9322359217 | -3.3064774047 | |
| 36253689 | Sandilands Close | 55.9244021394 | -3.1251815789 | |
| 36253639 | SCRM | 55.9220435049 | -3.1295938977 |