service_node

160 rows where unit_count_municipality_kauniainen = 1 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, keywords, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vantaa, unit_count_municipality_kerava

unit_count_municipality_vihti ✖

unit_count_municipality_kauniainen ✖

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ää
2225 [] Senioritanssi Seniordans Senior dancing 900 2020-06-09T15:30:11.415952+03:00 3 2217 {} [900] 0 1403 24 29                                           2       2     1        
2221 [] Senioriliikunta Seniormotion Senior sports 895 2020-06-09T15:30:11.355674+03:00 3 2217 {} [895] 0 1403 86 102                     1                     4       10     1        
2220 [] Seniorikävely Seniorgående Senior walk 901 2020-06-09T15:30:11.341704+03:00 3 2217 {} [901] 0 1403 6 7                                                         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        
2196 [] Korkeakoulujen kirjastot Högskolebibliotek Polytechnic libraries 880 2019-04-02T13:30:07.763547+03:00 3 345 {} [880] 0 1403 8 14                                           3       2     1        
2193 [] Korkeakoulujen kirjastot Högskolebibliotek Polytechnic libraries 880 2019-03-20T13:30:07.442599+02:00 3 324 {} [880] 0 1402 8 14                                           3       2     1        
2145 [964, 963, 972] Ryhmäperhepäivähoito Gruppfamiljedagvård Group family day care   2018-08-07T14:00:28.879106+03:00 3 961 {} [] 0 1405 57 118                                           51       9     1        
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} [769] 0 1402 147 188       2                 1         1       36             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        
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        
2005 [] Valtuustotalot Fullmäktigehus Council buildings 744 2018-08-07T14:00:30.401425+03:00 4 173 {} [744] 0 1401   2                                           1             1        
2004 [] Hallinnolliset toimipisteet Administrativa ämbetsverk Administrative offices 271 2018-08-07T14:00:30.391457+03:00 4 173 {} [271] 0 1401 55 65                                   1       1       7     1        
2003 [] Kaupungintalot Stadshus City halls 270 2018-08-07T14:00:30.383310+03:00 4 173 {} [270] 0 1401 1 3                                                   1     1        
1376 [] Koulu- ja opiskelijaruokailu Måltider för elever och studerande Meals for pupils and students 338 2020-08-20T14:00:09.319013+03:00 1 1087 {} [338] 0 1087 119 136                                           12       4     1        
1370 [] Musiikkiopisto Musikinstitut Music institute 456 2020-11-18T07:30:12.915030+02:00 2 1360 {} [456] 0 1087   20                                                   19     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        
1367 [] Opetuspaikat Verksamhetsställen Teaching locations 605*727 2020-11-18T07:30:12.891173+02:00 3 1365 {} [727, 605] 0 1087 2 3                                                         1        
1366 [] Asiakaspalvelu Kundtjänst Customer services 605*66 2020-11-18T07:30:12.883321+02:00 3 1365 {} [605, 66] 0 1087 2 3                                                         1        
1363 [] Opetuspaikat Verksamhetsställen Teaching locations 665*727 2020-11-18T07:30:12.858775+02:00 3 1361 {} [727, 665] 0 1087 44 46                                           1             1        
1362 [] Asiakaspalvelu Kundtjänst Customer services 665*66 2020-11-18T07:30:12.851359+02:00 3 1361 {} [665, 66] 0 1087 7 9                                           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        
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} [654] 0 1087 1 2                                                         1        
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} [] 0 1087 5 11                                           2       3     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        
1070 [1071, 1072, 1073, 1074, 1075] Pelastustoimi Räddningsväsendet Rescue services   2018-08-07T14:00:29.845529+03:00 1 1061 {} [] 0 1061 26 46                                           13       6     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        
1052 [] Päihdehuollon sosiaalityö Socialt arbete inom missbrukarvården Care for substance abuse, social work 549 2018-08-07T14:00:29.687959+03:00 2 1051 {} [549] 0 986 1 4                                           1       1     1        
1051 [1057, 1058, 1055, 1054, 1056, 1053, 1052, 1059, 2158] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:29.682313+03:00 1 986 {} [] 0 986 29 56                                           12       14     1        
1041 [] Psykologitoiminta Psykologverksamhet Psychologists 525 2018-08-07T14:00:29.598972+03:00 1 986 {} [525] 0 986 4 10                                           1       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        
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        
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        
1034 [] Lääkinnällinen kuntoutus Medicinsk rehabilitering Medical rehabilitation 416 2018-08-07T14:00:29.531662+03:00 2 1028 {} [416] 0 986 1 5                                           2       1     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        
1029 [] Apuvälinepalvelut Hjälpmedelstjänster Aid services 352 2018-08-07T14:00:29.484194+03:00 2 1028 {} [352] 0 986 5 10                                           1       3     1        
1006 [] Perhesuunnittelu ja ehkäisyneuvola Familjeplanerings- och preventivmedelsrådgivning Family planning and contraception clinic 507 2018-08-07T14:00:29.286660+03:00 2 1004 {} [507] 0 986   5                                           4             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        
1004 [1005, 1006, 1008] Neuvolat Rådgivningar Maternity and child health guidance 463 2018-08-07T14:00:29.268764+03:00 1 986 {} [463] 0 986 23 53                                           19       10     1        
1002 [] Lasten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för barn Health centre on-call service and emergency outpatient clinic for children 378 2018-10-25T08:00:09.598902+03:00 2 1000 {} [378] 0 986   3                                           1       1     1        
1001 [] Aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för vuxna Health centre on-call service and emergency outpatient clinic for adults 43 2018-08-07T14:00:29.242685+03:00 2 1000 {"fi": ["p\u00e4ivystys"]} [43] 0 986   3                                           1       1     1        
1000 [1001, 1002, 1003] Päivystys Jour Emergency services   2018-08-07T14:00:29.234256+03:00 1 986 {} [] 0 986   6                                           4       1     1        
995 [] Hammashoito Tandvård Dental care 184 2020-03-06T18:32:09.101816+02:00 1 986 {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} [184] 0 986 36 98                                           20       41     1        
993 [] Terveydenhoitajan vastaanotto Hälsovårdarens mottagning Nurse's reception 702 2018-08-07T14:00:29.169309+03:00 1 986 {} [702] 0 986 26 50                                           11       12     1        
992 [] Lääkärin vastaanotto Läkarmottagning Doctor's reception 417 2018-08-07T14:00:29.162295+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} [417] 0 986 26 50                                           11       12     1        
991 [] Terveysasemat Hälsostationer Health stations 703 2018-08-07T14:00:29.153043+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} [703] 0 986 25 49                                           12       11     1        
978 [] Kerhotoiminta Klubbverksamhet Club activities 288 2019-03-05T14:30:09.661194+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [288] 0 1405 94 143                                           20       28     1        
976 [] Avoin toiminta Öppen verksamhet Open family activities 86 2019-03-05T14:30:09.650822+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [86] 0 1405 2 31                                           13       15     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        
963 [] Suomenkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på finska Group family day care in Finnish 664 2018-10-25T08:00:09.441773+03:00 4 2145 {"fi": ["suomi"]} [664] 0 1405 50 107                                           47       9     1        
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        
906 [] päivähoito dagvård day care 151 2018-08-07T14:00:28.486872+03:00 4 905 {} [151] 0 1405 39 62                                           21       1     1        
905 [911, 906] Englanninkielinen päivähoito Engelskspråkig dagvård Day care in English 151 2018-08-07T14:00:28.480764+03:00 3 869 {} [151] 0 1405 39 62                                           21       1     1        
883 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 603*200 2018-08-07T14:00:28.354237+03:00 4 881 {} [603, 200] 0 1405 2 3                                                         1        
872 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 663*200 2018-08-07T14:00:28.278055+03:00 4 870 {} [663, 200] 0 1405 6 14                                           3       4     1        
859 [] Yhteiset tukipalvelut Gemensamma stödtjänster Shared support services 639 2018-08-07T14:00:28.209104+03:00 1 783 {} [639] 0 783   3                                                   2     1        
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        
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        
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        
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        
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    
839 [2011, 841, 843, 2012] Toimeentulotuki Utkomststöd Social assistance   2018-08-07T14:00:28.080690+03:00 1 783 {} [] 0 783 11 20       1                                   3       3     1   1    
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        
831 [] Päihdehuollon sosiaalityö Socialt arbete inom missbrukarvården Care for substance abuse, social work 549 2018-08-07T14:00:28.021758+03:00 2 830 {} [549] 0 783 1 4                                           1       1     1        
830 [836, 837, 834, 833, 835, 832, 831, 838, 2157] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:28.016024+03:00 1 783 {} [] 0 783 29 56                                           12       14     1        
827 [] Vanhuspalvelun omaishoidon tuki Stöd för närståendevårdare inom äldreomsorgen Care for the elderly, close relative care support 759 2018-08-07T14:00:27.996868+03:00 2 819 {} [759] 0 783 4 8                                           1       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        
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        
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        
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    
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        
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        
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    
798 [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] Vammaispalvelut Handikapptjänster Services for the disabled   2018-08-07T14:00:27.804536+03:00 1 783 {} [] 0 783 14 59       2                                   7       34     1   1    
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        
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        
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        
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        
787 [789, 790, 788] Lastensuojelu Barnskydd Child welfare   2018-10-25T08:00:09.006369+03:00 1 783 {} [] 0 783 37 81                               1           17       24 1   1        
760 [] Kaupunginvaltuusto Stadsfullmäktige City Council 273 2018-08-07T14:00:30.790348+03:00 4 757 {} [273] 0 1401 2 5                                           1       1     1        
758 [] Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät stadsstyrelsens och stadsförvaltningens beredningsuppgifter preparatory assignments for City Government and City Council 274 2018-08-07T14:00:30.769165+03:00 4 757 {} [274] 0 1401 1 2                                                         1        
757 [758, 759, 760, 761, 762] Päätöksenteko Beslutsfattande Decision-making   2018-08-07T14:00:30.759776+03:00 3 756 {} [] 0 1401 6 10                                           2       1     1        
756 [757, 763] Demokratia Demokrati Democracy   2018-08-07T14:00:30.749902+03:00 2 755 {} [] 0 1401 8 13                                           3       1     1        
755 [756, 768, 769] Oikeusturva ja demokratia Rättsskydd och demokrati Justice system and democracy   2020-03-06T18:32:09.608464+02:00 1 1401 {} [] 0 1401 15 46                                           28       2     1        
705 [] Venesatama Serviceplats för båtfarare Boating services 769 2018-08-07T14:00:24.310541+03:00 4 695 {} [769] 0 1403 147 188       2                 1         1       36             1        
695 [696, 697, 698, 699, 700, 701, 702, 703, 704, 705] Retkeilyn palvelut Utflyktstjänster Hiking facilities   2018-08-07T14:00:24.236641+03:00 3 694 {} [] 0 1403 224 404       10                 11         8       125       7   18 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        
693 [] Uimahalli Simhall Public indoor swimming pool 729 2018-08-07T14:00:24.224255+03:00 4 690 {} [729] 0 1403 14 25                                           5       5     1        
690 [691, 692, 693] Uima-altaat, hallit ja kylpylät Simbassänger, hallar och badinrättningar Indoor swimming pools, halls and spas   2018-08-07T14:00:24.204334+03:00 3 684 {} [] 0 1403 35 55                                           12       7     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        
656 [] Jalkapallostadion Fotbollsstadion Football stadium 205 2018-08-07T14:00:23.964244+03:00 4 654 {} [205] 0 1403 1 4                                           1       1     1        
655 [] Beachvolleykenttä Beachvolleyplan Beach volleyball court 125 2018-08-07T14:00:23.954884+03:00 4 654 {} [125] 0 1403 39 85                                           27       18     1        
652 [] Skeitti / rullaluistelupaikka Plats för skejtning/rullskridskoåkning Skateboarding/roller-blading rink 630 2018-08-07T14:00:23.929996+03:00 4 646 {} [630] 0 1403 27 51                                           11       12     1        
632 [] Yksittäinen yleisurheilun suorituspaikka Enstaka övningsplats för friidrott Stand-alone athletics venue 810 2018-08-07T14:00:23.783286+03:00 4 624 {} [810] 0 1403 9 22                                                   12     1        
624 [625, 626, 627, 628, 629, 630, 631, 632] Yksittäiset lajikohtaiset sisäliikuntapaikat Enstaka grenspecifika anläggningar för inomhusidrott Indoor venues for various sports   2018-08-07T14:00:23.722887+03:00 3 601 {} [] 0 1403 118 186                                           43       24     1        
616 [] Liikuntahalli Idrottshall Sports hall 400 2018-08-07T14:00:23.657783+03:00 4 614 {} [400] 0 1403 24 38                                           7       6     1        
615 [] Jalkapallohalli Fotbollshall Football hall 204 2018-08-07T14:00:23.650553+03:00 4 614 {} [204] 0 1403 8 18                                           6       3     1        
610 [] Kuntokeskus Konditionsidrottscentrum Fitness centre 625 2018-08-07T14:00:23.616327+03:00 4 608 {} [625] 0 1403 48 97                                           28       20     1        
604 [] Kilpajäähalli Tävlingsishall Competition ice arena 308 2018-08-07T14:00:23.575267+03:00 4 602 {} [308] 0 1403 2 7                                           2       2     1        
602 [603, 604] Jäähallit Ishallar Ice-skating arenas   2018-08-07T14:00:23.562977+03:00 3 601 {} [] 0 1403 12 24                                           7       4     1        
584 [] Luontopolku Naturstig Nature trail 413 2018-08-07T14:00:23.440979+03:00 4 577 {} [413] 0 1403 12 41       1                 1                 24       1   1 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
);