street
10,780 rows sorted by name_fi
This data as json, CSV (advanced)
municipality ✖
- helsinki 4,094
- espoo 3,199
- vantaa 2,986
- kauniainen 122
id | modified_at | municipality | name_fi ▼ | name_sv |
---|---|---|---|---|
7140 | 2018-08-07T16:13:06.571529+03:00 | vantaa | Aunentie | Agnesvägen |
7139 | 2018-08-07T16:13:06.569463+03:00 | vantaa | Aurakuja | Ploggränden |
141 | 2018-08-07T16:12:22.899814+03:00 | helsinki | Aurapolku | Plogstigen |
7138 | 2018-08-07T16:13:06.567202+03:00 | vantaa | Auratie | Plogvägen |
7918 | 2018-08-07T16:13:07.902329+03:00 | espoo | Auringonkatu | Solgatan |
7137 | 2018-08-07T16:13:06.565816+03:00 | vantaa | Auringonkehrä | Solskivan |
7136 | 2018-08-07T16:13:06.561476+03:00 | vantaa | Auringonkierto | Solvändan |
7911 | 2018-08-07T16:13:07.893389+03:00 | espoo | Auringonkuja | Solskivan |
7135 | 2018-08-07T16:13:06.559922+03:00 | vantaa | Aurinkokivenkuja | Solstensgränden |
7134 | 2018-08-07T16:13:06.558249+03:00 | vantaa | Aurinkokivenpiha | Solstensgården |
142 | 2018-08-07T16:12:22.901403+03:00 | helsinki | Aurinkokuja | Solgränden |
143 | 2018-08-07T16:12:22.903235+03:00 | helsinki | Aurinkolahden puistotie | Solviksallén |
3473 | 2018-08-07T16:12:34.750319+03:00 | helsinki | Aurinkolahdenaukio | Solviksplatsen |
150 | 2018-08-07T16:12:22.921304+03:00 | helsinki | Aurinkomäenkuja | Solbackagränden |
112 | 2018-08-07T16:12:22.845024+03:00 | helsinki | Aurinkomäentie | Solbackavägen |
7133 | 2018-08-07T16:13:06.556927+03:00 | vantaa | Aurinkomäentie | Solbergsvägen |
10144 | 2018-08-07T16:13:17.400613+03:00 | espoo | Aurinkoniitynkuja | Solängsgränden |
8851 | 2018-08-07T16:13:11.008879+03:00 | espoo | Aurinkoniityntie | Solängsvägen |
10553 | 2018-11-14T12:12:32.993814+02:00 | helsinki | Aurinkoranta | Solstranden |
114 | 2018-08-07T16:12:22.847557+03:00 | helsinki | Aurinkotie | Solvägen |
7132 | 2018-08-07T16:13:06.555373+03:00 | vantaa | Aurinkotie | Solvägen |
151 | 2018-08-07T16:12:22.924799+03:00 | helsinki | Aurinkotuulenkatu | Solvindsgatan |
152 | 2018-08-07T16:12:22.927128+03:00 | helsinki | Aurorankatu | Auroragatan |
8641 | 2018-08-07T16:13:08.607310+03:00 | espoo | Aurorankuja | Auroragränden |
9345 | 2018-08-07T16:13:11.705706+03:00 | espoo | Auroranmäki | Aurorabacken |
153 | 2018-08-07T16:12:22.928896+03:00 | helsinki | Auroranportti | Auroraporten |
9956 | 2018-08-07T16:13:14.078626+03:00 | espoo | Auroranportti | Auroraporten |
154 | 2018-08-07T16:12:22.929866+03:00 | helsinki | Autotallintie | Garagevägen |
7131 | 2018-08-07T16:13:06.554333+03:00 | vantaa | Avainpolku | Nyckelstigen |
7130 | 2018-08-07T16:13:06.550578+03:00 | vantaa | Avaintie | Nyckelvägen |
11393 | 2018-11-14T12:12:41.446484+02:00 | helsinki | Avajaisaukio | Vernissageplatsen |
7766 | 2018-08-07T16:13:07.740624+03:00 | espoo | Avaruuskatu | Rymdgatan |
7129 | 2018-08-07T16:13:06.549203+03:00 | vantaa | Avia-aukio | Aviaplatsen |
7128 | 2018-08-07T16:13:06.547855+03:00 | vantaa | Aviabulevardi | Aviabulevarden |
7127 | 2018-08-07T16:13:06.545911+03:00 | vantaa | Aviakuja | Aviagränden |
3941 | 2018-08-07T16:12:41.700852+03:00 | helsinki | Azorienkuja | Azorergränden |
3939 | 2018-08-07T16:12:41.699046+03:00 | helsinki | Bahamankatu | Bahamasgatan |
11437 | 2018-11-14T12:12:42.702820+02:00 | helsinki | Bahamankuja | Bahamasgränden |
9991 | 2018-08-07T16:13:16.449297+03:00 | espoo | Balderinkuja | Baldersgränden |
9174 | 2018-08-07T16:13:11.396640+03:00 | espoo | Bassenkuja | Bassegränden |
9504 | 2018-08-07T16:13:12.281470+03:00 | espoo | Bassenkyläntie | Bassebyvägen |
8109 | 2018-08-07T16:13:08.097804+03:00 | espoo | Bassenmäki | Bassebacken |
9242 | 2018-08-07T16:13:11.499103+03:00 | espoo | Bassenraitti | Bassestråket |
203 | 2018-08-07T16:12:23.026726+03:00 | helsinki | Beckerintie | Beckersvägen |
8399 | 2018-08-07T16:13:08.378512+03:00 | espoo | Bellinmäki | Bellbacken |
10285 | 2018-08-07T16:13:18.780078+03:00 | espoo | Bellinrinne | Bellbranten |
8400 | 2018-08-07T16:13:08.379245+03:00 | espoo | Bellintie | Bellvägen |
10563 | 2018-11-14T12:12:33.056898+02:00 | helsinki | Bellispolku - Oulunkylän siirtolapuutarha | Bellisstigen- Åggelby koloniträdgård |
10564 | 2018-11-14T12:12:33.061530+02:00 | helsinki | Bellisstigen - Ruskeasuon siirtolapuutarha | Bellisstigen - Brunakärr koloniträdgård |
4099 | 2018-08-07T16:12:46.242850+03:00 | kauniainen | Bembölentie | Bembölevägen |
10565 | 2018-11-14T12:12:33.062287+02:00 | helsinki | Bengalinpolku | Bengalenstigen |
156 | 2018-08-07T16:12:22.932407+03:00 | helsinki | Benktankuja | Bengtagränden |
2467 | 2018-08-07T16:12:30.109102+03:00 | helsinki | Bensa-asemankuja | Bensinmacksgränden |
4071 | 2018-08-07T16:12:46.199857+03:00 | kauniainen | Bensowinkuja | Bensowsgränden |
8111 | 2018-08-07T16:13:08.099238+03:00 | espoo | Bensulsintie | Bensulsvägen |
157 | 2018-08-07T16:12:22.933143+03:00 | helsinki | Bergantie | Bergavägen |
158 | 2018-08-07T16:12:22.934446+03:00 | helsinki | Bergbominkuja | Bergbomsgränden |
7126 | 2018-08-07T16:13:06.543000+03:00 | vantaa | Bergkullantie | Bergkullavägen |
9943 | 2018-08-07T16:13:14.032959+03:00 | espoo | Bergön Flakaholm | Bergö Flakaholm |
9914 | 2018-08-07T16:13:13.931843+03:00 | espoo | Bergönrinne | Bergöbrinken |
7276 | 2018-08-07T16:13:07.239479+03:00 | espoo | Bergöntie | Bergövägen |
159 | 2018-08-07T16:12:22.935154+03:00 | helsinki | Berliininkatu | Berlingatan |
10570 | 2018-11-14T12:12:33.105336+02:00 | helsinki | Berliininkuja | Berlingränden |
4002 | 2018-08-07T16:12:45.169292+03:00 | helsinki | Bermudankatu | Bermudagatan |
11414 | 2018-11-14T12:12:42.254949+02:00 | helsinki | Bermudankolmio | Bermudatriangeln |
11412 | 2018-11-14T12:12:42.244007+02:00 | helsinki | Bermudankuja | Bermudagränden |
187 | 2018-08-07T16:12:22.990348+03:00 | helsinki | Bernhardinkatu | Bernhardsgatan |
7125 | 2018-08-07T16:13:06.541984+03:00 | vantaa | Bertaksenkuja | Bertasgränden |
7124 | 2018-08-07T16:13:06.540458+03:00 | vantaa | Bertaksentie | Bertasvägen |
9230 | 2018-08-07T16:13:11.483478+03:00 | espoo | Bertel Jungin aukio | Bertel Jungs plats |
101 | 2018-08-07T16:12:22.826047+03:00 | helsinki | Bertel Jungin tie | Bertel Jungs väg |
102 | 2018-08-07T16:12:22.827758+03:00 | helsinki | Bertha Pauligin katu | Bertha Pauligs gata |
10551 | 2018-11-14T12:12:32.979478+02:00 | helsinki | Bertha Tabelle vägen - Ruskeasuon siirtolapuutarha | Bertha Tabelle vägen - Brunakärr koloniträdgård |
10370 | 2018-08-07T16:13:21.919352+03:00 | espoo | Berthanpolku | Berthastigen |
8009 | 2018-08-07T16:13:07.991578+03:00 | espoo | Betonimiehenkuja | Betongblandargränden |
103 | 2018-08-07T16:12:22.829677+03:00 | helsinki | Betonitie | Betongvägen |
104 | 2018-08-07T16:12:22.830494+03:00 | helsinki | Biologinkatu | Biologgatan |
11251 | 2018-11-14T12:12:38.651543+02:00 | helsinki | Birger Brunilan puistokuja | Birger Brunilas allé |
7348 | 2018-08-07T16:13:07.314198+03:00 | espoo | Birger Carlstedtin kuja | Birger Carlstedts gränd |
105 | 2018-08-07T16:12:22.831879+03:00 | helsinki | Birger Kaipiaisen katu | Birger Kaipiainens gata |
204 | 2018-08-07T16:12:23.029669+03:00 | helsinki | Birger Kaipiaisen piha | Birger Kaipiainens gård |
10573 | 2018-11-14T12:12:33.140405+02:00 | helsinki | Birgittalaiskatu | Birgittingatan |
10582 | 2018-11-14T12:12:33.171657+02:00 | helsinki | Birgittalaiskuja | Birgittingränden |
10583 | 2018-11-14T12:12:33.172407+02:00 | helsinki | Birkankuja | Birkagränden |
7123 | 2018-08-07T16:13:06.538979+03:00 | vantaa | Birkanpolku | Birkastigen |
7122 | 2018-08-07T16:13:06.529895+03:00 | vantaa | Bisajärventie | Bisaträskvägen |
9925 | 2018-08-07T16:13:13.986825+03:00 | espoo | Björkholmen | Björkholmen |
7332 | 2018-08-07T16:13:07.297420+03:00 | espoo | Björksundintie | Björksundsvägen |
10262 | 2018-08-07T16:13:18.470634+03:00 | espoo | Björkö | Björkö |
8316 | 2018-08-07T16:13:08.298442+03:00 | espoo | Blominkuja | Blommens gränd |
10379 | 2018-08-07T16:13:21.976216+03:00 | espoo | Blominmetsäntie | Blomskogsvägen |
8314 | 2018-08-07T16:13:08.297025+03:00 | espoo | Blominmäki | Blombacken |
8315 | 2018-08-07T16:13:08.297742+03:00 | espoo | Blomintie | Blommens väg |
7294 | 2018-08-07T16:13:07.259231+03:00 | espoo | Bodominkuja | Bodomgränden |
8961 | 2018-08-07T16:13:11.131169+03:00 | espoo | Bodomintie | Bodomvägen |
7334 | 2018-08-07T16:13:07.299255+03:00 | espoo | Bodöntie | Bodövägen |
9346 | 2018-08-07T16:13:11.708022+03:00 | espoo | Boholmankuja | Boholmsgränden |
188 | 2018-08-07T16:12:22.991868+03:00 | helsinki | Bomansonintie | Bomansonsvägen |
4159 | 2018-08-07T16:12:46.391776+03:00 | kauniainen | Borgintie | Borgsvägen |
8360 | 2018-08-07T16:13:08.337198+03:00 | espoo | Borgintie | Borgsvägen |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [street] ( [id] INTEGER PRIMARY KEY, [modified_at] TEXT, [municipality] TEXT, [name_fi] TEXT, [name_sv] TEXT );