address
5 rows where letter = "j"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23985 | 2 | j | 2018-08-07T16:12:32.429137+03:00 | Point | 24.976716 | 60.2610607 | 2052 | 2018-08-07T16:12:29.204282+03:00 | helsinki | Ollilantie | Ollasvägen | 00780 | |
| 54235 | 9 | j | 2020-08-24T15:48:20.252250+03:00 | Point | 24.8728095 | 60.3273382 | 4954 | 2018-08-07T16:12:51.851919+03:00 | vantaa | Santakuopantie | Sandgropsvägen | 01730 | |
| 71937 | 9 | j | 2018-08-07T16:13:03.440715+03:00 | Point | 24.7863709 | 60.2927893 | 6383 | 2018-08-07T16:13:01.503115+03:00 | vantaa | Koivurinne | Björkbrinken | 01680 | |
| 76111 | 5 | j | 2020-08-24T15:49:11.647329+03:00 | Point | 24.8727771 | 60.2658665 | 6701 | 2018-08-07T16:13:04.877224+03:00 | vantaa | Kaivokselantie | Gruvstavägen | 01610 | |
| 99790 | 9 | j | 2018-08-07T16:13:24.519839+03:00 | Point | 24.7853376 | 60.2269804 | 8525 | 2018-08-07T16:13:08.493767+03:00 | espoo | Pääskyskuja | Svalgränden | 02620 |
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 );