department
27 rows where municipality = "vantaa" sorted by address_zip
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
b4e07809-a34e-4476-b210-2c29c1fd52cb | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | 0124610-9 | Kaupunkikulttuurin toimiala, Vantaa | +358 9 839 11 | #11 | MUNICIPALITY | 1 | vantaa | Urban Culture Department, Vantaa | Kaku | Stadskulturens verksamhetsområde, Vanda | ||||||||||||||||||||
c6e828d9-9f7c-43ee-91fc-085d9a122b04 | 744852ab-9425-4329-9d1d-96fe0f132f63 | 0124610-9 | Perusopetus | #11 | MUNICIPALITY | 2 | vantaa | Basic Education | Pope | Grundläggande utbildningen | |||||||||||||||||||||
c8fc61df-3e17-40b3-b96c-2097c29304c2 | b4e07809-a34e-4476-b210-2c29c1fd52cb | 0124610-9 | Liikunta | +358 9 839 11 | #11 | MUNICIPALITY | 2 | vantaa | Sports | Liik. | Idrott och motion | ||||||||||||||||||||
ced512bb-395d-495b-9599-d57140d9d1ad | 78cdd9d7-ff04-4cbb-8caa-b8059ea4cc9f | 0124610-9 | Vantaan keskusvaalilautakunta | #10 | MUNICIPALITY | 2 | vantaa | ||||||||||||||||||||||||
cf66aaaa-c219-49b8-b00d-15babc9952a7 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | 0124610-9 | Kaupunkiympäristön toimiala, Vantaa | #11 | MUNICIPALITY | 1 | vantaa | Urban Environment Department, Vantaa | Kato | Stadsmiljöns verksamhetsområde, Vanda | |||||||||||||||||||||
d6c56752-dec1-4e56-9113-10975030cd75 | de363a63-45be-487c-bbec-e98accf372a2 | 0124610-9 | Vanhus- ja vammaispalvelut | #11 | MUNICIPALITY | 2 | vantaa | Services for the Elderly and the Disabled | Vahva | Äldre- och handikappservicen | |||||||||||||||||||||
d9368ea3-e657-4d58-b3b7-c447d5d3ea16 | 744852ab-9425-4329-9d1d-96fe0f132f63 | 0124610-9 | Ruotsinkieliset palvelut | #11 | MUNICIPALITY | 2 | vantaa | Swedish-language Services | Sve | Svenskspråkiga servicen | |||||||||||||||||||||
de363a63-45be-487c-bbec-e98accf372a2 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | 0124610-9 | Sosiaali- ja terveydenhuollon toimiala, Vantaa | 1.2.246.10.1246109.10.200 | MUNICIPALITY | 1 | vantaa | Health and Social Welfare Department, Vantaa | Sote | Verksamhetsområdet för social- och hälsovård, Vanda | |||||||||||||||||||||
fa67dcbc-6f88-4e9f-bccc-5760dad3301d | cf66aaaa-c219-49b8-b00d-15babc9952a7 | 0124610-9 | Kadut ja puistot | #11 | MUNICIPALITY | 2 | vantaa | Streets and Parks | Kapu | Gator och parker | |||||||||||||||||||||
fef822d5-7a4e-47da-ba94-f6f4b0a7c759 | 744852ab-9425-4329-9d1d-96fe0f132f63 | 0124610-9 | Toisen asteen koulutus | #11 | MUNICIPALITY | 2 | vantaa | Secondary Education | Tako | Utbildningen på andra stadiet | |||||||||||||||||||||
6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | 0124610-9 | Vantaan kaupunki | +358 9 839 11 | 01300 | 1.2.246.10.1246109.10.0 | MUNICIPALITY | 0 | vantaa | http://www.vantaa.fi/ | Asematie 7 | Asematie 7 | Vantaa | City of Vantaa | http://www.vantaa.fi/ | Vantaa | Vanda stad | Asematie 7 | Vantaa | http://www.vantaa.fi/ |
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 );