street

5 rows where "modified_at" is on date 2019-02-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: municipality, modified_at (date)

id ▼ modified_at municipality name_fi name_sv
3673 2019-02-21T14:23:13.104723+02:00 helsinki Vattuniemenkuja Hallonnäsgränden
11513 2019-02-21T14:23:14.999866+02:00 helsinki Sissosenpolku Sissonens stig
11514 2019-02-21T14:23:15.001825+02:00 helsinki Muotokuvankatu Porträttgatan
11515 2019-02-21T14:23:34.053370+02:00 espoo Pitkoskorventie Spångkärrsvägen
11516 2019-02-21T14:23:34.292208+02:00 espoo Kaisankuja Kajsasgränden

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
);