service_node

1,140 rows sorted by name_fi

✎ View and edit SQL

This data as json, CSV (advanced)

unit_count_municipality_hyvinkää ✖

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ää
124 [] Avoimet työpaikat Lediga jobb Open jobs 84 2018-08-07T14:00:30.009390+03:00 2 122 {} [84] 0 1401 5 7                                           1       1              
375 [] Avoin nuorisotoiminta Öppen ungdomsverksamhet Open youth activities 85 2018-08-07T14:00:22.911924+03:00 3 368 {} [85] 0 1403 41 78                                           22       14     1        
976 [] Avoin toiminta Öppen verksamhet Open family activities 86 2019-03-05T14:30:09.650822+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [86] 0 1405 2 31                                           13       15     1        
220 [] Avustusten sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för bidragsärenden Electronic services and forms related to benefits 87 2018-08-07T14:00:30.732707+03:00 3 219 {} [87] 0 1401   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                      
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                                                                  
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              
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              
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              
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                                                                  
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                      
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                                                                  
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              
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              
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              
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              
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              
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                                                                  
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              
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                                                                  
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            
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                                                                  
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              
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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                                                                  
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              
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                                                                  
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              
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                                                                  
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                      
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                                                                  
2174 [] Baarit ja yöelämä Barer och nattliv Bars and nightlife 869 2018-08-07T14:00:24.408116+03:00 3 718 {} [869] 0 1403 179 181                                                   2              
655 [] Beachvolleykenttä Beachvolleyplan Beach volleyball court 125 2018-08-07T14:00:23.954884+03:00 4 654 {} [125] 0 1403 39 85                                           27       18     1        
376 [] Biljardi Biljard Billiards 126 2018-08-07T14:00:22.918484+03:00 3 368 {} [126] 0 1403   16                                           13       3              
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} [127] 0 1400 2 4                                           1       1              
378 [] Bänditoiminta/-tila Bandverksamhet eller bandlokal Band activity or practice space 128 2018-08-07T14:00:22.924860+03:00 3 368 {} [128] 0 1403 2 12                                           5       5              
568 [] Curlingrata Curlingbana Curling sheet 129 2018-08-07T14:00:23.345064+03:00 4 567 {} [129] 0 1403 1 1                                                                  
756 [757, 763] Demokratia Demokrati Democracy   2018-08-07T14:00:30.749902+03:00 2 755 {} [] 0 1401 8 13                                           3       1     1        
381 [] Demostudio Demostudio Demo studio 130 2018-08-07T14:00:22.931253+03:00 3 368 {} [130] 0 1403 1 2                                                   1              
2162 [] Digitaalinen nuorisotyö Digital ungdomsarbete Digital youth work 859 2018-08-07T14:00:23.214339+03:00 2 365 {} [859] 0 1403   2                                           1       1              
775 [] Edunvalvonta Intressebevakning Trusteeship 131 2018-08-07T14:00:30.904881+03:00 3 769 {} [131] 0 1401 1 3                                           2                      
2011 [] Ehkäisevä toimeentulotuki Förebyggande utkomststöd Preventive social assistance 840 2018-08-07T14:00:28.099014+03:00 2 839 {} [840] 0 783 7 8                                                         1        
122 [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] Elinkeino, työ ja verotus Näringar, arbete och beskattning Entrepreneurship, work and taxation   2018-08-07T14:00:29.995212+03:00 1 1401 {} [] 0 1401 322 452       2 1         1 2 1     2     2       51       62     5   1    
126 [] Elinkeinoasiat Näringslivsfrågor Trade and industry matters 132 2018-08-07T14:00:30.024180+03:00 2 122 {} [132] 0 1401 2 2                                                                  
142 [] Elinkeinomarkkinointi Näringslivmarknadsföring Business marketing 133 2018-08-07T14:00:30.132324+03:00 3 141 {} [133] 0 1401 2 2                                                                  
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} [135] 0 1401   1                     1                                            
105 [] Elintarvikevalvonta Livsmedelsbevakning Food control 137 2018-08-07T14:00:21.585963+03:00 3 103 {} [137] 0 1400 1 4                                 1         1       1              
353 [] Elokuvateatterit Biografteater Cinemas 138 2018-08-07T14:00:22.603098+03:00 3 352 {} [138] 0 1403 15 21                                           2       4              
14 [16, 23] Eläimet Djur Animals   2018-08-07T14:00:21.679608+03:00 1 1400 {} [] 0 1400 103 150                                           22       25              
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} [140] 0 1400 1 4                                 1         1       1              
107 [] Eläinsuojelu Djurskydd Animal protection 141 2018-08-07T14:00:21.598706+03:00 3 103 {} [141] 0 1400 1 4                                           1       2              
721 [] Eläintarha Högholmens djurgård Helsinki Zoo 142 2018-08-07T14:00:24.428725+03:00 4 719 {} [142] 0 1403 9 9                                                                  
719 [721, 723, 724, 725, 730] Eläintarhat Djurparker Zoos   2018-08-07T14:00:24.415879+03:00 3 718 {} [] 0 1403 13 14                     1                                            
552 [553, 2007] Eläinurheilualueet Anläggningar för djursport Animal sports areas   2018-08-07T14:00:23.225274+03:00 2 551 {} [] 0 1403 27 75                                           31       17              
130 [] Eläkkeet Pensioner Pension matters 143 2018-08-07T14:00:30.054750+03:00 2 122 {} [143] 0 1401 4 10       1                                   2       2         1    
24 [25, 26, 27] Energia Energi Energy   2018-08-07T14:00:21.738244+03:00 1 1400 {} [] 0 1400 6 7                                                   1              
272 [273, 274, 275] Energia Energi Energy   2018-08-07T14:00:22.327547+03:00 3 270 {} [] 0 1400 6 7                                                   1              
232 [] Energia-avustukset energiunderstöd energy grants 144 2018-08-07T14:00:22.065643+03:00 3 231 {} [144] 0 1400   1                                           1                      
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} [145] 0 1400   1                                                   1              
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} [146] 0 1400 1 1                                                                  
274 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:22.341217+03:00 4 272 {} [146] 0 1400 1 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              
1260 [] Englanninkielinen lukiokoulutus gymnasieutbildning på engelska general upper secondary education in English 148 2018-10-25T08:00:08.503752+03:00 3 1258 {"fi": ["englanti"]} [148] 1 1087 3 5                                           1       1              
905 [911, 906] Englanninkielinen päivähoito Engelskspråkig dagvård Day care in English 151 2018-08-07T14:00:28.480764+03:00 3 869 {} [151] 0 1405 39 62                                           21       1     1        
325 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:24.829787+03:00 3 324 {"fi": ["kirjastot"]} [155] 0 1402 27 29                                           2                      
346 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:22.558572+03:00 3 345 {"fi": ["kirjastot"]} [155] 0 1403 27 29                                           2                      
1173 [] Erityisluokkaopetus Undervisning i specialklass Special class education 660 2018-08-07T14:00:26.138862+03:00 3 1098 {} [660] 1 1087 4 10                               1           5                      
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                      
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              
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                                                                  
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                      
2127 [] Esi- ja starttiopetus Förskoleundervisning, startklasser Pre-primary and start class education 595 2018-10-25T08:00:09.543127+03:00 3 2126 {} [595] 1 1405   2                                           2                      
1088 [1093, 1089] Esiopetus Förskola Pre-primary education   2018-08-07T14:00:25.281111+03:00 1 1087 {} [] 0 1087 320 530                                           89       121              
2118 [2126, 2122] Esiopetus Förskola Pre-primary education   2018-08-07T14:00:29.045629+03:00 1 1405 {} [] 0 1405 320 530                                           89       121              
913 [919, 914] Espanjankielinen päivähoito Spanskspråkig dagvård Day care in Spanish 164 2018-08-07T14:00:28.527678+03:00 3 869 {} [164] 0 1405 2 2                                                                  
2207 [] Esteettömät autopaikat kadulla P-plats för personer med rörelsehinder bredvid gatan Accessible parking space along street 887 2020-02-12T09:30:09.092906+02:00 3 526 {} [887] 0 1402   94                                           94                      
554 [] Esteratsastuskenttä Bana för banhoppning Show jumping field 166 2018-08-07T14:00:23.236991+03:00 4 553 {} [166] 0 1403 3 3                                                                  
2156 [] Etsivä nuorisotyö Uppsökande ungdomsarbete Detective youth work 854 2018-08-07T14:00:23.208137+03:00 2 365 {} [854] 0 1403 5 7                                           2                      
841 [] Etuuskäsittely Förmånsbehandling Benefit processing 167 2018-08-07T14:00:28.085946+03:00 2 839 {} [167] 0 783 1 2                                           1                      
389 [] Fillari- ja moottoripaja Cykel- och motorverkstad Workshop for bicycles and mopeds 168 2018-08-07T14:00:22.937466+03:00 3 368 {} [168] 0 1403 4 5                                           1                      
578 [] Frisbeegolf-rata Frisbeegolfbana Disc golf course 169 2018-08-07T14:00:23.883764+03:00 4 646 {} [169] 0 1403 8 27                                           10       8     1        
391 [] Futsal Futsal Futsal 170 2018-08-07T14:00:22.944059+03:00 3 368 {} [170] 0 1403   1                                                   1              
1031 [] Fysioterapia Fysioterapi Physiotherapy 172 2018-08-07T14:00:29.505159+03:00 2 1028 {"fi": ["kuntoutus"]} [172] 0 986 11 21                                           4       5     1        
635 [] Golfin harjoitusalue Träningsområde för golf Golf training area 173 2018-08-07T14:00:23.802245+03:00 4 634 {} [173] 0 1403 1 6                                           3       2              
636 [] Golfin harjoitushalli Övningshall för golf Golf training hall 174 2018-08-07T14:00:23.808994+03:00 4 634 {} [174] 0 1403 6 10                                           4                      
637 [] Golfkenttä Golfbana Golf course 175 2018-08-07T14:00:23.815939+03:00 4 634 {} [175] 0 1403 4 16                                           9       3              
634 [635, 636, 637, 638] Golfkentät Golfbanor Golf courses   2018-08-07T14:00:23.796742+03:00 3 633 {} [] 0 1403 18 50                                           23       9              
1021 [] HUS:n erikoissairaanhoito HNS:s specialsjukvård HUS specialised health care 440 2018-08-07T14:00:29.421431+03:00 2 1019 {} [440] 0 986 2 2                                                                  
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        
173 [2004, 2003, 2005] Hallinnon toimipisteet Förvaltningens verksamhetsställen Administrative offices   2018-08-07T14:00:30.377254+03:00 3 172 {} [] 0 1401 56 67                                   1       2       7     1        
28 [29] Hallinto Förvaltning Administration   2018-08-07T14:00:21.313217+03:00 2 1 {} [] 0 1400   1                                                   1              
172 [173, 176, 2001, 2002] Hallinto Förvaltning Administration   2018-08-07T14:00:30.370486+03:00 2 171 {} [] 0 1401 59 72                                   1       3       8     1        

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