service_node

1,140 rows sorted by unit_count_municipality_kauniainen descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, keywords, period_enabled, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, 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, last_modified_time (date)

root ✖

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ää
608 [609, 610, 611, 612, 613] Kuntoilukeskukset ja liikuntasalit Konditionsidrottscentra och idrottssalar Fitness centres and sports halls   2018-08-07T14:00:23.602837+03:00 3 601 {} [] 0 1403 576 949                                           188       177     8        
881 [886, 887, 883, 882] Ruotsinkielinen päivähoito Svenskspråkig dagvård Day care in Swedish 603 2019-03-05T14:30:09.379492+02:00 3 869 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [603] 0 1405 77 128                                           33       10     8        
882 [] päivähoito dagvård day care 603 2019-03-05T14:30:09.386238+02:00 4 881 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [603] 0 1405 77 128                                           33       10     8        
1402 [306, 512] Liikenne ja kartat Trafik och kartor Traffic and maps   2018-08-07T14:00:24.647447+03:00 0   {} [] 0 1402 1567 2238 1     4             1   2   1     2       581       71     8        
783 [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] Perhe- ja sosiaalipalvelut Familje- och socialservice Family and social services   2018-08-07T14:00:27.699133+03:00 0   {} [] 0 783 397 718       2             1         1           129       175 1   7   5    
997 [2164, 2166] Koulu- ja opiskeluterveydenhuolto Skol- och studenthälsovård School and student health services   2018-10-25T08:00:09.578039+03:00 1 986 {} [] 0 986 241 320                               1           2       68 1   7        
1372 [1373, 1374, 1375] Oppilas- ja opiskelijahuolto Elevvård Pupil and student care   2018-08-07T14:00:27.603403+03:00 1 1087 {} [] 0 1087 241 388                               1           2       136 1   7        
1373 [2165, 2167] Koulu- ja opiskeluterveydenhuolto Skol- och studenthälsovård School and student health services   2018-10-25T08:00:08.960295+03:00 2 1372 {} [] 0 1087 241 320                               1           2       68 1   7        
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    
1403 [343, 551, 717, 365] Kulttuuri, liikunta ja vapaa-aika Kultur, motion och fritid Culture, sports and leisure   2018-08-07T14:00:22.534057+03:00 0   {} [] 0 1403 5769 8871 1     18 1 1       1 12 1 20   3 1 6 14       1685     1 1238 1 37 57 4      
40 [] Lasinkeräys Glasåtervinning Glass recycling 374 2018-08-07T14:00:21.831316+03:00 3 34 {} [374] 0 1400 50 138                                           46       37     5        
60 [61, 62, 68, 2236, 71, 72] Puistot ja viheralueet Parker och grönområden Parks and green areas   2018-08-07T14:00:21.354530+03:00 2 1 {} [] 0 1400 520 967                     1                     268       173     5        
68 [70, 69] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:21.413441+03:00 3 60 {} [] 0 1400 293 647                                           201       148     5        
70 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:21.425954+03:00 4 68 {} [389] 0 1400 224 567                                           193       145     5        
122 [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] Elinkeino, työ ja verotus Näringar, arbete och beskattning Entrepreneurship, work and taxation   2018-08-07T14:00:29.995212+03:00 1 1401 {} [] 0 1401 322 452       2 1         1 2 1     2     2       51       62     5   1    
231 [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] Kiinteistöt ja rakennetut tilat Fastigheter Real estate   2018-08-07T14:00:22.059452+03:00 2 221 {} [] 0 1400 311 427       1 1         1   1     2     2       48       55     5        
491 [492, 493, 499, 2237, 502, 2235] Puistot ja viheralueet Parker och grönområden Parks and green areas   2018-08-07T14:00:22.684763+03:00 2 343 {} [] 0 1403 520 967                     1                     268       173     5        
499 [501, 500] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:22.748801+03:00 3 491 {} [] 0 1403 293 647                                           201       148     5        
501 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:22.761746+03:00 4 499 {} [389] 0 1403 224 567                                           193       145     5        
558 [559, 564, 567, 572, 575, 577, 592, 597] Maastoliikuntapaikat Anläggningar för terrängidrott Cross-country sports facilities   2018-08-07T14:00:23.281875+03:00 2 551 {} [] 0 1403 151 443       5                 1       1         118       153   9 5        
612 [] Liikuntasali Idrottssal Gymnastics hall 402 2018-08-07T14:00:23.630490+03:00 4 608 {} [402] 0 1403 308 512                                           97       102     5        
659 [] Pallokenttä Bollplan Ball field 495 2018-08-07T14:00:23.987386+03:00 4 654 {} [495] 0 1403 408 743                                           169       161     5        
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} [340] 0 1087   71                                                   66     5        
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        
2165 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:27.619794+03:00 3 1373 {} [339] 0 1087 160 236                               1           1       68 1   5        
551 [552, 2151, 558, 2217, 601, 633, 666, 684, 694] Liikunta Idrott och motion Sports and physical exercise   2018-08-07T14:00:23.220207+03:00 1 1403 {} [] 0 1403 2590 4872       16             3   19     1 1 11       1260     1 892   36 42        
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        
1400 [2, 1, 14, 24, 31, 221, 85] Asuminen ja kaupunkiympäristö Boende och stadsmiljö Housing and urban environment   2018-08-07T14:00:21.224786+03:00 0   {} [] 0 1400 2311 4077       17 1 23 1     1 4 1     30   53 43       737     3 698 35 10 31 37 41    
152 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:30.200626+03:00 4 149 {} [214] 0 1401 218 249       1 1         1   1           1       10       13     3        
261 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.239469+03:00 5 258 {} [214] 0 1400 218 249       1 1         1   1           1       10       13     3        
306 [307, 314, 320, 324, 329, 342] Kartat, tietopalvelut ja viestintä Kartor, informationstjänster och kommunikation Maps, information services and communication   2018-08-07T14:00:24.652419+03:00 1 1402 {} [] 0 1402 307 389                     1                     42       36     3        
352 [353, 354, 355, 356, 357, 358, 359, 360] Kulttuuritilat Kulturlokaler Cultural facilities   2018-08-07T14:00:22.597325+03:00 2 343 {} [] 0 1403 198 232                                           18       13     3        
365 [2162, 2156, 368, 367, 366, 490] Nuoriso Ungdom Youth   2018-08-07T14:00:22.862181+03:00 1 1403 {} [] 0 1403 82 146 1     1                                   30       29     3        
368 [371, 374, 375, 376, 378, 381, 389, 391, 395, 396, 399, 2155, 403, 404, 405, 409, 410, 415, 418, 419, 421, 424, 426, 429, 433, 437, 438, 440, 442, 446, 448, 449, 452, 453, 454, 455, 458, 467, 468, 470, 473, 2154, 480, 481, 485, 488] Harrasteet Hobbyer Hobbies   2018-08-07T14:00:22.885008+03:00 2 365 {} [] 0 1403 71 120 1     1                                   27       17     3        
508 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.820471+03:00 3 505 {} [214] 0 1403 218 249       1 1         1   1           1       10       13     3        
577 [579, 580, 581, 582, 583, 584, 585, 586, 590] Liikunta- ja ulkoilureitit Idrotts- och friluftsleder Sports and outdoor recreation routes   2018-08-07T14:00:23.400833+03:00 3 558 {} [] 0 1403 132 401       3                 1       1         105       147   9 3        
717 [754, 718, 2173, 2028] Matkailu ja tapahtumat Turism och evenemang Things to do   2020-03-06T18:32:07.102459+02:00 1 1403 {} [] 0 1403 1973 2155       1 1 1       1 2 1 1   3   5 3       87       67 1 1 3 4      
718 [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] Matkailu Turism Tourism   2018-08-07T14:00:24.401683+03:00 2 717 {} [] 0 1403 1880 2050       1 1 1       1 1 1 1   3   5 3       79       64 1 1 3 4      
737 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:24.498919+03:00 3 718 {} [214] 0 1403 218 249       1 1         1   1           1       10       13     3        
825 [] Vanhusten palveluasuminen Serviceboende för äldre Service residence for the elderly 760 2018-08-07T14:00:27.984445+03:00 2 819 {} [760] 0 783 30 103       1                                   36       32     3   1    
829 [] Kotihoito Hemvård Home care 635 2020-03-06T18:32:08.579934+02:00 2 819 {} [635] 0 783 69 95                                           19       4     3        
845 [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] Muu sosiaalihuolto Övrig socialvård Other social welfare   2018-08-07T14:00:28.112184+03:00 1 783 {} [] 0 783 105 239       1                                   11       118     3   1    
996 [] Kotihoito Hemvård Home care 635 2020-03-06T18:32:09.105708+02:00 1 986 {} [635] 0 986 69 95                                           19       4     3        
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        
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        
2167 [] Opiskeluterveydenhuolto Studenthälsovård Student health care 863 2018-08-07T14:00:27.627209+03:00 3 1373 {} [863] 0 1087 81 154                                           2       68     3        
633 [634, 639, 646, 654, 663] Ulkokentät ja liikuntapuistot Utomhusplaner och idrottsparker Outdoor fields and sports parks   2018-08-07T14:00:23.790680+03:00 2 551 {} [] 0 1403 1261 2383                         1     1           636       457   4 23        
31 [32, 33, 34, 52, 53, 54] Jätehuolto ja kierrätys Avfallshantering och återvinning Waste management and recycling   2018-08-07T14:00:21.761620+03:00 1 1400 {} [] 0 1400 215 572                                   1       150       186     20        
34 [35, 36, 37, 38, 2211, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51] Keräyspisteet Insamlingsplatser Collection points   2018-08-07T14:00:21.780177+03:00 2 31 {} [] 0 1400 210 565                                           150       185     20        
42 [] Muovinkeräys Plaståtervinning Plastic recycling 454 2018-08-07T14:00:21.846516+03:00 3 34 {} [454] 0 1400 23 70                                           29       16     2        
44 [] Pahvinkeräys Insamling av wellpapp Corrugated cardboard recycling 491 2018-08-07T14:00:21.860147+03:00 3 34 {} [491] 0 1400 2 7                                           1       2     2        
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} [696] 0 1400 40 108                                           37       29     2        
150 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:30.186216+03:00 4 149 {} [799] 0 1401 3 8                                           2       1     2        
171 [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] Hallinto ja talous Förvaltning och ekonomi Administration and economy   2018-08-07T14:00:30.363012+03:00 1 1401 {} [] 0 1401 124 163       1                           1       17       17     2   1    
259 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:22.226278+03:00 5 258 {} [799] 0 1400 3 8                                           2       1     2        
324 [325, 2040, 2193, 327, 328, 2194] Kirjastot Bibliotek Libraries   2018-08-07T14:00:24.821378+03:00 2 306 {} [] 0 1402 83 125                                           26       14     2        
345 [346, 2026, 2196, 348, 349, 2197] Kirjastot Bibliotek Libraries   2018-08-07T14:00:22.550752+03:00 2 343 {} [] 0 1403 114 157                                           27       14     2        
355 [] Kulttuurin monitoimitalot Allaktivitetshus för kultur Multi-functional culture venues 345 2018-08-07T14:00:22.617002+03:00 3 352 {} [345] 0 1403 8 18                                           3       5     2        
357 [] Näyttelytilat Utställningslokaler Exhibition spaces 474 2018-08-07T14:00:22.630116+03:00 3 352 {} [474] 0 1403 105 114                                           7             2        
506 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:22.804088+03:00 3 505 {} [799] 0 1403 3 8                                           2       1     2        
515 [] Joukkoliikennepysäkit Kollektivtrafikens hållplatser Public transport stops 209 2018-08-07T14:00:25.015254+03:00 3 513 {} [209] 0 1402   3                                           1             2        
520 [] Rautatieasemat Järnvägsstationer Railway stations 576 2018-08-07T14:00:25.051739+03:00 3 513 {} [576] 0 1402 16 41                                           9       14     2        
526 [527, 528, 2207, 529, 530, 2204, 532] Pysäköinti Parkering Parking   2018-08-07T14:00:25.093849+03:00 2 512 {} [] 0 1402 559 1023                                           460       2     2        
532 [] Yleiset pysäköintialueet Allmänna parkeringsområden Public parking lot 814 2018-08-07T14:00:25.132843+03:00 3 526 {} [814] 0 1402 1 346                                           343             2        
575 [576] Laskettelurinteet ja rinnehiihtokeskukset Slalombackar och alpina skidcentra Ski slopes and downhill ski resorts   2018-08-07T14:00:23.388106+03:00 3 558 {} [] 0 1403 2 6                                           2             2        
576 [] Laskettelun suorituspaikat Slalombackar och alpina skidcentra Ski slopes and downhill ski resorts 376 2018-08-07T14:00:23.393272+03:00 4 575 {} [376] 0 1403 2 6                                           2             2        
611 [] Kuntosali Gym Gym 350 2018-08-07T14:00:23.623495+03:00 4 608 {} [350] 0 1403 151 237                                           45       39     2        
614 [615, 616, 617, 618, 619, 620, 621, 622, 623] Liikuntahallit Idrottshallar Sports halls   2018-08-07T14:00:23.644666+03:00 3 601 {} [] 0 1403 149 233                                           60       22     2        
639 [641, 642, 643, 644, 645] Jääurheilualueet ja luonnonjäät Isidrottsområden och naturisar Ice sports areas and sites with natural ice   2018-08-07T14:00:23.829697+03:00 3 633 {} [] 0 1403 165 358                                           114       77     2        
642 [] Luistelukenttä Skridskobana Ice-skating field 406 2018-08-07T14:00:23.848959+03:00 4 639 {} [406] 0 1403 136 308                                           100       70     2        
647 [] Liikuntapuisto Idrottspark Sports park 401 2018-08-07T14:00:23.890605+03:00 4 646 {} [401] 0 1403   7                                           3       2     2        
657 [] Koripallokenttä Basketplan Basketball court 331 2018-08-07T14:00:23.971455+03:00 4 654 {} [331] 0 1403 153 256                                           64       37     2        
662 [] Tenniskenttäalue Område med tennisbanor Tennis court area 700 2018-10-25T08:00:07.016431+03:00 4 654 {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} [700] 0 1403 45 83                                           11       25     2        
791 [794, 795, 792, 793, 796] Muut perheiden palvelut Övriga tjänster för familjer Other family services   2018-08-07T14:00:27.754089+03:00 1 783 {} [] 0 783 16 40                                           4       18     2        
810 [815, 816, 817, 813, 812, 811, 818, 814, 1007] Kehitysvammahuolto Vård av utvecklingsstörda Care for the developmentally disabled   2018-08-07T14:00:27.882619+03:00 1 783 {} [] 0 783 56 109                                           12       36     2   3    
820 [] Vanhuspalvelun sosiaalityö Socialt arbete inom äldreomsorgen Service for the elderly, social work 764 2018-08-07T14:00:27.951192+03:00 2 819 {} [764] 0 783 5 16                                           1       8     2        
824 [] Vanhusten itsenäinen asuminen Självständigt boende för äldre Independent habitation for the elderly 757 2018-08-07T14:00:27.977916+03:00 2 819 {} [757] 0 783   4                                                   2     2        
876 [] kielikylpy ruotsi språkbad, svenska language immersion, Swedish 663*294 2018-08-07T14:00:28.297483+03:00 4 870 {} [663, 294] 0 1405 9 19                                           5       3     2        
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
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        
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        
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        
1083 [1084, 1086] Väestönsuojat Befolkningsskyddsrum Public shelters   2018-08-07T14:00:29.937480+03:00 1 1061 {} [] 0 1061 47 49                                                         2        
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        

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