servicemap

Custom SQL query returning 8 rows (show)

Query parameters

This data as json, CSV

idchildrenname_finame_svname_enservice_referencelast_modified_timelevelparentkeywordsrelated_servicesperiod_enabledrootunit_count_municipality_helsinkiunit_count_totalunit_count_municipality_hankounit_count_municipality_raaseporiunit_count_municipality_siuntiounit_count_municipality_sipoounit_count_municipality_janakkalaunit_count_municipality_nurmijärviunit_count_municipality_salounit_count_municipality_virolahtiunit_count_municipality_pornainenunit_count_municipality_hämeenlinnaunit_count_municipality__unknownunit_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_askolaunit_count_municipality_kotkaunit_count_municipality_mäntsäläunit_count_municipality_vantaaunit_count_municipality_hyvinkääunit_count_municipality_vihtiunit_count_municipality_kauniainenunit_count_municipality_järvenpääunit_count_municipality_keravaunit_count_municipality_karkkilaunit_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        
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        
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        
653 [] Ulkokuntoiluvälineet Konditionspark för utomhusaktiviteter Fitness training park 737 2018-08-07T14:00:23.939410+03:00 4 646 {} [737] 0 1403 168 320                                           100       43   3 6        
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    
870 [875, 879, 872, 877, 876, 880, 871, 874] Suomenkielinen päivähoito Finskspråkig dagvård Day care in Finnish 663 2019-03-05T14:30:09.339119+02:00 3 869 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [663] 0 1405 389 847                                           278       174     6        
871 [] päivähoito dagvård day care 663 2019-03-05T14:30:09.346786+02:00 4 870 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [663] 0 1405 389 845                                           277       173     6        
1401 [122, 171, 755] Työ, talous ja hallinto Arbete, ekonomi och förvaltning Employment and public authorities   2020-03-06T18:32:09.344909+02:00 0   {} [] 0 1401 448 629       2 1         1 2 1     2     3       88       74     6   1