address
55 rows where letter = "f"
This data as json, CSV (advanced)
Suggested facets: number, street_municipality, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1867 | 2 | f | 2018-08-07T16:12:37.363690+03:00 | Point | 24.8664288 | 60.2232363 | 166 | 2018-08-07T16:12:22.949374+03:00 | helsinki | Atomitie | Atomvägen | 00370 | |
| 4233 | 1 | f | 2018-08-07T16:12:26.440447+03:00 | Point | 25.0709748 | 60.2706384 | 398 | 2018-08-07T16:12:23.398453+03:00 | helsinki | Heikinlaaksontie | Henriksdalsvägen | 00760 | |
| 8630 | 1 | f | 2018-08-07T16:12:26.746815+03:00 | Point | 24.8890268 | 60.236774 | 740 | 2018-08-07T16:12:24.099349+03:00 | helsinki | Kantelettarentie | Kanteletarvägen | 00420 | |
| 9151 | 2 | f | 2018-08-07T16:12:47.706408+03:00 | Point | 24.8813953 | 60.2157471 | 780 | 2018-08-07T16:12:24.166620+03:00 | helsinki | Karvaamokuja | Garverigränden | 00380 | |
| 9850 | 11 | f | 2018-08-07T16:12:47.363421+03:00 | Point | 25.0786531 | 60.2551876 | 858 | 2018-08-07T16:12:24.326264+03:00 | helsinki | Kankaretie | Hympelvägen | 00770 | |
| 11821 | 2 | f | 2018-08-07T16:12:48.004705+03:00 | Point | 25.072795 | 60.2603697 | 1002 | 2018-08-07T16:12:24.668152+03:00 | helsinki | Jakomäentie | Jakobackavägen | 00770 | |
| 14670 | 2 | f | 2018-08-07T16:12:27.183658+03:00 | Point | 24.8547268 | 60.1806806 | 1256 | 2018-08-07T16:12:25.237346+03:00 | helsinki | Lehtisaarentie | Lövövägen | 00340 | |
| 15231 | 4 | f | 2018-08-07T16:12:32.606633+03:00 | Point | 24.8474774 | 60.1818662 | 1306 | 2018-08-07T16:12:25.357216+03:00 | helsinki | Liljasaarentie | Liljeholmsvägen | 00340 | |
| 16908 | 5 | f | 2018-08-07T16:12:27.356529+03:00 | Point | 24.9718569 | 60.1978553 | 1466 | 2018-08-07T16:12:25.745477+03:00 | helsinki | Kyläsaarenkatu | Byholmsgatan | 00580 | |
| 16965 | 22 | f | 2018-08-07T16:12:27.414367+03:00 | Point | 24.9306188 | 60.2519257 | 1469 | 2018-08-07T16:12:25.750840+03:00 | helsinki | Kytöniityntie | Kyttängsvägen | 00670 | |
| 16996 | 37 | f | 2018-08-07T16:12:42.316883+03:00 | Point | 24.9307266 | 60.2521861 | 1469 | 2018-08-07T16:12:25.750840+03:00 | helsinki | Kytöniityntie | Kyttängsvägen | 00670 | |
| 17122 | 29 | f | 2018-08-07T16:12:38.518858+03:00 | Point | 24.8584513 | 60.1861417 | 1479 | 2018-08-07T16:12:25.768435+03:00 | helsinki | Kuusiniementie | Granuddsvägen | 00340 | |
| 17432 | 11 | f | 2020-08-24T15:47:54.533052+03:00 | Point | 24.9648061 | 60.2160468 | 1499 | 2018-08-07T16:12:25.809083+03:00 | helsinki | Käpyläntie | Kottbyvägen | 00600 | |
| 18356 | 1 | f | 2018-08-07T16:12:27.438983+03:00 | Point | 25.0551527 | 60.2743886 | 1576 | 2018-08-07T16:12:25.964463+03:00 | helsinki | Laaksotie | Dalvägen | 00760 | |
| 19175 | 1 | f | 2018-08-07T16:12:47.690850+03:00 | Point | 25.0862706 | 60.2399158 | 1662 | 2018-08-07T16:12:28.358513+03:00 | helsinki | Kotikonnuntie | Hemgårdsvägen | 00940 | |
| 19336 | 4 | f | 2018-08-07T16:12:43.287742+03:00 | Point | 24.9014623 | 60.2010977 | 1676 | 2018-08-07T16:12:28.387789+03:00 | helsinki | Koroistentie | Koroisvägen | 00280 | |
| 22494 | 2 | f | 2018-08-07T16:12:43.258709+03:00 | Point | 24.9206889 | 60.1687542 | 1928 | 2018-08-07T16:12:28.923424+03:00 | helsinki | Mechelininkatu | Mechelingatan | 00100 | |
| 23981 | 2 | f | 2018-08-07T16:12:42.598676+03:00 | Point | 24.9774749 | 60.2606929 | 2052 | 2018-08-07T16:12:29.204282+03:00 | helsinki | Ollilantie | Ollasvägen | 00780 | |
| 24584 | 5 | f | 2018-09-18T18:27:10.866658+03:00 | Point | 25.1109336 | 60.2357598 | 2104 | 2018-08-07T16:12:29.328863+03:00 | helsinki | Naulakalliontie | Spikbergsvägen | 00970 | |
| 31342 | 4 | f | 2018-08-07T16:12:47.351613+03:00 | Point | 24.9819321 | 60.2687803 | 2763 | 2018-08-07T16:12:30.806805+03:00 | helsinki | Peltokyläntie | Åkerbyvägen | 00740 | |
| 33974 | 1 | f | 2020-05-25T12:29:24.180951+03:00 | Point | 24.8852185 | 60.2418508 | 2999 | 2018-08-07T16:12:31.282018+03:00 | helsinki | Vanhaistentie | Gamlasvägen | 00420 | |
| 35531 | 5 | f | 2018-08-07T16:12:47.431162+03:00 | Point | 24.8738525 | 60.2446049 | 3118 | 2018-08-07T16:12:31.548292+03:00 | helsinki | Urkupillintie | Orgelpipsvägen | 00420 | |
| 40662 | 27 | f | 2018-08-07T16:12:43.294891+03:00 | Point | 24.8733617 | 60.2080568 | 3619 | 2018-08-07T16:12:35.257786+03:00 | helsinki | Ulvilantie | Ulfsbyvägen | 00350 | |
| 46970 | 6 | f | 2020-08-24T15:48:02.065191+03:00 | Point | 24.8144657 | 60.2678621 | 4368 | 2018-08-07T16:12:49.730164+03:00 | vantaa | Varistontie | Varistovägen | 01660 | |
| 47601 | 354 | f | 2020-08-24T15:48:03.272183+03:00 | Point | 25.1480235 | 60.3392268 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | 01490 | |
| 47607 | 356 | f | 2020-08-24T15:48:03.255707+03:00 | Point | 25.1498896 | 60.339467 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | 01490 | |
| 47615 | 358 | f | 2020-08-24T15:48:03.226678+03:00 | Point | 25.1509798 | 60.3402915 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | 01490 | |
| 47843 | 2 | f | 2020-08-24T15:48:04.066792+03:00 | Point | 25.0629308 | 60.3347976 | 4413 | 2018-08-07T16:12:49.960201+03:00 | vantaa | Valtimotie | Pulsvägen | 01400 | |
| 48610 | 1 | f | 2020-08-24T15:48:05.971455+03:00 | Point | 25.1078129 | 60.3406566 | 4470 | 2018-08-07T16:12:50.175352+03:00 | vantaa | Uranuksenkuja | Uranusgränden | 01480 | |
| 48835 | 7 | f | 2020-08-24T15:48:06.455913+03:00 | Point | 24.8100674 | 60.2661147 | 4484 | 2018-08-07T16:12:50.235887+03:00 | vantaa | Ulkoniitynkuja | Utängsgränden | 01660 | |
| 54232 | 9 | f | 2020-08-24T15:48:20.259950+03:00 | Point | 24.871507 | 60.3271395 | 4954 | 2018-08-07T16:12:51.851919+03:00 | vantaa | Santakuopantie | Sandgropsvägen | 01730 | |
| 55037 | 6 | f | 2020-08-24T15:48:22.077993+03:00 | Point | 25.0310487 | 60.3344589 | 5045 | 2018-08-07T16:12:52.101280+03:00 | vantaa | Runotie | Diktvägen | 01390 | |
| 55645 | 38 | f | 2020-08-24T15:48:23.730046+03:00 | Point | 24.862681 | 60.3341224 | 5086 | 2018-08-07T16:12:52.260975+03:00 | vantaa | Riipiläntie | Ripubyvägen | 01730 | |
| 55669 | 49 | f | 2020-08-24T15:48:23.675717+03:00 | Point | 24.8649413 | 60.3304 | 5086 | 2018-08-07T16:12:52.260975+03:00 | vantaa | Riipiläntie | Ripubyvägen | 01730 | |
| 61219 | 47 | f | 2020-08-24T15:48:36.573132+03:00 | Point | 25.1827042 | 60.2819842 | 5564 | 2018-08-07T16:12:56.119126+03:00 | vantaa | Nybyggetintie | Nybyggesvägen | 01200 | |
| 62684 | 5 | f | 2019-06-19T23:59:32.461909+03:00 | Point | 24.8522393 | 60.2650554 | 5678 | 2018-08-07T16:12:56.559186+03:00 | vantaa | Myyrmäenraitti | Myrbackaleden | 01600 | |
| 63553 | 2 | f | 2020-08-24T15:48:42.378855+03:00 | Point | 24.8472718 | 60.3269433 | 5750 | 2018-08-07T16:12:56.825690+03:00 | vantaa | Miekkatie | Svärdvägen | 01700 | |
| 63955 | 52 | f | 2020-08-24T15:48:43.118595+03:00 | Point | 25.1033916 | 60.3511521 | 5772 | 2018-08-07T16:12:56.922065+03:00 | vantaa | Metsolantie | Skogsbrinksvägen | 01450 | |
| 64532 | 17 | f | 2018-08-07T16:12:58.798771+03:00 | Point | 24.8389817 | 60.2828739 | 5821 | 2018-08-07T16:12:57.112571+03:00 | vantaa | Martinkyläntie | Mårtensbyvägen | 01620 | |
| 67239 | 46 | f | 2018-08-07T16:13:02.840918+03:00 | Point | 25.0896019 | 60.3558023 | 6030 | 2018-08-07T16:13:00.171544+03:00 | vantaa | Leppäkorventie | Alkärrsvägen | 01450 | |
| 68412 | 2 | f | 2020-08-24T15:48:53.516842+03:00 | Point | 24.8651652 | 60.3375534 | 6112 | 2018-08-07T16:13:00.492741+03:00 | vantaa | Lapintie | Lappvägen | 01760 | |
| 69378 | 2 | f | 2020-08-24T15:48:55.728104+03:00 | Point | 25.096639 | 60.260516 | 6206 | 2018-08-07T16:13:00.796640+03:00 | vantaa | Kuussillantie | Sexbrovägen | 01230 | |
| 70811 | 6 | f | 2018-08-07T16:13:03.306465+03:00 | Point | 24.7892116 | 60.3570656 | 6297 | 2018-08-07T16:13:01.194731+03:00 | vantaa | Kuhajoentie | Kuhajokivägen | 01750 | |
| 71934 | 9 | f | 2020-08-24T15:49:01.427369+03:00 | Point | 24.7859451 | 60.291541 | 6383 | 2018-08-07T16:13:01.503115+03:00 | vantaa | Koivurinne | Björkbrinken | 01680 | |
| 75443 | 1 | f | 2020-08-24T15:49:09.448185+03:00 | Point | 24.8112524 | 60.2579758 | 6637 | 2018-08-07T16:13:02.511516+03:00 | vantaa | Karhunkierros | Björnringen | 01640 | |
| 75449 | 2 | f | 2020-08-24T15:49:09.432144+03:00 | Point | 24.8103808 | 60.2587733 | 6637 | 2018-08-07T16:13:02.511516+03:00 | vantaa | Karhunkierros | Björnringen | 01640 | |
| 76108 | 5 | f | 2020-08-24T15:49:11.654902+03:00 | Point | 24.8735899 | 60.2658942 | 6701 | 2018-08-07T16:13:04.877224+03:00 | vantaa | Kaivokselantie | Gruvstavägen | 01610 | |
| 87078 | 26 | f | 2020-08-24T15:49:39.997192+03:00 | Point | 24.7603309 | 60.1572522 | 7561 | 2018-08-07T16:13:07.533091+03:00 | espoo | Iirislahdenranta | Irisviksstranden | 02230 | |
| 88303 | 1 | f | 2019-01-22T18:22:37.895967+02:00 | Point | 24.7878551 | 60.1724766 | 7654 | 2018-08-07T16:13:07.628508+03:00 | espoo | Suvikummuntie | Solhöjdsvägen | 02120 | |
| 102556 | 25 | f | 2020-08-24T15:49:34.165339+03:00 | Point | 24.7139462 | 60.2483148 | 8720 | 2018-08-07T16:13:08.687838+03:00 | espoo | Kulloonmäentie | Kullobackavägen | 02940 | |
| 103554 | 9 | f | 2018-08-07T16:13:20.188817+03:00 | Point | 24.7562812 | 60.2445399 | 8773 | 2018-08-07T16:13:10.926347+03:00 | espoo | Laaksolahdentie | Dalsvikvägen | 02730 | |
| 104766 | 45 | f | 2018-08-07T16:13:19.980243+03:00 | Point | 24.7550011 | 60.2636371 | 8833 | 2018-08-07T16:13:10.991439+03:00 | espoo | Vanhankartanontie | Gammelgårdsvägen | 02920 | |
| 107271 | 13 | f | 2018-08-07T16:13:19.936792+03:00 | Point | 24.5403742 | 60.2670529 | 8977 | 2018-08-07T16:13:11.149756+03:00 | espoo | Koivumäentie | Björkbacksvägen | 02860 | |
| 107854 | 10 | f | 2018-08-07T16:13:19.883654+03:00 | Point | 24.7218806 | 60.3262017 | 9025 | 2018-08-07T16:13:11.204038+03:00 | espoo | Korpilammentie | Korpilampivägen | 02970 | |
| 119746 | 5 | f | 2018-11-14T12:13:01.864647+02:00 | Point | 25.0764231 | 60.2592368 | 10708 | 2018-11-14T12:12:34.071367+02:00 | helsinki | Kankarepolku | Hympelstigen | 00770 |
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 );