administrative_division
8 rows where municipality = "kauniainen" sorted by origin_id
This data as json, CSV (advanced)
Suggested facets: modified_at (date)
id | origin_id ▼ | ocd_id | service_point_id | start | end | modified_at | type | parent | municipality | name_fi | name_sv | name |
---|---|---|---|---|---|---|---|---|---|---|---|---|
5433 | 235-001 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:001 | 2020-10-02T09:50:47.246885+03:00 | neighborhood | 84 | kauniainen | 1 | 1 | ||||
5434 | 235-002 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:002 | 2020-10-02T09:50:47.253766+03:00 | neighborhood | 84 | kauniainen | 2 | 2 | ||||
5435 | 235-003 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:003 | 2020-10-02T09:50:47.260423+03:00 | neighborhood | 84 | kauniainen | 3 | 3 | ||||
5436 | 235-004 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:004 | 2020-10-02T09:50:47.269769+03:00 | neighborhood | 84 | kauniainen | 4 | 4 | ||||
5437 | 235-005 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:005 | 2020-10-02T09:50:47.279288+03:00 | neighborhood | 84 | kauniainen | 5 | 5 | ||||
5438 | 235-006 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:006 | 2020-10-02T09:50:47.292873+03:00 | neighborhood | 84 | kauniainen | 6 | 6 | ||||
5439 | 235-007 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:007 | 2020-10-02T09:50:47.300202+03:00 | neighborhood | 84 | kauniainen | 7 | 7 | ||||
5440 | 235-008 | ocd-division/country:fi/kunta:kauniainen/kaupunginosa:008 | 2020-10-02T09:50:47.306652+03:00 | neighborhood | 84 | kauniainen | 8 | 8 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [administrative_division] ( [id] INTEGER PRIMARY KEY, [origin_id] TEXT, [ocd_id] TEXT, [service_point_id] TEXT, [start] TEXT, [end] TEXT, [modified_at] TEXT, [type] TEXT, [parent] INTEGER, [municipality] TEXT, [name_fi] TEXT, [name_sv] TEXT, [name] TEXT );