2 rows where "modified_at" is on date 2018-11-14 and municipality = "espoo" sorted by name_fi

View and edit SQL

municipality

  • espoo · 2

modified_at (date)

  • 2018-11-14 · 2
id modified_at municipality name_fi ▼ name_sv
11484 2018-11-14T12:12:58.820975+02:00 espoo Aavasaksanpolku Aavasaksastigen
11483 2018-11-14T12:12:58.122307+02:00 espoo Letkamäki Raddabacken

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