service_node
160 rows where unit_count_municipality_kauniainen = 1 sorted by related_services
This data as json, CSV (advanced)
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)
| 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 655 | [] | Beachvolleykenttä | Beachvolleyplan | Beach volleyball court | 125 | 2018-08-07T14:00:23.954884+03:00 | 4 | 654 | {} | [125] | 0 | 1403 | 39 | 85 | 27 | 18 | 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 | {} | [151] | 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 | {} | [151] | 0 | 1405 | 39 | 62 | 21 | 1 | 1 | ||||||||||||||||||||||||||||||
| 578 | [] | Frisbeegolf-rata | Frisbeegolfbana | Disc golf course | 169 | 2018-08-07T14:00:23.883764+03:00 | 4 | 646 | {} | [169] | 0 | 1403 | 8 | 27 | 10 | 8 | 1 | ||||||||||||||||||||||||||||||
| 1031 | [] | Fysioterapia | Fysioterapi | Physiotherapy | 172 | 2018-08-07T14:00:29.505159+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [172] | 0 | 986 | 11 | 21 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||
| 995 | [] | Hammashoito | Tandvård | Dental care | 184 | 2020-03-06T18:32:09.101816+02:00 | 1 | 986 | {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammass\u00e4rky", "hammashuolto", "hammashoitola"]} | [184] | 0 | 986 | 36 | 98 | 20 | 41 | 1 | ||||||||||||||||||||||||||||||
| 583 | [] | Latu | Skidspår | Ski track | 191 | 2018-08-07T14:00:23.433650+03:00 | 4 | 577 | {} | [191] | 0 | 1403 | 45 | 208 | 2 | 1 | 39 | 117 | 3 | 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 | {} | [201] | 0 | 1400 | 2 | 4 | 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 | {} | [201] | 0 | 1402 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 615 | [] | Jalkapallohalli | Fotbollshall | Football hall | 204 | 2018-08-07T14:00:23.650553+03:00 | 4 | 614 | {} | [204] | 0 | 1403 | 8 | 18 | 6 | 3 | 1 | ||||||||||||||||||||||||||||||
| 656 | [] | Jalkapallostadion | Fotbollsstadion | Football stadium | 205 | 2018-08-07T14:00:23.964244+03:00 | 4 | 654 | {} | [205] | 0 | 1403 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 1040 | [] | Jalkaterapia | Fotvård | Podiatry | 206 | 2018-08-07T14:00:29.581915+03:00 | 2 | 1028 | {} | [206] | 0 | 986 | 7 | 10 | 2 | 1 | |||||||||||||||||||||||||||||||
| 32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 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 | {} | [237] | 0 | 1400 | 5 | 9 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
| 77 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:21.469668+03:00 | 3 | 74 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
| 277 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:22.362599+03:00 | 3 | 270 | {} | [252] | 0 | 1400 | 1 | 18 | 2 | 14 | 1 | ||||||||||||||||||||||||||||||
| 537 | [] | Katujen ja viheralueiden suunnittelu ja rakennuttaminen | Planering och byggande av gator och grönområden | Design and development of streets and parks | 252 | 2018-08-07T14:00:25.163756+03:00 | 3 | 534 | {} | [252] | 0 | 1402 | 1 | 18 | 2 | 14 | 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 | {} | [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 | ||||||||||||||||||||||||||||||
| 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 | {} | [268] | 0 | 1400 | 9 | 12 | 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 | {} | [268] | 0 | 1401 | 9 | 12 | 2 | 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 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 1 | |||||||||||||||||||||||||||||||
| 2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 2004 | [] | Hallinnolliset toimipisteet | Administrativa ämbetsverk | Administrative offices | 271 | 2018-08-07T14:00:30.391457+03:00 | 4 | 173 | {} | [271] | 0 | 1401 | 55 | 65 | 1 | 1 | 7 | 1 | |||||||||||||||||||||||||||||
| 194 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.540753+03:00 | 3 | 191 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 760 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.790348+03:00 | 4 | 757 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 1 | 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 | {} | [274] | 0 | 1401 | 1 | 2 | 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 | {} | [274] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 815 | [] | Kehitysvammahuollon asumispalvelut | Boendetjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, residential services | 275 | 2018-08-07T14:00:27.912869+03:00 | 2 | 810 | {} | [275] | 0 | 783 | 39 | 71 | 9 | 21 | 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 | {} | [279] | 0 | 783 | 1 | 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 | {} | [280] | 0 | 783 | 3 | 9 | 5 | 1 | |||||||||||||||||||||||||||||||
| 978 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 288 | 2019-03-05T14:30:09.661194+02:00 | 3 | 975 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [288] | 0 | 1405 | 94 | 143 | 20 | 28 | 1 | ||||||||||||||||||||||||||||||
| 404 | [] | Kerhotoiminta | Klubbverksamhet | Club activities | 289 | 2018-08-07T14:00:22.983998+03:00 | 3 | 368 | {} | [289] | 0 | 1403 | 22 | 14 | 7 | 1 | |||||||||||||||||||||||||||||||
| 52 | [] | Kierrätyskeskus | Återvinningscentral | Recycling centre | 298 | 2018-08-07T14:00:21.919516+03:00 | 2 | 31 | {} | [298] | 0 | 1400 | 3 | 7 | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||
| 604 | [] | Kilpajäähalli | Tävlingsishall | Competition ice arena | 308 | 2018-08-07T14:00:23.575267+03:00 | 4 | 602 | {} | [308] | 0 | 1403 | 2 | 7 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||
| 350 | [] | Kirkot ja muut uskonnolliset tilat | Kyrkor och andra religiösa byggnader | Churches and other religious buildings | 314 | 2018-08-07T14:00:22.584521+03:00 | 2 | 343 | {} | [314] | 0 | 1403 | 63 | 86 | 3 | 19 | 1 | ||||||||||||||||||||||||||||||
| 354 | [] | Konserttitilat | Konsertutrymmen | Concert facilities | 329 | 2018-08-07T14:00:22.610197+03:00 | 3 | 352 | {} | [329] | 0 | 1403 | 33 | 43 | 8 | 1 | 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 | {} | [338] | 0 | 1087 | 119 | 136 | 12 | 4 | 1 | ||||||||||||||||||||||||||||||
| 581 | [] | Kuntorata | Konditionsbana | Jogging track | 348 | 2018-08-07T14:00:23.419850+03:00 | 4 | 577 | {} | [348] | 0 | 1403 | 45 | 82 | 22 | 14 | 1 | ||||||||||||||||||||||||||||||
| 1029 | [] | Apuvälinepalvelut | Hjälpmedelstjänster | Aid services | 352 | 2018-08-07T14:00:29.484194+03:00 | 2 | 1028 | {} | [352] | 0 | 986 | 5 | 10 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
| 418 | [] | Kuvataide | Bildkonst | Visual arts | 359 | 2018-08-07T14:00:23.020022+03:00 | 3 | 368 | {} | [359] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
| 1369 | [] | Kuvataidekoulu | Konstskola | School of visual arts | 360 | 2020-11-18T07:30:12.906446+02:00 | 2 | 1360 | {} | [360] | 0 | 1087 | 7 | 6 | 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 | {} | [372] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 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 | {} | [373] | 0 | 783 | 17 | 16 | 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 | {} | [378] | 0 | 986 | 3 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||
| 1005 | [] | Lastenneuvola | Barnrådgivning | Child health clinic | 379 | 2018-10-25T08:00:09.610190+03:00 | 2 | 1004 | {} | [379] | 0 | 986 | 22 | 47 | 14 | 10 | 1 | ||||||||||||||||||||||||||||||
| 788 | [] | Lastensuojelun sosiaalityö | Socialt arbete inom barnskyddet | Child welfare social work | 382 | 2018-08-07T14:00:27.731506+03:00 | 2 | 787 | {} | [382] | 0 | 783 | 25 | 42 | 9 | 7 | 1 | ||||||||||||||||||||||||||||||
| 227 | [] | Liikennesuunnittelu | Trafikplanering | Traffic planning | 395 | 2018-08-07T14:00:22.030360+03:00 | 4 | 226 | {} | [395] | 0 | 1400 | 1 | 3 | 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 | |||||||||||||||||||||||||||||||
| 616 | [] | Liikuntahalli | Idrottshall | Sports hall | 400 | 2018-08-07T14:00:23.657783+03:00 | 4 | 614 | {} | [400] | 0 | 1403 | 24 | 38 | 7 | 6 | 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 | {} | [404, 63] | 0 | 1402 | 5 | 11 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||
| 584 | [] | Luontopolku | Naturstig | Nature trail | 413 | 2018-08-07T14:00:23.440979+03:00 | 4 | 577 | {} | [413] | 0 | 1403 | 12 | 41 | 1 | 1 | 24 | 1 | 1 | 1 | |||||||||||||||||||||||||||
| 1034 | [] | Lääkinnällinen kuntoutus | Medicinsk rehabilitering | Medical rehabilitation | 416 | 2018-08-07T14:00:29.531662+03:00 | 2 | 1028 | {} | [416] | 0 | 986 | 1 | 5 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||
| 992 | [] | Lääkärin vastaanotto | Läkarmottagning | Doctor's reception | 417 | 2018-08-07T14:00:29.162295+03:00 | 1 | 986 | {"fi": ["mielenterveys", "terveysasemat"]} | [417] | 0 | 986 | 26 | 50 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 857 | [] | Maahanmuuttajapalvelut | Tjänster för invandrare | Services for immigrants | 420 | 2018-08-07T14:00:28.196278+03:00 | 2 | 845 | {} | [420] | 0 | 783 | 14 | 20 | 2 | 3 | 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"]} | [43] | 0 | 986 | 3 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||
| 1370 | [] | Musiikkiopisto | Musikinstitut | Music institute | 456 | 2020-11-18T07:30:12.915030+02:00 | 2 | 1360 | {} | [456] | 0 | 1087 | 20 | 19 | 1 | ||||||||||||||||||||||||||||||||
| 35 | [] | Akkujen keräys | Återvinning av bilbatterier | Car battery recycling | 45 | 2018-08-07T14:00:21.789985+03:00 | 3 | 34 | {"fi": ["akut"]} | [45] | 0 | 1400 | 34 | 79 | 18 | 26 | 1 | ||||||||||||||||||||||||||||||
| 1004 | [1005, 1006, 1008] | Neuvolat | Rådgivningar | Maternity and child health guidance | 463 | 2018-08-07T14:00:29.268764+03:00 | 1 | 986 | {} | [463] | 0 | 986 | 23 | 53 | 19 | 10 | 1 | ||||||||||||||||||||||||||||||
| 366 | [] | Nuorisotalot | Ungdomsgårdar | Youth centres | 468 | 2018-08-07T14:00:22.869007+03:00 | 2 | 365 | {} | [468] | 0 | 1403 | 39 | 69 | 16 | 13 | 1 | ||||||||||||||||||||||||||||||
| 847 | [] | Alueellinen kumppanuustyö | Områdesvist partnerskapsarbete | Regional partnership work | 49 | 2018-08-07T14:00:28.124411+03:00 | 2 | 845 | {} | [49] | 0 | 783 | 19 | 119 | 1 | 1 | 96 | 1 | 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 | {} | [504] | 0 | 783 | 10 | 20 | 4 | 5 | 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 | {} | [507] | 0 | 986 | 5 | 4 | 1 | ||||||||||||||||||||||||||||||||
| 1041 | [] | Psykologitoiminta | Psykologverksamhet | Psychologists | 525 | 2018-08-07T14:00:29.598972+03:00 | 1 | 986 | {} | [525] | 0 | 986 | 4 | 10 | 1 | 4 | 1 | ||||||||||||||||||||||||||||||
| 1036 | [] | Puheterapia | Talterapi | Speech therapy | 527 | 2018-08-07T14:00:29.552393+03:00 | 2 | 1028 | {"fi": ["kuntoutus"]} | [527] | 0 | 986 | 2 | 13 | 5 | 5 | 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 | {} | [548] | 0 | 783 | 7 | 6 | 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 | {} | [548] | 0 | 986 | 7 | 6 | 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 | {} | [549] | 0 | 783 | 1 | 4 | 1 | 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 | {} | [549] | 0 | 986 | 1 | 4 | 1 | 1 | 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 | {} | [558] | 0 | 1400 | 1 | 5 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
| 1037 | [] | Rintamavetaraanien kuntoutus | Rehabilitering av frontveteraner | Front-line veteran rehabilitation | 583 | 2018-08-07T14:00:29.562795+03:00 | 2 | 1028 | {} | [583] | 0 | 986 | 1 | 6 | 4 | 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 | {} | [603, 200] | 0 | 1405 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 1366 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 605*66 | 2020-11-18T07:30:12.883321+02:00 | 3 | 1365 | {} | [605, 66] | 0 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 308 | [] | Asemakaava-arkisto | Detaljplanearkiv | Town plan archive | 60 | 2018-08-07T14:00:24.662512+03:00 | 3 | 307 | {} | [60] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 48 | [] | Sekajäte | Blandat avfall | Mixed waste | 617 | 2018-08-07T14:00:21.889545+03:00 | 3 | 34 | {} | [617] | 0 | 1400 | 2 | 6 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||
| 610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
| 652 | [] | Skeitti / rullaluistelupaikka | Plats för skejtning/rullskridskoåkning | Skateboarding/roller-blading rink | 630 | 2018-08-07T14:00:23.929996+03:00 | 4 | 646 | {} | [630] | 0 | 1403 | 27 | 51 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
| 1074 | [] | Sopimuspalokunnat | Avtalsbrandkårer | Volunteer fire departments | 633 | 2018-08-07T14:00:29.872976+03:00 | 2 | 1070 | {} | [633] | 0 | 1061 | 15 | 23 | 7 | 1 | |||||||||||||||||||||||||||||||
| 852 | [] | Muun sosiaalihuollon asumispalvelut | Boendetjänster inom övrig socialvård | Residential services for other social welfare | 637 | 2018-08-07T14:00:28.163665+03:00 | 2 | 845 | {} | [637] | 0 | 783 | 11 | 26 | 1 | 1 | 12 | 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 | {} | [638] | 0 | 783 | 4 | 12 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
| 859 | [] | Yhteiset tukipalvelut | Gemensamma stödtjänster | Shared support services | 639 | 2018-08-07T14:00:28.209104+03:00 | 1 | 783 | {} | [639] | 0 | 783 | 3 | 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 | {} | [640] | 0 | 783 | 3 | 6 | 2 | 1 | |||||||||||||||||||||||||||||||
| 223 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 64 | 2018-08-07T14:00:22.006084+03:00 | 3 | 222 | {} | [64] | 0 | 1400 | 3 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||
| 1356 | [1357] | Ammattikorkeakoulut | Yrkeshögskolor | Polytechnics | 654 | 2018-08-07T14:00:27.483584+03:00 | 1 | 1087 | {} | [654] | 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 | {} | [654] | 0 | 1087 | 1 | 2 | 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 | {} | [663, 200] | 0 | 1405 | 6 | 14 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||
| 963 | [] | Suomenkielinen ryhmäperhepäivähoito | Gruppfamiljedagvård på finska | Group family day care in Finnish | 664 | 2018-10-25T08:00:09.441773+03:00 | 4 | 2145 | {"fi": ["suomi"]} | [664] | 0 | 1405 | 50 | 107 | 47 | 9 | 1 | ||||||||||||||||||||||||||||||
| 1362 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 665*66 | 2020-11-18T07:30:12.851359+02:00 | 3 | 1361 | {} | [665, 66] | 0 | 1087 | 7 | 9 | 1 | 1 | |||||||||||||||||||||||||||||||
| 993 | [] | Terveydenhoitajan vastaanotto | Hälsovårdarens mottagning | Nurse's reception | 702 | 2018-08-07T14:00:29.169309+03:00 | 1 | 986 | {} | [702] | 0 | 986 | 26 | 50 | 11 | 12 | 1 | ||||||||||||||||||||||||||||||
| 991 | [] | Terveysasemat | Hälsostationer | Health stations | 703 | 2018-08-07T14:00:29.153043+03:00 | 1 | 986 | {"fi": ["mielenterveys", "terveysasemat"]} | [703] | 0 | 986 | 25 | 49 | 12 | 11 | 1 | ||||||||||||||||||||||||||||||
| 219 | [220] | Tuet ja avustukset | Understöd och bidrag | Grants and benefits | 715 | 2018-08-07T14:00:30.723645+03:00 | 2 | 171 | {} | [715] | 0 | 1401 | 3 | 2 | 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 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 693 | [] | Uimahalli | Simhall | Public indoor swimming pool | 729 | 2018-08-07T14:00:24.224255+03:00 | 4 | 690 | {} | [729] | 0 | 1403 | 14 | 25 | 5 | 5 | 1 | ||||||||||||||||||||||||||||||
| 2005 | [] | Valtuustotalot | Fullmäktigehus | Council buildings | 744 | 2018-08-07T14:00:30.401425+03:00 | 4 | 173 | {} | [744] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
| 809 | [] | Vammaistuet ja -palvelut | Handikappbidrag och -tjänster | Disability benefits and services | 755 | 2018-08-07T14:00:27.876348+03:00 | 2 | 798 | {} | [755] | 0 | 783 | 3 | 15 | 1 | 2 | 7 | 1 | 1 | ||||||||||||||||||||||||||||
| 827 | [] | Vanhuspalvelun omaishoidon tuki | Stöd för närståendevårdare inom äldreomsorgen | Care for the elderly, close relative care support | 759 | 2018-08-07T14:00:27.996868+03:00 | 2 | 819 | {} | [759] | 0 | 783 | 4 | 8 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
| 823 | [] | Vanhusten palvelukeskustoiminta | Servicecentralverksamhet för äldre | Service centre activities for the elderly | 761 | 2018-08-07T14:00:27.970552+03:00 | 2 | 819 | {} | [761] | 0 | 783 | 14 | 15 | 1 | ||||||||||||||||||||||||||||||||
| 822 | [] | Vanhusten päivätoiminta | Dagverksamhet för äldre | Service for the elderly, daytime activities | 762 | 2018-08-07T14:00:27.964013+03:00 | 2 | 819 | {} | [762] | 0 | 783 | 17 | 30 | 9 | 3 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );