address
3 rows where letter = "i"
This data as json, CSV (advanced)
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
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 );