Clermiston - Easter Road
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 18:11:00 | 18:11:00 | ... | 1 |
|
| ... | 18:12:00 | 18:12:00 | ... | 2 |
|
| ... | 18:13:00 | 18:13:00 | ... | 3 |
|
| ... | 18:14:00 | 18:14:00 | ... | 4 |
|
| ... | 18:16:00 | 18:16:00 | ... | 5 |
|
| ... | 18:17:00 | 18:17:00 | ... | 6 |
|
| ... | 18:18:00 | 18:18:00 | ... | 7 |
|
| ... | 18:19:00 | 18:19:00 | ... | 8 |
|
| ... | 18:20:00 | 18:20:00 | ... | 9 |
|
| ... | 18:21:00 | 18:21:00 | ... | 10 |
|
| ... | 18:24:00 | 18:24:00 | ... | 11 |
|
| ... | 18:26:00 | 18:26:00 | ... | 12 |
|
| ... | 18:28:00 | 18:28:00 | ... | 13 |
|
| ... | 18:32:00 | 18:32:00 | ... | 14 |
|
| ... | 18:34:00 | 18:34:00 | ... | 15 |
|
| ... | 18:35:00 | 18:35:00 | ... | 16 |
|
| ... | 18:38:00 | 18:38:00 | ... | 17 |
|
| ... | 18:39:00 | 18:39:00 | ... | 18 |
|
| ... | 18:40:00 | 18:40:00 | ... | 19 |
|
| ... | 18:41:00 | 18:41:00 | ... | 20 |
|
| ... | 18:44:00 | 18:44:00 | ... | 21 |
|
| ... | 18:44:00 | 18:44:00 | ... | 22 |
|
| ... | 18:45:00 | 18:45:00 | ... | 23 |
|
| ... | 18:46:00 | 18:46:00 | ... | 24 |
|
| ... | 18:48:00 | 18:48:00 | ... | 25 |
|
| ... | 18:49:00 | 18:49:00 | ... | 26 |
|
| ... | 18:50:00 | 18:50:00 | ... | 27 |
|
| ... | 18:52:00 | 18:52:00 | ... | 28 |
|
| ... | 18:53:00 | 18:53:00 | ... | 29 |
|
| ... | 18:54:00 | 18:54:00 | ... | 30 |
|
| ... | 18:54:00 | 18:54:00 | ... | 31 |
|
| ... | 18:55:00 | 18:55:00 | ... | 32 |
|
| ... | 18:56:00 | 18:56:00 | ... | 33 |
|
| ... | 18:57:00 | 18:57:00 | ... | 34 |
|
| ... | 18:58:00 | 18:58:00 | ... | 35 |
|
| ... | 18:58:00 | 18:58:00 | ... | 36 |
|
| ... | 18:59:00 | 18:59:00 | ... | 37 |
|
| ... | 19:00:00 | 19:00:00 | ... | 38 |
|
| ... | 19:02:00 | 19:02:00 | ... | 39 |
|
| ... | 19:02:00 | 19:02:00 | ... | 40 |
|
| ... | 19:03:00 | 19:03:00 | ... | 41 |
|
| ... | 19:04:00 | 19:04:00 | ... | 42 |
|
| ... | 19:05:00 | 19:05:00 | ... | 43 |
|
| ... | 19:05:00 | 19:05:00 | ... | 44 |
|
| ... | 19:06:00 | 19:06:00 | ... | 45 |
|
| ... | 19:07:00 | 19:07:00 | ... | 46 |
|
| ... | 19:07:00 | 19:07:00 | ... | 47 |
|
| ... | 19:08:00 | 19:08:00 | ... | 48 |
|
| ... | 19:08:00 | 19:08:00 | ... | 49 |
|
| ... | 19:09:00 | 19:09:00 | ... | 50 |
|
| ... | 19:09:00 | 19:09:00 | ... | 51 |
|
| ... | 19:10:00 | 19:10:00 | ... | 52 |
|
| ... | 19:10:00 | 19:10:00 | ... | 53 |
|
| 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 | |
|---|---|---|---|---|
| 36237636 | Clermiston Crescent | 55.9562677335 | -3.281259534 | |
| 36232897 | Academy Park | 55.9680444809 | -3.1686004876 | |
| 36234249 | Academy Park | 55.9679928619 | -3.1683586098 | |
| 36234252 | St Clair Avenue | 55.9662275305 | -3.1697472647 | |
| 36234253 | Dalmeny Street | 55.964064042 | -3.1704829734 | |
| 36232893 | Brunswick Road | 55.9612189172 | -3.1710858796 | |
| 36238389 | Montgomery Street | 55.9586616968 | -3.1716493474 | |
| 36234745 | Brunton Place | 55.9575401964 | -3.1733613273 | |
| 36234746 | Wellington Street | 55.957635264 | -3.1765836562 | |
| 36234747 | Brunswick Street | 55.9577181974 | -3.1801259774 | |
| 36234748 | Leopold Place | 55.9577895223 | -3.1829952363 | |
| 36242697 | Leith Street | 55.9556076777 | -3.186564389 | |
| 36235975 | Princes Street (Waverley Steps) | 55.9529530558 | -3.1906951851 | |
| 36237983 | Princes Street (Scott Mon.) | 55.9520875552 | -3.1956332395 | |
| 36232546 | Princes Street (west) | 55.9505464222 | -3.2044096118 | |
| 36232547 | Lothian Road | 55.9495269343 | -3.2066679418 | |
| 36232549 | Usher Hall | 55.9471002869 | -3.2058078239 | |
| 36236485 | Port Hamilton | 55.943366254 | -3.2081575153 | |
| 36236486 | Gilmore Park | 55.9423809195 | -3.2124177678 | |
| 36236489 | Fountain Park | 55.9411877544 | -3.2158707659 | |
| 36236493 | Dundee Terrace | 55.940105771 | -3.218974827 | |
| 36237593 | Templeland Road | 55.9449288761 | -3.2940630431 | |
| 36237595 | Pearce Road | 55.9472062168 | -3.2945393428 | |
| 36237596 | Drum Brae Gardens | 55.9487010713 | -3.2950856584 | |
| 36237623 | Drum Brae Avenue | 55.9513019996 | -3.2964056481 | |
| 36237579 | Duart Crescent | 55.9531876891 | -3.2973815722 | |
| 36237625 | Drum Brae North | 55.9539521575 | -3.2964622069 | |
| 36237627 | Drum Brae Drive | 55.9547525119 | -3.2929814044 | |
| 36237629 | Hoseason Gardens | 55.9555202508 | -3.2883141505 | |
| 36237634 | Drum Brae Hub | 55.9557853602 | -3.2861607087 | |
| 36237635 | Clermiston View | 55.9562492388 | -3.2830367924 | |
| 36242546 | Henderson Terrace | 55.9391039101 | -3.2257634554 | |
| 36232675 | Gorgie City Farm | 55.9387712341 | -3.2284905712 | |
| 36232676 | Tynecastle | 55.9378275363 | -3.2321107744 | |
| 36232678 | Stewart Terrace | 55.9372443284 | -3.2347177143 | |
| 36236257 | Westfield Road | 55.9368252422 | -3.2397631359 | |
| 36236542 | Westfield Avenue | 55.9374134344 | -3.2429196863 | |
| 36238784 | Stevenson Grove | 55.9359431438 | -3.2452578432 | |
| 36235872 | Balgreen Primary School | 55.9368324424 | -3.249720803 | |
| 36235869 | Whitson Crescent | 55.9354574465 | -3.2532783669 | |
| 36235868 | Whitson Grove | 55.9338995937 | -3.2571339033 | |
| 36235867 | Stenhouse Cross | 55.9329082227 | -3.259182722 | |
| 36243453 | Stenhouse Grove | 55.9332292278 | -3.2620584417 | |
| 36235864 | Saughton Mains Street | 55.9335419459 | -3.2657343116 | |
| 36235863 | Saughton Road North | 55.9324933739 | -3.2715746871 | |
| 36253656 | Saughton Tram Stop | 55.9327753441 | -3.2747213231 | |
| 36235862 | Broomhall Avenue | 55.9341407578 | -3.2764950019 | |
| 36235858 | Broomfield Crescent | 55.9359474638 | -3.2790357395 | |
| 36235859 | Castle Avenue | 55.9384753854 | -3.2804798705 | |
| 36239723 | Orchardfield Avenue | 55.9404112149 | -3.2844182485 | |
| 36235783 | Featherhall Avenue | 55.939894529 | -3.2882915993 | |
| 36235782 | Dunsmuir Court | 55.9400529982 | -3.291178692 | |
| 36242835 | Meadow Place Road | 55.9419471267 | -3.2930669757 |