27 rows where letter = "g"

View and edit SQL

Suggested facets: number, street_id, street_modified_at, street_municipality, street_name_fi, street_name_sv, postal_code, 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
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

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
);