7 rows where "modified_at" is on date 2019-12-17 sorted by name_fi

View and edit SQL

Suggested facets: municipality

modified_at (date)

  • 2019-12-17 · 7
id modified_at municipality name_fi ▼ name_sv
11620 2019-12-17T13:55:25.026836+02:00 espoo Hannulanniitty Hannulaängen
11617 2019-12-17T13:55:13.004961+02:00 vantaa Juoksuhaudanpuisto Skyttegravsparken
11616 2019-12-17T13:55:12.925730+02:00 vantaa KIRJASTOPOLKU BIBLIOTEKSSTIGEN
11615 2019-12-17T13:55:12.315372+02:00 vantaa Kelokuusenkuja Torrgransgränden
11614 2019-12-17T13:55:10.878331+02:00 vantaa LUMMEKUJA NÄCKROSGRÄNDEN
11619 2019-12-17T13:55:24.827479+02:00 espoo Metallikuja Metallgränden
11618 2019-12-17T13:55:24.823989+02:00 espoo Metallitie Metallvägen

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