8 rows where "modified_at" is on date 2019-02-06

View and edit SQL

Suggested facets: municipality, modified_at (date)

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
11511 2019-02-06T11:02:57.750605+02:00 espoo Kala-Maijan polku Fiskar-Majas gång
11512 2019-02-06T11:02:59.434819+02:00 espoo Kala-Matin raitti Fiskar-Mattes stråk

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [street] (
   [id] INTEGER PRIMARY KEY,
   [modified_at] TEXT,
   [municipality] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT
);