service
179 rows where root_service_node = 1087
This data as json, CSV (advanced)
| id ▼ | name_fi | name_sv | name_en | period_enabled | clarification_enabled | keywords | root_service_node | 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_null | unit_count_municipality_nurmijärvi | unit_count_municipality_virolahti | unit_count_municipality_pornainen | unit_count_municipality_hämeenlinna | unit_count_municipality_salo | 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_kotka | unit_count_municipality_askola | 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_karkkila | unit_count_municipality_järvenpää | unit_count_municipality_kerava | unit_count_municipality_pyhtää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 793 | vironkielinen perusopetus luokille 1-6 | grundläggande utbildning på estniska för årskurserna 1-6 | basic education for grades 1-6 in Estonian | 1 | 0 | {} | 1087 | 0 | ||||||||||||||||||||||||||||||||||
| 794 | vironkielinen perusopetus luokille 7-9 | grundläggande utbildning på estniska för årskurserna 7-9 | basic education for grades 7-9 in Estonian | 1 | 0 | {} | 1087 | 0 | ||||||||||||||||||||||||||||||||||
| 816 | yleislinjan mukaiset lukiot | gymnasier med en allmän linje | general upper secondary schools | 1 | 0 | {} | 1087 | 16 | 33 | 11 | 6 | |||||||||||||||||||||||||||||||
| 822 | yliopistot | universitet | universities | 0 | 0 | {} | 1087 | 10 | 60 | 50 | ||||||||||||||||||||||||||||||||
| 843 | valmistava opetus luokille 1-2 (maahanmuuttajat) | förberedande undervisning för årskurserna 1-2 (invandrare) | preparatory education for grades 1-2 (immigrants) | 1 | 0 | {} | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 844 | asiakaspalvelu ja neuvonta (lasten päivähoito) | kundbetjäning och rådgivning (barndagvård) | customer service and information (child day care) | 0 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 863 | opiskeluterveydenhuolto | studenthälsovård | student health care | 0 | 0 | {} | 1087 | 81 | 154 | 2 | 68 | 3 | ||||||||||||||||||||||||||||||
| 865 | saamenkielinen perusopetus luokille 1-6 | grundläggande utbildning på samiska för årskurserna 1-6 | basic education for grades 1-6 in Sami | 1 | 0 | {} | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 866 | saamenkielinen perusopetus luokille 7-9 | grundläggande utbildning på samiska för årskurserna 7-9 | basic education for grades 7-9 in Sami | 1 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 870 | B2-japani (perusopetuksen kieliohjelma) | B2-japanska (språkprogrammet för den grundläggande utbildningen) | B2-Japanese (basic education language programme) | 1 | 0 | {} | 1087 | 0 | ||||||||||||||||||||||||||||||||||
| 871 | A1-englanti paluuoppilaille (perusopetuksen kieliohjelma) | A1-engelska för återvändande elever (språkprogrammet för den grundläggande utbildningen) | A1-English for repatriating pupils (basic education language programme) | 1 | 0 | {} | 1087 | 0 | ||||||||||||||||||||||||||||||||||
| 872 | ammatillinen peruskoulutus | grundläggande yrkesutbildning | vocational upper secondary education and training | 1 | 1 | {} | 1087 | 63 | 98 | 2 | 33 | |||||||||||||||||||||||||||||||
| 873 | ammatillinen lisäkoulutus | yrkesinriktad tilläggsutbildning | vocational further education and training | 1 | 1 | {} | 1087 | 35 | 37 | 2 | ||||||||||||||||||||||||||||||||
| 883 | englanninkielinen ammatillinen koulutus | yrkesutbildning på engelska | vocational education and training in English | 1 | 1 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 890 | kansalaisopistot | medborgarinstitut | community colleges | 0 | 0 | {} | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 893 | valmistava opetus luokille 3-6 | förbererande undervisning för årskurserna 3-6 | preparatory education for grades 3-6 | 1 | 0 | {} | 1087 | 13 | 13 | |||||||||||||||||||||||||||||||||
| 894 | valmistava opetus luokille 7-9 | förbererande undervisning för årskurserna 7-9 | preparatory education for grades 7-9 | 1 | 0 | {} | 1087 | 9 | 9 | |||||||||||||||||||||||||||||||||
| 904 | laajamittainen kaksikielinen opetus (suomi-englanti) | omfattande undervisning på två språk (finska-engelska) | extensive bilingual education (Finnish-English) | 1 | 0 | {} | 1087 | 8 | 9 | 1 | ||||||||||||||||||||||||||||||||
| 905 | laajamittainen kaksikielinen opetus (suomi-kiina) | omfattande undervisning på två språk (finska-kinesiska) | extensive bilingual education (Finnish-Chinese) | 1 | 0 | {} | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 906 | laajamittainen kaksikielinen opetus (suomi-espanja) | omfattande undervisning på två språk (finska-spanska) | extensive bilingual education (Finnish-Spanish) | 1 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 907 | laajamittainen kaksikielinen opetus (suomi-pohjoissaame) | omfattande undervisning på två språk (finska-nordsamiska) | extensive bilingual education (Finnish-Northern Sami) | 1 | 0 | {} | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 908 | laajamittainen kaksikielinen opetus (suomi-viro) | omfattande undervisning på två språk (finska-estinska) | extensive bilingual education(Finnish-Estonian) | 1 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 909 | laajamittainen kaksikielinen opetus (suomi-venäjä) | omfattande undervisning på två språk (finska-ryska) | extensive bilingual education (Finnish-Russian) | 1 | 0 | {} | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 910 | kielirikasteinen opetus (suomi-englanti) | språkberikande undervisning (finska-engelska) | language-enriched education (Finnish-English) | 1 | 0 | {} | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
| 911 | kielirikasteinen opetus (suomi-venäjä) | språkberikande undervisning (finska-ryska) | language-enriched education (Finnish-Russian) | 1 | 0 | {} | 1087 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [service] ( [name_fi] TEXT, [name_sv] TEXT, [name_en] TEXT, [id] INTEGER PRIMARY KEY, [period_enabled] INTEGER, [clarification_enabled] INTEGER, [keywords] TEXT, [root_service_node] 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_null] INTEGER, [unit_count_municipality_nurmijärvi] TEXT, [unit_count_municipality_virolahti] TEXT, [unit_count_municipality_pornainen] TEXT, [unit_count_municipality_hämeenlinna] TEXT, [unit_count_municipality_salo] 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] TEXT, [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_kotka] TEXT, [unit_count_municipality_askola] TEXT, [unit_count_municipality_mäntsälä] TEXT, [unit_count_municipality_vantaa] INTEGER, [unit_count_municipality_hyvinkää] TEXT, [unit_count_municipality_vihti] TEXT, [unit_count_municipality_kauniainen] INTEGER, [unit_count_municipality_karkkila] TEXT, [unit_count_municipality_järvenpää] TEXT, [unit_count_municipality_kerava] TEXT, [unit_count_municipality_pyhtää] TEXT );