3 rows where "modified_at" is on date 2020-01-30 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2020-01-30 · 3
id modified_at municipality name_fi ▼ name_sv
11623 2020-01-30T12:59:26.680959+02:00 helsinki Eskolankaari Eskosbågen
11622 2020-01-30T12:59:26.659966+02:00 helsinki Kappelinpiha Kapellgården
11624 2020-01-30T13:00:01.425547+02:00 espoo Ylismäenkuja Oppibackagrä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
);