street

5 rows where "modified_at" is on date 2019-11-15 and municipality = "helsinki" sorted by municipality

✎ View and edit SQL

This data as json, CSV (advanced)

municipality ✖

  • helsinki · 5 ✖

modified_at (date) ✖

  • 2019-11-15 · 5 ✖
id modified_at municipality ▼ name_fi name_sv
1034 2019-11-15T09:20:06.840160+02:00 helsinki Kellaritie Källarvägen
1947 2019-11-15T09:20:09.030679+02:00 helsinki Pietiläntie Pehrsvägen
11608 2019-11-15T09:20:17.286970+02:00 helsinki Paviljonkikuja Paviljonggränden
11609 2019-11-15T09:20:17.289320+02:00 helsinki Hospitaalinkulku Hospitalgången
11610 2019-11-15T09:20:17.290511+02:00 helsinki Ilmasillantie Luftbrovä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
);