service_node

279 rows where level = 2 sorted by name_sv

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_hyvinkää, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, unit_count_municipality_kerava, last_modified_time (date)

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ää
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} [46] 0 986 1 4                                                   3              
837 [] 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:28.061184+03:00 2 830 {} [544] 0 783 6 9                                           1       2              
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              
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        
94 [] Yleisövessat Allmänna toaletter Public toilets 819 2018-10-25T08:00:06.064613+03:00 2 1 {} [819] 0 1400 39 39                                                                  
666 [667, 675, 677] Vene-, ilmailu- ja moottoriurheilu Anläggningar för båtsport, flygsport och motorsport Boating, aviation and motor sports   2018-08-07T14:00:24.041279+03:00 2 551 {} [] 0 1403 9 18                                           3       6              
552 [553, 2007] Eläinurheilualueet Anläggningar för djursport Animal sports areas   2018-08-07T14:00:23.225274+03:00 2 551 {} [] 0 1403 27 75                                           31       17              
601 [602, 606, 608, 614, 624] Sisäliikuntatilat Anläggningar för inomhusidrott Indoor sports facilities   2018-08-07T14:00:23.557871+03:00 2 551 {} [] 0 1403 795 1314                                           278       229     12        
558 [559, 564, 567, 572, 575, 577, 592, 597] Maastoliikuntapaikat Anläggningar för terrängidrott Cross-country sports facilities   2018-08-07T14:00:23.281875+03:00 2 551 {} [] 0 1403 151 443       5                 1       1         118       153   9 5        
684 [685, 690] Vesiliikuntapaikat Anläggningar för vattenidrott Water sports facilities   2018-08-07T14:00:24.163817+03:00 2 551 {} [] 0 1403 78 153                         4                 51       15   4 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              
164 [] Työsuhdeasiat Anställningsfrågor Employment matters 725 2018-08-07T14:00:30.298491+03:00 2 122 {} [725] 0 1401 3 5                                           1       1              
163 [] Työ- ja elinkeinotoimistot Arbets- och näringsbyråer Employment and economic development offices 723 2018-08-07T14:00:30.289431+03:00 2 122 {} [723] 0 1401 3 7                                           1       3              
165 [] Työttömyys Arbetslöshet Unemployment 464 2018-08-07T14:00:30.308304+03:00 2 122 {} [464] 0 1401 4 8                                           1       3              
850 [] Työhön kuntoutus- ja työllistämispalvelut Arbetsrehabiliterings- och sysselsättningstjänster Rehabilitation and employment services for work 638 2018-08-07T14:00:28.151060+03:00 2 845 {} [638] 0 783 4 12                                           1       6     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              
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        
33 [] Jätteenkäsittelykeskus Avfallshanteringscentral Waste treatment centre 234 2018-08-07T14:00:21.773147+03:00 2 31 {} [234] 0 1400   1                                           1                      
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} [232] 0 1400 1 2                                                         1        
87 [] Jäteveden puhdistamo Avloppsreningsverk Sewage treatment plant 233 2018-08-07T14:00:21.958557+03:00 2 85 {} [233] 0 1400 1 2                                           1                      
1074 [] Sopimuspalokunnat Avtalsbrandkårer Volunteer fire departments 633 2018-08-07T14:00:29.872976+03:00 2 1070 {} [633] 0 1061 15 23                                           7             1        
1005 [] Lastenneuvola Barnrådgivning Child health clinic 379 2018-10-25T08:00:09.610190+03:00 2 1004 {} [379] 0 986 22 47                                           14       10     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        
132 [] Kaupanvahvistus Bestyrkande av köp Public purchase witnessing 255 2018-08-07T14:00:30.067157+03:00 2 122 {} [255] 0 1401 1 3                                           1       1              
324 [325, 2040, 2193, 327, 328, 2194] Kirjastot Bibliotek Libraries   2018-08-07T14:00:24.821378+03:00 2 306 {} [] 0 1402 83 125                                           26       14     2        
345 [346, 2026, 2196, 348, 349, 2197] Kirjastot Bibliotek Libraries   2018-08-07T14:00:22.550752+03:00 2 343 {} [] 0 1403 114 157                                           27       14     2        
754 [] Lipunmyynti tapahtumiin Biljettförsäljning till evenemang Ticket sales to events 405 2018-08-07T14:00:24.631976+03:00 2 717 {} [405] 0 1403 5 13                     1                     6       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              
803 [] Vammaispalvelun asumispalvelut Boendetjänster inom handikappservicen Services for the disabled, residential services 746 2018-08-07T14:00:27.835887+03:00 2 798 {} [746] 0 783 7 24       1                                   3       13              
836 [] Päihdehuollon asumispalvelut Boendetjänster inom missbrukarvården Care for substance abuse, residential services 543 2018-08-07T14:00:28.054175+03:00 2 830 {} [543] 0 783 1 15                                           7       7              
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              
815 [] Kehitysvammahuollon asumispalvelut Boendetjänster inom vård av utvecklingsstörda Care of the developmentally disabled, residential services 275 2018-08-07T14:00:27.912869+03:00 2 810 {} [275] 0 783 39 71                                           9       21     1   1    
852 [] Muun sosiaalihuollon asumispalvelut Boendetjänster inom övrig socialvård Residential services for other social welfare 637 2018-08-07T14:00:28.163665+03:00 2 845 {} [637] 0 783 11 26       1                                   1       12     1        
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} [75] 0 1400 3 9       1                                   2       2         1    
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} [79] 0 1400 1 3                                           1       1              
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} [76] 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
344 [] Kasvitieteelliset puutarhat Botaniska trädgårdar Botanic gardens 248 2018-08-07T14:00:22.544317+03:00 2 343 {} [248] 0 1403 3 3                                                                  
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        
504 [] Ruoka - ja cateringpalvelut Catering Catering 587 2018-08-07T14:00:22.784722+03:00 2 343 {} [587] 0 1403   4                                           2       2              
178 [] Keskitetyt tietotekniikkapalvelut Centraliserade datatekniktjänster Centralised services on information technology 222 2018-08-07T14:00:30.449039+03:00 2 171 {} [222] 0 1401 1 2                                                   1              
869 [897, 905, 913, 921, 929, 881, 889, 937, 870, 945, 2238, 953] Päiväkotihoito Daghemsvård Day care centres   2018-08-07T14:00:28.258090+03:00 2 868 {} [] 0 1405 497 1020                                           329       184     10        
1014 [] Päiväsairaala Dagsjukhus Day hospital 553 2018-08-07T14:00:29.349793+03:00 2 1009 {} [553] 0 986   2                                           1       1              
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              
822 [] Vanhusten päivätoiminta Dagverksamhet för äldre Service for the elderly, daytime activities 762 2018-08-07T14:00:27.964013+03:00 2 819 {} [762] 0 783 17 30                                           9       3     1        
802 [] Vammaispalvelun päivätoiminta Dagverksamhet inom handikappservicen Service for the disabled, daytime activities 750 2018-08-07T14:00:27.829187+03:00 2 798 {} [750] 0 783   10                                           1       9              
835 [] Päihdehuollon päivätoiminta Dagverksamhet inom missbrukarvården Care for substance abuse, daytime activities 547 2018-08-07T14:00:28.047640+03:00 2 830 {} [547] 0 783 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              
813 [] Kehitysvammahuollon päivätoiminta Dagverksamhet inom vård av utvecklingsstörda Care of the developmentally disabled, daytime activities 278 2018-08-07T14:00:27.899777+03:00 2 810 {} [278] 0 783 10 18                                           3       4         1    
756 [757, 763] Demokratia Demokrati Democracy   2018-08-07T14:00:30.749902+03:00 2 755 {} [] 0 1401 8 13                                           3       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              
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              
197 [2152, 198, 209] Talous Ekonomi Economy   2018-08-07T14:00:30.559004+03:00 2 171 {} [] 0 1401 10 10                                                                  
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                      
818 [] Kehitysvammahuollon taloudellinen tuki Ekonomiskt stöd inom vård av utvecklingsstörda Care of the developmentally disabled, financial support 281 2018-08-07T14:00:27.931547+03:00 2 810 {} [281] 0 783 2 4                                                   2              
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} [74] 0 1400   1                     1                                            
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                                                                  
351 [] Kulttuuripalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för kulturtjänster Electronic services and forms related to cultural services 346 2018-08-07T14:00:22.590770+03:00 2 343 {} [346] 0 1403   2                     1                             1              
100 [] Ympäristön sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för miljöärenden Electronic services and forms related to environmental matters 826 2018-08-07T14:00:21.554721+03:00 2 1 {} [826] 0 1400   1                     1                                            
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} [135] 0 1401   1                     1                                            
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                                            
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} [146] 0 1400 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              
2173 [] Tapahtumapaikat Evenemangsplatser Venues 868 2018-08-07T14:00:24.624759+03:00 2 717 {} [868] 0 1403 195 211                                           10       6              
961 [962, 2145] Perhepäivähoito Familjedagvård Family day care   2018-08-07T14:00:28.863138+03:00 2 868 {} [] 0 1405 71 134                                           51       11     1        
1006 [] Perhesuunnittelu ja ehkäisyneuvola Familjeplanerings- och preventivmedelsrådgivning Family planning and contraception clinic 507 2018-08-07T14:00:29.286660+03:00 2 1004 {} [507] 0 986   5                                           4             1        
796 [] Perheoikeudelliset palvelut Familjerättsliga tjänster Services for family law 505 2018-08-07T14:00:27.790684+03:00 2 791 {} [505] 0 783   1                                                   1              
793 [] Perheneuvonta ja perheneuvolatoiminta Familjerådgivning och familjerådgivningsverksamhet Family counselling and family clinic 504 2018-10-25T08:00:09.024637+03:00 2 791 {} [504] 0 783 10 20                                           4       5     1        
790 [] Lastensuojelun perhehoito Familjevård inom barnskyddet Domestic care for child welfare 381 2018-08-07T14:00:27.746492+03:00 2 787 {} [381] 0 783   5                                           2       3              
231 [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] Kiinteistöt ja rakennetut tilat Fastigheter Real estate   2018-08-07T14:00:22.059452+03:00 2 221 {} [] 0 1400 311 427       1 1         1   1     2     2       48       55     5        
817 [] Kehitysvammahuollon loma- ja harrastustoiminta Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda Care of the developmentally disabled, vacation and leisure activities 277 2018-08-07T14:00:27.925241+03:00 2 810 {} [277] 0 783 3 6                                                   3              
1361 [1362, 1363] Suomenkielinen työväenopisto Finska arbetarinstitutet Finnish adult education centre 665 2020-11-18T07:30:12.844488+02:00 2 1360 {} [665] 0 1087 50 59                                           7             2        
1371 [] Kansanopisto Folkhögskola Folk high school 244 2020-11-18T07:30:12.932144+02:00 2 1360 {} [244] 0 1087   3                                           1             2        
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} [206] 0 986 7 10                                                   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        
805 [] Vammaispalvelulain mukainen kuljetuspalvelu Färdtjänst enligt handikappservicelagen Transportation service according to the legislation on disability services 745 2018-08-07T14:00:27.849436+03:00 2 798 {} [745] 0 783 4 8                                           2       2              
853 [] Sosiaalihuoltolain mukainen kuljetuspalvelu Färdtjänst enligt socialvårdslagen Transportation service according to the legislation on social welfare 640 2018-08-07T14:00:28.169839+03:00 2 845 {} [640] 0 783 3 6                                                   2     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        
1016 [] Synnytyssairaalat Förlossningssjukhus Maternity hospitals 667 2018-08-07T14:00:29.368533+03:00 2 1009 {} [667] 0 986 1 2                                           1                      
841 [] Etuuskäsittely Förmånsbehandling Benefit processing 167 2018-08-07T14:00:28.085946+03:00 2 839 {} [167] 0 783 1 2                                           1                      
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              
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              
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              
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              
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                      
88 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:21.964747+03:00 2 85 {} [453] 0 1400 1 2                             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        
28 [29] Hallinto Förvaltning Administration   2018-08-07T14:00:21.313217+03:00 2 1 {} [] 0 1400   1                                                   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        
1084 [] Yhteiskalliosuojat Gemensamma bergskyddsrum Shared ground shelters 808 2018-08-07T14:00:29.944094+03:00 2 1083 {} [808] 0 1061 29 29                                                                  
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                                                                  
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              
843 [] Perustoimeentulotuki Grundläggande utkomststöd Basic social assistance 711 2018-08-07T14:00:28.092481+03:00 2 839 {} [711] 0 783 3 9       1                                   2       2         1    
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              
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              
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              

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