Balerno - Edinburgh
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 04:25:00 | 04:25:00 | ... | 1 |
|
| ... | 04:27:00 | 04:27:00 | ... | 2 |
|
| ... | 04:29:00 | 04:29:00 | ... | 3 |
|
| ... | 04:30:00 | 04:30:00 | ... | 4 |
|
| ... | 04:32:00 | 04:32:00 | ... | 5 |
|
| ... | 04:34:00 | 04:34:00 | ... | 6 |
|
| ... | 04:35:00 | 04:35:00 | ... | 7 |
|
| ... | 04:37:00 | 04:37:00 | ... | 8 |
|
| ... | 04:38:00 | 04:38:00 | ... | 9 |
|
| ... | 04:39:00 | 04:39:00 | ... | 10 |
|
| ... | 04:39:00 | 04:39:00 | ... | 11 |
|
| ... | 04:39:00 | 04:39:00 | ... | 12 |
|
| ... | 04:40:00 | 04:40:00 | ... | 13 |
|
| ... | 04:41:00 | 04:41:00 | ... | 14 |
|
| ... | 04:42:00 | 04:42:00 | ... | 15 |
|
| ... | 04:43:00 | 04:43:00 | ... | 16 |
|
| ... | 04:43:00 | 04:43:00 | ... | 17 |
|
| ... | 04:44:00 | 04:44:00 | ... | 18 |
|
| ... | 04:44:00 | 04:44:00 | ... | 19 |
|
| ... | 04:45:00 | 04:45:00 | ... | 20 |
|
| ... | 04:45:00 | 04:45:00 | ... | 21 |
|
| ... | 04:46:00 | 04:46:00 | ... | 22 |
|
| ... | 04:46:00 | 04:46:00 | ... | 23 |
|
| ... | 04:47:00 | 04:47:00 | ... | 24 |
|
| ... | 04:47:00 | 04:47:00 | ... | 25 |
|
| ... | 04:48:00 | 04:48:00 | ... | 26 |
|
| ... | 04:48:00 | 04:48:00 | ... | 27 |
|
| ... | 04:49:00 | 04:49:00 | ... | 28 |
|
| ... | 04:49:00 | 04:49:00 | ... | 29 |
|
| ... | 04:49:00 | 04:49:00 | ... | 30 |
|
| ... | 04:50:00 | 04:50:00 | ... | 31 |
|
| ... | 04:50:00 | 04:50:00 | ... | 32 |
|
| ... | 04:51:00 | 04:51:00 | ... | 33 |
|
| ... | 04:51:00 | 04:51:00 | ... | 34 |
|
| ... | 04:52:00 | 04:52:00 | ... | 35 |
|
| ... | 04:53:00 | 04:53:00 | ... | 36 |
|
| ... | 04:53:00 | 04:53:00 | ... | 37 |
|
| ... | 04:54:00 | 04:54:00 | ... | 38 |
|
| ... | 04:54:00 | 04:54:00 | ... | 39 |
|
| ... | 04:55:00 | 04:55:00 | ... | 40 |
|
| ... | 04:55:00 | 04:55:00 | ... | 41 |
|
| ... | 04:56:00 | 04:56:00 | ... | 42 |
|
| ... | 04:56:00 | 04:56:00 | ... | 43 |
|
| ... | 04:57:00 | 04:57:00 | ... | 44 |
|
| ... | 04:57:00 | 04:57:00 | ... | 45 |
|
| ... | 04:58:00 | 04:58:00 | ... | 46 |
|
| ... | 04:59:00 | 04:59:00 | ... | 47 |
|
| ... | 04:59:00 | 04:59:00 | ... | 48 |
|
| ... | 05:00:00 | 05:00:00 | ... | 49 |
|
| ... | 05:01:00 | 05:01:00 | ... | 50 |
|
| ... | 05:02:00 | 05:02:00 | ... | 51 |
|
| ... | 05:02:00 | 05:02:00 | ... | 52 |
|
| ... | 05:02:00 | 05:02:00 | ... | 53 |
|
| ... | 05:03:00 | 05:03:00 | ... | 54 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 30/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36234964 | Lothian Buses Terminus | 55.8765781511 | -3.3374705364 | |
| 36232574 | Elm Row | 55.9587708658 | -3.1837299539 | |
| 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 | |
| 36246256 | Princes Street (west) | 55.9507077341 | -3.2035338303 | |
| 36238748 | Shandwick Place | 55.9491419034 | -3.2101950003 | |
| 36236576 | Atholl Crescent | 55.9480570676 | -3.2126912558 | |
| 36232659 | Haymarket Station | 55.9452444443 | -3.2172628666 | |
| 36232672 | Caledonian Village | 55.9425438902 | -3.2213890404 | |
| 36232673 | Dalry Primary School | 55.9414043761 | -3.2230342794 | |
| 36232674 | Murieston Crescent | 55.9396088527 | -3.2255872884 | |
| 36236538 | Springwell House | 55.938730203 | -3.2262959727 | |
| 36236498 | St Michaels Church | 55.9367409361 | -3.2275458207 | |
| 36236525 | Shandon Place | 55.9350773712 | -3.2312710846 | |
| 36236526 | Hermand Street | 55.9335710525 | -3.2345368219 | |
| 36236528 | Hutchison Crossway | 55.9306922036 | -3.2384628108 | |
| 36236532 | Hutchison Place | 55.9293816321 | -3.2401175961 | |
| 36236535 | Slateford Station | 55.927178471 | -3.24296008 | |
| 36238754 | Allan Park Road | 55.9250402273 | -3.245596277 | |
| 36235949 | Water of Leith Centre | 55.9232215086 | -3.2477303586 | |
| 36236296 | Slateford House | 55.9224003147 | -3.2498483442 | |
| 36235368 | Redhall View | 55.9208233247 | -3.2547102459 | |
| 36235369 | Dovecot Grove | 55.9187107963 | -3.2583222861 | |
| 36235372 | Kingsknowe Park | 55.9163130636 | -3.2599406299 | |
| 36235373 | Dovecot Park | 55.9149899759 | -3.2610336914 | |
| 36235374 | Kingsknowe Road South | 55.9130565156 | -3.2629387922 | |
| 36235375 | Hailes Grove | 55.9118839195 | -3.2651244576 | |
| 36235376 | Spylaw Bank Road | 55.9098718752 | -3.2685464226 | |
| 36235378 | Spylaw Park | 55.9083944324 | -3.2706577827 | |
| 36237486 | Muirend Avenue | 55.9075359786 | -3.2737330702 | |
| 36237492 | Foulis Crescent | 55.9059603803 | -3.2783682684 | |
| 36237494 | Juniper Green Kirk | 55.9047946637 | -3.2815930192 | |
| 36237495 | St Margaret's Court | 55.903936463 | -3.2837560639 | |
| 36237496 | Baberton Avenue | 55.9033760168 | -3.2849371753 | |
| 36237524 | Juniper Avenue | 55.9016828923 | -3.2895995215 | |
| 36237527 | Muirwood Road | 55.9000869581 | -3.2952563131 | |
| 36237528 | Nether Currie | 55.8990643546 | -3.2985008558 | |
| 36237532 | Bryce Road | 55.8974525787 | -3.3030688777 | |
| 36237563 | Easter Currie | 55.8967829717 | -3.3060529941 | |
| 36242659 | Currie Library | 55.8960937669 | -3.3100278598 | |
| 36237539 | Pentland View Court | 55.8950087525 | -3.3131896221 | |
| 36237543 | Currie High School | 55.8940745545 | -3.3156846832 | |
| 36237549 | Kinauld Leather Works | 55.8926807057 | -3.3208184986 | |
| 36237547 | Stewart Road | 55.891639469 | -3.3240611313 | |
| 36237545 | Newmills Road | 55.8901706523 | -3.3294476048 | |
| 36234942 | Lanark Road West | 55.8882498824 | -3.3383677047 | |
| 36234943 | Balerno High School | 55.8865835623 | -3.3395574281 | |
| 36234946 | Lovedale Road | 55.8839882338 | -3.3427134179 | |
| 36237974 | Clayhills Grove | 55.881487912 | -3.3478545666 | |
| 36234947 | Cockburnhill Road | 55.8786340783 | -3.3491623406 | |
| 36234948 | Highlea Circle | 55.8755062931 | -3.3467681717 | |
| 36234949 | Whitlea Road | 55.8746633892 | -3.3433185432 | |
| 36234952 | Greenfield Crescent | 55.8754035903 | -3.3413621308 |