administrative_division
7 rows where parent = 332
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 365 | 101 | ocd-division/country:fi/kunta:helsinki/osa-alue:vilhonvuori | 2020-12-07T13:38:25.278657+02:00 | sub_district | 332 | helsinki | Vilhonvuori | Vilhemsberg | ||||
| 366 | 102 | ocd-division/country:fi/kunta:helsinki/osa-alue:kalasatama | 2020-12-07T13:38:25.302141+02:00 | sub_district | 332 | helsinki | Kalasatama | Fiskehamnen | ||||
| 367 | 103 | ocd-division/country:fi/kunta:helsinki/osa-alue:sompasaari | 2020-12-07T13:38:25.321184+02:00 | sub_district | 332 | helsinki | Sompasaari | Sumparn | ||||
| 368 | 104 | ocd-division/country:fi/kunta:helsinki/osa-alue:hanasaari | 2020-12-07T13:38:25.341607+02:00 | sub_district | 332 | helsinki | Hanasaari | Hanaholmen | ||||
| 369 | 111 | ocd-division/country:fi/kunta:helsinki/osa-alue:siltasaari | 2020-12-07T13:38:25.362679+02:00 | sub_district | 332 | helsinki | Siltasaari | Broholmen | ||||
| 370 | 112 | ocd-division/country:fi/kunta:helsinki/osa-alue:linjat | 2020-12-07T13:38:25.376023+02:00 | sub_district | 332 | helsinki | Linjat | Linjerna | ||||
| 371 | 113 | ocd-division/country:fi/kunta:helsinki/osa-alue:torkkelinmäki | 2020-12-07T13:38:25.391475+02:00 | sub_district | 332 | helsinki | Torkkelinmäki | Torkelsbacken |
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 );