3 rows where "modified_at" is on date 2019-08-05 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2019-08-05 · 3
id modified_at municipality name_fi ▼ name_sv
11594 2019-08-05T13:39:37.329803+03:00 vantaa Forsbackantaival Forsbackastråten
11595 2019-08-05T13:39:39.928775+03:00 espoo Kirstinharjuntori Kirstiåstorget
11596 2019-08-05T13:39:47.076613+03:00 espoo Suinonpolku Svinöstigen

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