street
4 rows where "modified_at" is on date 2019-12-17 and municipality = "vantaa"
This data as json, CSV (advanced)
id ▼ | modified_at | municipality | name_fi | name_sv |
---|---|---|---|---|
11614 | 2019-12-17T13:55:10.878331+02:00 | vantaa | LUMMEKUJA | NÄCKROSGRÄNDEN |
11615 | 2019-12-17T13:55:12.315372+02:00 | vantaa | Kelokuusenkuja | Torrgransgränden |
11616 | 2019-12-17T13:55:12.925730+02:00 | vantaa | KIRJASTOPOLKU | BIBLIOTEKSSTIGEN |
11617 | 2019-12-17T13:55:13.004961+02:00 | vantaa | Juoksuhaudanpuisto | Skyttegravsparken |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [street] ( [id] INTEGER PRIMARY KEY, [modified_at] TEXT, [municipality] TEXT, [name_fi] TEXT, [name_sv] TEXT );