service_node

383 rows where level = 3 sorted by unit_count_municipality_espoo

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää, last_modified_time (date)

level ✖

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ää
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                                                                  
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                                                                  
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              
37 [] Energiajäte Energiavfall Energy waste 145 2018-08-07T14:00:21.805057+03:00 3 34 {} [145] 0 1400   1                                                   1              
61 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:21.361137+03:00 3 60 {} [238] 0 1400 49 49                                                                  
72 [] Viheralueiden hoito Skötsel av grönområden Green area maintenance 787 2020-12-02T11:30:08.056281+02:00 3 60 {} [787] 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 {} [249] 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 {} [707] 0 1400 1 1                                                                  
81 [] Kauppahallit Saluhallar Market halls 259 2018-08-07T14:00:21.499406+03:00 3 80 {} [259] 0 1400 3 3                                                                  
82 [] Kirpputorit Lopptorg Flea markets 315 2018-08-07T14:00:21.505503+03:00 3 80 {} [315] 0 1400 3 3                                                                  
83 [] Markkinat Marknader Markets 427 2018-08-07T14:00:21.511515+03:00 3 80 {} [427] 0 1400 2 2                                                                  
84 [] Torit Torg Market squares 714 2018-08-07T14:00:21.493235+03:00 3 80 {} [714] 0 1400 15 15                                                                  
98 [] Metsät Skogar Forests 438 2020-12-02T12:30:08.292275+02:00 3 97 {} [438] 0 1400 1 1                                                                  
99 [] Puutarhapalvelut Trädgårdstjänster Gardening services 533 2018-08-07T14:00:21.548578+03:00 3 97 {} [533] 0 1400 1 2                                                   1              
109 [] Sisätilojen tuholaiset Inomhus skadedjur Interior pests 626 2018-08-07T14:00:21.605181+03:00 3 103 {} [626] 0 1400 1 1                                                                  
118 [] Pohjavesitiedot Grundvatteninformation Groundwater information 517 2018-08-07T14:00:21.654694+03:00 3 116 {} [517] 0 1400 2 3                                                   1              
119 [] Sisäympäristö Inomhusmiljö Indoor environment 627 2018-08-07T14:00:21.660811+03:00 3 116 {} [627] 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 {} [828] 0 1400 2 4                                 1                 1              
139 [] Maa-alueiden vuokraus ja myynti Uthyrning och försäljning av markområden Selling or renting land areas 419 2018-08-07T14:00:30.113920+03:00 3 134 {} [419] 0 1401   17                                                   17              
142 [] Elinkeinomarkkinointi Näringslivmarknadsföring Business marketing 133 2018-08-07T14:00:30.132324+03:00 3 141 {} [133] 0 1401 2 2                                                                  
144 [] Matkailumarkkinointi Marknadsföring av turism Tourism marketing 428 2018-08-07T14:00:30.145003+03:00 3 141 {} [428] 0 1401 2 4                                                   2              
145 [] Tapahtumamarkkinointi Evenemangsmarknadsföring Event marketing 688 2018-08-07T14:00:30.151217+03:00 3 141 {} [688] 0 1401   2                                                   2              
147 [] Kauppahallimyyntipaikkojen vuokraus Uthyrning av försäljningsplatser i saluhallar Market hall sales location leasing 258 2018-08-07T14:00:30.162809+03:00 3 146 {} [258] 0 1401 1 2                                                   1              
148 [] Torimyyntipaikkojen vuokraus Uthyrning av torgförsäljningsplatser Market square vending stall rental 713 2018-08-07T14:00:30.169994+03:00 3 146 {} [713] 0 1401 1 2                                                   1              
176 [] Postipalvelut Posttjänster Postal services 224 2018-08-07T14:00:30.419580+03:00 3 172 {} [224] 0 1401 1 1                                                                  
182 [] Henkilöstöpolitiikka ja -strategia Personalpolitik och -strategi Personnel policy and strategy 220 2018-08-07T14:00:30.473352+03:00 3 180 {} [220] 0 1401 3 3                                                                  
185 [] Rekrytointi Rekrytering Recruitment 225 2018-08-07T14:00:30.493982+03:00 3 180 {} [225] 0 1401 2 2                                                                  
192 [] Kaupunginhallituksen ja kaupunginvaltuuston valmistelutehtävät stadsstyrelsens och stadsförvaltningens beredningsuppgifter preparatory assignments for City Government and City Council 274 2018-08-07T14:00:30.528561+03:00 3 191 {} [274] 0 1401 1 2                                                         1        
195 [] Lautakunnat ja johtokunnat Nämnder och direktioner Committees and boards 386 2018-08-07T14:00:30.546848+03:00 3 191 {} [386] 0 1401 1 2                                                   1              
196 [] Valtuustoryhmät, kansalaislähetystöt Stadsfullmäktigegrupper, medborgardelegationer Council groups, public delegations 743 2018-08-07T14:00:30.552905+03:00 3 191 {} [743] 0 1401 1 2                                                   1              
198 [199, 200, 201, 202, 203, 204, 205, 206, 207, 208] Taloushallinto Ekonomiförvaltning Financial administration 487 2018-08-07T14:00:30.570887+03:00 3 197 {} [487] 0 1401 8 8                                                                  
209 [210, 211, 213] Varainhallinta Finansförvaltning Assets management   2018-08-07T14:00:30.654818+03:00 3 197 {} [] 0 1401 3 3                                                                  
220 [] Avustusten sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för bidragsärenden Electronic services and forms related to benefits 87 2018-08-07T14:00:30.732707+03:00 3 219 {} [87] 0 1401   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 {} [201] 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 {} [785] 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              
238 [] Hissiprojekti Anskaffning av hissar (gamla höghus) Lift procurement (old residential buildings) 195 2018-08-07T14:00:22.097017+03:00 3 231 {} [195] 0 1400 1 1                                                                  
244 [] Lainhuuto Lagfart Registration of title to property 367 2018-08-07T14:00:22.136957+03:00 3 231 {} [367] 0 1400 1 1                                                                  
254 [] Siivouspalvelut Städningsservice Cleaning services 621 2018-08-07T14:00:22.196172+03:00 3 231 {} [621] 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              
302 [303] Yhdyskuntarakentaminen Samhällsbyggnad Civil engineering   2018-08-07T14:00:22.510499+03:00 3 270 {} [] 0 1400 1 1                                                                  
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} [60] 0 1402   1                                                         1        
312 [] Rakennusvalvonnan arkisto Byggnadstillsynsverkets arkiv Building Control archive 561 2018-08-07T14:00:24.689378+03:00 3 307 {} [561] 0 1402 1 1                                                                  
313 [] Katu-, puisto- ja rakennuspiirustusten arkisto Arkiv för gatu-, park- och byggnadsritningar Public works department archive 250 2018-08-07T14:00:24.696359+03:00 3 307 {} [250] 0 1402 1 1                                                                  
315 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:24.709417+03:00 3 314 {} [201] 0 1402 2 4                                                   1     1        
323 [] Paikkatietoneuvonta ja -aineistot Rådgivning och material inom geografisk information Location information guidance and archives 492 2018-08-07T14:00:24.814824+03:00 3 320 {} [492] 0 1402 1 3                                                   2              
327 [] Laitoskirjastot Anstaltsbibliotek Institutional libraries 368 2018-08-07T14:00:24.845380+03:00 3 324 {} [368] 0 1402 8 8                                                                  
330 [331, 332] Langaton internet, wlan Trådlöst internet, wlan Wireless internet, wlan   2018-10-25T08:00:07.331877+03:00 3 329 {} [] 0 1402 233 240                                                   7              
348 [] Laitoskirjastot Anstaltsbibliotek Institutional libraries 368 2018-08-07T14:00:22.571974+03:00 3 345 {} [368] 0 1403 8 8                                                                  
358 [] Ooppera ja baletti Operan och balett Opera and ballet 479 2018-08-07T14:00:22.636644+03:00 3 352 {} [479] 0 1403 1 1                                                                  
381 [] Demostudio Demostudio Demo studio 130 2018-08-07T14:00:22.931253+03:00 3 368 {} [130] 0 1403 1 2                                                   1              
391 [] Futsal Futsal Futsal 170 2018-08-07T14:00:22.944059+03:00 3 368 {} [170] 0 1403   1                                                   1              
396 [] Jalkapallo Fotboll Football 203 2018-08-07T14:00:22.956950+03:00 3 368 {} [203] 0 1403   2                                                   2              
399 [] Järjestötoiminta Organisationsverksamhet Organisational activities 231 2018-08-07T14:00:22.963009+03:00 3 368 {} [231] 0 1403 6 8                                                   2              
409 [] Kokkikerho Kockklubb Cook club 325 2018-08-07T14:00:22.999540+03:00 3 368 {} [325] 0 1403   4                                                   4              
410 [] Konsolipelit Konsolspel Console games 330 2018-08-07T14:00:23.006235+03:00 3 368 {} [330] 0 1403 1 2                                                   1              
437 [] Monistuspalvelu Kopieringstjänst Copying service 443 2018-08-07T14:00:23.067329+03:00 3 368 {} [443] 0 1403 2 2                                                                  
438 [] Moottorihalli Motorhall Motorhall 445 2018-08-07T14:00:23.074919+03:00 3 368 {} [445] 0 1403 2 3                                                   1              
453 [] Pyöräkoulu Cykelskola Bicycle school 541 2018-08-07T14:00:23.119521+03:00 3 368 {} [541] 0 1403 1 1                                                                  
467 [] Skeittaus Skateboardåkning Skateboarding 629 2018-08-07T14:00:23.144513+03:00 3 368 {} [629] 0 1403 1 2                                                   1              
468 [] Soitonopetus Instrumentundervisning Teaching music 632 2018-08-07T14:00:23.150860+03:00 3 368 {} [632] 0 1403 1 2                                                   1              
470 [] Sähly Innebandy Floorball 670 2018-08-07T14:00:23.157134+03:00 3 368 {} [670] 0 1403   1                                                   1              
480 [] Tyttökerho / tyttöryhmät Flickklubb / flickgrupper Girls' club / Girl groups 722 2018-08-07T14:00:23.175639+03:00 3 368 {} [722] 0 1403   2                                                   2              
485 [] Viikonlopputoiminta Veckoslutsverksamhet Weekend activities 789 2018-08-07T14:00:23.188643+03:00 3 368 {} [789] 0 1403 2 2                                                                  
492 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:22.690959+03:00 3 491 {} [238] 0 1403 49 49                                                                  
516 [] Julkisen liikenteen varikot Kollektivtrafikens depåer Public transport depots 216 2018-08-07T14:00:25.022696+03:00 3 513 {} [216] 0 1402 5 9                                                   4              
518 [] Matkalippujen tarkastus Biljettkontroll Ticket inspection 431 2018-08-07T14:00:25.036866+03:00 3 513 {} [431] 0 1402 1 1                                                                  
528 [] Asukas- ja yrityspysäköintitunnukset Boende- och företagsparkering Residential and corporate parking 73+834 2018-10-24T23:30:06.727092+03:00 3 526 {} [834, 73] 0 1402 1 1                                                                  
530 [] Pysäköintilippuautomaatit Parkeringsbiljettautomater Parking ticket machines 536 2018-08-07T14:00:25.120116+03:00 3 526 {} [536] 0 1402 557 557                                                                  
535 [] Katu-, maa- ja viherrakentamispalvelut Tjänster inom gatu-, mark- och grönbyggnad Construction services for streets, land and parks 249 2018-08-07T14:00:25.151160+03:00 3 534 {} [249] 0 1402 1 5                                                   4              
539 [] 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:25.177483+03:00 3 534 {} [707] 0 1402 1 1                                                                  
564 [565] Hyppyrimäet Hoppbackar Ski jumping hills   2018-08-07T14:00:23.318569+03:00 3 558 {} [] 0 1403 1 1                                                                  
567 [568, 569] Katetut talviurheilupaikat Vintersportplatser under tak Covered winter sports facilities   2018-08-07T14:00:23.339639+03:00 3 558 {} [] 0 1403 2 2                                                                  
597 [600] Suunnistusalueet Orienteringsområden Orienteering areas   2018-08-07T14:00:23.531981+03:00 3 558 {} [] 0 1403   1                                                   1              
675 [676] Urheiluilmailualueet Områden för flygsport Sport aviation areas   2018-08-07T14:00:24.102541+03:00 3 666 {} [] 0 1403 1 1                                                                  
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                                            
740 [] Kauppahallit Saluhallar Market halls 259 2018-08-07T14:00:24.520703+03:00 3 718 {} [259] 0 1403 3 3                                                                  
741 [] Kioskit Kiosker Kiosks 309 2018-08-07T14:00:24.527473+03:00 3 718 {} [309] 0 1403 2 2                                                                  
743 [] Leirintäalueet Campingområden Camping sites 390 2018-08-07T14:00:24.541305+03:00 3 718 {} [390] 0 1403 1 1                                                                  
748 [] Muut matkailupalvelut Övriga turisttjänster Other tourism services 459 2018-08-07T14:00:24.575540+03:00 3 718 {} [459] 0 1403 5 5                                                                  
753 [] Torit Torg Market squares 714 2018-08-07T14:00:24.610283+03:00 3 718 {} [714] 0 1403 15 15                                                                  
781 [] Tuomioistuimet Domstolarna Finnish courts 717 2018-08-07T14:00:30.954711+03:00 3 769 {} [717] 0 1401 3 3                                                                  
889 [895, 890] Saamenkielinen päivähoito Samiskspråkig dagvård Day care in Sami 607 2018-08-07T14:00:28.389203+03:00 3 869 {} [607] 0 1405 1 1                                                                  
897 [903, 898] Arabiankielinen päivähoito Arabiskspråkig dagvård Day care in Arabic 58 2018-08-07T14:00:28.436562+03:00 3 869 {} [58] 0 1405 2 2                                                                  
913 [919, 914] Espanjankielinen päivähoito Spanskspråkig dagvård Day care in Spanish 164 2018-08-07T14:00:28.527678+03:00 3 869 {} [164] 0 1405 2 2                                                                  
921 [922] Hepreankielinen päivähoito Hebreiskspråkig dagvård Day care in Hebrew 188 2018-08-07T14:00:28.572081+03:00 3 869 {} [188] 0 1405 1 1                                                                  
929 [935, 930] Ranskankielinen päivähoito Franskspråkig dagvård Day care in French 569 2018-08-07T14:00:28.623079+03:00 3 869 {} [569] 0 1405 6 6                                                                  
937 [938] Saksankielinen päivähoito Tyskspråkig dagvård Day care in German 614 2018-08-07T14:00:28.671882+03:00 3 869 {} [614] 0 1405 2 2                                                                  
945 [946] Venäjänkielinen päivähoito Ryskspråkig dagvård Day care in Russian 773 2018-08-07T14:00:28.731246+03:00 3 869 {} [773] 0 1405 5 7                                                   2              
962 [] Perhepäivähoidon ohjausalue Familjedagvårdens styrningsområde Family day care guidance area 506 2018-08-07T14:00:28.870469+03:00 3 961 {} [506] 0 1405 14 16                                                   2              
977 [] Kehitysvammaisten iltapäivätoiminnan ryhmät Eftermiddagsverksamhet för utvecklingsstörda Afternoon activities for the intellectually disabled 80 2018-08-07T14:00:28.982154+03:00 3 975 {} [80] 1 1405 33 33                                                                  
982 [] Puistotäti Parktant Park aunt 528 2019-03-05T14:30:09.685579+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} [528] 0 1405 2 2                                                                  
1095 [] Koulun järjestämä esiopetus Förskoleundervisning som ordnas av skolan Pre-primary education organised by school 601*159+862*159 2018-10-25T08:00:07.525080+03:00 3 1093 {} [862, 601, 159] 1 1087 5 9                                                   4              
1119 [] Lisäopetus (10. luokka) Påbyggnadsundervisning (10:de klass) Supplementary education (10th grade) 657 2018-10-25T08:00:07.670545+03:00 3 1098 {} [657] 1 1087 5 7                                                   2              
1169 [1170, 1171, 1172] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.110528+03:00 3 1098 {} [] 0 1087 40 44                                                   4              
1193 [1194, 1208, 1214, 1215, 1218, 1232, 1233, 1236, 1237, 1238, 1239, 1240] Kieliohjelma Språkprogram Language programme   2018-08-07T14:00:26.296242+03:00 3 1187 {} [] 0 1087 21 26                                                   5              
1242 [1244, 1245] Soveltuvuuskoepainotus Intensifierad undervisning, lämplighetstest Emphasis on aptitude tests   2018-08-07T14:00:26.661731+03:00 3 1187 {} [] 0 1087 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
);