department
6 rows where parent = "6455dad1-2c2a-4042-9737-e6eac2f4413e"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0f04de19-56d4-4542-8dda-daf535240af2 | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Hankinnat ja kilpailuttaminen | +358 9 310 1691 | #10 | MUNICIPALITY | 4 | helsinki | |||||||||||||||||||||||
36e0ff5c-96be-4a1e-83eb-cc4d6c986f2d | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Aluerakentaminen | +358 9 310 1691 | 00170 | #10 | MUNICIPALITY | 4 | helsinki | Helsinki | Neighbourhood Construction | Områdesbyggande | Pohjoisesplanadi 11-13 | ||||||||||||||||||
87abd238-a222-4fa6-8bb9-9f3597880872 | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Rahoitus | +358 9 310 1691 | #10 | MUNICIPALITY | 4 | helsinki | |||||||||||||||||||||||
9ea31b17-9d92-4218-9115-5eb8910d4bc3 | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Asuminen | +358 9 310 1691 | #10 | MUNICIPALITY | 4 | helsinki | |||||||||||||||||||||||
ac541a52-aef1-4e7d-b8f7-4869bacb869f | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Talouden ohjaus | +358 9 310 1691 | 00170 | #10 | MUNICIPALITY | 4 | helsinki | Helsinki | Pohjoisesplanadi 15-17 | ||||||||||||||||||||
c7c4904e-17ac-4e2c-8fc6-a52f2e89949f | 6455dad1-2c2a-4042-9737-e6eac2f4413e | 0201256-6 | Konserniohjaus | +358 9 310 1691 | #10 | MUNICIPALITY | 4 | helsinki | City Group Governance | Koncernstyrning |
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 );