10 rows where "modified_at" is on date 2019-04-25 and municipality = "espoo" sorted by municipality

View and edit SQL

municipality

  • espoo · 10

modified_at (date)

  • 2019-04-25 · 10
id modified_at municipality ▼ name_fi name_sv
11568 2019-04-25T11:36:48.130284+03:00 espoo Vanha Laaksotie Gamla Dalvägen
11569 2019-04-25T11:36:48.502239+03:00 espoo Kiannonkatu Kiantogatan
11570 2019-04-25T11:36:52.860839+03:00 espoo Välikallionkuja Mellanbergsgränden
11571 2019-04-25T11:36:53.041416+03:00 espoo Kalajärven puistotie Kalajärviallén
11572 2019-04-25T11:36:53.176971+03:00 espoo Postipuunpolku Postträdsstigen
11573 2019-04-25T11:36:53.261808+03:00 espoo Välikallio Mellanberget
11574 2019-04-25T11:36:53.286497+03:00 espoo Peijinkuja Pejgränden
11575 2019-04-25T11:36:53.305380+03:00 espoo Kammitie Gammevägen
11576 2019-04-25T11:36:54.569499+03:00 espoo Kirstinkuja Kirstigränden
11577 2019-04-25T11:36:55.532251+03:00 espoo Hagalundintie Hagalundvä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
);