street
4,254 rows where municipality = "helsinki" sorted by name_fi
This data as json, CSV (advanced)
Suggested facets: modified_at (date)
id | modified_at | municipality | name_fi ▼ | name_sv |
---|---|---|---|---|
11421 | 2018-11-14T12:12:42.276898+02:00 | helsinki | A.I. Virtasen aukio | A.I. Virtanens plats |
50 | 2018-08-07T16:12:22.706107+03:00 | helsinki | Aadolfinkatu | Adolfsgatan |
3876 | 2018-08-07T16:12:40.178708+03:00 | helsinki | Aallonhalkoja | Vågbrytaren |
51 | 2018-08-07T16:12:22.708663+03:00 | helsinki | Aamukasteenkuja | Morgondaggsgränden |
10540 | 2018-11-14T12:12:32.891638+02:00 | helsinki | Aamuruskonkuja | Morgonrådegränden |
10541 | 2018-11-14T12:12:32.892625+02:00 | helsinki | Aamuruskonpolku | Morgonrådestigen |
17 | 2018-08-07T16:12:22.648826+03:00 | helsinki | Aamuruskontie | Morgonrådevägen |
10534 | 2018-11-14T12:12:32.840197+02:00 | helsinki | Aaponpolku | Aapostigen |
19 | 2018-08-07T16:12:22.652174+03:00 | helsinki | Aapontie | Aapovägen |
20 | 2018-08-07T16:12:22.654865+03:00 | helsinki | Aarholmankuja | Arholmagränden |
21 | 2018-08-07T16:12:22.656169+03:00 | helsinki | Aarrekuja | Klenodgränden |
22 | 2018-08-07T16:12:22.656962+03:00 | helsinki | Aarteenetsijänkuja | Skattsökargränden |
11555 | 2019-04-25T11:36:36.688277+03:00 | helsinki | Aarteenetsijänsilta | Skattsökarbron |
23 | 2018-08-07T16:12:22.658121+03:00 | helsinki | Aarteenetsijäntie | Skattsökarvägen |
24 | 2018-08-07T16:12:22.659842+03:00 | helsinki | Aavasaksantie | Aavasaksavägen |
25 | 2018-08-07T16:12:22.661301+03:00 | helsinki | Abraham Wetterin tie | Abraham Wetters väg |
26 | 2018-08-07T16:12:22.663577+03:00 | helsinki | Abrahaminkatu | Abrahamsgatan |
27 | 2018-08-07T16:12:22.665702+03:00 | helsinki | Adalmiinankatu | Adalminas gata |
10535 | 2018-11-14T12:12:32.852076+02:00 | helsinki | Adelenpolku | Adeles stig |
11239 | 2018-11-14T12:12:38.465587+02:00 | helsinki | Adjutantinpolku | Adjutantstigen |
1 | 2018-08-07T16:12:22.616384+03:00 | helsinki | Adolf Lindforsin tie | Adolf Lindfors väg |
2 | 2018-08-07T16:12:22.619994+03:00 | helsinki | Agnes Sjöbergin katu | Agnes Sjöbergs gata |
3 | 2018-08-07T16:12:22.621176+03:00 | helsinki | Agnetankuja | Agnetagränden |
4 | 2018-08-07T16:12:22.622299+03:00 | helsinki | Agricolankatu | Agricolagatan |
5 | 2019-01-22T18:22:07.787100+02:00 | helsinki | Agricolankuja | Agricolagränden |
10 | 2018-08-07T16:12:22.636631+03:00 | helsinki | Agronominkatu | Agronomgatan |
10532 | 2018-11-14T12:12:32.829418+02:00 | helsinki | Agronominkuja | Agronomgränden |
10533 | 2018-11-14T12:12:32.831170+02:00 | helsinki | Agronominraitti | Agronomstråket |
13 | 2018-08-07T16:12:22.644321+03:00 | helsinki | Ahdekaunokintie | Rödklintsvägen |
14 | 2018-08-07T16:12:22.645844+03:00 | helsinki | Ahjokuja | Ässjegränd |
15 | 2018-08-07T16:12:22.646766+03:00 | helsinki | Ahmatie | Järvvägen |
16 | 2018-08-07T16:12:22.647906+03:00 | helsinki | Ahomäenkuja | Svedjebackagränd |
6 | 2018-08-07T16:12:22.625591+03:00 | helsinki | Ahomäentie | Svedjebackavägen |
7 | 2018-08-07T16:12:22.627730+03:00 | helsinki | Ahvenkoskenkuja | Abborforsgränden |
8 | 2018-08-07T16:12:22.628900+03:00 | helsinki | Ahvenkoskenpolku | Abborforsstigen |
9 | 2018-08-07T16:12:22.631252+03:00 | helsinki | Aidasmäentie | Gärdobackavägen |
10544 | 2018-11-14T12:12:32.912232+02:00 | helsinki | Aili Lindfors vägen - Ruskeasuon siirtolapuutarha | Aili Lindfors vägen - Brunakärr koloniträdgård |
29 | 2018-08-07T16:12:22.669513+03:00 | helsinki | Aino Acktén tie | Aino Acktés väg |
30 | 2018-08-07T16:12:22.671619+03:00 | helsinki | Ainonkatu | Ainogatan |
31 | 2018-08-07T16:12:22.672512+03:00 | helsinki | Airoparinkuja | Årparsgränden |
11463 | 2018-11-14T12:12:43.859572+02:00 | helsinki | Airoparinpolku | Årparsstigen |
32 | 2018-08-07T16:12:22.673836+03:00 | helsinki | Airoparintie | Årparsvägen |
33 | 2018-08-07T16:12:22.677495+03:00 | helsinki | Airoranta | Årstrand |
122 | 2018-08-07T16:12:22.857433+03:00 | helsinki | Airotie | Årvägen |
123 | 2018-08-07T16:12:22.858977+03:00 | helsinki | Airuentie | Budbärarvägen |
124 | 2018-08-07T16:12:22.860396+03:00 | helsinki | Aisatie | Skalmvägen |
10557 | 2018-11-14T12:12:33.004598+02:00 | helsinki | Aitiopaikka | Logeplatsen |
34 | 2018-08-07T16:12:22.678240+03:00 | helsinki | Aittatie | Bodvägen |
10536 | 2018-11-14T12:12:32.859113+02:00 | helsinki | Aiturinraitti | Häcklöparstråket |
36 | 2018-08-07T16:12:22.680033+03:00 | helsinki | Aivinakuja | Linvävsgränden |
37 | 2018-08-07T16:12:22.680965+03:00 | helsinki | Ajomiehentie | Körkarlsvägen |
38 | 2018-08-07T16:12:22.682660+03:00 | helsinki | Ajopolku | Skallgången |
10537 | 2018-11-14T12:12:32.862979+02:00 | helsinki | Ajurinaukio | Formansplatsen |
11252 | 2018-11-14T12:12:38.670172+02:00 | helsinki | Ajurinkuja | Formansgränden |
10538 | 2018-11-14T12:12:32.863999+02:00 | helsinki | Akileijapolku - Oulunkylän siirtolapuutarha | Akileijapolku - Åggelby koloniträdgård |
40 | 2018-08-07T16:12:22.689326+03:00 | helsinki | Akkutie | Ackumulatorvägen |
41 | 2018-08-07T16:12:22.692315+03:00 | helsinki | Akonlahdenkuja | Akonlahtigränden |
42 | 2018-08-07T16:12:22.694147+03:00 | helsinki | Akseli | Axeln |
10539 | 2018-11-14T12:12:32.880984+02:00 | helsinki | Aksiisipolku | Accisstigen |
44 | 2018-08-07T16:12:22.695926+03:00 | helsinki | Aku Korhosen tie | Aku Korhonens väg |
45 | 2018-08-07T16:12:22.697242+03:00 | helsinki | Ala-Malmin raitti | Nedre Malms stråk |
46 | 2018-08-07T16:12:22.698028+03:00 | helsinki | Ala-Malmin tori | Nedre Malms torg |
47 | 2018-08-07T16:12:22.699391+03:00 | helsinki | Alakivenkuja | Understensgränden |
48 | 2018-08-07T16:12:22.700384+03:00 | helsinki | Alakiventie | Understensvägen |
49 | 2018-08-07T16:12:22.702217+03:00 | helsinki | Alankotie | Låglandsvägen |
10545 | 2018-11-14T12:12:32.920125+02:00 | helsinki | Alasinraitti | Städtået |
64 | 2018-08-07T16:12:22.756176+03:00 | helsinki | Albertinkatu | Albertsgatan |
88 | 2018-08-07T16:12:22.799176+03:00 | helsinki | Aleksanteri Nevskin katu | Alexander Nevskis gata |
126 | 2018-08-07T16:12:22.863083+03:00 | helsinki | Aleksanterinkatu | Alexandersgatan |
89 | 2018-08-07T16:12:22.800683+03:00 | helsinki | Aleksis Kiven katu | Aleksis Kivis gata |
90 | 2018-08-07T16:12:22.805507+03:00 | helsinki | Alempi Talonpojantie | Nedre Bondevägen |
91 | 2018-08-07T16:12:22.806323+03:00 | helsinki | Alhokuja | Lakaängsgränd |
92 | 2018-08-07T16:12:22.808055+03:00 | helsinki | Alkukuja | Alkugränden |
54 | 2018-08-07T16:12:22.714449+03:00 | helsinki | Alkutie | Alkuvägen |
3512 | 2018-08-07T16:12:35.026489+03:00 | helsinki | Allastie | Bassängvägen |
10542 | 2018-11-14T12:12:32.898848+02:00 | helsinki | Allotriankuja | Allotriagränden |
56 | 2018-08-07T16:12:22.719566+03:00 | helsinki | Alppikatu | Alpgatan |
57 | 2018-08-07T16:12:22.724600+03:00 | helsinki | Alppikylänkatu | Alpbygatan |
58 | 2018-08-07T16:12:22.734034+03:00 | helsinki | Alppikylänkuja | Alpbygränden |
59 | 2018-08-07T16:12:22.738586+03:00 | helsinki | Alvar Aallon katu | Alvar Aaltos gata |
60 | 2018-08-07T16:12:22.740107+03:00 | helsinki | Alvionkuja | Alviogränden |
61 | 2018-08-07T16:12:22.741664+03:00 | helsinki | Alviontie | Alviovägen |
10543 | 2018-11-14T12:12:32.910824+02:00 | helsinki | Amiraali Cronstedtin ranta | Amiral Cronstedts strand |
11238 | 2018-11-14T12:12:38.455828+02:00 | helsinki | Amiraali Cronstedtin tori | Amiral Cronstedts torg |
93 | 2018-08-07T16:12:22.813698+03:00 | helsinki | Amiraalinkatu | Amiralsgatan |
94 | 2018-08-07T16:12:22.814888+03:00 | helsinki | Ampiaiskuja | Getinggränden |
95 | 2018-08-07T16:12:22.815797+03:00 | helsinki | Ampujantie | Skyttevägen |
96 | 2018-08-07T16:12:22.816885+03:00 | helsinki | Ampumaradantie | Skjutbanevägen |
97 | 2018-08-07T16:12:22.817745+03:00 | helsinki | Angervotie | Spireavägen |
11250 | 2018-11-14T12:12:38.630152+02:00 | helsinki | Anianpellonpolku | Anianpeltostigen |
98 | 2018-08-07T16:12:22.819312+03:00 | helsinki | Anianpellontie | Anianpeltovägen |
10550 | 2018-11-14T12:12:32.970818+02:00 | helsinki | Anispolku - Klaukkalanpuiston siirtolapuutarha | Anispolku - Klasasparken koloniträdgård |
99 | 2018-08-07T16:12:22.823344+03:00 | helsinki | Anjalantie | Anjalavägen |
100 | 2018-08-07T16:12:22.824296+03:00 | helsinki | Ankkapurhankuja | Ankapurhagränden |
65 | 2018-08-07T16:12:22.762497+03:00 | helsinki | Ankkurikatu | Ankargatan |
66 | 2018-08-07T16:12:22.763379+03:00 | helsinki | Annalankuja | Annebergsgränd |
10546 | 2018-11-14T12:12:32.925746+02:00 | helsinki | Annanaukio | Anneplatsen |
68 | 2018-08-07T16:12:22.765129+03:00 | helsinki | Annankatu | Annegatan |
69 | 2018-08-07T16:12:22.769269+03:00 | helsinki | Annikinkuja | Annikkigränd |
70 | 2018-08-07T16:12:22.770008+03:00 | helsinki | Ansaritie | Orangerivä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 );