Rosewell - Fort Kinnaird

  1. Molten Mouse
  2. TNDS
  3. Trip
Details
trip_id arrival_time departure_time stop_id stop_sequence
... 15:45:00 15:45:00 ... 1
... 15:46:00 15:46:00 ... 2
... 15:46:00 15:46:00 ... 3
... 15:47:00 15:47:00 ... 4
... 15:50:00 15:50:00 ... 5
... 15:51:00 15:51:00 ... 6
... 15:52:00 15:52:00 ... 7
... 15:53:00 15:53:00 ... 8
... 15:54:00 15:54:00 ... 9
... 15:55:00 15:55:00 ... 10
... 15:56:00 15:56:00 ... 11
... 15:57:00 15:57:00 ... 12
... 15:58:00 15:58:00 ... 13
... 15:59:00 15:59:00 ... 14
... 16:00:00 16:00:00 ... 15
... 16:01:00 16:01:00 ... 16
... 16:01:00 16:01:00 ... 17
... 16:02:00 16:02:00 ... 18
... 16:03:00 16:03:00 ... 19
... 16:05:00 16:05:00 ... 20
... 16:08:00 16:08:00 ... 21
... 16:08:00 16:08:00 ... 22
... 16:09:00 16:09:00 ... 23
... 16:11:00 16:11:00 ... 24
... 16:13:00 16:13:00 ... 25
... 16:14:00 16:14:00 ... 26
... 16:15:00 16:15:00 ... 27
... 16:16:00 16:16:00 ... 28
... 16:18:00 16:18:00 ... 29
... 16:18:00 16:18:00 ... 30
... 16:20:00 16:20:00 ... 31
... 16:22:00 16:22:00 ... 32
... 16:24:00 16:24:00 ... 33
... 16:25:00 16:25:00 ... 34
... 16:27:00 16:27:00 ... 35
... 16:28:00 16:28:00 ... 36
... 16:29:00 16:29:00 ... 37
... 16:31:00 16:31:00 ... 38
... 16:34:00 16:34:00 ... 39
... 16:35:00 16:35:00 ... 40
... 16:36:00 16:36:00 ... 41
... 16:37:00 16:37:00 ... 42
... 16:38:00 16:38:00 ... 43
... 16:39:00 16:39:00 ... 44
... 16:40:00 16:40:00 ... 45
... 16:41:00 16:41:00 ... 46
... 16:42:00 16:42:00 ... 47
... 16:43:00 16:43:00 ... 48
... 16:45:00 16:45:00 ... 49
... 16:45:00 16:45:00 ... 50
... 16:46:00 16:46:00 ... 51
... 16:47:00 16:47:00 ... 52
... 16:49:00 16:49:00 ... 53
... 16:51:00 16:51:00 ... 54
... 16:53:00 16:53:00 ... 55
... 16:55:00 16:55:00 ... 56
... 16:57:00 16:57:00 ... 57
... 17:00:00 17:00:00 ... 58
... 17:03:00 17:03:00 ... 59
... 17:05:00 17:05:00 ... 60
... 17:07:00 17:07:00 ... 61
... 17:08:00 17:08:00 ... 62
... 17:09:00 17:09:00 ... 63
... 17:10:00 17:10:00 ... 64
... 17:11:00 17:11:00 ... 65
... 17:13:00 17:13:00 ... 66
... 17:14:00 17:14:00 ... 67
... 17:15:00 17:15:00 ... 68
... 17:16:00 17:16:00 ... 69
... 17:17:00 17:17:00 ... 70
... 17:18:00 17:18:00 ... 71
... 17:18:00 17:18:00 ... 72
... 17:19:00 17:19:00 ... 73
... 17:20:00 17:20:00 ... 74
... 17:21:00 17:21:00 ... 75
... 17:21:00 17:21:00 ... 76
... 17:22:00 17:22:00 ... 77
... 17:23:00 17:23:00 ... 78
... 17:23:00 17:23:00 ... 79
... 17:24:00 17:24:00 ... 80
... 17:24:00 17:24:00 ... 81
... 17:25:00 17:25:00 ... 82
... 17:26:00 17:26:00 ... 83
... 17:29:00 17:29:00 ... 84
... 17:30:00 17:30:00 ... 85
... 17:31:00 17:31:00 ... 86
... 17:32:00 17:32:00 ... 87
... 17:34:00 17:34:00 ... 88
... 17:35:00 17:35:00 ... 89
... 17:36:00 17:36:00 ... 90
... 17:38:00 17:38:00 ... 91
... 17:38:00 17:38:00 ... 92
... 17:39:00 17:39:00 ... 93
... 17:40:00 17:40:00 ... 94
... 17:41:00 17:41:00 ... 95
... 17:44:00 17:44:00 ... 96
... 17:45:00 17:45:00 ... 97
... 17:45:00 17:45:00 ... 98
... 17:46:00 17:46:00 ... 99
start_date end_date monday tuesday wednesday thursday friday saturday sunday
30/09/2018 @ 00:00 01/01/0001 @ 00:00
stop_code stop_name stop_lat stop_lon
36238543 Leith Street 55.9554593258 -3.1870403387
36235979 Elm Row 55.9588662918 -3.1840852566
36235629 Shrubhill 55.9619679952 -3.1801592221
36235634 Pilrig Street 55.9641764086 -3.1775511309
36237349 Balfour Street 55.9664692496 -3.1755060332
36237348 Stead's Place 55.9680636656 -3.1741444966
36237378 Foot of the Walk 55.9696859297 -3.1726875589
36235643 Duke Street 55.9699406398 -3.16952286
36235649 Burns Street 55.9682315088 -3.1659305299
36235652 Woodville Terrace 55.9660592204 -3.1637985292
36235653 Hermitage Park Grove 55.9646969346 -3.1624760258
36235654 Lochend Park 55.9628268986 -3.159728711
36253278 Lochend Castle Barns 55.9617148839 -3.1585420915
36243939 Marionville Road 55.9599751071 -3.1572246753
36243925 Lochend Quadrant 55.959983406 -3.1553828409
36243952 Sleigh Drive 55.9616352504 -3.1536219443
36232928 Sleigh Gardens 55.9623381738 -3.1514802862
36232929 Findlay Avenue 55.9624817066 -3.1486171261
36232932 Restalrig Drive 55.962626662 -3.1455937962
36232934 Loaning Road 55.9612675302 -3.1429426028
36232935 Loganlea Road 55.960200388 -3.1398036212
36232936 Craigentinny Crossroads 55.9602414375 -3.1373059928
36232937 Christiemillar Avenue 55.9604874222 -3.134990559
36232938 Vandaleur Avenue 55.9609293505 -3.1309027736
36232939 Bryce Avenue 55.9603730513 -3.1278751239
36232942 Portobello Road 55.957695665 -3.1248981507
36234276 King's Road 55.9566462226 -3.1207514262
36234279 Bridge Street 55.9549318774 -3.117578772
36234282 Portobello Town Hall 55.9534882446 -3.1152629923
36234365 Parrotshot 55.9389849322 -3.1123806698
36234368 Corbiewynd 55.9395070956 -3.1082811828
36234372 Milton Link 55.939745129 -3.1057904763
36245253 Fort Kinnaird 55.935031318 -3.1023905909
36234379 Newcraighall Road 55.9336886469 -3.0987988687
36242942 Retail Park 55.9332672297 -3.1017162122
36234383 Niddrie Cottages 55.9328851199 -3.1042504487
36234579 Standford Gardens 55.951656423 -3.1161231484
36238368 Southfield Place 55.9487038137 -3.1196892358
36238369 Durham Place Lane 55.9465043113 -3.1184888643
36238372 Milton Road 55.9442962483 -3.1172403495
36234359 Magdalene Drive 55.9407389773 -3.1151526685
36234363 The Jewel 55.9391327479 -3.114914394
36237839 Ferniehill Grove 55.9140614429 -3.126977874
36247289 Moredunvale Road 55.9184216262 -3.1355368851
36235439 Fernieside Drive 55.9154739621 -3.1297228087
36235452 Craigmillar Castle Road 55.9208834934 -3.1433218132
36235453 Kingston Avenue 55.9217164553 -3.1474749318
36235454 Walter Scott Avenue 55.9238776997 -3.1508194605
36253592 Craigmillar Cemetery 55.926031817 -3.1539560996
36235456 Bridgend Cottages 55.9271916307 -3.1557990918
36236295 Cameron Toll 55.9283139032 -3.1616263311
36242685 Cameron Toll Centre 55.9277384442 -3.1645219872
36234847 Lygon Road 55.9273479183 -3.1678072318
36234848 Suffolk Road 55.9287357414 -3.1692734488
36234849 East Savile Road 55.9308004653 -3.1713684195
36234852 Mayfield Gardens 55.9333727544 -3.1739431691
36234853 Minto Street 55.9346359625 -3.1752780016
36234854 Salisbury Place 55.9358821069 -3.1765163552
36234786 Newington Road 55.9376977847 -3.178332388
36236562 Bernard Terrace 55.9405669692 -3.1808530611
36234857 St Patrick Square 55.9432750231 -3.1833051509
36236563 Surgeons' Hall 55.9457306866 -3.184901221
36243274 South Bridge 55.949078441 -3.1871653304
36235879 North Bridge 55.9515828254 -3.1883630155
36253632 Royal Infirmary 55.9225704743 -3.1328737624
64323479 Buccleuch Street 55.8927482295 -3.0705698045
64324572 Tesco 55.882592893 -3.0851412461
64329349 Summerside 55.9011455179 -3.0945357861
64324528 Terminus 55.8476977121 -3.1393191541
64324527 St Joseph's 55.8557921791 -3.1326707674
64324525 Prestonhall Road 55.8531629325 -3.1352140156
64324523 Gorton Road 55.8511286069 -3.1365763155
64329276 Midfield House 55.865421499 -3.13301497
64324397 St Annes Avenue 55.8696880416 -3.1282970201
64324394 Pentland Road 55.8721952248 -3.1223765338
64324389 Dalhousie Drive 55.869650393 -3.1176526969
64323298 Skeltiemuir Avenue 55.8689542058 -3.1151557154
64323282 Hopefield Place 55.8704120507 -3.1129281841
64323289 Hazel Drive 55.8724628429 -3.1097105536
64323275 Dobbies Road 55.8738387349 -3.1075921649
64324393 Farm Avenue 55.8716967994 -3.1248073489
64323276 Douglas Crescent 55.8751627009 -3.105248389
64323284 Maryfield Place 55.8765221258 -3.1029534111
64323426 Waverley Crescent 55.8777514552 -3.1011341158
64323295 Pendreich Avenue 55.8795327243 -3.096868643
64323424 Viewbank Avenue 55.8805041206 -3.0937309653
64323286 Mayshade Garden Centre 55.8817043269 -3.091127078
64323648 Muirpark 55.8834106482 -3.0881854983
64323653 Westfield Park 55.8853400713 -3.0854097614
64323643 Bonnyrigg Road 55.8866599609 -3.0834801163
64323482 Croft Street 55.8927540228 -3.0730004779
64323492 Glenesk Crescent 55.8896547622 -3.0790866708
64323562 South Street 55.8934750899 -3.0696463834
64323475 Bridgend Court 55.8954854206 -3.0719884707
64323528 Lugton Brae 55.8968510458 -3.0812534739
64323536 Melville Gate Road 55.8971594528 -3.0860276873
64325832 Sheriffhall Park and Ride 55.905505099 -3.0993932733
64323589 Old Dalkeith Road 55.910423131 -3.1100748507
64323597 The Wisp 55.9132226278 -3.1174662786
© 2017 Molten Mouse LTD