service_node
279 rows where level = 2 sorted by name_en
This data as json, CSV (advanced)
Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, last_modified_time (date)
id | children | name_fi | name_sv | name_en ▼ | service_reference | last_modified_time | level | parent | keywords | related_services | period_enabled | root | unit_count_municipality_helsinki | unit_count_total | unit_count_municipality_hanko | unit_count_municipality_raasepori | unit_count_municipality_siuntio | unit_count_municipality_sipoo | unit_count_municipality_janakkala | unit_count_municipality_nurmijärvi | unit_count_municipality_salo | unit_count_municipality_virolahti | unit_count_municipality_pornainen | unit_count_municipality_hämeenlinna | unit_count_municipality__unknown | unit_count_municipality_lapinjärvi | unit_count_municipality_inkoo | unit_count_municipality_miehikkälä | unit_count_municipality_porvoo | unit_count_municipality_lohja | unit_count_municipality_tuusula | unit_count_municipality_kirkkonummi | unit_count_municipality_hamina | unit_count_municipality_kouvola | unit_count_municipality_loviisa | unit_count_municipality_espoo | unit_count_municipality_askola | unit_count_municipality_kotka | unit_count_municipality_mäntsälä | unit_count_municipality_vantaa | unit_count_municipality_hyvinkää | unit_count_municipality_vihti | unit_count_municipality_kauniainen | unit_count_municipality_järvenpää | unit_count_municipality_kerava | unit_count_municipality_karkkila | unit_count_municipality_pyhtää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1020 | [] | Akuuttipsykiatria | Akutpsykiatri | Acute psychiatry | 46 | 2018-08-07T14:00:29.412887+03:00 | 2 | 1019 | {} | [46] | 0 | 986 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
172 | [173, 176, 2001, 2002] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:30.370486+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 59 | 72 | 1 | 3 | 8 | 1 | ||||||||||||||||||||||||||||||
490 | [] | Nuorten neuvonta ja ohjaus | Rådgivning och handledning för ungdomar | Advice and guidance for young people | 471 | 2018-08-07T14:00:23.202058+03:00 | 2 | 365 | {} | [471] | 0 | 1403 | 7 | 22 | 3 | 12 | |||||||||||||||||||||||||||||||
2049 | [2055, 2053, 2050, 2054] | Suomen- ja vieraskielinen iltapäivätoiminta | Eftermiddagsverksamhet på finska och främmande språk | Afternoon activities in Finnish, English and other languages | 656 | 2020-03-06T18:32:07.503687+02:00 | 2 | 2042 | {} | [656] | 1 | 1087 | 184 | 184 | |||||||||||||||||||||||||||||||||
2056 | [2060, 2057, 2061] | Ruotsinkielinen iltapäivätoiminta | Eftermiddagsverksamhet på svenska | Afternoon activities in Swedish | 596 | 2018-08-07T14:00:25.399596+03:00 | 2 | 2042 | {} | [596] | 1 | 1087 | 24 | 39 | 11 | 4 | |||||||||||||||||||||||||||||||
1029 | [] | Apuvälinepalvelut | Hjälpmedelstjänster | Aid services | 352 | 2018-08-07T14:00:29.484194+03:00 | 2 | 1028 | {} | [352] | 0 | 986 | 5 | 10 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
73 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:21.445519+03:00 | 2 | 1 | {} | [532] | 0 | 1400 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
503 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:22.776545+03:00 | 2 | 343 | {} | [532] | 0 | 1403 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
552 | [553, 2007] | Eläinurheilualueet | Anläggningar för djursport | Animal sports areas | 2018-08-07T14:00:23.225274+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 27 | 75 | 31 | 17 | ||||||||||||||||||||||||||||||||
1354 | [] | Suomenkielinen oppisopimuskoulutus | Läroavtalsutbildning på finska | Apprenticeship training in Finnish | 659 | 2018-08-07T14:00:27.469481+03:00 | 2 | 1353 | {} | [659] | 1 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1355 | [] | Ruotsinkielinen oppisopimuskoulutus | Läroavtalsutbildning på svenska | Apprenticeship training in Swedish | 599 | 2018-08-07T14:00:27.476430+03:00 | 2 | 1353 | {} | [599] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
307 | [308, 313, 309, 310, 312] | Arkistot | Arkiv | Archives | 2018-08-07T14:00:24.657353+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 4 | 11 | 2 | 4 | 1 | |||||||||||||||||||||||||||||||
216 | [217, 218] | Tarkastus | Revision | Auditing | 2018-08-07T14:00:30.700171+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 1 | 3 | 2 | |||||||||||||||||||||||||||||||||
2200 | [] | Englanninkielinen ammatillinen peruskoulutus | Grundutbildning på engelska | Basic education in English | 883*872 | 2019-08-22T14:00:14.395819+03:00 | 2 | 2179 | {} | [883, 872] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1098 | [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] | Suomen- ja vieraskielinen perusopetus | Grundläggande utbildning på finska och främmande språk | Basic education in Finnish, English and other languages | 2020-03-06T18:32:07.543511+02:00 | 2 | 1097 | {} | [] | 0 | 1087 | 368 | 504 | 1 | 84 | 50 | 1 | ||||||||||||||||||||||||||||||
2180 | [] | Suomenkielinen ammatillinen peruskoulutus | Grundutbildning på finska | Basic education in Finnsh | 653*872 | 2018-08-31T16:00:09.186721+03:00 | 2 | 2179 | {} | [872, 653] | 1 | 1087 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
1187 | [1246, 1249, 1193, 1192, 1188, 1190, 1242] | Ruotsinkielinen perusopetus | Grundläggande utbildning på svenska | Basic education in Swedish | 2018-08-07T14:00:26.251158+03:00 | 2 | 1097 | {} | [] | 0 | 1087 | 47 | 65 | 13 | 5 | ||||||||||||||||||||||||||||||||
843 | [] | Perustoimeentulotuki | Grundläggande utkomststöd | Basic social assistance | 711 | 2018-08-07T14:00:28.092481+03:00 | 2 | 839 | {} | [711] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
841 | [] | Etuuskäsittely | Förmånsbehandling | Benefit processing | 167 | 2018-08-07T14:00:28.085946+03:00 | 2 | 839 | {} | [167] | 0 | 783 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
93 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-24T20:30:07.186738+03:00 | 2 | 85 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
666 | [667, 675, 677] | Vene-, ilmailu- ja moottoriurheilu | Anläggningar för båtsport, flygsport och motorsport | Boating, aviation and motor sports | 2018-08-07T14:00:24.041279+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 9 | 18 | 3 | 6 | ||||||||||||||||||||||||||||||||
344 | [] | Kasvitieteelliset puutarhat | Botaniska trädgårdar | Botanic gardens | 248 | 2018-08-07T14:00:22.544317+03:00 | 2 | 343 | {} | [248] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
835 | [] | Päihdehuollon päivätoiminta | Dagverksamhet inom missbrukarvården | Care for substance abuse, daytime activities | 547 | 2018-08-07T14:00:28.047640+03:00 | 2 | 830 | {} | [547] | 0 | 783 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1056 | [] | Päihdehuollon päivätoiminta | Dagverksamhet inom missbrukarvården | Care for substance abuse, daytime activities | 547 | 2018-08-07T14:00:29.716393+03:00 | 2 | 1051 | {} | [547] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
837 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:28.061184+03:00 | 2 | 830 | {} | [544] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
1058 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:29.732968+03:00 | 2 | 1051 | {} | [544] | 0 | 986 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
833 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:28.034805+03:00 | 2 | 830 | {} | [546] | 0 | 783 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
1054 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:29.702337+03:00 | 2 | 1051 | {} | [546] | 0 | 986 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
836 | [] | Päihdehuollon asumispalvelut | Boendetjänster inom missbrukarvården | Care for substance abuse, residential services | 543 | 2018-08-07T14:00:28.054175+03:00 | 2 | 830 | {} | [543] | 0 | 783 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
1057 | [] | Päihdehuollon asumispalvelut | Boendetjänster inom missbrukarvården | Care for substance abuse, residential services | 543 | 2018-08-07T14:00:29.725065+03:00 | 2 | 1051 | {} | [543] | 0 | 986 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
832 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:28.028451+03:00 | 2 | 830 | {} | [548] | 0 | 783 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
1053 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:29.695330+03:00 | 2 | 1051 | {} | [548] | 0 | 986 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
831 | [] | Päihdehuollon sosiaalityö | Socialt arbete inom missbrukarvården | Care for substance abuse, social work | 549 | 2018-08-07T14:00:28.021758+03:00 | 2 | 830 | {} | [549] | 0 | 783 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
1052 | [] | Päihdehuollon sosiaalityö | Socialt arbete inom missbrukarvården | Care for substance abuse, social work | 549 | 2018-08-07T14:00:29.687959+03:00 | 2 | 1051 | {} | [549] | 0 | 986 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
834 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:28.041229+03:00 | 2 | 830 | {} | [545] | 0 | 783 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1055 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:29.709367+03:00 | 2 | 1051 | {} | [545] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
827 | [] | Vanhuspalvelun omaishoidon tuki | Stöd för närståendevårdare inom äldreomsorgen | Care for the elderly, close relative care support | 759 | 2018-08-07T14:00:27.996868+03:00 | 2 | 819 | {} | [759] | 0 | 783 | 4 | 8 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
813 | [] | Kehitysvammahuollon päivätoiminta | Dagverksamhet inom vård av utvecklingsstörda | Care of the developmentally disabled, daytime activities | 278 | 2018-08-07T14:00:27.899777+03:00 | 2 | 810 | {} | [278] | 0 | 783 | 10 | 18 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||
814 | [] | Kehitysvammahuollon työllistämispalvelut | Sysselsättningstjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, employment services | 282 | 2018-08-07T14:00:27.906450+03:00 | 2 | 810 | {} | [282] | 0 | 783 | 5 | 6 | 1 | ||||||||||||||||||||||||||||||||
818 | [] | Kehitysvammahuollon taloudellinen tuki | Ekonomiskt stöd inom vård av utvecklingsstörda | Care of the developmentally disabled, financial support | 281 | 2018-08-07T14:00:27.931547+03:00 | 2 | 810 | {} | [281] | 0 | 783 | 2 | 4 | 2 | ||||||||||||||||||||||||||||||||
816 | [] | Kehitysvammahuollon laitospalvelu | Institutionsservice inom vård av utvecklingsstörda | Care of the developmentally disabled, institutional service | 276 | 2018-08-07T14:00:27.919212+03:00 | 2 | 810 | {} | [276] | 0 | 783 | 4 | 4 | |||||||||||||||||||||||||||||||||
815 | [] | Kehitysvammahuollon asumispalvelut | Boendetjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, residential services | 275 | 2018-08-07T14:00:27.912869+03:00 | 2 | 810 | {} | [275] | 0 | 783 | 39 | 71 | 9 | 21 | 1 | 1 | |||||||||||||||||||||||||||||
812 | [] | Kehitysvammahuollon sosiaaliohjaus | Socialhandledning inom omsorger om utvecklingsstörda | Care of the developmentally disabled, social care work | 279 | 2018-08-07T14:00:27.893701+03:00 | 2 | 810 | {} | [279] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
811 | [] | Kehitysvammahuollon sosiaalityö | Socialt arbete inom vård av utvecklingsstörda | Care of the developmentally disabled, social work | 280 | 2018-08-07T14:00:27.887549+03:00 | 2 | 810 | {} | [280] | 0 | 783 | 3 | 9 | 5 | 1 | |||||||||||||||||||||||||||||||
817 | [] | Kehitysvammahuollon loma- ja harrastustoiminta | Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda | Care of the developmentally disabled, vacation and leisure activities | 277 | 2018-08-07T14:00:27.925241+03:00 | 2 | 810 | {} | [277] | 0 | 783 | 3 | 6 | 3 | ||||||||||||||||||||||||||||||||
59 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:21.345565+03:00 | 2 | 1 | {} | [432] | 0 | 1400 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
361 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:22.659080+03:00 | 2 | 343 | {} | [432] | 0 | 1403 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
178 | [] | Keskitetyt tietotekniikkapalvelut | Centraliserade datatekniktjänster | Centralised services on information technology | 222 | 2018-08-07T14:00:30.449039+03:00 | 2 | 171 | {} | [222] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
533 | [] | Sähköautojen latauspisteet | Laddstationer för elbilar | Charging stations for electric vehicles | 669 | 2018-08-07T14:00:25.139376+03:00 | 2 | 512 | {} | [669] | 0 | 1402 | 31 | 37 | 6 | ||||||||||||||||||||||||||||||||
1005 | [] | Lastenneuvola | Barnrådgivning | Child health clinic | 379 | 2018-10-25T08:00:09.610190+03:00 | 2 | 1004 | {} | [379] | 0 | 986 | 22 | 47 | 14 | 10 | 1 | ||||||||||||||||||||||||||||||
788 | [] | Lastensuojelun sosiaalityö | Socialt arbete inom barnskyddet | Child welfare social work | 382 | 2018-08-07T14:00:27.731506+03:00 | 2 | 787 | {} | [382] | 0 | 783 | 25 | 42 | 9 | 7 | 1 | ||||||||||||||||||||||||||||||
1071 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:29.851905+03:00 | 2 | 1070 | {} | [467] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
350 | [] | Kirkot ja muut uskonnolliset tilat | Kyrkor och andra religiösa byggnader | Churches and other religious buildings | 314 | 2018-08-07T14:00:22.584521+03:00 | 2 | 343 | {} | [314] | 0 | 1403 | 63 | 86 | 3 | 19 | 1 | ||||||||||||||||||||||||||||||
1011 | [] | Kaupungin psykiatrinen sairaala | Stadens psykiatriska sjukhus | City Psychiatric Hospital | 263 | 2018-08-07T14:00:29.322493+03:00 | 2 | 1009 | {} | [263] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1012 | [] | Kaupunginsairaalat | Stadssjukhus | City hospitals | 264 | 2018-08-07T14:00:29.330351+03:00 | 2 | 1009 | {} | [264] | 0 | 986 | 9 | 11 | 1 | 1 | |||||||||||||||||||||||||||||||
54 | [] | Rantavesien ja sisäsaariston puhtaanapito | Renhållning av strandvatten och inre skärgård | Cleaning waterfronts and inner archipelago | 572 | 2018-08-07T14:00:21.940289+03:00 | 2 | 31 | {} | [572] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
34 | [35, 36, 37, 38, 2211, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51] | Keräyspisteet | Insamlingsplatser | Collection points | 2018-08-07T14:00:21.780177+03:00 | 2 | 31 | {} | [] | 0 | 1400 | 210 | 565 | 150 | 185 | 20 | |||||||||||||||||||||||||||||||
305 | [] | Viestintä | Kommunikation | Communications | 784 | 2018-08-07T14:00:22.528397+03:00 | 2 | 221 | {} | [784] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
2212 | [] | Kansalaisopisto | Medborgarinstitut | Community college | 890 | 2020-11-18T07:30:12.923359+02:00 | 2 | 1360 | {} | [890] | 0 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1336 | [1340, 1337, 1341, 1338, 1342] | Suomen- ja vieraskielinen aikuisten perus- ja lukiokoulutus | Grundläggande utbildning och gymnasieutbildning för vuxna på finska och främmande språk | Comprehensive and upper secondary school education for adults in Finnish, English and other languages | 2020-03-06T18:32:08.302751+02:00 | 2 | 1335 | {} | [] | 0 | 1087 | 3 | 8 | 2 | 3 | ||||||||||||||||||||||||||||||||
1343 | [1346, 1344, 1347, 1345] | Ruotsinkielinen aikuisten perus- ja lukiokoulutus | Grundläggande utbildning och gymnasieutbildning för vuxna på svenska | Comprehensive and upper secondary school education for adults in Swedish | 2018-08-07T14:00:27.400544+03:00 | 2 | 1335 | {} | [] | 0 | 1087 | 1 | 1 | ||||||||||||||||||||||||||||||||||
270 | [271, 272, 277, 278, 279, 286, 287, 293, 302] | Rakentaminen | Byggande | Construction | 2018-08-07T14:00:22.314988+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 48 | 80 | 1 | 1 | 8 | 21 | 1 | |||||||||||||||||||||||||||||
558 | [559, 564, 567, 572, 575, 577, 592, 597] | Maastoliikuntapaikat | Anläggningar för terrängidrott | Cross-country sports facilities | 2018-08-07T14:00:23.281875+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 151 | 443 | 5 | 1 | 1 | 118 | 153 | 9 | 5 | |||||||||||||||||||||||||||
352 | [353, 354, 355, 356, 357, 358, 359, 360] | Kulttuuritilat | Kulturlokaler | Cultural facilities | 2018-08-07T14:00:22.597325+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 198 | 232 | 18 | 13 | 3 | |||||||||||||||||||||||||||||||
314 | [319, 315, 317, 316, 2147, 2159] | Asiakaspalvelu ja neuvonta | Kundbetjäning och rådgivning | Customer service and information | 2018-08-07T14:00:24.703287+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 12 | 39 | 1 | 12 | 13 | 1 | ||||||||||||||||||||||||||||||
1379 | [] | Perusopetuksen neuvonta | Kundbetjäning och rådgivning (grundläggande utbildning) | Customer service and information (basic education) | 70 | 2018-08-07T14:00:27.673059+03:00 | 2 | 1378 | {} | [70] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2029 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:28.251638+03:00 | 2 | 868 | {} | [844] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2080 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:27.666416+03:00 | 2 | 1378 | {} | [844] | 0 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1380 | [] | Lukiokoulutuksen neuvonta | Kundbetjäning och rådgivning (gymnasieutbildning) | Customer service and information (general upper secondary education) | 69 | 2018-08-07T14:00:27.679921+03:00 | 2 | 1378 | {} | [69] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1381 | [] | Ammatillisen koulutuksen neuvonta | Kundbetjäning och rådgivning (yrkesutbildning) | Customer service and information (vocational education and training) | 68 | 2018-08-07T14:00:27.686734+03:00 | 2 | 1378 | {} | [68] | 0 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2203 | [] | Asiakaspalvelu | Kundbetjäning | Customer services | 884 | 2019-08-23T14:30:13.757143+03:00 | 2 | 171 | {} | [884] | 0 | 1401 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1081 | [] | Tullin asiointipisteet | Tullens verksamhetsställen | Customs offices | 716 | 2018-08-07T14:00:29.921102+03:00 | 2 | 1080 | {} | [716] | 0 | 1061 | 4 | 7 | 1 | 2 | |||||||||||||||||||||||||||||||
849 | [] | Mielenterveyskuntoutujien päivätoiminta | Dagverksamhet för klienter inom psykrehabilitering | Day activities for mental health rehabilitation clients | 441 | 2018-08-07T14:00:28.144565+03:00 | 2 | 845 | {} | [441] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
869 | [897, 905, 913, 921, 929, 881, 889, 937, 870, 945, 2238, 953] | Päiväkotihoito | Daghemsvård | Day care centres | 2018-08-07T14:00:28.258090+03:00 | 2 | 868 | {} | [] | 0 | 1405 | 497 | 1020 | 329 | 184 | 10 | |||||||||||||||||||||||||||||||
1014 | [] | Päiväsairaala | Dagsjukhus | Day hospital | 553 | 2018-08-07T14:00:29.349793+03:00 | 2 | 1009 | {} | [553] | 0 | 986 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
191 | [192, 193, 194, 195, 196] | Päätöksenteko | Beslutsfattande | Decision-making | 2018-08-07T14:00:30.523612+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 6 | 10 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
756 | [757, 763] | Demokratia | Demokrati | Democracy | 2018-08-07T14:00:30.749902+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 8 | 13 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2156 | [] | Etsivä nuorisotyö | Uppsökande ungdomsarbete | Detective youth work | 854 | 2018-08-07T14:00:23.208137+03:00 | 2 | 365 | {} | [854] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
838 | [] | Selviämishoitoasema | Tillnyktringsstation | Detoxification centre | 618 | 2018-08-07T14:00:28.067660+03:00 | 2 | 830 | {} | [618] | 0 | 783 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1059 | [] | Selviämishoitoasema | Tillnyktringsstation | Detoxification centre | 618 | 2018-08-07T14:00:29.743322+03:00 | 2 | 1051 | {} | [618] | 0 | 986 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1007 | [] | Kehitysvammapoliklinikka | Handikapprådgivning | Developmental disability clinic | 284 | 2018-10-25T08:00:09.092312+03:00 | 2 | 810 | {} | [284] | 0 | 783 | 4 | 6 | 1 | 1 | |||||||||||||||||||||||||||||||
2162 | [] | Digitaalinen nuorisotyö | Digital ungdomsarbete | Digital youth work | 859 | 2018-08-07T14:00:23.214339+03:00 | 2 | 365 | {} | [859] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
809 | [] | Vammaistuet ja -palvelut | Handikappbidrag och -tjänster | Disability benefits and services | 755 | 2018-08-07T14:00:27.876348+03:00 | 2 | 798 | {} | [755] | 0 | 783 | 3 | 15 | 1 | 2 | 7 | 1 | 1 | ||||||||||||||||||||||||||||
16 | [17, 18, 19, 20, 21] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.685399+03:00 | 2 | 14 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
790 | [] | Lastensuojelun perhehoito | Familjevård inom barnskyddet | Domestic care for child welfare | 381 | 2018-08-07T14:00:27.746492+03:00 | 2 | 787 | {} | [381] | 0 | 783 | 5 | 2 | 3 | ||||||||||||||||||||||||||||||||
1013 | [] | Kotisairaalat | Hemsjukhus | Domestic hospitals | 336 | 2018-08-07T14:00:29.340263+03:00 | 2 | 1009 | {} | [336] | 0 | 986 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
794 | [] | Lapsiperheiden kotipalvelu | Hemservice för barnfamiljer | Domestic services for families with children | 371 | 2018-08-07T14:00:27.777393+03:00 | 2 | 791 | {} | [371] | 0 | 783 | 6 | 9 | 3 | ||||||||||||||||||||||||||||||||
197 | [2152, 198, 209] | Talous | Ekonomi | Economy | 2018-08-07T14:00:30.559004+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 10 | 10 | ||||||||||||||||||||||||||||||||||
3 | [] | Asumisen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för boendeärenden | Electronic housing services and forms | 74 | 2018-08-07T14:00:21.236014+03:00 | 2 | 2 | {} | [74] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
128 | [] | Elinkeinopalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för näringslivsservicen | Electronic services and forms related to business services | 135 | 2018-08-07T14:00:30.039148+03:00 | 2 | 122 | {} | [135] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
351 | [] | Kulttuuripalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för kulturtjänster | Electronic services and forms related to cultural services | 346 | 2018-08-07T14:00:22.590770+03:00 | 2 | 343 | {} | [346] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
985 | [] | Päivähoidon sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för dagvårdsärenden | Electronic services and forms related to day care | 552 | 2018-08-07T14:00:29.033246+03:00 | 2 | 868 | {} | [552] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
100 | [] | Ympäristön sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för miljöärenden | Electronic services and forms related to environmental matters | 826 | 2018-08-07T14:00:21.554721+03:00 | 2 | 1 | {} | [826] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
2151 | [] | Liikunnan sähköinen asiointi ja lomakkeet | Elektroniska tjänster och formulär för motion | Electronic services and forms related to sports | 849 | 2018-08-07T14:00:24.387923+03:00 | 2 | 551 | {} | [849] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
1003 | [] | Päivystyksen vuodeosastot | Vårdavdelningar inom jourverksamheten | Emergency care outpatient wards | 550 | 2018-08-07T14:00:29.260759+03:00 | 2 | 1000 | {} | [550] | 0 | 986 | 4 | 4 | |||||||||||||||||||||||||||||||||
163 | [] | Työ- ja elinkeinotoimistot | Arbets- och näringsbyråer | Employment and economic development offices | 723 | 2018-08-07T14:00:30.289431+03:00 | 2 | 122 | {} | [723] | 0 | 1401 | 3 | 7 | 1 | 3 | |||||||||||||||||||||||||||||||
164 | [] | Työsuhdeasiat | Anställningsfrågor | Employment matters | 725 | 2018-08-07T14:00:30.298491+03:00 | 2 | 122 | {} | [725] | 0 | 1401 | 3 | 5 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service_node] ( [id] INTEGER PRIMARY KEY, [children] TEXT, [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [service_reference] TEXT, [last_modified_time] TEXT, [level] INTEGER, [parent] INTEGER, [keywords] TEXT, [related_services] TEXT, [period_enabled] INTEGER, [root] INTEGER, [unit_count_municipality_helsinki] INTEGER, [unit_count_total] INTEGER, [unit_count_municipality_hanko] TEXT, [unit_count_municipality_raasepori] TEXT, [unit_count_municipality_siuntio] TEXT, [unit_count_municipality_sipoo] TEXT, [unit_count_municipality_janakkala] TEXT, [unit_count_municipality_nurmijärvi] TEXT, [unit_count_municipality_salo] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality__unknown] TEXT, [unit_count_municipality_lapinjärvi] TEXT, [unit_count_municipality_inkoo] TEXT, [unit_count_municipality_miehikkälä] TEXT, [unit_count_municipality_porvoo] TEXT, [unit_count_municipality_lohja] INTEGER, [unit_count_municipality_tuusula] TEXT, [unit_count_municipality_kirkkonummi] TEXT, [unit_count_municipality_hamina] TEXT, [unit_count_municipality_kouvola] TEXT, [unit_count_municipality_loviisa] TEXT, [unit_count_municipality_espoo] INTEGER, [unit_count_municipality_askola] TEXT, [unit_count_municipality_kotka] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] INTEGER, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_pyhtää] TEXT );