service_node

207 rows where root = 1087

✎ View and edit SQL

This data as json, CSV (advanced)

root ✖

  • 1087 · 107 ✖
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ää
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              
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              
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              
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              
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                      
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              
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              
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              
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                      
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              
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              
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              
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              
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              
1298 [1303, 1300, 1328, 1299] Ruotsinkielinen nuorten lukiokoulutus Gymnasieutbildning för unga på svenska General upper secondary education for the young in Swedish   2020-03-06T18:32:08.157237+02:00 2 1257 {} [] 0 1087 7 10                                           2       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              
1300 [1302, 1301] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:27.088539+03:00 3 1298 {} [] 0 1087 3 5                                           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                                                                  
1303 [1306, 1312, 1313, 1304, 1317, 1318, 1319, 1321, 1324, 1325, 1315, 1326] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:27.110966+03:00 3 1298 {} [] 0 1087 3 4                                                   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              
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} [] 0 1087 5 11                                           2       3     1        
1336 [1340, 1337, 1341, 1338, 1342] Suomen- ja vieraskielinen aikuisten perus- ja lukiokoulutus Grundläggande utbildning och gymnasieutbildning för vuxna på finska och främmande språk Comprehensive and upper secondary school education for adults in Finnish, English and other languages   2020-03-06T18:32:08.302751+02:00 2 1335 {} [] 0 1087 3 8                                           2       3              
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                                                                  
1343 [1346, 1344, 1347, 1345] Ruotsinkielinen aikuisten perus- ja lukiokoulutus Grundläggande utbildning och gymnasieutbildning för vuxna på svenska Comprehensive and upper secondary school education for adults in Swedish   2018-08-07T14:00:27.400544+03:00 2 1335 {} [] 0 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                                                                  
1353 [1355, 1354] Oppisopimuskoulutus Läroavtalsutbildning Apprenticeship training   2018-08-07T14:00:27.464000+03:00 1 1087 {} [] 0 1087 1 2                                                   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                                                                  
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} [654] 0 1087 1 2                                                         1        
1357 [] Suomenkielinen ammattikorkeakoulukoulutus Yrkeshögskoleutbildning på finska Polytechnic education in Finnish 654 2018-08-07T14:00:27.490338+03:00 2 1356 {} [654] 0 1087 1 2                                                         1        
1359 [] Yliopistot Universitet Universities 822 2018-08-07T14:00:27.510881+03:00 1 1087 {} [822] 0 1087 10 60                                           50                      
1360 [2212, 1371, 1369, 1370, 1365, 1361] Vapaa sivistystyö Fritt bildningsarbete General educational work   2020-11-18T07:30:12.838195+02:00 1 1087 {} [] 0 1087 56 97                                           9       28     4        
1361 [1362, 1363] Suomenkielinen työväenopisto Finska arbetarinstitutet Finnish adult education centre 665 2020-11-18T07:30:12.844488+02:00 2 1360 {} [665] 0 1087 50 59                                           7             2        
1362 [] Asiakaspalvelu Kundtjänst Customer services 665*66 2020-11-18T07:30:12.851359+02:00 3 1361 {} [665, 66] 0 1087 7 9                                           1             1        
1363 [] Opetuspaikat Verksamhetsställen Teaching locations 665*727 2020-11-18T07:30:12.858775+02:00 3 1361 {} [727, 665] 0 1087 44 46                                           1             1        
1365 [1366, 1368, 1367] Ruotsinkielinen työväenopisto Svenska arbetarinstitutet Swedish adult education centre 605 2020-11-18T07:30:12.874521+02:00 2 1360 {} [605] 0 1087 6 9                                           1             2        
1366 [] Asiakaspalvelu Kundtjänst Customer services 605*66 2020-11-18T07:30:12.883321+02:00 3 1365 {} [605, 66] 0 1087 2 3                                                         1        
1367 [] Opetuspaikat Verksamhetsställen Teaching locations 605*727 2020-11-18T07:30:12.891173+02:00 3 1365 {} [727, 605] 0 1087 2 3                                                         1        
1368 [] Kirjasto Bibliotek Library 605*313 2020-11-18T07:30:12.898026+02:00 3 1365 {} [605, 313] 0 1087 1 1                                                                  
1369 [] Kuvataidekoulu Konstskola School of visual arts 360 2020-11-18T07:30:12.906446+02:00 2 1360 {} [360] 0 1087   7                                                   6     1        
1370 [] Musiikkiopisto Musikinstitut Music institute 456 2020-11-18T07:30:12.915030+02:00 2 1360 {} [456] 0 1087   20                                                   19     1        
1371 [] Kansanopisto Folkhögskola Folk high school 244 2020-11-18T07:30:12.932144+02:00 2 1360 {} [244] 0 1087   3                                           1             2        
1372 [1373, 1374, 1375] Oppilas- ja opiskelijahuolto Elevvård Pupil and student care   2018-08-07T14:00:27.603403+03:00 1 1087 {} [] 0 1087 241 388                               1           2       136 1   7        
1373 [2165, 2167] Koulu- ja opiskeluterveydenhuolto Skol- och studenthälsovård School and student health services   2018-10-25T08:00:08.960295+03:00 2 1372 {} [] 0 1087 241 320                               1           2       68 1   7        
1374 [] Koulukuraattori Skolkurator School social worker 340 2018-08-07T14:00:27.634259+03:00 2 1372 {} [340] 0 1087   71                                                   66     5        
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} [343] 0 1087   2                                                   2              
1376 [] Koulu- ja opiskelijaruokailu Måltider för elever och studerande Meals for pupils and students 338 2020-08-20T14:00:09.319013+03:00 1 1087 {} [338] 0 1087 119 136                                           12       4     1        
1377 [] Oppilaan ja opiskelijan tuet Förmåner för elever och studerande Pupil and student benefits 485 2018-08-07T14:00:27.654181+03:00 1 1087 {} [485] 0 1087 4 15       1                                   7       2         1    
1378 [1381, 2080, 1380, 1379] Kasvatuksen ja koulutuksen neuvonta Rådgivning om fostran och utbildning Day care and education information and advice   2018-08-07T14:00:27.660874+03:00 1 1087 {} [] 0 1087 4 6                                           2                      
1379 [] Perusopetuksen neuvonta Kundbetjäning och rådgivning (grundläggande utbildning) Customer service and information (basic education) 70 2018-08-07T14:00:27.673059+03:00 2 1378 {} [70] 0 1087 1 2                                           1                      
1380 [] Lukiokoulutuksen neuvonta Kundbetjäning och rådgivning (gymnasieutbildning) Customer service and information (general upper secondary education) 69 2018-08-07T14:00:27.679921+03:00 2 1378 {} [69] 0 1087 1 2                                           1                      
1381 [] Ammatillisen koulutuksen neuvonta Kundbetjäning och rådgivning (yrkesutbildning) Customer service and information (vocational education and training) 68 2018-08-07T14:00:27.686734+03:00 2 1378 {} [68] 0 1087 3 5                                           2                      
1382 [] Hallinto Förvaltning Administration 179 2018-08-07T14:00:27.693663+03:00 1 1087 {} [179] 0 1087 12 12                                                                  
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              
2042 [2056, 2049] Aamu- ja iltapäivätoiminta Morgon- och eftermiddagsverksamhet Morning and afternoon activities   2018-08-07T14:00:25.343707+03:00 1 1087 {} [] 0 1087 208 223                                           11       4              
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                                                                  
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                                                                  
2080 [] Lasten päivähoidon neuvonta Kundbetjäning och rådgivning (barndagvård) Customer service and information (child day care) 844 2018-08-07T14:00:27.666416+03:00 2 1378 {} [844] 0 1087 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                      
2165 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:27.619794+03:00 3 1373 {} [339] 0 1087 160 236                               1           1       68 1   5        
2167 [] Opiskeluterveydenhuolto Studenthälsovård Student health care 863 2018-08-07T14:00:27.627209+03:00 3 1373 {} [863] 0 1087 81 154                                           2       68     3        
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                                                                  
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                                                                  
2179 [2186, 2200, 2181, 2180] Ammatillinen koulutus Yrkesutbildning Vocational education   2018-08-31T16:00:09.179533+03:00 1 1087 {} [] 0 1087 18 24                                           2       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              
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              
2212 [] Kansalaisopisto Medborgarinstitut Community college 890 2020-11-18T07:30:12.923359+02:00 2 1360 {} [890] 0 1087   3                                                   3              
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                                                                  
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                                                                  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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
);