service_node

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

✎ View and edit SQL

This data as json, CSV (advanced)

unit_count_municipality_porvoo ✖

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ää
1324 [] B-ranska B-franska B-French 598*95 2018-08-07T14:00:27.267203+03:00 4 1303 {} [598, 95] 1 1087 3 4                                                   1              
1321 [] B-kiina B-kinesiska B-Chinese 598*92 2018-08-07T14:00:27.245446+03:00 4 1303 {} [598, 92] 1 1087 3 3                                                                  
1319 [] B-italia B-italienska B-Italian 598*90 2018-08-07T14:00:27.230479+03:00 4 1303 {} [598, 90] 1 1087 3 3                                                                  
1318 [] B-espanja B-spanska B-Spanish 598*89 2018-08-07T14:00:27.222850+03:00 4 1303 {} [598, 89] 1 1087 3 4                                                   1              
1317 [] B-englanti B-engelska B-English 598*88 2018-08-07T14:00:27.214095+03:00 4 1303 {} [598, 88] 1 1087 2 2                                                                  
1315 [] B-suomi B-finska B-Finnish 598*98 2018-08-07T14:00:27.199171+03:00 4 1303 {} [598, 98] 1 1087 2 2                                                                  
1313 [] A-saksa A-tyska A-German 598*12 2018-08-07T14:00:27.183391+03:00 4 1303 {} [598, 12] 1 1087 1 1                                                                  
1312 [] A-ranska A-franska A-French 598*10 2018-08-07T14:00:27.175551+03:00 4 1303 {} [598, 10] 1 1087 1 1                                                                  
1306 [] A-englanti A-engelska A-English 598*4 2018-08-07T14:00:27.131698+03:00 4 1303 {} [598, 4] 1 1087 2 3                                                   1              
1304 [] A-suomi A-finska A-Finnish 598*13 2018-08-07T14:00:27.116631+03:00 4 1303 {} [598, 13] 1 1087 3 4                                                   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              
1302 [] Erityistehtävän mukainen lukiokoulutus Gymnasieutbildning med särskild uppgift Upper secondary school education with special curriculum 598*157 2018-08-07T14:00:27.104000+03:00 4 1300 {} [598, 157] 1 1087 1 1                                                                  
1301 [] Yleislinjan lukiokoulutus Gymnasieutbildning, allmän linje Upper secondary school education, general programme 598*816 2018-08-07T14:00:27.095367+03:00 4 1300 {} [816, 598] 1 1087 2 4                                           1       1              
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              
1299 [] Ruotsinkielinen lukiokoulutus gymnasieutbildning på svenska general upper secondary education in Swedish 598 2018-08-07T14:00:27.081551+03:00 3 1298 {} [598] 1 1087 4 6                                           1       1              
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              
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              
1257 [1298, 1258] Lukiokoulutus Gymnasier General upper secondary education   2018-08-07T14:00:26.772637+03:00 1 1087 {} [] 0 1087 37 62                                           16       9              
1255 [] Sairaalaopetus Sjukhusundervisning Hospital education 609 2018-08-07T14:00:26.759479+03:00 2 1097 {} [609] 1 1087 3 5                                           2                      
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                                                                  
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              
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                      
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              
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                      
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                                                                  
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                                                                  
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                                                                  
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              
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              
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              
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              
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                      
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                      
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              
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                      
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              
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            
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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            
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              
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              
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    
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        
1084 [] Yhteiskalliosuojat Gemensamma bergskyddsrum Shared ground shelters 808 2018-08-07T14:00:29.944094+03:00 2 1083 {} [808] 0 1061 29 29                                                                  
1083 [1084, 1086] Väestönsuojat Befolkningsskyddsrum Public shelters   2018-08-07T14:00:29.937480+03:00 1 1061 {} [] 0 1061 47 49                                                         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                                                                  
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              
1080 [1081] Tulli Tullen Customs   2018-08-07T14:00:29.915254+03:00 1 1061 {} [] 0 1061 4 7                                           1       2              
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                                                                  
1078 [] Rajavartiolaitos Gränsbevakningsväsendet Border guard 557 2018-08-07T14:00:29.900790+03:00 1 1061 {} [557] 0 1061 1 1                                                                  
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              
1076 [1077] Poliisi Polisen Police   2018-08-07T14:00:29.888769+03:00 1 1061 {} [] 0 1061 1 6                                           1       4              
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        
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                                                                  
1072 [] Pelastusasemat Räddningsstationerna Rescue Stations 501 2018-08-07T14:00:29.858704+03:00 2 1070 {} [501] 0 1061 9 21                                           6       6              
1071 [] Nuohous Sotning Chimney sweeping 467 2018-08-07T14:00:29.851905+03:00 2 1070 {} [467] 0 1061   1                                           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        
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                      
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              
1067 [] Turvallisuuskoulutus Säkerhetsutbildning Safety training 720 2018-08-07T14:00:29.819172+03:00 2 1066 {} [720] 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              
1065 [] Meripelastus Sjöräddningen Sea rescue 435 2018-08-07T14:00:29.800283+03:00 1 1061 {} [435] 0 1061 1 1                                                                  
1064 [] Puolustusvoimat Försvarsmakten The Finnish Defence Forces 529 2018-08-07T14:00:29.789161+03:00 2 1062 {} [529] 0 1061 6 7                                           1                      
1063 [] Maanpuolustusyhdistykset Försvarsföreningar National defence associations 422 2018-08-07T14:00:29.780736+03:00 2 1062 {} [422] 0 1061 2 2                                                                  
1062 [1063, 1064] Maanpuolustus Försvaret National defence   2018-08-07T14:00:29.774255+03:00 1 1061 {} [] 0 1061 8 9                                           1                      
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        
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              
1059 [] Selviämishoitoasema Tillnyktringsstation Detoxification centre 618 2018-08-07T14:00:29.743322+03:00 2 1051 {} [618] 0 986 1 2                                           1                      
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              
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              
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              
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              
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              
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        
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} [520] 0 986   1                                                   1              
1044 [] Silmätaudit Ögonsjukdomar Eye diseases 622 2018-08-07T14:00:29.630771+03:00 1 986 {} [622] 0 986 1 2                                                   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        
1042 [] Kuulontutkimus Hörseltester Hearing tests 357 2018-08-07T14:00:29.607627+03:00 1 986 {} [357] 0 986   1                                                   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        
1039 [] Ravitsemusterapia Näringsterapi Nutrition therapy 579 2018-08-07T14:00:29.591225+03:00 1 986 {} [579] 0 986   1                                                   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              
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        
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} [462] 0 986   6                                                   6              
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        
1033 [] Kuntoutussuunnittelu ja -ohjaus Rehabiliteringsplanering och -handledning Rehabilitation planning and guidance 355 2018-08-07T14:00:29.523750+03:00 2 1028 {} [355] 0 986   4                                           1       1     2        
1032 [] Kuntoutuksen vuodeosastopalvelut Vårdavdelningstjänster inom rehabilitering Rehabilitation inpatient care 353 2018-08-07T14:00:29.514187+03:00 2 1028 {} [353] 0 986   3                                           2       1              
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        

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