street
2 rows where "modified_at" is on date 2018-11-14 and municipality = "espoo" sorted by name_fi
This data as json, CSV (advanced)
id | modified_at | municipality | name_fi ▼ | name_sv |
---|---|---|---|---|
11484 | 2018-11-14T12:12:58.820975+02:00 | espoo | Aavasaksanpolku | Aavasaksastigen |
11483 | 2018-11-14T12:12:58.122307+02:00 | espoo | Letkamäki | Raddabacken |
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 );