service_node
1,140 rows sorted by unit_count_municipality_kauniainen descending
This data as json, CSV (advanced)
Suggested facets: level, period_enabled, root, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, 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, last_modified_time (date)
keywords ✖
- {} 1,103
- {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 10
- {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 3
- {"fi": ["kuntoutus"]} 3
- {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} 2
- {"fi": ["kirjastot"]} 2
- {"fi": ["mielenterveys", "terveysasemat"]} 2
- {"fi": ["suomi"]} 2
- {"fi": ["akut"]} 1
- {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} 1
- {"fi": ["englanti"]} 1
- {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} 1
- {"fi": ["kartonki"]} 1
- {"fi": ["lamput"]} 1
- {"fi": ["p\u00e4ivystys"]} 1
- {"fi": ["palvelupiste"]} 1
- {"fi": ["paristot"]} 1
- {"fi": ["patsas", "patsaat", "veistos"]} 1
- {"fi": ["tartuntatauti", "tartuntataudit"]} 1
- {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} 1
- {"sv": ["digitalt st\u00f6d", "digitalt r\u00e5dgivning"], "fi": ["digiopastus", "digituki"], "en": ["digital quidance", "digital support"]} 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
608 | [609, 610, 611, 612, 613] | Kuntoilukeskukset ja liikuntasalit | Konditionsidrottscentra och idrottssalar | Fitness centres and sports halls | 2018-08-07T14:00:23.602837+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 576 | 949 | 188 | 177 | 8 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
1402 | [306, 512] | Liikenne ja kartat | Trafik och kartor | Traffic and maps | 2018-08-07T14:00:24.647447+03:00 | 0 | {} | [] | 0 | 1402 | 1567 | 2238 | 1 | 4 | 1 | 2 | 1 | 2 | 581 | 71 | 8 | ||||||||||||||||||||||||||
783 | [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] | Perhe- ja sosiaalipalvelut | Familje- och socialservice | Family and social services | 2018-08-07T14:00:27.699133+03:00 | 0 | {} | [] | 0 | 783 | 397 | 718 | 2 | 1 | 1 | 129 | 175 | 1 | 7 | 5 | |||||||||||||||||||||||||||
997 | [2164, 2166] | Koulu- ja opiskeluterveydenhuolto | Skol- och studenthälsovård | School and student health services | 2018-10-25T08:00:09.578039+03:00 | 1 | 986 | {} | [] | 0 | 986 | 241 | 320 | 1 | 2 | 68 | 1 | 7 | |||||||||||||||||||||||||||||
1372 | [1373, 1374, 1375] | Oppilas- ja opiskelijahuolto | Elevvård | Pupil and student care | 2018-08-07T14:00:27.603403+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 241 | 388 | 1 | 2 | 136 | 1 | 7 | |||||||||||||||||||||||||||||
1373 | [2165, 2167] | Koulu- ja opiskeluterveydenhuolto | Skol- och studenthälsovård | School and student health services | 2018-10-25T08:00:08.960295+03:00 | 2 | 1372 | {} | [] | 0 | 1087 | 241 | 320 | 1 | 2 | 68 | 1 | 7 | |||||||||||||||||||||||||||||
1 | [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] | Asumisympäristö | Boendemiljön | Housing environment | 2018-08-07T14:00:21.308151+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 1002 | 1524 | 2 | 2 | 294 | 218 | 6 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||
512 | [513, 521, 525, 526, 533, 534, 541] | Liikenne | Trafik | Traffic | 2018-08-07T14:00:24.996122+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 1269 | 1864 | 1 | 4 | 2 | 1 | 2 | 540 | 39 | 6 | ||||||||||||||||||||||||||
653 | [] | Ulkokuntoiluvälineet | Konditionspark för utomhusaktiviteter | Fitness training park | 737 | 2018-08-07T14:00:23.939410+03:00 | 4 | 646 | {} | [737] | 0 | 1403 | 168 | 320 | 100 | 43 | 3 | 6 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
871 | [] | päivähoito | dagvård | day care | 663 | 2019-03-05T14:30:09.346786+02:00 | 4 | 870 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [663] | 0 | 1405 | 389 | 845 | 277 | 173 | 6 | ||||||||||||||||||||||||||||||
1401 | [122, 171, 755] | Työ, talous ja hallinto | Arbete, ekonomi och förvaltning | Employment and public authorities | 2020-03-06T18:32:09.344909+02:00 | 0 | {} | [] | 0 | 1401 | 448 | 629 | 2 | 1 | 1 | 2 | 1 | 2 | 3 | 88 | 74 | 6 | 1 | ||||||||||||||||||||||||
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 | ||||||||||||||||
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 | ||||||||||||||||||||||||||||||
60 | [61, 62, 68, 2236, 71, 72] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:21.354530+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
70 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:21.425954+03:00 | 4 | 68 | {} | [389] | 0 | 1400 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
122 | [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] | Elinkeino, työ ja verotus | Näringar, arbete och beskattning | Entrepreneurship, work and taxation | 2018-08-07T14:00:29.995212+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 322 | 452 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 51 | 62 | 5 | 1 | |||||||||||||||||||||||
231 | [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] | Kiinteistöt ja rakennetut tilat | Fastigheter | Real estate | 2018-08-07T14:00:22.059452+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 311 | 427 | 1 | 1 | 1 | 1 | 2 | 2 | 48 | 55 | 5 | |||||||||||||||||||||||||
491 | [492, 493, 499, 2237, 502, 2235] | Puistot ja viheralueet | Parker och grönområden | Parks and green areas | 2018-08-07T14:00:22.684763+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 520 | 967 | 1 | 268 | 173 | 5 | ||||||||||||||||||||||||||||||
499 | [501, 500] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:22.748801+03:00 | 3 | 491 | {} | [] | 0 | 1403 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
501 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:22.761746+03:00 | 4 | 499 | {} | [389] | 0 | 1403 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
612 | [] | Liikuntasali | Idrottssal | Gymnastics hall | 402 | 2018-08-07T14:00:23.630490+03:00 | 4 | 608 | {} | [402] | 0 | 1403 | 308 | 512 | 97 | 102 | 5 | ||||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
1374 | [] | Koulukuraattori | Skolkurator | School social worker | 340 | 2018-08-07T14:00:27.634259+03:00 | 2 | 1372 | {} | [340] | 0 | 1087 | 71 | 66 | 5 | ||||||||||||||||||||||||||||||||
2164 | [] | Kouluterveydenhuolto | Skolhälsovård | School health care | 339 | 2018-08-07T14:00:29.207544+03:00 | 2 | 997 | {} | [339] | 0 | 986 | 160 | 236 | 1 | 1 | 68 | 1 | 5 | ||||||||||||||||||||||||||||
2165 | [] | Kouluterveydenhuolto | Skolhälsovård | School health care | 339 | 2018-08-07T14:00:27.619794+03:00 | 3 | 1373 | {} | [339] | 0 | 1087 | 160 | 236 | 1 | 1 | 68 | 1 | 5 | ||||||||||||||||||||||||||||
551 | [552, 2151, 558, 2217, 601, 633, 666, 684, 694] | Liikunta | Idrott och motion | Sports and physical exercise | 2018-08-07T14:00:23.220207+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 2590 | 4872 | 16 | 3 | 19 | 1 | 1 | 11 | 1260 | 1 | 892 | 36 | 42 | |||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
146 | [147, 148, 149, 156] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:30.157480+03:00 | 2 | 122 | {} | [] | 0 | 1401 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
149 | [2209, 150, 152, 151, 154, 155] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:30.179684+03:00 | 3 | 146 | {} | [] | 0 | 1401 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
255 | [256, 257, 258, 265] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:22.202500+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
258 | [2210, 259, 261, 260, 263, 264] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.220951+03:00 | 4 | 255 | {} | [] | 0 | 1400 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
505 | [2208, 506, 508, 507, 510, 511] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.797039+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1400 | [2, 1, 14, 24, 31, 221, 85] | Asuminen ja kaupunkiympäristö | Boende och stadsmiljö | Housing and urban environment | 2018-08-07T14:00:21.224786+03:00 | 0 | {} | [] | 0 | 1400 | 2311 | 4077 | 17 | 1 | 23 | 1 | 1 | 4 | 1 | 30 | 53 | 43 | 737 | 3 | 698 | 35 | 10 | 31 | 37 | 41 | |||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
717 | [754, 718, 2173, 2028] | Matkailu ja tapahtumat | Turism och evenemang | Things to do | 2020-03-06T18:32:07.102459+02:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1973 | 2155 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 5 | 3 | 87 | 67 | 1 | 1 | 3 | 4 | ||||||||||||||||||
718 | [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] | Matkailu | Turism | Tourism | 2018-08-07T14:00:24.401683+03:00 | 2 | 717 | {} | [] | 0 | 1403 | 1880 | 2050 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 5 | 3 | 79 | 64 | 1 | 1 | 3 | 4 | ||||||||||||||||||
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 | |||||||||||||||||||||||||
825 | [] | Vanhusten palveluasuminen | Serviceboende för äldre | Service residence for the elderly | 760 | 2018-08-07T14:00:27.984445+03:00 | 2 | 819 | {} | [760] | 0 | 783 | 30 | 103 | 1 | 36 | 32 | 3 | 1 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
633 | [634, 639, 646, 654, 663] | Ulkokentät ja liikuntapuistot | Utomhusplaner och idrottsparker | Outdoor fields and sports parks | 2018-08-07T14:00:23.790680+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 1261 | 2383 | 1 | 1 | 636 | 457 | 4 | 23 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
42 | [] | Muovinkeräys | Plaståtervinning | Plastic recycling | 454 | 2018-08-07T14:00:21.846516+03:00 | 3 | 34 | {} | [454] | 0 | 1400 | 23 | 70 | 29 | 16 | 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 | ||||||||||||||||||||||||||||||
50 | [] | Tekstiilien keräys | Textilåtervinning | Textile recycling | 696 | 2018-08-07T14:00:21.906229+03:00 | 3 | 34 | {} | [696] | 0 | 1400 | 40 | 108 | 37 | 29 | 2 | ||||||||||||||||||||||||||||||
150 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:30.186216+03:00 | 4 | 149 | {} | [799] | 0 | 1401 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
259 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.226278+03:00 | 5 | 258 | {} | [799] | 0 | 1400 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
355 | [] | Kulttuurin monitoimitalot | Allaktivitetshus för kultur | Multi-functional culture venues | 345 | 2018-08-07T14:00:22.617002+03:00 | 3 | 352 | {} | [345] | 0 | 1403 | 8 | 18 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
506 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.804088+03:00 | 3 | 505 | {} | [799] | 0 | 1403 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
520 | [] | Rautatieasemat | Järnvägsstationer | Railway stations | 576 | 2018-08-07T14:00:25.051739+03:00 | 3 | 513 | {} | [576] | 0 | 1402 | 16 | 41 | 9 | 14 | 2 | ||||||||||||||||||||||||||||||
526 | [527, 528, 2207, 529, 530, 2204, 532] | Pysäköinti | Parkering | Parking | 2018-08-07T14:00:25.093849+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 559 | 1023 | 460 | 2 | 2 | |||||||||||||||||||||||||||||||
532 | [] | Yleiset pysäköintialueet | Allmänna parkeringsområden | Public parking lot | 814 | 2018-08-07T14:00:25.132843+03:00 | 3 | 526 | {} | [814] | 0 | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
575 | [576] | Laskettelurinteet ja rinnehiihtokeskukset | Slalombackar och alpina skidcentra | Ski slopes and downhill ski resorts | 2018-08-07T14:00:23.388106+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 6 | 2 | 2 | ||||||||||||||||||||||||||||||||
576 | [] | Laskettelun suorituspaikat | Slalombackar och alpina skidcentra | Ski slopes and downhill ski resorts | 376 | 2018-08-07T14:00:23.393272+03:00 | 4 | 575 | {} | [376] | 0 | 1403 | 2 | 6 | 2 | 2 | |||||||||||||||||||||||||||||||
611 | [] | Kuntosali | Gym | Gym | 350 | 2018-08-07T14:00:23.623495+03:00 | 4 | 608 | {} | [350] | 0 | 1403 | 151 | 237 | 45 | 39 | 2 | ||||||||||||||||||||||||||||||
614 | [615, 616, 617, 618, 619, 620, 621, 622, 623] | Liikuntahallit | Idrottshallar | Sports halls | 2018-08-07T14:00:23.644666+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 149 | 233 | 60 | 22 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
647 | [] | Liikuntapuisto | Idrottspark | Sports park | 401 | 2018-08-07T14:00:23.890605+03:00 | 4 | 646 | {} | [401] | 0 | 1403 | 7 | 3 | 2 | 2 | |||||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
791 | [794, 795, 792, 793, 796] | Muut perheiden palvelut | Övriga tjänster för familjer | Other family services | 2018-08-07T14:00:27.754089+03:00 | 1 | 783 | {} | [] | 0 | 783 | 16 | 40 | 4 | 18 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
820 | [] | Vanhuspalvelun sosiaalityö | Socialt arbete inom äldreomsorgen | Service for the elderly, social work | 764 | 2018-08-07T14:00:27.951192+03:00 | 2 | 819 | {} | [764] | 0 | 783 | 5 | 16 | 1 | 8 | 2 | ||||||||||||||||||||||||||||||
824 | [] | Vanhusten itsenäinen asuminen | Självständigt boende för äldre | Independent habitation for the elderly | 757 | 2018-08-07T14:00:27.977916+03:00 | 2 | 819 | {} | [757] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
876 | [] | kielikylpy ruotsi | språkbad, svenska | language immersion, Swedish | 663*294 | 2018-08-07T14:00:28.297483+03:00 | 4 | 870 | {} | [663, 294] | 0 | 1405 | 9 | 19 | 5 | 3 | 2 | ||||||||||||||||||||||||||||||
1017 | [] | Laboratorio | Laboratorium | Laboratory | 366 | 2018-08-07T14:00:29.386729+03:00 | 1 | 986 | {} | [366] | 0 | 986 | 22 | 88 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 2 | 6 | 3 | 3 | 1 | 7 | 1 | 10 | 1 | 3 | 1 | 8 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | ||||||
1028 | [1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038] | Kuntoutus | Rehabilitering | Rehabilitation | 2018-08-07T14:00:29.478107+03:00 | 1 | 986 | {} | [] | 0 | 986 | 33 | 67 | 16 | 16 | 2 | |||||||||||||||||||||||||||||||
1033 | [] | Kuntoutussuunnittelu ja -ohjaus | Rehabiliteringsplanering och -handledning | Rehabilitation planning and guidance | 355 | 2018-08-07T14:00:29.523750+03:00 | 2 | 1028 | {} | [355] | 0 | 986 | 4 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||
1043 | [] | Omahoitotarvikejakelu | Utdelning av egenvårdsartiklar | Distribution of self-care supplies | 477 | 2018-08-07T14:00:29.623935+03:00 | 1 | 986 | {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} | [477] | 0 | 986 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
1083 | [1084, 1086] | Väestönsuojat | Befolkningsskyddsrum | Public shelters | 2018-08-07T14:00:29.937480+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 47 | 49 | 2 | |||||||||||||||||||||||||||||||||
1086 | [] | Yleiset väestönsuojat | Allmänna befolkningsskyddsrum | General public shelters | 815 | 2018-08-07T14:00:29.980338+03:00 | 2 | 1083 | {} | [815] | 0 | 1061 | 27 | 29 | 2 |
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 );