service_node

1,140 rows sorted by unit_count_municipality_sipoo 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_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

unit_count_municipality_porvoo ✖

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ää
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          
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        
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        
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        
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        
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        
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    
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        
548 [] Ulkoilusaaret Friluftsöar Recreational islands 735 2018-10-25T08:00:07.487309+03:00 4 547 {} [735] 0 1402 54 69 1     2                 1   1     1       9                      
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        
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        
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    
798 [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] Vammaispalvelut Handikapptjänster Services for the disabled   2018-08-07T14:00:27.804536+03:00 1 783 {} [] 0 783 14 59       2                                   7       34     1   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
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    
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        
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      
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    
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    
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        
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    
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        
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        
4 [] Asumisen tuet Bostadsbidrag Housing allowances 75 2018-08-07T14:00:21.243003+03:00 2 2 {} [75] 0 1400 3 9       1                                   2       2         1    
130 [] Eläkkeet Pensioner Pension matters 143 2018-08-07T14:00:30.054750+03:00 2 122 {} [143] 0 1401 4 10       1                                   2       2         1    
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        
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        
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              
152 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:30.200626+03:00 4 149 {} [214] 0 1401 218 249       1 1         1   1           1       10       13     3        
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    
187 [188, 189] Maahanmuutto Invandring Immigration   2018-08-07T14:00:30.506450+03:00 2 171 {} [] 0 1401 17 29       1                                   4       5     1   1    
188 [] Kelan etuudet FPA:s förmåner Kela benefits 286 2018-08-07T14:00:30.511334+03:00 3 187 {} [286] 0 1401 3 9       1                                   2       2         1    
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        
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        
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        
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        
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              
261 [] Juhlatilat Festlokaler Banquet facilities 214 2018-08-07T14:00:22.239469+03:00 5 258 {} [214] 0 1400 218 249       1 1         1   1           1       10       13     3        
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      
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        
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        
405 [] Kesätoiminta Sommarverksamhet Summer activities 291 2018-08-07T14:00:22.992018+03:00 3 368 {} [291] 0 1403 1 4       1                                   1       1              
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        
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              
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        
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                      
561 [] Ampumaurheilukeskus Sportskyttecentrum Shooting sports centre 55 2018-08-07T14:00:23.299465+03:00 4 559 {} [55] 0 1403   1       1                                                          
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        
592 [593, 594, 595, 596] Maastohiihtokeskukset Längdåkningscentra Cross-country ski resorts   2018-08-07T14:00:23.496608+03:00 3 558 {} [] 0 1403 3 8       1                                   2       2              
593 [] Ampumahiihdon harjoittelualue Träningsområde för skidskytte Training area for biathlon 52 2018-08-07T14:00:23.502563+03:00 4 592 {} [52] 0 1403   1       1                                                          
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          
702 [] Telttailu ja leiriytyminen Tältning och läger Camping 698 2018-08-07T14:00:24.290069+03:00 4 695 {} [698] 0 1403 2 12       1                                   8           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          
711 [] Monikäyttöalue, jolla on virkistyspalveluita Allaktivitetsområde med rekreationstjänster Multipurpose area with recreational services 442 2018-08-07T14:00:24.344046+03:00 4 706 {} [442] 0 1403 1 3       1                 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      
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      
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        
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              
797 [] Lapsiperheen tuet Förmåner för barnfamiljer Benefits for families with children 370 2020-08-20T14:00:09.399199+03:00 1 783 {} [370] 0 783 3 9       1                                   2       2         1    
801 [] Vammaispalvelun sosiaaliohjaus Socialhandledning inom handikappservice Services for the disabled, social care work 751 2018-08-07T14:00:27.822488+03:00 2 798 {} [751] 0 783   33       1                                           32              
803 [] Vammaispalvelun asumispalvelut Boendetjänster inom handikappservicen Services for the disabled, residential services 746 2018-08-07T14:00:27.835887+03:00 2 798 {} [746] 0 783 7 24       1                                   3       13              
809 [] Vammaistuet ja -palvelut Handikappbidrag och -tjänster Disability benefits and services 755 2018-08-07T14:00:27.876348+03:00 2 798 {} [755] 0 783 3 15       1                                   2       7     1   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    
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    
839 [2011, 841, 843, 2012] Toimeentulotuki Utkomststöd Social assistance   2018-08-07T14:00:28.080690+03:00 1 783 {} [] 0 783 11 20       1                                   3       3     1   1    
843 [] Perustoimeentulotuki Grundläggande utkomststöd Basic social assistance 711 2018-08-07T14:00:28.092481+03:00 2 839 {} [711] 0 783 3 9       1                                   2       2         1    
845 [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] Muu sosiaalihuolto Övrig socialvård Other social welfare   2018-08-07T14:00:28.112184+03:00 1 783 {} [] 0 783 105 239       1                                   11       118     3   1    
847 [] Alueellinen kumppanuustyö Områdesvist partnerskapsarbete Regional partnership work 49 2018-08-07T14:00:28.124411+03:00 2 845 {} [49] 0 783 19 119       1                                   1       96     1   1    
852 [] Muun sosiaalihuollon asumispalvelut Boendetjänster inom övrig socialvård Residential services for other social welfare 637 2018-08-07T14:00:28.163665+03:00 2 845 {} [637] 0 783 11 26       1                                   1       12     1        
1017 [] Laboratorio Laboratorium Laboratory 366 2018-08-07T14:00:29.386729+03:00 1 986 {} [366] 0 986 22 88   3 1 1   3   1 1       1 1 2 6 3 3 1 7 1 10 1 3 1 8 1 1 2 1 1 1 1
1018 [] Röntgen Röntgen X-rays 606 2018-08-07T14:00:29.396972+03:00 1 986 {} [606] 0 986 11 42 1 1   1   1                 2 1 1 1 1 1 1 6   1 1 6 1 1   1 1 1  
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    
1377 [] Oppilaan ja opiskelijan tuet Förmåner för elever och studerande Pupil and student benefits 485 2018-08-07T14:00:27.654181+03:00 1 1087 {} [485] 0 1087 4 15       1                                   7       2         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        
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 {} [74] 0 1400   1                     1                                            
6 [] Kaupungin asumisoikeusasunnot stadens bostadsrättsbostäder City's right of residence apartments 261 2018-08-07T14:00:21.255121+03:00 3 5 {} [261] 0 1400 1 1                                                                  
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} [79] 0 1400 1 3                                           1       1              
8 [10, 9, 11] Vuokra-asuminen Hyresbostäder Rental flats   2018-08-07T14:00:21.267377+03:00 2 2 {} [] 0 1400 9 13                                           3             1        
9 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:21.273119+03:00 3 8 {} [268] 0 1400 9 12                                           2             1        
10 [] Kaupungin tai kunnan työsuhdeasunnot Stadens eller kommunens tjänstebostäder City's or municipality's housing provided by the employer 267 2018-08-07T14:00:21.280357+03:00 3 8 {} [267] 0 1400 2 3                                           1                      
11 [] Opiskelija-asunnot Studentbostäder Student housing 484 2018-08-07T14:00:21.287386+03:00 3 8 {} [484] 0 1400   1                                           1                      
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              
18 [] Koirakäymälät Hundtoaletter Dog toilets 319 2018-08-07T14:00:21.700490+03:00 3 16 {} [319] 0 1400 5 5                                                                  
19 [] Koirametsät Hundskogar Forest dog runs 320 2018-08-07T14:00:21.707130+03:00 3 16 {} [320] 0 1400 1 1                                                                  
20 [] Koirauimarannat Hundbadstränder Dog beaches 321 2018-08-07T14:00:21.713262+03:00 3 16 {} [321] 0 1400 4 5                                                   1              
21 [] Opaskoira-aitaukset Inhägnat områden för ledarhundar Fenced areas for guide dogs 480 2018-08-07T14:00:21.719558+03:00 3 16 {} [480] 0 1400 2 2                                                                  
23 [] Luonnonvaraisten eläinten hoitola Vårdanstalt för vilda djur Wildlife home 411 2018-08-07T14:00:21.732081+03:00 2 14 {} [411] 0 1400 1 1                                                                  
24 [25, 26, 27] Energia Energi Energy   2018-08-07T14:00:21.738244+03:00 1 1400 {} [] 0 1400 6 7                                                   1              
25 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:21.743023+03:00 2 24 {} [62] 0 1400 1 2                                                   1              
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} [146] 0 1400 1 1                                                                  
27 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:21.755624+03:00 2 24 {} [798] 0 1400 4 4                                                                  
28 [29] Hallinto Förvaltning Administration   2018-08-07T14:00:21.313217+03:00 2 1 {} [] 0 1400   1                                                   1              
29 [] Ympäristölautakunta Miljövårdsnämnden Environment committee 824 2018-08-07T14:00:21.318211+03:00 3 28 {} [824] 0 1400   1                                                   1              
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        
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} [232] 0 1400 1 2                                                         1        
33 [] Jätteenkäsittelykeskus Avfallshanteringscentral Waste treatment centre 234 2018-08-07T14:00:21.773147+03:00 2 31 {} [234] 0 1400   1                                           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
);