279 rows where level = 2 sorted by related_services

View and edit SQL

Suggested facets: 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_kirkkonummi, unit_count_municipality_hyvinkää, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava

level

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ää
126 [] Elinkeinoasiat Näringslivsfrågor Trade and industry matters 132 2018-08-07T14:00:30.024180+03:00 2 122 {} 0 1401 2 2                                                                  
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} 0 1401   1                     1                                            
130 [] Eläkkeet Pensioner Pension matters 143 2018-08-07T14:00:30.054750+03:00 2 122 {} 0 1401 4 10       1                                   2       2         1    
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} 0 1400 1 1                                                                  
841 [] Etuuskäsittely Förmånsbehandling Benefit processing 167 2018-08-07T14:00:28.085946+03:00 2 839 {} 0 783 1 2                                           1                      
1031 [] Fysioterapia Fysioterapi Physiotherapy 172 2018-08-07T14:00:29.505159+03:00 2 1028 {"fi": ["kuntoutus"]} 0 986 11 21                                           4       5     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 {} 0 783   4                                           2       2              
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 {} 0 986   4                                           2       2              
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} 0 986 7 10                                                   2     1        
131 [] Julkinen notaari Notarius publicus Notary public 215 2018-08-07T14:00:30.061046+03:00 2 122 {} 0 1401 1 2                                           1                      
177 [] Hankintapalvelut Upphandlingstjänster Procurement services 217 2018-08-07T14:00:30.442764+03:00 2 171 {} 0 1401 1 1                                                                  
178 [] Keskitetyt tietotekniikkapalvelut Centraliserade datatekniktjänster Centralised services on information technology 222 2018-08-07T14:00:30.449039+03:00 2 171 {} 0 1401 1 2                                                   1              
768 [] Järjestötoiminta Organisationsverksamhet Organisational activities 230 2018-08-07T14:00:30.858157+03:00 2 755 {} 0 1401 2 24                                           22                      
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} 0 1400 1 2                                                         1        
87 [] Jäteveden puhdistamo Avloppsreningsverk Sewage treatment plant 233 2018-08-07T14:00:21.958557+03:00 2 85 {} 0 1400 1 2                                           1                      
33 [] Jätteenkäsittelykeskus Avfallshanteringscentral Waste treatment centre 234 2018-08-07T14:00:21.773147+03:00 2 31 {} 0 1400   1                                           1                      
1371 [] Kansanopisto Folkhögskola Folk high school 244 2020-11-18T07:30:12.932144+02:00 2 1360 {} 0 1087   3                                           1             2        
344 [] Kasvitieteelliset puutarhat Botaniska trädgårdar Botanic gardens 248 2018-08-07T14:00:22.544317+03:00 2 343 {} 0 1403 3 3                                                                  
367 [] Katutaidepaikat Platser för gatukonst Street art locations 254 2018-08-07T14:00:22.877110+03:00 2 365 {} 0 1403 12 12                                                                  
132 [] Kaupanvahvistus Bestyrkande av köp Public purchase witnessing 255 2018-08-07T14:00:30.067157+03:00 2 122 {} 0 1401 1 3                                           1       1              
133 [] Kauppa- ja yhdistysrekisteri Handelsregistret och föreningsregistret Trade register and register of associations 257 2018-08-07T14:00:30.073459+03:00 2 122 {} 0 1401 1 2                                           1                      
1011 [] Kaupungin psykiatrinen sairaala Stadens psykiatriska sjukhus City Psychiatric Hospital 263 2018-08-07T14:00:29.322493+03:00 2 1009 {} 0 986 2 2                                                                  
1012 [] Kaupunginsairaalat Stadssjukhus City hospitals 264 2018-08-07T14:00:29.330351+03:00 2 1009 {} 0 986 9 11                                           1       1              
815 [] Kehitysvammahuollon asumispalvelut Boendetjänster inom vård av utvecklingsstörda Care of the developmentally disabled, residential services 275 2018-08-07T14:00:27.912869+03:00 2 810 {} 0 783 39 71                                           9       21     1   1    
816 [] Kehitysvammahuollon laitospalvelu Institutionsservice inom vård av utvecklingsstörda Care of the developmentally disabled, institutional service 276 2018-08-07T14:00:27.919212+03:00 2 810 {} 0 783   4                                                   4              
817 [] Kehitysvammahuollon loma- ja harrastustoiminta Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda Care of the developmentally disabled, vacation and leisure activities 277 2018-08-07T14:00:27.925241+03:00 2 810 {} 0 783 3 6                                                   3              
813 [] Kehitysvammahuollon päivätoiminta Dagverksamhet inom vård av utvecklingsstörda Care of the developmentally disabled, daytime activities 278 2018-08-07T14:00:27.899777+03:00 2 810 {} 0 783 10 18                                           3       4         1    
812 [] Kehitysvammahuollon sosiaaliohjaus Socialhandledning inom omsorger om utvecklingsstörda Care of the developmentally disabled, social care work 279 2018-08-07T14:00:27.893701+03:00 2 810 {} 0 783   1                                                         1        
811 [] Kehitysvammahuollon sosiaalityö Socialt arbete inom vård av utvecklingsstörda Care of the developmentally disabled, social work 280 2018-08-07T14:00:27.887549+03:00 2 810 {} 0 783 3 9                                                   5     1        
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 {} 0 783 2 4                                                   2              
814 [] Kehitysvammahuollon työllistämispalvelut Sysselsättningstjänster inom vård av utvecklingsstörda Care of the developmentally disabled, employment services 282 2018-08-07T14:00:27.906450+03:00 2 810 {} 0 783 5 6                                                   1              
1007 [] Kehitysvammapoliklinikka Handikapprådgivning Developmental disability clinic 284 2018-10-25T08:00:09.092312+03:00 2 810 {} 0 783 4 6                                                   1         1    
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} 0 1400 3 7                                   1       1       1     1        
179 [] Kirjaamo Registratorskontor Registrar's office 310 2018-08-07T14:00:30.455188+03:00 2 171 {} 0 1401 4 8                                           2       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 {} 0 1403 63 86                                           3       19     1        
1013 [] Kotisairaalat Hemsjukhus Domestic hospitals 336 2018-08-07T14:00:29.340263+03:00 2 1009 {} 0 986 3 4                                                   1              
2164 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:29.207544+03:00 2 997 {} 0 986 160 236                               1           1       68 1   5        
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} 0 1087   71                                                   66     5        
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} 0 1087   2                                                   2              
351 [] Kulttuuripalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för kulturtjänster Electronic services and forms related to cultural services 346 2018-08-07T14:00:22.590770+03:00 2 343 {} 0 1403   2                     1                             1              
851 [] Kuntouttava työtoiminta Arbetsverksamhet i rehabiliterande syfte Rehabilitative work 351 2018-08-07T14:00:28.157405+03:00 2 845 {} 0 783 34 43                                           1       8              
1029 [] Apuvälinepalvelut Hjälpmedelstjänster Aid services 352 2018-08-07T14:00:29.484194+03:00 2 1028 {} 0 986 5 10                                           1       3     1        
1032 [] Kuntoutuksen vuodeosastopalvelut Vårdavdelningstjänster inom rehabilitering Rehabilitation inpatient care 353 2018-08-07T14:00:29.514187+03:00 2 1028 {} 0 986   3                                           2       1              
1022 [] Kuntoutuspsykiatria Rehabiliteringspsykiatri Rehabilitation psychiatry 354 2018-08-07T14:00:29.429019+03:00 2 1019 {} 0 986 2 3                                           1                      
1033 [] Kuntoutussuunnittelu ja -ohjaus Rehabiliteringsplanering och -handledning Rehabilitation planning and guidance 355 2018-08-07T14:00:29.523750+03:00 2 1028 {} 0 986   4                                           1       1     2        
186 [] Kuulutukset Kungörelser Public announcements 358 2018-08-07T14:00:30.500246+03:00 2 171 {} 0 1401   2                                           1       1              
1369 [] Kuvataidekoulu Konstskola School of visual arts 360 2020-11-18T07:30:12.906446+02:00 2 1360 {} 0 1087   7                                                   6     1        
794 [] Lapsiperheiden kotipalvelu Hemservice för barnfamiljer Domestic services for families with children 371 2018-08-07T14:00:27.777393+03:00 2 791 {} 0 783 6 9                                                   3              
795 [] Lapsiperheiden lomatoiminta Semesterverksamhet för barnfamiljer Vacation activities for families with children 372 2018-08-07T14:00:27.784058+03:00 2 791 {} 0 783   1                                                         1        
792 [] Lapsiperheiden sosiaaliohjaus Socialhandledning för barnfamiljer Social care work for families with children 373 2018-08-07T14:00:27.759985+03:00 2 791 {} 0 783   17                                                   16     1        
1002 [] Lasten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för barn Health centre on-call service and emergency outpatient clinic for children 378 2018-10-25T08:00:09.598902+03:00 2 1000 {} 0 986   3                                           1       1     1        
1005 [] Lastenneuvola Barnrådgivning Child health clinic 379 2018-10-25T08:00:09.610190+03:00 2 1004 {} 0 986 22 47                                           14       10     1        
789 [] Lastensuojelun laitospalvelu Institutionstjänster inom barnskyddet Institutional service for child welfare 380 2018-08-07T14:00:27.738722+03:00 2 787 {} 0 783 12 37                               1           7       16 1            
790 [] Lastensuojelun perhehoito Familjevård inom barnskyddet Domestic care for child welfare 381 2018-08-07T14:00:27.746492+03:00 2 787 {} 0 783   5                                           2       3              
788 [] Lastensuojelun sosiaalityö Socialt arbete inom barnskyddet Child welfare social work 382 2018-08-07T14:00:27.731506+03:00 2 787 {} 0 783 25 42                                           9       7     1        
754 [] Lipunmyynti tapahtumiin Biljettförsäljning till evenemang Ticket sales to events 405 2018-08-07T14:00:24.631976+03:00 2 717 {} 0 1403 5 13                     1                     6       1              
57 [] Luonnonsuojelu Naturskydd Environmental protection 410 2018-08-07T14:00:21.330807+03:00 2 1 {} 0 1400 2 4                                           1       1              
23 [] Luonnonvaraisten eläinten hoitola Vårdanstalt för vilda djur Wildlife home 411 2018-08-07T14:00:21.732081+03:00 2 14 {} 0 1400 1 1                                                                  
1034 [] Lääkinnällinen kuntoutus Medicinsk rehabilitering Medical rehabilitation 416 2018-08-07T14:00:29.531662+03:00 2 1028 {} 0 986 1 5                                           2       1     1        
58 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:21.337453+03:00 2 1 {} 0 1400 1 1                                                                  
525 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:25.085327+03:00 2 512 {} 0 1402 1 1                                                                  
848 [] Aikuisten sosiaaliohjaus Socialhandledning för vuxna Social care work for adults 41 2018-08-07T14:00:28.131053+03:00 2 845 {} 0 783 6 9                                           1       2              
857 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:28.196278+03:00 2 845 {} 0 783 14 20                                           2       3     1        
1063 [] Maanpuolustusyhdistykset Försvarsföreningar National defence associations 422 2018-08-07T14:00:29.780736+03:00 2 1062 {} 0 1061 2 2                                                                  
846 [] Aikuisten sosiaalityö Socialt arbete för vuxna Social work for adults 42 2018-08-07T14:00:28.117778+03:00 2 845 {} 0 783 21 25                                           3       1              
59 [] Matonpesupaikat Mattvättningsplatser Carpet washing places 432 2018-08-07T14:00:21.345565+03:00 2 1 {} 0 1400 13 29                                           5       11              
361 [] Matonpesupaikat Mattvättningsplatser Carpet washing places 432 2018-08-07T14:00:22.659080+03:00 2 343 {} 0 1403 13 29                                           5       11              
1001 [] Aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för vuxna Health centre on-call service and emergency outpatient clinic for adults 43 2018-08-07T14:00:29.242685+03:00 2 1000 {"fi": ["p\u00e4ivystys"]} 0 986   3                                           1       1     1        
1021 [] HUS:n erikoissairaanhoito HNS:s specialsjukvård HUS specialised health care 440 2018-08-07T14:00:29.421431+03:00 2 1019 {} 0 986 2 2                                                                  
849 [] Mielenterveyskuntoutujien päivätoiminta Dagverksamhet för klienter inom psykrehabilitering Day activities for mental health rehabilitation clients 441 2018-08-07T14:00:28.144565+03:00 2 845 {} 0 783   1                                                   1              
88 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:21.964747+03:00 2 85 {} 0 1400 1 2                             1                                    
1370 [] Musiikkiopisto Musikinstitut Music institute 456 2020-11-18T07:30:12.915030+02:00 2 1360 {} 0 1087   20                                                   19     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 {} 0 1061 1 2                                           1                      
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} 0 986   6                                                   6              
165 [] Työttömyys Arbetslöshet Unemployment 464 2018-08-07T14:00:30.308304+03:00 2 122 {} 0 1401 4 8                                           1       3              
1071 [] Nuohous Sotning Chimney sweeping 467 2018-08-07T14:00:29.851905+03:00 2 1070 {} 0 1061   1                                           1                      
366 [] Nuorisotalot Ungdomsgårdar Youth centres 468 2018-08-07T14:00:22.869007+03:00 2 365 {} 0 1403 39 69                                           16       13     1        
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} 0 986 1 4                                                   3              
2186 [] Ammatilliseen peruskoulutukseen valmentava koulutus - VALMA Handledande utbildning för grundläggande yrkesutbildning - VALMA Preparatory education for vocational training - VALMA 470 2018-08-31T16:00:09.222841+03:00 2 2179 {} 1 1087 8 9                                                   1              
490 [] Nuorten neuvonta ja ohjaus Rådgivning och handledning för ungdomar Advice and guidance for young people 471 2018-08-07T14:00:23.202058+03:00 2 365 {} 0 1403 7 22                                           3       12              
53 [] Ongelmajäteasema Problemavfall station Waste management station 478 2018-08-07T14:00:21.933801+03:00 2 31 {} 0 1400 1 2                                           1                      
847 [] Alueellinen kumppanuustyö Områdesvist partnerskapsarbete Regional partnership work 49 2018-08-07T14:00:28.124411+03:00 2 845 {} 0 783 19 119       1                                   1       96     1   1    
1072 [] Pelastusasemat Räddningsstationerna Rescue Stations 501 2018-08-07T14:00:29.858704+03:00 2 1070 {} 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 {} 0 1061 1 1                                                                  
793 [] Perheneuvonta ja perheneuvolatoiminta Familjerådgivning och familjerådgivningsverksamhet Family counselling and family clinic 504 2018-10-25T08:00:09.024637+03:00 2 791 {} 0 783 10 20                                           4       5     1        
796 [] Perheoikeudelliset palvelut Familjerättsliga tjänster Services for family law 505 2018-08-07T14:00:27.790684+03:00 2 791 {} 0 783   1                                                   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 {} 0 986   5                                           4             1        
1077 [] Poliisilaitokset ja -asemat Polisrättningar och -stationer Police departments and stations 519 2018-08-07T14:00:29.893912+03:00 2 1076 {} 0 1061 1 6                                           1       4              
123 [] Ammatinvalinnanohjaus Yrkesvägledning Vocational guidance 51 2018-08-07T14:00:30.001277+03:00 2 122 {} 0 1401 4 6                                           1       1              
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} 0 986   1                                                   1              
1023 [] Psykiatrian poliklinikat Psykiatriska polikliniker Psychiatric outpatient clinics 521 2018-08-07T14:00:29.437165+03:00 2 1019 {} 0 986 19 19                                                                  
1024 [] Psykiatrinen asumiskuntoutus Psykiatrisk boenderehabilitering Psychiatric residential rehabilitation 522 2018-08-07T14:00:29.444521+03:00 2 1019 {} 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 {} 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 {} 0 986 2 2                                                                  
1027 [] Psykoterapia Psykoterapi Psychotherapy 526 2018-08-07T14:00:29.469348+03:00 2 1019 {} 0 986 2 2                                                                  
1036 [] Puheterapia Talterapi Speech therapy 527 2018-08-07T14:00:29.552393+03:00 2 1028 {"fi": ["kuntoutus"]} 0 986 2 13                                           5       5     1        
1064 [] Puolustusvoimat Försvarsmakten The Finnish Defence Forces 529 2018-08-07T14:00:29.789161+03:00 2 1062 {} 0 1061 6 7                                           1                      
73 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:21.445519+03:00 2 1 {} 0 1400 44 74                                           14       16              
503 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:22.776545+03:00 2 343 {} 0 1403 44 74                                           14       16              
836 [] Päihdehuollon asumispalvelut Boendetjänster inom missbrukarvården Care for substance abuse, residential services 543 2018-08-07T14:00:28.054175+03:00 2 830 {} 0 783 1 15                                           7       7              

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);