service_node
297 rows where root = 1403 sorted by unit_count_total
This data as json, CSV (advanced)
Suggested facets: level, keywords, 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) ✖
- 2018-08-07 278
- 2020-06-09 9
- 2019-04-02 2
- 2018-10-25 1
- 2018-11-20 1
- 2019-03-05 1
- 2019-03-20 1
- 2019-10-22 1
- 2020-03-06 1
- 2020-09-01 1
- 2020-12-02 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 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 | |||||||||||||||||||||||||||||||||
470 | [] | Sähly | Innebandy | Floorball | 670 | 2018-08-07T14:00:23.157134+03:00 | 3 | 368 | {} | [670] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
496 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:22.725829+03:00 | 4 | 493 | {} | [320] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
557 | [] | Ravirata | Travbana | Horse racing track | 578 | 2018-08-07T14:00:23.257255+03:00 | 4 | 553 | {} | [578] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
560 | [] | Ampumarata | Skjutbana | Open-air shooting range | 54 | 2018-08-07T14:00:23.293024+03:00 | 4 | 559 | {} | [54] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
561 | [] | Ampumaurheilukeskus | Sportskyttecentrum | Shooting sports centre | 55 | 2018-08-07T14:00:23.299465+03:00 | 4 | 559 | {} | [55] | 0 | 1403 | 1 | 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 | |||||||||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
565 | [] | Harjoitushyppyrimäki | Träningshoppbacke | Ski jumping hill for training | 186 | 2018-08-07T14:00:23.324523+03:00 | 4 | 564 | {} | [186] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
593 | [] | Ampumahiihdon harjoittelualue | Träningsområde för skidskytte | Training area for biathlon | 52 | 2018-08-07T14:00:23.502563+03:00 | 4 | 592 | {} | [52] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
597 | [600] | Suunnistusalueet | Orienteringsområden | Orienteering areas | 2018-08-07T14:00:23.531981+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
600 | [] | Suunnistusalue | Orienteringsområde | Orienteering area | 666 | 2018-08-07T14:00:23.551634+03:00 | 4 | 597 | {} | [666] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
644 | [] | Pikaluistelurata | Bana hastighetsåkning på skridsko | Speed-skating track | 514 | 2018-08-07T14:00:23.862975+03:00 | 4 | 639 | {} | [514] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
673 | [] | Moottorirata | Motorbana | Formula race track | 449 | 2018-08-07T14:00:24.087804+03:00 | 4 | 667 | {} | [449] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
674 | [] | Moottoriurheilukeskus | Centrum för motorsport | Motor sports centre | 450 | 2018-08-07T14:00:24.095559+03:00 | 4 | 667 | {} | [450] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
676 | [] | Urheiluilmailualue | Område för flygsport | Sport aviation area | 739 | 2018-08-07T14:00:24.108363+03:00 | 4 | 675 | {} | [739] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
681 | [] | Soudun ja melonnan sisäharjoittelutila | Inomhusträningsutrymme för rodd och paddling | Indoor training facility for rowing and canoeing | 642 | 2018-08-07T14:00:24.143385+03:00 | 4 | 677 | {} | [642] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
712 | [] | Muu luonnonsuojelualue, jolla on virkistyspalveluita | Annat naturskyddsområde med rekreationstjänster | Other nature conservation area with recreational services | 458 | 2018-08-07T14:00:24.351095+03:00 | 4 | 706 | {} | [458] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
716 | [] | Virkistysmetsä | Friluftsskog | Recreational forest | 791 | 2018-08-07T14:00:24.380867+03:00 | 4 | 706 | {} | [791] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
724 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:24.442228+03:00 | 4 | 719 | {} | [411] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
726 | [] | Kahvila | Café | Cafe | 142*239 | 2018-08-07T14:00:24.455731+03:00 | 5 | 725 | {} | [239, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
729 | [] | Ravintola | Restaurang | Restaurant | 142*577 | 2018-08-07T14:00:24.477966+03:00 | 5 | 725 | {} | [577, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2009 | [] | Koiraurheiluhalli | Hundsporthall | Dog sports hall | 323 | 2018-08-07T14:00:23.274980+03:00 | 4 | 2007 | {} | [323] | 0 | 1403 | 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 | |||||||||||||||||||||||||||||||||
2155 | [] | Kasvitarha | Köksträdgård | Kitchen garden | 853 | 2018-08-07T14:00:22.969353+03:00 | 3 | 368 | {} | [853] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2235 | [] | Viheralueiden hoito | Skötsel av grönområden | Green area maintenance | 787 | 2020-12-02T11:30:08.949266+02:00 | 3 | 491 | {} | [787] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
396 | [] | Jalkapallo | Fotboll | Football | 203 | 2018-08-07T14:00:22.956950+03:00 | 3 | 368 | {} | [203] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
437 | [] | Monistuspalvelu | Kopieringstjänst | Copying service | 443 | 2018-08-07T14:00:23.067329+03:00 | 3 | 368 | {} | [443] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
511 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.844464+03:00 | 3 | 505 | {} | [804] | 0 | 1403 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||||||
618 | [] | Petanque - halli | Petanquehall | Petanque hall | 512 | 2018-08-07T14:00:23.673008+03:00 | 4 | 614 | {} | [512] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
626 | [] | Parkour- Sali | Parkoursal | Parkour hall | 500 | 2018-08-07T14:00:23.737371+03:00 | 4 | 624 | {} | [500] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
651 | [] | Pyöräilyrata | Cykelåkningsbana | Velodrome | 539 | 2018-08-07T14:00:23.920549+03:00 | 4 | 646 | {} | [539] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
682 | [] | Soutustadion | Roddstadion | Rowing stadium | 643 | 2018-08-07T14:00:24.150686+03:00 | 4 | 677 | {} | [643] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
683 | [] | Vesihiihtoalue | Område för vattenskidåkning | Water ski area | 777 | 2018-08-07T14:00:24.157225+03:00 | 4 | 677 | {} | [777] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
691 | [] | Kylpylä | Badinrättning | Spa | 361 | 2018-08-07T14:00:24.210042+03:00 | 4 | 690 | {} | [361] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
700 | [] | Rantautumispaikka | Ilandstigningsplats | Boat dock | 571 | 2018-08-07T14:00:24.275183+03:00 | 4 | 695 | {} | [571] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
703 | [] | Tupa | Stuga | Hut | 721 | 2018-08-07T14:00:24.296823+03:00 | 4 | 695 | {} | [721] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
727 | [] | Kauppa | Butik | Store | 142*256 | 2018-08-07T14:00:24.462954+03:00 | 5 | 725 | {} | [256, 142] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
728 | [] | Kioski | Kiosk | Kiosk | 142*309 | 2018-08-07T14:00:24.470558+03:00 | 5 | 725 | {} | [309, 142] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
741 | [] | Kioskit | Kiosker | Kiosks | 309 | 2018-08-07T14:00:24.527473+03:00 | 3 | 718 | {} | [309] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
2154 | [] | Teatteri | Teater | Theatre | 852 | 2018-08-07T14:00:23.169545+03:00 | 3 | 368 | {} | [852] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2224 | [] | Seniorisäpinät | Seniorisäpinät | Seniorisäpinät | 903 | 2020-06-09T15:30:11.400501+03:00 | 3 | 2217 | {} | [903] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
438 | [] | Moottorihalli | Motorhall | Motorhall | 445 | 2018-08-07T14:00:23.074919+03:00 | 3 | 368 | {} | [445] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
452 | [] | Puutyö | Slöjd | Woodwork | 534 | 2018-08-07T14:00:23.113213+03:00 | 3 | 368 | {} | [534] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
473 | [] | Tanssi | Dans | Dance | 685 | 2018-08-07T14:00:23.163347+03:00 | 3 | 368 | {} | [685] | 0 | 1403 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
554 | [] | Esteratsastuskenttä | Bana för banhoppning | Show jumping field | 166 | 2018-08-07T14:00:23.236991+03:00 | 4 | 553 | {} | [166] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
579 | [] | Hevosreitti | Hästled | Horse track | 190 | 2018-08-07T14:00:23.406242+03:00 | 4 | 577 | {} | [190] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
596 | [] | Kilpahiihtokeskus | Skidtävlingscentrum | Ski competition centre | 307 | 2018-08-07T14:00:23.524927+03:00 | 4 | 592 | {} | [307] | 0 | 1403 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
620 | [] | Skeittihalli | Skateboardhall | Skateboarding hall | 631 | 2018-08-07T14:00:23.687502+03:00 | 4 | 614 | {} | [631] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
661 | [] | Rullakiekkokenttä | Inlinehockeyplan | Roller hockey field | 585 | 2018-08-07T14:00:24.003615+03:00 | 4 | 654 | {} | [585] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
711 | [] | Monikäyttöalue, jolla on virkistyspalveluita | Allaktivitetsområde med rekreationstjänster | Multipurpose area with recreational services | 442 | 2018-08-07T14:00:24.344046+03:00 | 4 | 706 | {} | [442] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
730 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 142*776 | 2018-08-07T14:00:24.485125+03:00 | 4 | 719 | {} | [776, 142] | 0 | 1403 | 3 | 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 | |||||||||||||||||||||||||||||||||
2026 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:22.565354+03:00 | 3 | 345 | {} | [312] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
356 | [] | Kurssitoiminta | Kursverksamhet | Courses | 356 | 2018-08-07T14:00:22.623521+03:00 | 3 | 352 | {} | [356] | 0 | 1403 | 4 | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
573 | [] | Kiipeilykallio | Klätterberg | Climbing rock | 306 | 2018-08-07T14:00:23.375633+03:00 | 4 | 572 | {} | [306] | 0 | 1403 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
656 | [] | Jalkapallostadion | Fotbollsstadion | Football stadium | 205 | 2018-08-07T14:00:23.964244+03:00 | 4 | 654 | {} | [205] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
672 | [] | Moottoripyöräilyalue | Område för motorcykelsport | Motorcycling area | 448 | 2018-08-07T14:00:24.080942+03:00 | 4 | 667 | {} | [448] | 0 | 1403 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
697 | [] | Laavu, kota tai kammi | Vindskydd eller kåta | Lean-to, goahti (Lapp tent shelter) or 'kammi' earth lodge | 365 | 2018-08-07T14:00:24.250943+03:00 | 4 | 695 | {} | [365] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
713 | [] | Retkeilyalue | Utflyktsområde | Hiking area | 581 | 2018-08-07T14:00:24.359089+03:00 | 4 | 706 | {} | [581] | 0 | 1403 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
723 | [] | Lipunmyynti | Biljettförsäljning | Ticket sales | 403 | 2018-08-07T14:00:24.435423+03:00 | 4 | 719 | {} | [403] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
403 | [] | Keramiikka | Keramik | Pottery | 287 | 2018-08-07T14:00:22.976243+03:00 | 3 | 368 | {} | [287] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
418 | [] | Kuvataide | Bildkonst | Visual arts | 359 | 2018-08-07T14:00:23.020022+03:00 | 3 | 368 | {} | [359] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
433 | [] | Media | Media | Media | 433 | 2018-08-07T14:00:23.060583+03:00 | 3 | 368 | {} | [433] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
440 | [] | Mopokerho | Mopedklubb | Moped club | 452 | 2018-08-07T14:00:23.082022+03:00 | 3 | 368 | {} | [452] | 0 | 1403 | 2 | 5 | 2 | 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 | |||||||||||||||||||||||||||||||||
497 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:22.733778+03:00 | 4 | 493 | {} | [321] | 0 | 1403 | 4 | 5 | 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 );