service_node
170 rows where period_enabled = 1 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: children, level, keywords, root, unit_count_municipality_espoo, unit_count_municipality_vantaa
last_modified_time (date) ✖
- 2018-08-07 75
- 2018-10-25 67
- 2020-06-22 8
- 2018-10-24 7
- 2018-08-31 3
- 2020-03-06 3
- 2019-06-20 2
- 2020-05-08 2
- 2019-08-22 1
- 2020-10-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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2232 | [] | Laajamittainen kaksikielinen opetus (suomi-pohjoissaame) | Omfattande undervisning på två språk (finska-nordsamiska) | Extensive bilingual education (Finnish-Northern Sami) | 661*907+662*907 | 2020-06-22T13:30:11.202979+03:00 | 4 | 1120 | {} | [907, 662, 661] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
2231 | [] | Laajamittainen kaksikielinen opetus (suomi-kiina) | Omfattande undervisning på två språk (finska-kinesiska) | Extensive bilingual education (Finnish-Chinese) | 661*905+662*905 | 2020-06-22T13:30:11.170697+03:00 | 4 | 1120 | {} | [905, 662, 661] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2229 | [] | Laajamittainen kaksikielinen opetus (suomi-englanti) | Omfattande undervisning på två språk (finska-engelska) | Extensive bilingual education (Finnish-English) | 661*904+662*904 | 2020-06-22T13:30:11.121789+03:00 | 4 | 1120 | {} | [904, 662, 661] | 1 | 1087 | 8 | 9 | 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 | |||||||||||||||||||||||||||||||||
2227 | [] | Kielirikasteinen opetus (suomi-englanti) | Språkberikande undervisning (finska-engelska) | Language-enriched education (Finnish-English) | 661*910+662*910 | 2020-06-22T13:30:11.061581+03:00 | 4 | 1120 | {} | [910, 662, 661] | 1 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
2216 | [] | Valmistava opetus luokille 7-9 | Förbererande undervisning för årskurserna 7-9 | Preparatory education for grades 7-9 | 894 | 2020-05-08T12:30:12.979716+03:00 | 3 | 1098 | {} | [894] | 1 | 1087 | 9 | 9 | |||||||||||||||||||||||||||||||||
2215 | [] | Valmistava opetus luokille 3-6 | Förbererande undervisning för årskurserna 3-6 | Preparatory education for grades 3-6 | 893 | 2020-05-08T12:30:12.951754+03:00 | 3 | 1098 | {} | [893] | 1 | 1087 | 13 | 13 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2129 | [] | 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:09.527795+03:00 | 3 | 2126 | {} | [862, 603, 160] | 1 | 1405 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
2128 | [] | 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:09.534871+03:00 | 3 | 2126 | {} | [862, 601, 159] | 1 | 1405 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
2127 | [] | Esi- ja starttiopetus | Förskoleundervisning, startklasser | Pre-primary and start class education | 595 | 2018-10-25T08:00:09.543127+03:00 | 3 | 2126 | {} | [595] | 1 | 1405 | 2 | 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 | |||||||||||||||||||||||||||||||
2125 | [] | Päivähoidon järjestämä esiopetus | Förskoleundervisning som ordnas av dagvården | Pre-primary education organised by day care | 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 | 2019-06-20T11:30:22.256470+03:00 | 3 | 2122 | {} | [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] | 1 | 1405 | 289 | 483 | 78 | 116 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
1296 | [] | Painotettu lukio | Gymnasium med betoning | Specialised upper secondary school | 148*493+161*493+300*493+383*493+566*493+611*493+658*493+770*493+792*493 | 2018-10-25T08:00:08.739223+03:00 | 3 | 1258 | {} | [792, 770, 658, 611, 566, 493, 383, 300, 161, 148] | 1 | 1087 | 12 | 17 | 5 | ||||||||||||||||||||||||||||||||
1294 | [] | B-venäjä | B-ryska | B-Russian | 148*99+161*99+300*99+383*99+566*99+611*99+658*99+770*99+792*99 | 2018-10-25T08:00:08.723952+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 99] | 1 | 1087 | 6 | 12 | 1 | 5 | |||||||||||||||||||||||||||||||
1293 | [] | B-saksa | B-tyska | B-German | 148*97+161*97+300*97+383*97+566*97+611*97+658*97+770*97+792*97 | 2018-10-25T08:00:08.715851+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 97] | 1 | 1087 | 10 | 26 | 11 | 5 | |||||||||||||||||||||||||||||||
1292 | [] | B-ranska | B-franska | B-French | 148*95+161*95+300*95+383*95+566*95+611*95+658*95+770*95+792*95 | 2018-10-25T08:00:08.707519+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 95] | 1 | 1087 | 10 | 26 | 11 | 5 | |||||||||||||||||||||||||||||||
1290 | [] | B-latina | B-latin | B-Latin | 148*93+161*93+300*93+383*93+566*93+611*93+658*93+770*93+792*93 | 2018-10-25T08:00:08.690591+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 93] | 1 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1289 | [] | B-kiina | B-kinesiska | B-Chinese | 148*92+161*92+300*92+383*92+566*92+611*92+658*92+770*92+792*92 | 2018-10-25T08:00:08.681673+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 92] | 1 | 1087 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
1288 | [] | B-japani | B-japanska | B-Japanese | 148*91+161*91+300*91+383*91+566*91+611*91+658*91+770*91+792*91 | 2018-10-25T08:00:08.673017+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 91] | 1 | 1087 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1287 | [] | B-italia | B-italienska | B-Italian | 148*90+161*90+300*90+383*90+566*90+611*90+658*90+770*90+792*90 | 2018-10-25T08:00:08.665268+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 90] | 1 | 1087 | 3 | 8 | 4 | 1 | |||||||||||||||||||||||||||||||
1286 | [] | B-espanja | B-spanska | B-Spanish | 148*89+161*89+300*89+383*89+566*89+611*89+658*89+770*89+792*89 | 2018-10-25T08:00:08.657538+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 89] | 1 | 1087 | 9 | 24 | 10 | 5 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1284 | [] | B-ruotsi | B-svenska | B-Swedish | 148*96+161*96+300*96+383*96+566*96+611*96+658*96+770*96+792*96 | 2018-10-25T08:00:08.642605+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 96] | 1 | 1087 | 11 | 27 | 11 | 5 | |||||||||||||||||||||||||||||||
1282 | [] | A-venäjä | A-ryska | A-Russian | 148*14+161*14+300*14+383*14+566*14+611*14+658*14+770*14+792*14 | 2018-10-25T08:00:08.627334+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 14] | 1 | 1087 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
1281 | [] | A-saksa | A-tyska | A-German | 148*12+161*12+300*12+383*12+566*12+611*12+658*12+770*12+792*12 | 2018-10-25T08:00:08.618606+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 12] | 1 | 1087 | 7 | 20 | 9 | 4 | |||||||||||||||||||||||||||||||
1280 | [] | A-ranska | A-franska | A-French | 148*10+161*10+300*10+383*10+566*10+611*10+658*10+770*10+792*10 | 2018-10-25T08:00:08.609701+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 10] | 1 | 1087 | 7 | 16 | 5 | 4 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1275 | [] | A-espanja | A-spanska | A-Spanish | 148*5+161*5+300*5+383*5+566*5+611*5+658*5+770*5+792*5 | 2018-10-25T08:00:08.569813+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 5] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1274 | [] | A-englanti | A-engelska | A-English | 148*4+161*4+300*4+383*4+566*4+611*4+658*4+770*4+792*4 | 2018-10-25T08:00:08.562076+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 4] | 1 | 1087 | 12 | 27 | 10 | 5 | |||||||||||||||||||||||||||||||
1273 | [] | A-ruotsi | A-svenska | A-Swedish | 148*11+161*11+300*11+383*11+566*11+611*11+658*11+770*11+792*11 | 2018-10-25T08:00:08.554488+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 11] | 1 | 1087 | 9 | 25 | 11 | 5 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1270 | [] | Erityistehtävän mukainen lukiokoulutus | Gymnasieutbildning med särskild uppgift | Upper secondary school education with special curriculum | 148*157+161*157+300*157+383*157+566*157+611*157+658*157+770*157+792*157 | 2018-10-25T08:00:08.535976+03:00 | 4 | 1268 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 157, 148] | 1 | 1087 | 6 | 9 | 3 | ||||||||||||||||||||||||||||||||
1269 | [] | Yleislinjan lukiokoulutus | Gymnasieutbildning, allmän linje | Upper secondary school education, general programme | 148*816+161*816+300*816+383*816+566*816+611*816+658*816+770*816+792*816 | 2018-10-25T08:00:08.527922+03:00 | 4 | 1268 | {} | [816, 792, 770, 658, 611, 566, 383, 300, 161, 148] | 1 | 1087 | 14 | 30 | 11 | 5 | |||||||||||||||||||||||||||||||
1260 | [] | Englanninkielinen lukiokoulutus | gymnasieutbildning på engelska | general upper secondary education in English | 148 | 2018-10-25T08:00:08.503752+03:00 | 3 | 1258 | {"fi": ["englanti"]} | [148] | 1 | 1087 | 3 | 5 | 1 | 1 | |||||||||||||||||||||||||||||||
1259 | [] | Suomenkielinen lukiokoulutus | gymnasieutbildning på finska | general upper secondary education in Finnish | 658 | 2018-10-25T08:00:08.498186+03:00 | 3 | 1258 | {"fi": ["suomi"]} | [658] | 1 | 1087 | 30 | 52 | 14 | 8 | |||||||||||||||||||||||||||||||
1255 | [] | Sairaalaopetus | Sjukhusundervisning | Hospital education | 609 | 2018-08-07T14:00:26.759479+03:00 | 2 | 1097 | {} | [609] | 1 | 1087 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1238 | [] | B2-ranska | B2-franska | B2-French | 601*119+602*119 | 2018-10-25T08:00:08.435500+03:00 | 4 | 1193 | {} | [602, 601, 119] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1233 | [] | B2-espanja | B2-spanska | B2-Spanish | 601*114+602*114 | 2018-10-25T08:00:08.398971+03:00 | 4 | 1193 | {} | [602, 601, 114] | 1 | 1087 | 4 | 4 | |||||||||||||||||||||||||||||||||
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 |
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 );