service_node
360 rows where level = 4 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: children, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, last_modified_time (date)
keywords ✖
- {} 352
- {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 4
- {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 2
- {"fi": ["suomi"]} 1
- {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2239 | [] | päivähoito | dagvård | day care | 913 | 2020-10-02T12:00:13.926103+03:00 | 4 | 2238 | {} | [913] | 0 | 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 | |||||||||||||||||||||||||||||||||
2209 | [] | Asukastilat | Invånarlokaler | Resident facilities | 888 | 2019-10-22T09:30:10.261582+03:00 | 4 | 149 | {} | [888] | 0 | 1401 | 1 | 12 | 2 | 9 | |||||||||||||||||||||||||||||||
2199 | [] | Veneiden lyhytaikainen kiinnittyminen | Kortvarig förtöjning av båtar | Short-term mooring of boats | 881 | 2019-05-08T14:30:08.752556+03:00 | 4 | 547 | {} | [881] | 0 | 1402 | 4 | 4 | |||||||||||||||||||||||||||||||||
2198 | [] | Veneiden lyhytaikainen kiinnittyminen | Kortvarig förtöjning av båtar | Short-term mooring of boats | 881 | 2019-05-08T14:30:08.739155+03:00 | 4 | 542 | {} | [881] | 0 | 1402 | 4 | 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 | |||||||||||||||||||||||||||||||||
2150 | [] | Tietotekniikkaneuvonta opiskelijoille | IT rådgivning för studenter | IT consultancy for students | 848 | 2018-08-07T14:00:24.978309+03:00 | 4 | 2149 | {} | [848] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
2148 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:24.771984+03:00 | 4 | 2147 | {} | [199] | 0 | 1402 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2144 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 776 | 2018-08-07T14:00:25.224191+03:00 | 4 | 542 | {} | [776] | 0 | 1402 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
2142 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.242377+03:00 | 4 | 547 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
2138 | [] | Ammatillisen koulutuksen neuvonta | Kundbetjäning och rådgivning (yrkesutbildning) | Customer service and information (vocational education and training) | 68 | 2018-08-07T14:00:24.750620+03:00 | 4 | 317 | {} | [68] | 0 | 1402 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
2137 | [] | Lukiokoulutuksen neuvonta | Kundbetjäning och rådgivning (gymnasieutbildning) | Customer service and information (general upper secondary education) | 69 | 2018-08-07T14:00:24.743644+03:00 | 4 | 317 | {} | [69] | 0 | 1402 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2136 | [] | Perusopetuksen neuvonta | Kundbetjäning och rådgivning (grundläggande utbildning) | Customer service and information (basic education) | 70 | 2018-08-07T14:00:24.736470+03:00 | 4 | 317 | {} | [70] | 0 | 1402 | 1 | 2 | 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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
2009 | [] | Koiraurheiluhalli | Hundsporthall | Dog sports hall | 323 | 2018-08-07T14:00:23.274980+03:00 | 4 | 2007 | {} | [323] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2008 | [] | Koiraurheilualue | Område för hundsport | Dog sports area | 322 | 2018-08-07T14:00:23.268249+03:00 | 4 | 2007 | {} | [322] | 0 | 1403 | 7 | 10 | 3 | ||||||||||||||||||||||||||||||||
2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
2004 | [] | Hallinnolliset toimipisteet | Administrativa ämbetsverk | Administrative offices | 271 | 2018-08-07T14:00:30.391457+03:00 | 4 | 173 | {} | [271] | 0 | 1401 | 55 | 65 | 1 | 1 | 7 | 1 | |||||||||||||||||||||||||||||
2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1208 | [] | A2-englanti | A2-engelska | A2-English | 601*27+602*27 | 2018-10-25T08:00:08.293365+03:00 | 4 | 1193 | {} | [602, 601, 27] | 1 | 1087 | 20 | 25 | 5 | ||||||||||||||||||||||||||||||||
1194 | [] | A1-suomi | A1-finska | A1-Finnish | 601*24+602*24 | 2018-10-25T08:00:08.223234+03:00 | 4 | 1193 | {} | [602, 601, 24] | 1 | 1087 | 21 | 26 | 5 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1172 | [] | 7. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 7 | special emphasis starting from 7th grade | 150*3+163*3+302*3+385*3+568*3+613*3+662*3+772*3+794*3+866*3 | 2018-10-25T08:00:08.139111+03:00 | 4 | 1169 | {} | [866, 794, 772, 662, 613, 568, 385, 302, 163, 150, 3] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
1171 | [] | 3. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 3 | special emphasis starting from 3rd grade | 149*2+162*2+301*2+384*2+567*2+612*2+661*2+771*2+793*2+865*2 | 2018-10-25T08:00:08.131695+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 2] | 1 | 1087 | 11 | 15 | 4 | ||||||||||||||||||||||||||||||||
1170 | [] | 1. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 1 | special emphasis starting from 1st grade | 149*1+162*1+301*1+384*1+567*1+612*1+661*1+771*1+793*1+865*1 | 2018-10-25T08:00:08.124175+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 1] | 1 | 1087 | 10 | 10 | |||||||||||||||||||||||||||||||||
1167 | [] | B2-venäjä | B2-ryska | B2-Russian | 149*123+150*123+162*123+163*123+301*123+302*123+384*123+385*123+567*123+568*123+612*123+613*123+661*123+662*123+771*123+772*123+793*123+794*123+865*123+866*123 | 2018-10-25T08:00:08.105027+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 123] | 1 | 1087 | 10 | 12 | 2 | ||||||||||||||||||||||||||||||||
1166 | [] | B2-saksa | B2-tyska | B2-German | 149*121+150*121+162*121+163*121+301*121+302*121+384*121+385*121+567*121+568*121+612*121+613*121+661*121+662*121+771*121+772*121+793*121+794*121+865*121+866*121 | 2018-10-25T08:00:08.096555+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 121] | 1 | 1087 | 43 | 71 | 25 | 3 | |||||||||||||||||||||||||||||||
1165 | [] | B2-ranska | B2-franska | B2-French | 149*119+150*119+162*119+163*119+301*119+302*119+384*119+385*119+567*119+568*119+612*119+613*119+661*119+662*119+771*119+772*119+793*119+794*119+865*119+866*119 | 2018-10-25T08:00:08.088270+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 119] | 1 | 1087 | 48 | 72 | 22 | 2 | |||||||||||||||||||||||||||||||
1164 | [] | B2-latina | B2-latin | B2-Latin | 149*118+150*118+162*118+163*118+301*118+302*118+384*118+385*118+567*118+568*118+612*118+613*118+661*118+662*118+771*118+772*118+793*118+794*118+865*118+866*118 | 2018-10-25T08:00:08.080049+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 118] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1163 | [] | B2-kiina | B2-kinesiska | B2-Chinese | 149*117+150*117+162*117+163*117+301*117+302*117+384*117+385*117+567*117+568*117+612*117+613*117+661*117+662*117+771*117+772*117+793*117+794*117+865*117+866*117 | 2018-10-25T08:00:08.071757+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 117] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
1160 | [] | B2-espanja | B2-spanska | B2-Spanish | 149*114+150*114+162*114+163*114+301*114+302*114+384*114+385*114+567*114+568*114+612*114+613*114+661*114+662*114+771*114+772*114+793*114+794*114+865*114+866*114 | 2018-10-25T08:00:08.038588+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 114] | 1 | 1087 | 23 | 31 | 7 | 1 | |||||||||||||||||||||||||||||||
1147 | [] | B1-englanti | B1-engelska | B1-English | 149*101+150*101+162*101+163*101+301*101+302*101+384*101+385*101+567*101+568*101+612*101+613*101+661*101+662*101+771*101+772*101+793*101+794*101+865*101+866*101 | 2018-10-25T08:00:07.920873+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 101] | 1 | 1087 | 7 | 7 | |||||||||||||||||||||||||||||||||
1146 | [] | B1-ruotsi | B1-svenska | B1-Swedish | 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 | 2018-10-25T08:00:07.912218+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108] | 1 | 1087 | 107 | 205 | 1 | 72 | 24 | 1 |
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 );