3 rows where "modified_at" is on date 2019-08-22 sorted by name_fi

View and edit SQL

modified_at (date)

  • 2019-08-22 · 3
id modified_at municipality name_fi ▼ name_sv
11598 2019-08-22T18:27:36.568828+03:00 espoo Alamyllynpolku Nedre kvarnstigen
11600 2019-08-22T18:27:40.626879+03:00 espoo Pottipelto Pottåkern
11599 2019-08-22T18:27:39.060388+03:00 espoo Purohyrränpolku Strandlöparstigen

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