186 rows where root = 1400 sorted by unit_count_municipality_espoo

View and edit SQL

Suggested facets: level, keywords, unit_count_municipality_sipoo, unit_count_municipality__unknown, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_kauniainen, unit_count_municipality_kerava, last_modified_time (date)

root

  • 1400 · 186
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ää
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 {} 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 {} 0 1400 1 1                                                                  
18 [] Koirakäymälät Hundtoaletter Dog toilets 319 2018-08-07T14:00:21.700490+03:00 3 16 {} 0 1400 5 5                                                                  
19 [] Koirametsät Hundskogar Forest dog runs 320 2018-08-07T14:00:21.707130+03:00 3 16 {} 0 1400 1 1                                                                  
20 [] Koirauimarannat Hundbadstränder Dog beaches 321 2018-08-07T14:00:21.713262+03:00 3 16 {} 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 {} 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 {} 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 {} 0 1400 1 2                                                   1              
26 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:21.749651+03:00 2 24 {} 0 1400 1 1                                                                  
27 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:21.755624+03:00 2 24 {} 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 {} 0 1400   1                                                   1              
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} 0 1400 1 2                                                         1        
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} 0 1400   1                                                   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 {} 0 1400 2 2                                                                  
58 [] Löytötavarapalvelu Hittegodsservice Found Property Service 418 2018-08-07T14:00:21.337453+03:00 2 1 {} 0 1400 1 1                                                                  
61 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:21.361137+03:00 3 60 {} 0 1400 49 49                                                                  
64 [] Koirakäymälät Hundtoaletter Dog toilets 319 2018-08-07T14:00:21.387379+03:00 4 62 {} 0 1400 5 5                                                                  
65 [] Koirametsät Hundskogar Forest dog runs 320 2018-08-07T14:00:21.393701+03:00 4 62 {} 0 1400 1 1                                                                  
66 [] Koirauimarannat Hundbadstränder Dog beaches 321 2018-08-07T14:00:21.400222+03:00 4 62 {} 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 {} 0 1400 2 2                                                                  
72 [] Viheralueiden hoito Skötsel av grönområden Green area maintenance 787 2020-12-02T11:30:08.056281+02:00 3 60 {} 0 1400 1 1                                                                  
75 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:21.457195+03:00 3 74 {} 0 1400 1 5                                                   4              
79 [] Tierakenteiden tiiviys- ja kantavuusmittaus Mätning av vägkonstruktioners täthet och bärkraft Measuring the solidity and bearing capacity of road constructions 707 2018-08-07T14:00:21.481992+03:00 3 74 {} 0 1400 1 1                                                                  
80 [81, 82, 83, 84] Torit ja kauppahallit Torg och saluhallar Market squares and halls   2018-08-07T14:00:21.488118+03:00 2 1 {} 0 1400 19 19                                                                  
81 [] Kauppahallit Saluhallar Market halls 259 2018-08-07T14:00:21.499406+03:00 3 80 {} 0 1400 3 3                                                                  
82 [] Kirpputorit Lopptorg Flea markets 315 2018-08-07T14:00:21.505503+03:00 3 80 {} 0 1400 3 3                                                                  
83 [] Markkinat Marknader Markets 427 2018-08-07T14:00:21.511515+03:00 3 80 {} 0 1400 2 2                                                                  
84 [] Torit Torg Market squares 714 2018-08-07T14:00:21.493235+03:00 3 80 {} 0 1400 15 15                                                                  
88 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:21.964747+03:00 2 85 {} 0 1400 1 2                             1                                    
91 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:21.983685+03:00 2 85 {} 0 1400 2 2                                                                  
93 [] Vesilaskut ja asiakaspalvelu Vattenfakturering och kundtjänst Billing for water and customer services 67+781 2018-10-24T20:30:07.186738+03:00 2 85 {} 0 1400 26 26                                                                  
94 [] Yleisövessat Allmänna toaletter Public toilets 819 2018-10-25T08:00:06.064613+03:00 2 1 {} 0 1400 39 39                                                                  
97 [98, 99] Ympäristön hoito Miljövård Maintenance of the environment 825 2018-08-07T14:00:21.535829+03:00 2 1 {} 0 1400 2 3                                                   1              
98 [] Metsät Skogar Forests 438 2020-12-02T12:30:08.292275+02:00 3 97 {} 0 1400 1 1                                                                  
99 [] Puutarhapalvelut Trädgårdstjänster Gardening services 533 2018-08-07T14:00:21.548578+03:00 3 97 {} 0 1400 1 2                                                   1              
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 {} 0 1400   1                     1                                            
102 [] Ympäristöohjelmat Miljöprogram Environmental programmes 829 2018-08-07T14:00:21.567791+03:00 2 1 {} 0 1400 1 2                                                   1              
109 [] Sisätilojen tuholaiset Inomhus skadedjur Interior pests 626 2018-08-07T14:00:21.605181+03:00 3 103 {} 0 1400 1 1                                                                  
118 [] Pohjavesitiedot Grundvatteninformation Groundwater information 517 2018-08-07T14:00:21.654694+03:00 3 116 {} 0 1400 2 3                                                   1              
119 [] Sisäympäristö Inomhusmiljö Indoor environment 627 2018-08-07T14:00:21.660811+03:00 3 116 {} 0 1400 1 1                                                                  
121 [] Ympäristönsuojelumääräykset Miljöskyddsbestämmelser Environmental protection regulations 828 2018-08-07T14:00:21.673508+03:00 3 116 {} 0 1400 2 4                                 1                 1              
224 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:22.012371+03:00 3 222 {} 0 1400 2 4                                                   1     1        
230 [] Viestintä ja vuorovaikutus Kommunikation och påverkan Communications and interaction 785 2018-08-07T14:00:22.052241+03:00 3 222 {} 0 1400 2 2                                                                  
233 [234, 235, 237] Hallinto Förvaltning Administration   2018-08-07T14:00:22.072503+03:00 3 231 {} 0 1400 3 6                                                   3              
234 [] Hallintopalvelut Förvaltningstjänster Administrative services 178 2020-12-02T12:30:08.656880+02:00 4 233 {} 0 1400 1 1                                                                  
235 [] Hankepalvelut Projekttjänster Project services 185 2018-08-07T14:00:22.084046+03:00 4 233 {} 0 1400   3                                                   3              
237 [] Maastomittauspalvelut Terrängmätning Field surveying services 424 2018-08-07T14:00:22.090579+03:00 4 233 {} 0 1400 2 2                                                                  
238 [] Hissiprojekti Anskaffning av hissar (gamla höghus) Lift procurement (old residential buildings) 195 2018-08-07T14:00:22.097017+03:00 3 231 {} 0 1400 1 1                                                                  
244 [] Lainhuuto Lagfart Registration of title to property 367 2018-08-07T14:00:22.136957+03:00 3 231 {} 0 1400 1 1                                                                  
251 [] Maa-alueiden vuokraus ja myynti Uthyrning och försäljning av markområden Selling or renting land areas 419 2018-08-07T14:00:22.176075+03:00 4 245 {} 0 1400   17                                                   17              
254 [] Siivouspalvelut Städningsservice Cleaning services 621 2018-08-07T14:00:22.196172+03:00 3 231 {} 0 1400 1 1                                                                  
256 [] Kauppahallimyyntipaikkojen vuokraus Uthyrning av försäljningsplatser i saluhallar Market hall sales location leasing 258 2018-08-07T14:00:22.208042+03:00 4 255 {} 0 1400 1 2                                                   1              
257 [] Torimyyntipaikkojen vuokraus Uthyrning av torgförsäljningsplatser Market square vending stall rental 713 2018-08-07T14:00:22.214641+03:00 4 255 {} 0 1400 1 2                                                   1              
267 [] Pakastamotilojen vuokraus Uthyrning av fryslokaler Cold storage space rental 494 2018-08-07T14:00:22.293996+03:00 5 265 {} 0 1400 1 1                                                                  
268 [] Teurastamotilojen vuokraus Uthyrning av slakterilokaler Slaughterhouse rental 706 2018-08-07T14:00:22.300791+03:00 5 265 {} 0 1400 1 1                                                                  
269 [] Vihertukkutilojen vuokraus Uthyrning av lokaler för grönsaksgrossister Green wholesale trade space rental 788 2018-08-07T14:00:22.308088+03:00 5 265 {} 0 1400 1 1                                                                  
272 [273, 274, 275] Energia Energi Energy   2018-08-07T14:00:22.327547+03:00 3 270 {} 0 1400 6 7                                                   1              
273 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:22.333741+03:00 4 272 {} 0 1400 1 2                                                   1              
274 [] Energianeuvonta Energirådgivning Energy counselling 146 2018-08-07T14:00:22.341217+03:00 4 272 {} 0 1400 1 1                                                                  
275 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:22.348354+03:00 4 272 {} 0 1400 4 4                                                                  
290 [] Kilpipalvelut Skylttjänster Sign services 481 2018-08-07T14:00:22.444787+03:00 4 287 {} 0 1400 1 1                                                                  
291 [] Materiaalipalvelut Materialservice Material services 564 2018-08-07T14:00:22.451320+03:00 4 287 {} 0 1400 3 3                                                                  
292 [] Pohja- ja kalliorakennussuunnittelu Planering av grund- och bergsbyggnad Foundation and rock engineering 516 2018-08-07T14:00:22.458169+03:00 4 287 {} 0 1400 1 2                                                   1              
296 [] Mullan myynti ja toimitus Försäljning och leverans av mylla Selling and delivering soil 453 2018-08-07T14:00:22.477143+03:00 4 293 {} 0 1400 1 2                             1                                    
299 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:22.497732+03:00 4 293 {} 0 1400 2 2                                                                  
301 [] Vesilaskut ja asiakaspalvelu Vattenfakturering och kundtjänst Billing for water and customer services 67+781 2018-10-25T08:00:06.456994+03:00 4 293 {} 0 1400 26 26                                                                  
302 [303] Yhdyskuntarakentaminen Samhällsbyggnad Civil engineering   2018-08-07T14:00:22.510499+03:00 3 270 {} 0 1400 1 1                                                                  
303 [304] Aluerakentaminen Områdesbyggandet Regional construction   2018-08-07T14:00:22.515802+03:00 4 302 {} 0 1400 1 1                                                                  
304 [] Tiedotus Information Information distribution 50 2018-08-07T14:00:22.521378+03:00 5 303 {} 0 1400 1 1                                                                  
305 [] Viestintä Kommunikation Communications 784 2018-08-07T14:00:22.528397+03:00 2 221 {} 0 1400 1 1                                                                  
2191 [] Hitas-asunnot Hitas-bostäder Hitas owner-occupied housing 877 2019-03-05T14:30:06.194077+02:00 2 2 {} 0 1400 399 399                                                                  
2236 [] Puistoshakkilaudat Parkschackbräden Park chess boards 912 2020-09-01T15:30:06.145353+03:00 3 60 {} 0 1400 24 24                                                                  
7 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:21.261214+03:00 2 2 {} 0 1400 1 3                                           1       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 {} 0 1400 2 3                                           1                      
11 [] Opiskelija-asunnot Studentbostäder Student housing 484 2018-08-07T14:00:21.287386+03:00 3 8 {} 0 1400   1                                           1                      
33 [] Jätteenkäsittelykeskus Avfallshanteringscentral Waste treatment centre 234 2018-08-07T14:00:21.773147+03:00 2 31 {} 0 1400   1                                           1                      
36 [] Bio- ja puutarhajäte Trädgårdsavfall Garden waste 127 2018-08-07T14:00:21.797808+03:00 3 34 {} 0 1400 2 4                                           1       1              
44 [] Pahvinkeräys Insamling av wellpapp Corrugated cardboard recycling 491 2018-08-07T14:00:21.860147+03:00 3 34 {} 0 1400 2 7                                           1       2     2        
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} 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 {} 0 1400 1 2                                           1                      
57 [] Luonnonsuojelu Naturskydd Environmental protection 410 2018-08-07T14:00:21.330807+03:00 2 1 {} 0 1400 2 4                                           1       1              
76 [] Katujen ja viheralueiden käyttöluvat ja vuokraus Tillstånd att använda gator och grönområden och uthyrning Permits for using streets and parks and renting 251 2018-08-07T14:00:21.463483+03:00 3 74 {} 0 1400 1 3                                           1       1              
78 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:21.475789+03:00 3 74 {} 0 1400 1 6                                           1       3     1        
85 [87, 88, 91, 93] Vesihuolto Vattenförsörjning Water services   2018-08-07T14:00:21.953530+03:00 1 1400 {} 0 1400 30 32                             1             1                      
87 [] Jäteveden puhdistamo Avloppsreningsverk Sewage treatment plant 233 2018-08-07T14:00:21.958557+03:00 2 85 {} 0 1400 1 2                                           1                      
103 [104, 105, 106, 107, 109, 110, 111, 113, 114] Ympäristöterveydenhuolto Miljö- och hälsoskydd Environmental health   2018-08-07T14:00:21.574018+03:00 2 1 {} 0 1400 4 9                                 2         1       2              
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} 0 1400 2 5                                 1         1       1              
105 [] Elintarvikevalvonta Livsmedelsbevakning Food control 137 2018-08-07T14:00:21.585963+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
107 [] Eläinsuojelu Djurskydd Animal protection 141 2018-08-07T14:00:21.598706+03:00 3 103 {} 0 1400 1 4                                           1       2              
110 [] Talousveden valvonta Övervakning av hushållsvatten Domestic water supervision 683 2018-08-07T14:00:21.612084+03:00 3 103 {} 0 1400 1 3                                           1       1              
111 [] Terveystarkastaja Hälsoinspektör Health inspector 705 2018-08-07T14:00:21.618445+03:00 3 103 {} 0 1400   2                                           1       1              
113 [] Tupakkalain valvonta Tillsyn av tobakslagen Tobacco Act supervision 719 2018-08-07T14:00:21.625158+03:00 3 103 {} 0 1400   2                                           1       1              
114 [] Uimavesien valvonta Övervakning av badvatten Swimming water supervision 732 2018-08-07T14:00:21.631376+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
115 [] Ympäristötutkimus ja tilastointi Miljöforskning och statistikförning Environmental research and compilation of statistics 830 2018-08-07T14:00:21.637464+03:00 2 1 {} 0 1400 1 3                                           1       1              
117 [] Maaperä ja vesi Jordmånen och vatten Ground and water 423 2018-08-07T14:00:21.648552+03:00 3 116 {} 0 1400 1 3                                           1       1              
120 [] Ympäristöhaitat ja -luvat Miljöolägenheter och -tillstånd Environmental detriments and permits 823 2018-08-07T14:00:21.667227+03:00 3 116 {} 0 1400 2 5                                 1         1       1              
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} 0 1400   3                                           1       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
);