service_node

383 rows where level = 3 sorted by service_reference

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää

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ää
62 [63, 64, 65, 66, 67] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:21.368201+03:00 3 60 {} [] 0 1400 102 149                                           22       25              
68 [70, 69] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:21.413441+03:00 3 60 {} [] 0 1400 293 647                                           201       148     5        
149 [2209, 150, 152, 151, 154, 155] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:30.179684+03:00 3 146 {} [] 0 1401 292 375       1 1         1   1     2     2       40       31     4        
173 [2004, 2003, 2005] Hallinnon toimipisteet Förvaltningens verksamhetsställen Administrative offices   2018-08-07T14:00:30.377254+03:00 3 172 {} [] 0 1401 56 67                                   1       2       7     1        
209 [210, 211, 213] Varainhallinta Finansförvaltning Assets management   2018-08-07T14:00:30.654818+03:00 3 197 {} [] 0 1401 3 3                                                                  
226 [227, 228] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:22.025116+03:00 3 222 {} [] 0 1400 1 5                                           2       1     1        
233 [234, 235, 237] Hallinto Förvaltning Administration   2018-08-07T14:00:22.072503+03:00 3 231 {} [] 0 1400 3 6                                                   3              
245 [249, 248, 247, 250, 251] 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:22.143596+03:00 3 231 {} [] 0 1400 10 32                                           4       17     1        
255 [256, 257, 258, 265] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:22.202500+03:00 3 231 {} [] 0 1400 294 380       1 1         1   1     2     2       42       32     4        
272 [273, 274, 275] Energia Energi Energy   2018-08-07T14:00:22.327547+03:00 3 270 {} [] 0 1400 6 7                                                   1              
279 [281, 282, 283, 284, 285] Rakennusvalvonta Byggnadstillsyn Building Control   2018-08-07T14:00:22.376681+03:00 3 270 {} [] 0 1400 3 11                                           2       5     1        
287 [289, 290, 291, 292] Suunnittelu- ja rakentamispalvelut Planerings- och byggtjänster Design and construction services   2018-08-07T14:00:22.425144+03:00 3 270 {} [] 0 1400 5 7                                           1       1              
293 [295, 296, 299, 301] Vesihuolto Vattenförsörjning Water services   2018-08-07T14:00:22.465138+03:00 3 270 {} [] 0 1400 30 32                             1             1                      
302 [303] Yhdyskuntarakentaminen Samhällsbyggnad Civil engineering   2018-08-07T14:00:22.510499+03:00 3 270 {} [] 0 1400 1 1                                                                  
317 [2138, 2135, 2137, 2136] Kasvatuksen ja koulutuksen neuvonta Rådgivning om fostran och utbildning Day care and education information and advice   2018-08-07T14:00:24.723868+03:00 3 314 {} [] 0 1402 4 6                                           2                      
330 [331, 332] Langaton internet, wlan Trådlöst internet, wlan Wireless internet, wlan   2018-10-25T08:00:07.331877+03:00 3 329 {} [] 0 1402 233 240                                                   7              
333 [334, 339] Tietokone ja internet Dator och internet Computer and internet   2018-10-25T08:00:07.342286+03:00 3 329 {} [] 0 1402 63 67                                           1       3              
493 [494, 495, 496, 497, 498] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:22.700110+03:00 3 491 {} [] 0 1403 102 149                                           22       25              
499 [501, 500] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:22.748801+03:00 3 491 {} [] 0 1403 293 647                                           201       148     5        
542 [543, 544, 545, 2198, 546, 2144] Satamat ja laiturit Hamn och bryggor Harbours, piers and quays   2018-08-07T14:00:25.196186+03:00 3 541 {} [] 0 1402 168 209       2                 1         1       36             1        
547 [548, 2199, 549, 2143, 2142] Veneily Båtsport Boating   2018-08-07T14:00:25.237133+03:00 3 541 {} [] 0 1402 206 262 1     4                 2   1     2       45             1        
553 [554, 555, 556, 557] Hevosurheilu Hästsport Equestrian sports   2018-08-07T14:00:23.231236+03:00 3 552 {} [] 0 1403 19 64                                           31       14              
559 [560, 561, 562, 563] Ampumaurheilupaikat Sportskytteplatser Shooting sports facilities   2018-08-07T14:00:23.287538+03:00 3 558 {} [] 0 1403 6 10       1                                   3                      
564 [565] Hyppyrimäet Hoppbackar Ski jumping hills   2018-08-07T14:00:23.318569+03:00 3 558 {} [] 0 1403 1 1                                                                  
567 [568, 569] Katetut talviurheilupaikat Vintersportplatser under tak Covered winter sports facilities   2018-08-07T14:00:23.339639+03:00 3 558 {} [] 0 1403 2 2                                                                  
572 [573, 574] Kiipeilypaikat Klättringsplatser Climbing venues   2018-08-07T14:00:23.370651+03:00 3 558 {} [] 0 1403 5 14                                           6       3              
575 [576] Laskettelurinteet ja rinnehiihtokeskukset Slalombackar och alpina skidcentra Ski slopes and downhill ski resorts   2018-08-07T14:00:23.388106+03:00 3 558 {} [] 0 1403 2 6                                           2             2        
577 [579, 580, 581, 582, 583, 584, 585, 586, 590] Liikunta- ja ulkoilureitit Idrotts- och friluftsleder Sports and outdoor recreation routes   2018-08-07T14:00:23.400833+03:00 3 558 {} [] 0 1403 132 401       3                 1       1         105       147   9 3        
592 [593, 594, 595, 596] Maastohiihtokeskukset Längdåkningscentra Cross-country ski resorts   2018-08-07T14:00:23.496608+03:00 3 558 {} [] 0 1403 3 8       1                                   2       2              
597 [600] Suunnistusalueet Orienteringsområden Orienteering areas   2018-08-07T14:00:23.531981+03:00 3 558 {} [] 0 1403   1                                                   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        
606 [607] Keilahallit Bowlinghallar Bowling alleys   2018-08-07T14:00:23.590235+03:00 3 601 {} [] 0 1403 7 11                                           2       2              
608 [609, 610, 611, 612, 613] Kuntoilukeskukset ja liikuntasalit Konditionsidrottscentra och idrottssalar Fitness centres and sports halls   2018-08-07T14:00:23.602837+03:00 3 601 {} [] 0 1403 576 949                                           188       177     8        
614 [615, 616, 617, 618, 619, 620, 621, 622, 623] Liikuntahallit Idrottshallar Sports halls   2018-08-07T14:00:23.644666+03:00 3 601 {} [] 0 1403 149 233                                           60       22     2        
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        
634 [635, 636, 637, 638] Golfkentät Golfbanor Golf courses   2018-08-07T14:00:23.796742+03:00 3 633 {} [] 0 1403 18 50                                           23       9              
639 [641, 642, 643, 644, 645] Jääurheilualueet ja luonnonjäät Isidrottsområden och naturisar Ice sports areas and sites with natural ice   2018-08-07T14:00:23.829697+03:00 3 633 {} [] 0 1403 165 358                                           114       77     2        
646 [578, 647, 648, 649, 650, 651, 652, 653] Lähiliikunta ja liikuntapuistot Närmotion och idrottsparker Neighbourhood sports facilities and parks   2018-08-07T14:00:23.877348+03:00 3 633 {} [] 0 1403 345 650                               1           196       95   3 10        
654 [655, 656, 657, 658, 659, 660, 661, 662] Pallokentät Bollplaner Ball games courts   2018-08-07T14:00:23.947305+03:00 3 633 {} [] 0 1403 697 1266                         1                 283       273   1 11        
663 [664, 665] Yleisurheilukentät ja -paikat Planer och platser för friidrott Athletics fields and venues   2018-08-07T14:00:24.019648+03:00 3 633 {} [] 0 1403 36 59                                           20       3              
667 [668, 670, 672, 673, 674] Moottoriurheilualueet Områden för motorsport Motor sports areas   2018-08-07T14:00:24.047385+03:00 3 666 {} [] 0 1403 4 12                                           2       6              
675 [676] Urheiluilmailualueet Områden för flygsport Sport aviation areas   2018-08-07T14:00:24.102541+03:00 3 666 {} [] 0 1403 1 1                                                                  
677 [681, 682, 683] Veneurheilupaikat Platser för båtsport Boating sports facilities   2018-08-07T14:00:24.115410+03:00 3 666 {} [] 0 1403 4 5                                           1                      
685 [686, 687, 688, 689] Maauimalat ja uimarannat Utebassänger och badstränder Open air pools and beaches   2018-08-07T14:00:24.169221+03:00 3 684 {} [] 0 1403 43 98                         4                 39       8   4          
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        
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        
706 [710, 711, 712, 713, 714, 716] Virkistys- ja retkeilyalueet Rekreations- och friluftsområden Recreational and outdoor areas   2018-08-07T14:00:24.316869+03:00 3 694 {} [] 0 1403 11 38       1             1   2         3       18     1     1          
719 [721, 723, 724, 725, 730] Eläintarhat Djurparker Zoos   2018-08-07T14:00:24.415879+03:00 3 718 {} [] 0 1403 13 14                     1                                            
745 [746, 747] Museot Museer Museums   2018-08-07T14:00:24.555720+03:00 3 718 {} [] 0 1403 64 96           1                     4 1       13       8 1     4      
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        
763 [764, 765] Vaalit ja äänestäminen Val och röstning Elections and voting   2018-08-07T14:00:30.816923+03:00 3 756 {} [] 0 1401 2 4                                           1       1              
770 [771, 773, 774] Avioliitto ja rekisteröity parisuhde Äktenskap och registrering av partnerskap Marriage and registered partnership   2018-08-07T14:00:30.869982+03:00 3 769 {} [] 0 1401 1 2                                           1                      
1099 [1101, 1102, 2170, 1103, 1100, 1104] Luokkien 1-6 perusopetus Grundläggande utbildning, årskurserna 1-6 Basic education, grades 1-6   2018-10-25T08:00:07.589100+03:00 3 1098 {} [] 0 1087 110 212                                           62       39 1            
1109 [1111, 1112, 2171, 1113, 1110, 1114] Luokkien 7-9 perusopetus Grundläggande utbildning, årskurserna 7-9 Basic education, grades 7-9   2018-10-25T08:00:07.629842+03:00 3 1098 {} [] 0 1087 69 121                               1           27       23 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              
1188 [1189] Luokkien 1-6 perusopetus Grundläggande utbildning, årskurserna 1-6 Basic education, grades 1-6   2018-10-25T08:00:08.198860+03:00 3 1187 {} [] 0 1087 21 37                                           12       4              
1190 [1191] Luokkien 7-9 perusopetus Grundläggande utbildning, årskurserna 7-9 Basic education, grades 7-9   2018-10-25T08:00:08.207545+03:00 3 1187 {} [] 0 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                                                                  
1268 [1270, 1269] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:26.852029+03:00 3 1258 {} [] 0 1087 14 30                                           11       5              
1271 [1274, 1275, 1278, 1280, 1273, 1281, 1272, 1282, 1285, 1286, 1287, 1288, 1289, 1290, 1292, 1284, 1293, 1294] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:26.871621+03:00 3 1258 {} [] 0 1087 12 28                                           11       5              
1300 [1302, 1301] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:27.088539+03:00 3 1298 {} [] 0 1087 3 5                                           1       1              
1303 [1306, 1312, 1313, 1304, 1317, 1318, 1319, 1321, 1324, 1325, 1315, 1326] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:27.110966+03:00 3 1298 {} [] 0 1087 3 4                                                   1              
2007 [2008, 2009] Koiraurheilu Hundsport Dog sports   2018-08-07T14:00:23.263114+03:00 3 552 {} [] 0 1403 8 11                                                   3              
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        
2147 [2148, 318] Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta Rådgivning om social- och hälsovårdstjänster och för äldre Information and advice of social and health services and for elderly people   2018-08-07T14:00:24.757653+03:00 3 314 {} [] 0 1402 1 13                     1                     3       8              
2149 [2150] Tietotekniikkaneuvonta IT rådgivning IT consultancy   2018-08-07T14:00:24.972880+03:00 3 329 {} [] 0 1402   2                                           2                      
376 [] Biljardi Biljard Billiards 126 2018-08-07T14:00:22.918484+03:00 3 368 {} [126] 0 1403   16                                           13       3              
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} [127] 0 1400 2 4                                           1       1              
378 [] Bänditoiminta/-tila Bandverksamhet eller bandlokal Band activity or practice space 128 2018-08-07T14:00:22.924860+03:00 3 368 {} [128] 0 1403 2 12                                           5       5              
381 [] Demostudio Demostudio Demo studio 130 2018-08-07T14:00:22.931253+03:00 3 368 {} [130] 0 1403 1 2                                                   1              
775 [] Edunvalvonta Intressebevakning Trusteeship 131 2018-08-07T14:00:30.904881+03:00 3 769 {} [131] 0 1401 1 3                                           2                      
142 [] Elinkeinomarkkinointi Näringslivmarknadsföring Business marketing 133 2018-08-07T14:00:30.132324+03:00 3 141 {} [133] 0 1401 2 2                                                                  
105 [] Elintarvikevalvonta Livsmedelsbevakning Food control 137 2018-08-07T14:00:21.585963+03:00 3 103 {} [137] 0 1400 1 4                                 1         1       1              
353 [] Elokuvateatterit Biografteater Cinemas 138 2018-08-07T14:00:22.603098+03:00 3 352 {} [138] 0 1403 15 21                                           2       4              
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} [140] 0 1400 1 4                                 1         1       1              
107 [] Eläinsuojelu Djurskydd Animal protection 141 2018-08-07T14:00:21.598706+03:00 3 103 {} [141] 0 1400 1 4                                           1       2              
232 [] Energia-avustukset energiunderstöd energy grants 144 2018-08-07T14:00:22.065643+03:00 3 231 {} [144] 0 1400   1                                           1                      
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} [145] 0 1400   1                                                   1              
1260 [] Englanninkielinen lukiokoulutus gymnasieutbildning på engelska general upper secondary education in English 148 2018-10-25T08:00:08.503752+03:00 3 1258 {"fi": ["englanti"]} [148] 1 1087 3 5                                           1       1              
1296 [] Painotettu lukio Gymnasium med betoning Specialised upper secondary school 148*493+161*493+300*493+383*493+566*493+611*493+658*493+770*493+792*493 2018-10-25T08:00:08.739223+03:00 3 1258 {} [792, 770, 658, 611, 566, 493, 383, 300, 161, 148] 1 1087 12 17                                                   5              
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        
325 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:24.829787+03:00 3 324 {"fi": ["kirjastot"]} [155] 0 1402 27 29                                           2                      
346 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:22.558572+03:00 3 345 {"fi": ["kirjastot"]} [155] 0 1403 27 29                                           2                      
913 [919, 914] Espanjankielinen päivähoito Spanskspråkig dagvård Day care in Spanish 164 2018-08-07T14:00:28.527678+03:00 3 869 {} [164] 0 1405 2 2                                                                  
389 [] Fillari- ja moottoripaja Cykel- och motorverkstad Workshop for bicycles and mopeds 168 2018-08-07T14:00:22.937466+03:00 3 368 {} [168] 0 1403 4 5                                           1                      
391 [] Futsal Futsal Futsal 170 2018-08-07T14:00:22.944059+03:00 3 368 {} [170] 0 1403   1                                                   1              
217 [] Sisäinen tarkastus Intern revision Internal auditing 176 2018-08-07T14:00:30.706266+03:00 3 216 {} [176] 0 1401 1 2                                           1                      
218 [] Ulkoinen tarkastus Extern revision External auditing 177 2018-08-07T14:00:30.714388+03:00 3 216 {} [177] 0 1401   1                                           1                      
921 [922] Hepreankielinen päivähoito Hebreiskspråkig dagvård Day care in Hebrew 188 2018-08-07T14:00:28.572081+03:00 3 869 {} [188] 0 1405 1 1                                                                  
238 [] Hissiprojekti Anskaffning av hissar (gamla höghus) Lift procurement (old residential buildings) 195 2018-08-07T14:00:22.097017+03:00 3 231 {} [195] 0 1400 1 1                                                                  
736 [] Hotellit ja majoitus Hotell och logi Hotels and accommodation 197 2018-08-07T14:00:24.492255+03:00 3 718 {} [197] 0 1403 89 115         1               1   1     2       7       13   1          
224 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:22.012371+03:00 3 222 {} [201] 0 1400 2 4                                                   1     1        
315 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:24.709417+03:00 3 314 {} [201] 0 1402 2 4                                                   1     1        
395 [] Internet Internet Internet 202 2018-08-07T14:00:22.950721+03:00 3 368 {} [202] 0 1403 2 15                                           13                      
396 [] Jalkapallo Fotboll Football 203 2018-08-07T14:00:22.956950+03:00 3 368 {} [203] 0 1403   2                                                   2              
321 [] Johtotietopalvelu ja maanalaisten tilojen tietopalvelu Ledningstjänsten och information om underjordiska utrymmen Information service on cabling and underground facilities 207 2018-08-07T14:00:24.801557+03:00 3 320 {} [207] 0 1402 2 6                                           1       3              
515 [] Joukkoliikennepysäkit Kollektivtrafikens hållplatser Public transport stops 209 2018-08-07T14:00:25.015254+03:00 3 513 {} [209] 0 1402   3                                           1             2        
508 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.820471+03:00 3 505 {} [214] 0 1403 218 249       1 1         1   1           1       10       13     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
);