3 rows where letter = "i"

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
23984 2   i 2018-08-07T16:12:42.598821+03:00 Point 24.9772398 60.2610519 2052 2018-08-07T16:12:29.204282+03:00 helsinki Ollilantie Ollasvägen 00780
71936 9   i 2018-08-07T16:13:03.440831+03:00 Point 24.7861207 60.2923491 6383 2018-08-07T16:13:01.503115+03:00 vantaa Koivurinne Björkbrinken 01680
119749 5   i 2018-11-14T12:13:01.864095+02:00 Point 25.077884 60.2583474 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
);