service_node
939 rows where "last_modified_time" is on date 2018-08-07 sorted by name_fi
This data as json, CSV (advanced)
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
124 | [] | Avoimet työpaikat | Lediga jobb | Open jobs | 84 | 2018-08-07T14:00:30.009390+03:00 | 2 | 122 | {} | [84] | 0 | 1401 | 5 | 7 | 1 | 1 | |||||||||||||||||||||||||||||||
375 | [] | Avoin nuorisotoiminta | Öppen ungdomsverksamhet | Open youth activities | 85 | 2018-08-07T14:00:22.911924+03:00 | 3 | 368 | {} | [85] | 0 | 1403 | 41 | 78 | 22 | 14 | 1 | ||||||||||||||||||||||||||||||
220 | [] | Avustusten sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för bidragsärenden | Electronic services and forms related to benefits | 87 | 2018-08-07T14:00:30.732707+03:00 | 3 | 219 | {} | [87] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
1317 | [] | B-englanti | B-engelska | B-English | 598*88 | 2018-08-07T14:00:27.214095+03:00 | 4 | 1303 | {} | [598, 88] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1318 | [] | B-espanja | B-spanska | B-Spanish | 598*89 | 2018-08-07T14:00:27.222850+03:00 | 4 | 1303 | {} | [598, 89] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1319 | [] | B-italia | B-italienska | B-Italian | 598*90 | 2018-08-07T14:00:27.230479+03:00 | 4 | 1303 | {} | [598, 90] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1321 | [] | B-kiina | B-kinesiska | B-Chinese | 598*92 | 2018-08-07T14:00:27.245446+03:00 | 4 | 1303 | {} | [598, 92] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1324 | [] | B-ranska | B-franska | B-French | 598*95 | 2018-08-07T14:00:27.267203+03:00 | 4 | 1303 | {} | [598, 95] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1325 | [] | B-saksa | B-tyska | B-German | 598*97 | 2018-08-07T14:00:27.274071+03:00 | 4 | 1303 | {} | [598, 97] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1315 | [] | B-suomi | B-finska | B-Finnish | 598*98 | 2018-08-07T14:00:27.199171+03:00 | 4 | 1303 | {} | [598, 98] | 1 | 1087 | 2 | 2 | |||||||||||||||||||||||||||||||||
1326 | [] | B-venäjä | B-ryska | B-Russian | 598*99 | 2018-08-07T14:00:27.281070+03:00 | 4 | 1303 | {} | [598, 99] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
2174 | [] | Baarit ja yöelämä | Barer och nattliv | Bars and nightlife | 869 | 2018-08-07T14:00:24.408116+03:00 | 3 | 718 | {} | [869] | 0 | 1403 | 179 | 181 | 2 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
568 | [] | Curlingrata | Curlingbana | Curling sheet | 129 | 2018-08-07T14:00:23.345064+03:00 | 4 | 567 | {} | [129] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
756 | [757, 763] | Demokratia | Demokrati | Democracy | 2018-08-07T14:00:30.749902+03:00 | 2 | 755 | {} | [] | 0 | 1401 | 8 | 13 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
381 | [] | Demostudio | Demostudio | Demo studio | 130 | 2018-08-07T14:00:22.931253+03:00 | 3 | 368 | {} | [130] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
2162 | [] | Digitaalinen nuorisotyö | Digital ungdomsarbete | Digital youth work | 859 | 2018-08-07T14:00:23.214339+03:00 | 2 | 365 | {} | [859] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
775 | [] | Edunvalvonta | Intressebevakning | Trusteeship | 131 | 2018-08-07T14:00:30.904881+03:00 | 3 | 769 | {} | [131] | 0 | 1401 | 1 | 3 | 2 | ||||||||||||||||||||||||||||||||
2011 | [] | Ehkäisevä toimeentulotuki | Förebyggande utkomststöd | Preventive social assistance | 840 | 2018-08-07T14:00:28.099014+03:00 | 2 | 839 | {} | [840] | 0 | 783 | 7 | 8 | 1 | ||||||||||||||||||||||||||||||||
122 | [123, 124, 126, 128, 130, 131, 132, 133, 134, 141, 146, 163, 164, 165, 166, 167] | Elinkeino, työ ja verotus | Näringar, arbete och beskattning | Entrepreneurship, work and taxation | 2018-08-07T14:00:29.995212+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 322 | 452 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 51 | 62 | 5 | 1 | |||||||||||||||||||||||
126 | [] | Elinkeinoasiat | Näringslivsfrågor | Trade and industry matters | 132 | 2018-08-07T14:00:30.024180+03:00 | 2 | 122 | {} | [132] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
128 | [] | Elinkeinopalvelujen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för näringslivsservicen | Electronic services and forms related to business services | 135 | 2018-08-07T14:00:30.039148+03:00 | 2 | 122 | {} | [135] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
14 | [16, 23] | Eläimet | Djur | Animals | 2018-08-07T14:00:21.679608+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 103 | 150 | 22 | 25 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
721 | [] | Eläintarha | Högholmens djurgård | Helsinki Zoo | 142 | 2018-08-07T14:00:24.428725+03:00 | 4 | 719 | {} | [142] | 0 | 1403 | 9 | 9 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
552 | [553, 2007] | Eläinurheilualueet | Anläggningar för djursport | Animal sports areas | 2018-08-07T14:00:23.225274+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 27 | 75 | 31 | 17 | ||||||||||||||||||||||||||||||||
130 | [] | Eläkkeet | Pensioner | Pension matters | 143 | 2018-08-07T14:00:30.054750+03:00 | 2 | 122 | {} | [143] | 0 | 1401 | 4 | 10 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
272 | [273, 274, 275] | Energia | Energi | Energy | 2018-08-07T14:00:22.327547+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
26 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:21.749651+03:00 | 2 | 24 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
274 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:22.341217+03:00 | 4 | 272 | {} | [146] | 0 | 1400 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1302 | [] | Erityistehtävän mukainen lukiokoulutus | Gymnasieutbildning med särskild uppgift | Upper secondary school education with special curriculum | 598*157 | 2018-08-07T14:00:27.104000+03:00 | 4 | 1300 | {} | [598, 157] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1088 | [1093, 1089] | Esiopetus | Förskola | Pre-primary education | 2018-08-07T14:00:25.281111+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 320 | 530 | 89 | 121 | ||||||||||||||||||||||||||||||||
2118 | [2126, 2122] | Esiopetus | Förskola | Pre-primary education | 2018-08-07T14:00:29.045629+03:00 | 1 | 1405 | {} | [] | 0 | 1405 | 320 | 530 | 89 | 121 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
554 | [] | Esteratsastuskenttä | Bana för banhoppning | Show jumping field | 166 | 2018-08-07T14:00:23.236991+03:00 | 4 | 553 | {} | [166] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
2156 | [] | Etsivä nuorisotyö | Uppsökande ungdomsarbete | Detective youth work | 854 | 2018-08-07T14:00:23.208137+03:00 | 2 | 365 | {} | [854] | 0 | 1403 | 5 | 7 | 2 | ||||||||||||||||||||||||||||||||
841 | [] | Etuuskäsittely | Förmånsbehandling | Benefit processing | 167 | 2018-08-07T14:00:28.085946+03:00 | 2 | 839 | {} | [167] | 0 | 783 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
391 | [] | Futsal | Futsal | Futsal | 170 | 2018-08-07T14:00:22.944059+03:00 | 3 | 368 | {} | [170] | 0 | 1403 | 1 | 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 | ||||||||||||||||||||||||||||||
635 | [] | Golfin harjoitusalue | Träningsområde för golf | Golf training area | 173 | 2018-08-07T14:00:23.802245+03:00 | 4 | 634 | {} | [173] | 0 | 1403 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
636 | [] | Golfin harjoitushalli | Övningshall för golf | Golf training hall | 174 | 2018-08-07T14:00:23.808994+03:00 | 4 | 634 | {} | [174] | 0 | 1403 | 6 | 10 | 4 | ||||||||||||||||||||||||||||||||
637 | [] | Golfkenttä | Golfbana | Golf course | 175 | 2018-08-07T14:00:23.815939+03:00 | 4 | 634 | {} | [175] | 0 | 1403 | 4 | 16 | 9 | 3 | |||||||||||||||||||||||||||||||
634 | [635, 636, 637, 638] | Golfkentät | Golfbanor | Golf courses | 2018-08-07T14:00:23.796742+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 18 | 50 | 23 | 9 | ||||||||||||||||||||||||||||||||
1021 | [] | HUS:n erikoissairaanhoito | HNS:s specialsjukvård | HUS specialised health care | 440 | 2018-08-07T14:00:29.421431+03:00 | 2 | 1019 | {} | [440] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
173 | [2004, 2003, 2005] | Hallinnon toimipisteet | Förvaltningens verksamhetsställen | Administrative offices | 2018-08-07T14:00:30.377254+03:00 | 3 | 172 | {} | [] | 0 | 1401 | 56 | 67 | 1 | 2 | 7 | 1 | ||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
172 | [173, 176, 2001, 2002] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:30.370486+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 59 | 72 | 1 | 3 | 8 | 1 | ||||||||||||||||||||||||||||||
233 | [234, 235, 237] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:22.072503+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 3 | 6 | 3 | |||||||||||||||||||||||||||||||||
866 | [] | Hallinto | Förvaltning | Administration | 180 | 2018-08-07T14:00:28.228192+03:00 | 1 | 783 | {} | [180] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
1382 | [] | Hallinto | Förvaltning | Administration | 179 | 2018-08-07T14:00:27.693663+03:00 | 1 | 1087 | {} | [179] | 0 | 1087 | 12 | 12 | |||||||||||||||||||||||||||||||||
171 | [2203, 172, 177, 178, 179, 180, 186, 187, 191, 197, 216, 219] | Hallinto ja talous | Förvaltning och ekonomi | Administration and economy | 2018-08-07T14:00:30.363012+03:00 | 1 | 1401 | {} | [] | 0 | 1401 | 124 | 163 | 1 | 1 | 17 | 17 | 2 | 1 | ||||||||||||||||||||||||||||
543 | [] | Hallintopalvelut | Förvaltningstjänster | Administrative services | 183 | 2018-08-07T14:00:25.201364+03:00 | 4 | 542 | {} | [183] | 0 | 1402 | 2 | 2 | |||||||||||||||||||||||||||||||||
235 | [] | Hankepalvelut | Projekttjänster | Project services | 185 | 2018-08-07T14:00:22.084046+03:00 | 4 | 233 | {} | [185] | 0 | 1400 | 3 | 3 | |||||||||||||||||||||||||||||||||
177 | [] | Hankintapalvelut | Upphandlingstjänster | Procurement services | 217 | 2018-08-07T14:00:30.442764+03:00 | 2 | 171 | {} | [217] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
565 | [] | Harjoitushyppyrimäki | Träningshoppbacke | Ski jumping hill for training | 186 | 2018-08-07T14:00:23.324523+03:00 | 4 | 564 | {} | [186] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
368 | [371, 374, 375, 376, 378, 381, 389, 391, 395, 396, 399, 2155, 403, 404, 405, 409, 410, 415, 418, 419, 421, 424, 426, 429, 433, 437, 438, 440, 442, 446, 448, 449, 452, 453, 454, 455, 458, 467, 468, 470, 473, 2154, 480, 481, 485, 488] | Harrasteet | Hobbyer | Hobbies | 2018-08-07T14:00:22.885008+03:00 | 2 | 365 | {} | [] | 0 | 1403 | 71 | 120 | 1 | 1 | 27 | 17 | 3 | |||||||||||||||||||||||||||||
150 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:30.186216+03:00 | 4 | 149 | {} | [799] | 0 | 1401 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
259 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.226278+03:00 | 5 | 258 | {} | [799] | 0 | 1400 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
506 | [] | Harrastustilat | Hobbylokaler | Hobby facilities | 799 | 2018-08-07T14:00:22.804088+03:00 | 3 | 505 | {} | [799] | 0 | 1403 | 3 | 8 | 2 | 1 | 2 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
579 | [] | Hevosreitti | Hästled | Horse track | 190 | 2018-08-07T14:00:23.406242+03:00 | 4 | 577 | {} | [190] | 0 | 1403 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
553 | [554, 555, 556, 557] | Hevosurheilu | Hästsport | Equestrian sports | 2018-08-07T14:00:23.231236+03:00 | 3 | 552 | {} | [] | 0 | 1403 | 19 | 64 | 31 | 14 | ||||||||||||||||||||||||||||||||
595 | [] | Hiihtomaa | Skidland | Cross-country ski park | 192 | 2018-08-07T14:00:23.517563+03:00 | 4 | 592 | {} | [192] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
569 | [] | Hiihtotunneli | Skidtunnel | Ski tunnel | 194 | 2018-08-07T14:00:23.351595+03:00 | 4 | 567 | {} | [194] | 0 | 1403 | 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 | |||||||||||||||||||||||||||||||||
861 | [] | Hoitoalan ruokapalvelut | Mattjänster inom vårdbranschen | Meal services in the care sector | 196 | 2018-08-07T14:00:28.222009+03:00 | 1 | 783 | {} | [196] | 0 | 783 | 12 | 12 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
564 | [565] | Hyppyrimäet | Hoppbackar | Ski jumping hills | 2018-08-07T14:00:23.318569+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 1 | 1 | ||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
786 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:27.716150+03:00 | 2 | 784 | {} | [199] | 0 | 783 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2146 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:29.136711+03:00 | 2 | 988 | {} | [199] | 0 | 986 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
2148 | [] | Ikääntyvien neuvonta | Rådgivning för åldringar | Information and advice for elderly people | 199 | 2018-08-07T14:00:24.771984+03:00 | 4 | 2147 | {} | [199] | 0 | 1402 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
1181 | [1186, 1183, 1182, 2134, 1184] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 656 | 2018-08-07T14:00:26.201113+03:00 | 3 | 1098 | {} | [656] | 1 | 1087 | 238 | 240 | 2 | ||||||||||||||||||||||||||||||||
1249 | [1251, 1250, 1252] | Iltapäivätoiminta | Eftermiddagsverksamhet | Afternoon activities | 596 | 2018-08-07T14:00:26.711531+03:00 | 3 | 1187 | {} | [596] | 1 | 1087 | 24 | 39 | 11 | 4 | |||||||||||||||||||||||||||||||
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 |
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 );