service_node
1,140 rows sorted by name_fi
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 813
- 2018-10-25 37
- 2020-03-06 16
- 2019-03-05 10
- 2020-11-18 10
- 2020-06-09 9
- 2020-06-22 8
- 2018-10-24 5
- 2020-10-02 4
- 2020-12-02 4
- 2018-08-31 2
- 2018-11-20 2
- 2019-02-12 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-05-08 2
- 2019-06-20 2
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-08-22 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-05-25 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
233 | [234, 235, 237] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:22.072503+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 3 | 6 | 3 | |||||||||||||||||||||||||||||||||
866 | [] | Hallinto | Förvaltning | Administration | 180 | 2018-08-07T14:00:28.228192+03:00 | 1 | 783 | {} | [180] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
1382 | [] | Hallinto | Förvaltning | Administration | 179 | 2018-08-07T14:00:27.693663+03:00 | 1 | 1087 | {} | [179] | 0 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
171 | [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] | Hallinto ja talous | Förvaltning och ekonomi | Administration and economy | 2018-08-07T14:00:30.363012+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 124 | 163 | 1 | 1 | 17 | 17 | 2 | 1 | ||||||||||||||||||||||||||||
234 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 178 | 2020-12-02T12:30:08.656880+02:00 | 4 | 233 | {} | [178] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
543 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 183 | 2018-08-07T14:00:25.201364+03:00 | 4 | 542 | {} | [183] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
1048 | [1050] | Hallintopalvelut | Förvaltningstjänster | Patient representative services | 2020-03-06T18:32:09.249350+02:00 | 1 | 986 | {} | [] | 0 | 986 | 1 | 1 | ||||||||||||||||||||||||||||||||||
995 | [] | Hammashoito | Tandvård | Dental care | 184 | 2020-03-06T18:32:09.101816+02:00 | 1 | 986 | {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} | [184] | 0 | 986 | 36 | 98 | 20 | 41 | 1 | ||||||||||||||||||||||||||||||
235 | [] | Hankepalvelut | Projekttjänster | Project services | 185 | 2018-08-07T14:00:22.084046+03:00 | 4 | 233 | {} | [185] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
177 | [] | Hankintapalvelut | Upphandlingstjänster | Procurement services | 217 | 2018-08-07T14:00:30.442764+03:00 | 2 | 171 | {} | [217] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
565 | [] | Harjoitushyppyrimäki | Träningshoppbacke | Ski jumping hill for training | 186 | 2018-08-07T14:00:23.324523+03:00 | 4 | 564 | {} | [186] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
603 | [] | Harjoitusjäähalli | Övningsishall | Training ice arena | 187 | 2018-08-07T14:00:23.568317+03:00 | 4 | 602 | {} | [187] | 0 | 1403 | 10 | 17 | 5 | 2 | |||||||||||||||||||||||||||||||
368 | [371, 374, 375, 376, 378, 381, 389, 391, 395, 396, 399, 2155, 403, 404, 405, 409, 410, 415, 418, 419, 421, 424, 426, 429, 433, 437, 438, 440, 442, 446, 448, 449, 452, 453, 454, 455, 458, 467, 468, 470, 473, 2154, 480, 481, 485, 488] | Harrasteet | Hobbyer | Hobbies | 2018-08-07T14:00:22.885008+03:00 | 2 | 365 | {} | [] | 0 | 1403 | 71 | 120 | 1 | 1 | 27 | 17 | 3 | |||||||||||||||||||||||||||||
150 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:30.186216+03:00 | 4 | 149 | {} | [799] | 0 | 1401 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
259 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.226278+03:00 | 5 | 258 | {} | [799] | 0 | 1400 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
506 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.804088+03:00 | 3 | 505 | {} | [799] | 0 | 1403 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
182 | [] | Henkilöstöpolitiikka ja -strategia | Personalpolitik och -strategi | Personnel policy and strategy | 220 | 2018-08-07T14:00:30.473352+03:00 | 3 | 180 | {} | [220] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
183 | [] | Henkilöstöravintolat | Personalrestaurang | Staff restaurants | 221 | 2018-08-07T14:00:30.479735+03:00 | 3 | 180 | {} | [221] | 0 | 1401 | 23 | 26 | 2 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
579 | [] | Hevosreitti | Hästled | Horse track | 190 | 2018-08-07T14:00:23.406242+03:00 | 4 | 577 | {} | [190] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
553 | [554, 555, 556, 557] | Hevosurheilu | Hästsport | Equestrian sports | 2018-08-07T14:00:23.231236+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 19 | 64 | 31 | 14 | ||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
238 | [] | Hissiprojekti | Anskaffning av hissar (gamla höghus) | Lift procurement (old residential buildings) | 195 | 2018-08-07T14:00:22.097017+03:00 | 3 | 231 | {} | [195] | 0 | 1400 | 1 | 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 | |||||||||||||||||||||||||||||||||
861 | [] | Hoitoalan ruokapalvelut | Mattjänster inom vårdbranschen | Meal services in the care sector | 196 | 2018-08-07T14:00:28.222009+03:00 | 1 | 783 | {} | [196] | 0 | 783 | 12 | 12 | |||||||||||||||||||||||||||||||||
736 | [] | Hotellit ja majoitus | Hotell och logi | Hotels and accommodation | 197 | 2018-08-07T14:00:24.492255+03:00 | 3 | 718 | {} | [197] | 0 | 1403 | 89 | 115 | 1 | 1 | 1 | 2 | 7 | 13 | 1 | ||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
2168 | [] | Hyvän olon palvelut | Välbefinnandetjänster | Well-being services | 864 | 2018-08-07T14:00:24.617742+03:00 | 3 | 718 | {} | [864] | 0 | 1403 | 34 | 37 | 1 | 2 | |||||||||||||||||||||||||||||||
786 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:27.716150+03:00 | 2 | 784 | {} | [199] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2146 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:29.136711+03:00 | 2 | 988 | {} | [199] | 0 | 986 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2148 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:24.771984+03:00 | 4 | 2147 | {} | [199] | 0 | 1402 | 4 | 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 | |||||||||||||||||||||||||||||||
224 | [] | Info- ja näyttelytilat | Informations- och utställningslokaler | Info and exhibition premises | 201 | 2018-08-07T14:00:22.012371+03:00 | 3 | 222 | {} | [201] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
315 | [] | Info- ja näyttelytilat | Informations- och utställningslokaler | Info and exhibition premises | 201 | 2018-08-07T14:00:24.709417+03:00 | 3 | 314 | {} | [201] | 0 | 1402 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
395 | [] | Internet | Internet | Internet | 202 | 2018-08-07T14:00:22.950721+03:00 | 3 | 368 | {} | [202] | 0 | 1403 | 2 | 15 | 13 | ||||||||||||||||||||||||||||||||
396 | [] | Jalkapallo | Fotboll | Football | 203 | 2018-08-07T14:00:22.956950+03:00 | 3 | 368 | {} | [203] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
615 | [] | Jalkapallohalli | Fotbollshall | Football hall | 204 | 2018-08-07T14:00:23.650553+03:00 | 4 | 614 | {} | [204] | 0 | 1403 | 8 | 18 | 6 | 3 | 1 | ||||||||||||||||||||||||||||||
656 | [] | Jalkapallostadion | Fotbollsstadion | Football stadium | 205 | 2018-08-07T14:00:23.964244+03:00 | 4 | 654 | {} | [205] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 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 | |||||||||||||||||||||||||||||||||
321 | [] | Johtotietopalvelu ja maanalaisten tilojen tietopalvelu | Ledningstjänsten och information om underjordiska utrymmen | Information service on cabling and underground facilities | 207 | 2018-08-07T14:00:24.801557+03:00 | 3 | 320 | {} | [207] | 0 | 1402 | 2 | 6 | 1 | 3 | |||||||||||||||||||||||||||||||
668 | [] | Jokamies- ja rallicross -rata | Allemans- och rallycrossbana | Everyman racing and rallycross track | 208 | 2018-08-07T14:00:24.052754+03:00 | 4 | 667 | {} | [208] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
513 | [514, 515, 516, 518, 519, 520] | Joukkoliikenne | Kollektivtrafik | Public transport | 2018-08-07T14:00:25.002057+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 99 | 151 | 27 | 21 | 4 | |||||||||||||||||||||||||||||||
515 | [] | Joukkoliikennepysäkit | Kollektivtrafikens hållplatser | Public transport stops | 209 | 2018-08-07T14:00:25.015254+03:00 | 3 | 513 | {} | [209] | 0 | 1402 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
562 | [] | Jousiammuntamaastorata | Terrängbana för bågskytte. | Field archery course | 212 | 2018-08-07T14:00:23.305715+03:00 | 4 | 559 | {} | [212] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
563 | [] | Jousiammuntarata | Bågskyttebana | Archery range | 213 | 2018-08-07T14:00:23.312216+03:00 | 4 | 559 | {} | [213] | 0 | 1403 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
152 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:30.200626+03:00 | 4 | 149 | {} | [214] | 0 | 1401 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
261 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.239469+03:00 | 5 | 258 | {} | [214] | 0 | 1400 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
131 | [] | Julkinen notaari | Notarius publicus | Notary public | 215 | 2018-08-07T14:00:30.061046+03:00 | 2 | 122 | {} | [215] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
516 | [] | Julkisen liikenteen varikot | Kollektivtrafikens depåer | Public transport depots | 216 | 2018-08-07T14:00:25.022696+03:00 | 3 | 513 | {} | [216] | 0 | 1402 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
2152 | [] | Julkishallinnon talousarviot | Budgetar inom den offentliga förvaltningen | Public administration budgets | 850 | 2018-08-07T14:00:30.564290+03:00 | 3 | 197 | {} | [850] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
1183 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:26.230412+03:00 | 4 | 1181 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
1251 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:26.727399+03:00 | 4 | 1249 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
2053 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:25.378466+03:00 | 3 | 2049 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
2060 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:25.427391+03:00 | 3 | 2056 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
399 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 231 | 2018-08-07T14:00:22.963009+03:00 | 3 | 368 | {} | [231] | 0 | 1403 | 6 | 8 | 2 | ||||||||||||||||||||||||||||||||
768 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 230 | 2018-08-07T14:00:30.858157+03:00 | 2 | 755 | {} | [230] | 0 | 1401 | 2 | 24 | 22 | ||||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
31 | [32, 33, 34, 52, 53, 54] | Jätehuolto ja kierrätys | Avfallshantering och återvinning | Waste management and recycling | 2018-08-07T14:00:21.761620+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 215 | 572 | 1 | 150 | 186 | 20 | ||||||||||||||||||||||||||||||
87 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:21.958557+03:00 | 2 | 85 | {} | [233] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
295 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:22.470442+03:00 | 4 | 293 | {} | [233] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
33 | [] | Jätteenkäsittelykeskus | Avfallshanteringscentral | Waste treatment centre | 234 | 2018-08-07T14:00:21.773147+03:00 | 2 | 31 | {} | [234] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
602 | [603, 604] | Jäähallit | Ishallar | Ice-skating arenas | 2018-08-07T14:00:23.562977+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 12 | 24 | 7 | 4 | 1 | |||||||||||||||||||||||||||||||
639 | [641, 642, 643, 644, 645] | Jääurheilualueet ja luonnonjäät | Isidrottsområden och naturisar | Ice sports areas and sites with natural ice | 2018-08-07T14:00:23.829697+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 165 | 358 | 114 | 77 | 2 | |||||||||||||||||||||||||||||||
225 | [] | Kaavat ja kaavoitus | Planer och planlägging | Town plans and zoning | 237 | 2018-08-07T14:00:22.018653+03:00 | 3 | 222 | {} | [237] | 0 | 1400 | 5 | 9 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
222 | [223, 224, 225, 226, 229, 230] | Kaavoitus | Planläggning | Planning | 2018-08-07T14:00:22.001028+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 9 | 15 | 2 | 3 | 1 | |||||||||||||||||||||||||||||||
221 | [222, 231, 270, 305] | Kaavoitus, kiinteistöt ja rakentaminen | Planläggning, fastigheter och byggande | Planning, real estate and construction | 2018-08-07T14:00:21.996119+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 367 | 506 | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 54 | 69 | 6 | ||||||||||||||||||||||||
61 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:21.361137+03:00 | 3 | 60 | {} | [238] | 0 | 1400 | 49 | 49 | |||||||||||||||||||||||||||||||||
492 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:22.690959+03:00 | 3 | 491 | {} | [238] | 0 | 1403 | 49 | 49 | |||||||||||||||||||||||||||||||||
726 | [] | Kahvila | Café | Cafe | 142*239 | 2018-08-07T14:00:24.455731+03:00 | 5 | 725 | {} | [239, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
1342 | [] | Kaksoistutkinto | Dubbel gymnasieexamen | Upper secondary school dual qualification | 408 | 2018-08-07T14:00:27.393475+03:00 | 3 | 1336 | {} | [408] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
696 | [] | Kalastusalue / -paikka | Område eller plats för fiske | Fishing area/spot | 240 | 2018-08-07T14:00:24.243549+03:00 | 4 | 695 | {} | [240] | 0 | 1403 | 1 | 26 | 19 | 2 | 4 | ||||||||||||||||||||||||||||||
609 | [] | Kamppailulajien sali | Sal för kampsport | Martial arts hall | 241 | 2018-08-07T14:00:23.609044+03:00 | 4 | 608 | {} | [241] | 0 | 1403 | 47 | 64 | 13 | 4 | |||||||||||||||||||||||||||||||
1177 | [] | Kansainvälinen opetus (IB) | Internationell undervisning (IB) | International education (IB) | 510 | 2018-08-07T14:00:26.169911+03:00 | 3 | 1098 | {} | [510] | 1 | 1087 | 4 | 6 | 2 | ||||||||||||||||||||||||||||||||
544 | [] | Kansainvälisten risteilyalusten laiturit | Kajer för internationella kryssningsfartyg | Piers for international cruisers | 242 | 2018-08-07T14:00:25.208722+03:00 | 4 | 542 | {} | [242] | 0 | 1402 | 6 | 6 | |||||||||||||||||||||||||||||||||
2212 | [] | Kansalaisopisto | Medborgarinstitut | Community college | 890 | 2020-11-18T07:30:12.923359+02:00 | 2 | 1360 | {} | [890] | 0 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1371 | [] | Kansanopisto | Folkhögskola | Folk high school | 244 | 2020-11-18T07:30:12.932144+02:00 | 2 | 1360 | {} | [244] | 0 | 1087 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
320 | [321, 322, 323] | Kartat ja paikkatietopalvelut | Kartor och geografisk information | Maps and location information services | 2018-08-07T14:00:24.796452+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 4 | 10 | 2 | 4 | ||||||||||||||||||||||||||||||||
306 | [307, 314, 320, 324, 329, 342] | Kartat, tietopalvelut ja viestintä | Kartor, informationstjänster och kommunikation | Maps, information services and communication | 2018-08-07T14:00:24.652419+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 307 | 389 | 1 | 42 | 36 | 3 | ||||||||||||||||||||||||||||||
670 | [] | Karting-rata | Kartingbana | Kart circuit | 245 | 2018-08-07T14:00:24.066651+03:00 | 4 | 667 | {} | [245] | 0 | 1403 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
322 | [] | Karttapalvelut, ilmakuvat ja karttojen tilaus | Karttjänster, flygbilder och beställning av kartor | Mapping services, aerial photographs and ordering maps | 247 | 2018-08-07T14:00:24.808369+03:00 | 3 | 320 | {} | [247] | 0 | 1402 | 3 | 6 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2155 | [] | Kasvitarha | Köksträdgård | Kitchen garden | 853 | 2018-08-07T14:00:22.969353+03:00 | 3 | 368 | {} | [853] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
313 | [] | Katu-, puisto- ja rakennuspiirustusten arkisto | Arkiv för gatu-, park- och byggnadsritningar | Public works department archive | 250 | 2018-08-07T14:00:24.696359+03:00 | 3 | 307 | {} | [250] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
76 | [] | Katujen ja viheralueiden käyttöluvat ja vuokraus | Tillstånd att använda gator och grönområden och uthyrning | Permits for using streets and parks and renting | 251 | 2018-08-07T14:00:21.463483+03:00 | 3 | 74 | {} | [251] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
536 | [] | Katujen ja viheralueiden käyttöluvat ja vuokraus | Tillstånd att använda gator och grönområden och uthyrning | Permits for using streets and parks and renting | 251 | 2018-08-07T14:00:25.157311+03:00 | 3 | 534 | {} | [251] | 0 | 1402 | 1 | 3 | 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 |
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 );