department
22 rows where business_id = "0124610-9" and level = 2
This data as json, CSV (advanced)
Suggested facets: parent, oid, organization_type
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
05b51e0b-d6ba-47fb-8c2a-e30c4f514f6d | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Keski-Uudenmaan pelastuslaitos | MUNICIPALLY_OWNED_COMPANY | 2 | Central-Uusimaa Rescue Department | KU-pela | Mellersta Nylands räddningsväsendes affärsverk | |||||||||||||||||||||||
0fd226cf-e79d-47d1-b9dd-7ff24021532b | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Kuntademokratia | #11 | MUNICIPALITY | 2 | vantaa | Local Democracy | Kude | Kommunal demokrati | |||||||||||||||||||||
4738c8e5-8bab-40c2-865d-5b28e64d7591 | de363a63-45be-487c-bbec-e98accf372a2 | 0124610-9 | Terveyspalvelut | #11 | MUNICIPALITY | 2 | vantaa | Health Services | Terpa | Hälsovårdstjänster | |||||||||||||||||||||
5ae74a7e-827b-49b5-8957-f94bcb7ec370 | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Viestintä | #11 | MUNICIPALITY | 2 | vantaa | Communications | Informationen | ||||||||||||||||||||||
68e57d85-383c-4e36-b77c-dea7c92602d3 | b4e07809-a34e-4476-b210-2c29c1fd52cb | 0124610-9 | Kulttuuri | +358 9 839 11 | #11 | MUNICIPALITY | 2 | vantaa | Culture | Kultt. | Kultur | ||||||||||||||||||||
751d7ecd-b8f3-40ad-b46e-2630fb31543c | de363a63-45be-487c-bbec-e98accf372a2 | 0124610-9 | Perhepalvelut | #11 | MUNICIPALITY | 2 | vantaa | Family Services | Perpa | Familjeservicen | |||||||||||||||||||||
799ae456-1519-4185-95ca-b34de57e7273 | cf66aaaa-c219-49b8-b00d-15babc9952a7 | 0124610-9 | Kiinteistöt ja tilat | #11 | MUNICIPALITY | 2 | vantaa | Real Estates and Premises | Kipa | Fastigheter och lokaler | |||||||||||||||||||||
7d0da869-fb36-4385-90d5-e79d2c419f7f | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Henkilöstö- ja konsernipalvelut | #11 | MUNICIPALITY | 2 | vantaa | PR and Group Services | Henko | Personal och koncernservice | |||||||||||||||||||||
8809b663-71b1-43bd-a894-ac7d0c503427 | de363a63-45be-487c-bbec-e98accf372a2 | 0124610-9 | Suun terveydenhuollon liikelaitos | MUNICIPALLY_OWNED_COMPANY | 2 | Vantaa Oral Health Corporation | Sthl | Affärsverket för mun- och tandhälsa | |||||||||||||||||||||||
8d5f6743-67b8-435f-8e36-281979c19fbf | b4e07809-a34e-4476-b210-2c29c1fd52cb | 0124610-9 | Nuoriso | +358 9 839 11 | #11 | MUNICIPALITY | 2 | vantaa | The Young | Nuor. | Ungdomar | ||||||||||||||||||||
a22185d1-8bf4-46b3-8a1a-35d985b60d9f | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Talous ja strategia | #11 | MUNICIPALITY | 2 | vantaa | Finance and Strategy | Tasa | Ekonomi och strategi | |||||||||||||||||||||
a415e9df-7d93-43e7-bc97-4e12e1192a0e | 2ea35a83-1051-4ba7-81d2-24d9ebebe8c2 | 0124610-9 | Kasvupalvelut | #11 | MUNICIPALITY | 2 | vantaa | Growth Services | Kapa | Tillväxttjänster | |||||||||||||||||||||
a897af2b-1f42-4772-b19a-ca7fe20a6704 | b4e07809-a34e-4476-b210-2c29c1fd52cb | 0124610-9 | Kirjasto- ja asukaspalvelut | +358 9 839 11 | #11 | MUNICIPALITY | 2 | vantaa | Library and Citizen Services | Kias | Biblioteks- och invånartjänster | ||||||||||||||||||||
ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 744852ab-9425-4329-9d1d-96fe0f132f63 | 0124610-9 | Varhaiskasvatus | #11 | MUNICIPALITY | 2 | vantaa | Early Childhood Education | Vaka | Småbarnspedagogik | |||||||||||||||||||||
b213292a-b2e4-4da0-9c88-31a38e6d7bc0 | cf66aaaa-c219-49b8-b00d-15babc9952a7 | 0124610-9 | Kaupunkirakenne ja ympäristö | #11 | MUNICIPALITY | 2 | vantaa | Urban Structure and Environment | Kara | Stadsstruktur och miljö | |||||||||||||||||||||
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 | ||||||||||||||||||||||||
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 | |||||||||||||||||||||
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 |
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 );