address
27 rows where letter = "g"
This data as json, CSV (advanced)
Suggested facets: number, street_id, street_modified_at, street_municipality, street_name_fi, street_name_sv, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4234 | 1 | g | 2018-08-07T16:12:37.831913+03:00 | Point | 25.0709739 | 60.2702345 | 398 | 2018-08-07T16:12:23.398453+03:00 | helsinki | Heikinlaaksontie | Henriksdalsvägen | 00760 | |
| 16909 | 5 | g | 2018-08-07T16:12:38.530859+03:00 | Point | 24.9721274 | 60.1977028 | 1466 | 2018-08-07T16:12:25.745477+03:00 | helsinki | Kyläsaarenkatu | Byholmsgatan | 00580 | |
| 16966 | 22 | g | 2018-08-07T16:12:42.303628+03:00 | Point | 24.9302936 | 60.2519704 | 1469 | 2018-08-07T16:12:25.750840+03:00 | helsinki | Kytöniityntie | Kyttängsvägen | 00670 | |
| 17433 | 11 | g | 2018-08-07T16:12:48.004943+03:00 | Point | 24.9639755 | 60.2167646 | 1499 | 2018-08-07T16:12:25.809083+03:00 | helsinki | Käpyläntie | Kottbyvägen | 00600 | |
| 18357 | 1 | g | 2018-08-07T16:12:42.167499+03:00 | Point | 25.0551159 | 60.2740207 | 1576 | 2018-08-07T16:12:25.964463+03:00 | helsinki | Laaksotie | Dalvägen | 00760 | |
| 19176 | 1 | g | 2018-08-07T16:12:37.383716+03:00 | Point | 25.0862534 | 60.2402479 | 1662 | 2018-08-07T16:12:28.358513+03:00 | helsinki | Kotikonnuntie | Hemgårdsvägen | 00940 | |
| 23982 | 2 | g | 2018-08-07T16:12:43.352504+03:00 | Point | 24.9773483 | 60.2608903 | 2052 | 2018-08-07T16:12:29.204282+03:00 | helsinki | Ollilantie | Ollasvägen | 00780 | |
| 24585 | 5 | g | 2018-08-07T16:12:42.920584+03:00 | Point | 25.1107164 | 60.2355626 | 2104 | 2018-08-07T16:12:29.328863+03:00 | helsinki | Naulakalliontie | Spikbergsvägen | 00970 | |
| 34519 | 1 | g | 2019-04-25T11:36:55.888479+03:00 | Point | 24.9461893 | 60.2604864 | 3040 | 2018-08-07T16:12:31.365868+03:00 | helsinki | Torpparinmäentie | Torparbacksvägen | 00690 | |
| 35532 | 5 | g | 2018-08-07T16:12:33.306590+03:00 | Point | 24.8729871 | 60.2442989 | 3118 | 2018-08-07T16:12:31.548292+03:00 | helsinki | Urkupillintie | Orgelpipsvägen | 00420 | |
| 39733 | 26 | g | 2018-08-07T16:12:37.489284+03:00 | Point | 25.0208933 | 60.2510447 | 3544 | 2018-08-07T16:12:35.112947+03:00 | helsinki | Vilppulantie | Filpusvägen | 00700 | |
| 47608 | 356 | g | 2020-08-24T15:48:03.251149+03:00 | Point | 25.1501981 | 60.3396192 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | 01490 | |
| 47616 | 358 | g | 2020-08-24T15:48:03.221934+03:00 | Point | 25.1506181 | 60.3403906 | 4399 | 2018-08-07T16:12:49.870914+03:00 | vantaa | Vanha Porvoontie | Gamla Borgåvägen | 01490 | |
| 47844 | 2 | g | 2020-08-24T15:48:04.064163+03:00 | Point | 25.0633286 | 60.3345013 | 4413 | 2018-08-07T16:12:49.960201+03:00 | vantaa | Valtimotie | Pulsvägen | 01400 | |
| 48611 | 1 | g | 2018-08-07T16:12:52.716804+03:00 | Point | 25.107705 | 60.340881 | 4470 | 2018-08-07T16:12:50.175352+03:00 | vantaa | Uranuksenkuja | Uranusgränden | 01480 | |
| 54233 | 9 | g | 2020-08-24T15:48:20.257475+03:00 | Point | 24.8732076 | 60.3273655 | 4954 | 2018-08-07T16:12:51.851919+03:00 | vantaa | Santakuopantie | Sandgropsvägen | 01730 | |
| 55695 | 59 | g | 2018-08-07T16:12:53.684465+03:00 | Point | 24.863711 | 60.3345812 | 5086 | 2018-08-07T16:12:52.260975+03:00 | vantaa | Riipiläntie | Ripubyvägen | 01730 | |
| 63554 | 2 | g | 2020-08-24T15:48:42.376181+03:00 | Point | 24.8470176 | 60.3271136 | 5750 | 2018-08-07T16:12:56.825690+03:00 | vantaa | Miekkatie | Svärdvägen | 01700 | |
| 67240 | 46 | g | 2020-08-24T15:48:50.440332+03:00 | Point | 25.0890942 | 60.355659 | 6030 | 2018-08-07T16:13:00.171544+03:00 | vantaa | Leppäkorventie | Alkärrsvägen | 01450 | |
| 69379 | 2 | g | 2020-08-24T15:48:55.725540+03:00 | Point | 25.0954452 | 60.2599604 | 6206 | 2018-08-07T16:13:00.796640+03:00 | vantaa | Kuussillantie | Sexbrovägen | 01230 | |
| 71935 | 9 | g | 2020-08-24T15:49:01.424236+03:00 | Point | 24.7859619 | 60.2917385 | 6383 | 2018-08-07T16:13:01.503115+03:00 | vantaa | Koivurinne | Björkbrinken | 01680 | |
| 75450 | 2 | g | 2020-08-24T15:49:09.429627+03:00 | Point | 24.8108896 | 60.2582535 | 6637 | 2018-08-07T16:13:02.511516+03:00 | vantaa | Karhunkierros | Björnringen | 01640 | |
| 76109 | 5 | g | 2020-08-24T15:49:11.652423+03:00 | Point | 24.8727939 | 60.2661717 | 6701 | 2018-08-07T16:13:04.877224+03:00 | vantaa | Kaivokselantie | Gruvstavägen | 01610 | |
| 93476 | 24 | g | 2018-08-07T16:13:25.383932+03:00 | Point | 24.6017498 | 60.1910763 | 8066 | 2018-08-07T16:13:08.047033+03:00 | espoo | Hansatie | Hansavägen | 02780 | |
| 97094 | 4 | g | 2018-08-07T16:13:25.231540+03:00 | Point | 24.8084584 | 60.1796884 | 8312 | 2018-08-07T16:13:08.295373+03:00 | espoo | Menninkäisentie | Rådarvägen | 02100 | |
| 102557 | 25 | g | 2020-08-24T15:49:34.415320+03:00 | Point | 24.7142008 | 60.248109 | 8720 | 2018-08-07T16:13:08.687838+03:00 | espoo | Kulloonmäentie | Kullobackavägen | 02940 | |
| 119747 | 5 | g | 2018-11-14T12:13:01.864363+02:00 | Point | 25.0770543 | 60.2588415 | 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 );