street
6 rows where "modified_at" is on date 2019-02-06 and municipality = "helsinki" sorted by municipality
This data as json, CSV (advanced)
id | modified_at | municipality ▼ | name_fi | name_sv |
---|---|---|---|---|
11505 | 2019-02-06T11:02:42.778878+02:00 | helsinki | Vaakapolku | Vågstigen |
11506 | 2019-02-06T11:02:42.875014+02:00 | helsinki | Kustinpolku | Gustensstigen |
11507 | 2019-02-06T11:02:42.876029+02:00 | helsinki | Mustekuja | Bläckgränden |
11508 | 2019-02-06T11:02:42.876948+02:00 | helsinki | Postiljooninkatu | Postiljonsgatan |
11509 | 2019-02-06T11:02:42.877927+02:00 | helsinki | Pakettikatu | Paketgatan |
11510 | 2019-02-06T11:02:42.879215+02:00 | helsinki | Bunkkerinkuja | Bunkergränden |
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 );