1,140 rows sorted by name_en descending

View and edit SQL

unit_count_municipality_kirkkonummi

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ää
492 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:22.690959+03:00 3 491 {} 0 1403 49 49                                                                  
332 [] WLAN-ulkopisteet WLAN-utomhusstationer WLAN outlets 807 2018-08-07T14:00:24.889824+03:00 4 330 {} 0 1402 10 10                                                                  
331 [] WLAN-sisäpisteet WLAN-inomhusstationer WLAN inlets 806 2018-08-07T14:00:24.883321+03:00 4 330 {} 0 1402 223 230                                                   7              
1074 [] Sopimuspalokunnat Avtalsbrandkårer Volunteer fire departments 633 2018-08-07T14:00:29.872976+03:00 2 1070 {} 0 1061 15 23                                           7             1        
658 [] Lentopallokenttä Volleybollplan Volleyball court 392 2018-08-07T14:00:23.980139+03:00 4 654 {} 0 1403 46 86                         1                 10       28   1          
123 [] Ammatinvalinnanohjaus Yrkesvägledning Vocational guidance 51 2018-08-07T14:00:30.001277+03:00 2 122 {} 0 1401 4 6                                           1       1              
2179 [2186, 2200, 2181, 2180] Ammatillinen koulutus Yrkesutbildning Vocational education   2018-08-31T16:00:09.179533+03:00 1 1087 {} 0 1087 18 24                                           2       4              
418 [] Kuvataide Bildkonst Visual arts 359 2018-08-07T14:00:23.020022+03:00 3 368 {} 0 1403 2 5                                           2             1        
106 [] Eläinlääkäripalvelut Veterinärtjänster Vet services 140 2018-08-07T14:00:21.592468+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
2173 [] Tapahtumapaikat Evenemangsplatser Venues 868 2018-08-07T14:00:24.624759+03:00 2 717 {} 0 1403 195 211                                           10       6              
651 [] Pyöräilyrata Cykelåkningsbana Velodrome 539 2018-08-07T14:00:23.920549+03:00 4 646 {} 0 1403 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        
1268 [1270, 1269] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:26.852029+03:00 3 1258 {} 0 1087 14 30                                           11       5              
1300 [1302, 1301] Lukion linja Gymnasieutbildning, linjetyp Upper secondary school, type of programme   2018-08-07T14:00:27.088539+03:00 3 1298 {} 0 1087 3 5                                           1       1              
1269 [] Yleislinjan lukiokoulutus Gymnasieutbildning, allmän linje Upper secondary school education, general programme 148*816+161*816+300*816+383*816+566*816+611*816+658*816+770*816+792*816 2018-10-25T08:00:08.527922+03:00 4 1268 {} 1 1087 14 30                                           11       5              
1301 [] Yleislinjan lukiokoulutus Gymnasieutbildning, allmän linje Upper secondary school education, general programme 598*816 2018-08-07T14:00:27.095367+03:00 4 1300 {} 1 1087 2 4                                           1       1              
1270 [] Erityistehtävän mukainen lukiokoulutus Gymnasieutbildning med särskild uppgift Upper secondary school education with special curriculum 148*157+161*157+300*157+383*157+566*157+611*157+658*157+770*157+792*157 2018-10-25T08:00:08.535976+03:00 4 1268 {} 1 1087 6 9                                                   3              
1302 [] Erityistehtävän mukainen lukiokoulutus Gymnasieutbildning med särskild uppgift Upper secondary school education with special curriculum 598*157 2018-08-07T14:00:27.104000+03:00 4 1300 {} 1 1087 1 1                                                                  
1337 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 650 2018-08-07T14:00:27.357192+03:00 3 1336 {} 1 1087 2 7                                           2       3              
1344 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 590 2018-08-07T14:00:27.406024+03:00 3 1343 {} 1 1087 1 1                                                                  
1342 [] Kaksoistutkinto Dubbel gymnasieexamen Upper secondary school dual qualification 408 2018-08-07T14:00:27.393475+03:00 3 1336 {} 1 1087 1 1                                                                  
688 [] Uimapaikka Badplats Unsupervised beach 730 2018-08-07T14:00:24.189679+03:00 4 685 {} 0 1403 14 48                         4                 22       4   4          
2194 [] Yliopistojen kirjastot Universitetsbibliotek University libraries 879 2019-03-20T13:30:07.460582+02:00 3 324 {} 0 1403 10 11                                           1                      
2197 [] Yliopistojen kirjastot Universitetsbibliotek University libraries 879 2019-04-02T13:30:07.786077+03:00 3 345 {} 0 1403 10 11                                           1                      
1010 [] Yliopistolliset sairaalat Universitetssjukhus University hospitals 820 2018-08-07T14:00:29.314677+03:00 2 1009 {} 0 986 18 31                             1 1           4   2   3 2            
1359 [] Yliopistot Universitet Universities 822 2018-08-07T14:00:27.510881+03:00 1 1087 {} 0 1087 10 60                                           50                      
165 [] Työttömyys Arbetslöshet Unemployment 464 2018-08-07T14:00:30.308304+03:00 2 122 {} 0 1401 4 8                                           1       3              
775 [] Edunvalvonta Intressebevakning Trusteeship 131 2018-08-07T14:00:30.904881+03:00 3 769 {} 0 1401 1 3                                           2                      
458 [] Retkeily Camping Trekking 580 2018-08-07T14:00:23.138224+03:00 3 368 {} 0 1403 2 7                                           5                      
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        
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 {} 0 783 4 8                                           2       2              
603 [] Harjoitusjäähalli Övningsishall Training ice arena 187 2018-08-07T14:00:23.568317+03:00 4 602 {} 0 1403 10 17                                           5       2              
593 [] Ampumahiihdon harjoittelualue Träningsområde för skidskytte Training area for biathlon 52 2018-08-07T14:00:23.502563+03:00 4 592 {} 0 1403   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        
227 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:22.030360+03:00 4 226 {} 0 1400 1 3                                           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        
522 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:25.064660+03:00 3 521 {} 0 1402 1 3                                           1             1        
228 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:05.577987+03:00 4 226 {} 0 1400   2                                           1       1              
523 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:06.706293+03:00 3 521 {} 0 1402   2                                           1       1              
1402 [306, 512] Liikenne ja kartat Trafik och kartor Traffic and maps   2018-08-07T14:00:24.647447+03:00 0   {} 0 1402 1567 2238 1     4             1   2   1     2       581       71     8        
512 [513, 521, 525, 526, 533, 534, 541] Liikenne Trafik Traffic   2018-08-07T14:00:24.996122+03:00 1 1402 {} 0 1402 1269 1864 1     4                 2   1     2       540       39     6        
133 [] Kauppa- ja yhdistysrekisteri Handelsregistret och föreningsregistret Trade register and register of associations 257 2018-08-07T14:00:30.073459+03:00 2 122 {} 0 1401 1 2                                           1                      
126 [] Elinkeinoasiat Näringslivsfrågor Trade and industry matters 132 2018-08-07T14:00:30.024180+03:00 2 122 {} 0 1401 2 2                                                                  
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        
308 [] Asemakaava-arkisto Detaljplanearkiv Town plan archive 60 2018-08-07T14:00:24.662512+03:00 3 307 {} 0 1402   1                                                         1        
527 [] Ajoneuvojen siirrot Flyttning av fordon Towing vehicles 44 2018-08-07T14:00:25.100072+03:00 3 526 {} 0 1402 2 5                                           1       2              
710 [] Matkailupalveluiden alue Område med turisttjänster Tourist services area 430 2018-08-07T14:00:24.337371+03:00 4 706 {} 0 1403 5 5                                                                  
144 [] Matkailumarkkinointi Marknadsföring av turism Tourism marketing 428 2018-08-07T14:00:30.145003+03:00 3 141 {} 0 1401 2 4                                                   2              
316 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.717090+03:00 3 314 {} 0 1402 2 12                                           6       4              
744 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.548312+03:00 3 718 {} 0 1403 2 12                                           6       4              
718 [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] Matkailu Turism Tourism   2018-08-07T14:00:24.401683+03:00 2 717 {} 0 1403 1880 2050       1 1 1       1 1 1 1   3   5 3       79       64 1 1 3 4      
2153 [] Kosketusnäyttöopasteet Infokiosker med pekskärm Touch screen guideposts 851 2018-08-07T14:00:24.869369+03:00 3 329 {} 0 1403 21 21                                                                  
113 [] Tupakkalain valvonta Tillsyn av tobakslagen Tobacco Act supervision 719 2018-08-07T14:00:21.625158+03:00 3 103 {} 0 1400   2                                           1       1              
754 [] Lipunmyynti tapahtumiin Biljettförsäljning till evenemang Ticket sales to events 405 2018-08-07T14:00:24.631976+03:00 2 717 {} 0 1403 5 13                     1                     6       1              
723 [] Lipunmyynti Biljettförsäljning Ticket sales 403 2018-08-07T14:00:24.435423+03:00 4 719 {} 0 1403 3 4                     1                                            
518 [] Matkalippujen tarkastus Biljettkontroll Ticket inspection 431 2018-08-07T14:00:25.036866+03:00 3 513 {} 0 1402 1 1                                                                  
717 [754, 718, 2173, 2028] Matkailu ja tapahtumat Turism och evenemang Things to do   2020-03-06T18:32:07.102459+02:00 1 1403 {} 0 1403 1973 2155       1 1 1       1 2 1 1   3   5 3       87       67 1 1 3 4      
360 [] Teatterit Teatrar Theatres 694 2018-08-07T14:00:22.651704+03:00 3 352 {} 0 1403 50 62                                           10       2              
752 [] Teatterit Teatrar Theatres 694 2018-08-07T14:00:24.603285+03:00 3 718 {} 0 1403 50 62                                           10       2              
2154 [] Teatteri Teater Theatre 852 2018-08-07T14:00:23.169545+03:00 3 368 {} 0 1403 1 2                                           1                      
1064 [] Puolustusvoimat Försvarsmakten The Finnish Defence Forces 529 2018-08-07T14:00:29.789161+03:00 2 1062 {} 0 1061 6 7                                           1                      
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} 0 1400 40 108                                           37       29     2        
545 [] Terminaalit Terminaler Terminals 782 2018-08-07T14:00:25.217022+03:00 4 542 {} 0 1402 6 6                                                                  
623 [] Tennishalli Tennishall Tennis hall 699 2018-08-07T14:00:23.714268+03:00 4 614 {} 0 1403 13 23                                           7       3              
662 [] Tenniskenttäalue Område med tennisbanor Tennis court area 700 2018-10-25T08:00:07.016431+03:00 4 654 {"fi": ["tenniskent\u00e4t", "ulkotenniskent\u00e4t"]} 0 1403 45 83                                           11       25     2        
468 [] Soitonopetus Instrumentundervisning Teaching music 632 2018-08-07T14:00:23.150860+03:00 3 368 {} 0 1403 1 2                                                   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        
1367 [] Opetuspaikat Verksamhetsställen Teaching locations 605*727 2020-11-18T07:30:12.891173+02:00 3 1365 {} 0 1087 2 3                                                         1        
1087 [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] Opetus ja koulutus Undervisning och utbildning Teaching and education   2018-08-07T14:00:25.275863+03:00 0   {} 0 1087 1214 1867       1                       2           274       362 2   11   1    
166 [] Verotoimistot Skattebyråer Tax offices 775 2018-08-07T14:00:30.318117+03:00 2 122 {} 0 1401 1 1                                                                  
627 [] Pöytätennistila Utrymme för bordtennis Table tennis venue 556 2018-08-07T14:00:23.745237+03:00 4 624 {} 0 1403 22 46                                           22       2              
448 [] Pingis Bordtennis Table tennis 515 2018-08-07T14:00:23.100999+03:00 3 368 {} 1 1403 1 17                                           12       4              
455 [] Pöytäjääkiekko Bordshockey Table hockey 555 2018-08-07T14:00:23.132016+03:00 3 368 {} 0 1403   4                                           3       1              
454 [] Pöytäfutis Bordfotboll Table football 554 2018-08-07T14:00:23.125546+03:00 3 368 {} 0 1403   11                                           10       1              
114 [] Uimavesien valvonta Övervakning av badvatten Swimming water supervision 732 2018-08-07T14:00:21.631376+03:00 3 103 {} 0 1400 1 4                                 1         1       1              
692 [] Uima-allas Simbassäng Swimming pool 728 2018-08-07T14:00:24.217361+03:00 4 690 {} 0 1403 21 28                                           6       1              
1365 [1366, 1368, 1367] Ruotsinkielinen työväenopisto Svenska arbetarinstitutet Swedish adult education centre 605 2020-11-18T07:30:12.874521+02:00 2 1360 {} 0 1087 6 9                                           1             2        
983 [] Yksityisen hoidon tuki Privatvårdsstöd Support for private care 811 2018-08-07T14:00:29.020270+03:00 2 868 {} 0 1405 111 118                                           7                      
2157 [] Tuki digipelaamisen ja netin liikakäytön ongelmiin Stöd för överanvändningsproblem av digitala spel och internet Support for digital gaming and internet over-use problems 855 2018-08-07T14:00:28.074000+03:00 2 830 {} 0 783 1 1                                                                  
2158 [] Tuki digipelaamisen ja netin liikakäytön ongelmiin Stöd för överanvändningsproblem av digitala spel och internet Support for digital gaming and internet over-use problems 855 2018-08-07T14:00:29.751405+03:00 2 1051 {} 0 986 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        
334 [335, 337, 338] Tarjolla oheislaitteita Kringutrustning finns Supplementary equipment available   2018-08-07T14:00:24.905778+03:00 4 333 {} 0 1402 54 56                                                   2              
2181 [] Suomenkielinen ammatillinen lisäkoulutus Påbyggnadsutbildning på finska Supplementary education in Finnsh 653*873 2018-08-31T16:00:09.195826+03:00 2 2179 {} 1 1087 14 16                                           2                      
1119 [] Lisäopetus (10. luokka) Påbyggnadsundervisning (10:de klass) Supplementary education (10th grade) 657 2018-10-25T08:00:07.670545+03:00 3 1098 {} 1 1087 5 7                                                   2              
1192 [] Lisäopetus (10. luokka) Påbyggnadsundervisning (10:de klass) Supplementary education (10th grade) 597 2018-10-25T08:00:08.215958+03:00 3 1187 {} 1 1087   1                                           1                      
69 [] Ohjattu leikkipuistotoiminta Ledd lekparksverksamhet Supervised playground activities 475 2019-03-05T14:30:06.276314+02:00 4 68 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 0 1400 69 80                                           8       3              
500 [] Ohjattu leikkipuistotoiminta Ledd lekparksverksamhet Supervised playground activities 475 2019-03-05T14:30:06.940551+02:00 4 499 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 0 1403 69 80                                           8       3              
981 [] Ohjattu leikkipuistotoiminta Ledd lekparksverksamhet Supervised playground activities 475 2019-03-05T14:30:09.677599+02:00 3 975 {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} 0 1405 69 80                                           8       3              
689 [] Uimaranta Badstrand Supervised beach 731 2018-08-07T14:00:24.196951+03:00 4 685 {} 0 1403 13 23                                           8       2              
405 [] Kesätoiminta Sommarverksamhet Summer activities 291 2018-08-07T14:00:22.992018+03:00 3 368 {} 0 1403 1 4       1                                   1       1              
11 [] Opiskelija-asunnot Studentbostäder Student housing 484 2018-08-07T14:00:21.287386+03:00 3 8 {} 0 1400   1                                           1                      
2166 [] Opiskeluterveydenhuolto Studenthälsovård Student health care 863 2018-08-07T14:00:29.213565+03:00 2 997 {} 0 986 81 154                                           2       68     3        
2167 [] Opiskeluterveydenhuolto Studenthälsovård Student health care 863 2018-08-07T14:00:27.627209+03:00 3 1373 {} 0 1087 81 154                                           2       68     3        
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        
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        
367 [] Katutaidepaikat Platser för gatukonst Street art locations 254 2018-08-07T14:00:22.877110+03:00 2 365 {} 0 1403 12 12                                                                  
727 [] Kauppa Butik Store 142*256 2018-08-07T14:00:24.462954+03:00 5 725 {} 0 1403 2 2                                                                  
159 [] Varastotilojen vuokraus Uthyrning av lagerlokaler Storage space rental 765 2018-08-07T14:00:30.247429+03:00 4 156 {} 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 {} 0 1400 3 4                                           1                      
342 [] Tilastot ja tietopalvelut Statistik och informationstjänst Statistics and information services 709 2018-10-25T08:00:07.381081+03:00 2 306 {} 0 1402 2 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
);