10 rows where "modified_at" is on date 2019-05-13 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2019-05-13 · 10
id modified_at municipality name_fi ▼ name_sv
11582 2019-05-13T11:17:01.415067+03:00 helsinki Kappelinkulku Kapellgången
11581 2019-05-13T11:17:01.410075+03:00 helsinki Kollikatu Kolligatan
11587 2019-05-13T11:17:09.094540+03:00 vantaa Korsonaukio Korsoplatsen
11579 2019-05-13T11:17:01.405714+03:00 helsinki Laskumäki Växlingsvallen
11583 2019-05-13T11:17:01.417072+03:00 helsinki Leimasinkatu Stämpelgatan
11580 2019-05-13T11:17:01.407935+03:00 helsinki Retkeilijänsilta Vandrarbron
11586 2019-05-13T11:17:04.201370+03:00 vantaa Taoskuja Smidesgränden
11585 2019-05-13T11:17:04.197191+03:00 vantaa Taostie Smidesvägen
11584 2019-05-13T11:17:03.871906+03:00 vantaa Topaasiaukio Topasplatsen
11578 2019-05-13T11:17:01.402590+03:00 helsinki Tulistimenkatu Överhettargatan

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