service_node
297 rows where root = 1403 sorted by name_fi
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)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
371 | [] | Askartelu | Hobbyverksamhet | Hobby crafts | 72 | 2018-08-07T14:00:22.898108+03:00 | 3 | 368 | {} | [72] | 0 | 1403 | 3 | 9 | 2 | 4 | |||||||||||||||||||||||||||||||
2208 | [] | Asukastilat | Invånarlokaler | Resident facilities | 888 | 2019-10-22T09:30:07.500577+03:00 | 3 | 505 | {} | [888] | 0 | 1403 | 1 | 12 | 2 | 9 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 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 | ||||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
721 | [] | Eläintarha | Högholmens djurgård | Helsinki Zoo | 142 | 2018-08-07T14:00:24.428725+03:00 | 4 | 719 | {} | [142] | 0 | 1403 | 9 | 9 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
346 | [] | Erikoiskirjastot | Specialbibliotek | Special libraries | 155 | 2018-08-07T14:00:22.558572+03:00 | 3 | 345 | {"fi": ["kirjastot"]} | [155] | 0 | 1403 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
635 | [] | Golfin harjoitusalue | Träningsområde för golf | Golf training area | 173 | 2018-08-07T14:00:23.802245+03:00 | 4 | 634 | {} | [173] | 0 | 1403 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
636 | [] | Golfin harjoitushalli | Övningshall för golf | Golf training hall | 174 | 2018-08-07T14:00:23.808994+03:00 | 4 | 634 | {} | [174] | 0 | 1403 | 6 | 10 | 4 | ||||||||||||||||||||||||||||||||
637 | [] | Golfkenttä | Golfbana | Golf course | 175 | 2018-08-07T14:00:23.815939+03:00 | 4 | 634 | {} | [175] | 0 | 1403 | 4 | 16 | 9 | 3 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
603 | [] | Harjoitusjäähalli | Övningsishall | Training ice arena | 187 | 2018-08-07T14:00:23.568317+03:00 | 4 | 602 | {} | [187] | 0 | 1403 | 10 | 17 | 5 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
506 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.804088+03:00 | 3 | 505 | {} | [799] | 0 | 1403 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
579 | [] | Hevosreitti | Hästled | Horse track | 190 | 2018-08-07T14:00:23.406242+03:00 | 4 | 577 | {} | [190] | 0 | 1403 | 2 | 3 | 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 | ||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 1 | 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 | ||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
2168 | [] | Hyvän olon palvelut | Välbefinnandetjänster | Well-being services | 864 | 2018-08-07T14:00:24.617742+03:00 | 3 | 718 | {} | [864] | 0 | 1403 | 34 | 37 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
563 | [] | Jousiammuntarata | Bågskyttebana | Archery range | 213 | 2018-08-07T14:00:23.312216+03:00 | 4 | 559 | {} | [213] | 0 | 1403 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
399 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 231 | 2018-08-07T14:00:22.963009+03:00 | 3 | 368 | {} | [231] | 0 | 1403 | 6 | 8 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
492 | [] | Kahluualtaat | Plaskdammer | Wading pools | 238 | 2018-08-07T14:00:22.690959+03:00 | 3 | 491 | {} | [238] | 0 | 1403 | 49 | 49 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
609 | [] | Kamppailulajien sali | Sal för kampsport | Martial arts hall | 241 | 2018-08-07T14:00:23.609044+03:00 | 4 | 608 | {} | [241] | 0 | 1403 | 47 | 64 | 13 | 4 | |||||||||||||||||||||||||||||||
670 | [] | Karting-rata | Kartingbana | Kart circuit | 245 | 2018-08-07T14:00:24.066651+03:00 | 4 | 667 | {} | [245] | 0 | 1403 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
2155 | [] | Kasvitarha | Köksträdgård | Kitchen garden | 853 | 2018-08-07T14:00:22.969353+03:00 | 3 | 368 | {} | [853] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
367 | [] | Katutaidepaikat | Platser för gatukonst | Street art locations | 254 | 2018-08-07T14:00:22.877110+03:00 | 2 | 365 | {} | [254] | 0 | 1403 | 12 | 12 | |||||||||||||||||||||||||||||||||
641 | [] | Kaukalo | Rink | Rink | 235 | 2018-08-07T14:00:23.842218+03:00 | 4 | 639 | {} | [235] | 0 | 1403 | 13 | 15 | 2 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
727 | [] | Kauppa | Butik | Store | 142*256 | 2018-08-07T14:00:24.462954+03:00 | 5 | 725 | {} | [256, 142] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
740 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:24.520703+03:00 | 3 | 718 | {} | [259] | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
596 | [] | Kilpahiihtokeskus | Skidtävlingscentrum | Ski competition centre | 307 | 2018-08-07T14:00:23.524927+03:00 | 4 | 592 | {} | [307] | 0 | 1403 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2026 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:22.565354+03:00 | 3 | 345 | {} | [312] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
495 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:22.718157+03:00 | 4 | 493 | {} | [319] | 0 | 1403 | 5 | 5 | |||||||||||||||||||||||||||||||||
496 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:22.725829+03:00 | 4 | 493 | {} | [320] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
497 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:22.733778+03:00 | 4 | 493 | {} | [321] | 0 | 1403 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
2196 | [] | Korkeakoulujen kirjastot | Högskolebibliotek | Polytechnic libraries | 880 | 2019-04-02T13:30:07.763547+03:00 | 3 | 345 | {} | [880] | 0 | 1403 | 8 | 14 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||
2153 | [] | Kosketusnäyttöopasteet | Infokiosker med pekskärm | Touch screen guideposts | 851 | 2018-08-07T14:00:24.869369+03:00 | 3 | 329 | {} | [851] | 0 | 1403 | 21 | 21 | |||||||||||||||||||||||||||||||||
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 |
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 );