service_node

1,140 rows sorted by unit_count_municipality_espoo descending

✎ View and edit SQL

This data as json, CSV (advanced)

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ää
882 [] päivähoito dagvård day care 603 2019-03-05T14:30:09.386238+02:00 4 881 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [603] 0 1405 77 128                                           33       10     8        
975 [976, 977, 978, 979, 981, 982] Leikkitoiminta Lekverksamhet Playground activities   2018-08-07T14:00:28.970500+03:00 2 868 {} [] 0 1405 144 210                                           33       32     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              
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              
365 [2162, 2156, 368, 367, 366, 490] Nuoriso Ungdom Youth   2018-08-07T14:00:22.862181+03:00 1 1403 {} [] 0 1403 82 146 1     1                                   30       29     3        
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        
610 [] Kuntokeskus Konditionsidrottscentrum Fitness centre 625 2018-08-07T14:00:23.616327+03:00 4 608 {} [625] 0 1403 48 97                                           28       20     1        
755 [756, 768, 769] Oikeusturva ja demokratia Rättsskydd och demokrati Justice system and democracy   2020-03-06T18:32:09.608464+02:00 1 1401 {} [] 0 1401 15 46                                           28       2     1        
345 [346, 2026, 2196, 348, 349, 2197] Kirjastot Bibliotek Libraries   2018-08-07T14:00:22.550752+03:00 2 343 {} [] 0 1403 114 157                                           27       14     2        
368 [371, 374, 375, 376, 378, 381, 389, 391, 395, 396, 399, 2155, 403, 404, 405, 409, 410, 415, 418, 419, 421, 424, 426, 429, 433, 437, 438, 440, 442, 446, 448, 449, 452, 453, 454, 455, 458, 467, 468, 470, 473, 2154, 480, 481, 485, 488] Harrasteet Hobbyer Hobbies   2018-08-07T14:00:22.885008+03:00 2 365 {} [] 0 1403 71 120 1     1                                   27       17     3        
513 [514, 515, 516, 518, 519, 520] Joukkoliikenne Kollektivtrafik Public transport   2018-08-07T14:00:25.002057+03:00 2 512 {} [] 0 1402 99 151                                           27       21     4        
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        
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            
1110 [] suomenkielinen opetus undervisning på finska education in Finnish 662 2018-10-25T08:00:07.635959+03:00 4 1109 {} [662] 1 1087 63 114                               1           27       22 1            
324 [325, 2040, 2193, 327, 328, 2194] Kirjastot Bibliotek Libraries   2018-08-07T14:00:24.821378+03:00 2 306 {} [] 0 1402 83 125                                           26       14     2        
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              
584 [] Luontopolku Naturstig Nature trail 413 2018-08-07T14:00:23.440979+03:00 4 577 {} [413] 0 1403 12 41       1                 1                 24       1   1 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              
14 [16, 23] Eläimet Djur Animals   2018-08-07T14:00:21.679608+03:00 1 1400 {} [] 0 1400 103 150                                           22       25              
16 [17, 18, 19, 20, 21] Koira-alueet Hund områden Dog areas   2018-08-07T14:00:21.685399+03:00 2 14 {} [] 0 1400 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              
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              
63 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:21.380622+03:00 4 62 {"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              
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        
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              
494 [] Koira-aitaukset Hundparker Dog parks 317 2018-08-07T14:00:22.710417+03:00 4 493 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} [317] 0 1403 94 140                                           22       24              
581 [] Kuntorata Konditionsbana Jogging track 348 2018-08-07T14:00:23.419850+03:00 4 577 {} [348] 0 1403 45 82                                           22       14     1        
627 [] Pöytätennistila Utrymme för bordtennis Table tennis venue 556 2018-08-07T14:00:23.745237+03:00 4 624 {} [556] 0 1403 22 46                                           22       2              
688 [] Uimapaikka Badplats Unsupervised beach 730 2018-08-07T14:00:24.189679+03:00 4 685 {} [730] 0 1403 14 48                         4                 22       4   4          
751 [] Ravintolat Restauranger Restaurants 577 2018-08-07T14:00:24.595794+03:00 3 718 {} [577] 0 1403 663 699                             1   1         22       12              
768 [] Järjestötoiminta Organisationsverksamhet Organisational activities 230 2018-08-07T14:00:30.858157+03:00 2 755 {} [230] 0 1401 2 24                                           22                      
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 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 33] 1 1087 63 101                                           22       16              
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              
2204 [] Yhteiskäyttöautojen pysäköintipaikat Bilpoolparkering Parking for car share vehicles 885 2019-09-02T10:30:09.552872+03:00 3 526 {} [885] 0 1402   22                                           22                      
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        
906 [] päivähoito dagvård day care 151 2018-08-07T14:00:28.486872+03:00 4 905 {} [151] 0 1405 39 62                                           21       1     1        
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        
555 [] Ratsastuskenttä Ridbana Equestrian field 574 2018-08-07T14:00:23.243825+03:00 4 553 {} [574] 0 1403 8 36                                           20       8              
663 [664, 665] Yleisurheilukentät ja -paikat Planer och platser för friidrott Athletics fields and venues   2018-08-07T14:00:24.019648+03:00 3 633 {} [] 0 1403 36 59                                           20       3              
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        
995 [] Hammashoito Tandvård Dental care 184 2020-03-06T18:32:09.101816+02:00 1 986 {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} [184] 0 986 36 98                                           20       41     1        
696 [] Kalastusalue / -paikka Område eller plats för fiske Fishing area/spot 240 2018-08-07T14:00:24.243549+03:00 4 695 {} [240] 0 1403 1 26                                           19       2   4          
829 [] Kotihoito Hemvård Home care 635 2020-03-06T18:32:08.579934+02:00 2 819 {} [635] 0 783 69 95                                           19       4     3        
996 [] Kotihoito Hemvård Home care 635 2020-03-06T18:32:09.105708+02:00 1 986 {} [635] 0 986 69 95                                           19       4     3        
1004 [1005, 1006, 1008] Neuvolat Rådgivningar Maternity and child health guidance 463 2018-08-07T14:00:29.268764+03:00 1 986 {} [463] 0 986 23 53                                           19       10     1        
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                      
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        
352 [353, 354, 355, 356, 357, 358, 359, 360] Kulttuuritilat Kulturlokaler Cultural facilities   2018-08-07T14:00:22.597325+03:00 2 343 {} [] 0 1403 198 232                                           18       13     3        
582 [] Kävelyreitti Promenadled/Friluftsled Outdoor route 364 2018-08-07T14:00:23.426422+03:00 4 577 {} [364] 0 1403 23 42                                           18       1              
706 [710, 711, 712, 713, 714, 716] Virkistys- ja retkeilyalueet Rekreations- och friluftsområden Recreational and outdoor areas   2018-08-07T14:00:24.316869+03:00 3 694 {} [] 0 1403 11 38       1             1   2         3       18     1     1          
151 [] Kokouspaikat Möteslokaler Meeting places 326 2018-08-07T14:00:30.193967+03:00 4 149 {} [326] 0 1401 247 293       1 1         1         2     2       17       22              
171 [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] Hallinto ja talous Förvaltning och ekonomi Administration and economy   2018-08-07T14:00:30.363012+03:00 1 1401 {} [] 0 1401 124 163       1                           1       17       17     2   1    
260 [] Kokouspaikat Möteslokaler Meeting places 326 2018-08-07T14:00:22.232800+03:00 5 258 {} [326] 0 1400 247 293       1 1         1         2     2       17       22              
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              
714 [] Ulkoilualue Friluftsområde Outdoor area 733 2018-08-07T14:00:24.366593+03:00 4 706 {} [733] 0 1403 2 24                         1         3       17           1          
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              
787 [789, 790, 788] Lastensuojelu Barnskydd Child welfare   2018-10-25T08:00:09.006369+03:00 1 783 {} [] 0 783 37 81                               1           17       24 1   1        
1061 [1062, 1065, 1066, 1070, 1076, 1078, 1079, 1080, 1082, 1083] Turvallisuus Säkerhet Public safety   2018-08-07T14:00:29.767356+03:00 0   {} [] 0 1061 130 163                                           17       13     3        
154 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:30.213017+03:00 4 149 {} [803] 0 1401   17                                           16             1        
263 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.252638+03:00 5 258 {} [803] 0 1400   17                                           16             1        
366 [] Nuorisotalot Ungdomsgårdar Youth centres 468 2018-08-07T14:00:22.869007+03:00 2 365 {} [468] 0 1403 39 69                                           16       13     1        
510 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.836894+03:00 3 505 {} [803] 0 1403   17                                           16             1        
519 [] Metroasemat Metrostationer Metro stations 437 2018-08-07T14:00:25.044266+03:00 3 513 {} [437] 0 1402 72 88                                           16                      
1028 [1029, 1031, 1040, 1032, 1033, 1034, 1035, 1036, 1037, 1038] Kuntoutus Rehabilitering Rehabilitation   2018-08-07T14:00:29.478107+03:00 1 986 {} [] 0 986 33 67                                           16       16     2        
1257 [1298, 1258] Lukiokoulutus Gymnasier General upper secondary education   2018-08-07T14:00:26.772637+03:00 1 1087 {} [] 0 1087 37 62                                           16       9              
446 [] Pelit Spel Games 503 2018-08-07T14:00:23.094780+03:00 3 368 {} [503] 0 1403 1 24                                           15       8              
1258 [1260, 1271, 1268, 1296, 1259] Suomen- ja vieraskielinen nuorten lukiokoulutus Gymnasieutbildning för unga på finska och främmande språk General upper secondary education for the young in Finnish, English and other languages   2020-03-06T18:32:08.032022+02:00 2 1257 {} [] 0 1087 31 54                                           15       8              
73 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:21.445519+03:00 2 1 {} [532] 0 1400 44 74                                           14       16              
404 [] Kerhotoiminta Klubbverksamhet Club activities 289 2018-08-07T14:00:22.983998+03:00 3 368 {} [289] 0 1403   22                                           14       7     1        
442 [] Musiikki Musik Music 455 2018-08-07T14:00:23.088590+03:00 3 368 {} [455] 0 1403 4 19                                           14       1              
449 [] Poikakerho / poikaryhmät Pojkklubb / pojkgrupper Boys' club / Boy groups 518 2018-08-07T14:00:23.107321+03:00 3 368 {} [518] 0 1403 1 16                                           14       1              
503 [] Viljelyspalstat Odlingslotter Allotments 532 2018-08-07T14:00:22.776545+03:00 2 343 {} [532] 0 1403 44 74                                           14       16              
665 [] Yleisurheilun harjoitusalue Träningsområde för friidrott Athletics training area 818 2018-08-07T14:00:24.033733+03:00 4 663 {} [818] 0 1403 28 42                                           14                      
699 [] Opastuspiste Information punkt Information point 482 2018-08-07T14:00:24.267790+03:00 4 695 {} [482] 0 1403 51 73       1                 2         2       14       2   1          
1005 [] Lastenneuvola Barnrådgivning Child health clinic 379 2018-10-25T08:00:09.610190+03:00 2 1004 {} [379] 0 986 22 47                                           14       10     1        
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              
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              
362 [363, 364] Museot Museer Museums   2018-08-07T14:00:22.665582+03:00 2 343 {} [] 0 1403 64 96           1                     4 1       13       8 1     4      
376 [] Biljardi Biljard Billiards 126 2018-08-07T14:00:22.918484+03:00 3 368 {} [126] 0 1403   16                                           13       3              
395 [] Internet Internet Internet 202 2018-08-07T14:00:22.950721+03:00 3 368 {} [202] 0 1403 2 15                                           13                      
424 [] Lautapelit Brädspel Board games 387 2018-08-07T14:00:23.039435+03:00 3 368 {} [387] 0 1403   14                                           13       1              
609 [] Kamppailulajien sali Sal för kampsport Martial arts hall 241 2018-08-07T14:00:23.609044+03:00 4 608 {} [241] 0 1403 47 64                                           13       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      
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        
1070 [1071, 1072, 1073, 1074, 1075] Pelastustoimi Räddningsväsendet Rescue services   2018-08-07T14:00:29.845529+03:00 1 1061 {} [] 0 1061 26 46                                           13       6     1        
1187 [1246, 1249, 1193, 1192, 1188, 1190, 1242] Ruotsinkielinen perusopetus Grundläggande utbildning på svenska Basic education in Swedish   2018-08-07T14:00:26.251158+03:00 2 1097 {} [] 0 1087 47 65                                           13       5              
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              
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        
448 [] Pingis Bordtennis Table tennis 515 2018-08-07T14:00:23.100999+03:00 3 368 {} [515] 1 1403 1 17                                           12       4              
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        
810 [815, 816, 817, 813, 812, 811, 818, 814, 1007] Kehitysvammahuolto Vård av utvecklingsstörda Care for the developmentally disabled   2018-08-07T14:00:27.882619+03:00 1 783 {} [] 0 783 56 109                                           12       36     2   3    
830 [836, 837, 834, 833, 835, 832, 831, 838, 2157] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:28.016024+03:00 1 783 {} [] 0 783 29 56                                           12       14     1        
911 [] esiopetus förskoleundervisning pre-primary education 151*160 2018-08-07T14:00:28.512259+03:00 4 905 {} [160, 151] 1 1405 26 39                                           12       1              
991 [] Terveysasemat Hälsostationer Health stations 703 2018-08-07T14:00:29.153043+03:00 1 986 {"fi": ["mielenterveys", "terveysasemat"]} [703] 0 986 25 49                                           12       11     1        
1051 [1057, 1058, 1055, 1054, 1056, 1053, 1052, 1059, 2158] Päihdepalvelut Service för missbrukare Services for substance abusers   2018-08-07T14:00:29.682313+03:00 1 986 {} [] 0 986 29 56                                           12       14     1        
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                      
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              
1189 [] ruotsinkielinen opetus undervisning på svenska education in Swedish 601 2018-08-07T14:00:26.265483+03:00 4 1188 {} [601] 1 1087 21 37                                           12       4              
1376 [] Koulu- ja opiskelijaruokailu Måltider för elever och studerande Meals for pupils and students 338 2020-08-20T14:00:09.319013+03:00 1 1087 {} [338] 0 1087 119 136                                           12       4     1        

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