service_node
279 rows where level = 2 sorted by unit_count_total
This data as json, CSV (advanced)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
521 | [522, 523] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 2018-08-07T14:00:25.059349+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 1 | 5 | 2 | 1 | 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 | ||||||||||||||||||||||||||||||||
834 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:28.041229+03:00 | 2 | 830 | {} | [545] | 0 | 783 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1255 | [] | Sairaalaopetus | Sjukhusundervisning | Hospital education | 609 | 2018-08-07T14:00:26.759479+03:00 | 2 | 1097 | {} | [609] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
123 | [] | Ammatinvalinnanohjaus | Yrkesvägledning | Vocational guidance | 51 | 2018-08-07T14:00:30.001277+03:00 | 2 | 122 | {} | [51] | 0 | 1401 | 4 | 6 | 1 | 1 | |||||||||||||||||||||||||||||||
804 | [] | Vammaispalvelun tulkkipalvelu | Tolktjänster inom handikappservicen | Services for the disabled, interpretation services | 754 | 2018-08-07T14:00:27.842330+03:00 | 2 | 798 | {} | [754] | 0 | 783 | 6 | 2 | 4 | ||||||||||||||||||||||||||||||||
814 | [] | Kehitysvammahuollon työllistämispalvelut | Sysselsättningstjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, employment services | 282 | 2018-08-07T14:00:27.906450+03:00 | 2 | 810 | {} | [282] | 0 | 783 | 5 | 6 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1035 | [] | Neurologia | Neurologi | Neurology | 462 | 2018-08-07T14:00:29.539786+03:00 | 2 | 1028 | {} | [462] | 0 | 986 | 6 | 6 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
124 | [] | Avoimet työpaikat | Lediga jobb | Open jobs | 84 | 2018-08-07T14:00:30.009390+03:00 | 2 | 122 | {} | [84] | 0 | 1401 | 5 | 7 | 1 | 1 | |||||||||||||||||||||||||||||||
141 | [142, 144, 145] | Markkinointi | Marknadsföring | Marketing | 2018-08-07T14:00:30.127227+03:00 | 2 | 122 | {} | [] | 0 | 1401 | 4 | 7 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
821 | [] | Vanhuspalvelun sosiaaliohjaus | Socialhandledning inom äldreomsorg | Services for the elderly, social care work | 763 | 2018-08-07T14:00:27.957632+03:00 | 2 | 819 | {} | [763] | 0 | 783 | 4 | 7 | 2 | 1 | |||||||||||||||||||||||||||||||
826 | [] | Vanhusten laitospalvelu | Institutionsservice för äldre | Institutional service for the elderly | 758 | 2018-08-07T14:00:27.990439+03:00 | 2 | 819 | {} | [758] | 0 | 783 | 4 | 7 | 2 | 1 | |||||||||||||||||||||||||||||||
832 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:28.028451+03:00 | 2 | 830 | {} | [548] | 0 | 783 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1369 | [] | Kuvataidekoulu | Konstskola | School of visual arts | 360 | 2020-11-18T07:30:12.906446+02:00 | 2 | 1360 | {} | [360] | 0 | 1087 | 7 | 6 | 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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
179 | [] | Kirjaamo | Registratorskontor | Registrar's office | 310 | 2018-08-07T14:00:30.455188+03:00 | 2 | 171 | {} | [310] | 0 | 1401 | 4 | 8 | 2 | 2 | |||||||||||||||||||||||||||||||
800 | [] | Vammaispalvelun tukihenkilö | Stödperson inom handikappservice | Services for the disabled, support person | 753 | 2018-08-07T14:00:27.816289+03:00 | 2 | 798 | {} | [753] | 0 | 783 | 4 | 8 | 4 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
827 | [] | Vanhuspalvelun omaishoidon tuki | Stöd för närståendevårdare inom äldreomsorgen | Care for the elderly, close relative care support | 759 | 2018-08-07T14:00:27.996868+03:00 | 2 | 819 | {} | [759] | 0 | 783 | 4 | 8 | 1 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
103 | [104, 105, 106, 107, 109, 110, 111, 113, 114] | Ympäristöterveydenhuolto | Miljö- och hälsoskydd | Environmental health | 2018-08-07T14:00:21.574018+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 4 | 9 | 2 | 1 | 2 | |||||||||||||||||||||||||||||||
769 | [770, 775, 776, 777, 778, 779, 780, 2202, 781] | Oikeusturva | Rättsskydd | Legal protection | 2018-08-07T14:00:30.864855+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 5 | 9 | 3 | 1 | ||||||||||||||||||||||||||||||||
785 | [] | Sosiaali- ja terveyspalvelujen neuvonta | Social- och hälsovårdstjänsternas rådgivning | Social and health services information and advice | 71 | 2018-08-07T14:00:27.709008+03:00 | 2 | 784 | {} | [71] | 0 | 783 | 1 | 9 | 1 | 1 | 6 | ||||||||||||||||||||||||||||||
794 | [] | Lapsiperheiden kotipalvelu | Hemservice för barnfamiljer | Domestic services for families with children | 371 | 2018-08-07T14:00:27.777393+03:00 | 2 | 791 | {} | [371] | 0 | 783 | 6 | 9 | 3 | ||||||||||||||||||||||||||||||||
808 | [] | Vammaispalvelun henkilökohtainen apu | Personlig assistent inom handikappservicen | Service for the disabled, personal assistant | 748 | 2018-08-07T14:00:27.870086+03:00 | 2 | 798 | {} | [748] | 0 | 783 | 4 | 9 | 1 | 4 | |||||||||||||||||||||||||||||||
811 | [] | Kehitysvammahuollon sosiaalityö | Socialt arbete inom vård av utvecklingsstörda | Care of the developmentally disabled, social work | 280 | 2018-08-07T14:00:27.887549+03:00 | 2 | 810 | {} | [280] | 0 | 783 | 3 | 9 | 5 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1365 | [1366, 1368, 1367] | Ruotsinkielinen työväenopisto | Svenska arbetarinstitutet | Swedish adult education centre | 605 | 2020-11-18T07:30:12.874521+02:00 | 2 | 1360 | {} | [605] | 0 | 1087 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
130 | [] | Eläkkeet | Pensioner | Pension matters | 143 | 2018-08-07T14:00:30.054750+03:00 | 2 | 122 | {} | [143] | 0 | 1401 | 4 | 10 | 1 | 2 | 2 | 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 | |||||||||||||||||||||||||||||||
197 | [2152, 198, 209] | Talous | Ekonomi | Economy | 2018-08-07T14:00:30.559004+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 10 | 10 | ||||||||||||||||||||||||||||||||||
320 | [321, 322, 323] | Kartat ja paikkatietopalvelut | Kartor och geografisk information | Maps and location information services | 2018-08-07T14:00:24.796452+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 4 | 10 | 2 | 4 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
806 | [] | Vammaispalvelun omaishoidon tuki | Stöd för närståendevård inom handikappservicen | Services for the disabled, close relative care support | 749 | 2018-08-07T14:00:27.856508+03:00 | 2 | 798 | {} | [749] | 0 | 783 | 4 | 10 | 2 | 4 | |||||||||||||||||||||||||||||||
807 | [] | Vammaispalvelun asunnon muutostyöt | Ändringsarbeten i bostad inom handikappservicen | Service for the disabled, renovation services | 747 | 2018-08-07T14:00:27.863389+03:00 | 2 | 798 | {} | [747] | 0 | 783 | 4 | 10 | 2 | 4 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1029 | [] | Apuvälinepalvelut | Hjälpmedelstjänster | Aid services | 352 | 2018-08-07T14:00:29.484194+03:00 | 2 | 1028 | {} | [352] | 0 | 986 | 5 | 10 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 1 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
799 | [] | Vammaispalvelun sosiaalityö | Socialt arbete inom handikappservicen | Service for the disabled, social work | 752 | 2018-08-07T14:00:27.810101+03:00 | 2 | 798 | {} | [752] | 0 | 783 | 4 | 11 | 3 | 4 | |||||||||||||||||||||||||||||||
1012 | [] | Kaupunginsairaalat | Stadssjukhus | City hospitals | 264 | 2018-08-07T14:00:29.330351+03:00 | 2 | 1009 | {} | [264] | 0 | 986 | 9 | 11 | 1 | 1 | |||||||||||||||||||||||||||||||
367 | [] | Katutaidepaikat | Platser för gatukonst | Street art locations | 254 | 2018-08-07T14:00:22.877110+03:00 | 2 | 365 | {} | [254] | 0 | 1403 | 12 | 12 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
756 | [757, 763] | Demokratia | Demokrati | Democracy | 2018-08-07T14:00:30.749902+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 8 | 13 | 3 | 1 | 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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
809 | [] | Vammaistuet ja -palvelut | Handikappbidrag och -tjänster | Disability benefits and services | 755 | 2018-08-07T14:00:27.876348+03:00 | 2 | 798 | {} | [755] | 0 | 783 | 3 | 15 | 1 | 2 | 7 | 1 | 1 | ||||||||||||||||||||||||||||
823 | [] | Vanhusten palvelukeskustoiminta | Servicecentralverksamhet för äldre | Service centre activities for the elderly | 761 | 2018-08-07T14:00:27.970552+03:00 | 2 | 819 | {} | [761] | 0 | 783 | 14 | 15 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
820 | [] | Vanhuspalvelun sosiaalityö | Socialt arbete inom äldreomsorgen | Service for the elderly, social work | 764 | 2018-08-07T14:00:27.951192+03:00 | 2 | 819 | {} | [764] | 0 | 783 | 5 | 16 | 1 | 8 | 2 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
792 | [] | Lapsiperheiden sosiaaliohjaus | Socialhandledning för barnfamiljer | Social care work for families with children | 373 | 2018-08-07T14:00:27.759985+03:00 | 2 | 791 | {} | [373] | 0 | 783 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
833 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:28.034805+03:00 | 2 | 830 | {} | [546] | 0 | 783 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
80 | [81, 82, 83, 84] | Torit ja kauppahallit | Torg och saluhallar | Market squares and halls | 2018-08-07T14:00:21.488118+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 19 | 19 | ||||||||||||||||||||||||||||||||||
1023 | [] | Psykiatrian poliklinikat | Psykiatriska polikliniker | Psychiatric outpatient clinics | 521 | 2018-08-07T14:00:29.437165+03:00 | 2 | 1019 | {} | [521] | 0 | 986 | 19 | 19 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
857 | [] | Maahanmuuttajapalvelut | Tjänster för invandrare | Services for immigrants | 420 | 2018-08-07T14:00:28.196278+03:00 | 2 | 845 | {} | [420] | 0 | 783 | 14 | 20 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||
1370 | [] | Musiikkiopisto | Musikinstitut | Music institute | 456 | 2020-11-18T07:30:12.915030+02:00 | 2 | 1360 | {} | [456] | 0 | 1087 | 20 | 19 | 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 | ||||||||||||||||||||||||||||||
1072 | [] | Pelastusasemat | Räddningsstationerna | Rescue Stations | 501 | 2018-08-07T14:00:29.858704+03:00 | 2 | 1070 | {} | [501] | 0 | 1061 | 9 | 21 | 6 | 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 | |||||||||||||||||||||||||||||||
490 | [] | Nuorten neuvonta ja ohjaus | Rådgivning och handledning för ungdomar | Advice and guidance for young people | 471 | 2018-08-07T14:00:23.202058+03:00 | 2 | 365 | {} | [471] | 0 | 1403 | 7 | 22 | 3 | 12 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
768 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 230 | 2018-08-07T14:00:30.858157+03:00 | 2 | 755 | {} | [230] | 0 | 1401 | 2 | 24 | 22 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );