service_node
279 rows where level = 2 sorted by unit_count_municipality_espoo
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_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_hyvinkää, 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
23 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:21.732081+03:00 | 2 | 14 | {} | [411] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
26 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:21.749651+03:00 | 2 | 24 | {} | [146] | 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 | |||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||||
58 | [] | Löytötavarapalvelu | Hittegodsservice | Found Property Service | 418 | 2018-08-07T14:00:21.337453+03:00 | 2 | 1 | {} | [418] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
80 | [81, 82, 83, 84] | Torit ja kauppahallit | Torg och saluhallar | Market squares and halls | 2018-08-07T14:00:21.488118+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 19 | 19 | ||||||||||||||||||||||||||||||||||
88 | [] | Mullan myynti ja toimitus | Försäljning och leverans av mylla | Selling and delivering soil | 453 | 2018-08-07T14:00:21.964747+03:00 | 2 | 85 | {} | [453] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
94 | [] | Yleisövessat | Allmänna toaletter | Public toilets | 819 | 2018-10-25T08:00:06.064613+03:00 | 2 | 1 | {} | [819] | 0 | 1400 | 39 | 39 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
126 | [] | Elinkeinoasiat | Näringslivsfrågor | Trade and industry matters | 132 | 2018-08-07T14:00:30.024180+03:00 | 2 | 122 | {} | [132] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
141 | [142, 144, 145] | Markkinointi | Marknadsföring | Marketing | 2018-08-07T14:00:30.127227+03:00 | 2 | 122 | {} | [] | 0 | 1401 | 4 | 7 | 3 | |||||||||||||||||||||||||||||||||
166 | [] | Verotoimistot | Skattebyråer | Tax offices | 775 | 2018-08-07T14:00:30.318117+03:00 | 2 | 122 | {} | [775] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
177 | [] | Hankintapalvelut | Upphandlingstjänster | Procurement services | 217 | 2018-08-07T14:00:30.442764+03:00 | 2 | 171 | {} | [217] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
197 | [2152, 198, 209] | Talous | Ekonomi | Economy | 2018-08-07T14:00:30.559004+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 10 | 10 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
305 | [] | Viestintä | Kommunikation | Communications | 784 | 2018-08-07T14:00:22.528397+03:00 | 2 | 221 | {} | [784] | 0 | 1400 | 1 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
367 | [] | Katutaidepaikat | Platser för gatukonst | Street art locations | 254 | 2018-08-07T14:00:22.877110+03:00 | 2 | 365 | {} | [254] | 0 | 1403 | 12 | 12 | |||||||||||||||||||||||||||||||||
525 | [] | Löytötavarapalvelu | Hittegodsservice | Found Property Service | 418 | 2018-08-07T14:00:25.085327+03:00 | 2 | 512 | {} | [418] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
792 | [] | Lapsiperheiden sosiaaliohjaus | Socialhandledning för barnfamiljer | Social care work for families with children | 373 | 2018-08-07T14:00:27.759985+03:00 | 2 | 791 | {} | [373] | 0 | 783 | 17 | 16 | 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 | ||||||||||||||||||||||||||||||||
795 | [] | Lapsiperheiden lomatoiminta | Semesterverksamhet för barnfamiljer | Vacation activities for families with children | 372 | 2018-08-07T14:00:27.784058+03:00 | 2 | 791 | {} | [372] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
796 | [] | Perheoikeudelliset palvelut | Familjerättsliga tjänster | Services for family law | 505 | 2018-08-07T14:00:27.790684+03:00 | 2 | 791 | {} | [505] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
856 | [] | Sovittelutoiminta | Medlingsverksamhet | Mitigation services | 644 | 2018-08-07T14:00:28.189606+03:00 | 2 | 845 | {} | [644] | 0 | 783 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1013 | [] | Kotisairaalat | Hemsjukhus | Domestic hospitals | 336 | 2018-08-07T14:00:29.340263+03:00 | 2 | 1009 | {} | [336] | 0 | 986 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1015 | [] | Sairaaloiden poliklinikat | Sjukhusens polikliniker | Hospital outpatient clinics | 610 | 2018-08-07T14:00:29.359098+03:00 | 2 | 1009 | {} | [610] | 0 | 986 | 3 | 3 | |||||||||||||||||||||||||||||||||
1020 | [] | Akuuttipsykiatria | Akutpsykiatri | Acute psychiatry | 46 | 2018-08-07T14:00:29.412887+03:00 | 2 | 1019 | {} | [46] | 0 | 986 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
1021 | [] | HUS:n erikoissairaanhoito | HNS:s specialsjukvård | HUS specialised health care | 440 | 2018-08-07T14:00:29.421431+03:00 | 2 | 1019 | {} | [440] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1023 | [] | Psykiatrian poliklinikat | Psykiatriska polikliniker | Psychiatric outpatient clinics | 521 | 2018-08-07T14:00:29.437165+03:00 | 2 | 1019 | {} | [521] | 0 | 986 | 19 | 19 | |||||||||||||||||||||||||||||||||
1025 | [] | Psykiatrinen perhehoito | Psykiatrisk familjevård | Psychiatric family care | 523 | 2018-08-07T14:00:29.453053+03:00 | 2 | 1019 | {} | [523] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1026 | [] | Psykiatrinen päiväsairaala | Psykiatriskt dagsjukhus | Psychiatric day hospital | 524 | 2018-08-07T14:00:29.460729+03:00 | 2 | 1019 | {} | [524] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1027 | [] | Psykoterapia | Psykoterapi | Psychotherapy | 526 | 2018-08-07T14:00:29.469348+03:00 | 2 | 1019 | {} | [526] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1035 | [] | Neurologia | Neurologi | Neurology | 462 | 2018-08-07T14:00:29.539786+03:00 | 2 | 1028 | {} | [462] | 0 | 986 | 6 | 6 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 1 | |||||||||||||||||||||||||||||||
1050 | [] | Potilasasiamies | Patientombudsman | Patient representative | 520 | 2018-08-07T14:00:29.675023+03:00 | 2 | 1048 | {} | [520] | 0 | 986 | 1 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1063 | [] | Maanpuolustusyhdistykset | Försvarsföreningar | National defence associations | 422 | 2018-08-07T14:00:29.780736+03:00 | 2 | 1062 | {} | [422] | 0 | 1061 | 2 | 2 | |||||||||||||||||||||||||||||||||
1067 | [] | Turvallisuuskoulutus | Säkerhetsutbildning | Safety training | 720 | 2018-08-07T14:00:29.819172+03:00 | 2 | 1066 | {} | [720] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1073 | [] | Pelastuskoulu | Räddningsskolan | School of Fire and Rescue Services | 502 | 2018-08-07T14:00:29.866063+03:00 | 2 | 1070 | {} | [502] | 0 | 1061 | 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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1369 | [] | Kuvataidekoulu | Konstskola | School of visual arts | 360 | 2020-11-18T07:30:12.906446+02:00 | 2 | 1360 | {} | [360] | 0 | 1087 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
1370 | [] | Musiikkiopisto | Musikinstitut | Music institute | 456 | 2020-11-18T07:30:12.915030+02:00 | 2 | 1360 | {} | [456] | 0 | 1087 | 20 | 19 | 1 | ||||||||||||||||||||||||||||||||
1374 | [] | Koulukuraattori | Skolkurator | School social worker | 340 | 2018-08-07T14:00:27.634259+03:00 | 2 | 1372 | {} | [340] | 0 | 1087 | 71 | 66 | 5 | ||||||||||||||||||||||||||||||||
1375 | [] | Koulupsykologi | Skolpsykolog | School psychologist | 343 | 2018-08-07T14:00:27.641064+03:00 | 2 | 1372 | {} | [343] | 0 | 1087 | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2157 | [] | Tuki digipelaamisen ja netin liikakäytön ongelmiin | Stöd för överanvändningsproblem av digitala spel och internet | Support for digital gaming and internet over-use problems | 855 | 2018-08-07T14:00:28.074000+03:00 | 2 | 830 | {} | [855] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
2158 | [] | Tuki digipelaamisen ja netin liikakäytön ongelmiin | Stöd för överanvändningsproblem av digitala spel och internet | Support for digital gaming and internet over-use problems | 855 | 2018-08-07T14:00:29.751405+03:00 | 2 | 1051 | {} | [855] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2160 | [] | Mielenterveyskuntoutujien asumispalvelut | Boendetjänster för klienter inom psykrehabilitering | Residential services for mental health rehabilitation clients | 857 | 2018-08-07T14:00:28.137962+03:00 | 2 | 845 | {} | [857] | 0 | 783 | 6 | 14 | 8 | ||||||||||||||||||||||||||||||||
2161 | [] | Palliatiivinen hoito | Palliativ vård | Palliative care | 858 | 2018-08-07T14:00:29.377630+03:00 | 2 | 1009 | {} | [858] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2186 | [] | Ammatilliseen peruskoulutukseen valmentava koulutus - VALMA | Handledande utbildning för grundläggande yrkesutbildning - VALMA | Preparatory education for vocational training - VALMA | 470 | 2018-08-31T16:00:09.222841+03:00 | 2 | 2179 | {} | [470] | 1 | 1087 | 8 | 9 | 1 | ||||||||||||||||||||||||||||||||
2191 | [] | Hitas-asunnot | Hitas-bostäder | Hitas owner-occupied housing | 877 | 2019-03-05T14:30:06.194077+02:00 | 2 | 2 | {} | [877] | 0 | 1400 | 399 | 399 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2212 | [] | Kansalaisopisto | Medborgarinstitut | Community college | 890 | 2020-11-18T07:30:12.923359+02:00 | 2 | 1360 | {} | [890] | 0 | 1087 | 3 | 3 |
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 );