service_node
297 rows where root = 1403 sorted by name_en
This data as json, CSV (advanced)
Suggested facets: level, period_enabled, unit_count_municipality_sipoo, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, last_modified_time (date)
keywords ✖
- {} 291
- {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} 1
- {"fi": ["kirjastot"]} 1
- {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 1
- {"fi": ["patsas", "patsaat", "veistos"]} 1
- {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} 1
- {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
490 | [] | Nuorten neuvonta ja ohjaus | Rådgivning och handledning för ungdomar | Advice and guidance for young people | 471 | 2018-08-07T14:00:23.202058+03:00 | 2 | 365 | {} | [471] | 0 | 1403 | 7 | 22 | 3 | 12 | |||||||||||||||||||||||||||||||
503 | [] | Viljelyspalstat | Odlingslotter | Allotments | 532 | 2018-08-07T14:00:22.776545+03:00 | 2 | 343 | {} | [532] | 0 | 1403 | 44 | 74 | 14 | 16 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
563 | [] | Jousiammuntarata | Bågskyttebana | Archery range | 213 | 2018-08-07T14:00:23.312216+03:00 | 4 | 559 | {} | [213] | 0 | 1403 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
631 | [] | Telinevoimistelutila | Utrymme för redskapsgymnastik | Artistic gymnastics facility | 697 | 2018-08-07T14:00:23.775695+03:00 | 4 | 624 | {} | [697] | 0 | 1403 | 6 | 15 | 5 | 4 | |||||||||||||||||||||||||||||||
419 | [] | Kädentaidot | Hantverk | Arts and Crafts | 362 | 2018-08-07T14:00:23.026643+03:00 | 3 | 368 | {} | [362] | 0 | 1403 | 3 | 15 | 10 | 2 | |||||||||||||||||||||||||||||||
664 | [] | Yleisurheilukenttä | Friidrottsplan | Athletics field | 817 | 2018-08-07T14:00:24.025516+03:00 | 4 | 663 | {} | [817] | 0 | 1403 | 8 | 17 | 6 | 3 | |||||||||||||||||||||||||||||||
663 | [664, 665] | Yleisurheilukentät ja -paikat | Planer och platser för friidrott | Athletics fields and venues | 2018-08-07T14:00:24.019648+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 36 | 59 | 20 | 3 | ||||||||||||||||||||||||||||||||
665 | [] | Yleisurheilun harjoitusalue | Träningsområde för friidrott | Athletics training area | 818 | 2018-08-07T14:00:24.033733+03:00 | 4 | 663 | {} | [818] | 0 | 1403 | 28 | 42 | 14 | ||||||||||||||||||||||||||||||||
622 | [] | Sulkapallohalli | Badmintonhall | Badminton hall | 647 | 2018-08-07T14:00:23.705272+03:00 | 4 | 614 | {} | [647] | 0 | 1403 | 9 | 18 | 5 | 4 | |||||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
654 | [655, 656, 657, 658, 659, 660, 661, 662] | Pallokentät | Bollplaner | Ball games courts | 2018-08-07T14:00:23.947305+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 697 | 1266 | 1 | 283 | 273 | 1 | 11 | |||||||||||||||||||||||||||||
2223 | [] | Senioripalloilu | Bollsport för seniorer | Ball games for seniors | 899 | 2020-06-09T15:30:11.384469+03:00 | 3 | 2217 | {} | [899] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
378 | [] | Bänditoiminta/-tila | Bandverksamhet eller bandlokal | Band activity or practice space | 128 | 2018-08-07T14:00:22.924860+03:00 | 3 | 368 | {} | [128] | 0 | 1403 | 2 | 12 | 5 | 5 | |||||||||||||||||||||||||||||||
508 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.820471+03:00 | 3 | 505 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
737 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:24.498919+03:00 | 3 | 718 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
2174 | [] | Baarit ja yöelämä | Barer och nattliv | Bars and nightlife | 869 | 2018-08-07T14:00:24.408116+03:00 | 3 | 718 | {} | [869] | 0 | 1403 | 179 | 181 | 2 | ||||||||||||||||||||||||||||||||
660 | [] | Pesäpallostadion | Bobollsstadion | Baseball stadium | 511 | 2018-08-07T14:00:23.995997+03:00 | 4 | 654 | {} | [511] | 0 | 1403 | 3 | 6 | 1 | 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 | ||||||||||||||||||||||||||||||
655 | [] | Beachvolleykenttä | Beachvolleyplan | Beach volleyball court | 125 | 2018-08-07T14:00:23.954884+03:00 | 4 | 654 | {} | [125] | 0 | 1403 | 39 | 85 | 27 | 18 | 1 | ||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
424 | [] | Lautapelit | Brädspel | Board games | 387 | 2018-08-07T14:00:23.039435+03:00 | 3 | 368 | {} | [387] | 0 | 1403 | 14 | 13 | 1 | ||||||||||||||||||||||||||||||||
700 | [] | Rantautumispaikka | Ilandstigningsplats | Boat dock | 571 | 2018-08-07T14:00:24.275183+03:00 | 4 | 695 | {} | [571] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
705 | [] | Venesatama | Serviceplats för båtfarare | Boating services | 769 | 2018-08-07T14:00:24.310541+03:00 | 4 | 695 | {} | [769] | 0 | 1403 | 147 | 188 | 2 | 1 | 1 | 36 | 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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
607 | [] | Keilahalli | Bowlinghall | Bowling alley | 285 | 2018-08-07T14:00:23.595829+03:00 | 4 | 606 | {} | [285] | 0 | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
449 | [] | Poikakerho / poikaryhmät | Pojkklubb / pojkgrupper | Boys' club / Boy groups | 518 | 2018-08-07T14:00:23.107321+03:00 | 3 | 368 | {} | [518] | 0 | 1403 | 1 | 16 | 14 | 1 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
702 | [] | Telttailu ja leiriytyminen | Tältning och läger | Camping | 698 | 2018-08-07T14:00:24.290069+03:00 | 4 | 695 | {} | [698] | 0 | 1403 | 2 | 12 | 1 | 8 | 1 | ||||||||||||||||||||||||||||||
426 | [] | Leiritoiminta | Lägerverksamhet | Camping activities | 391 | 2018-08-07T14:00:23.046486+03:00 | 3 | 368 | {} | [391] | 0 | 1403 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
361 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:22.659080+03:00 | 2 | 343 | {} | [432] | 0 | 1403 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
573 | [] | Kiipeilykallio | Klätterberg | Climbing rock | 306 | 2018-08-07T14:00:23.375633+03:00 | 4 | 572 | {} | [306] | 0 | 1403 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
572 | [573, 574] | Kiipeilypaikat | Klättringsplatser | Climbing venues | 2018-08-07T14:00:23.370651+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 5 | 14 | 6 | 3 | ||||||||||||||||||||||||||||||||
404 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 289 | 2018-08-07T14:00:22.983998+03:00 | 3 | 368 | {} | [289] | 0 | 1403 | 22 | 14 | 7 | 1 | |||||||||||||||||||||||||||||||
604 | [] | Kilpajäähalli | Tävlingsishall | Competition ice arena | 308 | 2018-08-07T14:00:23.575267+03:00 | 4 | 602 | {} | [308] | 0 | 1403 | 2 | 7 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||
354 | [] | Konserttitilat | Konsertutrymmen | Concert facilities | 329 | 2018-08-07T14:00:22.610197+03:00 | 3 | 352 | {} | [329] | 0 | 1403 | 33 | 43 | 8 | 1 | 1 | ||||||||||||||||||||||||||||||
410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
701 | [] | Ruoanlaittopaikka | Matlagningsplats | Cooking facilities | 586 | 2018-08-07T14:00:24.282789+03:00 | 4 | 695 | {} | [586] | 0 | 1403 | 17 | 77 | 6 | 8 | 4 | 33 | 9 | ||||||||||||||||||||||||||||
437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
567 | [568, 569] | Katetut talviurheilupaikat | Vintersportplatser under tak | Covered winter sports facilities | 2018-08-07T14:00:23.339639+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 2 | ||||||||||||||||||||||||||||||||||
585 | [] | Maastopyöräilyreitti | Mountainbikeled | Cross-country biking route | 425 | 2018-08-07T14:00:23.448007+03:00 | 4 | 577 | {} | [425] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
363 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:22.670926+03:00 | 3 | 362 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
746 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:24.561434+03:00 | 4 | 745 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||
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 | ||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
650 | [] | Pyöräilyalue | Cykelåkningsområde | Cycling area | 538 | 2018-08-07T14:00:23.912521+03:00 | 4 | 646 | {} | [538] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
473 | [] | Tanssi | Dans | Dance | 685 | 2018-08-07T14:00:23.163347+03:00 | 3 | 368 | {} | [685] | 0 | 1403 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
359 | [] | Tanssitilat | Dansutrymmen | Dance facilities | 686 | 2018-08-07T14:00:22.643791+03:00 | 3 | 352 | {} | [686] | 0 | 1403 | 12 | 15 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2156 | [] | Etsivä nuorisotyö | Uppsökande ungdomsarbete | Detective youth work | 854 | 2018-08-07T14:00:23.208137+03:00 | 2 | 365 | {} | [854] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
2162 | [] | Digitaalinen nuorisotyö | Digital ungdomsarbete | Digital youth work | 859 | 2018-08-07T14:00:23.214339+03:00 | 2 | 365 | {} | [859] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
578 | [] | Frisbeegolf-rata | Frisbeegolfbana | Disc golf course | 169 | 2018-08-07T14:00:23.883764+03:00 | 4 | 646 | {} | [169] | 0 | 1403 | 8 | 27 | 10 | 8 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
497 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:22.733778+03:00 | 4 | 493 | {} | [321] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
580 | [] | Koirahiihtolatu | Spår för hundspann | Dog skijoring track | 318 | 2018-08-07T14:00:23.413028+03:00 | 4 | 577 | {} | [318] | 0 | 1403 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
2007 | [2008, 2009] | Koiraurheilu | Hundsport | Dog sports | 2018-08-07T14:00:23.263114+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 8 | 11 | 3 | |||||||||||||||||||||||||||||||||
2008 | [] | Koiraurheilualue | Område för hundsport | Dog sports area | 322 | 2018-08-07T14:00:23.268249+03:00 | 4 | 2007 | {} | [322] | 0 | 1403 | 7 | 10 | 3 | ||||||||||||||||||||||||||||||||
2009 | [] | Koiraurheiluhalli | Hundsporthall | Dog sports hall | 323 | 2018-08-07T14:00:23.274980+03:00 | 4 | 2007 | {} | [323] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
495 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:22.718157+03:00 | 4 | 493 | {} | [319] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
351 | [] | Kulttuuripalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för kulturtjänster | Electronic services and forms related to cultural services | 346 | 2018-08-07T14:00:22.590770+03:00 | 2 | 343 | {} | [346] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
2151 | [] | Liikunnan sähköinen asiointi ja lomakkeet | Elektroniska tjänster och formulär för motion | Electronic services and forms related to sports | 849 | 2018-08-07T14:00:24.387923+03:00 | 2 | 551 | {} | [849] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
555 | [] | Ratsastuskenttä | Ridbana | Equestrian field | 574 | 2018-08-07T14:00:23.243825+03:00 | 4 | 553 | {} | [574] | 0 | 1403 | 8 | 36 | 20 | 8 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
498 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:22.741237+03:00 | 4 | 493 | {} | [480] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
625 | [] | Miekkailutila | Utrymme för fäktning | Fencing venue | 439 | 2018-08-07T14:00:23.729643+03:00 | 4 | 624 | {} | [439] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
470 | [] | Sähly | Innebandy | Floorball | 670 | 2018-08-07T14:00:23.157134+03:00 | 3 | 368 | {} | [670] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
619 | [] | Salibandyhalli | Innebandyhall | Floorball hall | 616 | 2018-08-07T14:00:23.680694+03:00 | 4 | 614 | {} | [616] | 0 | 1403 | 4 | 12 | 4 | 4 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 |
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 );