2 rows where "modified_at" is on date 2019-09-17 sorted by municipality

View and edit SQL

modified_at (date)

  • 2019-09-17 · 2
id modified_at municipality ▼ name_fi name_sv
11601 2019-09-17T13:24:24.655218+03:00 vantaa VIIKATEKUJA LIEGRÄDEN
11602 2019-09-17T13:24:24.657946+03:00 vantaa VEHKALANPOLKU VECKALSTIGEN

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