street

6 rows where "modified_at" is on date 2019-03-12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: municipality, modified_at (date)

id ▼ modified_at municipality name_fi name_sv
11517 2019-03-12T16:52:49.038592+02:00 helsinki Melkinlaituri Melkökajen
11518 2019-03-12T16:52:49.298510+02:00 helsinki Madeiranaukio Madeiraplatsen
11519 2019-03-12T16:52:49.545086+02:00 helsinki Sammaltori Mosstorget
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
);