service_node
83 rows where unit_count_municipality_vantaa = 2
This data as json, CSV (advanced)
Suggested facets: children, level, keywords, period_enabled, root, unit_count_municipality_helsinki, unit_count_total, unit_count_municipality_espoo, unit_count_municipality_kauniainen
name_sv ✖
- Rådgivning för åldringar 3
- Akutvård och rehabilitering inom missbrukarvården 2
- Högskolebibliotek 2
- Poliklinisk vård inom missbrukarvården 2
- Teatrar 2
- A-ryska 1
- A-spanska 1
- B2-franska 1
- Badstrand 1
- Barer och nattliv 1
- Bobollsstadion 1
- Bostadsbidrag 1
- Bowlinghall 1
- Bowlinghallar 1
- Bygglov och åtgärdstillstånd 1
- Catering 1
- Dansutrymmen 1
- Djurskydd 1
- Ekonomiskt stöd inom vård av utvecklingsstörda 1
- Evenemangsmarknadsföring 1
- FPA:s förmåner 1
- Familjedagvårdens styrningsområde 1
- Flickklubb / flickgrupper 1
- Flyttning av fordon 1
- Fotboll 1
- Fotvård 1
- Färdtjänst enligt handikappservicelagen 1
- Färdtjänst enligt socialvårdslagen 1
- Förmåner för barnfamiljer 1
- Förmåner för elever och studerande 1
- ...
last_modified_time (date) ✖
- 2018-08-07 72
- 2018-10-25 6
- 2019-03-20 1
- 2019-04-02 1
- 2020-03-06 1
- 2020-06-09 1
- 2020-08-20 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | [] | Asumisen tuet | Bostadsbidrag | Housing allowances | 75 | 2018-08-07T14:00:21.243003+03:00 | 2 | 2 | {} | [75] | 0 | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
44 | [] | Pahvinkeräys | Insamling av wellpapp | Corrugated cardboard recycling | 491 | 2018-08-07T14:00:21.860147+03:00 | 3 | 34 | {} | [491] | 0 | 1400 | 2 | 7 | 1 | 2 | 2 | ||||||||||||||||||||||||||||||
103 | [104, 105, 106, 107, 109, 110, 111, 113, 114] | Ympäristöterveydenhuolto | Miljö- och hälsoskydd | Environmental health | 2018-08-07T14:00:21.574018+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 4 | 9 | 2 | 1 | 2 | |||||||||||||||||||||||||||||||
107 | [] | Eläinsuojelu | Djurskydd | Animal protection | 141 | 2018-08-07T14:00:21.598706+03:00 | 3 | 103 | {} | [141] | 0 | 1400 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
130 | [] | Eläkkeet | Pensioner | Pension matters | 143 | 2018-08-07T14:00:30.054750+03:00 | 2 | 122 | {} | [143] | 0 | 1401 | 4 | 10 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
144 | [] | Matkailumarkkinointi | Marknadsföring av turism | Tourism marketing | 428 | 2018-08-07T14:00:30.145003+03:00 | 3 | 141 | {} | [428] | 0 | 1401 | 2 | 4 | 2 | ||||||||||||||||||||||||||||||||
145 | [] | Tapahtumamarkkinointi | Evenemangsmarknadsföring | Event marketing | 688 | 2018-08-07T14:00:30.151217+03:00 | 3 | 141 | {} | [688] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
168 | [] | Alkavien yrittäjien neuvonta | Rådgivning för nya företagare | Advice for start-up entrepreneurs | 48 | 2018-08-07T14:00:30.339989+03:00 | 3 | 167 | {} | [48] | 0 | 1401 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
179 | [] | Kirjaamo | Registratorskontor | Registrar's office | 310 | 2018-08-07T14:00:30.455188+03:00 | 2 | 171 | {} | [310] | 0 | 1401 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
188 | [] | Kelan etuudet | FPA:s förmåner | Kela benefits | 286 | 2018-08-07T14:00:30.511334+03:00 | 3 | 187 | {} | [286] | 0 | 1401 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
219 | [220] | Tuet ja avustukset | Understöd och bidrag | Grants and benefits | 715 | 2018-08-07T14:00:30.723645+03:00 | 2 | 171 | {} | [715] | 0 | 1401 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
225 | [] | Kaavat ja kaavoitus | Planer och planlägging | Town plans and zoning | 237 | 2018-08-07T14:00:22.018653+03:00 | 3 | 222 | {} | [237] | 0 | 1400 | 5 | 9 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
282 | [] | Rakennus- ja toimenpideluvat | Bygglov och åtgärdstillstånd | Licences for construction and operations | 558 | 2018-08-07T14:00:22.390024+03:00 | 4 | 279 | {} | [558] | 0 | 1400 | 1 | 5 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
322 | [] | Karttapalvelut, ilmakuvat ja karttojen tilaus | Karttjänster, flygbilder och beställning av kartor | Mapping services, aerial photographs and ordering maps | 247 | 2018-08-07T14:00:24.808369+03:00 | 3 | 320 | {} | [247] | 0 | 1402 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
323 | [] | Paikkatietoneuvonta ja -aineistot | Rådgivning och material inom geografisk information | Location information guidance and archives | 492 | 2018-08-07T14:00:24.814824+03:00 | 3 | 320 | {} | [492] | 0 | 1402 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
334 | [335, 337, 338] | Tarjolla oheislaitteita | Kringutrustning finns | Supplementary equipment available | 2018-08-07T14:00:24.905778+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 54 | 56 | 2 | |||||||||||||||||||||||||||||||||
337 | [] | Skanneri | Skanner | Scanner | 691 | 2018-08-07T14:00:24.926601+03:00 | 5 | 334 | {} | [691] | 0 | 1402 | 43 | 45 | 2 | ||||||||||||||||||||||||||||||||
338 | [] | Tulostin | Skrivare | Printer | 692 | 2018-10-25T08:00:07.357556+03:00 | 5 | 334 | {} | [692] | 0 | 1402 | 52 | 54 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
526 | [527, 528, 2207, 529, 530, 2204, 532] | Pysäköinti | Parkering | Parking | 2018-08-07T14:00:25.093849+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 559 | 1023 | 460 | 2 | 2 | |||||||||||||||||||||||||||||||
527 | [] | Ajoneuvojen siirrot | Flyttning av fordon | Towing vehicles | 44 | 2018-08-07T14:00:25.100072+03:00 | 3 | 526 | {} | [44] | 0 | 1402 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
596 | [] | Kilpahiihtokeskus | Skidtävlingscentrum | Ski competition centre | 307 | 2018-08-07T14:00:23.524927+03:00 | 4 | 592 | {} | [307] | 0 | 1403 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
607 | [] | Keilahalli | Bowlinghall | Bowling alley | 285 | 2018-08-07T14:00:23.595829+03:00 | 4 | 606 | {} | [285] | 0 | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
627 | [] | Pöytätennistila | Utrymme för bordtennis | Table tennis venue | 556 | 2018-08-07T14:00:23.745237+03:00 | 4 | 624 | {} | [556] | 0 | 1403 | 22 | 46 | 22 | 2 | |||||||||||||||||||||||||||||||
629 | [] | Sisäkiipeilyseinä | Klättervägg inomhus | Indoor climbing wall | 624 | 2018-08-07T14:00:23.760205+03:00 | 4 | 624 | {} | [624] | 0 | 1403 | 14 | 19 | 3 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
647 | [] | Liikuntapuisto | Idrottspark | Sports park | 401 | 2018-08-07T14:00:23.890605+03:00 | 4 | 646 | {} | [401] | 0 | 1403 | 7 | 3 | 2 | 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 | |||||||||||||||||||||||||||||||
670 | [] | Karting-rata | Kartingbana | Kart circuit | 245 | 2018-08-07T14:00:24.066651+03:00 | 4 | 667 | {} | [245] | 0 | 1403 | 2 | 5 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
687 | [] | Talviuintipaikka | Vinterbadplats | Winter swimming area | 684 | 2018-08-07T14:00:24.182493+03:00 | 4 | 685 | {} | [684] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
689 | [] | Uimaranta | Badstrand | Supervised beach | 731 | 2018-08-07T14:00:24.196951+03:00 | 4 | 685 | {} | [731] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
699 | [] | Opastuspiste | Information punkt | Information point | 482 | 2018-08-07T14:00:24.267790+03:00 | 4 | 695 | {} | [482] | 0 | 1403 | 51 | 73 | 1 | 2 | 2 | 14 | 2 | 1 | |||||||||||||||||||||||||||
752 | [] | Teatterit | Teatrar | Theatres | 694 | 2018-08-07T14:00:24.603285+03:00 | 3 | 718 | {} | [694] | 0 | 1403 | 50 | 62 | 10 | 2 | |||||||||||||||||||||||||||||||
755 | [756, 768, 769] | Oikeusturva ja demokratia | Rättsskydd och demokrati | Justice system and democracy | 2020-03-06T18:32:09.608464+02:00 | 1 | 1401 | {} | [] | 0 | 1401 | 15 | 46 | 28 | 2 | 1 | |||||||||||||||||||||||||||||||
786 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:27.716150+03:00 | 2 | 784 | {} | [199] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
797 | [] | Lapsiperheen tuet | Förmåner för barnfamiljer | Benefits for families with children | 370 | 2020-08-20T14:00:09.399199+03:00 | 1 | 783 | {} | [370] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
805 | [] | Vammaispalvelulain mukainen kuljetuspalvelu | Färdtjänst enligt handikappservicelagen | Transportation service according to the legislation on disability services | 745 | 2018-08-07T14:00:27.849436+03:00 | 2 | 798 | {} | [745] | 0 | 783 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
818 | [] | Kehitysvammahuollon taloudellinen tuki | Ekonomiskt stöd inom vård av utvecklingsstörda | Care of the developmentally disabled, financial support | 281 | 2018-08-07T14:00:27.931547+03:00 | 2 | 810 | {} | [281] | 0 | 783 | 2 | 4 | 2 | ||||||||||||||||||||||||||||||||
821 | [] | Vanhuspalvelun sosiaaliohjaus | Socialhandledning inom äldreomsorg | Services for the elderly, social care work | 763 | 2018-08-07T14:00:27.957632+03:00 | 2 | 819 | {} | [763] | 0 | 783 | 4 | 7 | 2 | 1 | |||||||||||||||||||||||||||||||
824 | [] | Vanhusten itsenäinen asuminen | Självständigt boende för äldre | Independent habitation for the elderly | 757 | 2018-08-07T14:00:27.977916+03:00 | 2 | 819 | {} | [757] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
827 | [] | Vanhuspalvelun omaishoidon tuki | Stöd för närståendevårdare inom äldreomsorgen | Care for the elderly, close relative care support | 759 | 2018-08-07T14:00:27.996868+03:00 | 2 | 819 | {} | [759] | 0 | 783 | 4 | 8 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
833 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:28.034805+03:00 | 2 | 830 | {} | [546] | 0 | 783 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
837 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:28.061184+03:00 | 2 | 830 | {} | [544] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
843 | [] | Perustoimeentulotuki | Grundläggande utkomststöd | Basic social assistance | 711 | 2018-08-07T14:00:28.092481+03:00 | 2 | 839 | {} | [711] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
848 | [] | Aikuisten sosiaaliohjaus | Socialhandledning för vuxna | Social care work for adults | 41 | 2018-08-07T14:00:28.131053+03:00 | 2 | 845 | {} | [41] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
853 | [] | Sosiaalihuoltolain mukainen kuljetuspalvelu | Färdtjänst enligt socialvårdslagen | Transportation service according to the legislation on social welfare | 640 | 2018-08-07T14:00:28.169839+03:00 | 2 | 845 | {} | [640] | 0 | 783 | 3 | 6 | 2 | 1 | |||||||||||||||||||||||||||||||
859 | [] | Yhteiset tukipalvelut | Gemensamma stödtjänster | Shared support services | 639 | 2018-08-07T14:00:28.209104+03:00 | 1 | 783 | {} | [639] | 0 | 783 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
945 | [946] | Venäjänkielinen päivähoito | Ryskspråkig dagvård | Day care in Russian | 773 | 2018-08-07T14:00:28.731246+03:00 | 3 | 869 | {} | [773] | 0 | 1405 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
946 | [] | päivähoito | dagvård | day care | 773 | 2018-08-07T14:00:28.740210+03:00 | 4 | 945 | {} | [773] | 0 | 1405 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
962 | [] | Perhepäivähoidon ohjausalue | Familjedagvårdens styrningsområde | Family day care guidance area | 506 | 2018-08-07T14:00:28.870469+03:00 | 3 | 961 | {} | [506] | 0 | 1405 | 14 | 16 | 2 | ||||||||||||||||||||||||||||||||
998 | [] | Tartuntaudit | Smittsamma sjukdomar | Infectious diseases | 693 | 2018-08-07T14:00:29.221985+03:00 | 1 | 986 | {"fi": ["tartuntatauti", "tartuntataudit"]} | [693] | 0 | 986 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
1024 | [] | Psykiatrinen asumiskuntoutus | Psykiatrisk boenderehabilitering | Psychiatric residential rehabilitation | 522 | 2018-08-07T14:00:29.444521+03:00 | 2 | 1019 | {} | [522] | 0 | 986 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 1 | |||||||||||||||||||||||||||||||
1054 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:29.702337+03:00 | 2 | 1051 | {} | [546] | 0 | 986 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
1058 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:29.732968+03:00 | 2 | 1051 | {} | [544] | 0 | 986 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
1080 | [1081] | Tulli | Tullen | Customs | 2018-08-07T14:00:29.915254+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 4 | 7 | 1 | 2 | ||||||||||||||||||||||||||||||||
1081 | [] | Tullin asiointipisteet | Tullens verksamhetsställen | Customs offices | 716 | 2018-08-07T14:00:29.921102+03:00 | 2 | 1080 | {} | [716] | 0 | 1061 | 4 | 7 | 1 | 2 | |||||||||||||||||||||||||||||||
1101 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 149 | 2018-10-25T08:00:07.601071+03:00 | 4 | 1099 | {} | [149] | 1 | 1087 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
1119 | [] | Lisäopetus (10. luokka) | Påbyggnadsundervisning (10:de klass) | Supplementary education (10th grade) | 657 | 2018-10-25T08:00:07.670545+03:00 | 3 | 1098 | {} | [657] | 1 | 1087 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
1165 | [] | B2-ranska | B2-franska | B2-French | 149*119+150*119+162*119+163*119+301*119+302*119+384*119+385*119+567*119+568*119+612*119+613*119+661*119+662*119+771*119+772*119+793*119+794*119+865*119+866*119 | 2018-10-25T08:00:08.088270+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 119] | 1 | 1087 | 48 | 72 | 22 | 2 | |||||||||||||||||||||||||||||||
1275 | [] | A-espanja | A-spanska | A-Spanish | 148*5+161*5+300*5+383*5+566*5+611*5+658*5+770*5+792*5 | 2018-10-25T08:00:08.569813+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 5] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1282 | [] | A-venäjä | A-ryska | A-Russian | 148*14+161*14+300*14+383*14+566*14+611*14+658*14+770*14+792*14 | 2018-10-25T08:00:08.627334+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 14] | 1 | 1087 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
1375 | [] | Koulupsykologi | Skolpsykolog | School psychologist | 343 | 2018-08-07T14:00:27.641064+03:00 | 2 | 1372 | {} | [343] | 0 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1377 | [] | Oppilaan ja opiskelijan tuet | Förmåner för elever och studerande | Pupil and student benefits | 485 | 2018-08-07T14:00:27.654181+03:00 | 1 | 1087 | {} | [485] | 0 | 1087 | 4 | 15 | 1 | 7 | 2 | 1 | |||||||||||||||||||||||||||||
2146 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:29.136711+03:00 | 2 | 988 | {} | [199] | 0 | 986 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2148 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:24.771984+03:00 | 4 | 2147 | {} | [199] | 0 | 1402 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2193 | [] | Korkeakoulujen kirjastot | Högskolebibliotek | Polytechnic libraries | 880 | 2019-03-20T13:30:07.442599+02:00 | 3 | 324 | {} | [880] | 0 | 1402 | 8 | 14 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
2225 | [] | Senioritanssi | Seniordans | Senior dancing | 900 | 2020-06-09T15:30:11.415952+03:00 | 3 | 2217 | {} | [900] | 0 | 1403 | 24 | 29 | 2 | 2 | 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 );