service_node
170 rows where period_enabled = 1 sorted by last_modified_time
This data as json, CSV (advanced)
Suggested facets: children, level, keywords, unit_count_municipality_espoo, unit_count_municipality_vantaa, last_modified_time (date)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
448 | [] | Pingis | Bordtennis | Table tennis | 515 | 2018-08-07T14:00:23.100999+03:00 | 3 | 368 | {} | [515] | 1 | 1403 | 1 | 17 | 12 | 4 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2050 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 656*342 | 2018-08-07T14:00:25.355697+03:00 | 3 | 2049 | {} | [656, 342] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
2053 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:25.378466+03:00 | 3 | 2049 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
2054 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 656*620 | 2018-08-07T14:00:25.385536+03:00 | 3 | 2049 | {} | [656, 620] | 1 | 1087 | 18 | 18 | |||||||||||||||||||||||||||||||||
2055 | [] | Autististen ja kehitysvammaisten ryhmät | Grupper för autistiska och utvecklingsstörda | Groups for autistic and mentally handicapped | 656*80 | 2018-08-07T14:00:25.392562+03:00 | 3 | 2049 | {} | [656, 80] | 1 | 1087 | 33 | 33 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
2057 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 596*342 | 2018-08-07T14:00:25.406504+03:00 | 3 | 2056 | {} | [596, 342] | 1 | 1087 | 4 | 15 | 11 | ||||||||||||||||||||||||||||||||
2060 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:25.427391+03:00 | 3 | 2056 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
2061 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 596*620 | 2018-08-07T14:00:25.434875+03:00 | 3 | 2056 | {} | [620, 596] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
2014 | [] | Valmistava opetus luokille 1-2 (maahanmuuttajat) | Förberedande undervisning för årskurserna 1-2 (invandrare) | Preparatory education for grades 1-2 (immigrants) | 843 | 2018-08-07T14:00:25.463637+03:00 | 3 | 1098 | {} | [843] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2170 | [] | saamenkielinen opetus | undervisning på samiska | education in Sami | 865 | 2018-08-07T14:00:25.510062+03:00 | 4 | 1099 | {} | [865] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1173 | [] | Erityisluokkaopetus | Undervisning i specialklass | Special class education | 660 | 2018-08-07T14:00:26.138862+03:00 | 3 | 1098 | {} | [660] | 1 | 1087 | 4 | 10 | 1 | 5 | |||||||||||||||||||||||||||||||
1174 | [] | Ruotsin kielikylpyopetus | Språkbadsundervisning på svenska | Language immersion education in Swedish | 295 | 2018-08-07T14:00:26.145715+03:00 | 3 | 1098 | {} | [295] | 1 | 1087 | 13 | 18 | 4 | 1 | |||||||||||||||||||||||||||||||
1177 | [] | Kansainvälinen opetus (IB) | Internationell undervisning (IB) | International education (IB) | 510 | 2018-08-07T14:00:26.169911+03:00 | 3 | 1098 | {} | [510] | 1 | 1087 | 4 | 6 | 2 | ||||||||||||||||||||||||||||||||
1181 | [1186, 1183, 1182, 2134, 1184] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 656 | 2018-08-07T14:00:26.201113+03:00 | 3 | 1098 | {} | [656] | 1 | 1087 | 238 | 240 | 2 | ||||||||||||||||||||||||||||||||
1182 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 656*342 | 2018-08-07T14:00:26.208350+03:00 | 4 | 1181 | {} | [656, 342] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
2134 | [] | Leikkipuiston järjestämät ryhmät | Lekparkernas grupper | Groups organised by playgrounds | 341 | 2018-08-07T14:00:26.223904+03:00 | 4 | 1181 | {} | [341] | 1 | 1087 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
1183 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:26.230412+03:00 | 4 | 1181 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
1184 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 656*620 | 2018-08-07T14:00:26.237285+03:00 | 4 | 1181 | {} | [656, 620] | 1 | 1087 | 18 | 18 | |||||||||||||||||||||||||||||||||
1186 | [] | Autististen ja kehitysvammaisten ryhmät | Grupper för autistiska och utvecklingsstörda | Groups for autistic and intellectually disabled | 656*80 | 2018-08-07T14:00:26.244278+03:00 | 4 | 1181 | {} | [656, 80] | 1 | 1087 | 33 | 33 | |||||||||||||||||||||||||||||||||
1189 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 601 | 2018-08-07T14:00:26.265483+03:00 | 4 | 1188 | {} | [601] | 1 | 1087 | 21 | 37 | 12 | 4 | |||||||||||||||||||||||||||||||
1191 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 602 | 2018-08-07T14:00:26.281144+03:00 | 4 | 1190 | {} | [602] | 1 | 1087 | 7 | 12 | 4 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1246 | [] | Erityisluokkaopetus | Undervisning i specialklass | Special class education | 600 | 2018-08-07T14:00:26.688791+03:00 | 3 | 1187 | {} | [600] | 1 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1249 | [1251, 1250, 1252] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 596 | 2018-08-07T14:00:26.711531+03:00 | 3 | 1187 | {} | [596] | 1 | 1087 | 24 | 39 | 11 | 4 | |||||||||||||||||||||||||||||||
1250 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 596*342 | 2018-08-07T14:00:26.719650+03:00 | 4 | 1249 | {} | [596, 342] | 1 | 1087 | 4 | 15 | 11 | ||||||||||||||||||||||||||||||||
1251 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:26.727399+03:00 | 4 | 1249 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
1252 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 596*620 | 2018-08-07T14:00:26.734846+03:00 | 4 | 1249 | {} | [620, 596] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1255 | [] | Sairaalaopetus | Sjukhusundervisning | Hospital education | 609 | 2018-08-07T14:00:26.759479+03:00 | 2 | 1097 | {} | [609] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1299 | [] | Ruotsinkielinen lukiokoulutus | gymnasieutbildning på svenska | general upper secondary education in Swedish | 598 | 2018-08-07T14:00:27.081551+03:00 | 3 | 1298 | {} | [598] | 1 | 1087 | 4 | 6 | 1 | 1 | |||||||||||||||||||||||||||||||
1301 | [] | Yleislinjan lukiokoulutus | Gymnasieutbildning, allmän linje | Upper secondary school education, general programme | 598*816 | 2018-08-07T14:00:27.095367+03:00 | 4 | 1300 | {} | [816, 598] | 1 | 1087 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1304 | [] | A-suomi | A-finska | A-Finnish | 598*13 | 2018-08-07T14:00:27.116631+03:00 | 4 | 1303 | {} | [598, 13] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1306 | [] | A-englanti | A-engelska | A-English | 598*4 | 2018-08-07T14:00:27.131698+03:00 | 4 | 1303 | {} | [598, 4] | 1 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1315 | [] | B-suomi | B-finska | B-Finnish | 598*98 | 2018-08-07T14:00:27.199171+03:00 | 4 | 1303 | {} | [598, 98] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1317 | [] | B-englanti | B-engelska | B-English | 598*88 | 2018-08-07T14:00:27.214095+03:00 | 4 | 1303 | {} | [598, 88] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1318 | [] | B-espanja | B-spanska | B-Spanish | 598*89 | 2018-08-07T14:00:27.222850+03:00 | 4 | 1303 | {} | [598, 89] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1319 | [] | B-italia | B-italienska | B-Italian | 598*90 | 2018-08-07T14:00:27.230479+03:00 | 4 | 1303 | {} | [598, 90] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1321 | [] | B-kiina | B-kinesiska | B-Chinese | 598*92 | 2018-08-07T14:00:27.245446+03:00 | 4 | 1303 | {} | [598, 92] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1324 | [] | B-ranska | B-franska | B-French | 598*95 | 2018-08-07T14:00:27.267203+03:00 | 4 | 1303 | {} | [598, 95] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1325 | [] | B-saksa | B-tyska | B-German | 598*97 | 2018-08-07T14:00:27.274071+03:00 | 4 | 1303 | {} | [598, 97] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1328 | [] | Painotettu lukio | Gymnasium med betoning | Specialised upper secondary school | 598*493 | 2018-08-07T14:00:27.295727+03:00 | 3 | 1298 | {} | [598, 493] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1334 | [] | Nuorten työpajatoiminta | Ungdomsverkstäder | Workshops for the young | 472 | 2018-08-07T14:00:27.336955+03:00 | 1 | 1087 | {} | [472] | 1 | 1087 | 9 | 17 | 8 | ||||||||||||||||||||||||||||||||
1337 | [] | Aikuisten lukiokoulutus | Gymnasieutbildning för vuxna | Upper secondary school education for adults | 650 | 2018-08-07T14:00:27.357192+03:00 | 3 | 1336 | {} | [650] | 1 | 1087 | 2 | 7 | 2 | 3 | |||||||||||||||||||||||||||||||
1338 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 652 | 2018-08-07T14:00:27.364989+03:00 | 3 | 1336 | {} | [652] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1340 | [] | Aikuisten lukioaineiden opetus | Undervisning i gymnasiets läroämnen för vuxna | Education on upper secondary school subjects for adults | 649 | 2018-08-07T14:00:27.379870+03:00 | 3 | 1336 | {} | [649] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1341 | [] | Aikuisten peruskouluaineiden opetus | Undervisning i grundskolans läroämnen för vuxna | Education on comprehensive school subjects for adults | 651 | 2018-08-07T14:00:27.386151+03:00 | 3 | 1336 | {} | [651] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
895 | [] | esiopetus | förskoleundervisning | pre-primary education | 607*160 | 2018-08-07T14:00:28.423737+03:00 | 4 | 889 | {} | [607, 160] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
903 | [] | esiopetus | förskoleundervisning | pre-primary education | 58*160 | 2018-08-07T14:00:28.468345+03:00 | 4 | 897 | {} | [160, 58] | 1 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
911 | [] | esiopetus | förskoleundervisning | pre-primary education | 151*160 | 2018-08-07T14:00:28.512259+03:00 | 4 | 905 | {} | [160, 151] | 1 | 1405 | 26 | 39 | 12 | 1 | |||||||||||||||||||||||||||||||
919 | [] | esiopetus | förskoleundervisning | pre-primary education | 164*160 | 2018-08-07T14:00:28.559368+03:00 | 4 | 913 | {} | [164, 160] | 1 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
935 | [] | esiopetus | förskoleundervisning | pre-primary education | 569*160 | 2018-08-07T14:00:28.657653+03:00 | 4 | 929 | {} | [569, 160] | 1 | 1405 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
977 | [] | Kehitysvammaisten iltapäivätoiminnan ryhmät | Eftermiddagsverksamhet för utvecklingsstörda | Afternoon activities for the intellectually disabled | 80 | 2018-08-07T14:00:28.982154+03:00 | 3 | 975 | {} | [80] | 1 | 1405 | 33 | 33 | |||||||||||||||||||||||||||||||||
979 | [] | Koululaisten iltapäivätoiminnan ryhmät | Eftermiddagsverksamhet för skolelever | Afternoon activities for schoolchildren | 341 | 2018-08-07T14:00:28.994886+03:00 | 3 | 975 | {} | [341] | 1 | 1405 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1214 | [] | A2-ranska | A2-franska | A2-French | 601*33+602*33 | 2018-10-24T20:00:08.734794+03:00 | 4 | 1193 | {} | [602, 601, 33] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1215 | [] | A2-saksa | A2-tyska | A2-German | 601*35+602*35 | 2018-10-24T20:00:08.743668+03:00 | 4 | 1193 | {} | [602, 601, 35] | 1 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
1218 | [] | B1-suomi | B1-finska | B1-Finnish | 601*110+602*110 | 2018-10-24T20:00:08.767450+03:00 | 4 | 1193 | {} | [602, 601, 110] | 1 | 1087 | 6 | 6 | |||||||||||||||||||||||||||||||||
1232 | [] | B2-englanti | B2-engelska | B2-English | 601*113+602*113 | 2018-10-24T20:30:09.320105+03:00 | 4 | 1193 | {} | [602, 601, 113] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
1239 | [] | B2-saksa | B2-tyska | B2-German | 601*121+602*121 | 2018-10-24T20:30:09.358131+03:00 | 4 | 1193 | {} | [602, 601, 121] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
879 | [] | esiopetus | förskoleundervisning | pre-primary education | 663*160+861*160 | 2018-10-24T23:30:08.464088+03:00 | 4 | 870 | {} | [861, 663, 160] | 1 | 1405 | 266 | 448 | 66 | 116 | |||||||||||||||||||||||||||||||
887 | [] | esiopetus | förskoleundervisning | pre-primary education | 603*160+862*160 | 2018-10-24T23:30:08.488969+03:00 | 4 | 881 | {} | [862, 603, 160] | 1 | 1405 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
1094 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 603*160+862*160 | 2018-10-25T08:00:07.518402+03:00 | 3 | 1093 | {} | [862, 603, 160] | 1 | 1087 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
1095 | [] | Koulun järjestämä esiopetus | Förskoleundervisning som ordnas av skolan | Pre-primary education organised by school | 601*159+862*159 | 2018-10-25T08:00:07.525080+03:00 | 3 | 1093 | {} | [862, 601, 159] | 1 | 1087 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
1096 | [] | Esi- ja starttiopetus | Förskoleundervisning, startklasser | Pre-primary and start class education | 595 | 2018-10-25T08:00:07.533093+03:00 | 3 | 1093 | {} | [595] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1100 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 661 | 2018-10-25T08:00:07.595003+03:00 | 4 | 1099 | {} | [661] | 1 | 1087 | 104 | 205 | 62 | 38 | 1 | ||||||||||||||||||||||||||||||
1101 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 149 | 2018-10-25T08:00:07.601071+03:00 | 4 | 1099 | {} | [149] | 1 | 1087 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
1110 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 662 | 2018-10-25T08:00:07.635959+03:00 | 4 | 1109 | {} | [662] | 1 | 1087 | 63 | 114 | 1 | 27 | 22 | 1 | |||||||||||||||||||||||||||||
1111 | [] | englanninkielinen opetus | undervisning på engelska | education in English | 150 | 2018-10-25T08:00:07.642003+03:00 | 4 | 1109 | {} | [150] | 1 | 1087 | 6 | 7 | 1 | ||||||||||||||||||||||||||||||||
1119 | [] | Lisäopetus (10. luokka) | Påbyggnadsundervisning (10:de klass) | Supplementary education (10th grade) | 657 | 2018-10-25T08:00:07.670545+03:00 | 3 | 1098 | {} | [657] | 1 | 1087 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
1122 | [] | A1-ruotsi | A1-svenska | A1-Swedish | 149*22+150*22+162*22+163*22+301*22+302*22+384*22+385*22+567*22+568*22+612*22+613*22+661*22+662*22+771*22+772*22+793*22+794*22+865*22+866*22 | 2018-10-25T08:00:07.687212+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 22] | 1 | 1087 | 43 | 50 | 7 | ||||||||||||||||||||||||||||||||
1123 | [] | A1-englanti | A1-engelska | A1-English | 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 | 2018-10-25T08:00:07.696168+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] | 1 | 1087 | 108 | 211 | 1 | 73 | 28 | 1 | |||||||||||||||||||||||||||||
1124 | [] | A1-espanja | A1-spanska | A1-Spanish | 149*16+150*16+162*16+163*16+301*16+302*16+384*16+385*16+567*16+568*16+612*16+613*16+661*16+662*16+771*16+772*16+793*16+794*16+865*16+866*16 | 2018-10-25T08:00:07.713876+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 16] | 1 | 1087 | 15 | 15 | |||||||||||||||||||||||||||||||||
1127 | [] | A1-kiina | A1-kinesiska | A1-Chinese | 149*19+150*19+162*19+163*19+301*19+302*19+384*19+385*19+567*19+568*19+612*19+613*19+661*19+662*19+771*19+772*19+793*19+794*19+865*19+866*19 | 2018-10-25T08:00:07.741562+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 19] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1129 | [] | A1-ranska | A1-franska | A1-French | 149*21+150*21+162*21+163*21+301*21+302*21+384*21+385*21+567*21+568*21+612*21+613*21+661*21+662*21+771*21+772*21+793*21+794*21+865*21+866*21 | 2018-10-25T08:00:07.759368+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 21] | 1 | 1087 | 42 | 50 | 8 | ||||||||||||||||||||||||||||||||
1130 | [] | A1-saksa | A1-tyska | A1-German | 149*23+150*23+162*23+163*23+301*23+302*23+384*23+385*23+567*23+568*23+612*23+613*23+661*23+662*23+771*23+772*23+793*23+794*23+865*23+866*23 | 2018-10-25T08:00:07.768212+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 23] | 1 | 1087 | 28 | 40 | 12 | ||||||||||||||||||||||||||||||||
1131 | [] | A1-venäjä | A1-ryska | A1-Russian | 149*25+150*25+162*25+163*25+301*25+302*25+384*25+385*25+567*25+568*25+612*25+613*25+661*25+662*25+771*25+772*25+793*25+794*25+865*25+866*25 | 2018-10-25T08:00:07.777104+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 25] | 1 | 1087 | 6 | 6 |
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 );