servicemap

Custom SQL query returning 10 rows (hide)

Query parameters

name_finame_svname_enidperiod_enabledclarification_enabledkeywordsroot_service_nodeunit_count_municipality_helsinkiunit_count_totalunit_count_municipality_hankounit_count_municipality_raaseporiunit_count_municipality_siuntiounit_count_municipality_sipoounit_count_municipality_janakkalaunit_count_municipality_nullunit_count_municipality_nurmijärviunit_count_municipality_virolahtiunit_count_municipality_pornainenunit_count_municipality_hämeenlinnaunit_count_municipality_salounit_count_municipality_lapinjärviunit_count_municipality_inkoounit_count_municipality_miehikkäläunit_count_municipality_porvoounit_count_municipality_lohjaunit_count_municipality_tuusulaunit_count_municipality_kirkkonummiunit_count_municipality_haminaunit_count_municipality_kouvolaunit_count_municipality_loviisaunit_count_municipality_espoounit_count_municipality_kotkaunit_count_municipality_askolaunit_count_municipality_mäntsäläunit_count_municipality_vantaaunit_count_municipality_hyvinkääunit_count_municipality_vihtiunit_count_municipality_kauniainenunit_count_municipality_karkkilaunit_count_municipality_järvenpääunit_count_municipality_keravaunit_count_municipality_pyhtää
A1-englanti (perusopetuksen kieliohjelma) A1-engelska (språkprogrammet för den grundläggande utbildningen) A1-English (basic education language programme) 15 1 0 {} 1087 110 216                               1           76       28 1            
B1-ruotsi (perusopetuksen kieliohjelma) B1-svenska (språkprogrammet för den grundläggande utbildningen) B1-Swedish (basic education language programme) 108 1 0 {} 1087 109 210                               1           75       24 1            
kouluterveydenhuolto skolhälsovård school health care 339 0 0 {} 986 160 236                               1           1       68 1   5        
kulttuurihistorialliset museot kulturhistoriska museer cultural history museums 344 0 0 {} 1403 42 58                                           9       5 1       1    
laboratoriot laboratorier laboratories 366 0 0 {} 986 22 88   3 1 1     3 1 1       1 1 2 6 3 3 1 7 1 10 3 1 1 8 1 1 2 1 1 1 1
lastensuojelun laitospalvelu anstaltsservice inom barnskyddet child welfare services, institutional service 380 0 0 {} 783 12 37                               1           7       16 1            
röntgenit röntgen x-rays 606 0 0 {} 986 11 42 1 1   1     1               2 1 1 1 1 1 1 6 1   1 6 1 1   1 1 1  
suomenkielinen perusopetus luokille 1-6 grundläggande utbildning på finska för årskurserna 1-6 basic education for grades 1-6 in Finnish 661 1 0 {} 1087 104 205                                           62       38 1            
suomenkielinen perusopetus luokille 7-9 grundläggande utbildning på finska för årskurserna 7-9 basic education for grades 7-9 in Finnish 662 1 0 {} 1087 63 114                               1           27       22 1            
taidemuseot konstmuseer art museums 672 0 0 {} 1403 61 88             1                   4 1       10       6 1       4