service_node

383 rows where level = 3 sorted by name_en descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen, unit_count_municipality_järvenpää

level ✖

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ää
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 {} [274] 0 1401 1 2                                                         1        
1299 [] Ruotsinkielinen lukiokoulutus gymnasieutbildning på svenska general upper secondary education in Swedish 598 2018-08-07T14:00:27.081551+03:00 3 1298 {} [598] 1 1087 4 6                                           1       1              
1259 [] Suomenkielinen lukiokoulutus gymnasieutbildning på finska general upper secondary education in Finnish 658 2018-10-25T08:00:08.498186+03:00 3 1258 {"fi": ["suomi"]} [658] 1 1087 30 52                                           14       8              
1260 [] Englanninkielinen lukiokoulutus gymnasieutbildning på engelska general upper secondary education in English 148 2018-10-25T08:00:08.503752+03:00 3 1258 {"fi": ["englanti"]} [148] 1 1087 3 5                                           1       1              
232 [] Energia-avustukset energiunderstöd energy grants 144 2018-08-07T14:00:22.065643+03:00 3 231 {} [144] 0 1400   1                                           1                      
719 [721, 723, 724, 725, 730] Eläintarhat Djurparker Zoos   2018-08-07T14:00:24.415879+03:00 3 718 {} [] 0 1403 13 14                     1                                            
510 [] Nuorisotilat Ungdomsgårdar Youth facilities 803 2018-08-07T14:00:22.836894+03:00 3 505 {} [803] 0 1403   17                                           16             1        
389 [] Fillari- ja moottoripaja Cykel- och motorverkstad Workshop for bicycles and mopeds 168 2018-08-07T14:00:22.937466+03:00 3 368 {} [168] 0 1403 4 5                                           1                      
452 [] Puutyö Slöjd Woodwork 534 2018-08-07T14:00:23.113213+03:00 3 368 {} [534] 0 1403 2 3                                           1                      
47 [] Puujäte Träavfall Wood waste 531 2018-08-07T14:00:21.882472+03:00 3 34 {} [531] 0 1400 2 5                                           2       1              
330 [331, 332] Langaton internet, wlan Trådlöst internet, wlan Wireless internet, wlan   2018-10-25T08:00:07.331877+03:00 3 329 {} [] 0 1402 233 240                                                   7              
2168 [] Hyvän olon palvelut Välbefinnandetjänster Well-being services 864 2018-08-07T14:00:24.617742+03:00 3 718 {} [864] 0 1403 34 37                                           1       2              
485 [] Viikonlopputoiminta Veckoslutsverksamhet Weekend activities 789 2018-08-07T14:00:23.188643+03:00 3 368 {} [789] 0 1403 2 2                                                                  
293 [295, 296, 299, 301] Vesihuolto Vattenförsörjning Water services   2018-08-07T14:00:22.465138+03:00 3 270 {} [] 0 1400 30 32                             1             1                      
61 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:21.361137+03:00 3 60 {} [238] 0 1400 49 49                                                                  
492 [] Kahluualtaat Plaskdammer Wading pools 238 2018-08-07T14:00:22.690959+03:00 3 491 {} [238] 0 1403 49 49                                                                  
418 [] Kuvataide Bildkonst Visual arts 359 2018-08-07T14:00:23.020022+03:00 3 368 {} [359] 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 {} [140] 0 1400 1 4                                 1         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              
1337 [] Aikuisten lukiokoulutus Gymnasieutbildning för vuxna Upper secondary school education for adults 650 2018-08-07T14:00:27.357192+03:00 3 1336 {} [650] 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 {} [590] 1 1087 1 1                                                                  
1342 [] Kaksoistutkinto Dubbel gymnasieexamen Upper secondary school dual qualification 408 2018-08-07T14:00:27.393475+03:00 3 1336 {} [408] 1 1087 1 1                                                                  
2194 [] Yliopistojen kirjastot Universitetsbibliotek University libraries 879 2019-03-20T13:30:07.460582+02:00 3 324 {} [879] 0 1403 10 11                                           1                      
2197 [] Yliopistojen kirjastot Universitetsbibliotek University libraries 879 2019-04-02T13:30:07.786077+03:00 3 345 {} [879] 0 1403 10 11                                           1                      
775 [] Edunvalvonta Intressebevakning Trusteeship 131 2018-08-07T14:00:30.904881+03:00 3 769 {} [131] 0 1401 1 3                                           2                      
458 [] Retkeily Camping Trekking 580 2018-08-07T14:00:23.138224+03:00 3 368 {} [580] 0 1403 2 7                                           5                      
226 [227, 228] Liikennesuunnittelu Trafikplanering Traffic planning   2018-08-07T14:00:22.025116+03:00 3 222 {} [] 0 1400 1 5                                           2       1     1        
522 [] Liikennesuunnittelu Trafikplanering Traffic planning 395 2018-08-07T14:00:25.064660+03:00 3 521 {} [395] 0 1402 1 3                                           1             1        
523 [] Liikenteen ohjaus, liikennevalot Trafikstyrning, trafikljus Traffic control, traffic lights 396+397 2018-10-24T23:30:06.706293+03:00 3 521 {} [397, 396] 0 1402   2                                           1       1              
225 [] Kaavat ja kaavoitus Planer och planlägging Town plans and zoning 237 2018-08-07T14:00:22.018653+03:00 3 222 {} [237] 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 {} [60] 0 1402   1                                                         1        
527 [] Ajoneuvojen siirrot Flyttning av fordon Towing vehicles 44 2018-08-07T14:00:25.100072+03:00 3 526 {} [44] 0 1402 2 5                                           1       2              
144 [] Matkailumarkkinointi Marknadsföring av turism Tourism marketing 428 2018-08-07T14:00:30.145003+03:00 3 141 {} [428] 0 1401 2 4                                                   2              
316 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.717090+03:00 3 314 {} [429] 0 1402 2 12                                           6       4              
744 [] Matkailuneuvonta Turistinformation Tourism information 429 2018-08-07T14:00:24.548312+03:00 3 718 {} [429] 0 1403 2 12                                           6       4              
2153 [] Kosketusnäyttöopasteet Infokiosker med pekskärm Touch screen guideposts 851 2018-08-07T14:00:24.869369+03:00 3 329 {} [851] 0 1403 21 21                                                                  
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              
518 [] Matkalippujen tarkastus Biljettkontroll Ticket inspection 431 2018-08-07T14:00:25.036866+03:00 3 513 {} [431] 0 1402 1 1                                                                  
360 [] Teatterit Teatrar Theatres 694 2018-08-07T14:00:22.651704+03:00 3 352 {} [694] 0 1403 50 62                                           10       2              
752 [] Teatterit Teatrar Theatres 694 2018-08-07T14:00:24.603285+03:00 3 718 {} [694] 0 1403 50 62                                           10       2              
2154 [] Teatteri Teater Theatre 852 2018-08-07T14:00:23.169545+03:00 3 368 {} [852] 0 1403 1 2                                           1                      
50 [] Tekstiilien keräys Textilåtervinning Textile recycling 696 2018-08-07T14:00:21.906229+03:00 3 34 {} [696] 0 1400 40 108                                           37       29     2        
468 [] Soitonopetus Instrumentundervisning Teaching music 632 2018-08-07T14:00:23.150860+03:00 3 368 {} [632] 0 1403 1 2                                                   1              
1363 [] Opetuspaikat Verksamhetsställen Teaching locations 665*727 2020-11-18T07:30:12.858775+02:00 3 1361 {} [727, 665] 0 1087 44 46                                           1             1        
1367 [] Opetuspaikat Verksamhetsställen Teaching locations 605*727 2020-11-18T07:30:12.891173+02:00 3 1365 {} [727, 605] 0 1087 2 3                                                         1        
448 [] Pingis Bordtennis Table tennis 515 2018-08-07T14:00:23.100999+03:00 3 368 {} [515] 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 {} [555] 0 1403   4                                           3       1              
454 [] Pöytäfutis Bordfotboll Table football 554 2018-08-07T14:00:23.125546+03:00 3 368 {} [554] 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 {} [732] 0 1400 1 4                                 1         1       1              
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 {} [657] 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 {} [597] 1 1087   1                                           1                      
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"]} [475] 0 1405 69 80                                           8       3              
405 [] Kesätoiminta Sommarverksamhet Summer activities 291 2018-08-07T14:00:22.992018+03:00 3 368 {} [291] 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 {} [484] 0 1400   1                                           1                      
2167 [] Opiskeluterveydenhuolto Studenthälsovård Student health care 863 2018-08-07T14:00:27.627209+03:00 3 1373 {} [863] 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 {} [253] 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 {} [253] 0 1402 1 6                                           1       3     1        
183 [] Henkilöstöravintolat Personalrestaurang Staff restaurants 221 2018-08-07T14:00:30.479735+03:00 3 180 {} [221] 0 1401 23 26                                           2       1              
614 [615, 616, 617, 618, 619, 620, 621, 622, 623] Liikuntahallit Idrottshallar Sports halls   2018-08-07T14:00:23.644666+03:00 3 601 {} [] 0 1403 149 233                                           60       22     2        
577 [579, 580, 581, 582, 583, 584, 585, 586, 590] Liikunta- ja ulkoilureitit Idrotts- och friluftsleder Sports and outdoor recreation routes   2018-08-07T14:00:23.400833+03:00 3 558 {} [] 0 1403 132 401       3                 1       1         105       147   9 3        
429 [] Liikunta Idrott Sports 399 2018-08-07T14:00:23.053156+03:00 3 368 {} [399] 0 1403   10                                           9       1              
675 [676] Urheiluilmailualueet Områden för flygsport Sport aviation areas   2018-08-07T14:00:24.102541+03:00 3 666 {} [] 0 1403 1 1                                                                  
1296 [] Painotettu lukio Gymnasium med betoning Specialised upper secondary school 148*493+161*493+300*493+383*493+566*493+611*493+658*493+770*493+792*493 2018-10-25T08:00:08.739223+03:00 3 1258 {} [792, 770, 658, 611, 566, 493, 383, 300, 161, 148] 1 1087 12 17                                                   5              
1328 [] Painotettu lukio Gymnasium med betoning Specialised upper secondary school 598*493 2018-08-07T14:00:27.295727+03:00 3 1298 {} [598, 493] 1 1087 2 2                                                                  
325 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:24.829787+03:00 3 324 {"fi": ["kirjastot"]} [155] 0 1402 27 29                                           2                      
346 [] Erikoiskirjastot Specialbibliotek Special libraries 155 2018-08-07T14:00:22.558572+03:00 3 345 {"fi": ["kirjastot"]} [155] 0 1403 27 29                                           2                      
1173 [] Erityisluokkaopetus Undervisning i specialklass Special class education 660 2018-08-07T14:00:26.138862+03:00 3 1098 {} [660] 1 1087 4 10                               1           5                      
1246 [] Erityisluokkaopetus Undervisning i specialklass Special class education 600 2018-08-07T14:00:26.688791+03:00 3 1187 {} [600] 1 1087 2 3                                           1                      
41 [] Metallinkeräys Metallavfall Small metal waste 436 2018-08-07T14:00:21.839149+03:00 3 34 {} [436] 0 1400 50 137                                           46       37     4        
46 [] Paristonkeräys Återvinning av små batterier Small battery recycling 497 2018-08-07T14:00:21.875976+03:00 3 34 {"fi": ["paristot"]} [497] 0 1400 16 46                                           12       18              
575 [576] Laskettelurinteet ja rinnehiihtokeskukset Slalombackar och alpina skidcentra Ski slopes and downhill ski resorts   2018-08-07T14:00:23.388106+03:00 3 558 {} [] 0 1403 2 6                                           2             2        
564 [565] Hyppyrimäet Hoppbackar Ski jumping hills   2018-08-07T14:00:23.318569+03:00 3 558 {} [] 0 1403 1 1                                                                  
467 [] Skeittaus Skateboardåkning Skateboarding 629 2018-08-07T14:00:23.144513+03:00 3 368 {} [629] 0 1403 1 2                                                   1              
749 [] Nähtävyydet Sevärdheter Sights 473 2018-08-07T14:00:24.582404+03:00 3 718 {} [473] 0 1403 234 244                                   1       4       5              
739 [] Kaupat ja myymälät Butiker och affärer Shops and outlets 256 2018-08-07T14:00:24.513136+03:00 3 718 {} [256] 0 1403 2 3                                           1                      
750 [] Ostospaikat Shoppingplatser Shopping 490 2018-08-07T14:00:24.589090+03:00 3 718 {} [490] 0 1403 465 477                                           5       7              
559 [560, 561, 562, 563] Ampumaurheilupaikat Sportskytteplatser Shooting sports facilities   2018-08-07T14:00:23.287538+03:00 3 558 {} [] 0 1403 6 10       1                                   3                      
189 [] Maahanmuuttajapalvelut Tjänster för invandrare Services for immigrants 420 2018-08-07T14:00:30.517534+03:00 3 187 {} [420] 0 1401 14 20                                           2       3     1        
319 [] Asiointipisteet, yleisneuvonta ja yhteispalvelu Servicepunkter, allmän rådgivning och samservicekontor Service points, General information and Citizen's offices 809 2019-04-11T16:30:09.599681+03:00 3 314 {"fi": ["palvelupiste"]} [809] 0 1402 2 11                                           6       3              
2224 [] Seniorisäpinät Seniorisäpinät Seniorisäpinät 903 2020-06-09T15:30:11.400501+03:00 3 2217 {} [903] 0 1403 2 2                                                                  
2220 [] Seniorikävely Seniorgående Senior walk 901 2020-06-09T15:30:11.341704+03:00 3 2217 {} [901] 0 1403 6 7                                                         1        
2221 [] Senioriliikunta Seniormotion Senior sports 895 2020-06-09T15:30:11.355674+03:00 3 2217 {} [895] 0 1403 86 102                     1                     4       10     1        
2219 [] Seniorikuntosalit Seniorgym Senior gyms 896 2020-06-09T15:30:11.328409+03:00 3 2217 {} [896] 0 1403 22 22                                                                  
2218 [] Seniorijumppa Seniorgympa Senior gym 898 2020-06-09T15:30:11.309679+03:00 3 2217 {} [898] 0 1403 41 44                                           2       1              
2225 [] Senioritanssi Seniordans Senior dancing 900 2020-06-09T15:30:11.415952+03:00 3 2217 {} [900] 0 1403 24 29                                           2       2     1        
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              
139 [] Maa-alueiden vuokraus ja myynti Uthyrning och försäljning av markområden Selling or renting land areas 419 2018-08-07T14:00:30.113920+03:00 3 134 {} [419] 0 1401   17                                                   17              
2165 [] Kouluterveydenhuolto Skolhälsovård School health care 339 2018-08-07T14:00:27.619794+03:00 3 1373 {} [339] 0 1087 160 236                               1           1       68 1   5        
245 [249, 248, 247, 250, 251] Maan, tonttien ja asuntojen vuokraus ja myynti Försäljning och uthyrning av mark, tomter, lokaler och bostäder Sales and rental of land, lots, facilities and apartments   2018-08-07T14:00:22.143596+03:00 3 231 {} [] 0 1400 10 32                                           4       17     1        
2001 [] Turvallisuus- ja valmiussuunnittelu Säkerhets- och beredskapsplanering Safety and preparedness planning 226 2018-08-07T14:00:30.429227+03:00 3 172 {} [226] 0 1401 1 1                                                                  
751 [] Ravintolat Restauranger Restaurants 577 2018-08-07T14:00:24.595794+03:00 3 718 {} [577] 0 1403 663 699                             1   1         22       12              
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                                                                  
2208 [] Asukastilat Invånarlokaler Resident facilities 888 2019-10-22T09:30:07.500577+03:00 3 505 {} [888] 0 1403 1 12                                           2       9              
511 [] Tilaussaunat Beställningsbastur Reservation-only sauna 804 2018-08-07T14:00:22.844464+03:00 3 505 {} [804] 0 1403 1 2                                           1                      
149 [2209, 150, 152, 151, 154, 155] Vapaa-ajan tilojen vuokraus Uthyrning av fritidslokaler Renting recreational spaces   2018-08-07T14:00:30.179684+03:00 3 146 {} [] 0 1401 292 375       1 1         1   1     2     2       40       31     4        
255 [256, 257, 258, 265] Tilojen vuokraus ja varaus Uthyrning och reservering av lokaler Renting out and reservation of facilities   2018-08-07T14:00:22.202500+03:00 3 231 {} [] 0 1400 294 380       1 1         1   1     2     2       42       32     4        
243 [] Korjausavustukset ja -lainat Reparationsunderstöd och -lån Renovation grants and loans 332 2018-08-07T14:00:22.130199+03:00 3 231 {} [332] 0 1400   2                                           1       1              
278 [] Korjausrakentaminen Renovering Renovation construction 333 2018-08-07T14:00:22.369873+03:00 3 270 {} [333] 0 1400 1 2                                           1                      
244 [] Lainhuuto Lagfart Registration of title to property 367 2018-08-07T14:00:22.136957+03:00 3 231 {} [367] 0 1400 1 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
);