service_node
1,140 rows sorted by children
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 863
- 2018-10-25 84
- 2018-10-24 12
- 2019-03-05 11
- 2020-11-18 9
- 2020-06-09 8
- 2020-06-22 8
- 2020-03-06 5
- 2020-12-02 4
- 2018-08-31 3
- 2019-10-22 3
- 2020-10-02 3
- 2018-11-20 2
- 2019-02-12 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-05-08 2
- 2019-06-20 2
- 2019-08-22 2
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-23 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-05-25 1
- 2020-12-15 1
keywords ✖
- {} 1,003
- {"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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
272 | [273, 274, 275] | Energia | Energi | Energy | 2018-08-07T14:00:22.327547+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
293 | [295, 296, 299, 301] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:22.465138+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
2 | [3, 4, 5, 7, 2191, 8] | Asuminen | Boende | Housing | 2018-08-07T14:00:21.231002+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 742 | 1530 | 16 | 23 | 1 | 1 | 27 | 51 | 40 | 246 | 3 | 256 | 35 | 10 | 1 | 37 | 41 | |||||||||||||||||||
302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
303 | [304] | Aluerakentaminen | Områdesbyggandet | Regional construction | 2018-08-07T14:00:22.515802+03:00 | 4 | 302 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
307 | [308, 313, 309, 310, 312] | Arkistot | Arkiv | Archives | 2018-08-07T14:00:24.657353+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 4 | 11 | 2 | 4 | 1 | |||||||||||||||||||||||||||||||
314 | [319, 315, 317, 316, 2147, 2159] | Asiakaspalvelu ja neuvonta | Kundbetjäning och rådgivning | Customer service and information | 2018-08-07T14:00:24.703287+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 12 | 39 | 1 | 12 | 13 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
330 | [331, 332] | Langaton internet, wlan | Trådlöst internet, wlan | Wireless internet, wlan | 2018-10-25T08:00:07.331877+03:00 | 3 | 329 | {} | [] | 0 | 1402 | 233 | 240 | 7 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||
343 | [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] | Kulttuuri ja vapaa-aika | Kultur och fritid | Culture and leisure | 2018-08-07T14:00:22.539281+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1745 | 2452 | 1 | 1 | 1 | 1 | 8 | 1 | 2 | 4 | 2 | 382 | 286 | 1 | 13 | 4 | ||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
499 | [501, 500] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:22.748801+03:00 | 3 | 491 | {} | [] | 0 | 1403 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
521 | [522, 523] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 2018-08-07T14:00:25.059349+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 1 | 5 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
534 | [536, 537, 538, 535, 539, 2206] | Tiet ja kadut | Vägar och gator | Roads and streets | 2018-08-07T14:00:25.145762+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 356 | 376 | 3 | 16 | 1 | |||||||||||||||||||||||||||||||
541 | [542, 547] | Vesiliikenne | Sjötrafik | Water traffic | 2018-08-07T14:00:25.190941+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 223 | 279 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
542 | [543, 544, 545, 2198, 546, 2144] | Satamat ja laiturit | Hamn och bryggor | Harbours, piers and quays | 2018-08-07T14:00:25.196186+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 168 | 209 | 2 | 1 | 1 | 36 | 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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||
552 | [553, 2007] | Eläinurheilualueet | Anläggningar för djursport | Animal sports areas | 2018-08-07T14:00:23.225274+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 27 | 75 | 31 | 17 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
559 | [560, 561, 562, 563] | Ampumaurheilupaikat | Sportskytteplatser | Shooting sports facilities | 2018-08-07T14:00:23.287538+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 6 | 10 | 1 | 3 | ||||||||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
572 | [573, 574] | Kiipeilypaikat | Klättringsplatser | Climbing venues | 2018-08-07T14:00:23.370651+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 5 | 14 | 6 | 3 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
646 | [578, 647, 648, 649, 650, 651, 652, 653] | Lähiliikunta ja liikuntapuistot | Närmotion och idrottsparker | Neighbourhood sports facilities and parks | 2018-08-07T14:00:23.877348+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 345 | 650 | 1 | 196 | 95 | 3 | 10 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
597 | [600] | Suunnistusalueet | Orienteringsområden | Orienteering areas | 2018-08-07T14:00:23.531981+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
601 | [602, 606, 608, 614, 624] | Sisäliikuntatilat | Anläggningar för inomhusidrott | Indoor sports facilities | 2018-08-07T14:00:23.557871+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 795 | 1314 | 278 | 229 | 12 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
634 | [635, 636, 637, 638] | Golfkentät | Golfbanor | Golf courses | 2018-08-07T14:00:23.796742+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 18 | 50 | 23 | 9 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
666 | [667, 675, 677] | Vene-, ilmailu- ja moottoriurheilu | Anläggningar för båtsport, flygsport och motorsport | Boating, aviation and motor sports | 2018-08-07T14:00:24.041279+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 9 | 18 | 3 | 6 | ||||||||||||||||||||||||||||||||
667 | [668, 670, 672, 673, 674] | Moottoriurheilualueet | Områden för motorsport | Motor sports areas | 2018-08-07T14:00:24.047385+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 4 | 12 | 2 | 6 | ||||||||||||||||||||||||||||||||
675 | [676] | Urheiluilmailualueet | Områden för flygsport | Sport aviation areas | 2018-08-07T14:00:24.102541+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 1 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
685 | [686, 687, 688, 689] | Maauimalat ja uimarannat | Utebassänger och badstränder | Open air pools and beaches | 2018-08-07T14:00:24.169221+03:00 | 3 | 684 | {} | [] | 0 | 1403 | 43 | 98 | 4 | 39 | 8 | 4 | ||||||||||||||||||||||||||||||
690 | [691, 692, 693] | Uima-altaat, hallit ja kylpylät | Simbassänger, hallar och badinrättningar | Indoor swimming pools, halls and spas | 2018-08-07T14:00:24.204334+03:00 | 3 | 684 | {} | [] | 0 | 1403 | 35 | 55 | 12 | 7 | 1 | |||||||||||||||||||||||||||||||
694 | [695, 706] | Virkistyskohteet ja palvelut | Rekreationsanläggningar och tjänster | Recreational destinations and services | 2018-08-07T14:00:24.231367+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 235 | 442 | 11 | 1 | 13 | 11 | 143 | 1 | 7 | 19 | 1 | |||||||||||||||||||||||||
695 | [696, 697, 698, 699, 700, 701, 702, 703, 704, 705] | Retkeilyn palvelut | Utflyktstjänster | Hiking facilities | 2018-08-07T14:00:24.236641+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 224 | 404 | 10 | 11 | 8 | 125 | 7 | 18 | 1 | |||||||||||||||||||||||||||
5 | [6] | Asumisoikeusasuminen | Bostadsrättsbostäder | Right-of-occupancy housing | 76 | 2018-08-07T14:00:21.249052+03:00 | 2 | 2 | {} | [76] | 0 | 1400 | 331 | 1108 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
68 | [70, 69] | Leikkipuistot | Lekparker | Playgrounds | 2018-08-07T14:00:21.413441+03:00 | 3 | 60 | {} | [] | 0 | 1400 | 293 | 647 | 201 | 148 | 5 | |||||||||||||||||||||||||||||||
706 | [710, 711, 712, 713, 714, 716] | Virkistys- ja retkeilyalueet | Rekreations- och friluftsområden | Recreational and outdoor areas | 2018-08-07T14:00:24.316869+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 11 | 38 | 1 | 1 | 2 | 3 | 18 | 1 | 1 | |||||||||||||||||||||||||||
719 | [721, 723, 724, 725, 730] | Eläintarhat | Djurparker | Zoos | 2018-08-07T14:00:24.415879+03:00 | 3 | 718 | {} | [] | 0 | 1403 | 13 | 14 | 1 | |||||||||||||||||||||||||||||||||
725 | [726, 727, 728, 729] | Ruokaa, juomaa ja ostoksia | Mat, dryck och inköp | Food, drinks and shopping | 2018-08-07T14:00:24.448965+03:00 | 4 | 719 | {} | [] | 0 | 1403 | 5 | 5 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||
755 | [756, 768, 769] | Oikeusturva ja demokratia | Rättsskydd och demokrati | Justice system and democracy | 2020-03-06T18:32:09.608464+02:00 | 1 | 1401 | {} | [] | 0 | 1401 | 15 | 46 | 28 | 2 | 1 | |||||||||||||||||||||||||||||||
756 | [757, 763] | Demokratia | Demokrati | Democracy | 2018-08-07T14:00:30.749902+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 8 | 13 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
74 | [76, 77, 78, 75, 79, 2205] | Tiet ja kadut | Vägar och gator | Roads and streets | 2018-08-07T14:00:21.451762+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 356 | 376 | 3 | 16 | 1 | |||||||||||||||||||||||||||||||
763 | [764, 765] | Vaalit ja äänestäminen | Val och röstning | Elections and voting | 2018-08-07T14:00:30.816923+03:00 | 3 | 756 | {} | [] | 0 | 1401 | 2 | 4 | 1 | 1 | ||||||||||||||||||||||||||||||||
769 | [770, 775, 776, 777, 778, 779, 780, 2202, 781] | Oikeusturva | Rättsskydd | Legal protection | 2018-08-07T14:00:30.864855+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 5 | 9 | 3 | 1 | ||||||||||||||||||||||||||||||||
770 | [771, 773, 774] | Avioliitto ja rekisteröity parisuhde | Äktenskap och registrering av partnerskap | Marriage and registered partnership | 2018-08-07T14:00:30.869982+03:00 | 3 | 769 | {} | [] | 0 | 1401 | 1 | 2 | 1 | |||||||||||||||||||||||||||||||||
784 | [786, 785] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:27.703824+03:00 | 1 | 783 | {} | [] | 0 | 783 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
787 | [789, 790, 788] | Lastensuojelu | Barnskydd | Child welfare | 2018-10-25T08:00:09.006369+03:00 | 1 | 783 | {} | [] | 0 | 783 | 37 | 81 | 1 | 17 | 24 | 1 | 1 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
798 | [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] | Vammaispalvelut | Handikapptjänster | Services for the disabled | 2018-08-07T14:00:27.804536+03:00 | 1 | 783 | {} | [] | 0 | 783 | 14 | 59 | 2 | 7 | 34 | 1 | 1 | |||||||||||||||||||||||||||||
80 | [81, 82, 83, 84] | Torit ja kauppahallit | Torg och saluhallar | Market squares and halls | 2018-08-07T14:00:21.488118+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 19 | 19 | ||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
830 | [836, 837, 834, 833, 835, 832, 831, 838, 2157] | Päihdepalvelut | Service för missbrukare | Services for substance abusers | 2018-08-07T14:00:28.016024+03:00 | 1 | 783 | {} | [] | 0 | 783 | 29 | 56 | 12 | 14 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 |
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 );