6 rows where "modified_at" is on date 2019-03-12 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2019-03-12 · 6
id modified_at municipality name_fi ▼ name_sv
11520 2019-03-12T16:53:14.407048+02:00 espoo Laidunmaanraitti Betesmarken
11521 2019-03-12T16:53:14.630850+02:00 espoo Lillhemtinkuja Lillhemtgränden
11522 2019-03-12T16:53:14.636677+02:00 espoo Lillhemtinpuisto Lillhemtparken
11518 2019-03-12T16:52:49.298510+02:00 helsinki Madeiranaukio Madeiraplatsen
11517 2019-03-12T16:52:49.038592+02:00 helsinki Melkinlaituri Melkökajen
11519 2019-03-12T16:52:49.545086+02:00 helsinki Sammaltori Mosstorget

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