1,140 rows sorted by name_fi

View and edit SQL

Suggested facets: level, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_loviisa, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, 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, last_modified_time (date)

unit_count_municipality_hamina

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ää
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 {} 1 1087 10 10                                                                  
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 {} 1 1087 11 15                                                   4              
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 {} 1 1087 1 1                                                                  
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 {} 1 1087 28 28                                                                  
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 {} 1 1087 1 1                                                                  
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 {} 1 1087 12 27                                           10       5              
1306 [] A-englanti A-engelska A-English 598*4 2018-08-07T14:00:27.131698+03:00 4 1303 {} 1 1087 2 3                                                   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 {} 1 1087 3 5                                                   2              
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 {} 1 1087 1 1                                                                  
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 {} 1 1087 7 16                                           5       4              
1312 [] A-ranska A-franska A-French 598*10 2018-08-07T14:00:27.175551+03:00 4 1303 {} 1 1087 1 1                                                                  
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 {} 1 1087 9 25                                           11       5              
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 {} 1 1087 7 20                                           9       4              
1313 [] A-saksa A-tyska A-German 598*12 2018-08-07T14:00:27.183391+03:00 4 1303 {} 1 1087 1 1                                                                  
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 {} 1 1087   1                                           1                      
1304 [] A-suomi A-finska A-Finnish 598*13 2018-08-07T14:00:27.116631+03:00 4 1303 {} 1 1087 3 4                                                   1              
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 {} 1 1087 3 6                                           1       2              
1123 [] A1-englanti A1-engelska A1-English 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 2018-10-25T08:00:07.696168+03:00 4 1120 {} 1 1087 108 211                               1           73       28 1            
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 {} 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 {} 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 {} 1 1087 42 50                                           8                      
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 {} 1 1087 43 50                                           7                      
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 {} 1 1087 28 40                                           12                      
1194 [] A1-suomi A1-finska A1-Finnish 601*24+602*24 2018-10-25T08:00:08.223234+03:00 4 1193 {} 1 1087 21 26                                                   5              
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 {} 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 {} 1 1087 81 100                                           19                      
1208 [] A2-englanti A2-engelska A2-English 601*27+602*27 2018-10-25T08:00:08.293365+03:00 4 1193 {} 1 1087 20 25                                                   5              
1136 [] A2-espanja A2-spanska A2-Spanish 149*28+150*28+162*28+163*28+301*28+302*28+384*28+385*28+567*28+568*28+612*28+613*28+661*28+662*28+771*28+772*28+793*28+794*28+865*28+866*28 2018-10-25T08:00:07.822843+03:00 4 1120 {} 1 1087 45 75                                           7       23              
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 {} 1 1087 2 4                                           2                      
1141 [] A2-ranska A2-franska A2-French 149*33+150*33+162*33+163*33+301*33+302*33+384*33+385*33+567*33+568*33+612*33+613*33+661*33+662*33+771*33+772*33+793*33+794*33+865*33+866*33 2018-10-25T08:00:07.868542+03:00 4 1120 {} 1 1087 63 101                                           22       16              
1214 [] A2-ranska A2-franska A2-French 601*33+602*33 2018-10-24T20:00:08.734794+03:00 4 1193 {} 1 1087 4 4                                                                  
1134 [] A2-ruotsi A2-svenska A2-Swedish 149*34+150*34+162*34+163*34+301*34+302*34+384*34+385*34+567*34+568*34+612*34+613*34+661*34+662*34+771*34+772*34+793*34+794*34+865*34+866*34 2018-10-25T08:00:07.804809+03:00 4 1120 {} 1 1087 57 117                                           39       21              
1142 [] A2-saksa A2-tyska A2-German 149*35+150*35+162*35+163*35+301*35+302*35+384*35+385*35+567*35+568*35+612*35+613*35+661*35+662*35+771*35+772*35+793*35+794*35+865*35+866*35 2018-10-25T08:00:07.877676+03:00 4 1120 {} 1 1087 58 124                                           50       16              
1215 [] A2-saksa A2-tyska A2-German 601*35+602*35 2018-10-24T20:00:08.743668+03:00 4 1193 {} 1 1087 12 12                                                                  
1143 [] A2-venäjä A2-ryska A2-Russian 149*37+150*37+162*37+163*37+301*37+302*37+384*37+385*37+567*37+568*37+612*37+613*37+661*37+662*37+771*37+772*37+793*37+794*37+865*37+866*37 2018-10-25T08:00:07.886355+03:00 4 1120 {} 1 1087 15 19                                           1       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              
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} 0 1087 5 11                                           2       3     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 {} 1 1087 3 3                                                                  
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 {} 1 1087 1 1                                                                  
1337 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 650 2018-08-07T14:00:27.357192+03:00 3 1336 {} 1 1087 2 7                                           2       3              
1344 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 590 2018-08-07T14:00:27.406024+03:00 3 1343 {} 1 1087 1 1                                                                  
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 {} 1 1087 3 3                                                                  
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 {} 1 1087 1 1                                                                  
1338 [] Aikuisten peruskoulutus Grundläggande utbildning för vuxna Basic education for adults 652 2018-08-07T14:00:27.364989+03:00 3 1336 {} 1 1087 3 4                                           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 {} 1 1087 1 1                                                                  
848 [] Aikuisten sosiaaliohjaus Socialhandledning för vuxna Social care work for adults 41 2018-08-07T14:00:28.131053+03:00 2 845 {} 0 783 6 9                                           1       2              
846 [] Aikuisten sosiaalityö Socialt arbete för vuxna Social work for adults 42 2018-08-07T14:00:28.117778+03:00 2 845 {} 0 783 21 25                                           3       1              
1001 [] Aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för vuxna Health centre on-call service and emergency outpatient clinic for adults 43 2018-08-07T14:00:29.242685+03:00 2 1000 {"fi": ["p\u00e4ivystys"]} 0 986   3                                           1       1     1        
527 [] Ajoneuvojen siirrot Flyttning av fordon Towing vehicles 44 2018-08-07T14:00:25.100072+03:00 3 526 {} 0 1402 2 5                                           1       2              
35 [] Akkujen keräys Återvinning av bilbatterier Car battery recycling 45 2018-08-07T14:00:21.789985+03:00 3 34 {"fi": ["akut"]} 0 1400 34 79                                           18       26     1        
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} 0 986 1 4                                                   3              
168 [] Alkavien yrittäjien neuvonta Rådgivning för nya företagare Advice for start-up entrepreneurs 48 2018-08-07T14:00:30.339989+03:00 3 167 {} 0 1401 4 8                                           2       2              
847 [] Alueellinen kumppanuustyö Områdesvist partnerskapsarbete Regional partnership work 49 2018-08-07T14:00:28.124411+03:00 2 845 {} 0 783 19 119       1                                   1       96     1   1    
303 [304] Aluerakentaminen Områdesbyggandet Regional construction   2018-08-07T14:00:22.515802+03:00 4 302 {} 0 1400 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              
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 {} 1 1087 8 9                                                   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 {} 0 1087 3 5                                           2                      
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 {} 0 1402 3 5                                           2                      
123 [] Ammatinvalinnanohjaus Yrkesvägledning Vocational guidance 51 2018-08-07T14:00:30.001277+03:00 2 122 {} 0 1401 4 6                                           1       1              
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} 0 1087 1 2                                                         1        
593 [] Ampumahiihdon harjoittelualue Träningsområde för skidskytte Training area for biathlon 52 2018-08-07T14:00:23.502563+03:00 4 592 {} 0 1403   1       1                                                          
594 [] Ampumahiihtokeskus Skidskyttecentrum Biathlon centre 53 2018-08-07T14:00:23.509751+03:00 4 592 {} 0 1403   1                                           1                      
560 [] Ampumarata Skjutbana Open-air shooting range 54 2018-08-07T14:00:23.293024+03:00 4 559 {} 0 1403   1                                           1                      
561 [] Ampumaurheilukeskus Sportskyttecentrum Shooting sports centre 55 2018-08-07T14:00:23.299465+03:00 4 559 {} 0 1403   1       1                                                          
559 [560, 561, 562, 563] Ampumaurheilupaikat Sportskytteplatser Shooting sports facilities   2018-08-07T14:00:23.287538+03:00 3 558 {} 0 1403 6 10       1                                   3                      
990 [] Apteekki Apotek Pharmacy 57 2018-08-07T14:00:29.143841+03:00 1 986 {} 0 986 1 8                                                   7              
1029 [] Apuvälinepalvelut Hjälpmedelstjänster Aid services 352 2018-08-07T14:00:29.484194+03:00 2 1028 {} 0 986 5 10                                           1       3     1        
897 [903, 898] Arabiankielinen päivähoito Arabiskspråkig dagvård Day care in Arabic 58 2018-08-07T14:00:28.436562+03:00 3 869 {} 0 1405 2 2                                                                  
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} 0 1402 4 11                                           2       4     1        
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} 0 1402   1                                                         1        
25 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:21.743023+03:00 2 24 {} 0 1400 1 2                                                   1              
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} 0 1400   3                                           1       1     1        
273 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:22.333741+03:00 4 272 {} 0 1400 1 2                                                   1              
1362 [] Asiakaspalvelu Kundtjänst Customer services 665*66 2020-11-18T07:30:12.851359+02:00 3 1361 {} 0 1087 7 9                                           1             1        
1366 [] Asiakaspalvelu Kundtjänst Customer services 605*66 2020-11-18T07:30:12.883321+02:00 3 1365 {} 0 1087 2 3                                                         1        
2203 [] Asiakaspalvelu Kundbetjäning Customer services 884 2019-08-23T14:30:13.757143+03:00 2 171 {} 0 1401 2 3                                           1                      
514 [] Asiakaspalvelu ja lipunmyynti Kundtjänst och biljettförsäljning Customer service and ticket sales 63+404 2018-10-24T20:00:07.778946+03:00 3 513 {} 0 1402 5 11                                           2       3     1        
314 [319, 315, 317, 316, 2147, 2159] Asiakaspalvelu ja neuvonta Kundbetjäning och rådgivning Customer service and information   2018-08-07T14:00:24.703287+03:00 2 306 {} 0 1402 12 39                     1                     12       13     1        
319 [] Asiointipisteet, yleisneuvonta ja yhteispalvelu Servicepunkter, allmän rådgivning och samservicekontor Service points, General information and Citizen's offices 809 2019-04-11T16:30:09.599681+03:00 3 314 {"fi": ["palvelupiste"]} 0 1402 2 11                                           6       3              
371 [] Askartelu Hobbyverksamhet Hobby crafts 72 2018-08-07T14:00:22.898108+03:00 3 368 {} 0 1403 3 9                                           2       4              
528 [] Asukas- ja yrityspysäköintitunnukset Boende- och företagsparkering Residential and corporate parking 73+834 2018-10-24T23:30:06.727092+03:00 3 526 {} 0 1402 1 1                                                                  
2208 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:07.500577+03:00 3 505 {} 0 1403 1 12                                           2       9              
2209 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:10.261582+03:00 4 149 {} 0 1401 1 12                                           2       9              
2210 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:07.230470+03:00 5 258 {} 0 1400 1 12                                           2       9              
2 [3, 4, 5, 7, 2191, 8] Asuminen Boende Housing   2018-08-07T14:00:21.231002+03:00 1 1400 {} 0 1400 742 1530       16   23 1       1       27   51 40       246     3 256 35 10 1 37 41    
1400 [2, 1, 14, 24, 31, 221, 85] Asuminen ja kaupunkiympäristö Boende och stadsmiljö Housing and urban environment   2018-08-07T14:00:21.224786+03:00 0   {} 0 1400 2311 4077       17 1 23 1     1 4 1     30   53 43       737     3 698 35 10 31 37 41    
3 [] Asumisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för boendeärenden Electronic housing services and forms 74 2018-08-07T14:00:21.236014+03:00 2 2 {} 0 1400   1                     1                                            
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} 0 1400 3 9       1                                   2       2         1    
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} 0 1400 2 5                                 1         1       1              
1 [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] Asumisympäristö Boendemiljön Housing environment   2018-08-07T14:00:21.308151+03:00 1 1400 {} 0 1400 1002 1524                     2           2         294       218     6        
137 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:30.100472+03:00 3 134 {} 0 1401 1 3                                           1       1              
249 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:22.162414+03:00 4 245 {} 0 1400 1 3                                           1       1              
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} 0 1400 1 3                                           1       1              
271 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:22.320238+03:00 3 270 {} 0 1400 1 3                                           1       1              
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 {} 1 1087 33 33                                                                  
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 {} 1 1087 33 33                                                                  
374 [] Av- ja leirivälinelainaamo Utlåning av AV-utrustning och campingutrustning Loaning service for audiovisual and camping equipment 81 2018-08-07T14:00:22.905139+03:00 3 368 {} 0 1403 3 4                                           1                      
771 [] Avioehto Äktenskapsförord Prenuptial agreement 82 2018-08-07T14:00:30.878414+03:00 4 770 {} 0 1401 1 2                                           1                      
770 [771, 773, 774] Avioliitto ja rekisteröity parisuhde Äktenskap och registrering av partnerskap Marriage and registered partnership   2018-08-07T14:00:30.869982+03:00 3 769 {} 0 1401 1 2                                           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
);