service_node

279 rows where level = 2 sorted by name_en 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__unknown, 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

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ää
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        
23 [] Luonnonvaraisten eläinten hoitola Vårdanstalt för vilda djur Wildlife home 411 2018-08-07T14:00:21.732081+03:00 2 14 {} [411] 0 1400 1 1                                                                  
91 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:21.983685+03:00 2 85 {} [766] 0 1400 2 2                                                                  
541 [542, 547] Vesiliikenne Sjötrafik Water traffic   2018-08-07T14:00:25.190941+03:00 2 512 {} [] 0 1402 223 279 1     4                 2   1     2       45             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        
33 [] Jätteenkäsittelykeskus Avfallshanteringscentral Waste treatment centre 234 2018-08-07T14:00:21.773147+03:00 2 31 {} [234] 0 1400   1                                           1                      
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} [232] 0 1400 1 2                                                         1        
53 [] Ongelmajäteasema Problemavfall station Waste management station 478 2018-08-07T14:00:21.933801+03:00 2 31 {} [478] 0 1400 1 2                                           1                      
1074 [] Sopimuspalokunnat Avtalsbrandkårer Volunteer fire departments 633 2018-08-07T14:00:29.872976+03:00 2 1070 {} [633] 0 1061 15 23                                           7             1        
123 [] Ammatinvalinnanohjaus Yrkesvägledning Vocational guidance 51 2018-08-07T14:00:30.001277+03:00 2 122 {} [51] 0 1401 4 6                                           1       1              
2173 [] Tapahtumapaikat Evenemangsplatser Venues 868 2018-08-07T14:00:24.624759+03:00 2 717 {} [868] 0 1403 195 211                                           10       6              
795 [] Lapsiperheiden lomatoiminta Semesterverksamhet för barnfamiljer Vacation activities for families with children 372 2018-08-07T14:00:27.784058+03:00 2 791 {} [372] 0 783   1                                                         1        
1010 [] Yliopistolliset sairaalat Universitetssjukhus University hospitals 820 2018-08-07T14:00:29.314677+03:00 2 1009 {} [820] 0 986 18 31                             1 1           4   2   3 2            
165 [] Työttömyys Arbetslöshet Unemployment 464 2018-08-07T14:00:30.308304+03:00 2 122 {} [464] 0 1401 4 8                                           1       3              
853 [] Sosiaalihuoltolain mukainen kuljetuspalvelu Färdtjänst enligt socialvårdslagen Transportation service according to the legislation on social welfare 640 2018-08-07T14:00:28.169839+03:00 2 845 {} [640] 0 783 3 6                                                   2     1        
805 [] Vammaispalvelulain mukainen kuljetuspalvelu Färdtjänst enligt handikappservicelagen Transportation service according to the legislation on disability services 745 2018-08-07T14:00:27.849436+03:00 2 798 {} [745] 0 783 4 8                                           2       2              
521 [522, 523] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:25.059349+03:00 2 512 {} [] 0 1402 1 5                                           2       1     1        
133 [] Kauppa- ja yhdistysrekisteri Handelsregistret och föreningsregistret Trade register and register of associations 257 2018-08-07T14:00:30.073459+03:00 2 122 {} [257] 0 1401 1 2                                           1                      
126 [] Elinkeinoasiat Näringslivsfrågor Trade and industry matters 132 2018-08-07T14:00:30.024180+03:00 2 122 {} [132] 0 1401 2 2                                                                  
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      
754 [] Lipunmyynti tapahtumiin Biljettförsäljning till evenemang Ticket sales to events 405 2018-08-07T14:00:24.631976+03:00 2 717 {} [405] 0 1403 5 13                     1                     6       1              
1064 [] Puolustusvoimat Försvarsmakten The Finnish Defence Forces 529 2018-08-07T14:00:29.789161+03:00 2 1062 {} [529] 0 1061 6 7                                           1                      
166 [] Verotoimistot Skattebyråer Tax offices 775 2018-08-07T14:00:30.318117+03:00 2 122 {} [775] 0 1401 1 1                                                                  
1365 [1366, 1368, 1367] Ruotsinkielinen työväenopisto Svenska arbetarinstitutet Swedish adult education centre 605 2020-11-18T07:30:12.874521+02:00 2 1360 {} [605] 0 1087 6 9                                           1             2        
983 [] Yksityisen hoidon tuki Privatvårdsstöd Support for private care 811 2018-08-07T14:00:29.020270+03:00 2 868 {} [811] 0 1405 111 118                                           7                      
2157 [] Tuki digipelaamisen ja netin liikakäytön ongelmiin Stöd för överanvändningsproblem av digitala spel och internet Support for digital gaming and internet over-use problems 855 2018-08-07T14:00:28.074000+03:00 2 830 {} [855] 0 783 1 1                                                                  
2158 [] Tuki digipelaamisen ja netin liikakäytön ongelmiin Stöd för överanvändningsproblem av digitala spel och internet Support for digital gaming and internet over-use problems 855 2018-08-07T14:00:29.751405+03:00 2 1051 {} [855] 0 986 1 1                                                                  
2012 [] Täydentävä toimeentulotuki Kompletterande utkomststöd Supplementary social assistance 841 2018-08-07T14:00:28.105801+03:00 2 839 {} [841] 0 783 7 9                                                   1     1        
2181 [] Suomenkielinen ammatillinen lisäkoulutus Påbyggnadsutbildning på finska Supplementary education in Finnsh 653*873 2018-08-31T16:00:09.195826+03:00 2 2179 {} [873, 653] 1 1087 14 16                                           2                      
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        
367 [] Katutaidepaikat Platser för gatukonst Street art locations 254 2018-08-07T14:00:22.877110+03:00 2 365 {} [254] 0 1403 12 12                                                                  
342 [] Tilastot ja tietopalvelut Statistik och informationstjänst Statistics and information services 709 2018-10-25T08:00:07.381081+03:00 2 306 {} [709] 0 1402 2 2                                                                  
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        
846 [] Aikuisten sosiaalityö Socialt arbete för vuxna Social work for adults 42 2018-08-07T14:00:28.117778+03:00 2 845 {} [42] 0 783 21 25                                           3       1              
854 [] Sosiaalinen luotto Social kredit Social lending 641 2018-08-07T14:00:28.176603+03:00 2 845 {} [641] 0 783 1 4                                           2       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        
848 [] Aikuisten sosiaaliohjaus Socialhandledning för vuxna Social care work for adults 41 2018-08-07T14:00:28.131053+03:00 2 845 {} [41] 0 783 6 9                                           1       2              
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              
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              
1068 [] Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) Stödtjänster inom social- och hälsovården (stöd för boende) Social and health care services' security services (housing support) 636 2018-08-07T14:00:29.828890+03:00 2 1066 {} [636] 0 1061 1 2                                                   1              
1084 [] Yhteiskalliosuojat Gemensamma bergskyddsrum Shared ground shelters 808 2018-08-07T14:00:29.944094+03:00 2 1083 {} [808] 0 1061 29 29                                                                  
87 [] Jäteveden puhdistamo Avloppsreningsverk Sewage treatment plant 233 2018-08-07T14:00:21.958557+03:00 2 85 {} [233] 0 1400 1 2                                           1                      
821 [] Vanhuspalvelun sosiaaliohjaus Socialhandledning inom äldreomsorg Services for the elderly, social care work 763 2018-08-07T14:00:27.957632+03:00 2 819 {} [763] 0 783 4 7                                                   2     1        
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              
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              
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              
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              
857 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:28.196278+03:00 2 845 {} [420] 0 783 14 20                                           2       3     1        
796 [] Perheoikeudelliset palvelut Familjerättsliga tjänster Services for family law 505 2018-08-07T14:00:27.790684+03:00 2 791 {} [505] 0 783   1                                                   1              
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    
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        
822 [] Vanhusten päivätoiminta Dagverksamhet för äldre Service for the elderly, daytime activities 762 2018-08-07T14:00:27.964013+03:00 2 819 {} [762] 0 783 17 30                                           9       3     1        
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              
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              
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              
823 [] Vanhusten palvelukeskustoiminta Servicecentralverksamhet för äldre Service centre activities for the elderly 761 2018-08-07T14:00:27.970552+03:00 2 819 {} [761] 0 783 14 15                                                         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        
88 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:21.964747+03:00 2 85 {} [453] 0 1400 1 2                             1                                    
2006 [] Veistokset ja julkinen taide Skulpturer och offentlig konst Sculptures and public art 767 2018-08-07T14:00:22.854537+03:00 2 343 {"fi": ["patsas", "patsaat", "veistos"]} [767] 0 1403 482 488                     6                                            
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} [340] 0 1087   71                                                   66     5        
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} [343] 0 1087   2                                                   2              
1369 [] Kuvataidekoulu Konstskola School of visual arts 360 2020-11-18T07:30:12.906446+02:00 2 1360 {} [360] 0 1087   7                                                   6     1        
1073 [] Pelastuskoulu Räddningsskolan School of Fire and Rescue Services 502 2018-08-07T14:00:29.866063+03:00 2 1070 {} [502] 0 1061 1 1                                                                  
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        
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        
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        
1067 [] Turvallisuuskoulutus Säkerhetsutbildning Safety training 720 2018-08-07T14:00:29.819172+03:00 2 1066 {} [720] 0 1061 1 1                                                                  
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        
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        
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    
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        
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              
1072 [] Pelastusasemat Räddningsstationerna Rescue Stations 501 2018-08-07T14:00:29.858704+03:00 2 1070 {} [501] 0 1061 9 21                                           6       6              
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        
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        
8 [10, 9, 11] Vuokra-asuminen Hyresbostäder Rental flats   2018-08-07T14:00:21.267377+03:00 2 2 {} [] 0 1400 9 13                                           3             1        
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              
1022 [] Kuntoutuspsykiatria Rehabiliteringspsykiatri Rehabilitation psychiatry 354 2018-08-07T14:00:29.429019+03:00 2 1019 {} [354] 0 986 2 3                                           1                      
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        
1032 [] Kuntoutuksen vuodeosastopalvelut Vårdavdelningstjänster inom rehabilitering Rehabilitation inpatient care 353 2018-08-07T14:00:29.514187+03:00 2 1028 {} [353] 0 986   3                                           2       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        
179 [] Kirjaamo Registratorskontor Registrar's office 310 2018-08-07T14:00:30.455188+03:00 2 171 {} [310] 0 1401 4 8                                           2       2              
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    
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} [298] 0 1400 3 7                                   1       1       1     1        
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        
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        
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        
94 [] Yleisövessat Allmänna toaletter Public toilets 819 2018-10-25T08:00:06.064613+03:00 2 1 {} [819] 0 1400 39 39                                                                  
132 [] Kaupanvahvistus Bestyrkande av köp Public purchase witnessing 255 2018-08-07T14:00:30.067157+03:00 2 122 {} [255] 0 1401 1 3                                           1       1              
186 [] Kuulutukset Kungörelser Public announcements 358 2018-08-07T14:00:30.500246+03:00 2 171 {} [358] 0 1401   2                                           1       1              
1027 [] Psykoterapia Psykoterapi Psychotherapy 526 2018-08-07T14:00:29.469348+03:00 2 1019 {} [526] 0 986 2 2                                                                  
1024 [] Psykiatrinen asumiskuntoutus Psykiatrisk boenderehabilitering Psychiatric residential rehabilitation 522 2018-08-07T14:00:29.444521+03:00 2 1019 {} [522] 0 986 3 6                                           1       2              
1023 [] Psykiatrian poliklinikat Psykiatriska polikliniker Psychiatric outpatient clinics 521 2018-08-07T14:00:29.437165+03:00 2 1019 {} [521] 0 986 19 19                                                                  
1025 [] Psykiatrinen perhehoito Psykiatrisk familjevård Psychiatric family care 523 2018-08-07T14:00:29.453053+03:00 2 1019 {} [523] 0 986 2 2                                                                  
1026 [] Psykiatrinen päiväsairaala Psykiatriskt dagsjukhus Psychiatric day hospital 524 2018-08-07T14:00:29.460729+03:00 2 1019 {} [524] 0 986 2 2                                                                  
177 [] Hankintapalvelut Upphandlingstjänster Procurement services 217 2018-08-07T14:00:30.442764+03:00 2 171 {} [217] 0 1401 1 1                                                                  
2011 [] Ehkäisevä toimeentulotuki Förebyggande utkomststöd Preventive social assistance 840 2018-08-07T14:00:28.099014+03:00 2 839 {} [840] 0 783 7 8                                                         1        
2186 [] Ammatilliseen peruskoulutukseen valmentava koulutus - VALMA Handledande utbildning för grundläggande yrkesutbildning - VALMA Preparatory education for vocational training - VALMA 470 2018-08-31T16:00:09.222841+03:00 2 2179 {} [470] 1 1087 8 9                                                   1              

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