service_node
1,140 rows sorted by unit_count_municipality_helsinki descending
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
975 | [976, 977, 978, 979, 981, 982] | Leikkitoiminta | Lekverksamhet | Playground activities | 2018-08-07T14:00:28.970500+03:00 | 2 | 868 | {} | [] | 0 | 1405 | 144 | 210 | 33 | 32 | 1 | |||||||||||||||||||||||||||||||
819 | [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] | Vanhuspalvelu | Äldreomsorg | Service for the elderly | 2018-08-07T14:00:27.946229+03:00 | 1 | 783 | {} | [] | 0 | 783 | 142 | 261 | 1 | 67 | 44 | 6 | 1 | |||||||||||||||||||||||||||||
642 | [] | Luistelukenttä | Skridskobana | Ice-skating field | 406 | 2018-08-07T14:00:23.848959+03:00 | 4 | 639 | {} | [406] | 0 | 1403 | 136 | 308 | 100 | 70 | 2 | ||||||||||||||||||||||||||||||
648 | [] | Lähiliikuntapaikka | Näridrottsplats | Neighbourhood sports area | 415 | 2018-08-07T14:00:23.898085+03:00 | 4 | 646 | {} | [415] | 0 | 1403 | 134 | 229 | 1 | 64 | 26 | 4 | |||||||||||||||||||||||||||||
577 | [579, 580, 581, 582, 583, 584, 585, 586, 590] | Liikunta- ja ulkoilureitit | Idrotts- och friluftsleder | Sports and outdoor recreation routes | 2018-08-07T14:00:23.400833+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 132 | 401 | 3 | 1 | 1 | 105 | 147 | 9 | 3 | |||||||||||||||||||||||||||
1061 | [1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083] | Turvallisuus | Säkerhet | Public safety | 2018-08-07T14:00:29.767356+03:00 | 0 | {} | [] | 0 | 1061 | 130 | 163 | 17 | 13 | 3 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
1376 | [] | Koulu- ja opiskelijaruokailu | Måltider för elever och studerande | Meals for pupils and students | 338 | 2020-08-20T14:00:09.319013+03:00 | 1 | 1087 | {} | [338] | 0 | 1087 | 119 | 136 | 12 | 4 | 1 | ||||||||||||||||||||||||||||||
624 | [625, 626, 627, 628, 629, 630, 631, 632] | Yksittäiset lajikohtaiset sisäliikuntapaikat | Enstaka grenspecifika anläggningar för inomhusidrott | Indoor venues for various sports | 2018-08-07T14:00:23.722887+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 118 | 186 | 43 | 24 | 1 | |||||||||||||||||||||||||||||||
345 | [346, 2026, 2196, 348, 349, 2197] | Kirjastot | Bibliotek | Libraries | 2018-08-07T14:00:22.550752+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 114 | 157 | 27 | 14 | 2 | |||||||||||||||||||||||||||||||
983 | [] | Yksityisen hoidon tuki | Privatvårdsstöd | Support for private care | 811 | 2018-08-07T14:00:29.020270+03:00 | 2 | 868 | {} | [811] | 0 | 1405 | 111 | 118 | 7 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1120 | [1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234] | Kieliohjelma | Språkprogram | Language programme | 2018-08-07T14:00:25.674488+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 109 | 213 | 1 | 73 | 29 | 1 | ||||||||||||||||||||||||||||||
1123 | [] | A1-englanti | A1-engelska | A1-English | 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 | 2018-10-25T08:00:07.696168+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] | 1 | 1087 | 108 | 211 | 1 | 73 | 28 | 1 | |||||||||||||||||||||||||||||
1146 | [] | B1-ruotsi | B1-svenska | B1-Swedish | 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 | 2018-10-25T08:00:07.912218+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108] | 1 | 1087 | 107 | 205 | 1 | 72 | 24 | 1 | |||||||||||||||||||||||||||||
357 | [] | Näyttelytilat | Utställningslokaler | Exhibition spaces | 474 | 2018-08-07T14:00:22.630116+03:00 | 3 | 352 | {} | [474] | 0 | 1403 | 105 | 114 | 7 | 2 | |||||||||||||||||||||||||||||||
845 | [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] | Muu sosiaalihuolto | Övrig socialvård | Other social welfare | 2018-08-07T14:00:28.112184+03:00 | 1 | 783 | {} | [] | 0 | 783 | 105 | 239 | 1 | 11 | 118 | 3 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1100 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 661 | 2018-10-25T08:00:07.595003+03:00 | 4 | 1099 | {} | [661] | 1 | 1087 | 104 | 205 | 62 | 38 | 1 | ||||||||||||||||||||||||||||||
14 | [16, 23] | Eläimet | Djur | Animals | 2018-08-07T14:00:21.679608+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 103 | 150 | 22 | 25 | ||||||||||||||||||||||||||||||||
16 | [17, 18, 19, 20, 21] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.685399+03:00 | 2 | 14 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
617 | [] | Monitoimihalli / areena | Allaktivitetshall/multiarena | Multipurpose hall/arena | 444 | 2018-08-07T14:00:23.665496+03:00 | 4 | 614 | {} | [444] | 0 | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
17 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.693384+03:00 | 3 | 16 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1400 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
63 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.380622+03:00 | 4 | 62 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1400 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
494 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:22.710417+03:00 | 4 | 493 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1403 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
2217 | [2218, 2219, 2220, 2221, 2223, 2224, 2225, 2226] | Senioriliikunta | Seniormotion | Senior sports | 2020-06-09T15:30:11.296799+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 88 | 104 | 1 | 4 | 10 | 1 | ||||||||||||||||||||||||||||||
2221 | [] | Senioriliikunta | Seniormotion | Senior sports | 895 | 2020-06-09T15:30:11.355674+03:00 | 3 | 2217 | {} | [895] | 0 | 1403 | 86 | 102 | 1 | 4 | 10 | 1 | |||||||||||||||||||||||||||||
324 | [325, 2040, 2193, 327, 328, 2194] | Kirjastot | Bibliotek | Libraries | 2018-08-07T14:00:24.821378+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 83 | 125 | 26 | 14 | 2 | |||||||||||||||||||||||||||||||
365 | [2162, 2156, 368, 367, 366, 490] | Nuoriso | Ungdom | Youth | 2018-08-07T14:00:22.862181+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 82 | 146 | 1 | 1 | 30 | 29 | 3 | |||||||||||||||||||||||||||||
1135 | [] | A2-englanti | A2-engelska | A2-English | 149*27+150*27+162*27+163*27+301*27+302*27+384*27+385*27+567*27+568*27+612*27+613*27+661*27+662*27+771*27+772*27+793*27+794*27+865*27+866*27 | 2018-10-25T08:00:07.813754+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 27] | 1 | 1087 | 81 | 100 | 19 | ||||||||||||||||||||||||||||||||
2166 | [] | Opiskeluterveydenhuolto | Studenthälsovård | Student health care | 863 | 2018-08-07T14:00:29.213565+03:00 | 2 | 997 | {} | [863] | 0 | 986 | 81 | 154 | 2 | 68 | 3 | ||||||||||||||||||||||||||||||
2167 | [] | Opiskeluterveydenhuolto | Studenthälsovård | Student health care | 863 | 2018-08-07T14:00:27.627209+03:00 | 3 | 1373 | {} | [863] | 0 | 1087 | 81 | 154 | 2 | 68 | 3 | ||||||||||||||||||||||||||||||
684 | [685, 690] | Vesiliikuntapaikat | Anläggningar för vattenidrott | Water sports facilities | 2018-08-07T14:00:24.163817+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 78 | 153 | 4 | 51 | 15 | 4 | 1 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
882 | [] | päivähoito | dagvård | day care | 603 | 2019-03-05T14:30:09.386238+02:00 | 4 | 881 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [603] | 0 | 1405 | 77 | 128 | 33 | 10 | 8 | ||||||||||||||||||||||||||||||
519 | [] | Metroasemat | Metrostationer | Metro stations | 437 | 2018-08-07T14:00:25.044266+03:00 | 3 | 513 | {} | [437] | 0 | 1402 | 72 | 88 | 16 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
961 | [962, 2145] | Perhepäivähoito | Familjedagvård | Family day care | 2018-08-07T14:00:28.863138+03:00 | 2 | 868 | {} | [] | 0 | 1405 | 71 | 134 | 51 | 11 | 1 | |||||||||||||||||||||||||||||||
69 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.276314+02:00 | 4 | 68 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1400 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
500 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:06.940551+02:00 | 4 | 499 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1403 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
829 | [] | Kotihoito | Hemvård | Home care | 635 | 2020-03-06T18:32:08.579934+02:00 | 2 | 819 | {} | [635] | 0 | 783 | 69 | 95 | 19 | 4 | 3 | ||||||||||||||||||||||||||||||
981 | [] | Ohjattu leikkipuistotoiminta | Ledd lekparksverksamhet | Supervised playground activities | 475 | 2019-03-05T14:30:09.677599+02:00 | 3 | 975 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [475] | 0 | 1405 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
996 | [] | Kotihoito | Hemvård | Home care | 635 | 2020-03-06T18:32:09.105708+02:00 | 1 | 986 | {} | [635] | 0 | 986 | 69 | 95 | 19 | 4 | 3 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
362 | [363, 364] | Museot | Museer | Museums | 2018-08-07T14:00:22.665582+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 64 | 96 | 1 | 4 | 1 | 13 | 8 | 1 | 4 | |||||||||||||||||||||||||||
745 | [746, 747] | Museot | Museer | Museums | 2018-08-07T14:00:24.555720+03:00 | 3 | 718 | {} | [] | 0 | 1403 | 64 | 96 | 1 | 4 | 1 | 13 | 8 | 1 | 4 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
350 | [] | Kirkot ja muut uskonnolliset tilat | Kyrkor och andra religiösa byggnader | Churches and other religious buildings | 314 | 2018-08-07T14:00:22.584521+03:00 | 2 | 343 | {} | [314] | 0 | 1403 | 63 | 86 | 3 | 19 | 1 | ||||||||||||||||||||||||||||||
1110 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 662 | 2018-10-25T08:00:07.635959+03:00 | 4 | 1109 | {} | [662] | 1 | 1087 | 63 | 114 | 1 | 27 | 22 | 1 | |||||||||||||||||||||||||||||
1141 | [] | A2-ranska | A2-franska | A2-French | 149*33+150*33+162*33+163*33+301*33+302*33+384*33+385*33+567*33+568*33+612*33+613*33+661*33+662*33+771*33+772*33+793*33+794*33+865*33+866*33 | 2018-10-25T08:00:07.868542+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 33] | 1 | 1087 | 63 | 101 | 22 | 16 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
747 | [] | Taidemuseo | Konstmuseer | Art museums | 672 | 2018-08-07T14:00:24.568656+03:00 | 4 | 745 | {} | [672] | 0 | 1403 | 61 | 88 | 1 | 4 | 1 | 10 | 6 | 1 | 4 | ||||||||||||||||||||||||||
339 | [340, 341] | Tarjolla opastusta | Handledning ges | Guidance available | 2018-10-25T08:00:07.363024+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 60 | 64 | 1 | 3 | ||||||||||||||||||||||||||||||||
172 | [173, 176, 2001, 2002] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:30.370486+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 59 | 72 | 1 | 3 | 8 | 1 | ||||||||||||||||||||||||||||||
341 | [] | Opastusta tietokoneen käytössä (digineuvonta) | Handledning i datoranvändning (digital handledning) | Guidance on using a computer (digital guidance) | 483 | 2020-05-25T11:30:10.362485+03:00 | 5 | 339 | {"sv": ["digitalt st\u00f6d", "digitalt r\u00e5dgivning"], "fi": ["digiopastus", "digituki"], "en": ["digital quidance", "digital support"]} | [483] | 0 | 1402 | 59 | 62 | 3 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1142 | [] | A2-saksa | A2-tyska | A2-German | 149*35+150*35+162*35+163*35+301*35+302*35+384*35+385*35+567*35+568*35+612*35+613*35+661*35+662*35+771*35+772*35+793*35+794*35+865*35+866*35 | 2018-10-25T08:00:07.877676+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 35] | 1 | 1087 | 58 | 124 | 50 | 16 | |||||||||||||||||||||||||||||||
1134 | [] | A2-ruotsi | A2-svenska | A2-Swedish | 149*34+150*34+162*34+163*34+301*34+302*34+384*34+385*34+567*34+568*34+612*34+613*34+661*34+662*34+771*34+772*34+793*34+794*34+865*34+866*34 | 2018-10-25T08:00:07.804809+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 34] | 1 | 1087 | 57 | 117 | 39 | 21 | |||||||||||||||||||||||||||||||
2145 | [964, 963, 972] | Ryhmäperhepäivähoito | Gruppfamiljedagvård | Group family day care | 2018-08-07T14:00:28.879106+03:00 | 3 | 961 | {} | [] | 0 | 1405 | 57 | 118 | 51 | 9 | 1 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
810 | [815, 816, 817, 813, 812, 811, 818, 814, 1007] | Kehitysvammahuolto | Vård av utvecklingsstörda | Care for the developmentally disabled | 2018-08-07T14:00:27.882619+03:00 | 1 | 783 | {} | [] | 0 | 783 | 56 | 109 | 12 | 36 | 2 | 3 | ||||||||||||||||||||||||||||||
1360 | [2212, 1371, 1369, 1370, 1365, 1361] | Vapaa sivistystyö | Fritt bildningsarbete | General educational work | 2020-11-18T07:30:12.838195+02:00 | 1 | 1087 | {} | [] | 0 | 1087 | 56 | 97 | 9 | 28 | 4 | |||||||||||||||||||||||||||||||
2004 | [] | Hallinnolliset toimipisteet | Administrativa ämbetsverk | Administrative offices | 271 | 2018-08-07T14:00:30.391457+03:00 | 4 | 173 | {} | [271] | 0 | 1401 | 55 | 65 | 1 | 1 | 7 | 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 | ||||||||||||||||||||||||||||||
334 | [335, 337, 338] | Tarjolla oheislaitteita | Kringutrustning finns | Supplementary equipment available | 2018-08-07T14:00:24.905778+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 54 | 56 | 2 | |||||||||||||||||||||||||||||||||
548 | [] | Ulkoilusaaret | Friluftsöar | Recreational islands | 735 | 2018-10-25T08:00:07.487309+03:00 | 4 | 547 | {} | [735] | 0 | 1402 | 54 | 69 | 1 | 2 | 1 | 1 | 1 | 9 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2134 | [] | Leikkipuiston järjestämät ryhmät | Lekparkernas grupper | Groups organised by playgrounds | 341 | 2018-08-07T14:00:26.223904+03:00 | 4 | 1181 | {} | [341] | 1 | 1087 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
338 | [] | Tulostin | Skrivare | Printer | 692 | 2018-10-25T08:00:07.357556+03:00 | 5 | 334 | {} | [692] | 0 | 1402 | 52 | 54 | 2 | ||||||||||||||||||||||||||||||||
71 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:21.432517+03:00 | 3 | 60 | {} | [786] | 0 | 1400 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
502 | [] | Viheralueet | Grönområden | Green areas | 786 | 2018-08-07T14:00:22.769184+03:00 | 3 | 491 | {} | [786] | 0 | 1403 | 51 | 102 | 1 | 50 | |||||||||||||||||||||||||||||||
699 | [] | Opastuspiste | Information punkt | Information point | 482 | 2018-08-07T14:00:24.267790+03:00 | 4 | 695 | {} | [482] | 0 | 1403 | 51 | 73 | 1 | 2 | 2 | 14 | 2 | 1 | |||||||||||||||||||||||||||
40 | [] | Lasinkeräys | Glasåtervinning | Glass recycling | 374 | 2018-08-07T14:00:21.831316+03:00 | 3 | 34 | {} | [374] | 0 | 1400 | 50 | 138 | 46 | 37 | 5 | ||||||||||||||||||||||||||||||
41 | [] | Metallinkeräys | Metallavfall | Small metal waste | 436 | 2018-08-07T14:00:21.839149+03:00 | 3 | 34 | {} | [436] | 0 | 1400 | 50 | 137 | 46 | 37 | 4 | ||||||||||||||||||||||||||||||
360 | [] | Teatterit | Teatrar | Theatres | 694 | 2018-08-07T14:00:22.651704+03:00 | 3 | 352 | {} | [694] | 0 | 1403 | 50 | 62 | 10 | 2 | |||||||||||||||||||||||||||||||
752 | [] | Teatterit | Teatrar | Theatres | 694 | 2018-08-07T14:00:24.603285+03:00 | 3 | 718 | {} | [694] | 0 | 1403 | 50 | 62 | 10 | 2 | |||||||||||||||||||||||||||||||
963 | [] | Suomenkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på finska | Group family day care in Finnish | 664 | 2018-10-25T08:00:09.441773+03:00 | 4 | 2145 | {"fi": ["suomi"]} | [664] | 0 | 1405 | 50 | 107 | 47 | 9 | 1 | ||||||||||||||||||||||||||||||
1361 | [1362, 1363] | Suomenkielinen työväenopisto | Finska arbetarinstitutet | Finnish adult education centre | 665 | 2020-11-18T07:30:12.844488+02:00 | 2 | 1360 | {} | [665] | 0 | 1087 | 50 | 59 | 7 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
875 | [] | erityisryhmä | specialgrupp | special group | 663*156 | 2018-08-07T14:00:28.291078+03:00 | 4 | 870 | {} | [663, 156] | 0 | 1405 | 49 | 77 | 28 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
1165 | [] | B2-ranska | B2-franska | B2-French | 149*119+150*119+162*119+163*119+301*119+302*119+384*119+385*119+567*119+568*119+612*119+613*119+661*119+662*119+771*119+772*119+793*119+794*119+865*119+866*119 | 2018-10-25T08:00:08.088270+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 119] | 1 | 1087 | 48 | 72 | 22 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1083 | [1084, 1086] | Väestönsuojat | Befolkningsskyddsrum | Public shelters | 2018-08-07T14:00:29.937480+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 47 | 49 | 2 | |||||||||||||||||||||||||||||||||
1187 | [1246, 1249, 1193, 1192, 1188, 1190, 1242] | Ruotsinkielinen perusopetus | Grundläggande utbildning på svenska | Basic education in Swedish | 2018-08-07T14:00:26.251158+03:00 | 2 | 1097 | {} | [] | 0 | 1087 | 47 | 65 | 13 | 5 | ||||||||||||||||||||||||||||||||
658 | [] | Lentopallokenttä | Volleybollplan | Volleyball court | 392 | 2018-08-07T14:00:23.980139+03:00 | 4 | 654 | {} | [392] | 0 | 1403 | 46 | 86 | 1 | 10 | 28 | 1 | |||||||||||||||||||||||||||||
581 | [] | Kuntorata | Konditionsbana | Jogging track | 348 | 2018-08-07T14:00:23.419850+03:00 | 4 | 577 | {} | [348] | 0 | 1403 | 45 | 82 | 22 | 14 | 1 | ||||||||||||||||||||||||||||||
583 | [] | Latu | Skidspår | Ski track | 191 | 2018-08-07T14:00:23.433650+03:00 | 4 | 577 | {} | [191] | 0 | 1403 | 45 | 208 | 2 | 1 | 39 | 117 | 3 | 1 | |||||||||||||||||||||||||||
662 | [] | Tenniskenttäalue | Område med tennisbanor | Tennis court area | 700 | 2018-10-25T08:00:07.016431+03:00 | 4 | 654 | {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} | [700] | 0 | 1403 | 45 | 83 | 11 | 25 | 2 | ||||||||||||||||||||||||||||||
1136 | [] | A2-espanja | A2-spanska | A2-Spanish | 149*28+150*28+162*28+163*28+301*28+302*28+384*28+385*28+567*28+568*28+612*28+613*28+661*28+662*28+771*28+772*28+793*28+794*28+865*28+866*28 | 2018-10-25T08:00:07.822843+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 28] | 1 | 1087 | 45 | 75 | 7 | 23 | |||||||||||||||||||||||||||||||
73 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:21.445519+03:00 | 2 | 1 | {} | [532] | 0 | 1400 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
503 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:22.776545+03:00 | 2 | 343 | {} | [532] | 0 | 1403 | 44 | 74 | 14 | 16 |
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 );