service
735 rows where period_enabled = 0 sorted by name_sv
This data as json, CSV (advanced)
Suggested facets: keywords, root_service_node, unit_count_municipality_sipoo, unit_count_municipality_null, unit_count_municipality_nurmijärvi, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_mäntsälä, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava
id | name_fi | name_sv ▼ | name_en | period_enabled | clarification_enabled | keywords | root_service_node | 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_null | unit_count_municipality_nurmijärvi | unit_count_municipality_virolahti | unit_count_municipality_pornainen | unit_count_municipality_hämeenlinna | unit_count_municipality_salo | 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_kotka | unit_count_municipality_askola | 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_karkkila | unit_count_municipality_järvenpää | unit_count_municipality_kerava | unit_count_municipality_pyhtää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
286 | Kelan etuudet | FPA:s förmåner | Kela benefits | 0 | 0 | {} | 1401 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
877 | Hitas-asunnot | Hitas-bostäder | Hitas owner-occupied housing | 0 | 0 | {} | 1400 | 399 | 399 | |||||||||||||||||||||||||||||||||
848 | tietotekniikkaneuvonta (opiskelijoille) | IT rådgivning för studenter | IT consultancy for students | 0 | 0 | {} | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
139 | ELY-keskukset | NTM-centraler | ELY Centres | 0 | 0 | {} | 1401 | 0 | ||||||||||||||||||||||||||||||||||
634 | sortti-asemat | Sortti-stationer | sortti recycling stations | 0 | 0 | {} | 1400 | 0 | ||||||||||||||||||||||||||||||||||
45 | akkujen keräys | ackumulatorinsamling | car battery recycling | 0 | 0 | {"fi": ["akut"]} | 1400 | 34 | 79 | 18 | 26 | 1 | ||||||||||||||||||||||||||||||
46 | akuuttipsykiatria | akutpsykiatri | acute psychiatry | 0 | 0 | {} | 986 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
154 | ensihoito | akutvård | emergency care | 0 | 0 | {} | 986 | 0 | ||||||||||||||||||||||||||||||||||
444 | monitoimihallit ja areenat | allaktivitetshallar och arenor | multipurpose halls/arenas | 0 | 0 | {} | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
345 | kulttuurin monitoimitalot | allaktivitetshus för kultur | multi-functional culture venues | 0 | 0 | {} | 1403 | 8 | 18 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||
442 | monikäyttöalueet, joilla on virkistyspalveluita | allaktivitetsområden med rekreationstjänster | multipurpose areas with recreational services | 0 | 0 | {} | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
208 | jokamies- ja rallicrossradat | allemans- och rallycrossbanor | everyman racing and rallycross tracks | 0 | 0 | {} | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
815 | yleiset väestönsuojat | allmänna befolkningsskyddsrum | general public shelters | 0 | 0 | {} | 1061 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
813 | yleiset kirjastot | allmänna bibliotek | public libraries | 0 | 0 | {"fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"], "en": ["library", "libraries"]} | 1403 | 39 | 71 | 20 | 11 | 1 | ||||||||||||||||||||||||||||||
814 | yleiset pysäköintialueet | allmänna parkeringsområden | public parking lots | 0 | 0 | {} | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
819 | yleisövessat | allmänna toaletter | public toilets | 0 | 0 | {} | 1400 | 39 | 39 | |||||||||||||||||||||||||||||||||
845 | tapahtumien järjestäminen | anordnande av evenemang | organising events | 0 | 0 | {} | 1403 | 2 | 6 | 3 | 1 | |||||||||||||||||||||||||||||||
195 | hissien hankinta (vanhat kerrostalot) | anskaffning av hissar (gamla höghus) | lift procurement (old residential buildings) | 0 | 0 | {} | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
368 | laitoskirjastot | anstaltsbibliotek | institutional libraries | 0 | 0 | {} | 1403 | 8 | 8 | |||||||||||||||||||||||||||||||||
380 | lastensuojelun laitospalvelu | anstaltsservice inom barnskyddet | child welfare services, institutional service | 0 | 0 | {} | 783 | 12 | 37 | 1 | 7 | 16 | 1 | |||||||||||||||||||||||||||||
276 | kehitysvammahuollon laitospalvelu | anstaltsservice inom vården av utvecklingsstörda | services for the intellectually disabled, institutional service | 0 | 0 | {} | 783 | 4 | 4 | |||||||||||||||||||||||||||||||||
758 | vanhuspalvelun laitospalvelu | anstaltsservice inom äldreservicen | services for the elderly, institutional service | 0 | 0 | {} | 783 | 4 | 7 | 2 | 1 | |||||||||||||||||||||||||||||||
725 | työsuhdeasiat | anställningsfrågor | employment matters | 0 | 0 | {} | 1401 | 3 | 5 | 1 | 1 | |||||||||||||||||||||||||||||||
755 | vammaistukien ja -kuntoutuksen hakeminen | ansökning om handikappbidrag och -rehabilitering | disability benefits and services | 0 | 0 | {} | 783 | 3 | 15 | 1 | 2 | 7 | 1 | 1 | ||||||||||||||||||||||||||||
57 | apteekit | apotek | pharmacies | 0 | 0 | {} | 986 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
727 | työväenopiston opetustilat | arbetarinstitutets undervisningslokaler | adult education centre teaching facilities | 0 | 0 | {} | 1087 | 46 | 48 | 1 | 1 | |||||||||||||||||||||||||||||||
723 | työ- ja elinkeinotoimistot | arbets- och näringsbyråer | employment and economic development offices | 0 | 0 | {} | 1401 | 3 | 7 | 1 | 3 | |||||||||||||||||||||||||||||||
250 | katu-, puisto- ja rakennuspiirustusten arkisto | arkiv för gatu-, park- och byggnadsritningar | public works department archive | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
508 | perinnönjakoasiat | arvskiftesfrågor | distribution of estate | 0 | 0 | {} | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
234 | jätteenkäsittelykeskus | avfallshanteringscentral | waste treatment centre | 0 | 0 | {} | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
232 | jäteasemat | avfallsstation | waste station | 0 | 0 | {} | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
478 | ongelmajäteasemat | avfallsstationer för problemavfall | hazardous waste stations | 0 | 0 | {} | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
544 | päihdehuollon katkaisuhoito ja kuntoutus | avgiftning och rehabilitering inom missbrukarvården | substance abuse services, detoxification and rehabilitation treatment | 0 | 0 | {} | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
233 | jäteveden puhdistamot | avloppsreningsverk | wastewater treatment plants | 0 | 0 | {} | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
633 | sopimuspalokunnat | avtalsbrandkårer | volunteer fire departments | 0 | 0 | {} | 1061 | 15 | 23 | 7 | 1 | |||||||||||||||||||||||||||||||
361 | kylpylät | badinrättningar | spas | 0 | 0 | {} | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
647 | sulkapallohallit | badmintonhallar | badminton halls | 0 | 0 | {} | 1403 | 9 | 18 | 5 | 4 | |||||||||||||||||||||||||||||||
730 | uimapaikat | badplatser | unsupervised public beaches | 0 | 0 | {} | 1403 | 14 | 48 | 4 | 22 | 4 | 4 | |||||||||||||||||||||||||||||
731 | uimarannat | badstränder | supervised public beaches | 0 | 0 | {} | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
128 | bänditoiminta tai -tila (nuorten harrastustila) | bandverksamhet eller bandlokal (fritidslokal för ungdomar) | band activity or practice space (youth recreational facility) | 0 | 0 | {} | 1403 | 2 | 12 | 5 | 5 | |||||||||||||||||||||||||||||||
573 | ratagolf | bangolf | minigolf course | 0 | 0 | {} | 1403 | 7 | 18 | 7 | 4 | |||||||||||||||||||||||||||||||
166 | esteratsastuskentät | banhoppningsbanor | show jumping fields | 0 | 0 | {} | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
514 | pikaluisteluradat | banor för hastighetsåkning på skridskor | speed-skating tracks | 0 | 0 | {} | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
869 | baarit ja yöelämä | barer och nattliv | bars and nightlife | 0 | 0 | {} | 1403 | 179 | 181 | 2 | ||||||||||||||||||||||||||||||||
379 | lastenneuvolat | barnrådgivningar | child health clinics | 0 | 0 | {} | 986 | 22 | 47 | 14 | 10 | 1 | ||||||||||||||||||||||||||||||
331 | koripallokentät | basketplaner | basketball courts | 0 | 0 | {} | 1403 | 155 | 258 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
497 | paristonkeräys | batteriinsamling | small battery recycling | 0 | 0 | {"fi": ["paristot"]} | 1400 | 16 | 46 | 12 | 18 | |||||||||||||||||||||||||||||||
125 | beachvolleykentät | beachvolleyplaner | beach volleyball courts | 0 | 0 | {} | 1403 | 39 | 85 | 27 | 18 | 1 | ||||||||||||||||||||||||||||||
805 | väestöhälyttimet | befolkningslarm | public alarm systems | 0 | 0 | {} | 1061 | 38 | 38 | |||||||||||||||||||||||||||||||||
255 | kaupanvahvistus | bestyrkande av köp | public purchase witnessing | 0 | 0 | {} | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
804 | vuokrattavat tilaussaunat | beställningsbastur för uthyrning | saunas for rent | 0 | 0 | {} | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
313 | kirjastot (työväenopisto) | bibliotek (arbetarinstitut) | libraries (adult education centre) | 0 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
878 | oppilaitoskirjastot | bibliotek vid läroanstalter | libraries at educational institutions | 0 | 0 | {} | 1403 | 0 | ||||||||||||||||||||||||||||||||||
359 | kuvataide (nuorten harrastustila) | bildkonst (fritidslokal för ungdomar) | visual arts (youth recreational facility) | 0 | 0 | {} | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
126 | biljardi (nuorten harrastustila) | biljard (fritidslokal för ungdomar) | billiards (youth recreational facility) | 0 | 0 | {} | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
403 | lipunmyynti (eläintarha) | biljettförsäljning (djurpark) | ticket sales (zoo) | 0 | 0 | {} | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
405 | lipunmyynti (tapahtumat) | biljettförsäljning (evenemang) | ticket sales (events) | 0 | 0 | {} | 1403 | 5 | 13 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
404 | lipunmyynti (joukkoliikenne) | biljettförsäljning (kollektivtrafik) | ticket sales (public transport) | 0 | 0 | {} | 1402 | 4 | 8 | 3 | 1 | |||||||||||||||||||||||||||||||
431 | matkalippujen tarkastus | biljettkontroll | ticket inspection | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
885 | yhteiskäyttöautojen pysäköintipaikat | bilpoolparkering | parking for car share vehicles | 0 | 0 | {} | 1402 | 22 | 22 | |||||||||||||||||||||||||||||||||
138 | elokuvateatterit | biografer | cinemas | 0 | 0 | {} | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
511 | pesäpallostadionit | bobollsstadion | Finnish baseball stadiums | 0 | 0 | {} | 1403 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
77 | asumisterveys (ympäristöterveydenhuolto) | boendehälsa (miljöhälsovård) | housing health (environmental health care) | 0 | 0 | {} | 1400 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
73 | asukaspysäköintitunnukset | boendeparkeringstillstånd | resident parking permits | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
857 | mielenterveyskuntoutujien asumispalvelut | boendetjänster för mentalvårdsklienter | residential services for mental health clients | 0 | 0 | {} | 783 | 6 | 14 | 8 | ||||||||||||||||||||||||||||||||
746 | vammaispalvelun asumispalvelut | boendetjänster inom handikappservicen | services for the disabled, residential services | 0 | 0 | {} | 783 | 7 | 24 | 1 | 3 | 13 | ||||||||||||||||||||||||||||||
543 | päihdehuollon asumispalvelut | boendetjänster inom missbrukarvården | substance abuse services, residential services | 0 | 0 | {} | 783 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
275 | kehitysvammahuollon asumispalvelut | boendetjänster inom vården av utvecklingsstörda | services for the intellectually disabled, residential services | 0 | 0 | {} | 783 | 39 | 71 | 9 | 21 | 1 | 1 | |||||||||||||||||||||||||||||
312 | kirjastoautopalvelut | bokbussar | mobile libraries | 0 | 0 | {} | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
311 | kirjastoautopysäkit | bokbussarnas hållplatser | mobile library stops | 0 | 0 | {} | 0 | |||||||||||||||||||||||||||||||||||
495 | pallokentät | bollplaner | ball games courts | 0 | 0 | {} | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
554 | pöytäfutis (nuorten harrastustila) | bordsfotboll (fritidslokal för ungdomar) | table football (youth recreational facility) | 0 | 0 | {} | 1403 | 11 | 10 | 1 | ||||||||||||||||||||||||||||||||
555 | pöytäjääkiekko (nuorten harrastustila) | bordshockey (fritidslokal för ungdomar) | table hockey (youth recreational facility) | 0 | 0 | {} | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
75 | asumisen tuet | bostadsbidrag | housing allowances | 0 | 0 | {} | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
79 | asuntotuotanto | bostadsproduktion | housing production | 0 | 0 | {} | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
76 | asumisoikeusasuminen | bostadsrättsboende | right-of-occupancy housing | 0 | 0 | {} | 1400 | 330 | 1107 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
248 | kasvitieteelliset puutarhat | botaniska trädgårdar | botanic gardens | 0 | 0 | {} | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
285 | keilahallit | bowlinghallar | bowling alleys | 0 | 0 | {} | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
387 | lautapelit (nuorten harrastustila) | brädspel (fritidslokal för ungdomar) | board games (youth recreational facility) | 0 | 0 | {} | 1403 | 14 | 13 | 1 | ||||||||||||||||||||||||||||||||
584 | rintasyövän seulontatutkimukset | bröstcancerscreeningar | breast cancer screening | 0 | 0 | {} | 986 | 0 | ||||||||||||||||||||||||||||||||||
850 | julkishallinnon talousarviot | budgetar inom den offentliga förvaltningen | public administration budgets | 0 | 0 | {} | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
256 | kaupat ja myymälät | butiker och affärer | shops and outlets | 0 | 0 | {} | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
265 | kaupungin tai kunnan toimitilojen rakennuttaminen | byggande av stadens eller kommunens lokaler | commissioning of city or municipal premises | 0 | 0 | {} | 1400 | 0 | ||||||||||||||||||||||||||||||||||
558 | rakennus- ja toimenpideluvat | bygglov och åtgärdstillstånd | building licences and planning permissions | 0 | 0 | {} | 1400 | 1 | 5 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
559 | rakennusrasitteet | byggnadsservitut | building easements | 0 | 0 | {} | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
561 | rakennusvalvonnan arkisto | byggnadstillsynens arkiv | building control archive | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
563 | rakennusvalvontamittaukset | byggnadstillsynsmätningar | building control measurements | 0 | 0 | {} | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
550 | päivystyksen vuodeosastot | bäddavdelningar inom jourverksamheten | emergency care outpatient wards | 0 | 0 | {} | 986 | 4 | 4 | |||||||||||||||||||||||||||||||||
353 | kuntoutuksen vuodeosastopalvelut | bäddavdelningstjänster inom rehabilitering | rehabilitation inpatient care | 0 | 0 | {} | 986 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
213 | jousiammuntaradat | bågskyttebanor | archery ranges | 0 | 0 | {} | 1403 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
769 | venesatamat | båthamnar | marinas | 0 | 0 | {} | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
847 | venekerhojen venepaikat | båtklubbarnas båtplatser | boat clubs' berths | 0 | 0 | {} | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
239 | kahvilat | caféer | cafés | 0 | 0 | {} | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
390 | leirintäalueet | campingområden | camping sites | 0 | 0 | {} | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
876 | terveys- ja hyvinvointikeskukset | centraler för hälsa och välbefinnande | health and well-being centres | 0 | 0 | {} | 986 | 2 | 11 | 1 | 8 | |||||||||||||||||||||||||||||||
222 | julkishallinnon keskitetyt tietotekniikkapalvelut | centraliserade IT-tjänster inom den offentliga förvaltningen | centralised public administration information technology services | 0 | 0 | {} | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
290 | keskusvaalilautakunta | centralvalnämnd | central election committee | 0 | 0 | {} | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
450 | moottoriurheilukeskukset | centrum för motorsport | motor sports centres | 0 | 0 | {} | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
710 | tilausliikenne | chartertrafik | charter traffic | 0 | 0 | {} | 1402 | 0 | ||||||||||||||||||||||||||||||||||
628 | siviilivihkiminen | civil vigsel | civil marriage | 0 | 0 | {} | 1401 | 1 | 2 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service] ( [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [id] INTEGER PRIMARY KEY, [period_enabled] INTEGER, [clarification_enabled] INTEGER, [keywords] TEXT, [root_service_node] 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_null] INTEGER, [unit_count_municipality_nurmijärvi] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality_salo] 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] TEXT, [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_kotka] TEXT, [unit_count_municipality_askola] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] TEXT, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] INTEGER, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_pyhtää] TEXT );