service_node

279 rows where level = 2 sorted by unit_count_municipality_vantaa descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, 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, last_modified_time (date)

unit_count_municipality__unknown ✖

  • 1 15
  • 6 1

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ää
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        
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} [76] 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
601 [602, 606, 608, 614, 624] Sisäliikuntatilat Anläggningar för inomhusidrott Indoor sports facilities   2018-08-07T14:00:23.557871+03:00 2 551 {} [] 0 1403 795 1314                                           278       229     12        
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        
869 [897, 905, 913, 921, 929, 881, 889, 937, 870, 945, 2238, 953] Päiväkotihoito Daghemsvård Day care centres   2018-08-07T14:00:28.258090+03:00 2 868 {} [] 0 1405 497 1020                                           329       184     10        
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        
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        
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        
1089 [1090] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:07.479235+02:00 2 1088 {} [861] 1 1087 289 484                                           78       117              
2122 [2125] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:09.045855+02:00 2 2118 {} [861] 1 1405 289 484                                           78       117              
847 [] Alueellinen kumppanuustyö Områdesvist partnerskapsarbete Regional partnership work 49 2018-08-07T14:00:28.124411+03:00 2 845 {} [49] 0 783 19 119       1                                   1       96     1   1    
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        
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        
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        
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} [340] 0 1087   71                                                   66     5        
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      
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        
1098 [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] Suomen- ja vieraskielinen perusopetus Grundläggande utbildning på finska och främmande språk Basic education in Finnish, English and other languages   2020-03-06T18:32:07.543511+02:00 2 1097 {} [] 0 1087 368 504                               1           84       50 1            
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        
801 [] Vammaispalvelun sosiaaliohjaus Socialhandledning inom handikappservice Services for the disabled, social care work 751 2018-08-07T14:00:27.822488+03:00 2 798 {} [751] 0 783   33       1                                           32              
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    
975 [976, 977, 978, 979, 981, 982] Leikkitoiminta Lekverksamhet Playground activities   2018-08-07T14:00:28.970500+03:00 2 868 {} [] 0 1405 144 210                                           33       32     1        
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        
16 [17, 18, 19, 20, 21] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:21.685399+03:00 2 14 {} [] 0 1400 102 149                                           22       25              
270 [271, 272, 277, 278, 279, 286, 287, 293, 302] Rakentaminen Byggande Construction   2018-08-07T14:00:22.314988+03:00 2 221 {} [] 0 1400 48 80                     1       1             8       21     1        
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        
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 {} [275] 0 783 39 71                                           9       21     1   1    
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 {} [314] 0 1403 63 86                                           3       19     1        
1370 [] Musiikkiopisto Musikinstitut Music institute 456 2020-11-18T07:30:12.915030+02:00 2 1360 {} [456] 0 1087   20                                                   19     1        
134 [137, 136, 135, 138, 139] Maan, tonttien ja asuntojen vuokraus ja myynti Försäljning och uthyrning av mark, tomter, lokaler och bostäder Sales and rental of land, lots, facilities and apartments   2018-08-07T14:00:30.080832+03:00 2 122 {} [] 0 1401 10 32                                           4       17     1        
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        
552 [553, 2007] Eläinurheilualueet Anläggningar för djursport Animal sports areas   2018-08-07T14:00:23.225274+03:00 2 551 {} [] 0 1403 27 75                                           31       17              
73 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:21.445519+03:00 2 1 {} [532] 0 1400 44 74                                           14       16              
74 [76, 77, 78, 75, 79, 2205] Tiet ja kadut Vägar och gator Roads and streets   2018-08-07T14:00:21.451762+03:00 2 1 {} [] 0 1400 356 376                                           3       16     1        
503 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:22.776545+03:00 2 343 {} [532] 0 1403 44 74                                           14       16              
534 [536, 537, 538, 535, 539, 2206] Tiet ja kadut Vägar och gator Roads and streets   2018-08-07T14:00:25.145762+03:00 2 512 {} [] 0 1402 356 376                                           3       16     1        
789 [] Lastensuojelun laitospalvelu Institutionstjänster inom barnskyddet Institutional service for child welfare 380 2018-08-07T14:00:27.738722+03:00 2 787 {} [380] 0 783 12 37                               1           7       16 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 {} [373] 0 783   17                                                   16     1        
684 [685, 690] Vesiliikuntapaikat Anläggningar för vattenidrott Water sports facilities   2018-08-07T14:00:24.163817+03:00 2 551 {} [] 0 1403 78 153                         4                 51       15   4 1        
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        
314 [319, 315, 317, 316, 2147, 2159] Asiakaspalvelu ja neuvonta Kundbetjäning och rådgivning Customer service and information   2018-08-07T14:00:24.703287+03:00 2 306 {} [] 0 1402 12 39                     1                     12       13     1        
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        
366 [] Nuorisotalot Ungdomsgårdar Youth centres 468 2018-08-07T14:00:22.869007+03:00 2 365 {} [468] 0 1403 39 69                                           16       13     1        
803 [] Vammaispalvelun asumispalvelut Boendetjänster inom handikappservicen Services for the disabled, residential services 746 2018-08-07T14:00:27.835887+03:00 2 798 {} [746] 0 783 7 24       1                                   3       13              
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 {} [471] 0 1403 7 22                                           3       12              
852 [] Muun sosiaalihuollon asumispalvelut Boendetjänster inom övrig socialvård Residential services for other social welfare 637 2018-08-07T14:00:28.163665+03:00 2 845 {} [637] 0 783 11 26       1                                   1       12     1        
59 [] Matonpesupaikat Mattvättningsplatser Carpet washing places 432 2018-08-07T14:00:21.345565+03:00 2 1 {} [432] 0 1400 13 29                                           5       11              
361 [] Matonpesupaikat Mattvättningsplatser Carpet washing places 432 2018-08-07T14:00:22.659080+03:00 2 343 {} [432] 0 1403 13 29                                           5       11              
961 [962, 2145] Perhepäivähoito Familjedagvård Family day care   2018-08-07T14:00:28.863138+03:00 2 868 {} [] 0 1405 71 134                                           51       11     1        
1005 [] Lastenneuvola Barnrådgivning Child health clinic 379 2018-10-25T08:00:09.610190+03:00 2 1004 {} [379] 0 986 22 47                                           14       10     1        
2217 [2218, 2219, 2220, 2221, 2223, 2224, 2225, 2226] Senioriliikunta Seniormotion Senior sports   2020-06-09T15:30:11.296799+03:00 2 551 {} [] 0 1403 88 104                     1                     4       10     1        
802 [] Vammaispalvelun päivätoiminta Dagverksamhet inom handikappservicen Service for the disabled, daytime activities 750 2018-08-07T14:00:27.829187+03:00 2 798 {} [750] 0 783   10                                           1       9              
172 [173, 176, 2001, 2002] Hallinto Förvaltning Administration   2018-08-07T14:00:30.370486+03:00 2 171 {} [] 0 1401 59 72                                   1       3       8     1        
329 [2153, 330, 333, 2149] Nettipisteet ja tietotekniikkapalvelut Internetstationer och datatekniktjänster Internet access points and IT services   2018-10-25T08:00:07.323845+03:00 2 306 {} [] 0 1402 246 257                                           3       8              
362 [363, 364] Museot Museer Museums   2018-08-07T14:00:22.665582+03:00 2 343 {} [] 0 1403 64 96           1                     4 1       13       8 1     4      
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        
851 [] Kuntouttava työtoiminta Arbetsverksamhet i rehabiliterande syfte Rehabilitative work 351 2018-08-07T14:00:28.157405+03:00 2 845 {} [351] 0 783 34 43                                           1       8              
855 [] Työkykyselvitys pitkäaikaistyöttömille Pensionsutredningsverksamhet Pension determination service 724 2018-08-07T14:00:28.183191+03:00 2 845 {} [724] 0 783 2 10                                                   8              
1258 [1260, 1271, 1268, 1296, 1259] Suomen- ja vieraskielinen nuorten lukiokoulutus Gymnasieutbildning för unga på finska och främmande språk General upper secondary education for the young in Finnish, English and other languages   2020-03-06T18:32:08.032022+02:00 2 1257 {} [] 0 1087 31 54                                           15       8              
2160 [] Mielenterveyskuntoutujien asumispalvelut Boendetjänster för klienter inom psykrehabilitering Residential services for mental health rehabilitation clients 857 2018-08-07T14:00:28.137962+03:00 2 845 {} [857] 0 783 6 14                                                   8              
694 [695, 706] Virkistyskohteet ja palvelut Rekreationsanläggningar och tjänster Recreational destinations and services   2018-08-07T14:00:24.231367+03:00 2 551 {} [] 0 1403 235 442       11             1   13         11       143     1 7   19 1        
788 [] Lastensuojelun sosiaalityö Socialt arbete inom barnskyddet Child welfare social work 382 2018-08-07T14:00:27.731506+03:00 2 787 {} [382] 0 783 25 42                                           9       7     1        
809 [] Vammaistuet ja -palvelut Handikappbidrag och -tjänster Disability benefits and services 755 2018-08-07T14:00:27.876348+03:00 2 798 {} [755] 0 783 3 15       1                                   2       7     1   1    
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 {} [543] 0 783 1 15                                           7       7              
1057 [] Päihdehuollon asumispalvelut Boendetjänster inom missbrukarvården Care for substance abuse, residential services 543 2018-08-07T14:00:29.725065+03:00 2 1051 {} [543] 0 986 1 15                                           7       7              
666 [667, 675, 677] Vene-, ilmailu- ja moottoriurheilu Anläggningar för båtsport, flygsport och motorsport Boating, aviation and motor sports   2018-08-07T14:00:24.041279+03:00 2 551 {} [] 0 1403 9 18                                           3       6              
785 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:27.709008+03:00 2 784 {} [71] 0 783 1 9                     1                     1       6              
832 [] Päihdehuollon sosiaaliohjaus Socialhandledning inom missbrukarvården Care for substance abuse, social care work 548 2018-08-07T14:00:28.028451+03:00 2 830 {} [548] 0 783   7                                                   6     1        
850 [] Työhön kuntoutus- ja työllistämispalvelut Arbetsrehabiliterings- och sysselsättningstjänster Rehabilitation and employment services for work 638 2018-08-07T14:00:28.151060+03:00 2 845 {} [638] 0 783 4 12                                           1       6     1        
989 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:29.129777+03:00 2 988 {} [71] 0 986 1 9                     1                     1       6              
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} [462] 0 986   6                                                   6              
1053 [] Päihdehuollon sosiaaliohjaus Socialhandledning inom missbrukarvården Care for substance abuse, social care work 548 2018-08-07T14:00:29.695330+03:00 2 1051 {} [548] 0 986   7                                                   6     1        
1072 [] Pelastusasemat Räddningsstationerna Rescue Stations 501 2018-08-07T14:00:29.858704+03:00 2 1070 {} [501] 0 1061 9 21                                           6       6              
1369 [] Kuvataidekoulu Konstskola School of visual arts 360 2020-11-18T07:30:12.906446+02:00 2 1360 {} [360] 0 1087   7                                                   6     1        
2173 [] Tapahtumapaikat Evenemangsplatser Venues 868 2018-08-07T14:00:24.624759+03:00 2 717 {} [868] 0 1403 195 211                                           10       6              
187 [188, 189] Maahanmuutto Invandring Immigration   2018-08-07T14:00:30.506450+03:00 2 171 {} [] 0 1401 17 29       1                                   4       5     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 {} [504] 0 783 10 20                                           4       5     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 {} [280] 0 783 3 9                                                   5     1        
1031 [] Fysioterapia Fysioterapi Physiotherapy 172 2018-08-07T14:00:29.505159+03:00 2 1028 {"fi": ["kuntoutus"]} [172] 0 986 11 21                                           4       5     1        
1036 [] Puheterapia Talterapi Speech therapy 527 2018-08-07T14:00:29.552393+03:00 2 1028 {"fi": ["kuntoutus"]} [527] 0 986 2 13                                           5       5     1        
1187 [1246, 1249, 1193, 1192, 1188, 1190, 1242] Ruotsinkielinen perusopetus Grundläggande utbildning på svenska Basic education in Swedish   2018-08-07T14:00:26.251158+03:00 2 1097 {} [] 0 1087 47 65                                           13       5              
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} [] 0 1402 4 11                                           2       4     1        
320 [321, 322, 323] Kartat ja paikkatietopalvelut Kartor och geografisk information Maps and location information services   2018-08-07T14:00:24.796452+03:00 2 306 {} [] 0 1402 4 10                                           2       4              
799 [] Vammaispalvelun sosiaalityö Socialt arbete inom handikappservicen Service for the disabled, social work 752 2018-08-07T14:00:27.810101+03:00 2 798 {} [752] 0 783 4 11                                           3       4              
800 [] Vammaispalvelun tukihenkilö Stödperson inom handikappservice Services for the disabled, support person 753 2018-08-07T14:00:27.816289+03:00 2 798 {} [753] 0 783 4 8                                                   4              
804 [] Vammaispalvelun tulkkipalvelu Tolktjänster inom handikappservicen Services for the disabled, interpretation services 754 2018-08-07T14:00:27.842330+03:00 2 798 {} [754] 0 783   6                                           2       4              
806 [] Vammaispalvelun omaishoidon tuki Stöd för närståendevård inom handikappservicen Services for the disabled, close relative care support 749 2018-08-07T14:00:27.856508+03:00 2 798 {} [749] 0 783 4 10                                           2       4              
807 [] Vammaispalvelun asunnon muutostyöt Ändringsarbeten i bostad inom handikappservicen Service for the disabled, renovation services 747 2018-08-07T14:00:27.863389+03:00 2 798 {} [747] 0 783 4 10                                           2       4              
808 [] Vammaispalvelun henkilökohtainen apu Personlig assistent inom handikappservicen Service for the disabled, personal assistant 748 2018-08-07T14:00:27.870086+03:00 2 798 {} [748] 0 783 4 9                                           1       4              
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 {} [278] 0 783 10 18                                           3       4         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 {} [276] 0 783   4                                                   4              
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        
1037 [] Rintamavetaraanien kuntoutus Rehabilitering av frontveteraner Front-line veteran rehabilitation 583 2018-08-07T14:00:29.562795+03:00 2 1028 {} [583] 0 986 1 6                                                   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 {} [519] 0 1061 1 6                                           1       4              
1093 [1096, 1095, 1094] Ruotsinkielinen esiopetus Förskoleundervisning på svenska Pre-primary education in Swedish 862 2018-08-07T14:00:25.315377+03:00 2 1088 {} [862] 1 1087 31 46                                           11       4              
2056 [2060, 2057, 2061] Ruotsinkielinen iltapäivätoiminta Eftermiddagsverksamhet på svenska Afternoon activities in Swedish 596 2018-08-07T14:00:25.399596+03:00 2 2042 {} [596] 1 1087 24 39                                           11       4              
2126 [2127, 2128, 2129] Ruotsinkielinen esiopetus Förskoleundervisning på svenska Pre-primary education in Swedish 862 2018-08-07T14:00:29.080400+03:00 2 2118 {} [862] 1 1405 31 46                                           11       4              
2180 [] Suomenkielinen ammatillinen peruskoulutus Grundutbildning på finska Basic education in Finnsh 653*872 2018-08-31T16:00:09.186721+03:00 2 2179 {} [872, 653] 1 1087 15 21                                           2       4              
141 [142, 144, 145] Markkinointi Marknadsföring Marketing   2018-08-07T14:00:30.127227+03:00 2 122 {} [] 0 1401 4 7                                                   3              

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