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)

last_modified_time (date) ✖

  • 2018-08-07 · 893 ✖
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ää
2050 [] Koulun järjestämät ryhmät Skolornas grupper Groups organised by schools 656*342 2018-08-07T14:00:25.355697+03:00 3 2049 {} [656, 342] 1 1087 28 28                                                                  
2042 [2056, 2049] Aamu- ja iltapäivätoiminta Morgon- och eftermiddagsverksamhet Morning and afternoon activities   2018-08-07T14:00:25.343707+03:00 1 1087 {} [] 0 1087 208 223                                           11       4              
2040 [] Kirjastoautopalvelut Bokbussar Mobile libraries 312 2018-08-07T14:00:24.837192+03:00 3 324 {} [312] 0 1402 1 3                                           1       1              
2029 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:28.251638+03:00 2 868 {} [844] 0 1405 1 1                                                                  
2028 [] Tapahtumien järjestäminen Anordnande av evenemang Organising events 845 2018-08-07T14:00:24.640373+03:00 2 717 {} [845] 0 1403 2 6                                           3       1              
2026 [] Kirjastoautopalvelut Bokbussar Mobile libraries 312 2018-08-07T14:00:22.565354+03:00 3 345 {} [312] 0 1403 1 3                                           1       1              
2023 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:22.286375+03:00 5 265 {} [765] 0 1400 3 4                                           1                      
2022 [] Tuotantotilojen vuokraus Uthyrning av produktionslokaler Production facility rental 718 2018-08-07T14:00:22.279273+03:00 5 265 {} [718] 0 1400 3 4                                           1                      
2021 [] Liike- ja toimistotilojen vuokraus Uthyrning av affärs- och kontorslokaler Commercial and office space rental 393 2018-08-07T14:00:22.272146+03:00 5 265 {} [393] 0 1400 3 5                                           2                      
2014 [] Valmistava opetus luokille 1-2 (maahanmuuttajat) Förberedande undervisning för årskurserna 1-2 (invandrare) Preparatory education for grades 1-2 (immigrants) 843 2018-08-07T14:00:25.463637+03:00 3 1098 {} [843] 1 1087   3                                                   3              
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        
2009 [] Koiraurheiluhalli Hundsporthall Dog sports hall 323 2018-08-07T14:00:23.274980+03:00 4 2007 {} [323] 0 1403 1 1                                                                  
2008 [] Koiraurheilualue Område för hundsport Dog sports area 322 2018-08-07T14:00:23.268249+03:00 4 2007 {} [322] 0 1403 7 10                                                   3              
2007 [2008, 2009] Koiraurheilu Hundsport Dog sports   2018-08-07T14:00:23.263114+03:00 3 552 {} [] 0 1403 8 11                                                   3              
2006 [] Veistokset ja julkinen taide Skulpturer och offentlig konst Sculptures and public art 767 2018-08-07T14:00:22.854537+03:00 2 343 {"fi": ["patsas", "patsaat", "veistos"]} [767] 0 1403 482 488                     6                                            
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        
2002 [] Viestintä Kommunikation Communications 488 2018-08-07T14:00:30.436273+03:00 3 172 {} [488] 0 1401 1 3                                           1       1              
2001 [] Turvallisuus- ja valmiussuunnittelu Säkerhets- och beredskapsplanering Safety and preparedness planning 226 2018-08-07T14:00:30.429227+03:00 3 172 {} [226] 0 1401 1 1                                                                  
1403 [343, 551, 717, 365] Kulttuuri, liikunta ja vapaa-aika Kultur, motion och fritid Culture, sports and leisure   2018-08-07T14:00:22.534057+03:00 0   {} [] 0 1403 5769 8871 1     18 1 1       1 12 1 20   3 1 6 14       1685     1 1238 1 37 57 4      
1402 [306, 512] Liikenne ja kartat Trafik och kartor Traffic and maps   2018-08-07T14:00:24.647447+03:00 0   {} [] 0 1402 1567 2238 1     4             1   2   1     2       581       71     8        
1400 [2, 1, 14, 24, 31, 221, 85] Asuminen ja kaupunkiympäristö Boende och stadsmiljö Housing and urban environment   2018-08-07T14:00:21.224786+03:00 0   {} [] 0 1400 2311 4077       17 1 23 1     1 4 1     30   53 43       737     3 698 35 10 31 37 41    
1382 [] Hallinto Förvaltning Administration 179 2018-08-07T14:00:27.693663+03:00 1 1087 {} [179] 0 1087 12 12                                                                  
1381 [] Ammatillisen koulutuksen neuvonta Kundbetjäning och rådgivning (yrkesutbildning) Customer service and information (vocational education and training) 68 2018-08-07T14:00:27.686734+03:00 2 1378 {} [68] 0 1087 3 5                                           2                      
1380 [] Lukiokoulutuksen neuvonta Kundbetjäning och rådgivning (gymnasieutbildning) Customer service and information (general upper secondary education) 69 2018-08-07T14:00:27.679921+03:00 2 1378 {} [69] 0 1087 1 2                                           1                      
1379 [] Perusopetuksen neuvonta Kundbetjäning och rådgivning (grundläggande utbildning) Customer service and information (basic education) 70 2018-08-07T14:00:27.673059+03:00 2 1378 {} [70] 0 1087 1 2                                           1                      
1378 [1381, 2080, 1380, 1379] Kasvatuksen ja koulutuksen neuvonta Rådgivning om fostran och utbildning Day care and education information and advice   2018-08-07T14:00:27.660874+03:00 1 1087 {} [] 0 1087 4 6                                           2                      
1377 [] Oppilaan ja opiskelijan tuet Förmåner för elever och studerande Pupil and student benefits 485 2018-08-07T14:00:27.654181+03:00 1 1087 {} [485] 0 1087 4 15       1                                   7       2         1    
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} [343] 0 1087   2                                                   2              
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} [340] 0 1087   71                                                   66     5        
1372 [1373, 1374, 1375] Oppilas- ja opiskelijahuolto Elevvård Pupil and student care   2018-08-07T14:00:27.603403+03:00 1 1087 {} [] 0 1087 241 388                               1           2       136 1   7        
1359 [] Yliopistot Universitet Universities 822 2018-08-07T14:00:27.510881+03:00 1 1087 {} [822] 0 1087 10 60                                           50                      
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        
1355 [] Ruotsinkielinen oppisopimuskoulutus Läroavtalsutbildning på svenska Apprenticeship training in Swedish 599 2018-08-07T14:00:27.476430+03:00 2 1353 {} [599] 1 1087 1 1                                                                  
1354 [] Suomenkielinen oppisopimuskoulutus Läroavtalsutbildning på finska Apprenticeship training in Finnish 659 2018-08-07T14:00:27.469481+03:00 2 1353 {} [659] 1 1087 1 2                                                   1              
1353 [1355, 1354] Oppisopimuskoulutus Läroavtalsutbildning Apprenticeship training   2018-08-07T14:00:27.464000+03:00 1 1087 {} [] 0 1087 1 2                                                   1              
1347 [] Aikuisten peruskouluaineiden opetus Undervisning i grundskolans läroämnen för vuxna Education on comprehensive school subjects for adults 591 2018-08-07T14:00:27.426296+03:00 3 1343 {} [591] 1 1087 1 1                                                                  
1346 [] Aikuisten lukioaineiden opetus Undervisning i gymnasiets läroämnen för vuxna Education on upper secondary school subjects for adults 589 2018-08-07T14:00:27.419564+03:00 3 1343 {} [589] 1 1087 1 1                                                                  
1345 [] Aikuisten peruskoulutus Grundläggande utbildning för vuxna Basic education for adults 592 2018-08-07T14:00:27.412986+03:00 3 1343 {} [592] 1 1087 1 1                                                                  
1344 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 590 2018-08-07T14:00:27.406024+03:00 3 1343 {} [590] 1 1087 1 1                                                                  
1343 [1346, 1344, 1347, 1345] Ruotsinkielinen aikuisten perus- ja lukiokoulutus Grundläggande utbildning och gymnasieutbildning för vuxna på svenska Comprehensive and upper secondary school education for adults in Swedish   2018-08-07T14:00:27.400544+03:00 2 1335 {} [] 0 1087 1 1                                                                  
1342 [] Kaksoistutkinto Dubbel gymnasieexamen Upper secondary school dual qualification 408 2018-08-07T14:00:27.393475+03:00 3 1336 {} [408] 1 1087 1 1                                                                  
1341 [] Aikuisten peruskouluaineiden opetus Undervisning i grundskolans läroämnen för vuxna Education on comprehensive school subjects for adults 651 2018-08-07T14:00:27.386151+03:00 3 1336 {} [651] 1 1087 3 3                                                                  
1340 [] Aikuisten lukioaineiden opetus Undervisning i gymnasiets läroämnen för vuxna Education on upper secondary school subjects for adults 649 2018-08-07T14:00:27.379870+03:00 3 1336 {} [649] 1 1087 3 3                                                                  
1338 [] Aikuisten peruskoulutus Grundläggande utbildning för vuxna Basic education for adults 652 2018-08-07T14:00:27.364989+03:00 3 1336 {} [652] 1 1087 3 4                                           1                      
1337 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 650 2018-08-07T14:00:27.357192+03:00 3 1336 {} [650] 1 1087 2 7                                           2       3              
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} [] 0 1087 5 11                                           2       3     1        
1334 [] Nuorten työpajatoiminta Ungdomsverkstäder Workshops for the young 472 2018-08-07T14:00:27.336955+03:00 1 1087 {} [472] 1 1087 9 17                                                   8              
1328 [] Painotettu lukio Gymnasium med betoning Specialised upper secondary school 598*493 2018-08-07T14:00:27.295727+03:00 3 1298 {} [598, 493] 1 1087 2 2                                                                  
1326 [] B-venäjä B-ryska B-Russian 598*99 2018-08-07T14:00:27.281070+03:00 4 1303 {} [598, 99] 1 1087 1 1                                                                  
1325 [] B-saksa B-tyska B-German 598*97 2018-08-07T14:00:27.274071+03:00 4 1303 {} [598, 97] 1 1087 3 4                                                   1              
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                                                                  

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