service_node

1,140 rows sorted by unit_count_total

✎ View and edit SQL

This data as json, CSV (advanced)

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ää
217 [] Sisäinen tarkastus Intern revision Internal auditing 176 2018-08-07T14:00:30.706266+03:00 3 216 {} [176] 0 1401 1 2                                           1                      
228 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:05.577987+03:00 4 226 {} [397, 396] 0 1400   2                                           1       1              
229 [] Nimistönsuunnittelu Namnplanering Nomenclature planning 466 2018-08-07T14:00:22.045496+03:00 3 222 {} [466] 0 1400   2                                           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                                                                  
237 [] Maastomittauspalvelut Terrängmätning Field surveying services 424 2018-08-07T14:00:22.090579+03:00 4 233 {} [424] 0 1400 2 2                                                                  
240 [] Kiinteistöhuolto ja isännöinti Fastighetsunderhåll och -förvaltning Janitorial and landlord services 303 2018-08-07T14:00:22.109816+03:00 3 231 {} [303] 0 1400 1 2                                           1                      
243 [] Korjausavustukset ja -lainat Reparationsunderstöd och -lån Renovation grants and loans 332 2018-08-07T14:00:22.130199+03:00 3 231 {} [332] 0 1400   2                                           1       1              
250 [] Liike- ja toimistotonttien vuokraus ja myynti Arrendering och försäljning av affärs- och kontorstomter Leasing and selling of commercial and office plots 394 2018-08-07T14:00:22.168975+03:00 4 245 {} [394] 0 1400   2                                           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 {} [258] 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 {} [713] 0 1400 1 2                                                   1              
264 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:22.259199+03:00 5 258 {} [804] 0 1400 1 2                                           1                      
273 [] Asiakaspalvelu Kundtjänst Customer services 62 2018-08-07T14:00:22.333741+03:00 4 272 {} [62] 0 1400 1 2                                                   1              
278 [] Korjausrakentaminen Renovering Renovation construction 333 2018-08-07T14:00:22.369873+03:00 3 270 {} [333] 0 1400 1 2                                           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                      
292 [] Pohja- ja kalliorakennussuunnittelu Planering av grund- och bergsbyggnad Foundation and rock engineering 516 2018-08-07T14:00:22.458169+03:00 4 287 {} [516] 0 1400 1 2                                                   1              
295 [] Jäteveden puhdistamo Avloppsreningsverk Sewage treatment plant 233 2018-08-07T14:00:22.470442+03:00 4 293 {} [233] 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 {} [453] 0 1400 1 2                             1                                    
299 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:22.497732+03:00 4 293 {} [766] 0 1400 2 2                                                                  
342 [] Tilastot ja tietopalvelut Statistik och informationstjänst Statistics and information services 709 2018-10-25T08:00:07.381081+03:00 2 306 {} [709] 0 1402 2 2                                                                  
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              
381 [] Demostudio Demostudio Demo studio 130 2018-08-07T14:00:22.931253+03:00 3 368 {} [130] 0 1403 1 2                                                   1              
396 [] Jalkapallo Fotboll Football 203 2018-08-07T14:00:22.956950+03:00 3 368 {} [203] 0 1403   2                                                   2              
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                                                                  
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              
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              
481 [] Valokuvaus Fotografering Photography 741 2018-08-07T14:00:23.182310+03:00 3 368 {} [741] 0 1403 1 2                                           1                      
485 [] Viikonlopputoiminta Veckoslutsverksamhet Weekend activities 789 2018-08-07T14:00:23.188643+03:00 3 368 {} [789] 0 1403 2 2                                                                  
498 [] Opaskoira-aitaukset Inhägnat områden för ledarhundar Fenced areas for guide dogs 480 2018-08-07T14:00:22.741237+03:00 4 493 {} [480] 0 1403 2 2                                                                  
511 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:22.844464+03:00 3 505 {} [804] 0 1403 1 2                                           1                      
523 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:06.706293+03:00 3 521 {} [397, 396] 0 1402   2                                           1       1              
543 [] Hallintopalvelut Förvaltningstjänster Administrative services 183 2018-08-07T14:00:25.201364+03:00 4 542 {} [183] 0 1402 2 2                                                                  
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                                                                  
618 [] Petanque - halli Petanquehall Petanque hall 512 2018-08-07T14:00:23.673008+03:00 4 614 {} [512] 0 1403 1 2                                                   1              
626 [] Parkour- Sali Parkoursal Parkour hall 500 2018-08-07T14:00:23.737371+03:00 4 624 {} [500] 0 1403 1 2                                           1                      
651 [] Pyöräilyrata Cykelåkningsbana Velodrome 539 2018-08-07T14:00:23.920549+03:00 4 646 {} [539] 0 1403 1 2                                           1                      
682 [] Soutustadion Roddstadion Rowing stadium 643 2018-08-07T14:00:24.150686+03:00 4 677 {} [643] 0 1403 2 2                                                                  
683 [] Vesihiihtoalue Område för vattenskidåkning Water ski area 777 2018-08-07T14:00:24.157225+03:00 4 677 {} [777] 0 1403 1 2                                           1                      
691 [] Kylpylä Badinrättning Spa 361 2018-08-07T14:00:24.210042+03:00 4 690 {} [361] 0 1403   2                                           1       1              
700 [] Rantautumispaikka Ilandstigningsplats Boat dock 571 2018-08-07T14:00:24.275183+03:00 4 695 {} [571] 0 1403 2 2                                                                  
703 [] Tupa Stuga Hut 721 2018-08-07T14:00:24.296823+03:00 4 695 {} [721] 0 1403   2                                           1           1          
727 [] Kauppa Butik Store 142*256 2018-08-07T14:00:24.462954+03:00 5 725 {} [256, 142] 0 1403 2 2                                                                  
728 [] Kioski Kiosk Kiosk 142*309 2018-08-07T14:00:24.470558+03:00 5 725 {} [309, 142] 0 1403 2 2                                                                  
741 [] Kioskit Kiosker Kiosks 309 2018-08-07T14:00:24.527473+03:00 3 718 {} [309] 0 1403 2 2                                                                  
758 [] 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.769165+03:00 4 757 {} [274] 0 1401 1 2                                                         1        
761 [] Lautakunnat ja johtokunnat Nämnder och direktioner Committees and boards 386 2018-08-07T14:00:30.800171+03:00 4 757 {} [386] 0 1401 1 2                                                   1              
762 [] Valtuustoryhmät, kansalaislähetystöt Stadsfullmäktigegrupper, medborgardelegationer Council groups, public delegations 743 2018-08-07T14:00:30.809629+03:00 4 757 {} [743] 0 1401 1 2                                                   1              
770 [771, 773, 774] Avioliitto ja rekisteröity parisuhde Äktenskap och registrering av partnerskap Marriage and registered partnership   2018-08-07T14:00:30.869982+03:00 3 769 {} [] 0 1401 1 2                                           1                      
771 [] Avioehto Äktenskapsförord Prenuptial agreement 82 2018-08-07T14:00:30.878414+03:00 4 770 {} [82] 0 1401 1 2                                           1                      
773 [] Parisuhteen rekisteröinti Registrering av partnerskap Registration of partnerships 498 2018-08-07T14:00:30.891417+03:00 4 770 {} [498] 0 1401 1 2                                           1                      
774 [] Siviilivihkiminen Civil vigsel Civil marriage 628 2018-08-07T14:00:30.898033+03:00 4 770 {} [628] 0 1401 1 2                                           1                      
776 [] Kotikunta- ja väestötiedot Uppgifter om hemkommun och befolkningsinformation Municipality of residence and population information 335 2018-08-07T14:00:30.913192+03:00 3 769 {} [335] 0 1401 1 2                                           1                      
777 [] Kuluttajansuoja ja neuvonta Konsumentskydd och rådgivning Consumer protection and advice 347 2018-08-07T14:00:30.921943+03:00 3 769 {} [347] 0 1401 1 2                                           1                      
778 [] Nimiasiat Namnärenden Name matters 465 2018-08-07T14:00:30.930146+03:00 3 769 {} [465] 0 1401 1 2                                           1                      
779 [] Oikeusaputoimistot Rättshjälpsbyråerna Legal aid offices 476 2018-08-07T14:00:30.939138+03:00 3 769 {} [476] 0 1401   2                                           1       1              
780 [] Perinnönjako Arvskifte Distribution of estate 508 2018-08-07T14:00:30.947784+03:00 3 769 {} [508] 0 1401 1 2                                           1                      
838 [] Selviämishoitoasema Tillnyktringsstation Detoxification centre 618 2018-08-07T14:00:28.067660+03:00 2 830 {} [618] 0 783 1 2                                           1                      
841 [] Etuuskäsittely Förmånsbehandling Benefit processing 167 2018-08-07T14:00:28.085946+03:00 2 839 {} [167] 0 783 1 2                                           1                      
856 [] Sovittelutoiminta Medlingsverksamhet Mitigation services 644 2018-08-07T14:00:28.189606+03:00 2 845 {} [644] 0 783 1 2                                                   1              
860 [] Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) Stödtjänster inom social- och hälsovården (stöd för boende) Social and health care services' security services (housing support) 636 2018-08-07T14:00:28.215634+03:00 1 783 {} [636] 0 783 1 2                                                   1              
877 [] kielikylpy englanti språkbad, engelska language immersion, English 663*292 2018-08-07T14:00:28.303776+03:00 4 870 {} [663, 292] 0 1405   2                                           2                      
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                                                                  
898 [] päivähoito dagvård day care 58 2018-08-07T14:00:28.442943+03:00 4 897 {} [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                                                                  
914 [] päivähoito dagvård day care 164 2018-08-07T14:00:28.533814+03:00 4 913 {} [164] 0 1405 2 2                                                                  
919 [] esiopetus förskoleundervisning pre-primary education 164*160 2018-08-07T14:00:28.559368+03:00 4 913 {} [164, 160] 1 1405 2 2                                                                  
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                                                                  
938 [] päivähoito dagvård day care 614 2018-08-07T14:00:28.681434+03:00 4 937 {} [614] 0 1405 2 2                                                                  
953 [959, 954] Vironkielinen päivähoito Estniskspråkig dagvård Day care in Estonian 795 2018-08-07T14:00:28.794858+03:00 3 869 {} [795] 0 1405 1 2                                           1                      
954 [] päivähoito dagvård day care 795 2018-08-07T14:00:28.802386+03:00 4 953 {} [795] 0 1405 1 2                                           1                      
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                                                                  
994 [] Työterveyshuolto Företagshälsovård Occupational health care 726 2018-08-07T14:00:29.175755+03:00 1 986 {} [726] 0 986 1 2                                           1                      
1011 [] Kaupungin psykiatrinen sairaala Stadens psykiatriska sjukhus City Psychiatric Hospital 263 2018-08-07T14:00:29.322493+03:00 2 1009 {} [263] 0 986 2 2                                                                  
1014 [] Päiväsairaala Dagsjukhus Day hospital 553 2018-08-07T14:00:29.349793+03:00 2 1009 {} [553] 0 986   2                                           1       1              
1016 [] Synnytyssairaalat Förlossningssjukhus Maternity hospitals 667 2018-08-07T14:00:29.368533+03:00 2 1009 {} [667] 0 986 1 2                                           1                      
1021 [] HUS:n erikoissairaanhoito HNS:s specialsjukvård HUS specialised health care 440 2018-08-07T14:00:29.421431+03:00 2 1019 {} [440] 0 986 2 2                                                                  
1025 [] Psykiatrinen perhehoito Psykiatrisk familjevård Psychiatric family care 523 2018-08-07T14:00:29.453053+03:00 2 1019 {} [523] 0 986 2 2                                                                  
1026 [] Psykiatrinen päiväsairaala Psykiatriskt dagsjukhus Psychiatric day hospital 524 2018-08-07T14:00:29.460729+03:00 2 1019 {} [524] 0 986 2 2                                                                  
1027 [] Psykoterapia Psykoterapi Psychotherapy 526 2018-08-07T14:00:29.469348+03:00 2 1019 {} [526] 0 986 2 2                                                                  
1044 [] Silmätaudit Ögonsjukdomar Eye diseases 622 2018-08-07T14:00:29.630771+03:00 1 986 {} [622] 0 986 1 2                                                   1              
1059 [] Selviämishoitoasema Tillnyktringsstation Detoxification centre 618 2018-08-07T14:00:29.743322+03:00 2 1051 {} [618] 0 986 1 2                                           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              
1063 [] Maanpuolustusyhdistykset Försvarsföreningar National defence associations 422 2018-08-07T14:00:29.780736+03:00 2 1062 {} [422] 0 1061 2 2                                                                  
1068 [] Sosiaali- ja terveyspalvelujen turvapalvelut (asumisen tuki) Stödtjänster inom social- och hälsovården (stöd för boende) Social and health care services' security services (housing support) 636 2018-08-07T14:00:29.828890+03:00 2 1066 {} [636] 0 1061 1 2                                                   1              
1069 [] Muut turvapalvelut (kiinteistöt ja vartiointi) Övrig säkerhetsservice (fastigheter och bevakning) Other security services (real estate and guarding) 460 2018-08-07T14:00:29.836971+03:00 2 1066 {} [460] 0 1061 1 2                                           1                      
1096 [] Esi- ja starttiopetus Förskoleundervisning, startklasser Pre-primary and start class education 595 2018-10-25T08:00:07.533093+03:00 3 1093 {} [595] 1 1087   2                                           2                      
1252 [] Seurakuntien ryhmät Församlingarnas grupper Groups organised by parishes 596*620 2018-08-07T14:00:26.734846+03:00 4 1249 {} [620, 596] 1 1087 2 2                                                                  
1288 [] B-japani B-japanska B-Japanese 148*91+161*91+300*91+383*91+566*91+611*91+658*91+770*91+792*91 2018-10-25T08:00:08.673017+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 91] 1 1087 1 2                                                   1              
1290 [] B-latina B-latin B-Latin 148*93+161*93+300*93+383*93+566*93+611*93+658*93+770*93+792*93 2018-10-25T08:00:08.690591+03:00 4 1271 {} [792, 770, 658, 611, 566, 383, 300, 161, 148, 93] 1 1087 1 2                                                   1              
1315 [] B-suomi B-finska B-Finnish 598*98 2018-08-07T14:00:27.199171+03:00 4 1303 {} [598, 98] 1 1087 2 2                                                                  
1317 [] B-englanti B-engelska B-English 598*88 2018-08-07T14:00:27.214095+03:00 4 1303 {} [598, 88] 1 1087 2 2                                                                  
1328 [] Painotettu lukio Gymnasium med betoning Specialised upper secondary school 598*493 2018-08-07T14:00:27.295727+03:00 3 1298 {} [598, 493] 1 1087 2 2                                                                  
1353 [1355, 1354] Oppisopimuskoulutus Läroavtalsutbildning Apprenticeship training   2018-08-07T14:00:27.464000+03:00 1 1087 {} [] 0 1087 1 2                                                   1              
1354 [] Suomenkielinen oppisopimuskoulutus Läroavtalsutbildning på finska Apprenticeship training in Finnish 659 2018-08-07T14:00:27.469481+03:00 2 1353 {} [659] 1 1087 1 2                                                   1              
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} [654] 0 1087 1 2                                                         1        
1357 [] Suomenkielinen ammattikorkeakoulukoulutus Yrkeshögskoleutbildning på finska Polytechnic education in Finnish 654 2018-08-07T14:00:27.490338+03:00 2 1356 {} [654] 0 1087 1 2                                                         1        
1375 [] Koulupsykologi Skolpsykolog School psychologist 343 2018-08-07T14:00:27.641064+03:00 2 1372 {} [343] 0 1087   2                                                   2              
1379 [] Perusopetuksen neuvonta Kundbetjäning och rådgivning (grundläggande utbildning) Customer service and information (basic education) 70 2018-08-07T14:00:27.673059+03:00 2 1378 {} [70] 0 1087 1 2                                           1                      
1380 [] Lukiokoulutuksen neuvonta Kundbetjäning och rådgivning (gymnasieutbildning) Customer service and information (general upper secondary education) 69 2018-08-07T14:00:27.679921+03:00 2 1378 {} [69] 0 1087 1 2                                           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
);