service_node

207 rows where root = 1087 sorted by unit_count_municipality_vantaa

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, keywords, period_enabled, unit_count_municipality_lohja, unit_count_municipality_espoo, unit_count_municipality_vantaa, unit_count_municipality_hyvinkää, unit_count_municipality_kauniainen, last_modified_time (date)

root ✖

  • 1087 · 207 ✖
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ää
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                      
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                      
1102 [] ranskankielinen opetus undervisning på franska education in French 567 2018-08-07T14:00:25.502701+03:00 4 1099 {} [567] 1 1087 1 1                                                                  
1103 [] saksankielinen opetus undervisning på tyska education in German 612 2018-08-07T14:00:25.517491+03:00 4 1099 {} [612] 1 1087 1 1                                                                  
1104 [] venäjänkielinen opetus undervisning på ryska education in Russian 771 2018-08-07T14:00:25.524519+03:00 4 1099 {} [771] 1 1087 1 1                                                                  
1112 [] ranskankielinen opetus undervisning på franska education in French 568 2018-08-07T14:00:25.599261+03:00 4 1109 {} [568] 1 1087 1 1                                                                  
1113 [] saksankielinen opetus undervisning på tyska education in German 613 2018-08-07T14:00:25.613385+03:00 4 1109 {} [613] 1 1087 1 1                                                                  
1114 [] venäjänkielinen opetus undervisning på ryska education in Russian 772 2018-08-07T14:00:25.622338+03:00 4 1109 {} [772] 1 1087 1 1                                                                  
1122 [] A1-ruotsi A1-svenska A1-Swedish 149*22+150*22+162*22+163*22+301*22+302*22+384*22+385*22+567*22+568*22+612*22+613*22+661*22+662*22+771*22+772*22+793*22+794*22+865*22+866*22 2018-10-25T08:00:07.687212+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 22] 1 1087 43 50                                           7                      
1124 [] A1-espanja A1-spanska A1-Spanish 149*16+150*16+162*16+163*16+301*16+302*16+384*16+385*16+567*16+568*16+612*16+613*16+661*16+662*16+771*16+772*16+793*16+794*16+865*16+866*16 2018-10-25T08:00:07.713876+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 16] 1 1087 15 15                                                                  
1127 [] A1-kiina A1-kinesiska A1-Chinese 149*19+150*19+162*19+163*19+301*19+302*19+384*19+385*19+567*19+568*19+612*19+613*19+661*19+662*19+771*19+772*19+793*19+794*19+865*19+866*19 2018-10-25T08:00:07.741562+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 19] 1 1087 3 4                                           1                      
1129 [] A1-ranska A1-franska A1-French 149*21+150*21+162*21+163*21+301*21+302*21+384*21+385*21+567*21+568*21+612*21+613*21+661*21+662*21+771*21+772*21+793*21+794*21+865*21+866*21 2018-10-25T08:00:07.759368+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 21] 1 1087 42 50                                           8                      
1130 [] A1-saksa A1-tyska A1-German 149*23+150*23+162*23+163*23+301*23+302*23+384*23+385*23+567*23+568*23+612*23+613*23+661*23+662*23+771*23+772*23+793*23+794*23+865*23+866*23 2018-10-25T08:00:07.768212+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 23] 1 1087 28 40                                           12                      
1131 [] A1-venäjä A1-ryska A1-Russian 149*25+150*25+162*25+163*25+301*25+302*25+384*25+385*25+567*25+568*25+612*25+613*25+661*25+662*25+771*25+772*25+793*25+794*25+865*25+866*25 2018-10-25T08:00:07.777104+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 25] 1 1087 6 6                                                                  
1135 [] A2-englanti A2-engelska A2-English 149*27+150*27+162*27+163*27+301*27+302*27+384*27+385*27+567*27+568*27+612*27+613*27+661*27+662*27+771*27+772*27+793*27+794*27+865*27+866*27 2018-10-25T08:00:07.813754+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 27] 1 1087 81 100                                           19                      
1139 [] A2-kiina A2-kinesiska A2-Chinese 149*31+150*31+162*31+163*31+301*31+302*31+384*31+385*31+567*31+568*31+612*31+613*31+661*31+662*31+771*31+772*31+793*31+794*31+865*31+866*31 2018-10-25T08:00:07.849979+03:00 4 1120 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 31] 1 1087 2 4                                           2                      
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                      
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                                                                  
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                                                                  
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                      
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                      
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                      
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
1242 [1244, 1245] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.661731+03:00 3 1187 {} [] 0 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                                                                  
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                                                                  
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                      
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                      
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                                                                  
1255 [] Sairaalaopetus Sjukhusundervisning Hospital education 609 2018-08-07T14:00:26.759479+03:00 2 1097 {} [609] 1 1087 3 5                                           2                      
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                      
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                                                                  
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                      
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                      
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                      
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                                                                  
1371 [] Kansanopisto Folkhögskola Folk high school 244 2020-11-18T07:30:12.932144+02:00 2 1360 {} [244] 0 1087   3                                           1             2        
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                                                                  
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                                                                  
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                      
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                      
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                                                                  
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                      
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                                                                  

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