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

View and edit SQL

Suggested facets: municipality, modified_at (date)

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

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