7 rows where "modified_at" is on date 2018-09-18 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2018-09-18 · 7
id modified_at municipality name_fi ▼ name_sv
10517 2018-09-18T18:26:49.144483+03:00 helsinki Gotlanninkatu Gotlandsgatan
10520 2018-09-18T18:27:00.361443+03:00 vantaa Kalustetie Möbelvägen
10516 2018-09-18T18:26:48.157381+03:00 helsinki Oranssikuja Orangegränden
10522 2018-09-18T18:27:08.896850+03:00 espoo Patruunakatu Patrongatan
10518 2018-09-18T18:26:53.112242+03:00 helsinki Pertunsuora Bertrakan
10521 2018-09-18T18:27:08.893622+03:00 espoo Seunapolku Vältstocksstigen
10519 2018-09-18T18:26:55.503098+03:00 vantaa Silkkitehtaantie Silkesfabriksvä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
);