servicemap

Custom SQL query returning 10 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ää
38 [] Kartonginkeräys Insamling av kartong Cardboard recycling 246 2018-08-07T14:00:21.813795+03:00 3 34 {"fi": ["kartonki"]} [246] 0 1400 54 140                                           46       36     4        
41 [] Metallinkeräys Metallavfall Small metal waste 436 2018-08-07T14:00:21.839149+03:00 3 34 {} [436] 0 1400 50 137                                           46       37     4        
146 [147, 148, 149, 156] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:30.157480+03:00 2 122 {} [] 0 1401 294 380       1 1         1   1     2     2       42       32     4        
149 [2209, 150, 152, 151, 154, 155] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:30.179684+03:00 3 146 {} [] 0 1401 292 375       1 1         1   1     2     2       40       31     4        
255 [256, 257, 258, 265] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:22.202500+03:00 3 231 {} [] 0 1400 294 380       1 1         1   1     2     2       42       32     4        
258 [2210, 259, 261, 260, 263, 264] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:22.220951+03:00 4 255 {} [] 0 1400 292 375       1 1         1   1     2     2       40       31     4        
505 [2208, 506, 508, 507, 510, 511] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:22.797039+03:00 2 343 {} [] 0 1403 292 375       1 1         1   1     2     2       40       31     4        
513 [514, 515, 516, 518, 519, 520] Joukkoliikenne Kollektivtrafik Public transport   2018-08-07T14:00:25.002057+03:00 2 512 {} [] 0 1402 99 151                                           27       21     4        
648 [] Lähiliikuntapaikka Näridrottsplats Neighbourhood sports area 415 2018-08-07T14:00:23.898085+03:00 4 646 {} [415] 0 1403 134 229                               1           64       26     4        
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