3 rows where "modified_at" is on date 2019-06-19 sorted by municipality

View and edit SQL

modified_at (date)

  • 2019-06-19 · 3
id modified_at municipality ▼ name_fi name_sv
11591 2019-06-19T23:59:14.216533+03:00 helsinki Kallioportaankuja Bergtrappsgränden
11592 2019-06-19T23:59:14.220964+03:00 helsinki Stansvikin rantakatu Stansviks strandgata
11593 2019-06-19T23:59:14.222546+03:00 helsinki Mosaiikkikuja Mosaikgränden

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