service_node

383 rows where level = 3 sorted by unit_count_municipality_vantaa descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, last_modified_time (date)

unit_count_municipality_tuusula ✖

level ✖

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ää
654 [655, 656, 657, 658, 659, 660, 661, 662] Pallokentät Bollplaner Ball games courts   2018-08-07T14:00:23.947305+03:00 3 633 {} [] 0 1403 697 1266                         1                 283       273   1 11        
608 [609, 610, 611, 612, 613] Kuntoilukeskukset ja liikuntasalit Konditionsidrottscentra och idrottssalar Fitness centres and sports halls   2018-08-07T14:00:23.602837+03:00 3 601 {} [] 0 1403 576 949                                           188       177     8        
870 [875, 879, 872, 877, 876, 880, 871, 874] Suomenkielinen päivähoito Finskspråkig dagvård Day care in Finnish 663 2019-03-05T14:30:09.339119+02:00 3 869 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [663] 0 1405 389 847                                           278       174     6        
45 [] Paperinkeräys Insamling av papper Paper recycling 496 2018-08-07T14:00:21.867001+03:00 3 34 {} [496] 0 1400 166 466                                           125       156     19        
68 [70, 69] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:21.413441+03:00 3 60 {} [] 0 1400 293 647                                           201       148     5        
499 [501, 500] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:22.748801+03:00 3 491 {} [] 0 1403 293 647                                           201       148     5        
577 [579, 580, 581, 582, 583, 584, 585, 586, 590] Liikunta- ja ulkoilureitit Idrotts- och friluftsleder Sports and outdoor recreation routes   2018-08-07T14:00:23.400833+03:00 3 558 {} [] 0 1403 132 401       3                 1       1         105       147   9 3        
1090 [] Päivähoidon järjestämä esiopetus Förskoleundervisning som ordnas av dagvården Pre-primary education organised by day care 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 2019-06-20T11:30:19.029713+03:00 3 1089 {} [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] 1 1087 289 483                                           78       116              
2125 [] Päivähoidon järjestämä esiopetus Förskoleundervisning som ordnas av dagvården Pre-primary education organised by day care 58*160+151*160+164*160+188*160+195*160+569*160+607*160+614*160+663*160+773*160+861*160 2019-06-20T11:30:22.256470+03:00 3 2122 {} [861, 773, 663, 614, 607, 569, 195, 188, 164, 160, 151, 58] 1 1405 289 483                                           78       116              
646 [578, 647, 648, 649, 650, 651, 652, 653] Lähiliikunta ja liikuntapuistot Närmotion och idrottsparker Neighbourhood sports facilities and parks   2018-08-07T14:00:23.877348+03:00 3 633 {} [] 0 1403 345 650                               1           196       95   3 10        
639 [641, 642, 643, 644, 645] Jääurheilualueet ja luonnonjäät Isidrottsområden och naturisar Ice sports areas and sites with natural ice   2018-08-07T14:00:23.829697+03:00 3 633 {} [] 0 1403 165 358                                           114       77     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        
1099 [1101, 1102, 2170, 1103, 1100, 1104] Luokkien 1-6 perusopetus Grundläggande utbildning, årskurserna 1-6 Basic education, grades 1-6   2018-10-25T08:00:07.589100+03:00 3 1098 {} [] 0 1087 110 212                                           62       39 1            
40 [] Lasinkeräys Glasåtervinning Glass recycling 374 2018-08-07T14:00:21.831316+03:00 3 34 {} [374] 0 1400 50 138                                           46       37     5        
41 [] Metallinkeräys Metallavfall Small metal waste 436 2018-08-07T14:00:21.839149+03:00 3 34 {} [436] 0 1400 50 137                                           46       37     4        
38 [] Kartonginkeräys Insamling av kartong Cardboard recycling 246 2018-08-07T14:00:21.813795+03:00 3 34 {"fi": ["kartonki"]} [246] 0 1400 54 140                                           46       36     4        
255 [256, 257, 258, 265] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:22.202500+03:00 3 231 {} [] 0 1400 294 380       1 1         1   1     2     2       42       32     4        
149 [2209, 150, 152, 151, 154, 155] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:30.179684+03:00 3 146 {} [] 0 1401 292 375       1 1         1   1     2     2       40       31     4        
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} [696] 0 1400 40 108                                           37       29     2        
1120 [1123, 1124, 1127, 1129, 1122, 1130, 1131, 1135, 1136, 1139, 1141, 1134, 1142, 1143, 1147, 1146, 1160, 1162, 1163, 1164, 1165, 1166, 1167, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:25.674488+03:00 3 1098 {} [] 0 1087 109 213                               1           73       29 1            
978 [] Kerhotoiminta Klubbverksamhet Club activities 288 2019-03-05T14:30:09.661194+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [288] 0 1405 94 143                                           20       28     1        
35 [] Akkujen keräys Återvinning av bilbatterier Car battery recycling 45 2018-08-07T14:00:21.789985+03:00 3 34 {"fi": ["akut"]} [45] 0 1400 34 79                                           18       26     1        
62 [63, 64, 65, 66, 67] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:21.368201+03:00 3 60 {} [] 0 1400 102 149                                           22       25              
493 [494, 495, 496, 497, 498] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:22.700110+03:00 3 491 {} [] 0 1403 102 149                                           22       25              
17 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.693384+03:00 3 16 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} [317] 0 1400 94 140                                           22       24              
624 [625, 626, 627, 628, 629, 630, 631, 632] Yksittäiset lajikohtaiset sisäliikuntapaikat Enstaka grenspecifika anläggningar för inomhusidrott Indoor venues for various sports   2018-08-07T14:00:23.722887+03:00 3 601 {} [] 0 1403 118 186                                           43       24     1        
1109 [1111, 1112, 2171, 1113, 1110, 1114] Luokkien 7-9 perusopetus Grundläggande utbildning, årskurserna 7-9 Basic education, grades 7-9   2018-10-25T08:00:07.629842+03:00 3 1098 {} [] 0 1087 69 121                               1           27       23 1            
507 [] Kokouspaikat Möteslokaler Meeting places 326 2018-08-07T14:00:22.812763+03:00 3 505 {} [326] 0 1403 247 293       1 1         1         2     2       17       22              
614 [615, 616, 617, 618, 619, 620, 621, 622, 623] Liikuntahallit Idrottshallar Sports halls   2018-08-07T14:00:23.644666+03:00 3 601 {} [] 0 1403 149 233                                           60       22     2        
742 [] Kokouspaikat Möteslokaler Meeting places 326 2018-08-07T14:00:24.534199+03:00 3 718 {} [326] 0 1403 247 293       1 1         1         2     2       17       22              
39 [] Lamppujen keräys Återvinning av lampor Lamp recycling 369 2018-08-07T14:00:21.822356+03:00 3 34 {"fi": ["lamput"]} [369] 0 1400 21 54                                           13       20              
46 [] Paristonkeräys Återvinning av små batterier Small battery recycling 497 2018-08-07T14:00:21.875976+03:00 3 34 {"fi": ["paristot"]} [497] 0 1400 16 46                                           12       18              
51 [] Vaarallinen jäte Farligt avfall Hazardous waste 740 2018-08-07T14:00:21.912639+03:00 3 34 {} [740] 0 1400 16 44                                           11       17              
139 [] Maa-alueiden vuokraus ja myynti Uthyrning och försäljning av markområden Selling or renting land areas 419 2018-08-07T14:00:30.113920+03:00 3 134 {} [419] 0 1401   17                                                   17              
245 [249, 248, 247, 250, 251] Maan, tonttien ja asuntojen vuokraus ja myynti Försäljning och uthyrning av mark, tomter, lokaler och bostäder Sales and rental of land, lots, facilities and apartments   2018-08-07T14:00:22.143596+03:00 3 231 {} [] 0 1400 10 32                                           4       17     1        
42 [] Muovinkeräys Plaståtervinning Plastic recycling 454 2018-08-07T14:00:21.846516+03:00 3 34 {} [454] 0 1400 23 70                                           29       16     2        
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        
77 [] Katujen ja viheralueiden suunnittelu ja rakennuttaminen Planering och byggande av gator och grönområden Design and development of streets and parks 252 2018-08-07T14:00:21.469668+03:00 3 74 {} [252] 0 1400 1 18                                           2       14     1        
277 [] Katujen ja viheralueiden suunnittelu ja rakennuttaminen Planering och byggande av gator och grönområden Design and development of streets and parks 252 2018-08-07T14:00:22.362599+03:00 3 270 {} [252] 0 1400 1 18                                           2       14     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        
520 [] Rautatieasemat Järnvägsstationer Railway stations 576 2018-08-07T14:00:25.051739+03:00 3 513 {} [576] 0 1402 16 41                                           9       14     2        
537 [] Katujen ja viheralueiden suunnittelu ja rakennuttaminen Planering och byggande av gator och grönområden Design and development of streets and parks 252 2018-08-07T14:00:25.163756+03:00 3 534 {} [252] 0 1402 1 18                                           2       14     1        
553 [554, 555, 556, 557] Hevosurheilu Hästsport Equestrian sports   2018-08-07T14:00:23.231236+03:00 3 552 {} [] 0 1403 19 64                                           31       14              
508 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.820471+03:00 3 505 {} [214] 0 1403 218 249       1 1         1   1           1       10       13     3        
736 [] Hotellit ja majoitus Hotell och logi Hotels and accommodation 197 2018-08-07T14:00:24.492255+03:00 3 718 {} [197] 0 1403 89 115         1               1   1     2       7       13   1          
737 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:24.498919+03:00 3 718 {} [214] 0 1403 218 249       1 1         1   1           1       10       13     3        
751 [] Ravintolat Restauranger Restaurants 577 2018-08-07T14:00:24.595794+03:00 3 718 {} [577] 0 1403 663 699                             1   1         22       12              
328 [] Yleiset kirjastot Allmänna bibliotek Public libraries 813 2018-11-20T14:00:07.881833+02:00 3 324 {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} [813] 0 1402 39 71                                           20       11     1        
349 [] Yleiset kirjastot Allmänna bibliotek Public libraries 813 2018-11-20T14:00:06.997504+02:00 3 345 {"en": ["library", "libraries"], "fi": ["kirjastot", "kirjasto"], "sv": ["bibliotek"]} [813] 0 1403 39 71                                           20       11     1        
415 [] Kuntosali Gym Gym 349 2018-08-07T14:00:23.013463+03:00 3 368 {} [349] 0 1403   11                                           1       10              
881 [886, 887, 883, 882] Ruotsinkielinen päivähoito Svenskspråkig dagvård Day care in Swedish 603 2019-03-05T14:30:09.379492+02:00 3 869 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [603] 0 1405 77 128                                           33       10     8        
2221 [] Senioriliikunta Seniormotion Senior sports 895 2020-06-09T15:30:11.355674+03:00 3 2217 {} [895] 0 1403 86 102                     1                     4       10     1        
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              
2145 [964, 963, 972] Ryhmäperhepäivähoito Gruppfamiljedagvård Group family day care   2018-08-07T14:00:28.879106+03:00 3 961 {} [] 0 1405 57 118                                           51       9     1        
2208 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:07.500577+03:00 3 505 {} [888] 0 1403 1 12                                           2       9              
446 [] Pelit Spel Games 503 2018-08-07T14:00:23.094780+03:00 3 368 {} [503] 0 1403 1 24                                           15       8              
685 [686, 687, 688, 689] Maauimalat ja uimarannat Utebassänger och badstränder Open air pools and beaches   2018-08-07T14:00:24.169221+03:00 3 684 {} [] 0 1403 43 98                         4                 39       8   4          
745 [746, 747] Museot Museer Museums   2018-08-07T14:00:24.555720+03:00 3 718 {} [] 0 1403 64 96           1                     4 1       13       8 1     4      
1259 [] Suomenkielinen lukiokoulutus gymnasieutbildning på finska general upper secondary education in Finnish 658 2018-10-25T08:00:08.498186+03:00 3 1258 {"fi": ["suomi"]} [658] 1 1087 30 52                                           14       8              
2147 [2148, 318] Sosiaali- ja terveyspalvelujen ja ikääntyvien neuvonta Rådgivning om social- och hälsovårdstjänster och för äldre Information and advice of social and health services and for elderly people   2018-08-07T14:00:24.757653+03:00 3 314 {} [] 0 1402 1 13                     1                     3       8              
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        
330 [331, 332] Langaton internet, wlan Trådlöst internet, wlan Wireless internet, wlan   2018-10-25T08:00:07.331877+03:00 3 329 {} [] 0 1402 233 240                                                   7              
404 [] Kerhotoiminta Klubbverksamhet Club activities 289 2018-08-07T14:00:22.983998+03:00 3 368 {} [289] 0 1403   22                                           14       7     1        
690 [691, 692, 693] Uima-altaat, hallit ja kylpylät Simbassänger, hallar och badinrättningar Indoor swimming pools, halls and spas   2018-08-07T14:00:24.204334+03:00 3 684 {} [] 0 1403 35 55                                           12       7     1        
695 [696, 697, 698, 699, 700, 701, 702, 703, 704, 705] Retkeilyn palvelut Utflyktstjänster Hiking facilities   2018-08-07T14:00:24.236641+03:00 3 694 {} [] 0 1403 224 404       10                 11         8       125       7   18 1        
750 [] Ostospaikat Shoppingplatser Shopping 490 2018-08-07T14:00:24.589090+03:00 3 718 {} [490] 0 1403 465 477                                           5       7              
49 [] Sähkö- ja elektroniikkaromu El- och elekronikskrot Electric and electronic junk 668 2018-10-25T08:00:06.218463+03:00 3 34 {} [668] 0 1400 11 24                                           7       6              
364 [] Taidemuseo Konstmuseer Art museums 672 2018-08-07T14:00:22.677535+03:00 3 362 {} [672] 0 1403 61 88           1                     4 1       10       6 1     4      
667 [668, 670, 672, 673, 674] Moottoriurheilualueet Områden för motorsport Motor sports areas   2018-08-07T14:00:24.047385+03:00 3 666 {} [] 0 1403 4 12                                           2       6              
279 [281, 282, 283, 284, 285] Rakennusvalvonta Byggnadstillsyn Building Control   2018-08-07T14:00:22.376681+03:00 3 270 {} [] 0 1400 3 11                                           2       5     1        
355 [] Kulttuurin monitoimitalot Allaktivitetshus för kultur Multi-functional culture venues 345 2018-08-07T14:00:22.617002+03:00 3 352 {} [345] 0 1403 8 18                                           3       5     2        
363 [] Kulttuurihistoriallinen museo Kulturhistoriska museer Cultural history museums 344 2018-08-07T14:00:22.670926+03:00 3 362 {} [344] 0 1403 42 58                                           9       5 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              
749 [] Nähtävyydet Sevärdheter Sights 473 2018-08-07T14:00:24.582404+03:00 3 718 {} [473] 0 1403 234 244                                   1       4       5              
1193 [1194, 1208, 1214, 1215, 1218, 1232, 1233, 1236, 1237, 1238, 1239, 1240] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:26.296242+03:00 3 1187 {} [] 0 1087 21 26                                                   5              
1268 [1270, 1269] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:26.852029+03:00 3 1258 {} [] 0 1087 14 30                                           11       5              
1271 [1274, 1275, 1278, 1280, 1273, 1281, 1272, 1282, 1285, 1286, 1287, 1288, 1289, 1290, 1292, 1284, 1293, 1294] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:26.871621+03:00 3 1258 {} [] 0 1087 12 28                                           11       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              
75 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:21.457195+03:00 3 74 {} [249] 0 1400 1 5                                                   4              
241 [] Kiinteistönmuodostus Fastighetsbildning Property formation 304 2018-08-07T14:00:22.116719+03:00 3 231 {} [304] 0 1400   5                                           1       4              
316 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.717090+03:00 3 314 {} [429] 0 1402 2 12                                           6       4              
353 [] Elokuvateatterit Biografteater Cinemas 138 2018-08-07T14:00:22.603098+03:00 3 352 {} [138] 0 1403 15 21                                           2       4              
371 [] Askartelu Hobbyverksamhet Hobby crafts 72 2018-08-07T14:00:22.898108+03:00 3 368 {} [72] 0 1403 3 9                                           2       4              
409 [] Kokkikerho Kockklubb Cook club 325 2018-08-07T14:00:22.999540+03:00 3 368 {} [325] 0 1403   4                                                   4              
448 [] Pingis Bordtennis Table tennis 515 2018-08-07T14:00:23.100999+03:00 3 368 {} [515] 1 1403 1 17                                           12       4              
516 [] Julkisen liikenteen varikot Kollektivtrafikens depåer Public transport depots 216 2018-08-07T14:00:25.022696+03:00 3 513 {} [216] 0 1402 5 9                                                   4              
535 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:25.151160+03:00 3 534 {} [249] 0 1402 1 5                                                   4              
602 [603, 604] Jäähallit Ishallar Ice-skating arenas   2018-08-07T14:00:23.562977+03:00 3 601 {} [] 0 1403 12 24                                           7       4     1        
744 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.548312+03:00 3 718 {} [429] 0 1403 2 12                                           6       4              
1095 [] Koulun järjestämä esiopetus Förskoleundervisning som ordnas av skolan Pre-primary education organised by school 601*159+862*159 2018-10-25T08:00:07.525080+03:00 3 1093 {} [862, 601, 159] 1 1087 5 9                                                   4              
1169 [1170, 1171, 1172] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.110528+03:00 3 1098 {} [] 0 1087 40 44                                                   4              
1188 [1189] Luokkien 1-6 perusopetus Grundläggande utbildning, årskurserna 1-6 Basic education, grades 1-6   2018-10-25T08:00:08.198860+03:00 3 1187 {} [] 0 1087 21 37                                           12       4              
1249 [1251, 1250, 1252] Iltapäivätoiminta Eftermiddagsverksamhet Afternoon activities 596 2018-08-07T14:00:26.711531+03:00 3 1187 {} [596] 1 1087 24 39                                           11       4              
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              
2128 [] Koulun järjestämä esiopetus Förskoleundervisning som ordnas av skolan Pre-primary education organised by school 601*159+862*159 2018-10-25T08:00:09.534871+03:00 3 2126 {} [862, 601, 159] 1 1405 5 9                                                   4              
78 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:21.475789+03:00 3 74 {} [253] 0 1400 1 6                                           1       3     1        
189 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:30.517534+03:00 3 187 {} [420] 0 1401 14 20                                           2       3     1        
233 [234, 235, 237] Hallinto Förvaltning Administration   2018-08-07T14:00:22.072503+03:00 3 231 {} [] 0 1400 3 6                                                   3              
242 [] Kiinteistörekisteri Fastighetsregister Real estate register 305 2018-08-07T14:00:22.123611+03:00 3 231 {} [305] 0 1400   4                                           1       3              

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