street
4 rows where "modified_at" is on date 2018-11-06 and municipality = "helsinki" sorted by municipality
This data as json, CSV (advanced)
id | modified_at | municipality ▼ | name_fi | name_sv |
---|---|---|---|---|
10523 | 2018-11-06T16:52:59.401591+02:00 | helsinki | Tenderinlenkki | Tenderlänken |
10524 | 2018-11-06T16:52:59.406564+02:00 | helsinki | Höyrykatu | Ånggatan |
10525 | 2018-11-06T16:52:59.425531+02:00 | helsinki | Kaljaasi Fortunan katu | Galeasen Fortunas gata |
10526 | 2018-11-06T16:52:59.441263+02:00 | helsinki | Werner Wirénin tie | Werner Wiréns väg |
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 );