street

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: municipality

modified_at (date) ✖

  • 2019-02-21 · 5 ✖
id modified_at municipality name_fi ▼ name_sv
11516 2019-02-21T14:23:34.292208+02:00 espoo Kaisankuja Kajsasgränden
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
11513 2019-02-21T14:23:14.999866+02:00 helsinki Sissosenpolku Sissonens stig
3673 2019-02-21T14:23:13.104723+02:00 helsinki Vattuniemenkuja Hallonnäsgrä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
);