service_node
1,140 rows sorted by unit_count_total
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 843
- 2018-10-25 91
- 2020-03-06 16
- 2020-11-18 12
- 2018-10-24 11
- 2019-03-05 11
- 2020-06-09 9
- 2020-06-22 8
- 2018-08-31 4
- 2020-10-02 4
- 2019-10-22 3
- 2018-11-20 2
- 2019-02-12 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-05-08 2
- 2019-06-20 2
- 2019-08-22 2
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-23 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-05-25 1
- 2020-12-02 1
- 2020-12-15 1
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
959 | [] | esiopetus | förskoleundervisning | pre-primary education | 795*160 | 2018-08-07T14:00:28.844971+03:00 | 4 | 953 | {} | [795, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
972 | [] | Venäjänkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på ryska | Group family day care in Russian | 774 | 2018-08-07T14:00:28.950155+03:00 | 4 | 2145 | {} | [774] | 0 | 1405 | 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 | |||||||||||||||||||||||||||||||||
999 | [] | Myrkytystietoa | Giftinformation | Poison information | 461 | 2018-08-07T14:00:29.228018+03:00 | 1 | 986 | {} | [461] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1039 | [] | Ravitsemusterapia | Näringsterapi | Nutrition therapy | 579 | 2018-08-07T14:00:29.591225+03:00 | 1 | 986 | {} | [579] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1042 | [] | Kuulontutkimus | Hörseltester | Hearing tests | 357 | 2018-08-07T14:00:29.607627+03:00 | 1 | 986 | {} | [357] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1048 | [1050] | Hallintopalvelut | Förvaltningstjänster | Patient representative services | 2020-03-06T18:32:09.249350+02:00 | 1 | 986 | {} | [] | 0 | 986 | 1 | 1 | ||||||||||||||||||||||||||||||||||
1050 | [] | Potilasasiamies | Patientombudsman | Patient representative | 520 | 2018-08-07T14:00:29.675023+03:00 | 2 | 1048 | {} | [520] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
1065 | [] | Meripelastus | Sjöräddningen | Sea rescue | 435 | 2018-08-07T14:00:29.800283+03:00 | 1 | 1061 | {} | [435] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1067 | [] | Turvallisuuskoulutus | Säkerhetsutbildning | Safety training | 720 | 2018-08-07T14:00:29.819172+03:00 | 2 | 1066 | {} | [720] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1071 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:29.851905+03:00 | 2 | 1070 | {} | [467] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1073 | [] | Pelastuskoulu | Räddningsskolan | School of Fire and Rescue Services | 502 | 2018-08-07T14:00:29.866063+03:00 | 2 | 1070 | {} | [502] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1078 | [] | Rajavartiolaitos | Gränsbevakningsväsendet | Border guard | 557 | 2018-08-07T14:00:29.900790+03:00 | 1 | 1061 | {} | [557] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1079 | [] | Säteilyturva | Strålsäkerhet | Radiation and nuclear safety | 671 | 2018-08-07T14:00:29.907687+03:00 | 1 | 1061 | {} | [671] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
1102 | [] | ranskankielinen opetus | undervisning på franska | education in French | 567 | 2018-08-07T14:00:25.502701+03:00 | 4 | 1099 | {} | [567] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1162 | [] | B2-italia | B2-italienska | B2-Italian | 149*116+150*116+162*116+163*116+301*116+302*116+384*116+385*116+567*116+568*116+612*116+613*116+661*116+662*116+771*116+772*116+793*116+794*116+865*116+866*116 | 2018-10-25T08:00:08.055251+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 116] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1192 | [] | Lisäopetus (10. luokka) | Påbyggnadsundervisning (10:de klass) | Supplementary education (10th grade) | 597 | 2018-10-25T08:00:08.215958+03:00 | 3 | 1187 | {} | [597] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1236 | [] | B2-kiina | B2-kinesiska | B2-Chinese | 601*117+602*117 | 2018-10-25T08:00:08.422063+03:00 | 4 | 1193 | {} | [602, 601, 117] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1237 | [] | B2-latina | B2-latin | B2-Latin | 601*118+602*118 | 2018-10-25T08:00:08.428837+03:00 | 4 | 1193 | {} | [602, 601, 118] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1240 | [] | B2-venäjä | B2-ryska | B2-Russian | 601*123+602*123 | 2018-10-25T08:00:08.445138+03:00 | 4 | 1193 | {} | [602, 601, 123] | 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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1272 | [] | A-suomi | A-finska | A-Finnish | 148*13+161*13+300*13+383*13+566*13+611*13+658*13+770*13+792*13 | 2018-10-25T08:00:08.546784+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 13] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1278 | [] | A-kiina | A-kinesiska | A-Chinese | 148*8+161*8+300*8+383*8+566*8+611*8+658*8+770*8+792*8 | 2020-12-15T14:00:14.137930+02:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 8] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1285 | [] | B-englanti | B-engelska | B-English | 148*88+161*88+300*88+383*88+566*88+611*88+658*88+770*88+792*88 | 2018-10-25T08:00:08.650030+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 88] | 1 | 1087 | 1 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1368 | [] | Kirjasto | Bibliotek | Library | 605*313 | 2020-11-18T07:30:12.898026+02:00 | 3 | 1365 | {} | [605, 313] | 0 | 1087 | 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 | |||||||||||||||||||||||||||||||||
2009 | [] | Koiraurheiluhalli | Hundsporthall | Dog sports hall | 323 | 2018-08-07T14:00:23.274980+03:00 | 4 | 2007 | {} | [323] | 0 | 1403 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2135 | [] | Lasten päivähoidon neuvonta | Kundbetjäning och rådgivning (barndagvård) | Customer service and information (child day care) | 844 | 2018-08-07T14:00:24.729525+03:00 | 4 | 317 | {} | [844] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
2143 | [] | Venekerhojen venepaikat | Båtklubbarnas båtplatser | Boat parking for yacht clubs | 847 | 2018-08-07T14:00:25.248772+03:00 | 4 | 547 | {} | [847] | 0 | 1402 | 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 | |||||||||||||||||||||||||||||||||
2152 | [] | Julkishallinnon talousarviot | Budgetar inom den offentliga förvaltningen | Public administration budgets | 850 | 2018-08-07T14:00:30.564290+03:00 | 3 | 197 | {} | [850] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
2155 | [] | Kasvitarha | Köksträdgård | Kitchen garden | 853 | 2018-08-07T14:00:22.969353+03:00 | 3 | 368 | {} | [853] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2161 | [] | Palliatiivinen hoito | Palliativ vård | Palliative care | 858 | 2018-08-07T14:00:29.377630+03:00 | 2 | 1009 | {} | [858] | 0 | 986 | 1 | 1 | |||||||||||||||||||||||||||||||||
2171 | [] | saamenkielinen opetus | undervisning på samiska | education in Sami | 866 | 2018-08-07T14:00:25.605807+03:00 | 4 | 1109 | {} | [866] | 1 | 1087 | 1 | 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 | |||||||||||||||||||||||||||||||||
2202 | [] | Syyttäjävirastot | Åklagarämbeten | Prosecutor's offices | 882 | 2019-08-22T15:30:11.975226+03:00 | 3 | 769 | {} | [882] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
2228 | [] | Kielirikasteinen opetus (suomi-venäjä) | Språkberikande undervisning (finska-ryska) | Language-enriched education (Finnish-Russian) | 661*911+662*911 | 2020-06-22T13:30:11.090936+03:00 | 4 | 1120 | {} | [911, 662, 661] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2230 | [] | Laajamittainen kaksikielinen opetus (suomi-espanja) | Omfattande undervisning på två språk (finska-spanska) | Extensive bilingual education (Finnish-Spanish) | 661*906+662*906 | 2020-06-22T13:30:11.144374+03:00 | 4 | 1120 | {} | [906, 662, 661] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2233 | [] | Laajamittainen kaksikielinen opetus (suomi-venäjä) | Omfattande undervisning på två språk (finska-ryska) | Extensive bilingual education (Finnish-Russian) | 661*909+662*909 | 2020-06-22T13:30:11.232959+03:00 | 4 | 1120 | {} | [909, 662, 661] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2234 | [] | Laajamittainen kaksikielinen opetus (suomi-viro) | Omfattande undervisning på två språk (finska-estinska) | Extensive bilingual education(Finnish-Estonian) | 661*908+662*908 | 2020-06-22T13:30:11.260046+03:00 | 4 | 1120 | {} | [908, 662, 661] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2235 | [] | Viheralueiden hoito | Skötsel av grönområden | Green area maintenance | 787 | 2020-12-02T11:30:08.949266+02:00 | 3 | 491 | {} | [787] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2238 | [2243, 2244, 2239] | Viittomakielinen varhaiskasvatus | Småbarnspedagogik på teckenspråk | Early childhood education and care in sign language | 913 | 2020-10-02T12:00:13.907327+03:00 | 3 | 869 | {} | [913] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2239 | [] | päivähoito | dagvård | day care | 913 | 2020-10-02T12:00:13.926103+03:00 | 4 | 2238 | {} | [913] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2243 | [] | esiopetus | förskoleundervisning | pre-primary education | 913*160 | 2020-10-02T12:00:13.998958+03:00 | 4 | 2238 | {} | [913, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
2244 | [] | osapäiväryhmä | halvdagsgrupp | part-time day care | 913*489 | 2020-10-02T12:00:14.017784+03:00 | 4 | 2238 | {} | [913, 489] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
21 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.719558+03:00 | 3 | 16 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
53 | [] | Ongelmajäteasema | Problemavfall station | Waste management station | 478 | 2018-08-07T14:00:21.933801+03:00 | 2 | 31 | {} | [478] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
54 | [] | Rantavesien ja sisäsaariston puhtaanapito | Renhållning av strandvatten och inre skärgård | Cleaning waterfronts and inner archipelago | 572 | 2018-08-07T14:00:21.940289+03:00 | 2 | 31 | {} | [572] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
67 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.407013+03:00 | 4 | 62 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
83 | [] | Markkinat | Marknader | Markets | 427 | 2018-08-07T14:00:21.511515+03:00 | 3 | 80 | {} | [427] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
99 | [] | Puutarhapalvelut | Trädgårdstjänster | Gardening services | 533 | 2018-08-07T14:00:21.548578+03:00 | 3 | 97 | {} | [533] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
102 | [] | Ympäristöohjelmat | Miljöprogram | Environmental programmes | 829 | 2018-08-07T14:00:21.567791+03:00 | 2 | 1 | {} | [829] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
111 | [] | Terveystarkastaja | Hälsoinspektör | Health inspector | 705 | 2018-08-07T14:00:21.618445+03:00 | 3 | 103 | {} | [705] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
113 | [] | Tupakkalain valvonta | Tillsyn av tobakslagen | Tobacco Act supervision | 719 | 2018-08-07T14:00:21.625158+03:00 | 3 | 103 | {} | [719] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
126 | [] | Elinkeinoasiat | Näringslivsfrågor | Trade and industry matters | 132 | 2018-08-07T14:00:30.024180+03:00 | 2 | 122 | {} | [132] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
131 | [] | Julkinen notaari | Notarius publicus | Notary public | 215 | 2018-08-07T14:00:30.061046+03:00 | 2 | 122 | {} | [215] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
133 | [] | Kauppa- ja yhdistysrekisteri | Handelsregistret och föreningsregistret | Trade register and register of associations | 257 | 2018-08-07T14:00:30.073459+03:00 | 2 | 122 | {} | [257] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
138 | [] | Liike- ja toimistotonttien vuokraus ja myynti | Arrendering och försäljning av affärs- och kontorstomter | Leasing and selling of commercial and office plots | 394 | 2018-08-07T14:00:30.106922+03:00 | 3 | 134 | {} | [394] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
145 | [] | Tapahtumamarkkinointi | Evenemangsmarknadsföring | Event marketing | 688 | 2018-08-07T14:00:30.151217+03:00 | 3 | 141 | {} | [688] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
147 | [] | Kauppahallimyyntipaikkojen vuokraus | Uthyrning av försäljningsplatser i saluhallar | Market hall sales location leasing | 258 | 2018-08-07T14:00:30.162809+03:00 | 3 | 146 | {} | [258] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
148 | [] | Torimyyntipaikkojen vuokraus | Uthyrning av torgförsäljningsplatser | Market square vending stall rental | 713 | 2018-08-07T14:00:30.169994+03:00 | 3 | 146 | {} | [713] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
185 | [] | Rekrytointi | Rekrytering | Recruitment | 225 | 2018-08-07T14:00:30.493982+03:00 | 3 | 180 | {} | [225] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
186 | [] | Kuulutukset | Kungörelser | Public announcements | 358 | 2018-08-07T14:00:30.500246+03:00 | 2 | 171 | {} | [358] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
192 | [] | Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät | stadsstyrelsens och stadsförvaltningens beredningsuppgifter | preparatory assignments for City Government and City Council | 274 | 2018-08-07T14:00:30.528561+03:00 | 3 | 191 | {} | [274] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
195 | [] | Lautakunnat ja johtokunnat | Nämnder och direktioner | Committees and boards | 386 | 2018-08-07T14:00:30.546848+03:00 | 3 | 191 | {} | [386] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
196 | [] | Valtuustoryhmät, kansalaislähetystöt | Stadsfullmäktigegrupper, medborgardelegationer | Council groups, public delegations | 743 | 2018-08-07T14:00:30.552905+03:00 | 3 | 191 | {} | [743] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
202 | [] | maksukattoasiat | betalningstakärenden | issues regarding payment limits | 677 | 2018-08-07T14:00:30.597368+03:00 | 4 | 198 | {} | [677] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
203 | [] | maksuliikenne | penningrörelse | payment transactions | 678 | 2018-08-07T14:00:30.605414+03:00 | 4 | 198 | {} | [678] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
206 | [] | suoritukset | betalningar | payments | 681 | 2018-08-07T14:00:30.628457+03:00 | 4 | 198 | {} | [681] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
207 | [] | täsmäykset | avstämningar | synchronisation | 682 | 2018-08-07T14:00:30.636668+03:00 | 4 | 198 | {} | [682] | 0 | 1401 | 2 | 2 |
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 );