service_node

1,140 rows sorted by unit_count_municipality__unknown 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_järvenpää, unit_count_municipality_kerava, unit_count_municipality_karkkila

unit_count_municipality_kauniainen ✖

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ää
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      
2006 [] Veistokset ja julkinen taide Skulpturer och offentlig konst Sculptures and public art 767 2018-08-07T14:00:22.854537+03:00 2 343 {"fi": ["patsas", "patsaat", "veistos"]} [767] 0 1403 482 488                     6                                            
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    
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        
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
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        
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    
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      
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    
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      
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    
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                                            
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        
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                      
100 [] Ympäristön sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för miljöärenden Electronic services and forms related to environmental matters 826 2018-08-07T14:00:21.554721+03:00 2 1 {} [826] 0 1400   1                     1                                            
128 [] Elinkeinopalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för näringslivsservicen Electronic services and forms related to business services 135 2018-08-07T14:00:30.039148+03:00 2 122 {} [135] 0 1401   1                     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        
270 [271, 272, 277, 278, 279, 286, 287, 293, 302] Rakentaminen Byggande Construction   2018-08-07T14:00:22.314988+03:00 2 221 {} [] 0 1400 48 80                     1       1             8       21     1        
286 [] Rakentamisen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter i byggärenden Electronic services and forms related to construction 565 2018-08-07T14:00:22.418594+03:00 3 270 {} [565] 0 1400   2                     1                     1                      
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        
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        
318 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:24.764164+03:00 4 2147 {} [71] 0 1402 1 9                     1                     1       6              
351 [] Kulttuuripalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för kulturtjänster Electronic services and forms related to cultural services 346 2018-08-07T14:00:22.590770+03:00 2 343 {} [346] 0 1403   2                     1                             1              
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        
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                      
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        
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          
716 [] Virkistysmetsä Friluftsskog Recreational forest 791 2018-08-07T14:00:24.380867+03:00 4 706 {} [791] 0 1403   1                     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      
719 [721, 723, 724, 725, 730] Eläintarhat Djurparker Zoos   2018-08-07T14:00:24.415879+03:00 3 718 {} [] 0 1403 13 14                     1                                            
723 [] Lipunmyynti Biljettförsäljning Ticket sales 403 2018-08-07T14:00:24.435423+03:00 4 719 {} [403] 0 1403 3 4                     1                                            
754 [] Lipunmyynti tapahtumiin Biljettförsäljning till evenemang Ticket sales to events 405 2018-08-07T14:00:24.631976+03:00 2 717 {} [405] 0 1403 5 13                     1                     6       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    
784 [786, 785] 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:27.703824+03:00 1 783 {} [] 0 783 1 13                     1                     3       8              
785 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:27.709008+03:00 2 784 {} [71] 0 783 1 9                     1                     1       6              
988 [2146, 989] 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:29.124487+03:00 1 986 {} [] 0 986 1 13                     1                     3       8              
989 [] Sosiaali- ja terveyspalvelujen neuvonta Social- och hälsovårdstjänsternas rådgivning Social and health services information and advice 71 2018-08-07T14:00:29.129777+03:00 2 988 {} [71] 0 986 1 9                     1                     1       6              
999 [] Myrkytystietoa Giftinformation Poison information 461 2018-08-07T14:00:29.228018+03:00 1 986 {} [461] 0 986   1                     1                                            
1060 [] Terveyspalvelujen sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter inom hälso- och sjukvården Electronic services and forms related to health services 704 2018-08-07T14:00:29.759443+03:00 1 986 {} [704] 0 986   2                     1                             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        
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              
2151 [] Liikunnan sähköinen asiointi ja lomakkeet Elektroniska tjänster och formulär för motion Electronic services and forms related to sports 849 2018-08-07T14:00:24.387923+03:00 2 551 {} [849] 0 1403   1                     1                                            
2217 [2218, 2219, 2220, 2221, 2223, 2224, 2225, 2226] Senioriliikunta Seniormotion Senior sports   2020-06-09T15:30:11.296799+03:00 2 551 {} [] 0 1403 88 104                     1                     4       10     1        
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        
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    
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    
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                      
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        
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        
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} [127] 0 1400 2 4                                           1       1              
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} [145] 0 1400   1                                                   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        
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              
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        
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        
44 [] Pahvinkeräys Insamling av wellpapp Corrugated cardboard recycling 491 2018-08-07T14:00:21.860147+03:00 3 34 {} [491] 0 1400 2 7                                           1       2     2        
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        
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              
47 [] Puujäte Träavfall Wood waste 531 2018-08-07T14:00:21.882472+03:00 3 34 {} [531] 0 1400 2 5                                           2       1              
48 [] Sekajäte Blandat avfall Mixed waste 617 2018-08-07T14:00:21.889545+03:00 3 34 {} [617] 0 1400 2 6                                           2       1     1        
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              
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        
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              
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} [298] 0 1400 3 7                                   1       1       1     1        
53 [] Ongelmajäteasema Problemavfall station Waste management station 478 2018-08-07T14:00:21.933801+03:00 2 31 {} [478] 0 1400 1 2                                           1                      
54 [] Rantavesien ja sisäsaariston puhtaanapito Renhållning av strandvatten och inre skärgård Cleaning waterfronts and inner archipelago 572 2018-08-07T14:00:21.940289+03:00 2 31 {} [572] 0 1400 2 2                                                                  
57 [] Luonnonsuojelu Naturskydd Environmental protection 410 2018-08-07T14:00:21.330807+03:00 2 1 {} [410] 0 1400 2 4                                           1       1              
58 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:21.337453+03:00 2 1 {} [418] 0 1400 1 1                                                                  
59 [] Matonpesupaikat Mattvättningsplatser Carpet washing places 432 2018-08-07T14:00:21.345565+03:00 2 1 {} [432] 0 1400 13 29                                           5       11              
61 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:21.361137+03:00 3 60 {} [238] 0 1400 49 49                                                                  
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              
64 [] Koirakäymälät Hundtoaletter Dog toilets 319 2018-08-07T14:00:21.387379+03:00 4 62 {} [319] 0 1400 5 5                                                                  
65 [] Koirametsät Hundskogar Forest dog runs 320 2018-08-07T14:00:21.393701+03:00 4 62 {} [320] 0 1400 1 1                                                                  
66 [] Koirauimarannat Hundbadstränder Dog beaches 321 2018-08-07T14:00:21.400222+03:00 4 62 {} [321] 0 1400 4 5                                                   1              
67 [] Opaskoira-aitaukset Inhägnat områden för ledarhundar Fenced areas for guide dogs 480 2018-08-07T14:00:21.407013+03:00 4 62 {} [480] 0 1400 2 2                                                                  
68 [70, 69] Leikkipuistot Lekparker Playgrounds   2018-08-07T14:00:21.413441+03:00 3 60 {} [] 0 1400 293 647                                           201       148     5        

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