1,140 rows sorted by unit_count_municipality_espoo

View and edit SQL

unit_count_municipality__unknown

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ää
728 [] Kioski Kiosk Kiosk 142*309 2018-08-07T14:00:24.470558+03:00 5 725 {} 0 1403 2 2                                                                  
729 [] Ravintola Restaurang Restaurant 142*577 2018-08-07T14:00:24.477966+03:00 5 725 {} 0 1403 1 1                                                                  
730 [] Vesibussilaiturit Vattenbussbryggor Water bus platforms 142*776 2018-08-07T14:00:24.485125+03:00 4 719 {} 0 1403 3 3                                                                  
740 [] Kauppahallit Saluhallar Market halls 259 2018-08-07T14:00:24.520703+03:00 3 718 {} 0 1403 3 3                                                                  
741 [] Kioskit Kiosker Kiosks 309 2018-08-07T14:00:24.527473+03:00 3 718 {} 0 1403 2 2                                                                  
743 [] Leirintäalueet Campingområden Camping sites 390 2018-08-07T14:00:24.541305+03:00 3 718 {} 0 1403 1 1                                                                  
748 [] Muut matkailupalvelut Övriga turisttjänster Other tourism services 459 2018-08-07T14:00:24.575540+03:00 3 718 {} 0 1403 5 5                                                                  
753 [] Torit Torg Market squares 714 2018-08-07T14:00:24.610283+03:00 3 718 {} 0 1403 15 15                                                                  
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 {} 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 {} 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 {} 0 1401 1 2                                                   1              
781 [] Tuomioistuimet Domstolarna Finnish courts 717 2018-08-07T14:00:30.954711+03:00 3 769 {} 0 1401 3 3                                                                  
792 [] Lapsiperheiden sosiaaliohjaus Socialhandledning för barnfamiljer Social care work for families with children 373 2018-08-07T14:00:27.759985+03:00 2 791 {} 0 783   17                                                   16     1        
794 [] Lapsiperheiden kotipalvelu Hemservice för barnfamiljer Domestic services for families with children 371 2018-08-07T14:00:27.777393+03:00 2 791 {} 0 783 6 9                                                   3              
795 [] Lapsiperheiden lomatoiminta Semesterverksamhet för barnfamiljer Vacation activities for families with children 372 2018-08-07T14:00:27.784058+03:00 2 791 {} 0 783   1                                                         1        
796 [] Perheoikeudelliset palvelut Familjerättsliga tjänster Services for family law 505 2018-08-07T14:00:27.790684+03:00 2 791 {} 0 783   1                                                   1              
800 [] Vammaispalvelun tukihenkilö Stödperson inom handikappservice Services for the disabled, support person 753 2018-08-07T14:00:27.816289+03:00 2 798 {} 0 783 4 8                                                   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 {} 0 783   33       1                                           32              
811 [] Kehitysvammahuollon sosiaalityö Socialt arbete inom vård av utvecklingsstörda Care of the developmentally disabled, social work 280 2018-08-07T14:00:27.887549+03:00 2 810 {} 0 783 3 9                                                   5     1        
812 [] Kehitysvammahuollon sosiaaliohjaus Socialhandledning inom omsorger om utvecklingsstörda Care of the developmentally disabled, social care work 279 2018-08-07T14:00:27.893701+03:00 2 810 {} 0 783   1                                                         1        
814 [] Kehitysvammahuollon työllistämispalvelut Sysselsättningstjänster inom vård av utvecklingsstörda Care of the developmentally disabled, employment services 282 2018-08-07T14:00:27.906450+03:00 2 810 {} 0 783 5 6                                                   1              
816 [] Kehitysvammahuollon laitospalvelu Institutionsservice inom vård av utvecklingsstörda Care of the developmentally disabled, institutional service 276 2018-08-07T14:00:27.919212+03:00 2 810 {} 0 783   4                                                   4              
817 [] Kehitysvammahuollon loma- ja harrastustoiminta Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda Care of the developmentally disabled, vacation and leisure activities 277 2018-08-07T14:00:27.925241+03:00 2 810 {} 0 783 3 6                                                   3              
818 [] Kehitysvammahuollon taloudellinen tuki Ekonomiskt stöd inom vård av utvecklingsstörda Care of the developmentally disabled, financial support 281 2018-08-07T14:00:27.931547+03:00 2 810 {} 0 783 2 4                                                   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 {} 0 783 4 7                                                   2     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 {} 0 783 14 15                                                         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 {} 0 783   4                                                   2     2        
832 [] Päihdehuollon sosiaaliohjaus Socialhandledning inom missbrukarvården Care for substance abuse, social care work 548 2018-08-07T14:00:28.028451+03:00 2 830 {} 0 783   7                                                   6     1        
834 [] Päihdehuollon korvaushoito Substitutionsbehandling inom missbrukarvården Care for substance abuse, substitute treatment 545 2018-08-07T14:00:28.041229+03:00 2 830 {} 0 783 4 5                                                   1              
835 [] Päihdehuollon päivätoiminta Dagverksamhet inom missbrukarvården Care for substance abuse, daytime activities 547 2018-08-07T14:00:28.047640+03:00 2 830 {} 0 783 4 5                                                   1              
849 [] Mielenterveyskuntoutujien päivätoiminta Dagverksamhet för klienter inom psykrehabilitering Day activities for mental health rehabilitation clients 441 2018-08-07T14:00:28.144565+03:00 2 845 {} 0 783   1                                                   1              
853 [] Sosiaalihuoltolain mukainen kuljetuspalvelu Färdtjänst enligt socialvårdslagen Transportation service according to the legislation on social welfare 640 2018-08-07T14:00:28.169839+03:00 2 845 {} 0 783 3 6                                                   2     1        
855 [] Työkykyselvitys pitkäaikaistyöttömille Pensionsutredningsverksamhet Pension determination service 724 2018-08-07T14:00:28.183191+03:00 2 845 {} 0 783 2 10                                                   8              
856 [] Sovittelutoiminta Medlingsverksamhet Mitigation services 644 2018-08-07T14:00:28.189606+03:00 2 845 {} 0 783 1 2                                                   1              
859 [] Yhteiset tukipalvelut Gemensamma stödtjänster Shared support services 639 2018-08-07T14:00:28.209104+03:00 1 783 {} 0 783   3                                                   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 {} 0 783 1 2                                                   1              
861 [] Hoitoalan ruokapalvelut Mattjänster inom vårdbranschen Meal services in the care sector 196 2018-08-07T14:00:28.222009+03:00 1 783 {} 0 783 12 12                                                                  
866 [] Hallinto Förvaltning Administration 180 2018-08-07T14:00:28.228192+03:00 1 783 {} 0 783   1                                                   1              
875 [] erityisryhmä specialgrupp special group 663*156 2018-08-07T14:00:28.291078+03:00 4 870 {} 0 1405 49 77                                                   28              
880 [] osapäiväryhmä halvdagsgrupp part-time day care 663*489 2018-08-07T14:00:28.322654+03:00 4 870 {} 0 1405 33 33                                                                  
883 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 603*200 2018-08-07T14:00:28.354237+03:00 4 881 {} 0 1405 2 3                                                         1        
886 [] erityisryhmä specialgrupp special group 603*156 2018-08-07T14:00:28.367894+03:00 4 881 {} 0 1405 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 {} 0 1405 1 1                                                                  
890 [] päivähoito dagvård day care 607 2018-08-07T14:00:28.398158+03:00 4 889 {} 0 1405 1 1                                                                  
895 [] esiopetus förskoleundervisning pre-primary education 607*160 2018-08-07T14:00:28.423737+03:00 4 889 {} 1 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 {} 0 1405 2 2                                                                  
898 [] päivähoito dagvård day care 58 2018-08-07T14:00:28.442943+03:00 4 897 {} 0 1405 2 2                                                                  
903 [] esiopetus förskoleundervisning pre-primary education 58*160 2018-08-07T14:00:28.468345+03:00 4 897 {} 1 1405 1 1                                                                  
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 {} 0 1405 2 2                                                                  
914 [] päivähoito dagvård day care 164 2018-08-07T14:00:28.533814+03:00 4 913 {} 0 1405 2 2                                                                  
919 [] esiopetus förskoleundervisning pre-primary education 164*160 2018-08-07T14:00:28.559368+03:00 4 913 {} 1 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 {} 0 1405 1 1                                                                  
922 [] päivähoito dagvård day care 188 2018-08-07T14:00:28.579608+03:00 4 921 {} 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 {} 0 1405 6 6                                                                  
930 [] päivähoito dagvård day care 569 2018-08-07T14:00:28.629796+03:00 4 929 {} 0 1405 6 6                                                                  
935 [] esiopetus förskoleundervisning pre-primary education 569*160 2018-08-07T14:00:28.657653+03:00 4 929 {} 1 1405 3 3                                                                  
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 {} 0 1405 2 2                                                                  
938 [] päivähoito dagvård day care 614 2018-08-07T14:00:28.681434+03:00 4 937 {} 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 {} 0 1405 5 7                                                   2              
946 [] päivähoito dagvård day care 773 2018-08-07T14:00:28.740210+03:00 4 945 {} 0 1405 5 7                                                   2              
959 [] esiopetus förskoleundervisning pre-primary education 795*160 2018-08-07T14:00:28.844971+03:00 4 953 {} 1 1405 1 1                                                                  
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 {} 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 {} 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"]} 0 1405 2 2                                                                  
985 [] Päivähoidon sähköinen asiointi ja lomakkeet Elektroniska tjänster och blanketter för dagvårdsärenden Electronic services and forms related to day care 552 2018-08-07T14:00:29.033246+03:00 2 868 {} 0 1405 1 1                                                                  
990 [] Apteekki Apotek Pharmacy 57 2018-08-07T14:00:29.143841+03:00 1 986 {} 0 986 1 8                                                   7              
998 [] Tartuntaudit Smittsamma sjukdomar Infectious diseases 693 2018-08-07T14:00:29.221985+03:00 1 986 {"fi": ["tartuntatauti", "tartuntataudit"]} 0 986 1 3                                                   2              
999 [] Myrkytystietoa Giftinformation Poison information 461 2018-08-07T14:00:29.228018+03:00 1 986 {} 0 986   1                     1                                            
1007 [] Kehitysvammapoliklinikka Handikapprådgivning Developmental disability clinic 284 2018-10-25T08:00:09.092312+03:00 2 810 {} 0 783 4 6                                                   1         1    
1011 [] Kaupungin psykiatrinen sairaala Stadens psykiatriska sjukhus City Psychiatric Hospital 263 2018-08-07T14:00:29.322493+03:00 2 1009 {} 0 986 2 2                                                                  
1013 [] Kotisairaalat Hemsjukhus Domestic hospitals 336 2018-08-07T14:00:29.340263+03:00 2 1009 {} 0 986 3 4                                                   1              
1015 [] Sairaaloiden poliklinikat Sjukhusens polikliniker Hospital outpatient clinics 610 2018-08-07T14:00:29.359098+03:00 2 1009 {} 0 986 3 3                                                                  
1020 [] Akuuttipsykiatria Akutpsykiatri Acute psychiatry 46 2018-08-07T14:00:29.412887+03:00 2 1019 {} 0 986 1 4                                                   3              
1021 [] HUS:n erikoissairaanhoito HNS:s specialsjukvård HUS specialised health care 440 2018-08-07T14:00:29.421431+03:00 2 1019 {} 0 986 2 2                                                                  
1023 [] Psykiatrian poliklinikat Psykiatriska polikliniker Psychiatric outpatient clinics 521 2018-08-07T14:00:29.437165+03:00 2 1019 {} 0 986 19 19                                                                  
1025 [] Psykiatrinen perhehoito Psykiatrisk familjevård Psychiatric family care 523 2018-08-07T14:00:29.453053+03:00 2 1019 {} 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 {} 0 986 2 2                                                                  
1027 [] Psykoterapia Psykoterapi Psychotherapy 526 2018-08-07T14:00:29.469348+03:00 2 1019 {} 0 986 2 2                                                                  
1035 [] Neurologia Neurologi Neurology 462 2018-08-07T14:00:29.539786+03:00 2 1028 {} 0 986   6                                                   6              
1037 [] Rintamavetaraanien kuntoutus Rehabilitering av frontveteraner Front-line veteran rehabilitation 583 2018-08-07T14:00:29.562795+03:00 2 1028 {} 0 986 1 6                                                   4     1        
1039 [] Ravitsemusterapia Näringsterapi Nutrition therapy 579 2018-08-07T14:00:29.591225+03:00 1 986 {} 0 986   1                                                   1              
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} 0 986 7 10                                                   2     1        
1042 [] Kuulontutkimus Hörseltester Hearing tests 357 2018-08-07T14:00:29.607627+03:00 1 986 {} 0 986   1                                                   1              
1043 [] Omahoitotarvikejakelu Utdelning av egenvårdsartiklar Distribution of self-care supplies 477 2018-08-07T14:00:29.623935+03:00 1 986 {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} 0 986 1 6                                                   3     2        
1044 [] Silmätaudit Ögonsjukdomar Eye diseases 622 2018-08-07T14:00:29.630771+03:00 1 986 {} 0 986 1 2                                                   1              
1048 [1050] Hallintopalvelut Förvaltningstjänster Patient representative services   2020-03-06T18:32:09.249350+02:00 1 986 {} 0 986   1                                                   1              
1050 [] Potilasasiamies Patientombudsman Patient representative 520 2018-08-07T14:00:29.675023+03:00 2 1048 {} 0 986   1                                                   1              
1053 [] Päihdehuollon sosiaaliohjaus Socialhandledning inom missbrukarvården Care for substance abuse, social care work 548 2018-08-07T14:00:29.695330+03:00 2 1051 {} 0 986   7                                                   6     1        
1055 [] Päihdehuollon korvaushoito Substitutionsbehandling inom missbrukarvården Care for substance abuse, substitute treatment 545 2018-08-07T14:00:29.709367+03:00 2 1051 {} 0 986 4 5                                                   1              
1056 [] Päihdehuollon päivätoiminta Dagverksamhet inom missbrukarvården Care for substance abuse, daytime activities 547 2018-08-07T14:00:29.716393+03:00 2 1051 {} 0 986 4 5                                                   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 {} 0 986   2                     1                             1              
1063 [] Maanpuolustusyhdistykset Försvarsföreningar National defence associations 422 2018-08-07T14:00:29.780736+03:00 2 1062 {} 0 1061 2 2                                                                  
1065 [] Meripelastus Sjöräddningen Sea rescue 435 2018-08-07T14:00:29.800283+03:00 1 1061 {} 0 1061 1 1                                                                  
1067 [] Turvallisuuskoulutus Säkerhetsutbildning Safety training 720 2018-08-07T14:00:29.819172+03:00 2 1066 {} 0 1061 1 1                                                                  
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 {} 0 1061 1 2                                                   1              
1073 [] Pelastuskoulu Räddningsskolan School of Fire and Rescue Services 502 2018-08-07T14:00:29.866063+03:00 2 1070 {} 0 1061 1 1                                                                  
1078 [] Rajavartiolaitos Gränsbevakningsväsendet Border guard 557 2018-08-07T14:00:29.900790+03:00 1 1061 {} 0 1061 1 1                                                                  
1079 [] Säteilyturva Strålsäkerhet Radiation and nuclear safety 671 2018-08-07T14:00:29.907687+03:00 1 1061 {} 0 1061 1 1                                                                  
1082 [] Väestöhälyttimet Befolkningslarm Public alarm systems 805 2018-08-07T14:00:29.929327+03:00 1 1061 {} 0 1061 38 38                                                                  
1083 [1084, 1086] Väestönsuojat Befolkningsskyddsrum Public shelters   2018-08-07T14:00:29.937480+03:00 1 1061 {} 0 1061 47 49                                                         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
);