service_node
129 rows where level = 3 and root = 1403
This data as json, CSV (advanced)
Suggested facets: parent, keywords, period_enabled, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vantaa, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, last_modified_time (date)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
346 | [] | Erikoiskirjastot | Specialbibliotek | Special libraries | 155 | 2018-08-07T14:00:22.558572+03:00 | 3 | 345 | {"fi": ["kirjastot"]} | [155] | 0 | 1403 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
348 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:22.571974+03:00 | 3 | 345 | {} | [368] | 0 | 1403 | 8 | 8 | |||||||||||||||||||||||||||||||||
349 | [] | Yleiset kirjastot | Allmänna bibliotek | Public libraries | 813 | 2018-11-20T14:00:06.997504+02:00 | 3 | 345 | {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} | [813] | 0 | 1403 | 39 | 71 | 20 | 11 | 1 | ||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
354 | [] | Konserttitilat | Konsertutrymmen | Concert facilities | 329 | 2018-08-07T14:00:22.610197+03:00 | 3 | 352 | {} | [329] | 0 | 1403 | 33 | 43 | 8 | 1 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
358 | [] | Ooppera ja baletti | Operan och balett | Opera and ballet | 479 | 2018-08-07T14:00:22.636644+03:00 | 3 | 352 | {} | [479] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
359 | [] | Tanssitilat | Dansutrymmen | Dance facilities | 686 | 2018-08-07T14:00:22.643791+03:00 | 3 | 352 | {} | [686] | 0 | 1403 | 12 | 15 | 1 | 2 | |||||||||||||||||||||||||||||||
360 | [] | Teatterit | Teatrar | Theatres | 694 | 2018-08-07T14:00:22.651704+03:00 | 3 | 352 | {} | [694] | 0 | 1403 | 50 | 62 | 10 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
371 | [] | Askartelu | Hobbyverksamhet | Hobby crafts | 72 | 2018-08-07T14:00:22.898108+03:00 | 3 | 368 | {} | [72] | 0 | 1403 | 3 | 9 | 2 | 4 | |||||||||||||||||||||||||||||||
374 | [] | Av- ja leirivälinelainaamo | Utlåning av AV-utrustning och campingutrustning | Loaning service for audiovisual and camping equipment | 81 | 2018-08-07T14:00:22.905139+03:00 | 3 | 368 | {} | [81] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
375 | [] | Avoin nuorisotoiminta | Öppen ungdomsverksamhet | Open youth activities | 85 | 2018-08-07T14:00:22.911924+03:00 | 3 | 368 | {} | [85] | 0 | 1403 | 41 | 78 | 22 | 14 | 1 | ||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
389 | [] | Fillari- ja moottoripaja | Cykel- och motorverkstad | Workshop for bicycles and mopeds | 168 | 2018-08-07T14:00:22.937466+03:00 | 3 | 368 | {} | [168] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
395 | [] | Internet | Internet | Internet | 202 | 2018-08-07T14:00:22.950721+03:00 | 3 | 368 | {} | [202] | 0 | 1403 | 2 | 15 | 13 | ||||||||||||||||||||||||||||||||
396 | [] | Jalkapallo | Fotboll | Football | 203 | 2018-08-07T14:00:22.956950+03:00 | 3 | 368 | {} | [203] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
399 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 231 | 2018-08-07T14:00:22.963009+03:00 | 3 | 368 | {} | [231] | 0 | 1403 | 6 | 8 | 2 | ||||||||||||||||||||||||||||||||
403 | [] | Keramiikka | Keramik | Pottery | 287 | 2018-08-07T14:00:22.976243+03:00 | 3 | 368 | {} | [287] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
404 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 289 | 2018-08-07T14:00:22.983998+03:00 | 3 | 368 | {} | [289] | 0 | 1403 | 22 | 14 | 7 | 1 | |||||||||||||||||||||||||||||||
405 | [] | Kesätoiminta | Sommarverksamhet | Summer activities | 291 | 2018-08-07T14:00:22.992018+03:00 | 3 | 368 | {} | [291] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
415 | [] | Kuntosali | Gym | Gym | 349 | 2018-08-07T14:00:23.013463+03:00 | 3 | 368 | {} | [349] | 0 | 1403 | 11 | 1 | 10 | ||||||||||||||||||||||||||||||||
418 | [] | Kuvataide | Bildkonst | Visual arts | 359 | 2018-08-07T14:00:23.020022+03:00 | 3 | 368 | {} | [359] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
421 | [] | Käsityöt | Handarbeten | Handicrafts | 363 | 2018-08-07T14:00:23.033043+03:00 | 3 | 368 | {} | [363] | 0 | 1403 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
424 | [] | Lautapelit | Brädspel | Board games | 387 | 2018-08-07T14:00:23.039435+03:00 | 3 | 368 | {} | [387] | 0 | 1403 | 14 | 13 | 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 | ||||||||||||||||||||||||||||||
429 | [] | Liikunta | Idrott | Sports | 399 | 2018-08-07T14:00:23.053156+03:00 | 3 | 368 | {} | [399] | 0 | 1403 | 10 | 9 | 1 | ||||||||||||||||||||||||||||||||
433 | [] | Media | Media | Media | 433 | 2018-08-07T14:00:23.060583+03:00 | 3 | 368 | {} | [433] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
438 | [] | Moottorihalli | Motorhall | Motorhall | 445 | 2018-08-07T14:00:23.074919+03:00 | 3 | 368 | {} | [445] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
440 | [] | Mopokerho | Mopedklubb | Moped club | 452 | 2018-08-07T14:00:23.082022+03:00 | 3 | 368 | {} | [452] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
442 | [] | Musiikki | Musik | Music | 455 | 2018-08-07T14:00:23.088590+03:00 | 3 | 368 | {} | [455] | 0 | 1403 | 4 | 19 | 14 | 1 | |||||||||||||||||||||||||||||||
446 | [] | Pelit | Spel | Games | 503 | 2018-08-07T14:00:23.094780+03:00 | 3 | 368 | {} | [503] | 0 | 1403 | 1 | 24 | 15 | 8 | |||||||||||||||||||||||||||||||
448 | [] | Pingis | Bordtennis | Table tennis | 515 | 2018-08-07T14:00:23.100999+03:00 | 3 | 368 | {} | [515] | 1 | 1403 | 1 | 17 | 12 | 4 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
452 | [] | Puutyö | Slöjd | Woodwork | 534 | 2018-08-07T14:00:23.113213+03:00 | 3 | 368 | {} | [534] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
454 | [] | Pöytäfutis | Bordfotboll | Table football | 554 | 2018-08-07T14:00:23.125546+03:00 | 3 | 368 | {} | [554] | 0 | 1403 | 11 | 10 | 1 | ||||||||||||||||||||||||||||||||
455 | [] | Pöytäjääkiekko | Bordshockey | Table hockey | 555 | 2018-08-07T14:00:23.132016+03:00 | 3 | 368 | {} | [555] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
458 | [] | Retkeily | Camping | Trekking | 580 | 2018-08-07T14:00:23.138224+03:00 | 3 | 368 | {} | [580] | 0 | 1403 | 2 | 7 | 5 | ||||||||||||||||||||||||||||||||
467 | [] | Skeittaus | Skateboardåkning | Skateboarding | 629 | 2018-08-07T14:00:23.144513+03:00 | 3 | 368 | {} | [629] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
468 | [] | Soitonopetus | Instrumentundervisning | Teaching music | 632 | 2018-08-07T14:00:23.150860+03:00 | 3 | 368 | {} | [632] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
470 | [] | Sähly | Innebandy | Floorball | 670 | 2018-08-07T14:00:23.157134+03:00 | 3 | 368 | {} | [670] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
473 | [] | Tanssi | Dans | Dance | 685 | 2018-08-07T14:00:23.163347+03:00 | 3 | 368 | {} | [685] | 0 | 1403 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
480 | [] | Tyttökerho / tyttöryhmät | Flickklubb / flickgrupper | Girls' club / Girl groups | 722 | 2018-08-07T14:00:23.175639+03:00 | 3 | 368 | {} | [722] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
481 | [] | Valokuvaus | Fotografering | Photography | 741 | 2018-08-07T14:00:23.182310+03:00 | 3 | 368 | {} | [741] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
485 | [] | Viikonlopputoiminta | Veckoslutsverksamhet | Weekend activities | 789 | 2018-08-07T14:00:23.188643+03:00 | 3 | 368 | {} | [789] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
492 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:22.690959+03:00 | 3 | 491 | {} | [238] | 0 | 1403 | 49 | 49 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
506 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.804088+03:00 | 3 | 505 | {} | [799] | 0 | 1403 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
507 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:22.812763+03:00 | 3 | 505 | {} | [326] | 0 | 1403 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
510 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.836894+03:00 | 3 | 505 | {} | [803] | 0 | 1403 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
511 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.844464+03:00 | 3 | 505 | {} | [804] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
553 | [554, 555, 556, 557] | Hevosurheilu | Hästsport | Equestrian sports | 2018-08-07T14:00:23.231236+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 19 | 64 | 31 | 14 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
739 | [] | Kaupat ja myymälät | Butiker och affärer | Shops and outlets | 256 | 2018-08-07T14:00:24.513136+03:00 | 3 | 718 | {} | [256] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
740 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:24.520703+03:00 | 3 | 718 | {} | [259] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
741 | [] | Kioskit | Kiosker | Kiosks | 309 | 2018-08-07T14:00:24.527473+03:00 | 3 | 718 | {} | [309] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
742 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:24.534199+03:00 | 3 | 718 | {} | [326] | 0 | 1403 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 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 );