service_node

279 rows where level = 2 sorted by unit_count_municipality_kauniainen

✎ View and edit SQL

This data as json, CSV (advanced)

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ää
846 [] Aikuisten sosiaalityö Socialt arbete för vuxna Social work for adults 42 2018-08-07T14:00:28.117778+03:00 2 845 {} [42] 0 783 21 25                                           3       1              
848 [] Aikuisten sosiaaliohjaus Socialhandledning för vuxna Social care work for adults 41 2018-08-07T14:00:28.131053+03:00 2 845 {} [41] 0 783 6 9                                           1       2              
849 [] Mielenterveyskuntoutujien päivätoiminta Dagverksamhet för klienter inom psykrehabilitering Day activities for mental health rehabilitation clients 441 2018-08-07T14:00:28.144565+03:00 2 845 {} [441] 0 783   1                                                   1              
851 [] Kuntouttava työtoiminta Arbetsverksamhet i rehabiliterande syfte Rehabilitative work 351 2018-08-07T14:00:28.157405+03:00 2 845 {} [351] 0 783 34 43                                           1       8              
854 [] Sosiaalinen luotto Social kredit Social lending 641 2018-08-07T14:00:28.176603+03:00 2 845 {} [641] 0 783 1 4                                           2       1              
855 [] Työkykyselvitys pitkäaikaistyöttömille Pensionsutredningsverksamhet Pension determination service 724 2018-08-07T14:00:28.183191+03:00 2 845 {} [724] 0 783 2 10                                                   8              
856 [] Sovittelutoiminta Medlingsverksamhet Mitigation services 644 2018-08-07T14:00:28.189606+03:00 2 845 {} [644] 0 783 1 2                                                   1              
858 [] Talous- ja velkaneuvonta Ekonomi- och skuldrådgivning Financial and debt counselling 673 2018-08-07T14:00:28.202820+03:00 2 845 {} [673] 0 783   3                                           3                      
983 [] Yksityisen hoidon tuki Privatvårdsstöd Support for private care 811 2018-08-07T14:00:29.020270+03:00 2 868 {} [811] 0 1405 111 118                                           7                      
985 [] Päivähoidon sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för dagvårdsärenden Electronic services and forms related to day care 552 2018-08-07T14:00:29.033246+03:00 2 868 {} [552] 0 1405 1 1                                                                  
989 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:29.129777+03:00 2 988 {} [71] 0 986 1 9                     1                     1       6              
1003 [] Päivystyksen vuodeosastot Vårdavdelningar inom jourverksamheten Emergency care outpatient wards 550 2018-08-07T14:00:29.260759+03:00 2 1000 {} [550] 0 986   4                                           4                      
1007 [] Kehitysvammapoliklinikka Handikapprådgivning Developmental disability clinic 284 2018-10-25T08:00:09.092312+03:00 2 810 {} [284] 0 783 4 6                                                   1         1    
1010 [] Yliopistolliset sairaalat Universitetssjukhus University hospitals 820 2018-08-07T14:00:29.314677+03:00 2 1009 {} [820] 0 986 18 31                             1 1           4   2   3 2            
1011 [] Kaupungin psykiatrinen sairaala Stadens psykiatriska sjukhus City Psychiatric Hospital 263 2018-08-07T14:00:29.322493+03:00 2 1009 {} [263] 0 986 2 2                                                                  
1012 [] Kaupunginsairaalat Stadssjukhus City hospitals 264 2018-08-07T14:00:29.330351+03:00 2 1009 {} [264] 0 986 9 11                                           1       1              
1013 [] Kotisairaalat Hemsjukhus Domestic hospitals 336 2018-08-07T14:00:29.340263+03:00 2 1009 {} [336] 0 986 3 4                                                   1              
1014 [] Päiväsairaala Dagsjukhus Day hospital 553 2018-08-07T14:00:29.349793+03:00 2 1009 {} [553] 0 986   2                                           1       1              
1015 [] Sairaaloiden poliklinikat Sjukhusens polikliniker Hospital outpatient clinics 610 2018-08-07T14:00:29.359098+03:00 2 1009 {} [610] 0 986 3 3                                                                  
1016 [] Synnytyssairaalat Förlossningssjukhus Maternity hospitals 667 2018-08-07T14:00:29.368533+03:00 2 1009 {} [667] 0 986 1 2                                           1                      
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                                                                  
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              
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} [462] 0 986   6                                                   6              
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              
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} [520] 0 986   1                                                   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                      
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                      
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                      
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                                                                  
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              
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              
1084 [] Yhteiskalliosuojat Gemensamma bergskyddsrum Shared ground shelters 808 2018-08-07T14:00:29.944094+03:00 2 1083 {} [808] 0 1061 29 29                                                                  
1089 [1090] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:07.479235+02:00 2 1088 {} [861] 1 1087 289 484                                           78       117              
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              
1098 [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] Suomen- ja vieraskielinen perusopetus Grundläggande utbildning på finska och främmande språk Basic education in Finnish, English and other languages   2020-03-06T18:32:07.543511+02:00 2 1097 {} [] 0 1087 368 504                               1           84       50 1            
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              
1255 [] Sairaalaopetus Sjukhusundervisning Hospital education 609 2018-08-07T14:00:26.759479+03:00 2 1097 {} [609] 1 1087 3 5                                           2                      
1258 [1260, 1271, 1268, 1296, 1259] Suomen- ja vieraskielinen nuorten lukiokoulutus Gymnasieutbildning för unga på finska och främmande språk General upper secondary education for the young in Finnish, English and other languages   2020-03-06T18:32:08.032022+02:00 2 1257 {} [] 0 1087 31 54                                           15       8              
1298 [1303, 1300, 1328, 1299] Ruotsinkielinen nuorten lukiokoulutus Gymnasieutbildning för unga på svenska General upper secondary education for the young in Swedish   2020-03-06T18:32:08.157237+02:00 2 1257 {} [] 0 1087 7 10                                           2       1              
1336 [1340, 1337, 1341, 1338, 1342] Suomen- ja vieraskielinen aikuisten perus- ja lukiokoulutus Grundläggande utbildning och gymnasieutbildning för vuxna på finska och främmande språk Comprehensive and upper secondary school education for adults in Finnish, English and other languages   2020-03-06T18:32:08.302751+02:00 2 1335 {} [] 0 1087 3 8                                           2       3              
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                                                                  
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              
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                                                                  
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} [343] 0 1087   2                                                   2              
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                      
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                      
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                      
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                                            
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              
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                                                                  
2049 [2055, 2053, 2050, 2054] Suomen- ja vieraskielinen iltapäivätoiminta Eftermiddagsverksamhet på finska och främmande språk Afternoon activities in Finnish, English and other languages 656 2020-03-06T18:32:07.503687+02:00 2 2042 {} [656] 1 1087 184 184                                                                  
2056 [2060, 2057, 2061] Ruotsinkielinen iltapäivätoiminta Eftermiddagsverksamhet på svenska Afternoon activities in Swedish 596 2018-08-07T14:00:25.399596+03:00 2 2042 {} [596] 1 1087 24 39                                           11       4              
2080 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:27.666416+03:00 2 1378 {} [844] 0 1087 1 1                                                                  
2122 [2125] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:09.045855+02:00 2 2118 {} [861] 1 1405 289 484                                           78       117              
2126 [2127, 2128, 2129] Ruotsinkielinen esiopetus Förskoleundervisning på svenska Pre-primary education in Swedish 862 2018-08-07T14:00:29.080400+03:00 2 2118 {} [862] 1 1405 31 46                                           11       4              
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              
2151 [] Liikunnan sähköinen asiointi ja lomakkeet Elektroniska tjänster och formulär för motion Electronic services and forms related to sports 849 2018-08-07T14:00:24.387923+03:00 2 551 {} [849] 0 1403   1                     1                                            
2156 [] Etsivä nuorisotyö Uppsökande ungdomsarbete Detective youth work 854 2018-08-07T14:00:23.208137+03:00 2 365 {} [854] 0 1403 5 7                                           2                      
2157 [] 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:28.074000+03:00 2 830 {} [855] 0 783 1 1                                                                  
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                                                                  
2160 [] Mielenterveyskuntoutujien asumispalvelut Boendetjänster för klienter inom psykrehabilitering Residential services for mental health rehabilitation clients 857 2018-08-07T14:00:28.137962+03:00 2 845 {} [857] 0 783 6 14                                                   8              
2161 [] Palliatiivinen hoito Palliativ vård Palliative care 858 2018-08-07T14:00:29.377630+03:00 2 1009 {} [858] 0 986 1 1                                                                  
2162 [] Digitaalinen nuorisotyö Digital ungdomsarbete Digital youth work 859 2018-08-07T14:00:23.214339+03:00 2 365 {} [859] 0 1403   2                                           1       1              
2173 [] Tapahtumapaikat Evenemangsplatser Venues 868 2018-08-07T14:00:24.624759+03:00 2 717 {} [868] 0 1403 195 211                                           10       6              
2180 [] Suomenkielinen ammatillinen peruskoulutus Grundutbildning på finska Basic education in Finnsh 653*872 2018-08-31T16:00:09.186721+03:00 2 2179 {} [872, 653] 1 1087 15 21                                           2       4              
2181 [] Suomenkielinen ammatillinen lisäkoulutus Påbyggnadsutbildning på finska Supplementary education in Finnsh 653*873 2018-08-31T16:00:09.195826+03:00 2 2179 {} [873, 653] 1 1087 14 16                                           2                      
2186 [] Ammatilliseen peruskoulutukseen valmentava koulutus - VALMA Handledande utbildning för grundläggande yrkesutbildning - VALMA Preparatory education for vocational training - VALMA 470 2018-08-31T16:00:09.222841+03:00 2 2179 {} [470] 1 1087 8 9                                                   1              
2191 [] Hitas-asunnot Hitas-bostäder Hitas owner-occupied housing 877 2019-03-05T14:30:06.194077+02:00 2 2 {} [877] 0 1400 399 399                                                                  
2200 [] Englanninkielinen ammatillinen peruskoulutus Grundutbildning på engelska Basic education in English 883*872 2019-08-22T14:00:14.395819+03:00 2 2179 {} [883, 872] 1 1087   1                                                   1              
2203 [] Asiakaspalvelu Kundbetjäning Customer services 884 2019-08-23T14:30:13.757143+03:00 2 171 {} [884] 0 1401 2 3                                           1                      
2212 [] Kansalaisopisto Medborgarinstitut Community college 890 2020-11-18T07:30:12.923359+02:00 2 1360 {} [890] 0 1087   3                                                   3              
8 [10, 9, 11] Vuokra-asuminen Hyresbostäder Rental flats   2018-08-07T14:00:21.267377+03:00 2 2 {} [] 0 1400 9 13                                           3             1        
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} [232] 0 1400 1 2                                                         1        
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} [298] 0 1400 3 7                                   1       1       1     1        
74 [76, 77, 78, 75, 79, 2205] Tiet ja kadut Vägar och gator Roads and streets   2018-08-07T14:00:21.451762+03:00 2 1 {} [] 0 1400 356 376                                           3       16     1        
134 [137, 136, 135, 138, 139] 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:30.080832+03:00 2 122 {} [] 0 1401 10 32                                           4       17     1        
172 [173, 176, 2001, 2002] Hallinto Förvaltning Administration   2018-08-07T14:00:30.370486+03:00 2 171 {} [] 0 1401 59 72                                   1       3       8     1        
187 [188, 189] Maahanmuutto Invandring Immigration   2018-08-07T14:00:30.506450+03:00 2 171 {} [] 0 1401 17 29       1                                   4       5     1   1    
191 [192, 193, 194, 195, 196] Päätöksenteko Beslutsfattande Decision-making   2018-08-07T14:00:30.523612+03:00 2 171 {} [] 0 1401 6 10                                           2       1     1        
219 [220] Tuet ja avustukset Understöd och bidrag Grants and benefits 715 2018-08-07T14:00:30.723645+03:00 2 171 {} [715] 0 1401   3                                                   2     1        
222 [223, 224, 225, 226, 229, 230] Kaavoitus Planläggning Planning   2018-08-07T14:00:22.001028+03:00 2 221 {} [] 0 1400 9 15                                           2       3     1        
270 [271, 272, 277, 278, 279, 286, 287, 293, 302] Rakentaminen Byggande Construction   2018-08-07T14:00:22.314988+03:00 2 221 {} [] 0 1400 48 80                     1       1             8       21     1        
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} [] 0 1402 4 11                                           2       4     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
);