service_node
43 rows where level = 3 and period_enabled = 1
This data as json, CSV (advanced)
Suggested facets: children, name_fi, name_sv, name_en, parent, keywords, root, unit_count_municipality_helsinki, unit_count_total, 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 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 1090 | [] | 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:19.029713+03:00 | 3 | 1089 | {} | [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] | 1 | 1087 | 289 | 483 | 78 | 116 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 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 |
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 );