department
6 rows where parent = "078a20dd-a3cc-4d29-9c7e-e5a2969e9a54"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1a244d49-1af2-4e7e-9cda-155ca791a2f7 | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Kehittämispalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki | |||||||||||||||||||||||
| 1b3226b3-a4ab-4bf1-8ede-4ccf9ec301f9 | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Talous- ja suunnittelupalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki | |||||||||||||||||||||||
| 41f09349-1f3d-4947-8196-ae494325df97 | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Hallinto- ja lakipalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki | |||||||||||||||||||||||
| 8b6317d9-9ffb-4cbc-903d-c1644d8050d8 | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Viestintäpalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki | |||||||||||||||||||||||
| b16d5dd9-1fac-42f1-8aaf-3394fc54c545 | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Henkilöstöpalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki | |||||||||||||||||||||||
| d32dec41-34b6-46ae-b9b2-b9c959e5dbca | 078a20dd-a3cc-4d29-9c7e-e5a2969e9a54 | 0201256-6 | Tietohallintopalvelut | +358 9 310 1691 | #10 | MUNICIPALITY | 3 | helsinki |
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 );