service_node
279 rows where level = 2 sorted by related_services
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 157
- 2020-03-06 8
- 2018-10-25 4
- 2020-11-18 3
- 2018-08-31 2
- 2018-10-24 1
- 2019-03-05 1
- 2019-08-22 1
- 2019-08-23 1
- 2020-06-09 1
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1014 | [] | Päiväsairaala | Dagsjukhus | Day hospital | 553 | 2018-08-07T14:00:29.349793+03:00 | 2 | 1009 | {} | [553] | 0 | 986 | 2 | 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 | |||||||||||||||||||||||||||||||||
1037 | [] | Rintamavetaraanien kuntoutus | Rehabilitering av frontveteraner | Front-line veteran rehabilitation | 583 | 2018-08-07T14:00:29.562795+03:00 | 2 | 1028 | {} | [583] | 0 | 986 | 1 | 6 | 4 | 1 | |||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1365 | [1366, 1368, 1367] | Ruotsinkielinen työväenopisto | Svenska arbetarinstitutet | Swedish adult education centre | 605 | 2020-11-18T07:30:12.874521+02:00 | 2 | 1360 | {} | [605] | 0 | 1087 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
1255 | [] | Sairaalaopetus | Sjukhusundervisning | Hospital education | 609 | 2018-08-07T14:00:26.759479+03:00 | 2 | 1097 | {} | [609] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1015 | [] | Sairaaloiden poliklinikat | Sjukhusens polikliniker | Hospital outpatient clinics | 610 | 2018-08-07T14:00:29.359098+03:00 | 2 | 1009 | {} | [610] | 0 | 986 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1074 | [] | Sopimuspalokunnat | Avtalsbrandkårer | Volunteer fire departments | 633 | 2018-08-07T14:00:29.872976+03:00 | 2 | 1070 | {} | [633] | 0 | 1061 | 15 | 23 | 7 | 1 | |||||||||||||||||||||||||||||||
829 | [] | Kotihoito | Hemvård | Home care | 635 | 2020-03-06T18:32:08.579934+02:00 | 2 | 819 | {} | [635] | 0 | 783 | 69 | 95 | 19 | 4 | 3 | ||||||||||||||||||||||||||||||
1068 | [] | Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) | Stödtjänster inom social- och hälsovården (stöd för boende) | Social and health care services' security services (housing support) | 636 | 2018-08-07T14:00:29.828890+03:00 | 2 | 1066 | {} | [636] | 0 | 1061 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
852 | [] | Muun sosiaalihuollon asumispalvelut | Boendetjänster inom övrig socialvård | Residential services for other social welfare | 637 | 2018-08-07T14:00:28.163665+03:00 | 2 | 845 | {} | [637] | 0 | 783 | 11 | 26 | 1 | 1 | 12 | 1 | |||||||||||||||||||||||||||||
850 | [] | Työhön kuntoutus- ja työllistämispalvelut | Arbetsrehabiliterings- och sysselsättningstjänster | Rehabilitation and employment services for work | 638 | 2018-08-07T14:00:28.151060+03:00 | 2 | 845 | {} | [638] | 0 | 783 | 4 | 12 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
853 | [] | Sosiaalihuoltolain mukainen kuljetuspalvelu | Färdtjänst enligt socialvårdslagen | Transportation service according to the legislation on social welfare | 640 | 2018-08-07T14:00:28.169839+03:00 | 2 | 845 | {} | [640] | 0 | 783 | 3 | 6 | 2 | 1 | |||||||||||||||||||||||||||||||
854 | [] | Sosiaalinen luotto | Social kredit | Social lending | 641 | 2018-08-07T14:00:28.176603+03:00 | 2 | 845 | {} | [641] | 0 | 783 | 1 | 4 | 2 | 1 | |||||||||||||||||||||||||||||||
856 | [] | Sovittelutoiminta | Medlingsverksamhet | Mitigation services | 644 | 2018-08-07T14:00:28.189606+03:00 | 2 | 845 | {} | [644] | 0 | 783 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1357 | [] | Suomenkielinen ammattikorkeakoulukoulutus | Yrkeshögskoleutbildning på finska | Polytechnic education in Finnish | 654 | 2018-08-07T14:00:27.490338+03:00 | 2 | 1356 | {} | [654] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1361 | [1362, 1363] | Suomenkielinen työväenopisto | Finska arbetarinstitutet | Finnish adult education centre | 665 | 2020-11-18T07:30:12.844488+02:00 | 2 | 1360 | {} | [665] | 0 | 1087 | 50 | 59 | 7 | 2 | |||||||||||||||||||||||||||||||
1016 | [] | Synnytyssairaalat | Förlossningssjukhus | Maternity hospitals | 667 | 2018-08-07T14:00:29.368533+03:00 | 2 | 1009 | {} | [667] | 0 | 986 | 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 | ||||||||||||||||||||||||||||||||
858 | [] | Talous- ja velkaneuvonta | Ekonomi- och skuldrådgivning | Financial and debt counselling | 673 | 2018-08-07T14:00:28.202820+03:00 | 2 | 845 | {} | [673] | 0 | 783 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
342 | [] | Tilastot ja tietopalvelut | Statistik och informationstjänst | Statistics and information services | 709 | 2018-10-25T08:00:07.381081+03:00 | 2 | 306 | {} | [709] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
1038 | [] | Toimintaterapia | Ergoterapi | Occupational therapy | 712 | 2018-08-07T14:00:29.573439+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [712] | 0 | 986 | 9 | 13 | 1 | 3 | |||||||||||||||||||||||||||||||
219 | [220] | Tuet ja avustukset | Understöd och bidrag | Grants and benefits | 715 | 2018-08-07T14:00:30.723645+03:00 | 2 | 171 | {} | [715] | 0 | 1401 | 3 | 2 | 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 | |||||||||||||||||||||||||||||||
785 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:27.709008+03:00 | 2 | 784 | {} | [71] | 0 | 783 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
989 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:29.129777+03:00 | 2 | 988 | {} | [71] | 0 | 986 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
1067 | [] | Turvallisuuskoulutus | Säkerhetsutbildning | Safety training | 720 | 2018-08-07T14:00:29.819172+03:00 | 2 | 1066 | {} | [720] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
855 | [] | Työkykyselvitys pitkäaikaistyöttömille | Pensionsutredningsverksamhet | Pension determination service | 724 | 2018-08-07T14:00:28.183191+03:00 | 2 | 845 | {} | [724] | 0 | 783 | 2 | 10 | 8 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
805 | [] | Vammaispalvelulain mukainen kuljetuspalvelu | Färdtjänst enligt handikappservicelagen | Transportation service according to the legislation on disability services | 745 | 2018-08-07T14:00:27.849436+03:00 | 2 | 798 | {} | [745] | 0 | 783 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
803 | [] | Vammaispalvelun asumispalvelut | Boendetjänster inom handikappservicen | Services for the disabled, residential services | 746 | 2018-08-07T14:00:27.835887+03:00 | 2 | 798 | {} | [746] | 0 | 783 | 7 | 24 | 1 | 3 | 13 | ||||||||||||||||||||||||||||||
807 | [] | Vammaispalvelun asunnon muutostyöt | Ändringsarbeten i bostad inom handikappservicen | Service for the disabled, renovation services | 747 | 2018-08-07T14:00:27.863389+03:00 | 2 | 798 | {} | [747] | 0 | 783 | 4 | 10 | 2 | 4 | |||||||||||||||||||||||||||||||
808 | [] | Vammaispalvelun henkilökohtainen apu | Personlig assistent inom handikappservicen | Service for the disabled, personal assistant | 748 | 2018-08-07T14:00:27.870086+03:00 | 2 | 798 | {} | [748] | 0 | 783 | 4 | 9 | 1 | 4 | |||||||||||||||||||||||||||||||
806 | [] | Vammaispalvelun omaishoidon tuki | Stöd för närståendevård inom handikappservicen | Services for the disabled, close relative care support | 749 | 2018-08-07T14:00:27.856508+03:00 | 2 | 798 | {} | [749] | 0 | 783 | 4 | 10 | 2 | 4 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
802 | [] | Vammaispalvelun päivätoiminta | Dagverksamhet inom handikappservicen | Service for the disabled, daytime activities | 750 | 2018-08-07T14:00:27.829187+03:00 | 2 | 798 | {} | [750] | 0 | 783 | 10 | 1 | 9 | ||||||||||||||||||||||||||||||||
801 | [] | Vammaispalvelun sosiaaliohjaus | Socialhandledning inom handikappservice | Services for the disabled, social care work | 751 | 2018-08-07T14:00:27.822488+03:00 | 2 | 798 | {} | [751] | 0 | 783 | 33 | 1 | 32 | ||||||||||||||||||||||||||||||||
799 | [] | Vammaispalvelun sosiaalityö | Socialt arbete inom handikappservicen | Service for the disabled, social work | 752 | 2018-08-07T14:00:27.810101+03:00 | 2 | 798 | {} | [752] | 0 | 783 | 4 | 11 | 3 | 4 | |||||||||||||||||||||||||||||||
800 | [] | Vammaispalvelun tukihenkilö | Stödperson inom handikappservice | Services for the disabled, support person | 753 | 2018-08-07T14:00:27.816289+03:00 | 2 | 798 | {} | [753] | 0 | 783 | 4 | 8 | 4 | ||||||||||||||||||||||||||||||||
804 | [] | Vammaispalvelun tulkkipalvelu | Tolktjänster inom handikappservicen | Services for the disabled, interpretation services | 754 | 2018-08-07T14:00:27.842330+03:00 | 2 | 798 | {} | [754] | 0 | 783 | 6 | 2 | 4 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
828 | [] | Vanhusten avopalvelutoiminta | Öppenserviceverksamhet inom äldre | Outpatient service activities for the elderly | 756 | 2018-08-07T14:00:28.002976+03:00 | 2 | 819 | {} | [756] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
824 | [] | Vanhusten itsenäinen asuminen | Självständigt boende för äldre | Independent habitation for the elderly | 757 | 2018-08-07T14:00:27.977916+03:00 | 2 | 819 | {} | [757] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
826 | [] | Vanhusten laitospalvelu | Institutionsservice för äldre | Institutional service for the elderly | 758 | 2018-08-07T14:00:27.990439+03:00 | 2 | 819 | {} | [758] | 0 | 783 | 4 | 7 | 2 | 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 | ||||||||||||||||||||||||||||||
4 | [] | Asumisen tuet | Bostadsbidrag | Housing allowances | 75 | 2018-08-07T14:00:21.243003+03:00 | 2 | 2 | {} | [75] | 0 | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
825 | [] | Vanhusten palveluasuminen | Serviceboende för äldre | Service residence for the elderly | 760 | 2018-08-07T14:00:27.984445+03:00 | 2 | 819 | {} | [760] | 0 | 783 | 30 | 103 | 1 | 36 | 32 | 3 | 1 | ||||||||||||||||||||||||||||
823 | [] | Vanhusten palvelukeskustoiminta | Servicecentralverksamhet för äldre | Service centre activities for the elderly | 761 | 2018-08-07T14:00:27.970552+03:00 | 2 | 819 | {} | [761] | 0 | 783 | 14 | 15 | 1 | ||||||||||||||||||||||||||||||||
822 | [] | Vanhusten päivätoiminta | Dagverksamhet för äldre | Service for the elderly, daytime activities | 762 | 2018-08-07T14:00:27.964013+03:00 | 2 | 819 | {} | [762] | 0 | 783 | 17 | 30 | 9 | 3 | 1 | ||||||||||||||||||||||||||||||
821 | [] | Vanhuspalvelun sosiaaliohjaus | Socialhandledning inom äldreomsorg | Services for the elderly, social care work | 763 | 2018-08-07T14:00:27.957632+03:00 | 2 | 819 | {} | [763] | 0 | 783 | 4 | 7 | 2 | 1 | |||||||||||||||||||||||||||||||
820 | [] | Vanhuspalvelun sosiaalityö | Socialt arbete inom äldreomsorgen | Service for the elderly, social work | 764 | 2018-08-07T14:00:27.951192+03:00 | 2 | 819 | {} | [764] | 0 | 783 | 5 | 16 | 1 | 8 | 2 | ||||||||||||||||||||||||||||||
91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
2006 | [] | Veistokset ja julkinen taide | Skulpturer och offentlig konst | Sculptures and public art | 767 | 2018-08-07T14:00:22.854537+03:00 | 2 | 343 | {"fi": ["patsas", "patsaat", "veistos"]} | [767] | 0 | 1403 | 482 | 488 | 6 | ||||||||||||||||||||||||||||||||
5 | [6] | Asumisoikeusasuminen | Bostadsrättsbostäder | Right-of-occupancy housing | 76 | 2018-08-07T14:00:21.249052+03:00 | 2 | 2 | {} | [76] | 0 | 1400 | 331 | 1108 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
166 | [] | Verotoimistot | Skattebyråer | Tax offices | 775 | 2018-08-07T14:00:30.318117+03:00 | 2 | 122 | {} | [775] | 0 | 1401 | 1 | 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 | |||||||||||||||||||||||||||||||||
305 | [] | Viestintä | Kommunikation | Communications | 784 | 2018-08-07T14:00:22.528397+03:00 | 2 | 221 | {} | [784] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
27 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:21.755624+03:00 | 2 | 24 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
7 | [] | Asuntotuotanto | Bostadsproduktion | Housing production | 79 | 2018-08-07T14:00:21.261214+03:00 | 2 | 2 | {} | [79] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
1084 | [] | Yhteiskalliosuojat | Gemensamma bergskyddsrum | Shared ground shelters | 808 | 2018-08-07T14:00:29.944094+03:00 | 2 | 1083 | {} | [808] | 0 | 1061 | 29 | 29 | |||||||||||||||||||||||||||||||||
983 | [] | Yksityisen hoidon tuki | Privatvårdsstöd | Support for private care | 811 | 2018-08-07T14:00:29.020270+03:00 | 2 | 868 | {} | [811] | 0 | 1405 | 111 | 118 | 7 | ||||||||||||||||||||||||||||||||
1086 | [] | Yleiset väestönsuojat | Allmänna befolkningsskyddsrum | General public shelters | 815 | 2018-08-07T14:00:29.980338+03:00 | 2 | 1083 | {} | [815] | 0 | 1061 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
94 | [] | Yleisövessat | Allmänna toaletter | Public toilets | 819 | 2018-10-25T08:00:06.064613+03:00 | 2 | 1 | {} | [819] | 0 | 1400 | 39 | 39 | |||||||||||||||||||||||||||||||||
1010 | [] | Yliopistolliset sairaalat | Universitetssjukhus | University hospitals | 820 | 2018-08-07T14:00:29.314677+03:00 | 2 | 1009 | {} | [820] | 0 | 986 | 18 | 31 | 1 | 1 | 4 | 2 | 3 | 2 | |||||||||||||||||||||||||||
97 | [98, 99] | Ympäristön hoito | Miljövård | Maintenance of the environment | 825 | 2018-08-07T14:00:21.535829+03:00 | 2 | 1 | {} | [825] | 0 | 1400 | 2 | 3 | 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 | |||||||||||||||||||||||||||||||||
101 | [] | Ympäristöneuvonta | Miljörådgivning | Environmental information | 827 | 2018-08-07T14:00:21.561444+03:00 | 2 | 1 | {} | [827] | 0 | 1400 | 1 | 5 | 3 | 1 | |||||||||||||||||||||||||||||||
102 | [] | Ympäristöohjelmat | Miljöprogram | Environmental programmes | 829 | 2018-08-07T14:00:21.567791+03:00 | 2 | 1 | {} | [829] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
115 | [] | Ympäristötutkimus ja tilastointi | Miljöforskning och statistikförning | Environmental research and compilation of statistics | 830 | 2018-08-07T14:00:21.637464+03:00 | 2 | 1 | {} | [830] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2011 | [] | Ehkäisevä toimeentulotuki | Förebyggande utkomststöd | Preventive social assistance | 840 | 2018-08-07T14:00:28.099014+03:00 | 2 | 839 | {} | [840] | 0 | 783 | 7 | 8 | 1 | ||||||||||||||||||||||||||||||||
2012 | [] | Täydentävä toimeentulotuki | Kompletterande utkomststöd | Supplementary social assistance | 841 | 2018-08-07T14:00:28.105801+03:00 | 2 | 839 | {} | [841] | 0 | 783 | 7 | 9 | 1 | 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 |
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 );