160 rows where unit_count_municipality_kauniainen = 1 sorted by unit_count_municipality_vantaa

View and edit SQL

Suggested facets: level, keywords, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vantaa, unit_count_municipality_kerava, last_modified_time (date)

unit_count_municipality_kauniainen

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ää
8 [10, 9, 11] Vuokra-asuminen Hyresbostäder Rental flats   2018-08-07T14:00:21.267377+03:00 2 2 {} 0 1400 9 13                                           3             1        
9 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:21.273119+03:00 3 8 {} 0 1400 9 12                                           2             1        
32 [] Jäteasema Avfallsstation Waste station 232 2018-08-07T14:00:21.766335+03:00 2 31 {} 0 1400 1 2                                                         1        
135 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:30.087071+03:00 3 134 {} 0 1401 9 12                                           2             1        
154 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:30.213017+03:00 4 149 {} 0 1401   17                                           16             1        
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 {} 0 1401 1 2                                                         1        
227 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:22.030360+03:00 4 226 {} 0 1400 1 3                                           1             1        
247 [] Kaupungin tai kunnan vuokra-asunnot Stadens eller kommunens hyresbostäder City's or municipality's rental apartments 268 2018-08-07T14:00:22.149025+03:00 4 245 {} 0 1400 9 12                                           2             1        
263 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.252638+03:00 5 258 {} 0 1400   17                                           16             1        
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} 0 1402   1                                                         1        
418 [] Kuvataide Bildkonst Visual arts 359 2018-08-07T14:00:23.020022+03:00 3 368 {} 0 1403 2 5                                           2             1        
510 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.836894+03:00 3 505 {} 0 1403   17                                           16             1        
522 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:25.064660+03:00 3 521 {} 0 1402 1 3                                           1             1        
541 [542, 547] Vesiliikenne Sjötrafik Water traffic   2018-08-07T14:00:25.190941+03:00 2 512 {} 0 1402 223 279 1     4                 2   1     2       45             1        
542 [543, 544, 545, 2198, 546, 2144] Satamat ja laiturit Hamn och bryggor Harbours, piers and quays   2018-08-07T14:00:25.196186+03:00 3 541 {} 0 1402 168 209       2                 1         1       36             1        
546 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.230897+03:00 4 542 {} 0 1402 147 188       2                 1         1       36             1        
547 [548, 2199, 549, 2143, 2142] Veneily Båtsport Boating   2018-08-07T14:00:25.237133+03:00 3 541 {} 0 1402 206 262 1     4                 2   1     2       45             1        
705 [] Venesatama Serviceplats för båtfarare Boating services 769 2018-08-07T14:00:24.310541+03:00 4 695 {} 0 1403 147 188       2                 1         1       36             1        
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        
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        
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        
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        
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        
1006 [] Perhesuunnittelu ja ehkäisyneuvola Familjeplanerings- och preventivmedelsrådgivning Family planning and contraception clinic 507 2018-08-07T14:00:29.286660+03:00 2 1004 {} 0 986   5                                           4             1        
1074 [] Sopimuspalokunnat Avtalsbrandkårer Volunteer fire departments 633 2018-08-07T14:00:29.872976+03:00 2 1070 {} 0 1061 15 23                                           7             1        
1356 [1357] Ammattikorkeakoulut Yrkeshögskolor Polytechnics 654 2018-08-07T14:00:27.483584+03:00 1 1087 {} 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 {} 0 1087 1 2                                                         1        
1362 [] Asiakaspalvelu Kundtjänst Customer services 665*66 2020-11-18T07:30:12.851359+02:00 3 1361 {} 0 1087 7 9                                           1             1        
1363 [] Opetuspaikat Verksamhetsställen Teaching locations 665*727 2020-11-18T07:30:12.858775+02:00 3 1361 {} 0 1087 44 46                                           1             1        
1366 [] Asiakaspalvelu Kundtjänst Customer services 605*66 2020-11-18T07:30:12.883321+02:00 3 1365 {} 0 1087 2 3                                                         1        
1367 [] Opetuspaikat Verksamhetsställen Teaching locations 605*727 2020-11-18T07:30:12.891173+02:00 3 1365 {} 0 1087 2 3                                                         1        
2005 [] Valtuustotalot Fullmäktigehus Council buildings 744 2018-08-07T14:00:30.401425+03:00 4 173 {} 0 1401   2                                           1             1        
2011 [] Ehkäisevä toimeentulotuki Förebyggande utkomststöd Preventive social assistance 840 2018-08-07T14:00:28.099014+03:00 2 839 {} 0 783 7 8                                                         1        
2142 [] Venesatamat Båthamnar Marinas 769 2018-08-07T14:00:25.242377+03:00 4 547 {} 0 1402 147 188       2                 1         1       36             1        
2220 [] Seniorikävely Seniorgående Senior walk 901 2020-06-09T15:30:11.341704+03:00 3 2217 {} 0 1403 6 7                                                         1        
48 [] Sekajäte Blandat avfall Mixed waste 617 2018-08-07T14:00:21.889545+03:00 3 34 {} 0 1400 2 6                                           2       1     1        
52 [] Kierrätyskeskus Återvinningscentral Recycling centre 298 2018-08-07T14:00:21.919516+03:00 2 31 {} 0 1400 3 7                                   1       1       1     1        
191 [192, 193, 194, 195, 196] Päätöksenteko Beslutsfattande Decision-making   2018-08-07T14:00:30.523612+03:00 2 171 {} 0 1401 6 10                                           2       1     1        
194 [] Kaupunginvaltuusto Stadsfullmäktige City Council 273 2018-08-07T14:00:30.540753+03:00 3 191 {} 0 1401 2 5                                           1       1     1        
223 [] Asiakaspalvelu Kundtjänst Customer services 64 2018-08-07T14:00:22.006084+03:00 3 222 {} 0 1400   3                                           1       1     1        
224 [] Info- ja näyttelytilat Informations- och utställningslokaler Info and exhibition premises 201 2018-08-07T14:00:22.012371+03:00 3 222 {} 0 1400 2 4                                                   1     1        
226 [227, 228] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:22.025116+03:00 3 222 {} 0 1400 1 5                                           2       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 {} 0 1402 2 4                                                   1     1        
354 [] Konserttitilat Konsertutrymmen Concert facilities 329 2018-08-07T14:00:22.610197+03:00 3 352 {} 0 1403 33 43                                           8       1     1        
521 [522, 523] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:25.059349+03:00 2 512 {} 0 1402 1 5                                           2       1     1        
584 [] Luontopolku Naturstig Nature trail 413 2018-08-07T14:00:23.440979+03:00 4 577 {} 0 1403 12 41       1                 1                 24       1   1 1        
656 [] Jalkapallostadion Fotbollsstadion Football stadium 205 2018-08-07T14:00:23.964244+03:00 4 654 {} 0 1403 1 4                                           1       1     1        
756 [757, 763] Demokratia Demokrati Democracy   2018-08-07T14:00:30.749902+03:00 2 755 {} 0 1401 8 13                                           3       1     1        
757 [758, 759, 760, 761, 762] Päätöksenteko Beslutsfattande Decision-making   2018-08-07T14:00:30.759776+03:00 3 756 {} 0 1401 6 10                                           2       1     1        
760 [] Kaupunginvaltuusto Stadsfullmäktige City Council 273 2018-08-07T14:00:30.790348+03:00 4 757 {} 0 1401 2 5                                           1       1     1        
831 [] Päihdehuollon sosiaalityö Socialt arbete inom missbrukarvården Care for substance abuse, social work 549 2018-08-07T14:00:28.021758+03:00 2 830 {} 0 783 1 4                                           1       1     1        
905 [911, 906] Englanninkielinen päivähoito Engelskspråkig dagvård Day care in English 151 2018-08-07T14:00:28.480764+03:00 3 869 {} 0 1405 39 62                                           21       1     1        
906 [] päivähoito dagvård day care 151 2018-08-07T14:00:28.486872+03:00 4 905 {} 0 1405 39 62                                           21       1     1        
1000 [1001, 1002, 1003] Päivystys Jour Emergency services   2018-08-07T14:00:29.234256+03:00 1 986 {} 0 986   6                                           4       1     1        
1001 [] Aikuisten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för vuxna Health centre on-call service and emergency outpatient clinic for adults 43 2018-08-07T14:00:29.242685+03:00 2 1000 {"fi": ["p\u00e4ivystys"]} 0 986   3                                           1       1     1        
1002 [] Lasten terveyskeskuspäivystys ja päivystyspoliklinikka Hälsocentraljour och jourpoliklinik för barn Health centre on-call service and emergency outpatient clinic for children 378 2018-10-25T08:00:09.598902+03:00 2 1000 {} 0 986   3                                           1       1     1        
1034 [] Lääkinnällinen kuntoutus Medicinsk rehabilitering Medical rehabilitation 416 2018-08-07T14:00:29.531662+03:00 2 1028 {} 0 986 1 5                                           2       1     1        
1052 [] Päihdehuollon sosiaalityö Socialt arbete inom missbrukarvården Care for substance abuse, social work 549 2018-08-07T14:00:29.687959+03:00 2 1051 {} 0 986 1 4                                           1       1     1        
2003 [] Kaupungintalot Stadshus City halls 270 2018-08-07T14:00:30.383310+03:00 4 173 {} 0 1401 1 3                                                   1     1        
2012 [] Täydentävä toimeentulotuki Kompletterande utkomststöd Supplementary social assistance 841 2018-08-07T14:00:28.105801+03:00 2 839 {} 0 783 7 9                                                   1     1        
219 [220] Tuet ja avustukset Understöd och bidrag Grants and benefits 715 2018-08-07T14:00:30.723645+03:00 2 171 {} 0 1401   3                                                   2     1        
225 [] Kaavat ja kaavoitus Planer och planlägging Town plans and zoning 237 2018-08-07T14:00:22.018653+03:00 3 222 {} 0 1400 5 9                                           1       2     1        
282 [] Rakennus- ja toimenpideluvat Bygglov och åtgärdstillstånd Licences for construction and operations 558 2018-08-07T14:00:22.390024+03:00 4 279 {} 0 1400 1 5                                           1       2     1        
604 [] Kilpajäähalli Tävlingsishall Competition ice arena 308 2018-08-07T14:00:23.575267+03:00 4 602 {} 0 1403 2 7                                           2       2     1        
755 [756, 768, 769] Oikeusturva ja demokratia Rättsskydd och demokrati Justice system and democracy   2020-03-06T18:32:09.608464+02:00 1 1401 {} 0 1401 15 46                                           28       2     1        
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        
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 {} 0 783 4 8                                           1       2     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        
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        
1040 [] Jalkaterapia Fotvård Podiatry 206 2018-08-07T14:00:29.581915+03:00 2 1028 {} 0 986 7 10                                                   2     1        
2193 [] Korkeakoulujen kirjastot Högskolebibliotek Polytechnic libraries 880 2019-03-20T13:30:07.442599+02:00 3 324 {} 0 1402 8 14                                           3       2     1        
2196 [] Korkeakoulujen kirjastot Högskolebibliotek Polytechnic libraries 880 2019-04-02T13:30:07.763547+03:00 3 345 {} 0 1403 8 14                                           3       2     1        
2225 [] Senioritanssi Seniordans Senior dancing 900 2020-06-09T15:30:11.415952+03:00 3 2217 {} 0 1403 24 29                                           2       2     1        
78 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:21.475789+03:00 3 74 {} 0 1400 1 6                                           1       3     1        
189 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:30.517534+03:00 3 187 {} 0 1401 14 20                                           2       3     1        
222 [223, 224, 225, 226, 229, 230] Kaavoitus Planläggning Planning   2018-08-07T14:00:22.001028+03:00 2 221 {} 0 1400 9 15                                           2       3     1        
514 [] Asiakaspalvelu ja lipunmyynti Kundtjänst och biljettförsäljning Customer service and ticket sales 63+404 2018-10-24T20:00:07.778946+03:00 3 513 {} 0 1402 5 11                                           2       3     1        
538 [] Katujen puhtaanapito ja talvikunnossapito Renhållning och vinterunderhåll av gator Street cleaning and winter maintenance 253 2018-08-07T14:00:25.170663+03:00 3 534 {} 0 1402 1 6                                           1       3     1        
615 [] Jalkapallohalli Fotbollshall Football hall 204 2018-08-07T14:00:23.650553+03:00 4 614 {} 0 1403 8 18                                           6       3     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 {} 0 783 17 30                                           9       3     1        
839 [2011, 841, 843, 2012] Toimeentulotuki Utkomststöd Social assistance   2018-08-07T14:00:28.080690+03:00 1 783 {} 0 783 11 20       1                                   3       3     1   1    
857 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:28.196278+03:00 2 845 {} 0 783 14 20                                           2       3     1        
1029 [] Apuvälinepalvelut Hjälpmedelstjänster Aid services 352 2018-08-07T14:00:29.484194+03:00 2 1028 {} 0 986 5 10                                           1       3     1        
1335 [1343, 1336] Aikuiskoulutus Vuxenutbildning Adult education   2018-08-07T14:00:27.345252+03:00 1 1087 {} 0 1087 5 11                                           2       3     1        
307 [308, 313, 309, 310, 312] Arkistot Arkiv Archives   2018-08-07T14:00:24.657353+03:00 2 306 {} 0 1402 4 11                                           2       4     1        
602 [603, 604] Jäähallit Ishallar Ice-skating arenas   2018-08-07T14:00:23.562977+03:00 3 601 {} 0 1403 12 24                                           7       4     1        
872 [] iltahoito 17:30-22:00 kvällsvård 17.30-22.00 evening care 5:30pm-10:00pm 663*200 2018-08-07T14:00:28.278055+03:00 4 870 {} 0 1405 6 14                                           3       4     1        
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        
1041 [] Psykologitoiminta Psykologverksamhet Psychologists 525 2018-08-07T14:00:29.598972+03:00 1 986 {} 0 986 4 10                                           1       4     1        
1376 [] Koulu- ja opiskelijaruokailu Måltider för elever och studerande Meals for pupils and students 338 2020-08-20T14:00:09.319013+03:00 1 1087 {} 0 1087 119 136                                           12       4     1        
187 [188, 189] Maahanmuutto Invandring Immigration   2018-08-07T14:00:30.506450+03:00 2 171 {} 0 1401 17 29       1                                   4       5     1   1    
279 [281, 282, 283, 284, 285] Rakennusvalvonta Byggnadstillsyn Building Control   2018-08-07T14:00:22.376681+03:00 3 270 {} 0 1400 3 11                                           2       5     1        
693 [] Uimahalli Simhall Public indoor swimming pool 729 2018-08-07T14:00:24.224255+03:00 4 690 {} 0 1403 14 25                                           5       5     1        
793 [] Perheneuvonta ja perheneuvolatoiminta Familjerådgivning och familjerådgivningsverksamhet Family counselling and family clinic 504 2018-10-25T08:00:09.024637+03:00 2 791 {} 0 783 10 20                                           4       5     1        
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        
1031 [] Fysioterapia Fysioterapi Physiotherapy 172 2018-08-07T14:00:29.505159+03:00 2 1028 {"fi": ["kuntoutus"]} 0 986 11 21                                           4       5     1        
1036 [] Puheterapia Talterapi Speech therapy 527 2018-08-07T14:00:29.552393+03:00 2 1028 {"fi": ["kuntoutus"]} 0 986 2 13                                           5       5     1        
616 [] Liikuntahalli Idrottshall Sports hall 400 2018-08-07T14:00:23.657783+03:00 4 614 {} 0 1403 24 38                                           7       6     1        
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        
850 [] Työhön kuntoutus- ja työllistämispalvelut Arbetsrehabiliterings- och sysselsättningstjänster Rehabilitation and employment services for work 638 2018-08-07T14:00:28.151060+03:00 2 845 {} 0 783 4 12                                           1       6     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
);