service_node
383 rows where level = 3 sorted by related_services
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ää
last_modified_time (date) ✖
- 2018-08-07 321
- 2018-10-25 18
- 2020-06-09 8
- 2019-03-05 6
- 2020-11-18 5
- 2018-10-24 3
- 2020-12-02 3
- 2018-11-20 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-06-20 2
- 2020-05-08 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-22 1
- 2019-09-02 1
- 2019-10-22 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-10-02 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ää |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
| 36 | [] | Bio- ja puutarhajäte | Trädgårdsavfall | Garden waste | 127 | 2018-08-07T14:00:21.797808+03:00 | 3 | 34 | {} | [127] | 0 | 1400 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
| 378 | [] | Bänditoiminta/-tila | Bandverksamhet eller bandlokal | Band activity or practice space | 128 | 2018-08-07T14:00:22.924860+03:00 | 3 | 368 | {} | [128] | 0 | 1403 | 2 | 12 | 5 | 5 | |||||||||||||||||||||||||||||||
| 381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 775 | [] | Edunvalvonta | Intressebevakning | Trusteeship | 131 | 2018-08-07T14:00:30.904881+03:00 | 3 | 769 | {} | [131] | 0 | 1401 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
| 142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 105 | [] | Elintarvikevalvonta | Livsmedelsbevakning | Food control | 137 | 2018-08-07T14:00:21.585963+03:00 | 3 | 103 | {} | [137] | 0 | 1400 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
| 353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 107 | [] | Eläinsuojelu | Djurskydd | Animal protection | 141 | 2018-08-07T14:00:21.598706+03:00 | 3 | 103 | {} | [141] | 0 | 1400 | 1 | 4 | 1 | 2 | |||||||||||||||||||||||||||||||
| 232 | [] | Energia-avustukset | energiunderstöd | energy grants | 144 | 2018-08-07T14:00:22.065643+03:00 | 3 | 231 | {} | [144] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 37 | [] | Energiajäte | Energiavfall | Energy waste | 145 | 2018-08-07T14:00:21.805057+03:00 | 3 | 34 | {} | [145] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 913 | [919, 914] | Espanjankielinen päivähoito | Spanskspråkig dagvård | Day care in Spanish | 164 | 2018-08-07T14:00:28.527678+03:00 | 3 | 869 | {} | [164] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 217 | [] | Sisäinen tarkastus | Intern revision | Internal auditing | 176 | 2018-08-07T14:00:30.706266+03:00 | 3 | 216 | {} | [176] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 218 | [] | Ulkoinen tarkastus | Extern revision | External auditing | 177 | 2018-08-07T14:00:30.714388+03:00 | 3 | 216 | {} | [177] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 921 | [922] | Hepreankielinen päivähoito | Hebreiskspråkig dagvård | Day care in Hebrew | 188 | 2018-08-07T14:00:28.572081+03:00 | 3 | 869 | {} | [188] | 0 | 1405 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 238 | [] | Hissiprojekti | Anskaffning av hissar (gamla höghus) | Lift procurement (old residential buildings) | 195 | 2018-08-07T14:00:22.097017+03:00 | 3 | 231 | {} | [195] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 736 | [] | Hotellit ja majoitus | Hotell och logi | Hotels and accommodation | 197 | 2018-08-07T14:00:24.492255+03:00 | 3 | 718 | {} | [197] | 0 | 1403 | 89 | 115 | 1 | 1 | 1 | 2 | 7 | 13 | 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 | |||||||||||||||||||||||||||||||
| 395 | [] | Internet | Internet | Internet | 202 | 2018-08-07T14:00:22.950721+03:00 | 3 | 368 | {} | [202] | 0 | 1403 | 2 | 15 | 13 | ||||||||||||||||||||||||||||||||
| 396 | [] | Jalkapallo | Fotboll | Football | 203 | 2018-08-07T14:00:22.956950+03:00 | 3 | 368 | {} | [203] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 321 | [] | Johtotietopalvelu ja maanalaisten tilojen tietopalvelu | Ledningstjänsten och information om underjordiska utrymmen | Information service on cabling and underground facilities | 207 | 2018-08-07T14:00:24.801557+03:00 | 3 | 320 | {} | [207] | 0 | 1402 | 2 | 6 | 1 | 3 | |||||||||||||||||||||||||||||||
| 515 | [] | Joukkoliikennepysäkit | Kollektivtrafikens hållplatser | Public transport stops | 209 | 2018-08-07T14:00:25.015254+03:00 | 3 | 513 | {} | [209] | 0 | 1402 | 3 | 1 | 2 | ||||||||||||||||||||||||||||||||
| 508 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.820471+03:00 | 3 | 505 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
| 737 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:24.498919+03:00 | 3 | 718 | {} | [214] | 0 | 1403 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
| 516 | [] | Julkisen liikenteen varikot | Kollektivtrafikens depåer | Public transport depots | 216 | 2018-08-07T14:00:25.022696+03:00 | 3 | 513 | {} | [216] | 0 | 1402 | 5 | 9 | 4 | ||||||||||||||||||||||||||||||||
| 182 | [] | Henkilöstöpolitiikka ja -strategia | Personalpolitik och -strategi | Personnel policy and strategy | 220 | 2018-08-07T14:00:30.473352+03:00 | 3 | 180 | {} | [220] | 0 | 1401 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 176 | [] | Postipalvelut | Posttjänster | Postal services | 224 | 2018-08-07T14:00:30.419580+03:00 | 3 | 172 | {} | [224] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 185 | [] | Rekrytointi | Rekrytering | Recruitment | 225 | 2018-08-07T14:00:30.493982+03:00 | 3 | 180 | {} | [225] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 399 | [] | Järjestötoiminta | Organisationsverksamhet | Organisational activities | 231 | 2018-08-07T14:00:22.963009+03:00 | 3 | 368 | {} | [231] | 0 | 1403 | 6 | 8 | 2 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||||
| 738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
| 38 | [] | Kartonginkeräys | Insamling av kartong | Cardboard recycling | 246 | 2018-08-07T14:00:21.813795+03:00 | 3 | 34 | {"fi": ["kartonki"]} | [246] | 0 | 1400 | 54 | 140 | 46 | 36 | 4 | ||||||||||||||||||||||||||||||
| 322 | [] | Karttapalvelut, ilmakuvat ja karttojen tilaus | Karttjänster, flygbilder och beställning av kartor | Mapping services, aerial photographs and ordering maps | 247 | 2018-08-07T14:00:24.808369+03:00 | 3 | 320 | {} | [247] | 0 | 1402 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
| 75 | [] | Katu-, maa- ja viherrakentamispalvelut | Tjänster inom gatu-, mark- och grönbyggnad | Construction services for streets, land and parks | 249 | 2018-08-07T14:00:21.457195+03:00 | 3 | 74 | {} | [249] | 0 | 1400 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
| 535 | [] | Katu-, maa- ja viherrakentamispalvelut | Tjänster inom gatu-, mark- och grönbyggnad | Construction services for streets, land and parks | 249 | 2018-08-07T14:00:25.151160+03:00 | 3 | 534 | {} | [249] | 0 | 1402 | 1 | 5 | 4 | ||||||||||||||||||||||||||||||||
| 313 | [] | Katu-, puisto- ja rakennuspiirustusten arkisto | Arkiv för gatu-, park- och byggnadsritningar | Public works department archive | 250 | 2018-08-07T14:00:24.696359+03:00 | 3 | 307 | {} | [250] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 76 | [] | Katujen ja viheralueiden käyttöluvat ja vuokraus | Tillstånd att använda gator och grönområden och uthyrning | Permits for using streets and parks and renting | 251 | 2018-08-07T14:00:21.463483+03:00 | 3 | 74 | {} | [251] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 536 | [] | Katujen ja viheralueiden käyttöluvat ja vuokraus | Tillstånd att använda gator och grönområden och uthyrning | Permits for using streets and parks and renting | 251 | 2018-08-07T14:00:25.157311+03:00 | 3 | 534 | {} | [251] | 0 | 1402 | 1 | 3 | 1 | 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 | ||||||||||||||||||||||||||||||
| 239 | [] | Kaupanvahvistus | Bestyrkande av köp | Public purchase witnessing | 255 | 2018-08-07T14:00:22.103157+03:00 | 3 | 231 | {} | [255] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 147 | [] | Kauppahallimyyntipaikkojen vuokraus | Uthyrning av försäljningsplatser i saluhallar | Market hall sales location leasing | 258 | 2018-08-07T14:00:30.162809+03:00 | 3 | 146 | {} | [258] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 81 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:21.499406+03:00 | 3 | 80 | {} | [259] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 740 | [] | Kauppahallit | Saluhallar | Market halls | 259 | 2018-08-07T14:00:24.520703+03:00 | 3 | 718 | {} | [259] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 6 | [] | Kaupungin asumisoikeusasunnot | stadens bostadsrättsbostäder | City's right of residence apartments | 261 | 2018-08-07T14:00:21.255121+03:00 | 3 | 5 | {} | [261] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 10 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:21.280357+03:00 | 3 | 8 | {} | [267] | 0 | 1400 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
| 136 | [] | Kaupungin tai kunnan työsuhdeasunnot | Stadens eller kommunens tjänstebostäder | City's or municipality's housing provided by the employer | 267 | 2018-08-07T14:00:30.094025+03:00 | 3 | 134 | {} | [267] | 0 | 1401 | 2 | 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 | |||||||||||||||||||||||||||||||
| 193 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.534760+03:00 | 3 | 191 | {} | [272] | 0 | 1401 | 2 | 4 | 1 | 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 | ||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 188 | [] | Kelan etuudet | FPA:s förmåner | Kela benefits | 286 | 2018-08-07T14:00:30.511334+03:00 | 3 | 187 | {} | [286] | 0 | 1401 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
| 403 | [] | Keramiikka | Keramik | Pottery | 287 | 2018-08-07T14:00:22.976243+03:00 | 3 | 368 | {} | [287] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
| 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 | |||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||
| 1174 | [] | Ruotsin kielikylpyopetus | Språkbadsundervisning på svenska | Language immersion education in Swedish | 295 | 2018-08-07T14:00:26.145715+03:00 | 3 | 1098 | {} | [295] | 1 | 1087 | 13 | 18 | 4 | 1 | |||||||||||||||||||||||||||||||
| 240 | [] | Kiinteistöhuolto ja isännöinti | Fastighetsunderhåll och -förvaltning | Janitorial and landlord services | 303 | 2018-08-07T14:00:22.109816+03:00 | 3 | 231 | {} | [303] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 241 | [] | Kiinteistönmuodostus | Fastighetsbildning | Property formation | 304 | 2018-08-07T14:00:22.116719+03:00 | 3 | 231 | {} | [304] | 0 | 1400 | 5 | 1 | 4 | ||||||||||||||||||||||||||||||||
| 242 | [] | Kiinteistörekisteri | Fastighetsregister | Real estate register | 305 | 2018-08-07T14:00:22.123611+03:00 | 3 | 231 | {} | [305] | 0 | 1400 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
| 310 | [] | Kiinteistörekisteri | Fastighetsregister | Real estate register | 305 | 2018-08-07T14:00:24.676288+03:00 | 3 | 307 | {} | [305] | 0 | 1402 | 4 | 1 | 3 | ||||||||||||||||||||||||||||||||
| 741 | [] | Kioskit | Kiosker | Kiosks | 309 | 2018-08-07T14:00:24.527473+03:00 | 3 | 718 | {} | [309] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
| 2026 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:22.565354+03:00 | 3 | 345 | {} | [312] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 2040 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:24.837192+03:00 | 3 | 324 | {} | [312] | 0 | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
| 82 | [] | Kirpputorit | Lopptorg | Flea markets | 315 | 2018-08-07T14:00:21.505503+03:00 | 3 | 80 | {} | [315] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
| 17 | [] | Koira-aitaukset | Hundparker | Dog parks | 317 | 2018-08-07T14:00:21.693384+03:00 | 3 | 16 | {"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 | |||||||||||||||||||||||||||||||
| 18 | [] | Koirakäymälät | Hundtoaletter | Dog toilets | 319 | 2018-08-07T14:00:21.700490+03:00 | 3 | 16 | {} | [319] | 0 | 1400 | 5 | 5 | |||||||||||||||||||||||||||||||||
| 19 | [] | Koirametsät | Hundskogar | Forest dog runs | 320 | 2018-08-07T14:00:21.707130+03:00 | 3 | 16 | {} | [320] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
| 20 | [] | Koirauimarannat | Hundbadstränder | Dog beaches | 321 | 2018-08-07T14:00:21.713262+03:00 | 3 | 16 | {} | [321] | 0 | 1400 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
| 409 | [] | Kokkikerho | Kockklubb | Cook club | 325 | 2018-08-07T14:00:22.999540+03:00 | 3 | 368 | {} | [325] | 0 | 1403 | 4 | 4 | |||||||||||||||||||||||||||||||||
| 507 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:22.812763+03:00 | 3 | 505 | {} | [326] | 0 | 1403 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
| 742 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:24.534199+03:00 | 3 | 718 | {} | [326] | 0 | 1403 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
| 354 | [] | Konserttitilat | Konsertutrymmen | Concert facilities | 329 | 2018-08-07T14:00:22.610197+03:00 | 3 | 352 | {} | [329] | 0 | 1403 | 33 | 43 | 8 | 1 | 1 | ||||||||||||||||||||||||||||||
| 410 | [] | Konsolipelit | Konsolspel | Console games | 330 | 2018-08-07T14:00:23.006235+03:00 | 3 | 368 | {} | [330] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||||||
| 776 | [] | Kotikunta- ja väestötiedot | Uppgifter om hemkommun och befolkningsinformation | Municipality of residence and population information | 335 | 2018-08-07T14:00:30.913192+03:00 | 3 | 769 | {} | [335] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
| 979 | [] | Koululaisten iltapäivätoiminnan ryhmät | Eftermiddagsverksamhet för skolelever | Afternoon activities for schoolchildren | 341 | 2018-08-07T14:00:28.994886+03:00 | 3 | 975 | {} | [341] | 1 | 1405 | 54 | 56 | 2 | ||||||||||||||||||||||||||||||||
| 363 | [] | Kulttuurihistoriallinen museo | Kulturhistoriska museer | Cultural history museums | 344 | 2018-08-07T14:00:22.670926+03:00 | 3 | 362 | {} | [344] | 0 | 1403 | 42 | 58 | 9 | 5 | 1 | 1 | |||||||||||||||||||||||||||||
| 355 | [] | Kulttuurin monitoimitalot | Allaktivitetshus för kultur | Multi-functional culture venues | 345 | 2018-08-07T14:00:22.617002+03:00 | 3 | 352 | {} | [345] | 0 | 1403 | 8 | 18 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||
| 777 | [] | Kuluttajansuoja ja neuvonta | Konsumentskydd och rådgivning | Consumer protection and advice | 347 | 2018-08-07T14:00:30.921943+03:00 | 3 | 769 | {} | [347] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
| 415 | [] | Kuntosali | Gym | Gym | 349 | 2018-08-07T14:00:23.013463+03:00 | 3 | 368 | {} | [349] | 0 | 1403 | 11 | 1 | 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 );