9,324 rows where letter = "b"

View and edit SQL

Suggested facets: modified_at (date), street_modified_at (date)

id ▼ number number_end letter modified_at location_type location_coordinates_0 location_coordinates_1 street_id street_modified_at street_municipality street_name_fi street_name_sv postal_code
37 11   b 2018-08-07T16:12:37.282041+03:00 Point 24.9843234 60.2554433 6 2018-08-07T16:12:22.625591+03:00 helsinki Ahomäentie Svedjebackavägen 00780
42 2   b 2018-08-07T16:12:26.142766+03:00 Point 24.9864727 60.2553628 6 2018-08-07T16:12:22.625591+03:00 helsinki Ahomäentie Svedjebackavägen 00780
57 1   b 2018-08-07T16:12:26.143992+03:00 Point 25.1074058 60.216717 8 2018-08-07T16:12:22.628900+03:00 helsinki Ahvenkoskenpolku Abborforsstigen 00950
66 3   b 2018-08-07T16:12:37.295587+03:00 Point 25.1068291 60.216879 8 2018-08-07T16:12:22.628900+03:00 helsinki Ahvenkoskenpolku Abborforsstigen 00950
69 5   b 2018-08-07T16:12:26.144371+03:00 Point 25.1063786 60.217041 8 2018-08-07T16:12:22.628900+03:00 helsinki Ahvenkoskenpolku Abborforsstigen 00950
107 7   b 2018-08-07T16:12:26.147161+03:00 Point 24.9746649 60.2270708 9 2018-08-07T16:12:22.631252+03:00 helsinki Aidasmäentie Gärdobackavägen 00650
161 17   b 2018-08-07T16:12:37.458480+03:00 Point 25.0220537 60.2848455 17 2018-08-07T16:12:22.648826+03:00 helsinki Aamuruskontie Morgonrådevägen 00750
168 22   b 2018-08-07T16:12:26.152665+03:00 Point 25.0200291 60.2848997 17 2018-08-07T16:12:22.648826+03:00 helsinki Aamuruskontie Morgonrådevägen 00750
172 25   b 2018-08-07T16:12:26.152906+03:00 Point 25.0196679 60.2854023 17 2018-08-07T16:12:22.648826+03:00 helsinki Aamuruskontie Morgonrådevägen 00750
175 27   b 2018-08-07T16:12:26.153137+03:00 Point 25.0195595 60.2856267 17 2018-08-07T16:12:22.648826+03:00 helsinki Aamuruskontie Morgonrådevägen 00750
178 29   b 2018-08-07T16:12:37.326462+03:00 Point 25.018981 60.2854742 17 2018-08-07T16:12:22.648826+03:00 helsinki Aamuruskontie Morgonrådevägen 00750
204 5   b 2018-08-07T16:12:26.155217+03:00 Point 25.0215712 60.2659616 19 2018-08-07T16:12:22.652174+03:00 helsinki Aapontie Aapovägen 00730
264 15   b 2018-08-07T16:12:37.342130+03:00 Point 24.9283522 60.1651594 26 2018-08-07T16:12:22.663577+03:00 helsinki Abrahaminkatu Abrahamsgatan 00180
303 3   b 2018-08-07T16:12:37.885390+03:00 Point 25.1278918 60.2103892 31 2018-08-07T16:12:22.672512+03:00 helsinki Airoparinkuja Årparsgränden 00980
312 12   b 2018-08-07T16:12:26.162506+03:00 Point 25.1303995 60.2105752 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
317 14   b 2018-08-07T16:12:47.162021+03:00 Point 25.1293003 60.2108096 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
319 16   b 2018-08-07T16:12:37.399191+03:00 Point 25.1288123 60.2105588 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
325 2   b 2018-08-07T16:12:26.163425+03:00 Point 25.1345125 60.2107775 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
329 3   b 2018-08-07T16:12:26.163555+03:00 Point 25.1322962 60.2113003 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
334 6   b 2018-08-07T16:12:47.162145+03:00 Point 25.1326732 60.2108512 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
337 8   b 2018-08-07T16:12:37.400733+03:00 Point 25.1304357 60.2106111 32 2018-08-07T16:12:22.673836+03:00 helsinki Airoparintie Årparsvägen 00980
360 5   b 2018-08-07T16:12:43.278499+03:00 Point 24.8457013 60.2339484 34 2018-08-07T16:12:22.678240+03:00 helsinki Aittatie Bodvägen 00390
362 6   b 2018-08-07T16:12:26.164581+03:00 Point 24.8450874 60.2340105 34 2018-08-07T16:12:22.678240+03:00 helsinki Aittatie Bodvägen 00390
389 2   b 2018-08-07T16:12:37.414628+03:00 Point 25.0542229 60.2148287 38 2018-08-07T16:12:22.682660+03:00 helsinki Ajopolku Skallgången 00800
392 4   b 2018-08-07T16:12:37.414803+03:00 Point 25.0538087 60.2152686 38 2018-08-07T16:12:22.682660+03:00 helsinki Ajopolku Skallgången 00800
395 6   b 2018-08-07T16:12:47.496579+03:00 Point 25.0532314 60.2151791 38 2018-08-07T16:12:22.682660+03:00 helsinki Ajopolku Skallgången 00800
411 2   b 2018-08-07T16:12:37.415709+03:00 Point 25.0583415 60.2587613 40 2018-08-07T16:12:22.689326+03:00 helsinki Akkutie Ackumulatorvägen 00770
467 14   b 2018-08-07T16:12:26.171931+03:00 Point 25.035831 60.2709128 49 2018-08-07T16:12:22.702217+03:00 helsinki Alankotie Låglandsvägen 00730
477 22   b 2018-08-07T16:12:37.256331+03:00 Point 25.0385243 60.2717827 49 2018-08-07T16:12:22.702217+03:00 helsinki Alankotie Låglandsvägen 00750
489 33   b 2018-08-07T16:12:26.187595+03:00 Point 25.0416316 60.2712253 49 2018-08-07T16:12:22.702217+03:00 helsinki Alankotie Låglandsvägen 00750
505 8   b 2018-08-07T16:12:47.163800+03:00 Point 25.0352156 60.2699527 49 2018-08-07T16:12:22.702217+03:00 helsinki Alankotie Låglandsvägen 00730
509 1   b 2018-08-07T16:12:37.444199+03:00 Point 24.9588178 60.1867673 50 2018-08-07T16:12:22.706107+03:00 helsinki Aadolfinkatu Adolfsgatan 00500
519 5   b 2018-08-07T16:12:26.173504+03:00 Point 24.9570692 60.1870899 50 2018-08-07T16:12:22.706107+03:00 helsinki Aadolfinkatu Adolfsgatan 00500
547 15   b 2018-08-07T16:12:37.261278+03:00 Point 24.9439685 60.2387742 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
564 3   b 2018-08-07T16:12:26.212430+03:00 Point 24.9467299 60.2390715 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
588 51   b 2018-08-07T16:12:37.269977+03:00 Point 24.9330314 60.2377729 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
595 56   b 2018-08-07T16:12:26.190983+03:00 Point 24.9273485 60.2363877 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
620 78   b 2018-08-07T16:12:26.177695+03:00 Point 24.9202918 60.2359887 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
628 85   b 2018-08-07T16:12:26.178278+03:00 Point 24.9213377 60.2364291 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
634 88   b 2018-08-07T16:12:37.460419+03:00 Point 24.9166111 60.23543 54 2018-08-07T16:12:22.714449+03:00 helsinki Alkutie Alkuvägen 00660
687 31   b 2018-08-07T16:12:37.474272+03:00 Point 25.0673514 60.2571773 57 2018-08-07T16:12:22.724600+03:00 helsinki Alppikylänkatu Alpbygatan 00770
690 33   b 2018-08-07T16:12:26.182327+03:00 Point 25.0671703 60.2569441 57 2018-08-07T16:12:22.724600+03:00 helsinki Alppikylänkatu Alpbygatan 00770
733 8   b 2018-08-07T16:12:26.185627+03:00 Point 25.0414085 60.2805776 61 2018-08-07T16:12:22.741664+03:00 helsinki Alviontie Alviovägen 00750
756 27   b 2018-08-07T16:12:37.269501+03:00 Point 24.933667 60.1643993 64 2018-08-07T16:12:22.756176+03:00 helsinki Albertinkatu Albertsgatan 00180
761 30   b 2018-08-07T16:12:26.205238+03:00 Point 24.9345341 60.1630893 64 2018-08-07T16:12:22.756176+03:00 helsinki Albertinkatu Albertsgatan 00120
825 1   b 2018-08-07T16:12:37.284680+03:00 Point 24.8875523 60.2087965 70 2018-08-07T16:12:22.770008+03:00 helsinki Ansaritie Orangerivägen 00350
839 2   b 2018-08-07T16:12:26.196817+03:00 Point 24.980176 60.1849412 71 2018-08-07T16:12:22.771298+03:00 helsinki Antareksenkatu Antaresgatan 00540
866 11   b 2018-08-07T16:12:37.299225+03:00 Point 24.925787 60.1765748 76 2018-08-07T16:12:22.777557+03:00 helsinki Apollonkatu Apollogatan 00100
896 2   b 2018-08-07T16:12:37.362498+03:00 Point 25.036364 60.2790174 77 2018-08-07T16:12:22.779240+03:00 helsinki Arttolantie Arttolavägen 00750
902 24   b 2018-08-07T16:12:26.264852+03:00 Point 25.031395 60.2803201 77 2018-08-07T16:12:22.779240+03:00 helsinki Arttolantie Arttolavägen 00750
906 3   b 2018-08-07T16:12:37.299722+03:00 Point 25.0366356 60.2794392 77 2018-08-07T16:12:22.779240+03:00 helsinki Arttolantie Arttolavägen 00750
911 5   b 2018-08-07T16:12:26.199563+03:00 Point 25.036871 60.279834 77 2018-08-07T16:12:22.779240+03:00 helsinki Arttolantie Arttolavägen 00750
921 3   b 2018-08-07T16:12:37.300544+03:00 Point 24.8977296 60.218588 78 2018-08-07T16:12:22.780950+03:00 helsinki Artturi Kanniston tie Artturi Kannistos väg 00320
1017 10   b 2018-08-07T16:12:37.288909+03:00 Point 24.9591574 60.1890831 89 2018-08-07T16:12:22.800683+03:00 helsinki Aleksis Kiven katu Aleksis Kivis gata 00500
1019 11   b 2018-08-07T16:12:26.248166+03:00 Point 24.9514956 60.1901306 89 2018-08-07T16:12:22.800683+03:00 helsinki Aleksis Kiven katu Aleksis Kivis gata 00510
1028 19   b 2018-08-07T16:12:47.886015+03:00 Point 24.9469145 60.191888 89 2018-08-07T16:12:22.800683+03:00 helsinki Aleksis Kiven katu Aleksis Kivis gata 00510
1085 3   b 2018-08-07T16:12:26.209089+03:00 Point 24.9870837 60.2630188 91 2018-08-07T16:12:22.806323+03:00 helsinki Alhokuja Lakaängsgränd 00780
1089 6   b 2018-08-07T16:12:37.343295+03:00 Point 24.9852954 60.2627763 91 2018-08-07T16:12:22.806323+03:00 helsinki Alhokuja Lakaängsgränd 00780
1166 2   b 2020-01-30T13:00:10.046616+02:00 Point 25.1501121 60.2064795 102 2018-08-07T16:12:22.827758+03:00 helsinki Bertha Pauligin katu Bertha Pauligs gata 00990
1285 1   b 2018-08-07T16:12:47.536397+03:00 Point 24.9446936 60.1834054 111 2018-08-07T16:12:22.842376+03:00 helsinki Castréninkatu Castrénsgatan 00530
1311 10   b 2018-08-07T16:12:37.319562+03:00 Point 25.0362796 60.2680765 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1313 11   b 2018-08-07T16:12:26.255847+03:00 Point 25.0351777 60.2683102 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1316 13   b 2018-08-07T16:12:26.255964+03:00 Point 25.0347981 60.2681128 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1322 2   b 2018-08-07T16:12:37.320315+03:00 Point 25.0389895 60.2679411 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1327 6   b 2018-08-07T16:12:26.256689+03:00 Point 25.0380683 60.2681119 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1331 9   b 2018-08-07T16:12:37.418501+03:00 Point 25.0360992 60.2683279 112 2018-08-07T16:12:22.845024+03:00 helsinki Aurinkomäentie Solbackavägen 00730
1386 10   b 2018-08-07T16:12:26.226312+03:00 Point 24.8834725 60.2505554 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1388 11   b 2018-08-07T16:12:47.514901+03:00 Point 24.8842308 60.2506009 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1391 13   b 2018-08-07T16:12:37.432813+03:00 Point 24.8844103 60.2509063 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1394 16   b 2018-08-07T16:12:37.271692+03:00 Point 24.8824942 60.2514431 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1399 2   b 2018-08-07T16:12:26.242221+03:00 Point 24.8824832 60.2494954 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1403 23   b 2018-08-07T16:12:47.831786+03:00 Point 24.8820057 60.2517119 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1407 4   b 2018-08-07T16:12:37.272819+03:00 Point 24.8821748 60.2498721 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1410 6   b 2018-08-07T16:12:37.273219+03:00 Point 24.8828601 60.250142 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1413 8   b 2018-08-07T16:12:26.242984+03:00 Point 24.8825884 60.2503751 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1415 9   b 2018-08-07T16:12:26.243098+03:00 Point 24.8845209 60.2502781 117 2018-08-07T16:12:22.851632+03:00 helsinki Arhipanpolku Arhippastigen 00420
1469 36   b 2018-08-07T16:12:26.231975+03:00 Point 24.948537 60.16875 126 2018-08-07T16:12:22.863083+03:00 helsinki Aleksanterinkatu Alexandersgatan 00100
1509 6   b 2018-08-07T16:12:47.515253+03:00 Point 24.9775654 60.2076127 129 2018-08-07T16:12:22.872723+03:00 helsinki Arabiankatu Arabiagatan 00560
1541 1   b 2018-08-07T16:12:37.259044+03:00 Point 24.9541034 60.258811 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1546 13   b 2018-08-07T16:12:37.258312+03:00 Point 24.9569558 60.259898 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1553 19   b 2018-08-07T16:12:37.258926+03:00 Point 24.9579305 60.2604997 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1557 21   b 2019-03-12T16:53:17.364783+02:00 Point 24.9582554 60.2606882 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1560 23   b 2018-08-07T16:12:37.259274+03:00 Point 24.9587612 60.2606166 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1563 25   b 2018-08-07T16:12:26.239778+03:00 Point 24.9590859 60.2609757 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1574 7   b 2018-08-07T16:12:26.240564+03:00 Point 24.9547711 60.2592869 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1576 8   b 2018-08-07T16:12:26.240692+03:00 Point 24.9572074 60.2609213 135 2018-08-07T16:12:22.882867+03:00 helsinki Asessorintie Assessorsvägen 00690
1593 15   b 2018-08-07T16:12:38.434494+03:00 Point 25.0888479 60.2183732 137 2018-08-07T16:12:22.892811+03:00 helsinki Arhotie Sandarvsvägen 00900
1598 18   b 2018-08-07T16:12:37.274328+03:00 Point 25.0878917 60.2183828 137 2018-08-07T16:12:22.892811+03:00 helsinki Arhotie Sandarvsvägen 00900
1611 9   b 2018-08-07T16:12:26.244653+03:00 Point 25.0895852 60.2175201 137 2018-08-07T16:12:22.892811+03:00 helsinki Arhotie Sandarvsvägen 00900
1650 4   b 2018-08-07T16:12:26.246349+03:00 Point 25.0420721 60.2766014 141 2018-08-07T16:12:22.899814+03:00 helsinki Aurapolku Plogstigen 00750
1668 10   b 2018-08-07T16:12:26.247502+03:00 Point 25.1501465 60.2021623 143 2018-08-07T16:12:22.903235+03:00 helsinki Aurinkolahden puistotie Solviksallén 00990
1686 13   b 2019-03-12T16:53:17.365694+02:00 Point 25.0124331 60.1798441 147 2018-08-07T16:12:22.914322+03:00 helsinki Armas Lindgrenin tie Armas Lindgrens väg 00570
1723 3   b 2018-08-07T16:12:37.319131+03:00 Point 25.0384847 60.2688388 150 2018-08-07T16:12:22.921304+03:00 helsinki Aurinkomäenkuja Solbackagränden 00730
1726 5   b 2018-08-07T16:12:37.319251+03:00 Point 25.0383767 60.269153 150 2018-08-07T16:12:22.921304+03:00 helsinki Aurinkomäenkuja Solbackagränden 00730
1863 2   b 2018-08-07T16:12:37.363438+03:00 Point 24.8645526 60.2231806 166 2018-08-07T16:12:22.949374+03:00 helsinki Atomitie Atomvägen 00370
1873 1   b 2018-08-07T16:12:26.266989+03:00 Point 25.0333757 60.2551977 167 2018-08-07T16:12:22.950858+03:00 helsinki Auertie Solröksvägen 00700
1878 2   b 2018-08-07T16:12:37.364398+03:00 Point 25.03408 60.2552245 167 2018-08-07T16:12:22.950858+03:00 helsinki Auertie Solröksvägen 00700
1883 6   b 2018-08-07T16:12:26.267487+03:00 Point 25.0338263 60.2543898 167 2018-08-07T16:12:22.950858+03:00 helsinki Auertie Solröksvägen 00700
1967 11   b 2018-08-07T16:12:43.314837+03:00 Point 24.8444656 60.2242894 175 2018-08-07T16:12:22.959826+03:00 helsinki Eljaksentie Eliasvägen 00370
1970 12   b 2018-08-07T16:12:26.269468+03:00 Point 24.8451926 60.2231863 175 2018-08-07T16:12:22.959826+03:00 helsinki Eljaksentie Eliasvägen 00370

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [address] (
   [id] INTEGER PRIMARY KEY,
   [number] TEXT,
   [number_end] TEXT,
   [letter] TEXT,
   [modified_at] TEXT,
   [location_type] TEXT,
   [location_coordinates_0] FLOAT,
   [location_coordinates_1] FLOAT,
   [street_id] INTEGER,
   [street_modified_at] TEXT,
   [street_municipality] TEXT,
   [street_name_fi] TEXT,
   [street_name_sv] TEXT,
   [postal_code] TEXT
);