service_node
383 rows where level = 3 sorted by name_en
This data as json, CSV (advanced)
Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_järvenpää
last_modified_time (date) ✖
- 2018-08-07 321
- 2018-10-25 18
- 2020-06-09 8
- 2019-03-05 6
- 2020-11-18 5
- 2018-10-24 3
- 2020-12-02 3
- 2018-11-20 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-06-20 2
- 2020-05-08 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-22 1
- 2019-09-02 1
- 2019-10-22 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-10-02 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2207 | [] | Esteettömät autopaikat kadulla | P-plats för personer med rörelsehinder bredvid gatan | Accessible parking space along street | 887 | 2020-02-12T09:30:09.092906+02:00 | 3 | 526 | {} | [887] | 0 | 1402 | 94 | 94 | |||||||||||||||||||||||||||||||||
233 | [234, 235, 237] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:22.072503+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 3 | 6 | 3 | |||||||||||||||||||||||||||||||||
173 | [2004, 2003, 2005] | Hallinnon toimipisteet | Förvaltningens verksamhetsställen | Administrative offices | 2018-08-07T14:00:30.377254+03:00 | 3 | 172 | {} | [] | 0 | 1401 | 56 | 67 | 1 | 2 | 7 | 1 | ||||||||||||||||||||||||||||||
169 | [] | Maahanmuuttajayrittäjien neuvonta | Rådgivning för invandrarföretagare | Advice for immigrant entrepreneurs | 421 | 2018-08-07T14:00:30.346437+03:00 | 3 | 167 | {} | [421] | 0 | 1401 | 4 | 6 | 1 | 1 | |||||||||||||||||||||||||||||||
168 | [] | Alkavien yrittäjien neuvonta | Rådgivning för nya företagare | Advice for start-up entrepreneurs | 48 | 2018-08-07T14:00:30.339989+03:00 | 3 | 167 | {} | [48] | 0 | 1401 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
1181 | [1186, 1183, 1182, 2134, 1184] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 656 | 2018-08-07T14:00:26.201113+03:00 | 3 | 1098 | {} | [656] | 1 | 1087 | 238 | 240 | 2 | ||||||||||||||||||||||||||||||||
1249 | [1251, 1250, 1252] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 596 | 2018-08-07T14:00:26.711531+03:00 | 3 | 1187 | {} | [596] | 1 | 1087 | 24 | 39 | 11 | 4 | |||||||||||||||||||||||||||||||
979 | [] | Koululaisten iltapäivätoiminnan ryhmät | Eftermiddagsverksamhet för skolelever | Afternoon activities for schoolchildren | 341 | 2018-08-07T14:00:28.994886+03:00 | 3 | 975 | {} | [341] | 1 | 1405 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
977 | [] | Kehitysvammaisten iltapäivätoiminnan ryhmät | Eftermiddagsverksamhet för utvecklingsstörda | Afternoon activities for the intellectually disabled | 80 | 2018-08-07T14:00:28.982154+03:00 | 3 | 975 | {} | [80] | 1 | 1405 | 33 | 33 | |||||||||||||||||||||||||||||||||
107 | [] | Eläinsuojelu | Djurskydd | Animal protection | 141 | 2018-08-07T14:00:21.598706+03:00 | 3 | 103 | {} | [141] | 0 | 1400 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
364 | [] | Taidemuseo | Konstmuseer | Art museums | 672 | 2018-08-07T14:00:22.677535+03:00 | 3 | 362 | {} | [672] | 0 | 1403 | 61 | 88 | 1 | 4 | 1 | 10 | 6 | 1 | 4 | ||||||||||||||||||||||||||
419 | [] | Kädentaidot | Hantverk | Arts and Crafts | 362 | 2018-08-07T14:00:23.026643+03:00 | 3 | 368 | {} | [362] | 0 | 1403 | 3 | 15 | 10 | 2 | |||||||||||||||||||||||||||||||
209 | [210, 211, 213] | Varainhallinta | Finansförvaltning | Assets management | 2018-08-07T14:00:30.654818+03:00 | 3 | 197 | {} | [] | 0 | 1401 | 3 | 3 | ||||||||||||||||||||||||||||||||||
663 | [664, 665] | Yleisurheilukentät ja -paikat | Planer och platser för friidrott | Athletics fields and venues | 2018-08-07T14:00:24.019648+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 36 | 59 | 20 | 3 | ||||||||||||||||||||||||||||||||
654 | [655, 656, 657, 658, 659, 660, 661, 662] | Pallokentät | Bollplaner | Ball games courts | 2018-08-07T14:00:23.947305+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 697 | 1266 | 1 | 283 | 273 | 1 | 11 | |||||||||||||||||||||||||||||
2223 | [] | Senioripalloilu | Bollsport för seniorer | Ball games for seniors | 899 | 2020-06-09T15:30:11.384469+03:00 | 3 | 2217 | {} | [899] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
378 | [] | Bänditoiminta/-tila | Bandverksamhet eller bandlokal | Band activity or practice space | 128 | 2018-08-07T14:00:22.924860+03:00 | 3 | 368 | {} | [128] | 0 | 1403 | 2 | 12 | 5 | 5 | |||||||||||||||||||||||||||||||
508 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.820471+03:00 | 3 | 505 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
737 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:24.498919+03:00 | 3 | 718 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
2174 | [] | Baarit ja yöelämä | Barer och nattliv | Bars and nightlife | 869 | 2018-08-07T14:00:24.408116+03:00 | 3 | 718 | {} | [869] | 0 | 1403 | 179 | 181 | 2 | ||||||||||||||||||||||||||||||||
1338 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 652 | 2018-08-07T14:00:27.364989+03:00 | 3 | 1336 | {} | [652] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1345 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 592 | 2018-08-07T14:00:27.412986+03:00 | 3 | 1343 | {} | [592] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1099 | [1101, 1102, 2170, 1103, 1100, 1104] | Luokkien 1-6 perusopetus | Grundläggande utbildning, årskurserna 1-6 | Basic education, grades 1-6 | 2018-10-25T08:00:07.589100+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 110 | 212 | 62 | 39 | 1 | |||||||||||||||||||||||||||||||
1188 | [1189] | Luokkien 1-6 perusopetus | Grundläggande utbildning, årskurserna 1-6 | Basic education, grades 1-6 | 2018-10-25T08:00:08.198860+03:00 | 3 | 1187 | {} | [] | 0 | 1087 | 21 | 37 | 12 | 4 | ||||||||||||||||||||||||||||||||
1109 | [1111, 1112, 2171, 1113, 1110, 1114] | Luokkien 7-9 perusopetus | Grundläggande utbildning, årskurserna 7-9 | Basic education, grades 7-9 | 2018-10-25T08:00:07.629842+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 69 | 121 | 1 | 27 | 23 | 1 | ||||||||||||||||||||||||||||||
1190 | [1191] | Luokkien 7-9 perusopetus | Grundläggande utbildning, årskurserna 7-9 | Basic education, grades 7-9 | 2018-10-25T08:00:08.207545+03:00 | 3 | 1187 | {} | [] | 0 | 1087 | 7 | 12 | 4 | 1 | ||||||||||||||||||||||||||||||||
453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
424 | [] | Lautapelit | Brädspel | Board games | 387 | 2018-08-07T14:00:23.039435+03:00 | 3 | 368 | {} | [387] | 0 | 1403 | 14 | 13 | 1 | ||||||||||||||||||||||||||||||||
547 | [548, 2199, 549, 2143, 2142] | Veneily | Båtsport | Boating | 2018-08-07T14:00:25.237133+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 206 | 262 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
677 | [681, 682, 683] | Veneurheilupaikat | Platser för båtsport | Boating sports facilities | 2018-08-07T14:00:24.115410+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 4 | 5 | 1 | |||||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
449 | [] | Poikakerho / poikaryhmät | Pojkklubb / pojkgrupper | Boys' club / Boy groups | 518 | 2018-08-07T14:00:23.107321+03:00 | 3 | 368 | {} | [518] | 0 | 1403 | 1 | 16 | 14 | 1 | |||||||||||||||||||||||||||||||
279 | [281, 282, 283, 284, 285] | Rakennusvalvonta | Byggnadstillsyn | Building Control | 2018-08-07T14:00:22.376681+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 3 | 11 | 2 | 5 | 1 | |||||||||||||||||||||||||||||||
312 | [] | Rakennusvalvonnan arkisto | Byggnadstillsynsverkets arkiv | Building Control archive | 561 | 2018-08-07T14:00:24.689378+03:00 | 3 | 307 | {} | [561] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
426 | [] | Leiritoiminta | Lägerverksamhet | Camping activities | 391 | 2018-08-07T14:00:23.046486+03:00 | 3 | 368 | {} | [391] | 0 | 1403 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
35 | [] | Akkujen keräys | Återvinning av bilbatterier | Car battery recycling | 45 | 2018-08-07T14:00:21.789985+03:00 | 3 | 34 | {"fi": ["akut"]} | [45] | 0 | 1400 | 34 | 79 | 18 | 26 | 1 | ||||||||||||||||||||||||||||||
38 | [] | Kartonginkeräys | Insamling av kartong | Cardboard recycling | 246 | 2018-08-07T14:00:21.813795+03:00 | 3 | 34 | {"fi": ["kartonki"]} | [246] | 0 | 1400 | 54 | 140 | 46 | 36 | 4 | ||||||||||||||||||||||||||||||
253 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:22.189946+03:00 | 3 | 231 | {} | [467] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
254 | [] | Siivouspalvelut | Städningsservice | Cleaning services | 621 | 2018-08-07T14:00:22.196172+03:00 | 3 | 231 | {} | [621] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
223 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 64 | 2018-08-07T14:00:22.006084+03:00 | 3 | 222 | {} | [64] | 0 | 1400 | 3 | 1 | 1 | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
937 | [938] | Saksankielinen päivähoito | Tyskspråkig dagvård | Day care in German | 614 | 2018-08-07T14:00:28.671882+03:00 | 3 | 869 | {} | [614] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
921 | [922] | Hepreankielinen päivähoito | Hebreiskspråkig dagvård | Day care in Hebrew | 188 | 2018-08-07T14:00:28.572081+03:00 | 3 | 869 | {} | [188] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
945 | [946] | Venäjänkielinen päivähoito | Ryskspråkig dagvård | Day care in Russian | 773 | 2018-08-07T14:00:28.731246+03:00 | 3 | 869 | {} | [773] | 0 | 1405 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
889 | [895, 890] | Saamenkielinen päivähoito | Samiskspråkig dagvård | Day care in Sami | 607 | 2018-08-07T14:00:28.389203+03:00 | 3 | 869 | {} | [607] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
913 | [919, 914] | Espanjankielinen päivähoito | Spanskspråkig dagvård | Day care in Spanish | 164 | 2018-08-07T14:00:28.527678+03:00 | 3 | 869 | {} | [164] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
881 | [886, 887, 883, 882] | Ruotsinkielinen päivähoito | Svenskspråkig dagvård | Day care in Swedish | 603 | 2019-03-05T14:30:09.379492+02:00 | 3 | 869 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [603] | 0 | 1405 | 77 | 128 | 33 | 10 | 8 | ||||||||||||||||||||||||||||||
757 | [758, 759, 760, 761, 762] | Päätöksenteko | Beslutsfattande | Decision-making | 2018-08-07T14:00:30.759776+03:00 | 3 | 756 | {} | [] | 0 | 1401 | 6 | 10 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
287 | [289, 290, 291, 292] | Suunnittelu- ja rakentamispalvelut | Planerings- och byggtjänster | Design and construction services | 2018-08-07T14:00:22.425144+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 5 | 7 | 1 | 1 | ||||||||||||||||||||||||||||||||
77 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:21.469668+03:00 | 3 | 74 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
277 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:22.362599+03:00 | 3 | 270 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
537 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:25.163756+03:00 | 3 | 534 | {} | [252] | 0 | 1402 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
780 | [] | Perinnönjako | Arvskifte | Distribution of estate | 508 | 2018-08-07T14:00:30.947784+03:00 | 3 | 769 | {} | [508] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
62 | [63, 64, 65, 66, 67] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.368201+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
493 | [494, 495, 496, 497, 498] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:22.700110+03:00 | 3 | 491 | {} | [] | 0 | 1403 | 102 | 149 | 22 | 25 |
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 );