service

127 rows where root_service_node = 1400 sorted by unit_count_total

✎ View and edit SQL

This data as json, CSV (advanced)

root_service_node ✖

  • 1400 · 27 ✖
id name_fi name_sv name_en period_enabled clarification_enabled keywords root_service_node 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_null unit_count_municipality_nurmijärvi unit_count_municipality_virolahti unit_count_municipality_pornainen unit_count_municipality_hämeenlinna unit_count_municipality_salo 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_kotka unit_count_municipality_askola 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_karkkila unit_count_municipality_järvenpää unit_count_municipality_kerava unit_count_municipality_pyhtää
298 kierrätyskeskukset återvinningscentraler recycling centres 0 0 {} 1400 3 7                                   1       1       1     1        
491 pahvinkeräys insamling av wellpapp corrugated cardboard recycling 0 0 {} 1400 2 7                                           1       2     2        
799 vuokrattavat harrastustilat fritidslokaler för uthyrning recreational space for rent 0 0 {} 1400 3 8                                           2       1     2        
75 asumisen tuet bostadsbidrag housing allowances 0 0 {} 1400 3 9       1                                   2       2           1  
237 kaavat ja kaavoitus planer och planläggning town plans and zoning 0 0 {} 1400 5 9                                           1       2     1        
268 kaupungin tai kunnan vuokra-asunnot stadens eller kommunens hyresbostäder city's or municipality's rental apartments 0 0 {} 1400 9 12                                           2             1        
714 torit torg market squares 0 0 {} 1400 15 15                                                                  
419 maa-alueiden vuokraus ja myynti utarrendering och försäljning av markområden selling or renting land areas 0 0 {} 1400   17                                                   17              
252 katujen ja viheralueiden suunnittelu ja rakennuttaminen planering och byggande av gator och grönområden design and development of streets and parks 0 0 {} 1400 1 18                                           2       14     1        
668 sähkö- ja elektroniikkaromun keräys insamling av el- och elektronikskrot waste electrical and electronic equipment collection 0 0 {} 1400 11 24                                           7       6              
67 asiakaspalvelu (vesihuolto) kundtjänst (vattenförsörjning) customer services (water supply) 0 0 {} 1400 26 26                                                                  
432 matonpesupaikat mattvättplatser carpet washing places 0 0 {} 1400 13 29                                           5       11              
819 yleisövessat allmänna toaletter public toilets 0 0 {} 1400 39 39                                                                  
740 vaarallisen jätteen keräys insamling av farligt avfall hazardous waste collection 0 0 {} 1400 16 44                                           11       17              
497 paristonkeräys batteriinsamling small battery recycling 0 0 {"fi": ["paristot"]} 1400 16 46                                           12       18              
369 lamppujen keräys insamling av lampor lamp recycling 0 0 {"fi": ["lamput"]} 1400 21 54                                           13       20              
454 muovinkeräys plastinsamling plastic recycling 0 0 {} 1400 23 70                                           29       16     2        
45 akkujen keräys ackumulatorinsamling car battery recycling 0 0 {"fi": ["akut"]} 1400 34 79                                           18       26     1        
696 tekstiilien keräys textilinsamling textile recycling 0 0 {} 1400 40 108                                           37       29     2        
436 metallinkeräys metallinsamling metal waste collection 0 0 {} 1400 50 137                                           46       37     4        
374 lasinkeräys glasinsamling glass recycling 0 0 {} 1400 50 138                                           46       37     5        
246 kartonginkeräys kartonginsamling cardboard recycling 0 0 {"fi": ["kartonki"]} 1400 54 140                                           46       36     4        
317 koira-aitaukset hundparker dog parks 0 0 {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} 1400 94 140                                           22       24              
886 ääniopastetut suojatiet skyddsväg med ljudsignal i trafikljus audible pedestrian signal in pedestrian crossing 0 0 {} 1400 351 351                                                                  
877 Hitas-asunnot Hitas-bostäder Hitas owner-occupied housing 0 0 {} 1400 399 399                                                                  
496 paperinkeräys pappersinsamling paper recycling 0 0 {} 1400 166 466                                           125       156     19        
76 asumisoikeusasuminen bostadsrättsboende right-of-occupancy housing 0 0 {} 1400 330 1107       15     23       1       27   51 40       242     3 253 35 10     37 40  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [service] (
   [name_fi] TEXT,
   [name_sv] TEXT,
   [name_en] TEXT,
   [id] INTEGER PRIMARY KEY,
   [period_enabled] INTEGER,
   [clarification_enabled] INTEGER,
   [keywords] TEXT,
   [root_service_node] 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_null] INTEGER,
   [unit_count_municipality_nurmijärvi] TEXT,
   [unit_count_municipality_virolahti] TEXT,
   [unit_count_municipality_pornainen] TEXT,
   [unit_count_municipality_hämeenlinna] TEXT,
   [unit_count_municipality_salo] 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] TEXT,
   [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_kotka] TEXT,
   [unit_count_municipality_askola] TEXT,
   [unit_count_municipality_mäntsälä] TEXT,
   [unit_count_municipality_vantaa] INTEGER,
   [unit_count_municipality_hyvinkää] TEXT,
   [unit_count_municipality_vihti] TEXT,
   [unit_count_municipality_kauniainen] INTEGER,
   [unit_count_municipality_karkkila] TEXT,
   [unit_count_municipality_järvenpää] TEXT,
   [unit_count_municipality_kerava] TEXT,
   [unit_count_municipality_pyhtää] TEXT
);