department
6 rows where level = 0 and municipality = "helsinki"
This data as json, CSV (advanced)
Suggested facets: oid
| id ▼ | parent | business_id | name_fi | abbr | street_address | address_city | address_postal_full | www | phone | address_zip | oid | organization_type | level | municipality | www_sv | street_address_sv | street_address_en | address_postal_full_en | address_city_fi | name_en | www_en | address_postal_full_sv | abbr_fi | address_postal_full_fi | abbr_sv | abbr_en | address_city_en | name_sv | street_address_fi | address_city_sv | www_fi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1047cf7a-8cf6-484f-a8ef-9ffe696cb648 | 0201256-6 | Viestintä | +358 9 310 1691 | #10 | MUNICIPALITY | 0 | helsinki | Viest | |||||||||||||||||||||||
| 30c80014-44d6-4b1f-aaac-914651a54ca3 | 0201256-6 | Kanslian ICT | +358 9 310 1691 | #10 | MUNICIPALITY | 0 | helsinki | KICT | |||||||||||||||||||||||
| 39fe670c-b3c7-4749-a619-7dc71ed3ab28 | 0201256-6 | Osallisuus ja neuvonta | +358 9 310 1691 | #10 | MUNICIPALITY | 0 | helsinki | Osne | |||||||||||||||||||||||
| 83e74666-0836-4c1d-948a-4b34a8b90301 | 0201256-6 | Helsingin kaupunki | +358 9 310 1691 | 00130 | 91 | MUNICIPALITY | 0 | helsinki | https://www.hel.fi/helsinki/fi | Norra esplanaden 11-13 | Pohjoisesplanadi 11-13 | P.O.Box 1, 00099 Helsingin kaupunki | Helsinki | City of Helsinki | https://www.hel.fi/helsinki/fi | PB 1, 00099 Helsingfors stad | PL 1, 00099 Helsingin kaupunki | Helsinki | Helsingfors stad | Pohjoisesplanadi 11-13 | Helsingfors | https://www.hel.fi/helsinki/fi | |||||||||
| db836105-eb22-4684-9f59-e31e4526c0a4 | 0201256-6 | Kaupunkitutkimus ja -tilastot -yksikkö | +358 9 310 1691 | #10 | MUNICIPALITY | 0 | helsinki | Ktt | |||||||||||||||||||||||
| e7b6bf77-9d59-4a91-8646-140788b762c6 | 0201256-6 | Tietotekniikka | +358 9 310 1691 | #10 | MUNICIPALITY | 0 | helsinki | Titek |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [department] ( [id] TEXT PRIMARY KEY, [parent] TEXT, [business_id] TEXT, [name_fi] TEXT, [abbr] TEXT, [street_address] TEXT, [address_city] TEXT, [address_postal_full] TEXT, [www] TEXT, [phone] TEXT, [address_zip] TEXT, [oid] TEXT, [organization_type] TEXT, [level] INTEGER, [municipality] TEXT, [www_sv] TEXT, [street_address_sv] TEXT, [street_address_en] TEXT, [address_postal_full_en] TEXT, [address_city_fi] TEXT, [name_en] TEXT, [www_en] TEXT, [address_postal_full_sv] TEXT, [abbr_fi] TEXT, [address_postal_full_fi] TEXT, [abbr_sv] TEXT, [abbr_en] TEXT, [address_city_en] TEXT, [name_sv] TEXT, [street_address_fi] TEXT, [address_city_sv] TEXT, [www_fi] TEXT );