street

3 rows where "modified_at" is on date 2019-03-12 and municipality = "espoo" sorted by name_fi

✎ View and edit SQL

This data as json, CSV (advanced)

municipality ✖

  • espoo · 3 ✖

modified_at (date) ✖

  • 2019-03-12 · 3 ✖
id modified_at municipality name_fi ▼ name_sv
11520 2019-03-12T16:53:14.407048+02:00 espoo Laidunmaanraitti Betesmarken
11521 2019-03-12T16:53:14.630850+02:00 espoo Lillhemtinkuja Lillhemtgränden
11522 2019-03-12T16:53:14.636677+02:00 espoo Lillhemtinpuisto Lillhemtparken

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