service_node
87 rows where level = 1
This data as json, CSV (advanced)
Suggested facets: parent, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_mäntsälä, unit_count_municipality_hyvinkää, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] | Asumisympäristö | Boendemiljön | Housing environment | 2018-08-07T14:00:21.308151+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 1002 | 1524 | 2 | 2 | 294 | 218 | 6 | |||||||||||||||||||||||||||||
| 2 | [3, 4, 5, 7, 2191, 8] | Asuminen | Boende | Housing | 2018-08-07T14:00:21.231002+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 742 | 1530 | 16 | 23 | 1 | 1 | 27 | 51 | 40 | 246 | 3 | 256 | 35 | 10 | 1 | 37 | 41 | |||||||||||||||||||
| 14 | [16, 23] | Eläimet | Djur | Animals | 2018-08-07T14:00:21.679608+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 103 | 150 | 22 | 25 | ||||||||||||||||||||||||||||||||
| 24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
| 31 | [32, 33, 34, 52, 53, 54] | Jätehuolto ja kierrätys | Avfallshantering och återvinning | Waste management and recycling | 2018-08-07T14:00:21.761620+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 215 | 572 | 1 | 150 | 186 | 20 | ||||||||||||||||||||||||||||||
| 85 | [87, 88, 91, 93] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:21.953530+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 122 | [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] | Elinkeino, työ ja verotus | Näringar, arbete och beskattning | Entrepreneurship, work and taxation | 2018-08-07T14:00:29.995212+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 322 | 452 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 51 | 62 | 5 | 1 | |||||||||||||||||||||||
| 171 | [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] | Hallinto ja talous | Förvaltning och ekonomi | Administration and economy | 2018-08-07T14:00:30.363012+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 124 | 163 | 1 | 1 | 17 | 17 | 2 | 1 | ||||||||||||||||||||||||||||
| 221 | [222, 231, 270, 305] | Kaavoitus, kiinteistöt ja rakentaminen | Planläggning, fastigheter och byggande | Planning, real estate and construction | 2018-08-07T14:00:21.996119+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 367 | 506 | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 54 | 69 | 6 | ||||||||||||||||||||||||
| 306 | [307, 314, 320, 324, 329, 342] | Kartat, tietopalvelut ja viestintä | Kartor, informationstjänster och kommunikation | Maps, information services and communication | 2018-08-07T14:00:24.652419+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 307 | 389 | 1 | 42 | 36 | 3 | ||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||
| 365 | [2162, 2156, 368, 367, 366, 490] | Nuoriso | Ungdom | Youth | 2018-08-07T14:00:22.862181+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 82 | 146 | 1 | 1 | 30 | 29 | 3 | |||||||||||||||||||||||||||||
| 512 | [513, 521, 525, 526, 533, 534, 541] | Liikenne | Trafik | Traffic | 2018-08-07T14:00:24.996122+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 1269 | 1864 | 1 | 4 | 2 | 1 | 2 | 540 | 39 | 6 | ||||||||||||||||||||||||||
| 551 | [552, 2151, 558, 2217, 601, 633, 666, 684, 694] | Liikunta | Idrott och motion | Sports and physical exercise | 2018-08-07T14:00:23.220207+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 2590 | 4872 | 16 | 3 | 19 | 1 | 1 | 11 | 1260 | 1 | 892 | 36 | 42 | |||||||||||||||||||||||
| 717 | [754, 718, 2173, 2028] | Matkailu ja tapahtumat | Turism och evenemang | Things to do | 2020-03-06T18:32:07.102459+02:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1973 | 2155 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 5 | 3 | 87 | 67 | 1 | 1 | 3 | 4 | ||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 784 | [786, 785] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:27.703824+03:00 | 1 | 783 | {} | [] | 0 | 783 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
| 787 | [789, 790, 788] | Lastensuojelu | Barnskydd | Child welfare | 2018-10-25T08:00:09.006369+03:00 | 1 | 783 | {} | [] | 0 | 783 | 37 | 81 | 1 | 17 | 24 | 1 | 1 | |||||||||||||||||||||||||||||
| 791 | [794, 795, 792, 793, 796] | Muut perheiden palvelut | Övriga tjänster för familjer | Other family services | 2018-08-07T14:00:27.754089+03:00 | 1 | 783 | {} | [] | 0 | 783 | 16 | 40 | 4 | 18 | 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 | |||||||||||||||||||||||||||||
| 798 | [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] | Vammaispalvelut | Handikapptjänster | Services for the disabled | 2018-08-07T14:00:27.804536+03:00 | 1 | 783 | {} | [] | 0 | 783 | 14 | 59 | 2 | 7 | 34 | 1 | 1 | |||||||||||||||||||||||||||||
| 810 | [815, 816, 817, 813, 812, 811, 818, 814, 1007] | Kehitysvammahuolto | Vård av utvecklingsstörda | Care for the developmentally disabled | 2018-08-07T14:00:27.882619+03:00 | 1 | 783 | {} | [] | 0 | 783 | 56 | 109 | 12 | 36 | 2 | 3 | ||||||||||||||||||||||||||||||
| 819 | [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] | Vanhuspalvelu | Äldreomsorg | Service for the elderly | 2018-08-07T14:00:27.946229+03:00 | 1 | 783 | {} | [] | 0 | 783 | 142 | 261 | 1 | 67 | 44 | 6 | 1 | |||||||||||||||||||||||||||||
| 830 | [836, 837, 834, 833, 835, 832, 831, 838, 2157] | Päihdepalvelut | Service för missbrukare | Services for substance abusers | 2018-08-07T14:00:28.016024+03:00 | 1 | 783 | {} | [] | 0 | 783 | 29 | 56 | 12 | 14 | 1 | |||||||||||||||||||||||||||||||
| 839 | [2011, 841, 843, 2012] | Toimeentulotuki | Utkomststöd | Social assistance | 2018-08-07T14:00:28.080690+03:00 | 1 | 783 | {} | [] | 0 | 783 | 11 | 20 | 1 | 3 | 3 | 1 | 1 | |||||||||||||||||||||||||||||
| 845 | [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] | Muu sosiaalihuolto | Övrig socialvård | Other social welfare | 2018-08-07T14:00:28.112184+03:00 | 1 | 783 | {} | [] | 0 | 783 | 105 | 239 | 1 | 11 | 118 | 3 | 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 | ||||||||||||||||||||||||||||||||
| 860 | [] | Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) | Stödtjänster inom social- och hälsovården (stöd för boende) | Social and health care services' security services (housing support) | 636 | 2018-08-07T14:00:28.215634+03:00 | 1 | 783 | {} | [636] | 0 | 783 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 861 | [] | Hoitoalan ruokapalvelut | Mattjänster inom vårdbranschen | Meal services in the care sector | 196 | 2018-08-07T14:00:28.222009+03:00 | 1 | 783 | {} | [196] | 0 | 783 | 12 | 12 | |||||||||||||||||||||||||||||||||
| 866 | [] | Hallinto | Förvaltning | Administration | 180 | 2018-08-07T14:00:28.228192+03:00 | 1 | 783 | {} | [180] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 868 | [2029, 975, 961, 985, 869, 983] | Lasten päivähoito | Barndagvård | Day care | 2020-03-06T18:32:08.678128+02:00 | 1 | 1405 | {} | [] | 0 | 1405 | 675 | 1264 | 365 | 212 | 12 | |||||||||||||||||||||||||||||||
| 988 | [2146, 989] | Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta | Rådgivning om social- och hälsovårdstjänster och för äldre | Information and advice of social and health services and for elderly people | 2018-08-07T14:00:29.124487+03:00 | 1 | 986 | {} | [] | 0 | 986 | 1 | 13 | 1 | 3 | 8 | |||||||||||||||||||||||||||||||
| 990 | [] | Apteekki | Apotek | Pharmacy | 57 | 2018-08-07T14:00:29.143841+03:00 | 1 | 986 | {} | [57] | 0 | 986 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
| 991 | [] | Terveysasemat | Hälsostationer | Health stations | 703 | 2018-08-07T14:00:29.153043+03:00 | 1 | 986 | {"fi": ["mielenterveys", "terveysasemat"]} | [703] | 0 | 986 | 25 | 49 | 12 | 11 | 1 | ||||||||||||||||||||||||||||||
| 992 | [] | Lääkärin vastaanotto | Läkarmottagning | Doctor's reception | 417 | 2018-08-07T14:00:29.162295+03:00 | 1 | 986 | {"fi": ["mielenterveys", "terveysasemat"]} | [417] | 0 | 986 | 26 | 50 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
| 993 | [] | Terveydenhoitajan vastaanotto | Hälsovårdarens mottagning | Nurse's reception | 702 | 2018-08-07T14:00:29.169309+03:00 | 1 | 986 | {} | [702] | 0 | 986 | 26 | 50 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
| 994 | [] | Työterveyshuolto | Företagshälsovård | Occupational health care | 726 | 2018-08-07T14:00:29.175755+03:00 | 1 | 986 | {} | [726] | 0 | 986 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 995 | [] | Hammashoito | Tandvård | Dental care | 184 | 2020-03-06T18:32:09.101816+02:00 | 1 | 986 | {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} | [184] | 0 | 986 | 36 | 98 | 20 | 41 | 1 | ||||||||||||||||||||||||||||||
| 996 | [] | Kotihoito | Hemvård | Home care | 635 | 2020-03-06T18:32:09.105708+02:00 | 1 | 986 | {} | [635] | 0 | 986 | 69 | 95 | 19 | 4 | 3 | ||||||||||||||||||||||||||||||
| 997 | [2164, 2166] | Koulu- ja opiskeluterveydenhuolto | Skol- och studenthälsovård | School and student health services | 2018-10-25T08:00:09.578039+03:00 | 1 | 986 | {} | [] | 0 | 986 | 241 | 320 | 1 | 2 | 68 | 1 | 7 | |||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 999 | [] | Myrkytystietoa | Giftinformation | Poison information | 461 | 2018-08-07T14:00:29.228018+03:00 | 1 | 986 | {} | [461] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1000 | [1001, 1002, 1003] | Päivystys | Jour | Emergency services | 2018-08-07T14:00:29.234256+03:00 | 1 | 986 | {} | [] | 0 | 986 | 6 | 4 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 1004 | [1005, 1006, 1008] | Neuvolat | Rådgivningar | Maternity and child health guidance | 463 | 2018-08-07T14:00:29.268764+03:00 | 1 | 986 | {} | [463] | 0 | 986 | 23 | 53 | 19 | 10 | 1 | ||||||||||||||||||||||||||||||
| 1009 | [1011, 1012, 1013, 2161, 1014, 1015, 1016, 1010] | Sairaalat | Sjukhus | Hospitals | 2018-08-07T14:00:29.308401+03:00 | 1 | 986 | {} | [] | 0 | 986 | 35 | 52 | 1 | 1 | 6 | 2 | 5 | 2 | ||||||||||||||||||||||||||||
| 1017 | [] | Laboratorio | Laboratorium | Laboratory | 366 | 2018-08-07T14:00:29.386729+03:00 | 1 | 986 | {} | [366] | 0 | 986 | 22 | 88 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 2 | 6 | 3 | 3 | 1 | 7 | 1 | 10 | 1 | 3 | 1 | 8 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | ||||||
| 1018 | [] | Röntgen | Röntgen | X-rays | 606 | 2018-08-07T14:00:29.396972+03:00 | 1 | 986 | {} | [606] | 0 | 986 | 11 | 42 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 1 | 1 | 6 | 1 | 1 | 1 | 1 | 1 | |||||||||||||
| 1019 | [1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027] | Mielenterveyspalvelut | Psykiatriska tjänster | Mental health care | 2018-08-07T14:00:29.405061+03:00 | 1 | 986 | {} | [] | 0 | 986 | 29 | 36 | 2 | 5 | ||||||||||||||||||||||||||||||||
| 1028 | [1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038] | Kuntoutus | Rehabilitering | Rehabilitation | 2018-08-07T14:00:29.478107+03:00 | 1 | 986 | {} | [] | 0 | 986 | 33 | 67 | 16 | 16 | 2 | |||||||||||||||||||||||||||||||
| 1039 | [] | Ravitsemusterapia | Näringsterapi | Nutrition therapy | 579 | 2018-08-07T14:00:29.591225+03:00 | 1 | 986 | {} | [579] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1041 | [] | Psykologitoiminta | Psykologverksamhet | Psychologists | 525 | 2018-08-07T14:00:29.598972+03:00 | 1 | 986 | {} | [525] | 0 | 986 | 4 | 10 | 1 | 4 | 1 | ||||||||||||||||||||||||||||||
| 1042 | [] | Kuulontutkimus | Hörseltester | Hearing tests | 357 | 2018-08-07T14:00:29.607627+03:00 | 1 | 986 | {} | [357] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1043 | [] | Omahoitotarvikejakelu | Utdelning av egenvårdsartiklar | Distribution of self-care supplies | 477 | 2018-08-07T14:00:29.623935+03:00 | 1 | 986 | {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} | [477] | 0 | 986 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
| 1044 | [] | Silmätaudit | Ögonsjukdomar | Eye diseases | 622 | 2018-08-07T14:00:29.630771+03:00 | 1 | 986 | {} | [622] | 0 | 986 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 1048 | [1050] | Hallintopalvelut | Förvaltningstjänster | Patient representative services | 2020-03-06T18:32:09.249350+02:00 | 1 | 986 | {} | [] | 0 | 986 | 1 | 1 | ||||||||||||||||||||||||||||||||||
| 1051 | [1057, 1058, 1055, 1054, 1056, 1053, 1052, 1059, 2158] | Päihdepalvelut | Service för missbrukare | Services for substance abusers | 2018-08-07T14:00:29.682313+03:00 | 1 | 986 | {} | [] | 0 | 986 | 29 | 56 | 12 | 14 | 1 | |||||||||||||||||||||||||||||||
| 1060 | [] | Terveyspalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter inom hälso- och sjukvården | Electronic services and forms related to health services | 704 | 2018-08-07T14:00:29.759443+03:00 | 1 | 986 | {} | [704] | 0 | 986 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 1062 | [1063, 1064] | Maanpuolustus | Försvaret | National defence | 2018-08-07T14:00:29.774255+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 8 | 9 | 1 | |||||||||||||||||||||||||||||||||
| 1065 | [] | Meripelastus | Sjöräddningen | Sea rescue | 435 | 2018-08-07T14:00:29.800283+03:00 | 1 | 1061 | {} | [435] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1066 | [1069, 1068, 1067] | Muut turvallisuuspalvelut | Andra säkerhetstjänster | Other safety services | 2018-08-07T14:00:29.808816+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 3 | 5 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 1070 | [1071, 1072, 1073, 1074, 1075] | Pelastustoimi | Räddningsväsendet | Rescue services | 2018-08-07T14:00:29.845529+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 26 | 46 | 13 | 6 | 1 | |||||||||||||||||||||||||||||||
| 1076 | [1077] | Poliisi | Polisen | Police | 2018-08-07T14:00:29.888769+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 1 | 6 | 1 | 4 | ||||||||||||||||||||||||||||||||
| 1078 | [] | Rajavartiolaitos | Gränsbevakningsväsendet | Border guard | 557 | 2018-08-07T14:00:29.900790+03:00 | 1 | 1061 | {} | [557] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1079 | [] | Säteilyturva | Strålsäkerhet | Radiation and nuclear safety | 671 | 2018-08-07T14:00:29.907687+03:00 | 1 | 1061 | {} | [671] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 1080 | [1081] | Tulli | Tullen | Customs | 2018-08-07T14:00:29.915254+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 4 | 7 | 1 | 2 | ||||||||||||||||||||||||||||||||
| 1082 | [] | Väestöhälyttimet | Befolkningslarm | Public alarm systems | 805 | 2018-08-07T14:00:29.929327+03:00 | 1 | 1061 | {} | [805] | 0 | 1061 | 38 | 38 | |||||||||||||||||||||||||||||||||
| 1083 | [1084, 1086] | Väestönsuojat | Befolkningsskyddsrum | Public shelters | 2018-08-07T14:00:29.937480+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 47 | 49 | 2 | |||||||||||||||||||||||||||||||||
| 1088 | [1093, 1089] | Esiopetus | Förskola | Pre-primary education | 2018-08-07T14:00:25.281111+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 320 | 530 | 89 | 121 | ||||||||||||||||||||||||||||||||
| 1097 | [1187, 1255, 1098] | Perusopetus | Grundläggande utbildning | Basic education | 2018-08-07T14:00:25.451107+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 414 | 568 | 1 | 97 | 55 | 1 | ||||||||||||||||||||||||||||||
| 1257 | [1298, 1258] | Lukiokoulutus | Gymnasier | General upper secondary education | 2018-08-07T14:00:26.772637+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 37 | 62 | 16 | 9 | ||||||||||||||||||||||||||||||||
| 1334 | [] | Nuorten työpajatoiminta | Ungdomsverkstäder | Workshops for the young | 472 | 2018-08-07T14:00:27.336955+03:00 | 1 | 1087 | {} | [472] | 1 | 1087 | 9 | 17 | 8 | ||||||||||||||||||||||||||||||||
| 1335 | [1343, 1336] | Aikuiskoulutus | Vuxenutbildning | Adult education | 2018-08-07T14:00:27.345252+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 5 | 11 | 2 | 3 | 1 | |||||||||||||||||||||||||||||||
| 1353 | [1355, 1354] | Oppisopimuskoulutus | Läroavtalsutbildning | Apprenticeship training | 2018-08-07T14:00:27.464000+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 1 | 2 | 1 | |||||||||||||||||||||||||||||||||
| 1356 | [1357] | Ammattikorkeakoulut | Yrkeshögskolor | Polytechnics | 654 | 2018-08-07T14:00:27.483584+03:00 | 1 | 1087 | {} | [654] | 0 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 1359 | [] | Yliopistot | Universitet | Universities | 822 | 2018-08-07T14:00:27.510881+03:00 | 1 | 1087 | {} | [822] | 0 | 1087 | 10 | 60 | 50 | ||||||||||||||||||||||||||||||||
| 1360 | [2212, 1371, 1369, 1370, 1365, 1361] | Vapaa sivistystyö | Fritt bildningsarbete | General educational work | 2020-11-18T07:30:12.838195+02:00 | 1 | 1087 | {} | [] | 0 | 1087 | 56 | 97 | 9 | 28 | 4 | |||||||||||||||||||||||||||||||
| 1372 | [1373, 1374, 1375] | Oppilas- ja opiskelijahuolto | Elevvård | Pupil and student care | 2018-08-07T14:00:27.603403+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 241 | 388 | 1 | 2 | 136 | 1 | 7 | |||||||||||||||||||||||||||||
| 1376 | [] | Koulu- ja opiskelijaruokailu | Måltider för elever och studerande | Meals for pupils and students | 338 | 2020-08-20T14:00:09.319013+03:00 | 1 | 1087 | {} | [338] | 0 | 1087 | 119 | 136 | 12 | 4 | 1 | ||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||
| 1378 | [1381, 2080, 1380, 1379] | Kasvatuksen ja koulutuksen neuvonta | Rådgivning om fostran och utbildning | Day care and education information and advice | 2018-08-07T14:00:27.660874+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 4 | 6 | 2 | |||||||||||||||||||||||||||||||||
| 1382 | [] | Hallinto | Förvaltning | Administration | 179 | 2018-08-07T14:00:27.693663+03:00 | 1 | 1087 | {} | [179] | 0 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
| 2042 | [2056, 2049] | Aamu- ja iltapäivätoiminta | Morgon- och eftermiddagsverksamhet | Morning and afternoon activities | 2018-08-07T14:00:25.343707+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 208 | 223 | 11 | 4 | ||||||||||||||||||||||||||||||||
| 2118 | [2126, 2122] | Esiopetus | Förskola | Pre-primary education | 2018-08-07T14:00:29.045629+03:00 | 1 | 1405 | {} | [] | 0 | 1405 | 320 | 530 | 89 | 121 | ||||||||||||||||||||||||||||||||
| 2163 | [] | Päiväkotiruokailu | Daghem måltider | Day care centre meals | 860 | 2018-08-07T14:00:29.039470+03:00 | 1 | 1405 | {} | [860] | 0 | 1405 | 274 | 274 | |||||||||||||||||||||||||||||||||
| 2179 | [2186, 2200, 2181, 2180] | Ammatillinen koulutus | Yrkesutbildning | Vocational education | 2018-08-31T16:00:09.179533+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 18 | 24 | 2 | 4 | ||||||||||||||||||||||||||||||||
| 2189 | [] | Perhekeskukset | Familjecentren | Family centres | 875 | 2019-02-12T15:30:09.896427+02:00 | 1 | 783 | {} | [875] | 0 | 783 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 2190 | [] | Terveys- ja hyvinvointikeskukset | Centraler för hälsa och välbefinnande | Health and well-being centres | 876 | 2019-02-12T15:30:10.708910+02:00 | 1 | 986 | {} | [876] | 0 | 986 | 2 | 11 | 1 | 8 |
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 );