Edinburgh - St Andrews
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 12:40:00 | 12:40:00 | ... | 1 |
|
| ... | 12:44:00 | 12:44:00 | ... | 2 |
|
| ... | 12:47:00 | 12:47:00 | ... | 3 |
|
| ... | 12:51:00 | 12:51:00 | ... | 4 |
|
| ... | 12:52:00 | 12:52:00 | ... | 5 |
|
| ... | 12:55:00 | 12:55:00 | ... | 6 |
|
| ... | 12:57:00 | 12:57:00 | ... | 7 |
|
| ... | 13:00:00 | 13:00:00 | ... | 8 |
|
| ... | 13:04:00 | 13:04:00 | ... | 9 |
|
| ... | 13:12:00 | 13:12:00 | ... | 10 |
|
| ... | 13:15:00 | 13:15:00 | ... | 11 |
|
| ... | 13:17:00 | 13:17:00 | ... | 12 |
|
| ... | 13:22:00 | 13:22:00 | ... | 13 |
|
| ... | 13:22:00 | 13:22:00 | ... | 14 |
|
| ... | 13:26:00 | 13:26:00 | ... | 15 |
|
| ... | 13:26:00 | 13:26:00 | ... | 16 |
|
| ... | 13:28:00 | 13:28:00 | ... | 17 |
|
| ... | 13:30:00 | 13:30:00 | ... | 18 |
|
| ... | 13:30:00 | 13:30:00 | ... | 19 |
|
| ... | 13:37:00 | 13:37:00 | ... | 20 |
|
| ... | 13:46:00 | 13:46:00 | ... | 21 |
|
| ... | 13:48:00 | 13:48:00 | ... | 22 |
|
| ... | 13:50:00 | 13:50:00 | ... | 23 |
|
| ... | 13:51:00 | 13:51:00 | ... | 24 |
|
| ... | 13:51:00 | 13:51:00 | ... | 25 |
|
| ... | 13:52:00 | 13:52:00 | ... | 26 |
|
| ... | 13:53:00 | 13:53:00 | ... | 27 |
|
| ... | 13:54:00 | 13:54:00 | ... | 28 |
|
| ... | 13:55:00 | 13:55:00 | ... | 29 |
|
| ... | 13:56:00 | 13:56:00 | ... | 30 |
|
| ... | 13:57:00 | 13:57:00 | ... | 31 |
|
| ... | 13:58:00 | 13:58:00 | ... | 32 |
|
| ... | 13:59:00 | 13:59:00 | ... | 33 |
|
| ... | 13:59:00 | 13:59:00 | ... | 34 |
|
| ... | 14:01:00 | 14:01:00 | ... | 35 |
|
| ... | 14:01:00 | 14:01:00 | ... | 36 |
|
| ... | 14:01:00 | 14:01:00 | ... | 37 |
|
| ... | 14:05:00 | 14:05:00 | ... | 38 |
|
| ... | 14:08:00 | 14:08:00 | ... | 39 |
|
| ... | 14:11:00 | 14:11:00 | ... | 40 |
|
| ... | 14:12:00 | 14:12:00 | ... | 41 |
|
| ... | 14:15:00 | 14:15:00 | ... | 42 |
|
| ... | 14:16:00 | 14:16:00 | ... | 43 |
|
| ... | 14:20:00 | 14:20:00 | ... | 44 |
|
| ... | 14:25:00 | 14:25:00 | ... | 45 |
|
| ... | 14:25:00 | 14:25:00 | ... | 46 |
|
| ... | 14:26:00 | 14:26:00 | ... | 47 |
|
| ... | 14:26:00 | 14:26:00 | ... | 48 |
|
| ... | 14:27:00 | 14:27:00 | ... | 49 |
|
| ... | 14:27:00 | 14:27:00 | ... | 50 |
|
| ... | 14:28:00 | 14:28:00 | ... | 51 |
|
| ... | 14:28:00 | 14:28:00 | ... | 52 |
|
| ... | 14:29:00 | 14:29:00 | ... | 53 |
|
| ... | 14:32:00 | 14:32:00 | ... | 54 |
|
| ... | 14:33:00 | 14:33:00 | ... | 55 |
|
| ... | 14:33:00 | 14:33:00 | ... | 56 |
|
| ... | 14:34:00 | 14:34:00 | ... | 57 |
|
| ... | 14:34:00 | 14:34:00 | ... | 58 |
|
| ... | 14:36:00 | 14:36:00 | ... | 59 |
|
| ... | 14:36:00 | 14:36:00 | ... | 60 |
|
| ... | 14:38:00 | 14:38:00 | ... | 61 |
|
| ... | 14:40:00 | 14:40:00 | ... | 62 |
|
| ... | 14:42:00 | 14:42:00 | ... | 63 |
|
| ... | 14:43:00 | 14:43:00 | ... | 64 |
|
| ... | 14:45:00 | 14:45:00 | ... | 65 |
|
| ... | 14:46:00 | 14:46:00 | ... | 66 |
|
| ... | 14:46:00 | 14:46:00 | ... | 67 |
|
| ... | 14:48:00 | 14:48:00 | ... | 68 |
|
| ... | 14:51:00 | 14:51:00 | ... | 69 |
|
| ... | 14:51:00 | 14:51:00 | ... | 70 |
|
| ... | 14:55:00 | 14:55:00 | ... | 71 |
|
| ... | 14:56:00 | 14:56:00 | ... | 72 |
|
| ... | 14:57:00 | 14:57:00 | ... | 73 |
|
| ... | 14:59:00 | 14:59:00 | ... | 74 |
|
| ... | 14:59:00 | 14:59:00 | ... | 75 |
|
| ... | 15:00:00 | 15:00:00 | ... | 76 |
|
| ... | 15:01:00 | 15:01:00 | ... | 77 |
|
| ... | 15:01:00 | 15:01:00 | ... | 78 |
|
| ... | 15:02:00 | 15:02:00 | ... | 79 |
|
| ... | 15:03:00 | 15:03:00 | ... | 80 |
|
| ... | 15:05:00 | 15:05:00 | ... | 81 |
|
| ... | 15:05:00 | 15:05:00 | ... | 82 |
|
| ... | 15:08:00 | 15:08:00 | ... | 83 |
|
| ... | 15:09:00 | 15:09:00 | ... | 84 |
|
| ... | 15:10:00 | 15:10:00 | ... | 85 |
|
| ... | 15:11:00 | 15:11:00 | ... | 86 |
|
| ... | 15:12:00 | 15:12:00 | ... | 87 |
|
| ... | 15:13:00 | 15:13:00 | ... | 88 |
|
| ... | 15:15:00 | 15:15:00 | ... | 89 |
|
| ... | 15:16:00 | 15:16:00 | ... | 90 |
|
| ... | 15:19:00 | 15:19:00 | ... | 91 |
|
| ... | 15:20:00 | 15:20:00 | ... | 92 |
|
| ... | 15:21:00 | 15:21:00 | ... | 93 |
|
| ... | 15:21:00 | 15:21:00 | ... | 94 |
|
| ... | 15:22:00 | 15:22:00 | ... | 95 |
|
| ... | 15:23:00 | 15:23:00 | ... | 96 |
|
| ... | 15:24:00 | 15:24:00 | ... | 97 |
|
| ... | 15:25:00 | 15:25:00 | ... | 98 |
|
| ... | 15:26:00 | 15:26:00 | ... | 99 |
|
| ... | 15:27:00 | 15:27:00 | ... | 100 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 13/08/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36232525 | Princes Street (Scott Mon.) | 55.9523439105 | -3.1942158046 | |
| 36243234 | Princes Street (west) | 55.9511628114 | -3.2010977238 | |
| 36246545 | Queensferry Street | 55.950587789 | -3.2093593254 | |
| 36232695 | Learmonth Terrace | 55.9551075427 | -3.2193822781 | |
| 36232729 | Craigleith Road | 55.9562687983 | -3.2434438948 | |
| 36237645 | Telford Road | 55.9601344736 | -3.2565427484 | |
| 36238694 | Hillpark Steps | 55.9625803596 | -3.2756050347 | |
| 36238724 | Barnton Junction | 55.9605022697 | -3.3033129428 | |
| 36237989 | Slip Road | 55.9864277768 | -3.4053472921 | |
| 36243759 | Bus Station | 55.955358747 | -3.1918741722 | |
| 34323672 | West Access Ridge Way | 56.0417136526 | -3.3615429682 | |
| 34323742 | East Access Ridge Way | 56.045709662 | -3.3404442221 | |
| 34323652 | Pentland Rise | 56.041090638 | -3.3429647405 | |
| 34323594 | Meadowfield | 56.0392101462 | -3.356334397 | |
| 34323425 | Square | 56.0306833998 | -3.3981289106 | |
| 34323495 | Bannerman Avenue | 56.0352583318 | -3.3964325695 | |
| 34323246 | North Access | 56.0125129742 | -3.4037922233 | |
| 34323675 | Railway Station | 56.0420380283 | -3.3663380604 | |
| 34349496 | Park & Ride | 56.0226203093 | -3.4062929556 | |
| 34326986 | Dysart Road End | 56.1325027786 | -3.1190888386 | |
| 34326873 | Fraser Place | 56.1299877038 | -3.1219760865 | |
| 34326738 | Porte | 56.1270322089 | -3.1238848577 | |
| 34326538 | West Quality Street | 56.1249259737 | -3.1272498544 | |
| 34325968 | Maryhall Street | 56.1157904172 | -3.1551918214 | |
| 34326252 | The Harbour | 56.1175151995 | -3.151383476 | |
| 34326284 | Old Dunnikier House | 56.1190031883 | -3.1488705548 | |
| 34326364 | Ravenscraig Flats | 56.120557512 | -3.1440432102 | |
| 34326425 | Ravenscraig Park | 56.121757085 | -3.1386902652 | |
| 34326465 | Briarcliffe Street | 56.1228917203 | -3.1354905657 | |
| 34326485 | Wishart Place | 56.1233880636 | -3.1313389412 | |
| 34325872 | St Brycedale Road | 56.1119311351 | -3.1633419011 | |
| 34325925 | St Peter's Church | 56.1133140704 | -3.1596044211 | |
| 34329564 | Letham Glen | 56.2024566238 | -2.9966881848 | |
| 34329494 | Cupar Road | 56.2051318201 | -2.9947426123 | |
| 34329529 | Scoonie Golf Course | 56.2063121243 | -2.9920972017 | |
| 34329362 | Haughgate Avenue | 56.2012364649 | -2.9953509567 | |
| 34329295 | Hawthorn Street | 56.1992190449 | -2.9948312916 | |
| 34329235 | Scoonie Kirk | 56.1974454975 | -2.9952688734 | |
| 34328782 | Viewforth Nursery | 56.1950686247 | -2.9947560774 | |
| 34328286 | Memorial Court | 56.1830081502 | -3.0149850047 | |
| 34327927 | Muiredge Roundabout | 56.1736628184 | -3.039961479 | |
| 34327895 | College Street | 56.1714158648 | -3.0336194681 | |
| 34327642 | School Wynd | 56.1605542579 | -3.0662547896 | |
| 34327539 | Bowling Green | 56.1503037733 | -3.0907924823 | |
| 34325649 | Esplanade | 56.0979744884 | -3.1626637119 | |
| 34325848 | Bus Station | 56.1101068762 | -3.1605049394 | |
| 34328328 | South Grove | 56.1843474711 | -3.0094297912 | |
| 34328686 | Bus Station | 56.1933024249 | -2.9987390825 | |
| 34325896 | St Brycedale Campus | 56.1125570915 | -3.1617526458 | |
| 34346479 | Bus Station | 56.1101197034 | -3.1610520602 | |
| 34345369 | West Lodge | 56.080763748 | -3.27933155 | |
| 34398929 | Silverburn Park | 56.2082126363 | -2.9825058592 | |
| 34346475 | Bus Station | 56.1932969565 | -2.9994157656 | |
| 34343483 | Kinnessburn Road | 56.3366746215 | -2.8005682905 | |
| 34343436 | Fire Station | 56.3338382687 | -2.8029187754 | |
| 34343293 | Pipeland Road | 56.3330729153 | -2.7976139955 | |
| 34343298 | Langlands Road | 56.3332016316 | -2.7929587259 | |
| 34343426 | Warrack Street | 56.3333974795 | -2.7876093496 | |
| 34343428 | Woodburn Terrace | 56.3335087556 | -2.7842313658 | |
| 34342349 | Toll Road | 56.2267092084 | -2.6923734738 | |
| 34342347 | March Crescent | 56.2251422952 | -2.6914097986 | |
| 34329896 | School Road | 56.2231872768 | -2.6939710224 | |
| 34329868 | Fisheries Museum | 56.2218582473 | -2.6970432631 | |
| 34329892 | Harbour | 56.2228969973 | -2.7008358033 | |
| 34329898 | St Andrews Road | 56.2232433474 | -2.7031321579 | |
| 34329864 | Crichton Street | 56.2216152355 | -2.7066178701 | |
| 34329832 | Craws Nest Hotel | 56.2196474052 | -2.7097906207 | |
| 34329742 | Milton Road | 56.2154098977 | -2.724723462 | |
| 34329689 | Tollcross | 56.2141349791 | -2.7321966838 | |
| 34329545 | Elm Grove | 56.2083020891 | -2.7607804511 | |
| 34329536 | Station Road | 56.2080461461 | -2.767304259 | |
| 34328545 | Wadeslea | 56.191317547 | -2.8162620868 | |
| 34328484 | High Street | 56.1904785232 | -2.8208527001 | |
| 34328594 | Primary School | 56.1925839661 | -2.8217517257 | |
| 34329786 | Durham Wynd | 56.2164420071 | -2.9386480848 | |
| 34329794 | Harbour Wynd | 56.2165641693 | -2.9414889903 | |
| 34329793 | Largo Road | 56.2165596305 | -2.9456167625 | |
| 34329752 | Lundin Links Hotel | 56.2140272138 | -2.9524713804 | |
| 34329696 | Old Manor Hotel | 56.2131379684 | -2.958253652 | |
| 34329876 | Simpson Institute | 56.22087967 | -2.9256458656 | |
| 34329867 | Post Office | 56.2201976629 | -2.929128774 | |
| 34342345 | Co-op Supermarket | 56.2248498158 | -2.7065967767 | |
| 34342352 | Police Station | 56.226816596 | -2.6940527718 | |
| 34382497 | Kinkell Braes Caravan Park | 56.3289857549 | -2.7748398913 | |
| 34345363 | Alexandra Place | 56.339382769 | -2.8013691168 | |
| 34345729 | Viewforth Place | 56.2144073651 | -2.7377644209 | |
| 34398694 | Beley Farm | 56.2868834723 | -2.7471885724 | |
| 34347642 | Cauldcots Farm | 56.2347624468 | -2.7108445335 | |
| 34345868 | Pitkierie Garage | 56.2421179735 | -2.7175638864 | |
| 34346496 | Bonerbo Farm | 56.2597040685 | -2.7277721575 | |
| 34398962 | Balmungo Steadings | 56.3226484383 | -2.7681468885 | |
| 34348253 | Ardross Farm | 56.1976771969 | -2.7944305324 | |
| 34347967 | Balchrystie Farm | 56.2159930189 | -2.8723503516 | |
| 34329596 | Farm Cottage | 56.20958589 | -2.8557770304 | |
| 34342385 | Smith Cottage | 56.2498677395 | -2.718241454 | |
| 34342532 | Crossroads | 56.2667165804 | -2.7346056222 | |
| 34342656 | Primary School | 56.2890616805 | -2.7480226583 | |
| 34329396 | Road End | 56.2043138968 | -2.8423934422 | |
| 34346469 | Bus Station | 56.3404991907 | -2.8023954731 | |
| 34329828 | Hollybank Cottage | 56.2182362856 | -2.901571719 |