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

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2019-02-21 · 5
id modified_at municipality ▼ name_fi name_sv
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
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

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