service_node

1,140 rows sorted by service_reference descending

✎ 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ää
511 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:22.844464+03:00 3 505 {} [804] 0 1403 1 2                                           1                      
154 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:30.213017+03:00 4 149 {} [803] 0 1401   17                                           16             1        
263 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.252638+03:00 5 258 {} [803] 0 1400   17                                           16             1        
510 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.836894+03:00 3 505 {} [803] 0 1403   17                                           16             1        
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                                                                  
150 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:30.186216+03:00 4 149 {} [799] 0 1401 3 8                                           2       1     2        
259 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:22.226278+03:00 5 258 {} [799] 0 1400 3 8                                           2       1     2        
506 [] Harrastustilat Hobbylokaler Hobby facilities 799 2018-08-07T14:00:22.804088+03:00 3 505 {} [799] 0 1403 3 8                                           2       1     2        
27 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:21.755624+03:00 2 24 {} [798] 0 1400 4 4                                                                  
275 [] Voimalaitokset Kraftverk Power plants 798 2018-08-07T14:00:22.348354+03:00 4 272 {} [798] 0 1400 4 4                                                                  
613 [] Voimailusali Styrketräningssal Weight training hall 797 2018-08-07T14:00:23.637831+03:00 4 608 {} [797] 0 1403 22 39                                           5       12              
959 [] esiopetus förskoleundervisning pre-primary education 795*160 2018-08-07T14:00:28.844971+03:00 4 953 {} [795, 160] 1 1405 1 1                                                                  
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                      
716 [] Virkistysmetsä Friluftsskog Recreational forest 791 2018-08-07T14:00:24.380867+03:00 4 706 {} [791] 0 1403   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              
271 [] Asuntotuotanto Bostadsproduktion Housing production 79 2018-08-07T14:00:22.320238+03:00 3 270 {} [79] 0 1400 1 3                                           1       1              
485 [] Viikonlopputoiminta Veckoslutsverksamhet Weekend activities 789 2018-08-07T14:00:23.188643+03:00 3 368 {} [789] 0 1403 2 2                                                                  
162 [] Vihertukkutilojen vuokraus Uthyrning av lokaler för grönsaksgrossister Green wholesale trade space rental 788 2018-08-07T14:00:30.280128+03:00 4 156 {} [788] 0 1401 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 {} [788] 0 1400 1 1                                                                  
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                                                                  
2235 [] Viheralueiden hoito Skötsel av grönområden Green area maintenance 787 2020-12-02T11:30:08.949266+02:00 3 491 {} [787] 0 1403 1 1                                                                  
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                      
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                      
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                                                                  
305 [] Viestintä Kommunikation Communications 784 2018-08-07T14:00:22.528397+03:00 2 221 {} [784] 0 1400 1 1                                                                  
545 [] Terminaalit Terminaler Terminals 782 2018-08-07T14:00:25.217022+03:00 4 542 {} [782] 0 1402 6 6                                                                  
137 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:30.100472+03:00 3 134 {} [78] 0 1401 1 3                                           1       1              
249 [] Asuntotonttien vuokraus ja myynti Uthyrning och försäljning av bostadstomter Selling or renting residential lots 78 2018-08-07T14:00:22.162414+03:00 4 245 {} [78] 0 1400 1 3                                           1       1              
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                      
2144 [] Vesibussilaiturit Vattenbussbryggor Water bus platforms 776 2018-08-07T14:00:25.224191+03:00 4 542 {} [776] 0 1402 3 3                                                                  
166 [] Verotoimistot Skattebyråer Tax offices 775 2018-08-07T14:00:30.318117+03:00 2 122 {} [775] 0 1401 1 1                                                                  
972 [] Venäjänkielinen ryhmäperhepäivähoito Gruppfamiljedagvård på ryska Group family day care in Russian 774 2018-08-07T14:00:28.950155+03:00 4 2145 {} [774] 0 1405   1                                           1                      
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              
946 [] päivähoito dagvård day care 773 2018-08-07T14:00:28.740210+03:00 4 945 {} [773] 0 1405 5 7                                                   2              
1114 [] venäjänkielinen opetus undervisning på ryska education in Russian 772 2018-08-07T14:00:25.622338+03:00 4 1109 {} [772] 1 1087 1 1                                                                  
1104 [] venäjänkielinen opetus undervisning på ryska education in Russian 771 2018-08-07T14:00:25.524519+03:00 4 1099 {} [771] 1 1087 1 1                                                                  
104 [] Asumisterveys Boendehälsa Housing health 77 2018-08-07T14:00:21.579504+03:00 3 103 {} [77] 0 1400 2 5                                 1         1       1              
546 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.230897+03:00 4 542 {} [769] 0 1402 147 188       2                 1         1       36             1        
705 [] Venesatama Serviceplats för båtfarare Boating services 769 2018-08-07T14:00:24.310541+03:00 4 695 {} [769] 0 1403 147 188       2                 1         1       36             1        
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} [769] 0 1402 147 188       2                 1         1       36             1        
549 [] Veneiden talvisäilytys Vinterförvaring av båtar Winter storage for boats 768 2018-08-07T14:00:25.255633+03:00 4 547 {} [768] 0 1402 1 1                                                                  
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                                            
91 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:21.983685+03:00 2 85 {} [766] 0 1400 2 2                                                                  
299 [] Vedenpuhdistuslaitos Vattenreningsverket Water treatment plant 766 2018-08-07T14:00:22.497732+03:00 4 293 {} [766] 0 1400 2 2                                                                  
159 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:30.247429+03:00 4 156 {} [765] 0 1401 3 4                                           1                      
2023 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:22.286375+03:00 5 265 {} [765] 0 1400 3 4                                           1                      
820 [] Vanhuspalvelun sosiaalityö Socialt arbete inom äldreomsorgen Service for the elderly, social work 764 2018-08-07T14:00:27.951192+03:00 2 819 {} [764] 0 783 5 16                                           1       8     2        
821 [] Vanhuspalvelun sosiaaliohjaus Socialhandledning inom äldreomsorg Services for the elderly, social care work 763 2018-08-07T14:00:27.957632+03:00 2 819 {} [763] 0 783 4 7                                                   2     1        
822 [] Vanhusten päivätoiminta Dagverksamhet för äldre Service for the elderly, daytime activities 762 2018-08-07T14:00:27.964013+03:00 2 819 {} [762] 0 783 17 30                                           9       3     1        
823 [] Vanhusten palvelukeskustoiminta Servicecentralverksamhet för äldre Service centre activities for the elderly 761 2018-08-07T14:00:27.970552+03:00 2 819 {} [761] 0 783 14 15                                                         1        
825 [] Vanhusten palveluasuminen Serviceboende för äldre Service residence for the elderly 760 2018-08-07T14:00:27.984445+03:00 2 819 {} [760] 0 783 30 103       1                                   36       32     3   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    
827 [] Vanhuspalvelun omaishoidon tuki Stöd för närståendevårdare inom äldreomsorgen Care for the elderly, close relative care support 759 2018-08-07T14:00:27.996868+03:00 2 819 {} [759] 0 783 4 8                                           1       2     1        
826 [] Vanhusten laitospalvelu Institutionsservice för äldre Institutional service for the elderly 758 2018-08-07T14:00:27.990439+03:00 2 819 {} [758] 0 783 4 7                                           2       1              
824 [] Vanhusten itsenäinen asuminen Självständigt boende för äldre Independent habitation for the elderly 757 2018-08-07T14:00:27.977916+03:00 2 819 {} [757] 0 783   4                                                   2     2        
828 [] Vanhusten avopalvelutoiminta Öppenserviceverksamhet inom äldre Outpatient service activities for the elderly 756 2018-08-07T14:00:28.002976+03:00 2 819 {} [756] 0 783   1                                           1                      
809 [] Vammaistuet ja -palvelut Handikappbidrag och -tjänster Disability benefits and services 755 2018-08-07T14:00:27.876348+03:00 2 798 {} [755] 0 783 3 15       1                                   2       7     1   1    
804 [] Vammaispalvelun tulkkipalvelu Tolktjänster inom handikappservicen Services for the disabled, interpretation services 754 2018-08-07T14:00:27.842330+03:00 2 798 {} [754] 0 783   6                                           2       4              
800 [] Vammaispalvelun tukihenkilö Stödperson inom handikappservice Services for the disabled, support person 753 2018-08-07T14:00:27.816289+03:00 2 798 {} [753] 0 783 4 8                                                   4              
799 [] Vammaispalvelun sosiaalityö Socialt arbete inom handikappservicen Service for the disabled, social work 752 2018-08-07T14:00:27.810101+03:00 2 798 {} [752] 0 783 4 11                                           3       4              
801 [] Vammaispalvelun sosiaaliohjaus Socialhandledning inom handikappservice Services for the disabled, social care work 751 2018-08-07T14:00:27.822488+03:00 2 798 {} [751] 0 783   33       1                                           32              
802 [] Vammaispalvelun päivätoiminta Dagverksamhet inom handikappservicen Service for the disabled, daytime activities 750 2018-08-07T14:00:27.829187+03:00 2 798 {} [750] 0 783   10                                           1       9              
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    
806 [] Vammaispalvelun omaishoidon tuki Stöd för närståendevård inom handikappservicen Services for the disabled, close relative care support 749 2018-08-07T14:00:27.856508+03:00 2 798 {} [749] 0 783 4 10                                           2       4              
808 [] Vammaispalvelun henkilökohtainen apu Personlig assistent inom handikappservicen Service for the disabled, personal assistant 748 2018-08-07T14:00:27.870086+03:00 2 798 {} [748] 0 783 4 9                                           1       4              
807 [] Vammaispalvelun asunnon muutostyöt Ändringsarbeten i bostad inom handikappservicen Service for the disabled, renovation services 747 2018-08-07T14:00:27.863389+03:00 2 798 {} [747] 0 783 4 10                                           2       4              
803 [] Vammaispalvelun asumispalvelut Boendetjänster inom handikappservicen Services for the disabled, residential services 746 2018-08-07T14:00:27.835887+03:00 2 798 {} [746] 0 783 7 24       1                                   3       13              
805 [] Vammaispalvelulain mukainen kuljetuspalvelu Färdtjänst enligt handikappservicelagen Transportation service according to the legislation on disability services 745 2018-08-07T14:00:27.849436+03:00 2 798 {} [745] 0 783 4 8                                           2       2              
2005 [] Valtuustotalot Fullmäktigehus Council buildings 744 2018-08-07T14:00:30.401425+03:00 4 173 {} [744] 0 1401   2                                           1             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              
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              
481 [] Valokuvaus Fotografering Photography 741 2018-08-07T14:00:23.182310+03:00 3 368 {} [741] 0 1403 1 2                                           1                      
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              
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                                            
676 [] Urheiluilmailualue Område för flygsport Sport aviation area 739 2018-08-07T14:00:24.108363+03:00 4 675 {} [739] 0 1403 1 1                                                                  
653 [] Ulkokuntoiluvälineet Konditionspark för utomhusaktiviteter Fitness training park 737 2018-08-07T14:00:23.939410+03:00 4 646 {} [737] 0 1403 168 320                                           100       43   3 6        
574 [] Ulkokiipeilyseinä Utomhusklättervägg Open-air climbing wall 736 2018-08-07T14:00:23.381720+03:00 4 572 {} [736] 0 1403 5 10                                           5                      
548 [] Ulkoilusaaret Friluftsöar Recreational islands 735 2018-10-25T08:00:07.487309+03:00 4 547 {} [735] 0 1402 54 69 1     2                 1   1     1       9                      
704 [] Ulkoilumaja / hiihtomaja Friluftsstuga / skidstuga Outdoor/ski lodge 734 2018-08-07T14:00:24.303405+03:00 4 695 {} [734] 0 1403 3 8                                           4           1          
714 [] Ulkoilualue Friluftsområde Outdoor area 733 2018-08-07T14:00:24.366593+03:00 4 706 {} [733] 0 1403 2 24                         1         3       17           1          
114 [] Uimavesien valvonta Övervakning av badvatten Swimming water supervision 732 2018-08-07T14:00:21.631376+03:00 3 103 {} [732] 0 1400 1 4                                 1         1       1              
689 [] Uimaranta Badstrand Supervised beach 731 2018-08-07T14:00:24.196951+03:00 4 685 {} [731] 0 1403 13 23                                           8       2              
688 [] Uimapaikka Badplats Unsupervised beach 730 2018-08-07T14:00:24.189679+03:00 4 685 {} [730] 0 1403 14 48                         4                 22       4   4          
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                                                                  
693 [] Uimahalli Simhall Public indoor swimming pool 729 2018-08-07T14:00:24.224255+03:00 4 690 {} [729] 0 1403 14 25                                           5       5     1        
692 [] Uima-allas Simbassäng Swimming pool 728 2018-08-07T14:00:24.217361+03:00 4 690 {} [728] 0 1403 21 28                                           6       1              
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                      
164 [] Työsuhdeasiat Anställningsfrågor Employment matters 725 2018-08-07T14:00:30.298491+03:00 2 122 {} [725] 0 1401 3 5                                           1       1              
855 [] Työkykyselvitys pitkäaikaistyöttömille Pensionsutredningsverksamhet Pension determination service 724 2018-08-07T14:00:28.183191+03:00 2 845 {} [724] 0 783 2 10                                                   8              
163 [] Työ- ja elinkeinotoimistot Arbets- och näringsbyråer Employment and economic development offices 723 2018-08-07T14:00:30.289431+03:00 2 122 {} [723] 0 1401 3 7                                           1       3              
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              
703 [] Tupa Stuga Hut 721 2018-08-07T14:00:24.296823+03:00 4 695 {} [721] 0 1403   2                                           1           1          
1067 [] Turvallisuuskoulutus Säkerhetsutbildning Safety training 720 2018-08-07T14:00:29.819172+03:00 2 1066 {} [720] 0 1061 1 1                                                                  
371 [] Askartelu Hobbyverksamhet Hobby crafts 72 2018-08-07T14:00:22.898108+03:00 3 368 {} [72] 0 1403 3 9                                           2       4              
113 [] Tupakkalain valvonta Tillsyn av tobakslagen Tobacco Act supervision 719 2018-08-07T14:00:21.625158+03:00 3 103 {} [719] 0 1400   2                                           1       1              
158 [] Tuotantotilojen vuokraus Uthyrning av produktionslokaler Production facility rental 718 2018-08-07T14:00:30.238264+03:00 4 156 {} [718] 0 1401 3 4                                           1                      
2022 [] Tuotantotilojen vuokraus Uthyrning av produktionslokaler Production facility rental 718 2018-08-07T14:00:22.279273+03:00 5 265 {} [718] 0 1400 3 4                                           1                      
781 [] Tuomioistuimet Domstolarna Finnish courts 717 2018-08-07T14:00:30.954711+03:00 3 769 {} [717] 0 1401 3 3                                                                  
1081 [] Tullin asiointipisteet Tullens verksamhetsställen Customs offices 716 2018-08-07T14:00:29.921102+03:00 2 1080 {} [716] 0 1061 4 7                                           1       2              

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