service_node

1,140 rows sorted by unit_count_municipality_espoo descending

✎ View and edit SQL

This data as json, CSV (advanced)

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_hamina, 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

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ää
1403 [343, 551, 717, 365] Kulttuuri, liikunta ja vapaa-aika Kultur, motion och fritid Culture, sports and leisure   2018-08-07T14:00:22.534057+03:00 0   {} [] 0 1403 5769 8871 1     18 1 1       1 12 1 20   3 1 6 14       1685     1 1238 1 37 57 4      
551 [552, 2151, 558, 2217, 601, 633, 666, 684, 694] Liikunta Idrott och motion Sports and physical exercise   2018-08-07T14:00:23.220207+03:00 1 1403 {} [] 0 1403 2590 4872       16             3   19     1 1 11       1260     1 892   36 42        
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    
633 [634, 639, 646, 654, 663] Ulkokentät ja liikuntapuistot Utomhusplaner och idrottsparker Outdoor fields and sports parks   2018-08-07T14:00:23.790680+03:00 2 551 {} [] 0 1403 1261 2383                         1     1           636       457   4 23        
1402 [306, 512] Liikenne ja kartat Trafik och kartor Traffic and maps   2018-08-07T14:00:24.647447+03:00 0   {} [] 0 1402 1567 2238 1     4             1   2   1     2       581       71     8        
512 [513, 521, 525, 526, 533, 534, 541] Liikenne Trafik Traffic   2018-08-07T14:00:24.996122+03:00 1 1402 {} [] 0 1402 1269 1864 1     4                 2   1     2       540       39     6        
526 [527, 528, 2207, 529, 530, 2204, 532] Pysäköinti Parkering Parking   2018-08-07T14:00:25.093849+03:00 2 512 {} [] 0 1402 559 1023                                           460       2     2        
343 [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] Kulttuuri ja vapaa-aika Kultur och fritid Culture and leisure   2018-08-07T14:00:22.539281+03:00 1 1403 {} [] 0 1403 1745 2452       1 1 1       1 8 1     2   4 2       382       286 1   13 4      
1405 [2118, 868, 2163] Päivähoito ja esiopetus Barndagvård och förskola Daycare and pre-primary education   2020-03-06T18:32:08.672148+02:00 0   {} [] 0 1405 951 1546                                           367       216     12        
868 [2029, 975, 961, 985, 869, 983] Lasten päivähoito Barndagvård Day care   2020-03-06T18:32:08.678128+02:00 1 1405 {} [] 0 1405 675 1264                                           365       212     12        
532 [] Yleiset pysäköintialueet Allmänna parkeringsområden Public parking lot 814 2018-08-07T14:00:25.132843+03:00 3 526 {} [814] 0 1402 1 346                                           343             2        
869 [897, 905, 913, 921, 929, 881, 889, 937, 870, 945, 2238, 953] Päiväkotihoito Daghemsvård Day care centres   2018-08-07T14:00:28.258090+03:00 2 868 {} [] 0 1405 497 1020                                           329       184     10        
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        
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        
601 [602, 606, 608, 614, 624] Sisäliikuntatilat Anläggningar för inomhusidrott Indoor sports facilities   2018-08-07T14:00:23.557871+03:00 2 551 {} [] 0 1403 795 1314                                           278       229     12        
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        
871 [] päivähoito dagvård day care 663 2019-03-05T14:30:09.346786+02:00 4 870 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [663] 0 1405 389 845                                           277       173     6        
1087 [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] Opetus ja koulutus Undervisning och utbildning Teaching and education   2018-08-07T14:00:25.275863+03:00 0   {} [] 0 1087 1214 1867       1                       2           274       362 2   11   1    
60 [61, 62, 68, 2236, 71, 72] Puistot ja viheralueet Parker och grönområden Parks and green areas   2018-08-07T14:00:21.354530+03:00 2 1 {} [] 0 1400 520 967                     1                     268       173     5        
491 [492, 493, 499, 2237, 502, 2235] Puistot ja viheralueet Parker och grönområden Parks and green areas   2018-08-07T14:00:22.684763+03:00 2 343 {} [] 0 1403 520 967                     1                     268       173     5        
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    
5 [6] Asumisoikeusasuminen Bostadsrättsbostäder Right-of-occupancy housing 76 2018-08-07T14:00:21.249052+03:00 2 2 {} [76] 0 1400 331 1108       15   23 1               27   51 40       242     3 253 35 10   37 40    
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        
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        
70 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:21.425954+03:00 4 68 {} [389] 0 1400 224 567                                           193       145     5        
501 [] Leikkipaikat (ei ohjattua toimintaa) Lekplatser (ingen handledd verksamhet) Play areas (no supervised activities) 389 2018-08-07T14:00:22.761746+03:00 4 499 {} [389] 0 1403 224 567                                           193       145     5        
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        
659 [] Pallokenttä Bollplan Ball field 495 2018-08-07T14:00:23.987386+03:00 4 654 {} [495] 0 1403 408 743                                           169       161     5        
31 [32, 33, 34, 52, 53, 54] Jätehuolto ja kierrätys Avfallshantering och återvinning Waste management and recycling   2018-08-07T14:00:21.761620+03:00 1 1400 {} [] 0 1400 215 572                                   1       150       186     20        
34 [35, 36, 37, 38, 2211, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51] Keräyspisteet Insamlingsplatser Collection points   2018-08-07T14:00:21.780177+03:00 2 31 {} [] 0 1400 210 565                                           150       185     20        
694 [695, 706] Virkistyskohteet ja palvelut Rekreationsanläggningar och tjänster Recreational destinations and services   2018-08-07T14:00:24.231367+03:00 2 551 {} [] 0 1403 235 442       11             1   13         11       143     1 7   19 1        
783 [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] Perhe- ja sosiaalipalvelut Familje- och socialservice Family and social services   2018-08-07T14:00:27.699133+03:00 0   {} [] 0 783 397 718       2             1         1           129       175 1   7   5    
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        
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        
986 [990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994] Terveys Hälsovård Health care   2018-08-07T14:00:29.110723+03:00 0   {} [] 0 986 556 949 1 4 1 2   4   1 1   3   1 1 5 9 4 4 2 8 2 122 1 6 2 183 5 2 12 2 2 2 1
558 [559, 564, 567, 572, 575, 577, 592, 597] Maastoliikuntapaikat Anläggningar för terrängidrott Cross-country sports facilities   2018-08-07T14:00:23.281875+03:00 2 551 {} [] 0 1403 151 443       5                 1       1         118       153   9 5        
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        
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        
642 [] Luistelukenttä Skridskobana Ice-skating field 406 2018-08-07T14:00:23.848959+03:00 4 639 {} [406] 0 1403 136 308                                           100       70     2        
653 [] Ulkokuntoiluvälineet Konditionspark för utomhusaktiviteter Fitness training park 737 2018-08-07T14:00:23.939410+03:00 4 646 {} [737] 0 1403 168 320                                           100       43   3 6        
612 [] Liikuntasali Idrottssal Gymnastics hall 402 2018-08-07T14:00:23.630490+03:00 4 608 {} [402] 0 1403 308 512                                           97       102     5        
1097 [1187, 1255, 1098] Perusopetus Grundläggande utbildning Basic education   2018-08-07T14:00:25.451107+03:00 1 1087 {} [] 0 1087 414 568                               1           97       55 1            
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                      
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              
1401 [122, 171, 755] Työ, talous ja hallinto Arbete, ekonomi och förvaltning Employment and public authorities   2020-03-06T18:32:09.344909+02:00 0   {} [] 0 1401 448 629       2 1         1 2 1     2     3       88       74     6   1    
717 [754, 718, 2173, 2028] Matkailu ja tapahtumat Turism och evenemang Things to do   2020-03-06T18:32:07.102459+02:00 1 1403 {} [] 0 1403 1973 2155       1 1 1       1 2 1 1   3   5 3       87       67 1 1 3 4      
1098 [1173, 1181, 1177, 1120, 1119, 1099, 1109, 1174, 1169, 2014, 2215, 2216] Suomen- ja vieraskielinen perusopetus Grundläggande utbildning på finska och främmande språk Basic education in Finnish, English and other languages   2020-03-06T18:32:07.543511+02:00 2 1097 {} [] 0 1087 368 504                               1           84       50 1            
718 [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] Matkailu Turism Tourism   2018-08-07T14:00:24.401683+03:00 2 717 {} [] 0 1403 1880 2050       1 1 1       1 1 1 1   3   5 3       79       64 1 1 3 4      
1089 [1090] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:07.479235+02:00 2 1088 {} [861] 1 1087 289 484                                           78       117              
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              
2122 [2125] Suomen- ja vieraskielinen esiopetus Förskoleundervisning på finska och främmande språk Pre-primary education in Finnish, English and other languages 861 2020-03-06T18:32:09.045855+02:00 2 2118 {} [861] 1 1405 289 484                                           78       117              
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              
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            
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 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] 1 1087 108 211                               1           73       28 1            
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            
819 [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] Vanhuspalvelu Äldreomsorg Service for the elderly   2018-08-07T14:00:27.946229+03:00 1 783 {} [] 0 783 142 261       1                                   67       44     6   1    
879 [] esiopetus förskoleundervisning pre-primary education 663*160+861*160 2018-10-24T23:30:08.464088+03:00 4 870 {} [861, 663, 160] 1 1405 266 448                                           66       116              
648 [] Lähiliikuntapaikka Näridrottsplats Neighbourhood sports area 415 2018-08-07T14:00:23.898085+03:00 4 646 {} [415] 0 1403 134 229                               1           64       26     4        
657 [] Koripallokenttä Basketplan Basketball court 331 2018-08-07T14:00:23.971455+03:00 4 654 {} [331] 0 1403 153 256                                           64       37     2        
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            
1100 [] suomenkielinen opetus undervisning på finska education in Finnish 661 2018-10-25T08:00:07.595003+03:00 4 1099 {} [661] 1 1087 104 205                                           62       38 1            
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        
221 [222, 231, 270, 305] Kaavoitus, kiinteistöt ja rakentaminen Planläggning, fastigheter och byggande Planning, real estate and construction   2018-08-07T14:00:21.996119+03:00 1 1400 {} [] 0 1400 367 506       1 1         1 1 1     3     2       54       69     6        
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    
684 [685, 690] Vesiliikuntapaikat Anläggningar för vattenidrott Water sports facilities   2018-08-07T14:00:24.163817+03:00 2 551 {} [] 0 1403 78 153                         4                 51       15   4 1        
961 [962, 2145] Perhepäivähoito Familjedagvård Family day care   2018-08-07T14:00:28.863138+03:00 2 868 {} [] 0 1405 71 134                                           51       11     1        
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        
71 [] Viheralueet Grönområden Green areas 786 2018-08-07T14:00:21.432517+03:00 3 60 {} [786] 0 1400 51 102                     1                     50                      
502 [] Viheralueet Grönområden Green areas 786 2018-08-07T14:00:22.769184+03:00 3 491 {} [786] 0 1403 51 102                     1                     50                      
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 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 35] 1 1087 58 124                                           50       16              
1359 [] Yliopistot Universitet Universities 822 2018-08-07T14:00:27.510881+03:00 1 1087 {} [822] 0 1087 10 60                                           50                      
231 [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] Kiinteistöt ja rakennetut tilat Fastigheter Real estate   2018-08-07T14:00:22.059452+03:00 2 221 {} [] 0 1400 311 427       1 1         1   1     2     2       48       55     5        
963 [] Suomenkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på finska Group family day care in Finnish 664 2018-10-25T08:00:09.441773+03:00 4 2145 {"fi": ["suomi"]} [664] 0 1405 50 107                                           47       9     1        
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        
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        
541 [542, 547] Vesiliikenne Sjötrafik Water traffic   2018-08-07T14:00:25.190941+03:00 2 512 {} [] 0 1402 223 279 1     4                 2   1     2       45             1        
547 [548, 2199, 549, 2143, 2142] Veneily Båtsport Boating   2018-08-07T14:00:25.237133+03:00 3 541 {} [] 0 1402 206 262 1     4                 2   1     2       45             1        
611 [] Kuntosali Gym Gym 350 2018-08-07T14:00:23.623495+03:00 4 608 {} [350] 0 1403 151 237                                           45       39     2        
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        
146 [147, 148, 149, 156] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:30.157480+03:00 2 122 {} [] 0 1401 294 380       1 1         1   1     2     2       42       32     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        
306 [307, 314, 320, 324, 329, 342] Kartat, tietopalvelut ja viestintä Kartor, informationstjänster och kommunikation Maps, information services and communication   2018-08-07T14:00:24.652419+03:00 1 1402 {} [] 0 1402 307 389                     1                     42       36     3        
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        
258 [2210, 259, 261, 260, 263, 264] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:22.220951+03:00 4 255 {} [] 0 1400 292 375       1 1         1   1     2     2       40       31     4        
505 [2208, 506, 508, 507, 510, 511] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:22.797039+03:00 2 343 {} [] 0 1403 292 375       1 1         1   1     2     2       40       31     4        
583 [] Latu Skidspår Ski track 191 2018-08-07T14:00:23.433650+03:00 4 577 {} [191] 0 1403 45 208       2                         1         39       117   3 1        
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          
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 {} [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 34] 1 1087 57 117                                           39       21              
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        
542 [543, 544, 545, 2198, 546, 2144] Satamat ja laiturit Hamn och bryggor Harbours, piers and quays   2018-08-07T14:00:25.196186+03:00 3 541 {} [] 0 1402 168 209       2                 1         1       36             1        
546 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.230897+03:00 4 542 {} [769] 0 1402 147 188       2                 1         1       36             1        
617 [] Monitoimihalli / areena Allaktivitetshall/multiarena Multipurpose hall/arena 444 2018-08-07T14:00:23.665496+03:00 4 614 {} [444] 0 1403 97 133                                           36                      
705 [] Venesatama Serviceplats för båtfarare Boating services 769 2018-08-07T14:00:24.310541+03:00 4 695 {} [769] 0 1403 147 188       2                 1         1       36             1        
825 [] Vanhusten palveluasuminen Serviceboende för äldre Service residence for the elderly 760 2018-08-07T14:00:27.984445+03:00 2 819 {} [760] 0 783 30 103       1                                   36       32     3   1    
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} [769] 0 1402 147 188       2                 1         1       36             1        
701 [] Ruoanlaittopaikka Matlagningsplats Cooking facilities 586 2018-08-07T14:00:24.282789+03:00 4 695 {} [586] 0 1403 17 77       6                 8         4       33           9          
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        

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