service_node
1,140 rows sorted by root
This data as json, CSV (advanced)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||||
1005 | [] | Lastenneuvola | Barnrådgivning | Child health clinic | 379 | 2018-10-25T08:00:09.610190+03:00 | 2 | 1004 | {} | [379] | 0 | 986 | 22 | 47 | 14 | 10 | 1 | ||||||||||||||||||||||||||||||
1006 | [] | Perhesuunnittelu ja ehkäisyneuvola | Familjeplanerings- och preventivmedelsrådgivning | Family planning and contraception clinic | 507 | 2018-08-07T14:00:29.286660+03:00 | 2 | 1004 | {} | [507] | 0 | 986 | 5 | 4 | 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 | ||||||||||||||||||||||||||||
1010 | [] | Yliopistolliset sairaalat | Universitetssjukhus | University hospitals | 820 | 2018-08-07T14:00:29.314677+03:00 | 2 | 1009 | {} | [820] | 0 | 986 | 18 | 31 | 1 | 1 | 4 | 2 | 3 | 2 | |||||||||||||||||||||||||||
1011 | [] | Kaupungin psykiatrinen sairaala | Stadens psykiatriska sjukhus | City Psychiatric Hospital | 263 | 2018-08-07T14:00:29.322493+03:00 | 2 | 1009 | {} | [263] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1012 | [] | Kaupunginsairaalat | Stadssjukhus | City hospitals | 264 | 2018-08-07T14:00:29.330351+03:00 | 2 | 1009 | {} | [264] | 0 | 986 | 9 | 11 | 1 | 1 | |||||||||||||||||||||||||||||||
1013 | [] | Kotisairaalat | Hemsjukhus | Domestic hospitals | 336 | 2018-08-07T14:00:29.340263+03:00 | 2 | 1009 | {} | [336] | 0 | 986 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1014 | [] | Päiväsairaala | Dagsjukhus | Day hospital | 553 | 2018-08-07T14:00:29.349793+03:00 | 2 | 1009 | {} | [553] | 0 | 986 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
1015 | [] | Sairaaloiden poliklinikat | Sjukhusens polikliniker | Hospital outpatient clinics | 610 | 2018-08-07T14:00:29.359098+03:00 | 2 | 1009 | {} | [610] | 0 | 986 | 3 | 3 | |||||||||||||||||||||||||||||||||
1016 | [] | Synnytyssairaalat | Förlossningssjukhus | Maternity hospitals | 667 | 2018-08-07T14:00:29.368533+03:00 | 2 | 1009 | {} | [667] | 0 | 986 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1020 | [] | Akuuttipsykiatria | Akutpsykiatri | Acute psychiatry | 46 | 2018-08-07T14:00:29.412887+03:00 | 2 | 1019 | {} | [46] | 0 | 986 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
1021 | [] | HUS:n erikoissairaanhoito | HNS:s specialsjukvård | HUS specialised health care | 440 | 2018-08-07T14:00:29.421431+03:00 | 2 | 1019 | {} | [440] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1022 | [] | Kuntoutuspsykiatria | Rehabiliteringspsykiatri | Rehabilitation psychiatry | 354 | 2018-08-07T14:00:29.429019+03:00 | 2 | 1019 | {} | [354] | 0 | 986 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1023 | [] | Psykiatrian poliklinikat | Psykiatriska polikliniker | Psychiatric outpatient clinics | 521 | 2018-08-07T14:00:29.437165+03:00 | 2 | 1019 | {} | [521] | 0 | 986 | 19 | 19 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1025 | [] | Psykiatrinen perhehoito | Psykiatrisk familjevård | Psychiatric family care | 523 | 2018-08-07T14:00:29.453053+03:00 | 2 | 1019 | {} | [523] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1026 | [] | Psykiatrinen päiväsairaala | Psykiatriskt dagsjukhus | Psychiatric day hospital | 524 | 2018-08-07T14:00:29.460729+03:00 | 2 | 1019 | {} | [524] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
1027 | [] | Psykoterapia | Psykoterapi | Psychotherapy | 526 | 2018-08-07T14:00:29.469348+03:00 | 2 | 1019 | {} | [526] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1029 | [] | Apuvälinepalvelut | Hjälpmedelstjänster | Aid services | 352 | 2018-08-07T14:00:29.484194+03:00 | 2 | 1028 | {} | [352] | 0 | 986 | 5 | 10 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
1031 | [] | Fysioterapia | Fysioterapi | Physiotherapy | 172 | 2018-08-07T14:00:29.505159+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [172] | 0 | 986 | 11 | 21 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||
1032 | [] | Kuntoutuksen vuodeosastopalvelut | Vårdavdelningstjänster inom rehabilitering | Rehabilitation inpatient care | 353 | 2018-08-07T14:00:29.514187+03:00 | 2 | 1028 | {} | [353] | 0 | 986 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
1033 | [] | Kuntoutussuunnittelu ja -ohjaus | Rehabiliteringsplanering och -handledning | Rehabilitation planning and guidance | 355 | 2018-08-07T14:00:29.523750+03:00 | 2 | 1028 | {} | [355] | 0 | 986 | 4 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||
1034 | [] | Lääkinnällinen kuntoutus | Medicinsk rehabilitering | Medical rehabilitation | 416 | 2018-08-07T14:00:29.531662+03:00 | 2 | 1028 | {} | [416] | 0 | 986 | 1 | 5 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||
1035 | [] | Neurologia | Neurologi | Neurology | 462 | 2018-08-07T14:00:29.539786+03:00 | 2 | 1028 | {} | [462] | 0 | 986 | 6 | 6 | |||||||||||||||||||||||||||||||||
1036 | [] | Puheterapia | Talterapi | Speech therapy | 527 | 2018-08-07T14:00:29.552393+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [527] | 0 | 986 | 2 | 13 | 5 | 5 | 1 | ||||||||||||||||||||||||||||||
1037 | [] | Rintamavetaraanien kuntoutus | Rehabilitering av frontveteraner | Front-line veteran rehabilitation | 583 | 2018-08-07T14:00:29.562795+03:00 | 2 | 1028 | {} | [583] | 0 | 986 | 1 | 6 | 4 | 1 | |||||||||||||||||||||||||||||||
1038 | [] | Toimintaterapia | Ergoterapi | Occupational therapy | 712 | 2018-08-07T14:00:29.573439+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [712] | 0 | 986 | 9 | 13 | 1 | 3 | |||||||||||||||||||||||||||||||
1039 | [] | Ravitsemusterapia | Näringsterapi | Nutrition therapy | 579 | 2018-08-07T14:00:29.591225+03:00 | 1 | 986 | {} | [579] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 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 | ||||||||||||||||||||||||||||||||||
1050 | [] | Potilasasiamies | Patientombudsman | Patient representative | 520 | 2018-08-07T14:00:29.675023+03:00 | 2 | 1048 | {} | [520] | 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 | |||||||||||||||||||||||||||||||
1052 | [] | Päihdehuollon sosiaalityö | Socialt arbete inom missbrukarvården | Care for substance abuse, social work | 549 | 2018-08-07T14:00:29.687959+03:00 | 2 | 1051 | {} | [549] | 0 | 986 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
1053 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:29.695330+03:00 | 2 | 1051 | {} | [548] | 0 | 986 | 7 | 6 | 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 | |||||||||||||||||||||||||||||||
1055 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:29.709367+03:00 | 2 | 1051 | {} | [545] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1056 | [] | Päihdehuollon päivätoiminta | Dagverksamhet inom missbrukarvården | Care for substance abuse, daytime activities | 547 | 2018-08-07T14:00:29.716393+03:00 | 2 | 1051 | {} | [547] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1057 | [] | Päihdehuollon asumispalvelut | Boendetjänster inom missbrukarvården | Care for substance abuse, residential services | 543 | 2018-08-07T14:00:29.725065+03:00 | 2 | 1051 | {} | [543] | 0 | 986 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1059 | [] | Selviämishoitoasema | Tillnyktringsstation | Detoxification centre | 618 | 2018-08-07T14:00:29.743322+03:00 | 2 | 1051 | {} | [618] | 0 | 986 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2158 | [] | Tuki digipelaamisen ja netin liikakäytön ongelmiin | Stöd för överanvändningsproblem av digitala spel och internet | Support for digital gaming and internet over-use problems | 855 | 2018-08-07T14:00:29.751405+03:00 | 2 | 1051 | {} | [855] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2161 | [] | Palliatiivinen hoito | Palliativ vård | Palliative care | 858 | 2018-08-07T14:00:29.377630+03:00 | 2 | 1009 | {} | [858] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2164 | [] | Kouluterveydenhuolto | Skolhälsovård | School health care | 339 | 2018-08-07T14:00:29.207544+03:00 | 2 | 997 | {} | [339] | 0 | 986 | 160 | 236 | 1 | 1 | 68 | 1 | 5 | ||||||||||||||||||||||||||||
2166 | [] | Opiskeluterveydenhuolto | Studenthälsovård | Student health care | 863 | 2018-08-07T14:00:29.213565+03:00 | 2 | 997 | {} | [863] | 0 | 986 | 81 | 154 | 2 | 68 | 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 | |||||||||||||||||||||||||||||||
1061 | [1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083] | Turvallisuus | Säkerhet | Public safety | 2018-08-07T14:00:29.767356+03:00 | 0 | {} | [] | 0 | 1061 | 130 | 163 | 17 | 13 | 3 | ||||||||||||||||||||||||||||||||
1062 | [1063, 1064] | Maanpuolustus | Försvaret | National defence | 2018-08-07T14:00:29.774255+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 8 | 9 | 1 | |||||||||||||||||||||||||||||||||
1063 | [] | Maanpuolustusyhdistykset | Försvarsföreningar | National defence associations | 422 | 2018-08-07T14:00:29.780736+03:00 | 2 | 1062 | {} | [422] | 0 | 1061 | 2 | 2 | |||||||||||||||||||||||||||||||||
1064 | [] | Puolustusvoimat | Försvarsmakten | The Finnish Defence Forces | 529 | 2018-08-07T14:00:29.789161+03:00 | 2 | 1062 | {} | [529] | 0 | 1061 | 6 | 7 | 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 | ||||||||||||||||||||||||||||||||
1067 | [] | Turvallisuuskoulutus | Säkerhetsutbildning | Safety training | 720 | 2018-08-07T14:00:29.819172+03:00 | 2 | 1066 | {} | [720] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1068 | [] | 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:29.828890+03:00 | 2 | 1066 | {} | [636] | 0 | 1061 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1069 | [] | Muut turvapalvelut (kiinteistöt ja vartiointi) | Övrig säkerhetsservice (fastigheter och bevakning) | Other security services (real estate and guarding) | 460 | 2018-08-07T14:00:29.836971+03:00 | 2 | 1066 | {} | [460] | 0 | 1061 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||
1071 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:29.851905+03:00 | 2 | 1070 | {} | [467] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1072 | [] | Pelastusasemat | Räddningsstationerna | Rescue Stations | 501 | 2018-08-07T14:00:29.858704+03:00 | 2 | 1070 | {} | [501] | 0 | 1061 | 9 | 21 | 6 | 6 | |||||||||||||||||||||||||||||||
1073 | [] | Pelastuskoulu | Räddningsskolan | School of Fire and Rescue Services | 502 | 2018-08-07T14:00:29.866063+03:00 | 2 | 1070 | {} | [502] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1074 | [] | Sopimuspalokunnat | Avtalsbrandkårer | Volunteer fire departments | 633 | 2018-08-07T14:00:29.872976+03:00 | 2 | 1070 | {} | [633] | 0 | 1061 | 15 | 23 | 7 | 1 | |||||||||||||||||||||||||||||||
1076 | [1077] | Poliisi | Polisen | Police | 2018-08-07T14:00:29.888769+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 1 | 6 | 1 | 4 | ||||||||||||||||||||||||||||||||
1077 | [] | Poliisilaitokset ja -asemat | Polisrättningar och -stationer | Police departments and stations | 519 | 2018-08-07T14:00:29.893912+03:00 | 2 | 1076 | {} | [519] | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1084 | [] | Yhteiskalliosuojat | Gemensamma bergskyddsrum | Shared ground shelters | 808 | 2018-08-07T14:00:29.944094+03:00 | 2 | 1083 | {} | [808] | 0 | 1061 | 29 | 29 | |||||||||||||||||||||||||||||||||
1086 | [] | Yleiset väestönsuojat | Allmänna befolkningsskyddsrum | General public shelters | 815 | 2018-08-07T14:00:29.980338+03:00 | 2 | 1083 | {} | [815] | 0 | 1061 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
1087 | [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] | Opetus ja koulutus | Undervisning och utbildning | Teaching and education | 2018-08-07T14:00:25.275863+03:00 | 0 | {} | [] | 0 | 1087 | 1214 | 1867 | 1 | 2 | 274 | 362 | 2 | 11 | 1 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1089 | [1090] | Suomen- ja vieraskielinen esiopetus | Förskoleundervisning på finska och främmande språk | Pre-primary education in Finnish, English and other languages | 861 | 2020-03-06T18:32:07.479235+02:00 | 2 | 1088 | {} | [861] | 1 | 1087 | 289 | 484 | 78 | 117 | |||||||||||||||||||||||||||||||
1090 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 | 2019-06-20T11:30:19.029713+03:00 | 3 | 1089 | {} | [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] | 1 | 1087 | 289 | 483 | 78 | 116 | |||||||||||||||||||||||||||||||
1093 | [1096, 1095, 1094] | Ruotsinkielinen esiopetus | Förskoleundervisning på svenska | Pre-primary education in Swedish | 862 | 2018-08-07T14:00:25.315377+03:00 | 2 | 1088 | {} | [862] | 1 | 1087 | 31 | 46 | 11 | 4 | |||||||||||||||||||||||||||||||
1094 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 603*160+862*160 | 2018-10-25T08:00:07.518402+03:00 | 3 | 1093 | {} | [862, 603, 160] | 1 | 1087 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
1095 | [] | Koulun järjestämä esiopetus | Förskoleundervisning som ordnas av skolan | Pre-primary education organised by school | 601*159+862*159 | 2018-10-25T08:00:07.525080+03:00 | 3 | 1093 | {} | [862, 601, 159] | 1 | 1087 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
1096 | [] | Esi- ja starttiopetus | Förskoleundervisning, startklasser | Pre-primary and start class education | 595 | 2018-10-25T08:00:07.533093+03:00 | 3 | 1093 | {} | [595] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
1098 | [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] | Suomen- ja vieraskielinen perusopetus | Grundläggande utbildning på finska och främmande språk | Basic education in Finnish, English and other languages | 2020-03-06T18:32:07.543511+02:00 | 2 | 1097 | {} | [] | 0 | 1087 | 368 | 504 | 1 | 84 | 50 | 1 | ||||||||||||||||||||||||||||||
1099 | [1101, 1102, 2170, 1103, 1100, 1104] | Luokkien 1-6 perusopetus | Grundläggande utbildning, årskurserna 1-6 | Basic education, grades 1-6 | 2018-10-25T08:00:07.589100+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 110 | 212 | 62 | 39 | 1 | |||||||||||||||||||||||||||||||
1100 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 661 | 2018-10-25T08:00:07.595003+03:00 | 4 | 1099 | {} | [661] | 1 | 1087 | 104 | 205 | 62 | 38 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1102 | [] | ranskankielinen opetus | undervisning på franska | education in French | 567 | 2018-08-07T14:00:25.502701+03:00 | 4 | 1099 | {} | [567] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1103 | [] | saksankielinen opetus | undervisning på tyska | education in German | 612 | 2018-08-07T14:00:25.517491+03:00 | 4 | 1099 | {} | [612] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1104 | [] | venäjänkielinen opetus | undervisning på ryska | education in Russian | 771 | 2018-08-07T14:00:25.524519+03:00 | 4 | 1099 | {} | [771] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1109 | [1111, 1112, 2171, 1113, 1110, 1114] | Luokkien 7-9 perusopetus | Grundläggande utbildning, årskurserna 7-9 | Basic education, grades 7-9 | 2018-10-25T08:00:07.629842+03:00 | 3 | 1098 | {} | [] | 0 | 1087 | 69 | 121 | 1 | 27 | 23 | 1 | ||||||||||||||||||||||||||||||
1110 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 662 | 2018-10-25T08:00:07.635959+03:00 | 4 | 1109 | {} | [662] | 1 | 1087 | 63 | 114 | 1 | 27 | 22 | 1 | |||||||||||||||||||||||||||||
1111 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 150 | 2018-10-25T08:00:07.642003+03:00 | 4 | 1109 | {} | [150] | 1 | 1087 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
1112 | [] | ranskankielinen opetus | undervisning på franska | education in French | 568 | 2018-08-07T14:00:25.599261+03:00 | 4 | 1109 | {} | [568] | 1 | 1087 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service_node] ( [id] INTEGER PRIMARY KEY, [children] TEXT, [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [service_reference] TEXT, [last_modified_time] TEXT, [level] INTEGER, [parent] INTEGER, [keywords] TEXT, [related_services] TEXT, [period_enabled] INTEGER, [root] INTEGER, [unit_count_municipality_helsinki] INTEGER, [unit_count_total] INTEGER, [unit_count_municipality_hanko] TEXT, [unit_count_municipality_raasepori] TEXT, [unit_count_municipality_siuntio] TEXT, [unit_count_municipality_sipoo] TEXT, [unit_count_municipality_janakkala] TEXT, [unit_count_municipality_nurmijärvi] TEXT, [unit_count_municipality_salo] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality__unknown] TEXT, [unit_count_municipality_lapinjärvi] TEXT, [unit_count_municipality_inkoo] TEXT, [unit_count_municipality_miehikkälä] TEXT, [unit_count_municipality_porvoo] TEXT, [unit_count_municipality_lohja] INTEGER, [unit_count_municipality_tuusula] TEXT, [unit_count_municipality_kirkkonummi] TEXT, [unit_count_municipality_hamina] TEXT, [unit_count_municipality_kouvola] TEXT, [unit_count_municipality_loviisa] TEXT, [unit_count_municipality_espoo] INTEGER, [unit_count_municipality_askola] TEXT, [unit_count_municipality_kotka] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] INTEGER, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_pyhtää] TEXT );