service_node

279 rows where level = 2 sorted by unit_count_municipality_espoo

✎ 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, last_modified_time (date)

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ää
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} [74] 0 1400   1                     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                                                                  
25 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:21.743023+03:00 2 24 {} [62] 0 1400 1 2                                                   1              
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} [146] 0 1400 1 1                                                                  
27 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:21.755624+03:00 2 24 {} [798] 0 1400 4 4                                                                  
28 [29] Hallinto Förvaltning Administration   2018-08-07T14:00:21.313217+03:00 2 1 {} [] 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        
54 [] Rantavesien ja sisäsaariston puhtaanapito Renhållning av strandvatten och inre skärgård Cleaning waterfronts and inner archipelago 572 2018-08-07T14:00:21.940289+03:00 2 31 {} [572] 0 1400 2 2                                                                  
58 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:21.337453+03:00 2 1 {} [418] 0 1400 1 1                                                                  
80 [81, 82, 83, 84] Torit ja kauppahallit Torg och saluhallar Market squares and halls   2018-08-07T14:00:21.488118+03:00 2 1 {} [] 0 1400 19 19                                                                  
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                                    
91 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:21.983685+03:00 2 85 {} [766] 0 1400 2 2                                                                  
93 [] Vesilaskut ja asiakaspalvelu Vattenfakturering och kundtjänst Billing for water and customer services 67+781 2018-10-24T20:30:07.186738+03:00 2 85 {} [781, 67] 0 1400 26 26                                                                  
94 [] Yleisövessat Allmänna toaletter Public toilets 819 2018-10-25T08:00:06.064613+03:00 2 1 {} [819] 0 1400 39 39                                                                  
97 [98, 99] Ympäristön hoito Miljövård Maintenance of the environment 825 2018-08-07T14:00:21.535829+03:00 2 1 {} [825] 0 1400 2 3                                                   1              
100 [] Ympäristön sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för miljöärenden Electronic services and forms related to environmental matters 826 2018-08-07T14:00:21.554721+03:00 2 1 {} [826] 0 1400   1                     1                                            
102 [] Ympäristöohjelmat Miljöprogram Environmental programmes 829 2018-08-07T14:00:21.567791+03:00 2 1 {} [829] 0 1400 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                                                                  
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} [135] 0 1401   1                     1                                            
141 [142, 144, 145] Markkinointi Marknadsföring Marketing   2018-08-07T14:00:30.127227+03:00 2 122 {} [] 0 1401 4 7                                                   3              
166 [] Verotoimistot Skattebyråer Tax offices 775 2018-08-07T14:00:30.318117+03:00 2 122 {} [775] 0 1401 1 1                                                                  
177 [] Hankintapalvelut Upphandlingstjänster Procurement services 217 2018-08-07T14:00:30.442764+03:00 2 171 {} [217] 0 1401 1 1                                                                  
178 [] Keskitetyt tietotekniikkapalvelut Centraliserade datatekniktjänster Centralised services on information technology 222 2018-08-07T14:00:30.449039+03:00 2 171 {} [222] 0 1401 1 2                                                   1              
197 [2152, 198, 209] Talous Ekonomi Economy   2018-08-07T14:00:30.559004+03:00 2 171 {} [] 0 1401 10 10                                                                  
219 [220] Tuet ja avustukset Understöd och bidrag Grants and benefits 715 2018-08-07T14:00:30.723645+03:00 2 171 {} [715] 0 1401   3                                                   2     1        
305 [] Viestintä Kommunikation Communications 784 2018-08-07T14:00:22.528397+03:00 2 221 {} [784] 0 1400 1 1                                                                  
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                                                                  
344 [] Kasvitieteelliset puutarhat Botaniska trädgårdar Botanic gardens 248 2018-08-07T14:00:22.544317+03:00 2 343 {} [248] 0 1403 3 3                                                                  
351 [] Kulttuuripalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för kulturtjänster Electronic services and forms related to cultural services 346 2018-08-07T14:00:22.590770+03:00 2 343 {} [346] 0 1403   2                     1                             1              
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                                                                  
525 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:25.085327+03:00 2 512 {} [418] 0 1402 1 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        
794 [] Lapsiperheiden kotipalvelu Hemservice för barnfamiljer Domestic services for families with children 371 2018-08-07T14:00:27.777393+03:00 2 791 {} [371] 0 783 6 9                                                   3              
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        
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              
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              
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        
812 [] Kehitysvammahuollon sosiaaliohjaus Socialhandledning inom omsorger om utvecklingsstörda Care of the developmentally disabled, social care work 279 2018-08-07T14:00:27.893701+03:00 2 810 {} [279] 0 783   1                                                         1        
814 [] Kehitysvammahuollon työllistämispalvelut Sysselsättningstjänster inom vård av utvecklingsstörda Care of the developmentally disabled, employment services 282 2018-08-07T14:00:27.906450+03:00 2 810 {} [282] 0 783 5 6                                                   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              
817 [] Kehitysvammahuollon loma- ja harrastustoiminta Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda Care of the developmentally disabled, vacation and leisure activities 277 2018-08-07T14:00:27.925241+03:00 2 810 {} [277] 0 783 3 6                                                   3              
818 [] Kehitysvammahuollon taloudellinen tuki Ekonomiskt stöd inom vård av utvecklingsstörda Care of the developmentally disabled, financial support 281 2018-08-07T14:00:27.931547+03:00 2 810 {} [281] 0 783 2 4                                                   2              
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        
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        
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        
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        
834 [] Päihdehuollon korvaushoito Substitutionsbehandling inom missbrukarvården Care for substance abuse, substitute treatment 545 2018-08-07T14:00:28.041229+03:00 2 830 {} [545] 0 783 4 5                                                   1              
835 [] Päihdehuollon päivätoiminta Dagverksamhet inom missbrukarvården Care for substance abuse, daytime activities 547 2018-08-07T14:00:28.047640+03:00 2 830 {} [547] 0 783 4 5                                                   1              
849 [] Mielenterveyskuntoutujien päivätoiminta Dagverksamhet för klienter inom psykrehabilitering Day activities for mental health rehabilitation clients 441 2018-08-07T14:00:28.144565+03:00 2 845 {} [441] 0 783   1                                                   1              
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        
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              
856 [] Sovittelutoiminta Medlingsverksamhet Mitigation services 644 2018-08-07T14:00:28.189606+03:00 2 845 {} [644] 0 783 1 2                                                   1              
985 [] Päivähoidon sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för dagvårdsärenden Electronic services and forms related to day care 552 2018-08-07T14:00:29.033246+03:00 2 868 {} [552] 0 1405 1 1                                                                  
1007 [] Kehitysvammapoliklinikka Handikapprådgivning Developmental disability clinic 284 2018-10-25T08:00:09.092312+03:00 2 810 {} [284] 0 783 4 6                                                   1         1    
1011 [] Kaupungin psykiatrinen sairaala Stadens psykiatriska sjukhus City Psychiatric Hospital 263 2018-08-07T14:00:29.322493+03:00 2 1009 {} [263] 0 986 2 2                                                                  
1013 [] Kotisairaalat Hemsjukhus Domestic hospitals 336 2018-08-07T14:00:29.340263+03:00 2 1009 {} [336] 0 986 3 4                                                   1              
1015 [] Sairaaloiden poliklinikat Sjukhusens polikliniker Hospital outpatient clinics 610 2018-08-07T14:00:29.359098+03:00 2 1009 {} [610] 0 986 3 3                                                                  
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} [46] 0 986 1 4                                                   3              
1021 [] HUS:n erikoissairaanhoito HNS:s specialsjukvård HUS specialised health care 440 2018-08-07T14:00:29.421431+03:00 2 1019 {} [440] 0 986 2 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                                                                  
1027 [] Psykoterapia Psykoterapi Psychotherapy 526 2018-08-07T14:00:29.469348+03:00 2 1019 {} [526] 0 986 2 2                                                                  
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} [462] 0 986   6                                                   6              
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        
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} [206] 0 986 7 10                                                   2     1        
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} [520] 0 986   1                                                   1              
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        
1055 [] Päihdehuollon korvaushoito Substitutionsbehandling inom missbrukarvården Care for substance abuse, substitute treatment 545 2018-08-07T14:00:29.709367+03:00 2 1051 {} [545] 0 986 4 5                                                   1              
1056 [] Päihdehuollon päivätoiminta Dagverksamhet inom missbrukarvården Care for substance abuse, daytime activities 547 2018-08-07T14:00:29.716393+03:00 2 1051 {} [547] 0 986 4 5                                                   1              
1063 [] Maanpuolustusyhdistykset Försvarsföreningar National defence associations 422 2018-08-07T14:00:29.780736+03:00 2 1062 {} [422] 0 1061 2 2                                                                  
1067 [] Turvallisuuskoulutus Säkerhetsutbildning Safety training 720 2018-08-07T14:00:29.819172+03:00 2 1066 {} [720] 0 1061 1 1                                                                  
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              
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                                                                  
1084 [] Yhteiskalliosuojat Gemensamma bergskyddsrum Shared ground shelters 808 2018-08-07T14:00:29.944094+03:00 2 1083 {} [808] 0 1061 29 29                                                                  
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        
1343 [1346, 1344, 1347, 1345] Ruotsinkielinen aikuisten perus- ja lukiokoulutus Grundläggande utbildning och gymnasieutbildning för vuxna på svenska Comprehensive and upper secondary school education for adults in Swedish   2018-08-07T14:00:27.400544+03:00 2 1335 {} [] 0 1087 1 1                                                                  
1354 [] Suomenkielinen oppisopimuskoulutus Läroavtalsutbildning på finska Apprenticeship training in Finnish 659 2018-08-07T14:00:27.469481+03:00 2 1353 {} [659] 1 1087 1 2                                                   1              
1355 [] Ruotsinkielinen oppisopimuskoulutus Läroavtalsutbildning på svenska Apprenticeship training in Swedish 599 2018-08-07T14:00:27.476430+03:00 2 1353 {} [599] 1 1087 1 1                                                                  
1357 [] Suomenkielinen ammattikorkeakoulukoulutus Yrkeshögskoleutbildning på finska Polytechnic education in Finnish 654 2018-08-07T14:00:27.490338+03:00 2 1356 {} [654] 0 1087 1 2                                                         1        
1369 [] Kuvataidekoulu Konstskola School of visual arts 360 2020-11-18T07:30:12.906446+02:00 2 1360 {} [360] 0 1087   7                                                   6     1        
1370 [] Musiikkiopisto Musikinstitut Music institute 456 2020-11-18T07:30:12.915030+02:00 2 1360 {} [456] 0 1087   20                                                   19     1        
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              
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                                            
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        
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        
2029 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:28.251638+03:00 2 868 {} [844] 0 1405 1 1                                                                  
2049 [2055, 2053, 2050, 2054] Suomen- ja vieraskielinen iltapäivätoiminta Eftermiddagsverksamhet på finska och främmande språk Afternoon activities in Finnish, English and other languages 656 2020-03-06T18:32:07.503687+02:00 2 2042 {} [656] 1 1087 184 184                                                                  
2080 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:27.666416+03:00 2 1378 {} [844] 0 1087 1 1                                                                  
2151 [] Liikunnan sähköinen asiointi ja lomakkeet Elektroniska tjänster och formulär för motion Electronic services and forms related to sports 849 2018-08-07T14:00:24.387923+03:00 2 551 {} [849] 0 1403   1                     1                                            
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                                                                  
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              
2161 [] Palliatiivinen hoito Palliativ vård Palliative care 858 2018-08-07T14:00:29.377630+03:00 2 1009 {} [858] 0 986 1 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              
2191 [] Hitas-asunnot Hitas-bostäder Hitas owner-occupied housing 877 2019-03-05T14:30:06.194077+02:00 2 2 {} [877] 0 1400 399 399                                                                  
2200 [] Englanninkielinen ammatillinen peruskoulutus Grundutbildning på engelska Basic education in English 883*872 2019-08-22T14:00:14.395819+03:00 2 2179 {} [883, 872] 1 1087   1                                                   1              
2212 [] Kansalaisopisto Medborgarinstitut Community college 890 2020-11-18T07:30:12.923359+02:00 2 1360 {} [890] 0 1087   3                                                   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
);