service_node

939 rows where "last_modified_time" is on date 2018-08-07 sorted by root

✎ View and edit SQL

This data as json, CSV (advanced)

unit_count_municipality_vihti ✖

last_modified_time (date) ✖

  • 2018-08-07 · 839 ✖
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ää
1017 [] Laboratorio Laboratorium Laboratory 366 2018-08-07T14:00:29.386729+03:00 1 986 {} [366] 0 986 22 88   3 1 1   3   1 1       1 1 2 6 3 3 1 7 1 10 1 3 1 8 1 1 2 1 1 1 1
1018 [] Röntgen Röntgen X-rays 606 2018-08-07T14:00:29.396972+03:00 1 986 {} [606] 0 986 11 42 1 1   1   1                 2 1 1 1 1 1 1 6   1 1 6 1 1   1 1 1  
1019 [1020, 1021, 1022, 1023, 1024, 1025, 1026, 1027] Mielenterveyspalvelut Psykiatriska tjänster Mental health care   2018-08-07T14:00:29.405061+03:00 1 986 {} [] 0 986 29 36                                           2       5              
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                                                                  
1022 [] Kuntoutuspsykiatria Rehabiliteringspsykiatri Rehabilitation psychiatry 354 2018-08-07T14:00:29.429019+03:00 2 1019 {} [354] 0 986 2 3                                           1                      
1023 [] Psykiatrian poliklinikat Psykiatriska polikliniker Psychiatric outpatient clinics 521 2018-08-07T14:00:29.437165+03:00 2 1019 {} [521] 0 986 19 19                                                                  
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              
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                                                                  
1028 [1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038] Kuntoutus Rehabilitering Rehabilitation   2018-08-07T14:00:29.478107+03:00 1 986 {} [] 0 986 33 67                                           16       16     2        
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        
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        
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              
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        
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        
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} [462] 0 986   6                                                   6              
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        
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        
1038 [] Toimintaterapia Ergoterapi Occupational therapy 712 2018-08-07T14:00:29.573439+03:00 2 1028 {"fi": ["kuntoutus"]} [712] 0 986 9 13                                           1       3              
1039 [] Ravitsemusterapia Näringsterapi Nutrition therapy 579 2018-08-07T14:00:29.591225+03:00 1 986 {} [579] 0 986   1                                                   1              
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} [206] 0 986 7 10                                                   2     1        
1041 [] Psykologitoiminta Psykologverksamhet Psychologists 525 2018-08-07T14:00:29.598972+03:00 1 986 {} [525] 0 986 4 10                                           1       4     1        
1042 [] Kuulontutkimus Hörseltester Hearing tests 357 2018-08-07T14:00:29.607627+03:00 1 986 {} [357] 0 986   1                                                   1              
1043 [] Omahoitotarvikejakelu Utdelning av egenvårdsartiklar Distribution of self-care supplies 477 2018-08-07T14:00:29.623935+03:00 1 986 {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} [477] 0 986 1 6                                                   3     2        
1044 [] Silmätaudit Ögonsjukdomar Eye diseases 622 2018-08-07T14:00:29.630771+03:00 1 986 {} [622] 0 986 1 2                                                   1              
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} [520] 0 986   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        
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        
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        
1054 [] Päihdehuollon polikliininen hoito Poliklinisk vård inom missbrukarvården Care for substance abuse, outpatient treatment 546 2018-08-07T14:00:29.702337+03:00 2 1051 {} [546] 0 986 12 17                                           3       2              
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              
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              
1058 [] Päihdehuollon katkaisuhoito ja kuntoutus Akutvård och rehabilitering inom missbrukarvården Care for substance abuse, detoxification and rehabilitation treatment 544 2018-08-07T14:00:29.732968+03:00 2 1051 {} [544] 0 986 6 9                                           1       2              
1059 [] Selviämishoitoasema Tillnyktringsstation Detoxification centre 618 2018-08-07T14:00:29.743322+03:00 2 1051 {} [618] 0 986 1 2                                           1                      
1060 [] Terveyspalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter inom hälso- och sjukvården Electronic services and forms related to health services 704 2018-08-07T14:00:29.759443+03:00 1 986 {} [704] 0 986   2                     1                             1              
2146 [] Ikääntyvien neuvonta Rådgivning för åldringar Information and advice for elderly people 199 2018-08-07T14:00:29.136711+03:00 2 988 {} [199] 0 986   4                                           2       2              
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                                                                  
2161 [] Palliatiivinen hoito Palliativ vård Palliative care 858 2018-08-07T14:00:29.377630+03:00 2 1009 {} [858] 0 986 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        
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        
1061 [1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083] Turvallisuus Säkerhet Public safety   2018-08-07T14:00:29.767356+03:00 0   {} [] 0 1061 130 163                                           17       13     3        
1062 [1063, 1064] Maanpuolustus Försvaret National defence   2018-08-07T14:00:29.774255+03:00 1 1061 {} [] 0 1061 8 9                                           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                                                                  
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                      
1065 [] Meripelastus Sjöräddningen Sea rescue 435 2018-08-07T14:00:29.800283+03:00 1 1061 {} [435] 0 1061 1 1                                                                  
1066 [1069, 1068, 1067] Muut turvallisuuspalvelut Andra säkerhetstjänster Other safety services   2018-08-07T14:00:29.808816+03:00 1 1061 {} [] 0 1061 3 5                                           1       1              
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              
1069 [] Muut turvapalvelut (kiinteistöt ja vartiointi) Övrig säkerhetsservice (fastigheter och bevakning) Other security services (real estate and guarding) 460 2018-08-07T14:00:29.836971+03:00 2 1066 {} [460] 0 1061 1 2                                           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        
1071 [] Nuohous Sotning Chimney sweeping 467 2018-08-07T14:00:29.851905+03:00 2 1070 {} [467] 0 1061   1                                           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              
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                                                                  
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        
1076 [1077] Poliisi Polisen Police   2018-08-07T14:00:29.888769+03:00 1 1061 {} [] 0 1061 1 6                                           1       4              
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              
1078 [] Rajavartiolaitos Gränsbevakningsväsendet Border guard 557 2018-08-07T14:00:29.900790+03:00 1 1061 {} [557] 0 1061 1 1                                                                  
1079 [] Säteilyturva Strålsäkerhet Radiation and nuclear safety 671 2018-08-07T14:00:29.907687+03:00 1 1061 {} [671] 0 1061 1 1                                                                  
1080 [1081] Tulli Tullen Customs   2018-08-07T14:00:29.915254+03:00 1 1061 {} [] 0 1061 4 7                                           1       2              
1081 [] Tullin asiointipisteet Tullens verksamhetsställen Customs offices 716 2018-08-07T14:00:29.921102+03:00 2 1080 {} [716] 0 1061 4 7                                           1       2              
1082 [] Väestöhälyttimet Befolkningslarm Public alarm systems 805 2018-08-07T14:00:29.929327+03:00 1 1061 {} [805] 0 1061 38 38                                                                  
1083 [1084, 1086] Väestönsuojat Befolkningsskyddsrum Public shelters   2018-08-07T14:00:29.937480+03:00 1 1061 {} [] 0 1061 47 49                                                         2        
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        
1087 [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] Opetus ja koulutus Undervisning och utbildning Teaching and education   2018-08-07T14:00:25.275863+03:00 0   {} [] 0 1087 1214 1867       1                       2           274       362 2   11   1    
1088 [1093, 1089] Esiopetus Förskola Pre-primary education   2018-08-07T14:00:25.281111+03:00 1 1087 {} [] 0 1087 320 530                                           89       121              
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              
1097 [1187, 1255, 1098] Perusopetus Grundläggande utbildning Basic education   2018-08-07T14:00:25.451107+03:00 1 1087 {} [] 0 1087 414 568                               1           97       55 1            
1102 [] ranskankielinen opetus undervisning på franska education in French 567 2018-08-07T14:00:25.502701+03:00 4 1099 {} [567] 1 1087 1 1                                                                  
1103 [] saksankielinen opetus undervisning på tyska education in German 612 2018-08-07T14:00:25.517491+03:00 4 1099 {} [612] 1 1087 1 1                                                                  
1104 [] venäjänkielinen opetus undervisning på ryska education in Russian 771 2018-08-07T14:00:25.524519+03:00 4 1099 {} [771] 1 1087 1 1                                                                  
1112 [] ranskankielinen opetus undervisning på franska education in French 568 2018-08-07T14:00:25.599261+03:00 4 1109 {} [568] 1 1087 1 1                                                                  
1113 [] saksankielinen opetus undervisning på tyska education in German 613 2018-08-07T14:00:25.613385+03:00 4 1109 {} [613] 1 1087 1 1                                                                  
1114 [] venäjänkielinen opetus undervisning på ryska education in Russian 772 2018-08-07T14:00:25.622338+03:00 4 1109 {} [772] 1 1087 1 1                                                                  
1120 [1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:25.674488+03:00 3 1098 {} [] 0 1087 109 213                               1           73       29 1            
1169 [1170, 1171, 1172] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.110528+03:00 3 1098 {} [] 0 1087 40 44                                                   4              
1173 [] Erityisluokkaopetus Undervisning i specialklass Special class education 660 2018-08-07T14:00:26.138862+03:00 3 1098 {} [660] 1 1087 4 10                               1           5                      
1174 [] Ruotsin kielikylpyopetus Språkbadsundervisning på svenska Language immersion education in Swedish 295 2018-08-07T14:00:26.145715+03:00 3 1098 {} [295] 1 1087 13 18                                           4       1              
1177 [] Kansainvälinen opetus (IB) Internationell undervisning (IB) International education (IB) 510 2018-08-07T14:00:26.169911+03:00 3 1098 {} [510] 1 1087 4 6                                           2                      
1181 [1186, 1183, 1182, 2134, 1184] Iltapäivätoiminta Eftermiddagsverksamhet Afternoon activities 656 2018-08-07T14:00:26.201113+03:00 3 1098 {} [656] 1 1087 238 240                                           2                      
1182 [] Koulun järjestämät ryhmät Skolornas grupper Groups organised by schools 656*342 2018-08-07T14:00:26.208350+03:00 4 1181 {} [656, 342] 1 1087 28 28                                                                  
1183 [] Järjestöjen ja yhdistysten ryhmät Organisationernas och föreningarnas grupper Groups organised by organisations or associations 656*229 2018-08-07T14:00:26.230412+03:00 4 1181 {} [656, 229] 1 1087 105 105                                                                  
1184 [] Seurakuntien ryhmät Församlingarnas grupper Groups organised by parishes 656*620 2018-08-07T14:00:26.237285+03:00 4 1181 {} [656, 620] 1 1087 18 18                                                                  
1186 [] Autististen ja kehitysvammaisten ryhmät Grupper för autistiska och utvecklingsstörda Groups for autistic and intellectually disabled 656*80 2018-08-07T14:00:26.244278+03:00 4 1181 {} [656, 80] 1 1087 33 33                                                                  
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              
1189 [] ruotsinkielinen opetus undervisning på svenska education in Swedish 601 2018-08-07T14:00:26.265483+03:00 4 1188 {} [601] 1 1087 21 37                                           12       4              
1191 [] ruotsinkielinen opetus undervisning på svenska education in Swedish 602 2018-08-07T14:00:26.281144+03:00 4 1190 {} [602] 1 1087 7 12                                           4       1              
1193 [1194, 1208, 1214, 1215, 1218, 1232, 1233, 1236, 1237, 1238, 1239, 1240] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:26.296242+03:00 3 1187 {} [] 0 1087 21 26                                                   5              
1242 [1244, 1245] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.661731+03:00 3 1187 {} [] 0 1087 1 1                                                                  
1244 [] 3. luokalta alkava soveltuvuuskoepainotus lämplighetstestbetoning från årskurs 3 special emphasis starting from 3rd grade 601*2 2018-08-07T14:00:26.674416+03:00 4 1242 {} [601, 2] 1 1087 1 1                                                                  
1245 [] 7. luokalta alkava soveltuvuuskoepainotus lämplighetstestbetoning från årskurs 7 special emphasis starting from 7th grade 602*3 2018-08-07T14:00:26.681590+03:00 4 1242 {} [602, 3] 1 1087 1 1                                                                  
1246 [] Erityisluokkaopetus Undervisning i specialklass Special class education 600 2018-08-07T14:00:26.688791+03:00 3 1187 {} [600] 1 1087 2 3                                           1                      
1249 [1251, 1250, 1252] Iltapäivätoiminta Eftermiddagsverksamhet Afternoon activities 596 2018-08-07T14:00:26.711531+03:00 3 1187 {} [596] 1 1087 24 39                                           11       4              
1250 [] Koulun järjestämät ryhmät Skolornas grupper Groups organised by schools 596*342 2018-08-07T14:00:26.719650+03:00 4 1249 {} [596, 342] 1 1087 4 15                                           11                      
1251 [] Järjestöjen ja yhdistysten ryhmät Organisationernas och föreningarnas grupper Groups organised by organisations or associations 596*229 2018-08-07T14:00:26.727399+03:00 4 1249 {} [596, 229] 1 1087 18 22                                                   4              
1252 [] Seurakuntien ryhmät Församlingarnas grupper Groups organised by parishes 596*620 2018-08-07T14:00:26.734846+03:00 4 1249 {} [620, 596] 1 1087 2 2                                                                  
1255 [] Sairaalaopetus Sjukhusundervisning Hospital education 609 2018-08-07T14:00:26.759479+03:00 2 1097 {} [609] 1 1087 3 5                                           2                      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [service_node] (
   [id] INTEGER PRIMARY KEY,
   [children] TEXT,
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [service_reference] TEXT,
   [last_modified_time] TEXT,
   [level] INTEGER,
   [parent] INTEGER,
   [keywords] TEXT,
   [related_services] TEXT,
   [period_enabled] INTEGER,
   [root] INTEGER,
   [unit_count_municipality_helsinki] INTEGER,
   [unit_count_total] INTEGER,
   [unit_count_municipality_hanko] TEXT,
   [unit_count_municipality_raasepori] TEXT,
   [unit_count_municipality_siuntio] TEXT,
   [unit_count_municipality_sipoo] TEXT,
   [unit_count_municipality_janakkala] TEXT,
   [unit_count_municipality_nurmijärvi] TEXT,
   [unit_count_municipality_salo] TEXT,
   [unit_count_municipality_virolahti] TEXT,
   [unit_count_municipality_pornainen] TEXT,
   [unit_count_municipality_hämeenlinna] TEXT,
   [unit_count_municipality__unknown] TEXT,
   [unit_count_municipality_lapinjärvi] TEXT,
   [unit_count_municipality_inkoo] TEXT,
   [unit_count_municipality_miehikkälä] TEXT,
   [unit_count_municipality_porvoo] TEXT,
   [unit_count_municipality_lohja] INTEGER,
   [unit_count_municipality_tuusula] TEXT,
   [unit_count_municipality_kirkkonummi] TEXT,
   [unit_count_municipality_hamina] TEXT,
   [unit_count_municipality_kouvola] TEXT,
   [unit_count_municipality_loviisa] TEXT,
   [unit_count_municipality_espoo] INTEGER,
   [unit_count_municipality_askola] TEXT,
   [unit_count_municipality_kotka] TEXT,
   [unit_count_municipality_mäntsälä] TEXT,
   [unit_count_municipality_vantaa] INTEGER,
   [unit_count_municipality_hyvinkää] INTEGER,
   [unit_count_municipality_vihti] TEXT,
   [unit_count_municipality_kauniainen] TEXT,
   [unit_count_municipality_järvenpää] TEXT,
   [unit_count_municipality_kerava] TEXT,
   [unit_count_municipality_karkkila] TEXT,
   [unit_count_municipality_pyhtää] TEXT
);