address
126,220 rows sorted by street_municipality
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40269 | 1 | 2018-08-07T16:13:14.354332+03:00 | Point | 24.682219 | 60.132836 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40270 | 10 | 2018-08-07T16:13:14.354586+03:00 | Point | 24.6826533 | 60.1344526 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40271 | 11 | 2018-08-07T16:13:09.652795+03:00 | Point | 24.6826055 | 60.1319393 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40272 | 12 | 2018-08-07T16:13:19.509842+03:00 | Point | 24.68272 | 60.1350003 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02380 | ||
40273 | 13 | 2018-08-07T16:13:27.285798+03:00 | Point | 24.6826576 | 60.1321369 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40274 | 14 | 2018-08-07T16:13:24.581119+03:00 | Point | 24.6832424 | 60.1349387 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40275 | 15 | 2018-08-07T16:13:15.142816+03:00 | Point | 24.6826737 | 60.1323344 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40276 | 16 | 2018-08-07T16:13:24.276524+03:00 | Point | 24.6831902 | 60.1347501 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40277 | 17 | 2018-08-07T16:13:14.354101+03:00 | Point | 24.6826691 | 60.1328101 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40278 | 18 | a | 2018-08-07T16:13:24.970069+03:00 | Point | 24.6827832 | 60.13404 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40279 | 18 | b | 2018-08-07T16:13:20.237321+03:00 | Point | 24.6832684 | 60.134104 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40280 | 19 | 2018-08-07T16:13:09.555960+03:00 | Point | 24.6829361 | 60.1331159 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40281 | 2 | 2018-08-07T16:13:09.615395+03:00 | Point | 24.6823242 | 60.1331234 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40282 | 20 | a | 2018-08-07T16:13:24.286619+03:00 | Point | 24.6837705 | 60.1342847 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40283 | 20 | b | 2018-08-07T16:13:14.279648+03:00 | Point | 24.6840933 | 60.1344022 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40284 | 21 | 2018-08-07T16:13:14.365799+03:00 | Point | 24.6828257 | 60.133367 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40285 | 22 | 2018-08-07T16:13:25.135384+03:00 | Point | 24.6845239 | 60.1345379 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40286 | 23 | a | 2018-08-07T16:13:09.557233+03:00 | Point | 24.6830381 | 60.1337265 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40287 | 23 | b | 2018-08-07T16:13:09.557119+03:00 | Point | 24.6834362 | 60.1335031 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40288 | 24 | 2018-08-07T16:13:19.251508+03:00 | Point | 24.6853315 | 60.1347552 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40289 | 25 | a | 2018-08-07T16:13:27.242391+03:00 | Point | 24.6833964 | 60.1338979 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40290 | 25 | b | 2018-08-07T16:13:25.375827+03:00 | Point | 24.6835963 | 60.1336919 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40291 | 26 | a | 2018-08-07T16:13:09.561112+03:00 | Point | 24.6858164 | 60.134864 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40292 | 26 | b | 2018-08-07T16:13:15.281240+03:00 | Point | 24.6854718 | 60.1351415 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40293 | 27 | 2018-08-07T16:13:14.669347+03:00 | Point | 24.6838626 | 60.1340696 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40294 | 28 | 2018-08-07T16:13:15.281594+03:00 | Point | 24.6861574 | 60.1349546 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40295 | 29 | 2018-08-07T16:13:19.396824+03:00 | Point | 24.6843289 | 60.1342322 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40296 | 3 | a | 2018-08-07T16:13:15.142699+03:00 | Point | 24.6819347 | 60.1324673 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40297 | 3 | b | 2018-08-07T16:13:19.235149+03:00 | Point | 24.682259 | 60.1324232 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40298 | 30 | 2018-08-07T16:13:24.418887+03:00 | Point | 24.6866422 | 60.1350635 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40299 | 31 | 2018-08-07T16:12:37.538377+03:00 | Point | 24.685262 | 60.1345037 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40300 | 32 | 2018-08-07T16:13:19.903560+03:00 | Point | 24.6874148 | 60.1351909 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40301 | 33 | 2018-08-07T16:13:15.281126+03:00 | Point | 24.6857286 | 60.1346305 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40302 | 35 | a | 2018-08-07T16:13:27.288904+03:00 | Point | 24.6862133 | 60.1347483 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40303 | 35 | b | 2018-08-07T16:13:27.255331+03:00 | Point | 24.6863958 | 60.1344795 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40304 | 37 | 2018-08-07T16:13:20.097536+03:00 | Point | 24.6866085 | 60.134821 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40305 | 38 | 2018-08-07T16:13:19.113460+03:00 | Point | 24.6890333 | 60.1352935 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40306 | 39 | 2018-08-07T16:13:19.033942+03:00 | Point | 24.6870755 | 60.1349119 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40307 | 4 | 2018-08-07T16:13:19.906803+03:00 | Point | 24.6823579 | 60.1333569 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40308 | 40 | 2018-08-07T16:13:19.811528+03:00 | Point | 24.6899326 | 60.1353405 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40309 | 41 | 2018-08-07T16:13:09.590009+03:00 | Point | 24.6878126 | 60.1349855 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40310 | 42 | 2018-08-07T16:13:15.254238+03:00 | Point | 24.6905257 | 60.1354226 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40311 | 43 | 2018-08-07T16:13:25.025498+03:00 | Point | 24.6883523 | 60.1350047 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02380 | ||
40312 | 45 | 2018-08-07T16:13:25.386932+03:00 | Point | 24.6889995 | 60.135069 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40313 | 47 | 2018-08-07T16:13:09.561230+03:00 | Point | 24.6894312 | 60.135079 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40314 | 49 | a | 2018-08-07T16:13:15.254123+03:00 | Point | 24.6900964 | 60.1351434 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40315 | 49 | b | 2018-08-07T16:13:19.806002+03:00 | Point | 24.690459 | 60.134857 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40316 | 5 | 2018-08-07T16:13:09.580336+03:00 | Point | 24.6822254 | 60.1321718 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40317 | 51 | 2018-08-07T16:13:15.254005+03:00 | Point | 24.6908153 | 60.1352438 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40318 | 55 | 2018-08-07T16:13:24.708641+03:00 | Point | 24.6940485 | 60.1358706 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02380 | ||
40319 | 6 | a | 2018-08-07T16:13:19.653368+03:00 | Point | 24.6824626 | 60.1336982 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40320 | 6 | b | 2018-08-07T16:13:14.353869+03:00 | Point | 24.6825151 | 60.1338509 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | |
40321 | 7 | 2018-08-07T16:13:15.142420+03:00 | Point | 24.6821389 | 60.1318126 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40322 | 8 | 2018-08-07T16:13:09.555839+03:00 | Point | 24.6826016 | 60.1342101 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40323 | 9 | 2018-08-07T16:13:09.580452+03:00 | Point | 24.6820346 | 60.1314353 | 3593 | 2018-08-07T16:12:35.210124+03:00 | espoo | Hanikka | Hanikka | 02360 | ||
40520 | 1 | 2018-08-07T16:13:19.782173+03:00 | Point | 24.6518601 | 60.1434226 | 3613 | 2018-08-07T16:12:35.246273+03:00 | espoo | Näkki | Näcken | 02320 | ||
40521 | 2 | 2018-08-07T16:13:14.353352+03:00 | Point | 24.6522212 | 60.1433159 | 3613 | 2018-08-07T16:12:35.246273+03:00 | espoo | Näkki | Näcken | 02320 | ||
40522 | 3 | 2018-08-07T16:13:14.356305+03:00 | Point | 24.6515218 | 60.1430807 | 3613 | 2018-08-07T16:12:35.246273+03:00 | espoo | Näkki | Näcken | 02320 | ||
40523 | 5 | 2018-08-07T16:13:09.556310+03:00 | Point | 24.6518286 | 60.1430007 | 3613 | 2018-08-07T16:12:35.246273+03:00 | espoo | Näkki | Näcken | 02320 | ||
40524 | 7 | 2018-08-07T16:12:37.554299+03:00 | Point | 24.6527318 | 60.1426889 | 3613 | 2018-08-07T16:12:35.246273+03:00 | espoo | Näkki | Näcken | 02320 | ||
41562 | 1 | 2018-08-07T16:13:19.191788+03:00 | Point | 24.6667184 | 60.1638892 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41563 | 10 | 2018-08-07T16:13:24.203382+03:00 | Point | 24.6671581 | 60.1649404 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41564 | 11 | 2018-08-07T16:13:14.890507+03:00 | Point | 24.667539 | 60.1646721 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41565 | 12 | 2018-08-07T16:13:14.430913+03:00 | Point | 24.6673192 | 60.1650395 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41566 | 13 | 2020-08-24T15:49:28.256365+03:00 | Point | 24.6678955 | 60.165041 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41567 | 14 | 2018-08-07T16:13:20.211025+03:00 | Point | 24.6674801 | 60.1651566 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41568 | 15 | a | 2020-08-24T15:49:42.571628+03:00 | Point | 24.6681648 | 60.1651314 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | |
41569 | 15 | b | 2018-08-07T16:13:27.324442+03:00 | Point | 24.6684924 | 60.1647912 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | |
41570 | 16 | 2018-08-07T16:12:37.635873+03:00 | Point | 24.6682524 | 60.165374 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41571 | 17 | 2018-08-07T16:13:14.280587+03:00 | Point | 24.6685961 | 60.1652222 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41572 | 19 | 2018-08-07T16:13:24.209451+03:00 | Point | 24.6694469 | 60.1647935 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41573 | 2 | 2018-08-07T16:13:09.630725+03:00 | Point | 24.6664142 | 60.1636999 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41574 | 3 | 2018-08-07T16:13:14.538059+03:00 | Point | 24.6665 | 60.164122 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41575 | 4 | 2018-08-07T16:13:09.633306+03:00 | Point | 24.6661958 | 60.1639237 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41576 | 5 | 2018-08-07T16:13:14.430797+03:00 | Point | 24.6670721 | 60.1645363 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41577 | 6 | 2018-08-07T16:13:09.633193+03:00 | Point | 24.6664605 | 60.1644629 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41578 | 7 | 2018-08-07T16:13:09.634993+03:00 | Point | 24.6680669 | 60.1641169 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41579 | 8 | a | 2018-08-07T16:13:14.859858+03:00 | Point | 24.6666214 | 60.16458 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | |
41580 | 8 | b | 2018-08-07T16:13:09.630484+03:00 | Point | 24.6663299 | 60.1649024 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | |
41581 | 9 | 2018-08-07T16:13:14.890379+03:00 | Point | 24.6677205 | 60.1645379 | 3697 | 2018-08-07T16:12:35.507904+03:00 | espoo | Aitamaa | Gärdet | 02330 | ||
41634 | 1 | 2018-08-07T16:13:24.988918+03:00 | Point | 24.589593 | 60.1916944 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41635 | 10 | 2018-08-07T16:13:09.782502+03:00 | Point | 24.5870291 | 60.1934636 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41636 | 11 | 2018-08-07T16:13:14.451514+03:00 | Point | 24.5885017 | 60.1924719 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41637 | 12 | 2020-08-24T15:49:29.762293+03:00 | Point | 24.586883 | 60.1936157 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41638 | 13 | 2018-08-07T16:13:15.083001+03:00 | Point | 24.5882484 | 60.1925429 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41639 | 14 | 2018-08-07T16:13:15.050324+03:00 | Point | 24.5865939 | 60.1936687 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41640 | 15 | 2018-08-07T16:13:20.083135+03:00 | Point | 24.5877948 | 60.1927839 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41641 | 16 | 2020-08-24T15:49:34.552332+03:00 | Point | 24.586164 | 60.1934519 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41642 | 17 | 2018-08-07T16:13:15.050096+03:00 | Point | 24.5878824 | 60.1929816 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41643 | 18 | 2018-08-07T16:13:19.404058+03:00 | Point | 24.5860158 | 60.1937656 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41644 | 19 | 2018-08-07T16:13:15.258140+03:00 | Point | 24.5876466 | 60.1930975 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41645 | 20 | 2018-08-07T16:13:27.194770+03:00 | Point | 24.5850415 | 60.1938344 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41646 | 21 | 2018-08-07T16:13:09.782388+03:00 | Point | 24.587591 | 60.193223 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41647 | 23 | 2018-08-07T16:13:15.049864+03:00 | Point | 24.5874443 | 60.19342 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41648 | 25 | 2018-08-07T16:13:15.049621+03:00 | Point | 24.5876221 | 60.193618 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41649 | 27 | 2018-08-07T16:13:24.533627+03:00 | Point | 24.5872425 | 60.1936976 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41650 | 29 | 2018-08-07T16:13:19.644007+03:00 | Point | 24.5871515 | 60.1937692 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41651 | 3 | 2018-08-07T16:13:15.078914+03:00 | Point | 24.5894822 | 60.1919005 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41652 | 31 | 2018-08-07T16:13:15.049480+03:00 | Point | 24.5869167 | 60.1938043 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 | ||
41653 | 33 | 2018-08-07T16:13:15.049254+03:00 | Point | 24.5866636 | 60.1938574 | 3712 | 2018-08-07T16:12:35.530806+03:00 | espoo | Asgård | Asgård | 02780 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );