service_node
1,140 rows sorted by name_en
This data as json, CSV (advanced)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
309 | [] | Kaupunginarkiston asiakaspalvelu | Stadsarkivets kundtjänst | City Archives customer service | 65 | 2018-08-07T14:00:24.669496+03:00 | 3 | 307 | {} | [65] | 0 | 1402 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
193 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.534760+03:00 | 3 | 191 | {} | [272] | 0 | 1401 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
759 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.780581+03:00 | 4 | 757 | {} | [272] | 0 | 1401 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
194 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.540753+03:00 | 3 | 191 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
760 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.790348+03:00 | 4 | 757 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 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 | |||||||||||||||||||||||||||||||||
2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
1012 | [] | Kaupunginsairaalat | Stadssjukhus | City hospitals | 264 | 2018-08-07T14:00:29.330351+03:00 | 2 | 1009 | {} | [264] | 0 | 986 | 9 | 11 | 1 | 1 | |||||||||||||||||||||||||||||||
10 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:21.280357+03:00 | 3 | 8 | {} | [267] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
136 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:30.094025+03:00 | 3 | 134 | {} | [267] | 0 | 1401 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
248 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:22.155735+03:00 | 4 | 245 | {} | [267] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
9 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:21.273119+03:00 | 3 | 8 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
135 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:30.087071+03:00 | 3 | 134 | {} | [268] | 0 | 1401 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
247 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:22.149025+03:00 | 4 | 245 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
6 | [] | Kaupungin asumisoikeusasunnot | stadens bostadsrättsbostäder | City's right of residence apartments | 261 | 2018-08-07T14:00:21.255121+03:00 | 3 | 5 | {} | [261] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
774 | [] | Siviilivihkiminen | Civil vigsel | Civil marriage | 628 | 2018-08-07T14:00:30.898033+03:00 | 4 | 770 | {} | [628] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
254 | [] | Siivouspalvelut | Städningsservice | Cleaning services | 621 | 2018-08-07T14:00:22.196172+03:00 | 3 | 231 | {} | [621] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||||
573 | [] | Kiipeilykallio | Klätterberg | Climbing rock | 306 | 2018-08-07T14:00:23.375633+03:00 | 4 | 572 | {} | [306] | 0 | 1403 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
572 | [573, 574] | Kiipeilypaikat | Klättringsplatser | Climbing venues | 2018-08-07T14:00:23.370651+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 5 | 14 | 6 | 3 | ||||||||||||||||||||||||||||||||
404 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 289 | 2018-08-07T14:00:22.983998+03:00 | 3 | 368 | {} | [289] | 0 | 1403 | 22 | 14 | 7 | 1 | |||||||||||||||||||||||||||||||
978 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 288 | 2019-03-05T14:30:09.661194+02:00 | 3 | 975 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [288] | 0 | 1405 | 94 | 143 | 20 | 28 | 1 | ||||||||||||||||||||||||||||||
160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
267 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:22.293996+03:00 | 5 | 265 | {} | [494] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
157 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:30.231632+03:00 | 4 | 156 | {} | [393] | 0 | 1401 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
2021 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:22.272146+03:00 | 5 | 265 | {} | [393] | 0 | 1400 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
195 | [] | Lautakunnat ja johtokunnat | Nämnder och direktioner | Committees and boards | 386 | 2018-08-07T14:00:30.546848+03:00 | 3 | 191 | {} | [386] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
761 | [] | Lautakunnat ja johtokunnat | Nämnder och direktioner | Committees and boards | 386 | 2018-08-07T14:00:30.800171+03:00 | 4 | 757 | {} | [386] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
305 | [] | Viestintä | Kommunikation | Communications | 784 | 2018-08-07T14:00:22.528397+03:00 | 2 | 221 | {} | [784] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
2002 | [] | Viestintä | Kommunikation | Communications | 488 | 2018-08-07T14:00:30.436273+03:00 | 3 | 172 | {} | [488] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
230 | [] | Viestintä ja vuorovaikutus | Kommunikation och påverkan | Communications and interaction | 785 | 2018-08-07T14:00:22.052241+03:00 | 3 | 222 | {} | [785] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
2212 | [] | Kansalaisopisto | Medborgarinstitut | Community college | 890 | 2020-11-18T07:30:12.923359+02:00 | 2 | 1360 | {} | [890] | 0 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
604 | [] | Kilpajäähalli | Tävlingsishall | Competition ice arena | 308 | 2018-08-07T14:00:23.575267+03:00 | 4 | 602 | {} | [308] | 0 | 1403 | 2 | 7 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
333 | [334, 339] | Tietokone ja internet | Dator och internet | Computer and internet | 2018-10-25T08:00:07.342286+03:00 | 3 | 329 | {} | [] | 0 | 1402 | 63 | 67 | 1 | 3 | ||||||||||||||||||||||||||||||||
340 | [] | Kurssimuotoista tietokoneopetusta | Kursformad datorundervisning | Computer guidance courses | 708 | 2018-10-25T08:00:07.368287+03:00 | 5 | 339 | {} | [708] | 0 | 1402 | 15 | 16 | 1 | ||||||||||||||||||||||||||||||||
354 | [] | Konserttitilat | Konsertutrymmen | Concert facilities | 329 | 2018-08-07T14:00:22.610197+03:00 | 3 | 352 | {} | [329] | 0 | 1403 | 33 | 43 | 8 | 1 | 1 | ||||||||||||||||||||||||||||||
410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 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 | |||||||||||||||||||||||||||||
75 | [] | Katu-, maa- ja viherrakentamispalvelut | Tjänster inom gatu-, mark- och grönbyggnad | Construction services for streets, land and parks | 249 | 2018-08-07T14:00:21.457195+03:00 | 3 | 74 | {} | [249] | 0 | 1400 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
535 | [] | Katu-, maa- ja viherrakentamispalvelut | Tjänster inom gatu-, mark- och grönbyggnad | Construction services for streets, land and parks | 249 | 2018-08-07T14:00:25.151160+03:00 | 3 | 534 | {} | [249] | 0 | 1402 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
777 | [] | Kuluttajansuoja ja neuvonta | Konsumentskydd och rådgivning | Consumer protection and advice | 347 | 2018-08-07T14:00:30.921943+03:00 | 3 | 769 | {} | [347] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
281 | [] | Jatkuva valvonta | Kontinuerlig tillsyn | Continuous monitoring | 562 | 2018-08-07T14:00:22.381961+03:00 | 4 | 279 | {} | [562] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
701 | [] | Ruoanlaittopaikka | Matlagningsplats | Cooking facilities | 586 | 2018-08-07T14:00:24.282789+03:00 | 4 | 695 | {} | [586] | 0 | 1403 | 17 | 77 | 6 | 8 | 4 | 33 | 9 | ||||||||||||||||||||||||||||
437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
44 | [] | Pahvinkeräys | Insamling av wellpapp | Corrugated cardboard recycling | 491 | 2018-08-07T14:00:21.860147+03:00 | 3 | 34 | {} | [491] | 0 | 1400 | 2 | 7 | 1 | 2 | 2 | ||||||||||||||||||||||||||||||
2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
196 | [] | Valtuustoryhmät, kansalaislähetystöt | Stadsfullmäktigegrupper, medborgardelegationer | Council groups, public delegations | 743 | 2018-08-07T14:00:30.552905+03:00 | 3 | 191 | {} | [743] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
762 | [] | Valtuustoryhmät, kansalaislähetystöt | Stadsfullmäktigegrupper, medborgardelegationer | Council groups, public delegations | 743 | 2018-08-07T14:00:30.809629+03:00 | 4 | 757 | {} | [743] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
567 | [568, 569] | Katetut talviurheilupaikat | Vintersportplatser under tak | Covered winter sports facilities | 2018-08-07T14:00:23.339639+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 2 | ||||||||||||||||||||||||||||||||||
585 | [] | Maastopyöräilyreitti | Mountainbikeled | Cross-country biking route | 425 | 2018-08-07T14:00:23.448007+03:00 | 4 | 577 | {} | [425] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
592 | [593, 594, 595, 596] | Maastohiihtokeskukset | Längdåkningscentra | Cross-country ski resorts | 2018-08-07T14:00:23.496608+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 3 | 8 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
363 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:22.670926+03:00 | 3 | 362 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
746 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:24.561434+03:00 | 4 | 745 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
343 | [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] | Kulttuuri ja vapaa-aika | Kultur och fritid | Culture and leisure | 2018-08-07T14:00:22.539281+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1745 | 2452 | 1 | 1 | 1 | 1 | 8 | 1 | 2 | 4 | 2 | 382 | 286 | 1 | 13 | 4 | ||||||||||||||||||||
1403 | [343, 551, 717, 365] | Kulttuuri, liikunta ja vapaa-aika | Kultur, motion och fritid | Culture, sports and leisure | 2018-08-07T14:00:22.534057+03:00 | 0 | {} | [] | 0 | 1403 | 5769 | 8871 | 1 | 18 | 1 | 1 | 1 | 12 | 1 | 20 | 3 | 1 | 6 | 14 | 1685 | 1 | 1238 | 1 | 37 | 57 | 4 | ||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2136 | [] | Perusopetuksen neuvonta | Kundbetjäning och rådgivning (grundläggande utbildning) | Customer service and information (basic education) | 70 | 2018-08-07T14:00:24.736470+03:00 | 4 | 317 | {} | [70] | 0 | 1402 | 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 | |||||||||||||||||||||||||||||||||
2135 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:24.729525+03:00 | 4 | 317 | {} | [844] | 0 | 1402 | 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 | ||||||||||||||||||||||||||||||||
2137 | [] | Lukiokoulutuksen neuvonta | Kundbetjäning och rådgivning (gymnasieutbildning) | Customer service and information (general upper secondary education) | 69 | 2018-08-07T14:00:24.743644+03:00 | 4 | 317 | {} | [69] | 0 | 1402 | 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 | ||||||||||||||||||||||||||||||||
2138 | [] | Ammatillisen koulutuksen neuvonta | Kundbetjäning och rådgivning (yrkesutbildning) | Customer service and information (vocational education and training) | 68 | 2018-08-07T14:00:24.750620+03:00 | 4 | 317 | {} | [68] | 0 | 1402 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
514 | [] | Asiakaspalvelu ja lipunmyynti | Kundtjänst och biljettförsäljning | Customer service and ticket sales | 63+404 | 2018-10-24T20:00:07.778946+03:00 | 3 | 513 | {} | [404, 63] | 0 | 1402 | 5 | 11 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
223 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 64 | 2018-08-07T14:00:22.006084+03:00 | 3 | 222 | {} | [64] | 0 | 1400 | 3 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||
273 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:22.333741+03:00 | 4 | 272 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1362 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 665*66 | 2020-11-18T07:30:12.851359+02:00 | 3 | 1361 | {} | [665, 66] | 0 | 1087 | 7 | 9 | 1 | 1 | |||||||||||||||||||||||||||||||
1366 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 605*66 | 2020-11-18T07:30:12.883321+02:00 | 3 | 1365 | {} | [605, 66] | 0 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
2203 | [] | Asiakaspalvelu | Kundbetjäning | Customer services | 884 | 2019-08-23T14:30:13.757143+03:00 | 2 | 171 | {} | [884] | 0 | 1401 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1080 | [1081] | Tulli | Tullen | Customs | 2018-08-07T14:00:29.915254+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 4 | 7 | 1 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
650 | [] | Pyöräilyalue | Cykelåkningsområde | Cycling area | 538 | 2018-08-07T14:00:23.912521+03:00 | 4 | 646 | {} | [538] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
473 | [] | Tanssi | Dans | Dance | 685 | 2018-08-07T14:00:23.163347+03:00 | 3 | 368 | {} | [685] | 0 | 1403 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
359 | [] | Tanssitilat | Dansutrymmen | Dance facilities | 686 | 2018-08-07T14:00:22.643791+03:00 | 3 | 352 | {} | [686] | 0 | 1403 | 12 | 15 | 1 | 2 | |||||||||||||||||||||||||||||||
630 | [] | Tanssitila | Utrymme för dans | Dance studio | 687 | 2018-08-07T14:00:23.767727+03:00 | 4 | 624 | {} | [687] | 0 | 1403 | 58 | 71 | 10 | 3 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
868 | [2029, 975, 961, 985, 869, 983] | Lasten päivähoito | Barndagvård | Day care | 2020-03-06T18:32:08.678128+02:00 | 1 | 1405 | {} | [] | 0 | 1405 | 675 | 1264 | 365 | 212 | 12 | |||||||||||||||||||||||||||||||
317 | [2138, 2135, 2137, 2136] | Kasvatuksen ja koulutuksen neuvonta | Rådgivning om fostran och utbildning | Day care and education information and advice | 2018-08-07T14:00:24.723868+03:00 | 3 | 314 | {} | [] | 0 | 1402 | 4 | 6 | 2 | |||||||||||||||||||||||||||||||||
1378 | [1381, 2080, 1380, 1379] | Kasvatuksen ja koulutuksen neuvonta | Rådgivning om fostran och utbildning | Day care and education information and advice | 2018-08-07T14:00:27.660874+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 4 | 6 | 2 | |||||||||||||||||||||||||||||||||
2163 | [] | Päiväkotiruokailu | Daghem måltider | Day care centre meals | 860 | 2018-08-07T14:00:29.039470+03:00 | 1 | 1405 | {} | [860] | 0 | 1405 | 274 | 274 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
897 | [903, 898] | Arabiankielinen päivähoito | Arabiskspråkig dagvård | Day care in Arabic | 58 | 2018-08-07T14:00:28.436562+03:00 | 3 | 869 | {} | [58] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
905 | [911, 906] | Englanninkielinen päivähoito | Engelskspråkig dagvård | Day care in English | 151 | 2018-08-07T14:00:28.480764+03:00 | 3 | 869 | {} | [151] | 0 | 1405 | 39 | 62 | 21 | 1 | 1 | ||||||||||||||||||||||||||||||
953 | [959, 954] | Vironkielinen päivähoito | Estniskspråkig dagvård | Day care in Estonian | 795 | 2018-08-07T14:00:28.794858+03:00 | 3 | 869 | {} | [795] | 0 | 1405 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
870 | [875, 879, 872, 877, 876, 880, 871, 874] | Suomenkielinen päivähoito | Finskspråkig dagvård | Day care in Finnish | 663 | 2019-03-05T14:30:09.339119+02:00 | 3 | 869 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [663] | 0 | 1405 | 389 | 847 | 278 | 174 | 6 | ||||||||||||||||||||||||||||||
929 | [935, 930] | Ranskankielinen päivähoito | Franskspråkig dagvård | Day care in French | 569 | 2018-08-07T14:00:28.623079+03:00 | 3 | 869 | {} | [569] | 0 | 1405 | 6 | 6 |
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 );