service_node
360 rows where level = 4 sorted by unit_count_municipality_helsinki descending
This data as json, CSV (advanced)
Suggested facets: children, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_kirkkonummi, unit_count_municipality_vihti, unit_count_municipality_kauniainen
last_modified_time (date) ✖
- 2018-08-07 271
- 2018-10-25 61
- 2018-10-24 8
- 2020-06-22 8
- 2019-03-05 4
- 2020-10-02 3
- 2019-05-08 2
- 2019-10-22 1
- 2020-12-02 1
- 2020-12-15 1
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
871 | [] | päivähoito | dagvård | day care | 663 | 2019-03-05T14:30:09.346786+02:00 | 4 | 870 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [663] | 0 | 1405 | 389 | 845 | 277 | 173 | 6 | ||||||||||||||||||||||||||||||
612 | [] | Liikuntasali | Idrottssal | Gymnastics hall | 402 | 2018-08-07T14:00:23.630490+03:00 | 4 | 608 | {} | [402] | 0 | 1403 | 308 | 512 | 97 | 102 | 5 | ||||||||||||||||||||||||||||||
258 | [2210, 259, 261, 260, 263, 264] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.220951+03:00 | 4 | 255 | {} | [] | 0 | 1400 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
879 | [] | esiopetus | förskoleundervisning | pre-primary education | 663*160+861*160 | 2018-10-24T23:30:08.464088+03:00 | 4 | 870 | {} | [861, 663, 160] | 1 | 1405 | 266 | 448 | 66 | 116 | |||||||||||||||||||||||||||||||
151 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:30.193967+03:00 | 4 | 149 | {} | [326] | 0 | 1401 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
70 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:21.425954+03:00 | 4 | 68 | {} | [389] | 0 | 1400 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
501 | [] | Leikkipaikat (ei ohjattua toimintaa) | Lekplatser (ingen handledd verksamhet) | Play areas (no supervised activities) | 389 | 2018-08-07T14:00:22.761746+03:00 | 4 | 499 | {} | [389] | 0 | 1403 | 224 | 567 | 193 | 145 | 5 | ||||||||||||||||||||||||||||||
331 | [] | WLAN-sisäpisteet | WLAN-inomhusstationer | WLAN inlets | 806 | 2018-08-07T14:00:24.883321+03:00 | 4 | 330 | {} | [806] | 0 | 1402 | 223 | 230 | 7 | ||||||||||||||||||||||||||||||||
152 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:30.200626+03:00 | 4 | 149 | {} | [214] | 0 | 1401 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
653 | [] | Ulkokuntoiluvälineet | Konditionspark för utomhusaktiviteter | Fitness training park | 737 | 2018-08-07T14:00:23.939410+03:00 | 4 | 646 | {} | [737] | 0 | 1403 | 168 | 320 | 100 | 43 | 3 | 6 | |||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 2 | ||||||||||||||||||||||||||||||
611 | [] | Kuntosali | Gym | Gym | 350 | 2018-08-07T14:00:23.623495+03:00 | 4 | 608 | {} | [350] | 0 | 1403 | 151 | 237 | 45 | 39 | 2 | ||||||||||||||||||||||||||||||
546 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.230897+03:00 | 4 | 542 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
705 | [] | Venesatama | Serviceplats för båtfarare | Boating services | 769 | 2018-08-07T14:00:24.310541+03:00 | 4 | 695 | {} | [769] | 0 | 1403 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
2142 | [] | Venesatamat | Båthamnar | Marinas | 769 | 2018-08-07T14:00:25.242377+03:00 | 4 | 547 | {} | [769] | 0 | 1402 | 147 | 188 | 2 | 1 | 1 | 36 | 1 | ||||||||||||||||||||||||||||
642 | [] | Luistelukenttä | Skridskobana | Ice-skating field | 406 | 2018-08-07T14:00:23.848959+03:00 | 4 | 639 | {} | [406] | 0 | 1403 | 136 | 308 | 100 | 70 | 2 | ||||||||||||||||||||||||||||||
648 | [] | Lähiliikuntapaikka | Näridrottsplats | Neighbourhood sports area | 415 | 2018-08-07T14:00:23.898085+03:00 | 4 | 646 | {} | [415] | 0 | 1403 | 134 | 229 | 1 | 64 | 26 | 4 | |||||||||||||||||||||||||||||
1123 | [] | A1-englanti | A1-engelska | A1-English | 149*15+150*15+162*15+163*15+301*15+302*15+384*15+385*15+567*15+568*15+612*15+613*15+661*15+662*15+771*15+772*15+793*15+794*15+865*15+866*15 | 2018-10-25T08:00:07.696168+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 15] | 1 | 1087 | 108 | 211 | 1 | 73 | 28 | 1 | |||||||||||||||||||||||||||||
1146 | [] | B1-ruotsi | B1-svenska | B1-Swedish | 149*108+150*108+162*108+163*108+301*108+302*108+384*108+385*108+567*108+568*108+612*108+613*108+661*108+662*108+771*108+772*108+793*108+794*108+865*108+866*108 | 2018-10-25T08:00:07.912218+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 108] | 1 | 1087 | 107 | 205 | 1 | 72 | 24 | 1 | |||||||||||||||||||||||||||||
1183 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 656*229 | 2018-08-07T14:00:26.230412+03:00 | 4 | 1181 | {} | [656, 229] | 1 | 1087 | 105 | 105 | |||||||||||||||||||||||||||||||||
1100 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 661 | 2018-10-25T08:00:07.595003+03:00 | 4 | 1099 | {} | [661] | 1 | 1087 | 104 | 205 | 62 | 38 | 1 | ||||||||||||||||||||||||||||||
617 | [] | Monitoimihalli / areena | Allaktivitetshall/multiarena | Multipurpose hall/arena | 444 | 2018-08-07T14:00:23.665496+03:00 | 4 | 614 | {} | [444] | 0 | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
63 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.380622+03:00 | 4 | 62 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1400 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
494 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:22.710417+03:00 | 4 | 493 | {"fi": ["koirapuistot", "koira-aitaus", "koira-aitaukset", "koirat"], "sv": ["hundparker", "hundinh\u00e4gnader", "hundrastg\u00e5rdar", "hundar"], "en": ["dog parks", "dogs"]} | [317] | 0 | 1403 | 94 | 140 | 22 | 24 | |||||||||||||||||||||||||||||||
1135 | [] | A2-englanti | A2-engelska | A2-English | 149*27+150*27+162*27+163*27+301*27+302*27+384*27+385*27+567*27+568*27+612*27+613*27+661*27+662*27+771*27+772*27+793*27+794*27+865*27+866*27 | 2018-10-25T08:00:07.813754+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 27] | 1 | 1087 | 81 | 100 | 19 | ||||||||||||||||||||||||||||||||
882 | [] | päivähoito | dagvård | day care | 603 | 2019-03-05T14:30:09.386238+02:00 | 4 | 881 | {"fi": ["varhaiskasvatus"], "en": ["early education and care"], "sv": ["sm\u00e5barnspedagogik"]} | [603] | 0 | 1405 | 77 | 128 | 33 | 10 | 8 | ||||||||||||||||||||||||||||||
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"]} | [475] | 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"]} | [475] | 0 | 1403 | 69 | 80 | 8 | 3 | |||||||||||||||||||||||||||||||
1110 | [] | suomenkielinen opetus | undervisning på finska | education in Finnish | 662 | 2018-10-25T08:00:07.635959+03:00 | 4 | 1109 | {} | [662] | 1 | 1087 | 63 | 114 | 1 | 27 | 22 | 1 | |||||||||||||||||||||||||||||
1141 | [] | A2-ranska | A2-franska | A2-French | 149*33+150*33+162*33+163*33+301*33+302*33+384*33+385*33+567*33+568*33+612*33+613*33+661*33+662*33+771*33+772*33+793*33+794*33+865*33+866*33 | 2018-10-25T08:00:07.868542+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 33] | 1 | 1087 | 63 | 101 | 22 | 16 | |||||||||||||||||||||||||||||||
747 | [] | Taidemuseo | Konstmuseer | Art museums | 672 | 2018-08-07T14:00:24.568656+03:00 | 4 | 745 | {} | [672] | 0 | 1403 | 61 | 88 | 1 | 4 | 1 | 10 | 6 | 1 | 4 | ||||||||||||||||||||||||||
339 | [340, 341] | Tarjolla opastusta | Handledning ges | Guidance available | 2018-10-25T08:00:07.363024+03:00 | 4 | 333 | {} | [] | 0 | 1402 | 60 | 64 | 1 | 3 | ||||||||||||||||||||||||||||||||
630 | [] | Tanssitila | Utrymme för dans | Dance studio | 687 | 2018-08-07T14:00:23.767727+03:00 | 4 | 624 | {} | [687] | 0 | 1403 | 58 | 71 | 10 | 3 | |||||||||||||||||||||||||||||||
1142 | [] | A2-saksa | A2-tyska | A2-German | 149*35+150*35+162*35+163*35+301*35+302*35+384*35+385*35+567*35+568*35+612*35+613*35+661*35+662*35+771*35+772*35+793*35+794*35+865*35+866*35 | 2018-10-25T08:00:07.877676+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 35] | 1 | 1087 | 58 | 124 | 50 | 16 | |||||||||||||||||||||||||||||||
1134 | [] | A2-ruotsi | A2-svenska | A2-Swedish | 149*34+150*34+162*34+163*34+301*34+302*34+384*34+385*34+567*34+568*34+612*34+613*34+661*34+662*34+771*34+772*34+793*34+794*34+865*34+866*34 | 2018-10-25T08:00:07.804809+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 34] | 1 | 1087 | 57 | 117 | 39 | 21 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
548 | [] | Ulkoilusaaret | Friluftsöar | Recreational islands | 735 | 2018-10-25T08:00:07.487309+03:00 | 4 | 547 | {} | [735] | 0 | 1402 | 54 | 69 | 1 | 2 | 1 | 1 | 1 | 9 | |||||||||||||||||||||||||||
2134 | [] | Leikkipuiston järjestämät ryhmät | Lekparkernas grupper | Groups organised by playgrounds | 341 | 2018-08-07T14:00:26.223904+03:00 | 4 | 1181 | {} | [341] | 1 | 1087 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
699 | [] | Opastuspiste | Information punkt | Information point | 482 | 2018-08-07T14:00:24.267790+03:00 | 4 | 695 | {} | [482] | 0 | 1403 | 51 | 73 | 1 | 2 | 2 | 14 | 2 | 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 | ||||||||||||||||||||||||||||||
875 | [] | erityisryhmä | specialgrupp | special group | 663*156 | 2018-08-07T14:00:28.291078+03:00 | 4 | 870 | {} | [663, 156] | 0 | 1405 | 49 | 77 | 28 | ||||||||||||||||||||||||||||||||
610 | [] | Kuntokeskus | Konditionsidrottscentrum | Fitness centre | 625 | 2018-08-07T14:00:23.616327+03:00 | 4 | 608 | {} | [625] | 0 | 1403 | 48 | 97 | 28 | 20 | 1 | ||||||||||||||||||||||||||||||
1165 | [] | B2-ranska | B2-franska | B2-French | 149*119+150*119+162*119+163*119+301*119+302*119+384*119+385*119+567*119+568*119+612*119+613*119+661*119+662*119+771*119+772*119+793*119+794*119+865*119+866*119 | 2018-10-25T08:00:08.088270+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 119] | 1 | 1087 | 48 | 72 | 22 | 2 | |||||||||||||||||||||||||||||||
609 | [] | Kamppailulajien sali | Sal för kampsport | Martial arts hall | 241 | 2018-08-07T14:00:23.609044+03:00 | 4 | 608 | {} | [241] | 0 | 1403 | 47 | 64 | 13 | 4 | |||||||||||||||||||||||||||||||
658 | [] | Lentopallokenttä | Volleybollplan | Volleyball court | 392 | 2018-08-07T14:00:23.980139+03:00 | 4 | 654 | {} | [392] | 0 | 1403 | 46 | 86 | 1 | 10 | 28 | 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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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"]} | [700] | 0 | 1403 | 45 | 83 | 11 | 25 | 2 | ||||||||||||||||||||||||||||||
1136 | [] | A2-espanja | A2-spanska | A2-Spanish | 149*28+150*28+162*28+163*28+301*28+302*28+384*28+385*28+567*28+568*28+612*28+613*28+661*28+662*28+771*28+772*28+793*28+794*28+865*28+866*28 | 2018-10-25T08:00:07.822843+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 28] | 1 | 1087 | 45 | 75 | 7 | 23 | |||||||||||||||||||||||||||||||
1122 | [] | A1-ruotsi | A1-svenska | A1-Swedish | 149*22+150*22+162*22+163*22+301*22+302*22+384*22+385*22+567*22+568*22+612*22+613*22+661*22+662*22+771*22+772*22+793*22+794*22+865*22+866*22 | 2018-10-25T08:00:07.687212+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 22] | 1 | 1087 | 43 | 50 | 7 | ||||||||||||||||||||||||||||||||
1166 | [] | B2-saksa | B2-tyska | B2-German | 149*121+150*121+162*121+163*121+301*121+302*121+384*121+385*121+567*121+568*121+612*121+613*121+661*121+662*121+771*121+772*121+793*121+794*121+865*121+866*121 | 2018-10-25T08:00:08.096555+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 121] | 1 | 1087 | 43 | 71 | 25 | 3 | |||||||||||||||||||||||||||||||
746 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:24.561434+03:00 | 4 | 745 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
1129 | [] | A1-ranska | A1-franska | A1-French | 149*21+150*21+162*21+163*21+301*21+302*21+384*21+385*21+567*21+568*21+612*21+613*21+661*21+662*21+771*21+772*21+793*21+794*21+865*21+866*21 | 2018-10-25T08:00:07.759368+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 21] | 1 | 1087 | 42 | 50 | 8 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
880 | [] | osapäiväryhmä | halvdagsgrupp | part-time day care | 663*489 | 2018-08-07T14:00:28.322654+03:00 | 4 | 870 | {} | [663, 489] | 0 | 1405 | 33 | 33 | |||||||||||||||||||||||||||||||||
1186 | [] | Autististen ja kehitysvammaisten ryhmät | Grupper för autistiska och utvecklingsstörda | Groups for autistic and intellectually disabled | 656*80 | 2018-08-07T14:00:26.244278+03:00 | 4 | 1181 | {} | [656, 80] | 1 | 1087 | 33 | 33 | |||||||||||||||||||||||||||||||||
665 | [] | Yleisurheilun harjoitusalue | Träningsområde för friidrott | Athletics training area | 818 | 2018-08-07T14:00:24.033733+03:00 | 4 | 663 | {} | [818] | 0 | 1403 | 28 | 42 | 14 | ||||||||||||||||||||||||||||||||
1130 | [] | A1-saksa | A1-tyska | A1-German | 149*23+150*23+162*23+163*23+301*23+302*23+384*23+385*23+567*23+568*23+612*23+613*23+661*23+662*23+771*23+772*23+793*23+794*23+865*23+866*23 | 2018-10-25T08:00:07.768212+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 23] | 1 | 1087 | 28 | 40 | 12 | ||||||||||||||||||||||||||||||||
1172 | [] | 7. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 7 | special emphasis starting from 7th grade | 150*3+163*3+302*3+385*3+568*3+613*3+662*3+772*3+794*3+866*3 | 2018-10-25T08:00:08.139111+03:00 | 4 | 1169 | {} | [866, 794, 772, 662, 613, 568, 385, 302, 163, 150, 3] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
1182 | [] | Koulun järjestämät ryhmät | Skolornas grupper | Groups organised by schools | 656*342 | 2018-08-07T14:00:26.208350+03:00 | 4 | 1181 | {} | [656, 342] | 1 | 1087 | 28 | 28 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
887 | [] | esiopetus | förskoleundervisning | pre-primary education | 603*160+862*160 | 2018-10-24T23:30:08.488969+03:00 | 4 | 881 | {} | [862, 603, 160] | 1 | 1405 | 27 | 36 | 9 | ||||||||||||||||||||||||||||||||
301 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-25T08:00:06.456994+03:00 | 4 | 293 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
911 | [] | esiopetus | förskoleundervisning | pre-primary education | 151*160 | 2018-08-07T14:00:28.512259+03:00 | 4 | 905 | {} | [160, 151] | 1 | 1405 | 26 | 39 | 12 | 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 | ||||||||||||||||||||||||||||||
582 | [] | Kävelyreitti | Promenadled/Friluftsled | Outdoor route | 364 | 2018-08-07T14:00:23.426422+03:00 | 4 | 577 | {} | [364] | 0 | 1403 | 23 | 42 | 18 | 1 | |||||||||||||||||||||||||||||||
1160 | [] | B2-espanja | B2-spanska | B2-Spanish | 149*114+150*114+162*114+163*114+301*114+302*114+384*114+385*114+567*114+568*114+612*114+613*114+661*114+662*114+771*114+772*114+793*114+794*114+865*114+866*114 | 2018-10-25T08:00:08.038588+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 114] | 1 | 1087 | 23 | 31 | 7 | 1 | |||||||||||||||||||||||||||||||
613 | [] | Voimailusali | Styrketräningssal | Weight training hall | 797 | 2018-08-07T14:00:23.637831+03:00 | 4 | 608 | {} | [797] | 0 | 1403 | 22 | 39 | 5 | 12 | |||||||||||||||||||||||||||||||
627 | [] | Pöytätennistila | Utrymme för bordtennis | Table tennis venue | 556 | 2018-08-07T14:00:23.745237+03:00 | 4 | 624 | {} | [556] | 0 | 1403 | 22 | 46 | 22 | 2 | |||||||||||||||||||||||||||||||
692 | [] | Uima-allas | Simbassäng | Swimming pool | 728 | 2018-08-07T14:00:24.217361+03:00 | 4 | 690 | {} | [728] | 0 | 1403 | 21 | 28 | 6 | 1 | |||||||||||||||||||||||||||||||
1189 | [] | ruotsinkielinen opetus | undervisning på svenska | education in Swedish | 601 | 2018-08-07T14:00:26.265483+03:00 | 4 | 1188 | {} | [601] | 1 | 1087 | 21 | 37 | 12 | 4 | |||||||||||||||||||||||||||||||
1194 | [] | A1-suomi | A1-finska | A1-Finnish | 601*24+602*24 | 2018-10-25T08:00:08.223234+03:00 | 4 | 1193 | {} | [602, 601, 24] | 1 | 1087 | 21 | 26 | 5 | ||||||||||||||||||||||||||||||||
1208 | [] | A2-englanti | A2-engelska | A2-English | 601*27+602*27 | 2018-10-25T08:00:08.293365+03:00 | 4 | 1193 | {} | [602, 601, 27] | 1 | 1087 | 20 | 25 | 5 | ||||||||||||||||||||||||||||||||
1184 | [] | Seurakuntien ryhmät | Församlingarnas grupper | Groups organised by parishes | 656*620 | 2018-08-07T14:00:26.237285+03:00 | 4 | 1181 | {} | [656, 620] | 1 | 1087 | 18 | 18 | |||||||||||||||||||||||||||||||||
1251 | [] | Järjestöjen ja yhdistysten ryhmät | Organisationernas och föreningarnas grupper | Groups organised by organisations or associations | 596*229 | 2018-08-07T14:00:26.727399+03:00 | 4 | 1249 | {} | [596, 229] | 1 | 1087 | 18 | 22 | 4 | ||||||||||||||||||||||||||||||||
701 | [] | Ruoanlaittopaikka | Matlagningsplats | Cooking facilities | 586 | 2018-08-07T14:00:24.282789+03:00 | 4 | 695 | {} | [586] | 0 | 1403 | 17 | 77 | 6 | 8 | 4 | 33 | 9 | ||||||||||||||||||||||||||||
1124 | [] | A1-espanja | A1-spanska | A1-Spanish | 149*16+150*16+162*16+163*16+301*16+302*16+384*16+385*16+567*16+568*16+612*16+613*16+661*16+662*16+771*16+772*16+793*16+794*16+865*16+866*16 | 2018-10-25T08:00:07.713876+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 16] | 1 | 1087 | 15 | 15 | |||||||||||||||||||||||||||||||||
1143 | [] | A2-venäjä | A2-ryska | A2-Russian | 149*37+150*37+162*37+163*37+301*37+302*37+384*37+385*37+567*37+568*37+612*37+613*37+661*37+662*37+771*37+772*37+793*37+794*37+865*37+866*37 | 2018-10-25T08:00:07.886355+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 37] | 1 | 1087 | 15 | 19 | 1 | 3 | |||||||||||||||||||||||||||||||
629 | [] | Sisäkiipeilyseinä | Klättervägg inomhus | Indoor climbing wall | 624 | 2018-08-07T14:00:23.760205+03:00 | 4 | 624 | {} | [624] | 0 | 1403 | 14 | 19 | 3 | 2 | |||||||||||||||||||||||||||||||
688 | [] | Uimapaikka | Badplats | Unsupervised beach | 730 | 2018-08-07T14:00:24.189679+03:00 | 4 | 685 | {} | [730] | 0 | 1403 | 14 | 48 | 4 | 22 | 4 | 4 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | {} | [816, 792, 770, 658, 611, 566, 383, 300, 161, 148] | 1 | 1087 | 14 | 30 | 11 | 5 | |||||||||||||||||||||||||||||||
623 | [] | Tennishalli | Tennishall | Tennis hall | 699 | 2018-08-07T14:00:23.714268+03:00 | 4 | 614 | {} | [699] | 0 | 1403 | 13 | 23 | 7 | 3 | |||||||||||||||||||||||||||||||
641 | [] | Kaukalo | Rink | Rink | 235 | 2018-08-07T14:00:23.842218+03:00 | 4 | 639 | {} | [235] | 0 | 1403 | 13 | 15 | 2 | ||||||||||||||||||||||||||||||||
687 | [] | Talviuintipaikka | Vinterbadplats | Winter swimming area | 684 | 2018-08-07T14:00:24.182493+03:00 | 4 | 685 | {} | [684] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
689 | [] | Uimaranta | Badstrand | Supervised beach | 731 | 2018-08-07T14:00:24.196951+03:00 | 4 | 685 | {} | [731] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
1215 | [] | A2-saksa | A2-tyska | A2-German | 601*35+602*35 | 2018-10-24T20:00:08.743668+03:00 | 4 | 1193 | {} | [602, 601, 35] | 1 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
1274 | [] | A-englanti | A-engelska | A-English | 148*4+161*4+300*4+383*4+566*4+611*4+658*4+770*4+792*4 | 2018-10-25T08:00:08.562076+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 4] | 1 | 1087 | 12 | 27 | 10 | 5 | |||||||||||||||||||||||||||||||
2227 | [] | Kielirikasteinen opetus (suomi-englanti) | Språkberikande undervisning (finska-engelska) | Language-enriched education (Finnish-English) | 661*910+662*910 | 2020-06-22T13:30:11.061581+03:00 | 4 | 1120 | {} | [910, 662, 661] | 1 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
645 | [] | Tekojääkenttä | Konstis | Mechanically frozen open-air ice rink | 695 | 2018-08-07T14:00:23.870223+03:00 | 4 | 639 | {} | [695] | 0 | 1403 | 11 | 25 | 10 | 4 | |||||||||||||||||||||||||||||||
1171 | [] | 3. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 3 | special emphasis starting from 3rd grade | 149*2+162*2+301*2+384*2+567*2+612*2+661*2+771*2+793*2+865*2 | 2018-10-25T08:00:08.131695+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 2] | 1 | 1087 | 11 | 15 | 4 | ||||||||||||||||||||||||||||||||
1284 | [] | B-ruotsi | B-svenska | B-Swedish | 148*96+161*96+300*96+383*96+566*96+611*96+658*96+770*96+792*96 | 2018-10-25T08:00:08.642605+03:00 | 4 | 1271 | {} | [792, 770, 658, 611, 566, 383, 300, 161, 148, 96] | 1 | 1087 | 11 | 27 | 11 | 5 | |||||||||||||||||||||||||||||||
332 | [] | WLAN-ulkopisteet | WLAN-utomhusstationer | WLAN outlets | 807 | 2018-08-07T14:00:24.889824+03:00 | 4 | 330 | {} | [807] | 0 | 1402 | 10 | 10 | |||||||||||||||||||||||||||||||||
603 | [] | Harjoitusjäähalli | Övningsishall | Training ice arena | 187 | 2018-08-07T14:00:23.568317+03:00 | 4 | 602 | {} | [187] | 0 | 1403 | 10 | 17 | 5 | 2 | |||||||||||||||||||||||||||||||
1167 | [] | B2-venäjä | B2-ryska | B2-Russian | 149*123+150*123+162*123+163*123+301*123+302*123+384*123+385*123+567*123+568*123+612*123+613*123+661*123+662*123+771*123+772*123+793*123+794*123+865*123+866*123 | 2018-10-25T08:00:08.105027+03:00 | 4 | 1120 | {} | [866, 865, 794, 793, 772, 771, 662, 661, 613, 612, 568, 567, 385, 384, 302, 301, 163, 162, 150, 149, 123] | 1 | 1087 | 10 | 12 | 2 | ||||||||||||||||||||||||||||||||
1170 | [] | 1. luokalta alkava soveltuvuuskoepainotus | lämplighetstestbetoning från årskurs 1 | special emphasis starting from 1st grade | 149*1+162*1+301*1+384*1+567*1+612*1+661*1+771*1+793*1+865*1 | 2018-10-25T08:00:08.124175+03:00 | 4 | 1169 | {} | [865, 793, 771, 661, 612, 567, 384, 301, 162, 149, 1] | 1 | 1087 | 10 | 10 |
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 );