street

3 rows where "modified_at" is on date 2018-11-06 and municipality = "vantaa" sorted by municipality

✎ View and edit SQL

This data as json, CSV (advanced)

municipality ✖

  • vantaa · 3 ✖

modified_at (date) ✖

  • 2018-11-06 · 3 ✖
id modified_at municipality ▼ name_fi name_sv
10527 2018-11-06T16:53:01.924612+02:00 vantaa Silakuja Selgränden
10528 2018-11-06T16:53:01.997025+02:00 vantaa Seppälänkuja Smedsgränden
10529 2018-11-06T16:53:04.975676+02:00 vantaa Lohestajantie Laxfiskarvä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
);