2 rows where "modified_at" is on date 2020-03-05 sorted by name_fi

View and edit SQL

modified_at (date)

  • 2020-03-05 · 2
id modified_at municipality name_fi ▼ name_sv
11640 2020-03-05T15:01:42.984456+02:00 espoo Auerinkuja Auergränden
11639 2020-03-05T15:01:38.694687+02:00 espoo Karamalmintie Karamalmsvägen

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