Clermiston - Easter Road
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:50:00 | 07:50:00 | ... | 1 |
|
| ... | 07:51:00 | 07:51:00 | ... | 2 |
|
| ... | 07:53:00 | 07:53:00 | ... | 3 |
|
| ... | 07:55:00 | 07:55:00 | ... | 4 |
|
| ... | 07:56:00 | 07:56:00 | ... | 5 |
|
| ... | 07:57:00 | 07:57:00 | ... | 6 |
|
| ... | 07:59:00 | 07:59:00 | ... | 7 |
|
| ... | 08:00:00 | 08:00:00 | ... | 8 |
|
| ... | 08:01:00 | 08:01:00 | ... | 9 |
|
| ... | 08:04:00 | 08:04:00 | ... | 10 |
|
| ... | 08:07:00 | 08:07:00 | ... | 11 |
|
| ... | 08:09:00 | 08:09:00 | ... | 12 |
|
| ... | 08:13:00 | 08:13:00 | ... | 13 |
|
| ... | 08:15:00 | 08:15:00 | ... | 14 |
|
| ... | 08:17:00 | 08:17:00 | ... | 15 |
|
| ... | 08:21:00 | 08:21:00 | ... | 16 |
|
| ... | 08:22:00 | 08:22:00 | ... | 17 |
|
| ... | 08:24:00 | 08:24:00 | ... | 18 |
|
| ... | 08:25:00 | 08:25:00 | ... | 19 |
|
| ... | 08:27:00 | 08:27:00 | ... | 20 |
|
| ... | 08:28:00 | 08:28:00 | ... | 21 |
|
| ... | 08:29:00 | 08:29:00 | ... | 22 |
|
| ... | 08:30:00 | 08:30:00 | ... | 23 |
|
| ... | 08:31:00 | 08:31:00 | ... | 24 |
|
| ... | 08:33:00 | 08:33:00 | ... | 25 |
|
| ... | 08:34:00 | 08:34:00 | ... | 26 |
|
| ... | 08:36:00 | 08:36:00 | ... | 27 |
|
| ... | 08:37:00 | 08:37:00 | ... | 28 |
|
| ... | 08:38:00 | 08:38:00 | ... | 29 |
|
| ... | 08:39:00 | 08:39:00 | ... | 30 |
|
| ... | 08:40:00 | 08:40:00 | ... | 31 |
|
| ... | 08:41:00 | 08:41:00 | ... | 32 |
|
| ... | 08:42:00 | 08:42:00 | ... | 33 |
|
| ... | 08:43:00 | 08:43:00 | ... | 34 |
|
| ... | 08:44:00 | 08:44:00 | ... | 35 |
|
| ... | 08:45:00 | 08:45:00 | ... | 36 |
|
| ... | 08:46:00 | 08:46:00 | ... | 37 |
|
| ... | 08:47:00 | 08:47:00 | ... | 38 |
|
| ... | 08:48:00 | 08:48:00 | ... | 39 |
|
| ... | 08:49:00 | 08:49:00 | ... | 40 |
|
| ... | 08:50:00 | 08:50:00 | ... | 41 |
|
| ... | 08:51:00 | 08:51:00 | ... | 42 |
|
| ... | 08:52:00 | 08:52:00 | ... | 43 |
|
| ... | 08:52:00 | 08:52:00 | ... | 44 |
|
| ... | 08:54:00 | 08:54:00 | ... | 45 |
|
| ... | 08:54:00 | 08:54:00 | ... | 46 |
|
| ... | 08:55:00 | 08:55:00 | ... | 47 |
|
| ... | 08:55:00 | 08:55:00 | ... | 48 |
|
| ... | 08:56:00 | 08:56:00 | ... | 49 |
|
| ... | 08:57:00 | 08:57:00 | ... | 50 |
|
| ... | 08:58:00 | 08:58:00 | ... | 51 |
|
| ... | 08:58:00 | 08:58:00 | ... | 52 |
|
| 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 | |
| 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 |