service_node
1,140 rows sorted by unit_count_municipality_sipoo descending
This data as json, CSV (advanced)
Suggested facets: level, keywords, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_porvoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_kotka, unit_count_municipality_mäntsälä, 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
last_modified_time (date) ✖
- 2018-08-07 939
- 2018-10-25 91
- 2020-03-06 16
- 2018-10-24 12
- 2020-11-18 12
- 2019-03-05 11
- 2020-06-09 9
- 2020-06-22 8
- 2018-08-31 4
- 2020-10-02 4
- 2020-12-02 4
- 2019-10-22 3
- 2018-11-20 2
- 2019-02-12 2
- 2019-03-20 2
- 2019-04-02 2
- 2019-05-08 2
- 2019-06-20 2
- 2019-08-22 2
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-23 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-05-25 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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||||||||||||||||||||
558 | [559, 564, 567, 572, 575, 577, 592, 597] | Maastoliikuntapaikat | Anläggningar för terrängidrott | Cross-country sports facilities | 2018-08-07T14:00:23.281875+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 151 | 443 | 5 | 1 | 1 | 118 | 153 | 9 | 5 | |||||||||||||||||||||||||||
512 | [513, 521, 525, 526, 533, 534, 541] | Liikenne | Trafik | Traffic | 2018-08-07T14:00:24.996122+03:00 | 1 | 1402 | {} | [] | 0 | 1402 | 1269 | 1864 | 1 | 4 | 2 | 1 | 2 | 540 | 39 | 6 | ||||||||||||||||||||||||||
541 | [542, 547] | Vesiliikenne | Sjötrafik | Water traffic | 2018-08-07T14:00:25.190941+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 223 | 279 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
547 | [548, 2199, 549, 2143, 2142] | Veneily | Båtsport | Boating | 2018-08-07T14:00:25.237133+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 206 | 262 | 1 | 4 | 2 | 1 | 2 | 45 | 1 | |||||||||||||||||||||||||||
1402 | [306, 512] | Liikenne ja kartat | Trafik och kartor | Traffic and maps | 2018-08-07T14:00:24.647447+03:00 | 0 | {} | [] | 0 | 1402 | 1567 | 2238 | 1 | 4 | 1 | 2 | 1 | 2 | 581 | 71 | 8 | ||||||||||||||||||||||||||
577 | [579, 580, 581, 582, 583, 584, 585, 586, 590] | Liikunta- ja ulkoilureitit | Idrotts- och friluftsleder | Sports and outdoor recreation routes | 2018-08-07T14:00:23.400833+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 132 | 401 | 3 | 1 | 1 | 105 | 147 | 9 | 3 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||
542 | [543, 544, 545, 2198, 546, 2144] | Satamat ja laiturit | Hamn och bryggor | Harbours, piers and quays | 2018-08-07T14:00:25.196186+03:00 | 3 | 541 | {} | [] | 0 | 1402 | 168 | 209 | 2 | 1 | 1 | 36 | 1 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
783 | [866, 861, 810, 797, 787, 845, 791, 2189, 830, 784, 860, 839, 798, 819, 859] | Perhe- ja sosiaalipalvelut | Familje- och socialservice | Family and social services | 2018-08-07T14:00:27.699133+03:00 | 0 | {} | [] | 0 | 783 | 397 | 718 | 2 | 1 | 1 | 129 | 175 | 1 | 7 | 5 | |||||||||||||||||||||||||||
798 | [805, 803, 807, 808, 806, 802, 801, 799, 800, 804, 809] | Vammaispalvelut | Handikapptjänster | Services for the disabled | 2018-08-07T14:00:27.804536+03:00 | 1 | 783 | {} | [] | 0 | 783 | 14 | 59 | 2 | 7 | 34 | 1 | 1 | |||||||||||||||||||||||||||||
986 | [990, 1048, 995, 996, 997, 1028, 1042, 1017, 992, 1019, 999, 1004, 1043, 1041, 1051, 1000, 1039, 1018, 1009, 1044, 988, 998, 993, 991, 2190, 1060, 994] | Terveys | Hälsovård | Health care | 2018-08-07T14:00:29.110723+03:00 | 0 | {} | [] | 0 | 986 | 556 | 949 | 1 | 4 | 1 | 2 | 4 | 1 | 1 | 3 | 1 | 1 | 5 | 9 | 4 | 4 | 2 | 8 | 2 | 122 | 1 | 6 | 2 | 183 | 5 | 2 | 12 | 2 | 2 | 2 | 1 | ||||||
1401 | [122, 171, 755] | Työ, talous ja hallinto | Arbete, ekonomi och förvaltning | Employment and public authorities | 2020-03-06T18:32:09.344909+02:00 | 0 | {} | [] | 0 | 1401 | 448 | 629 | 2 | 1 | 1 | 2 | 1 | 2 | 3 | 88 | 74 | 6 | 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 | ||||||||||||||||||||||||||||
1403 | [343, 551, 717, 365] | Kulttuuri, liikunta ja vapaa-aika | Kultur, motion och fritid | Culture, sports and leisure | 2018-08-07T14:00:22.534057+03:00 | 0 | {} | [] | 0 | 1403 | 5769 | 8871 | 1 | 18 | 1 | 1 | 1 | 12 | 1 | 20 | 3 | 1 | 6 | 14 | 1685 | 1 | 1238 | 1 | 37 | 57 | 4 | ||||||||||||||||
1400 | [2, 1, 14, 24, 31, 221, 85] | Asuminen ja kaupunkiympäristö | Boende och stadsmiljö | Housing and urban environment | 2018-08-07T14:00:21.224786+03:00 | 0 | {} | [] | 0 | 1400 | 2311 | 4077 | 17 | 1 | 23 | 1 | 1 | 4 | 1 | 30 | 53 | 43 | 737 | 3 | 698 | 35 | 10 | 31 | 37 | 41 | |||||||||||||||||
2 | [3, 4, 5, 7, 2191, 8] | Asuminen | Boende | Housing | 2018-08-07T14:00:21.231002+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 742 | 1530 | 16 | 23 | 1 | 1 | 27 | 51 | 40 | 246 | 3 | 256 | 35 | 10 | 1 | 37 | 41 | |||||||||||||||||||
551 | [552, 2151, 558, 2217, 601, 633, 666, 684, 694] | Liikunta | Idrott och motion | Sports and physical exercise | 2018-08-07T14:00:23.220207+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 2590 | 4872 | 16 | 3 | 19 | 1 | 1 | 11 | 1260 | 1 | 892 | 36 | 42 | |||||||||||||||||||||||
5 | [6] | Asumisoikeusasuminen | Bostadsrättsbostäder | Right-of-occupancy housing | 76 | 2018-08-07T14:00:21.249052+03:00 | 2 | 2 | {} | [76] | 0 | 1400 | 331 | 1108 | 15 | 23 | 1 | 27 | 51 | 40 | 242 | 3 | 253 | 35 | 10 | 37 | 40 | ||||||||||||||||||||
694 | [695, 706] | Virkistyskohteet ja palvelut | Rekreationsanläggningar och tjänster | Recreational destinations and services | 2018-08-07T14:00:24.231367+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 235 | 442 | 11 | 1 | 13 | 11 | 143 | 1 | 7 | 19 | 1 | |||||||||||||||||||||||||
695 | [696, 697, 698, 699, 700, 701, 702, 703, 704, 705] | Retkeilyn palvelut | Utflyktstjänster | Hiking facilities | 2018-08-07T14:00:24.236641+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 224 | 404 | 10 | 11 | 8 | 125 | 7 | 18 | 1 | |||||||||||||||||||||||||||
4 | [] | Asumisen tuet | Bostadsbidrag | Housing allowances | 75 | 2018-08-07T14:00:21.243003+03:00 | 2 | 2 | {} | [75] | 0 | 1400 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
146 | [147, 148, 149, 156] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:30.157480+03:00 | 2 | 122 | {} | [] | 0 | 1401 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
149 | [2209, 150, 152, 151, 154, 155] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:30.179684+03:00 | 3 | 146 | {} | [] | 0 | 1401 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 4 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
187 | [188, 189] | Maahanmuutto | Invandring | Immigration | 2018-08-07T14:00:30.506450+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 17 | 29 | 1 | 4 | 5 | 1 | 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 | |||||||||||||||||||||||||||||
221 | [222, 231, 270, 305] | Kaavoitus, kiinteistöt ja rakentaminen | Planläggning, fastigheter och byggande | Planning, real estate and construction | 2018-08-07T14:00:21.996119+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 367 | 506 | 1 | 1 | 1 | 1 | 1 | 3 | 2 | 54 | 69 | 6 | ||||||||||||||||||||||||
231 | [232, 233, 238, 239, 240, 241, 242, 243, 244, 245, 253, 254, 255] | Kiinteistöt ja rakennetut tilat | Fastigheter | Real estate | 2018-08-07T14:00:22.059452+03:00 | 2 | 221 | {} | [] | 0 | 1400 | 311 | 427 | 1 | 1 | 1 | 1 | 2 | 2 | 48 | 55 | 5 | |||||||||||||||||||||||||
255 | [256, 257, 258, 265] | Tilojen vuokraus ja varaus | Uthyrning och reservering av lokaler | Renting out and reservation of facilities | 2018-08-07T14:00:22.202500+03:00 | 3 | 231 | {} | [] | 0 | 1400 | 294 | 380 | 1 | 1 | 1 | 1 | 2 | 2 | 42 | 32 | 4 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
260 | [] | Kokouspaikat | Möteslokaler | Meeting places | 326 | 2018-08-07T14:00:22.232800+03:00 | 5 | 258 | {} | [326] | 0 | 1400 | 247 | 293 | 1 | 1 | 1 | 2 | 2 | 17 | 22 | ||||||||||||||||||||||||||
261 | [] | Juhlatilat | Festlokaler | Banquet facilities | 214 | 2018-08-07T14:00:22.239469+03:00 | 5 | 258 | {} | [214] | 0 | 1400 | 218 | 249 | 1 | 1 | 1 | 1 | 1 | 10 | 13 | 3 | |||||||||||||||||||||||||
343 | [344, 345, 350, 351, 352, 361, 362, 491, 504, 505, 2006, 503] | Kulttuuri ja vapaa-aika | Kultur och fritid | Culture and leisure | 2018-08-07T14:00:22.539281+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1745 | 2452 | 1 | 1 | 1 | 1 | 8 | 1 | 2 | 4 | 2 | 382 | 286 | 1 | 13 | 4 | ||||||||||||||||||||
365 | [2162, 2156, 368, 367, 366, 490] | Nuoriso | Ungdom | Youth | 2018-08-07T14:00:22.862181+03:00 | 1 | 1403 | {} | [] | 0 | 1403 | 82 | 146 | 1 | 1 | 30 | 29 | 3 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
505 | [2208, 506, 508, 507, 510, 511] | Vapaa-ajan tilojen vuokraus | Uthyrning av fritidslokaler | Renting recreational spaces | 2018-08-07T14:00:22.797039+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 292 | 375 | 1 | 1 | 1 | 1 | 2 | 2 | 40 | 31 | 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 | ||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
559 | [560, 561, 562, 563] | Ampumaurheilupaikat | Sportskytteplatser | Shooting sports facilities | 2018-08-07T14:00:23.287538+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 6 | 10 | 1 | 3 | ||||||||||||||||||||||||||||||||
561 | [] | Ampumaurheilukeskus | Sportskyttecentrum | Shooting sports centre | 55 | 2018-08-07T14:00:23.299465+03:00 | 4 | 559 | {} | [55] | 0 | 1403 | 1 | 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 | |||||||||||||||||||||||||||
592 | [593, 594, 595, 596] | Maastohiihtokeskukset | Längdåkningscentra | Cross-country ski resorts | 2018-08-07T14:00:23.496608+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 3 | 8 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||
593 | [] | Ampumahiihdon harjoittelualue | Träningsområde för skidskytte | Training area for biathlon | 52 | 2018-08-07T14:00:23.502563+03:00 | 4 | 592 | {} | [52] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
702 | [] | Telttailu ja leiriytyminen | Tältning och läger | Camping | 698 | 2018-08-07T14:00:24.290069+03:00 | 4 | 695 | {} | [698] | 0 | 1403 | 2 | 12 | 1 | 8 | 1 | ||||||||||||||||||||||||||||||
706 | [710, 711, 712, 713, 714, 716] | Virkistys- ja retkeilyalueet | Rekreations- och friluftsområden | Recreational and outdoor areas | 2018-08-07T14:00:24.316869+03:00 | 3 | 694 | {} | [] | 0 | 1403 | 11 | 38 | 1 | 1 | 2 | 3 | 18 | 1 | 1 | |||||||||||||||||||||||||||
711 | [] | Monikäyttöalue, jolla on virkistyspalveluita | Allaktivitetsområde med rekreationstjänster | Multipurpose area with recreational services | 442 | 2018-08-07T14:00:24.344046+03:00 | 4 | 706 | {} | [442] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
717 | [754, 718, 2173, 2028] | Matkailu ja tapahtumat | Turism och evenemang | Things to do | 2020-03-06T18:32:07.102459+02:00 | 1 | 1403 | {} | [] | 0 | 1403 | 1973 | 2155 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 3 | 5 | 3 | 87 | 67 | 1 | 1 | 3 | 4 | ||||||||||||||||||
718 | [2174, 719, 736, 2168, 737, 738, 739, 740, 741, 742, 743, 744, 745, 748, 749, 750, 751, 752, 753] | Matkailu | Turism | Tourism | 2018-08-07T14:00:24.401683+03:00 | 2 | 717 | {} | [] | 0 | 1403 | 1880 | 2050 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 3 | 5 | 3 | 79 | 64 | 1 | 1 | 3 | 4 | ||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||
797 | [] | Lapsiperheen tuet | Förmåner för barnfamiljer | Benefits for families with children | 370 | 2020-08-20T14:00:09.399199+03:00 | 1 | 783 | {} | [370] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
801 | [] | Vammaispalvelun sosiaaliohjaus | Socialhandledning inom handikappservice | Services for the disabled, social care work | 751 | 2018-08-07T14:00:27.822488+03:00 | 2 | 798 | {} | [751] | 0 | 783 | 33 | 1 | 32 | ||||||||||||||||||||||||||||||||
803 | [] | Vammaispalvelun asumispalvelut | Boendetjänster inom handikappservicen | Services for the disabled, residential services | 746 | 2018-08-07T14:00:27.835887+03:00 | 2 | 798 | {} | [746] | 0 | 783 | 7 | 24 | 1 | 3 | 13 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
819 | [829, 827, 821, 820, 828, 824, 826, 825, 823, 822] | Vanhuspalvelu | Äldreomsorg | Service for the elderly | 2018-08-07T14:00:27.946229+03:00 | 1 | 783 | {} | [] | 0 | 783 | 142 | 261 | 1 | 67 | 44 | 6 | 1 | |||||||||||||||||||||||||||||
825 | [] | Vanhusten palveluasuminen | Serviceboende för äldre | Service residence for the elderly | 760 | 2018-08-07T14:00:27.984445+03:00 | 2 | 819 | {} | [760] | 0 | 783 | 30 | 103 | 1 | 36 | 32 | 3 | 1 | ||||||||||||||||||||||||||||
839 | [2011, 841, 843, 2012] | Toimeentulotuki | Utkomststöd | Social assistance | 2018-08-07T14:00:28.080690+03:00 | 1 | 783 | {} | [] | 0 | 783 | 11 | 20 | 1 | 3 | 3 | 1 | 1 | |||||||||||||||||||||||||||||
843 | [] | Perustoimeentulotuki | Grundläggande utkomststöd | Basic social assistance | 711 | 2018-08-07T14:00:28.092481+03:00 | 2 | 839 | {} | [711] | 0 | 783 | 3 | 9 | 1 | 2 | 2 | 1 | |||||||||||||||||||||||||||||
845 | [848, 846, 847, 851, 857, 2160, 849, 852, 853, 854, 856, 858, 850, 855] | Muu sosiaalihuolto | Övrig socialvård | Other social welfare | 2018-08-07T14:00:28.112184+03:00 | 1 | 783 | {} | [] | 0 | 783 | 105 | 239 | 1 | 11 | 118 | 3 | 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 | ||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
1017 | [] | Laboratorio | Laboratorium | Laboratory | 366 | 2018-08-07T14:00:29.386729+03:00 | 1 | 986 | {} | [366] | 0 | 986 | 22 | 88 | 3 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 2 | 6 | 3 | 3 | 1 | 7 | 1 | 10 | 1 | 3 | 1 | 8 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | ||||||
1018 | [] | Röntgen | Röntgen | X-rays | 606 | 2018-08-07T14:00:29.396972+03:00 | 1 | 986 | {} | [606] | 0 | 986 | 11 | 42 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 1 | 1 | 6 | 1 | 1 | 1 | 1 | 1 | |||||||||||||
1087 | [2042, 1335, 2179, 1356, 1088, 1382, 1378, 1376, 1257, 1334, 1377, 1372, 1353, 1097, 1360, 1359] | Opetus ja koulutus | Undervisning och utbildning | Teaching and education | 2018-08-07T14:00:25.275863+03:00 | 0 | {} | [] | 0 | 1087 | 1214 | 1867 | 1 | 2 | 274 | 362 | 2 | 11 | 1 | ||||||||||||||||||||||||||||
1377 | [] | Oppilaan ja opiskelijan tuet | Förmåner för elever och studerande | Pupil and student benefits | 485 | 2018-08-07T14:00:27.654181+03:00 | 1 | 1087 | {} | [485] | 0 | 1087 | 4 | 15 | 1 | 7 | 2 | 1 | |||||||||||||||||||||||||||||
1 | [28, 57, 58, 59, 60, 74, 80, 73, 94, 95, 101, 97, 100, 102, 103, 115, 116] | Asumisympäristö | Boendemiljön | Housing environment | 2018-08-07T14:00:21.308151+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 1002 | 1524 | 2 | 2 | 294 | 218 | 6 | |||||||||||||||||||||||||||||
3 | [] | Asumisen sähköinen asiointi ja lomakkeet | Elektroniska tjänster och blanketter för boendeärenden | Electronic housing services and forms | 74 | 2018-08-07T14:00:21.236014+03:00 | 2 | 2 | {} | [74] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
7 | [] | Asuntotuotanto | Bostadsproduktion | Housing production | 79 | 2018-08-07T14:00:21.261214+03:00 | 2 | 2 | {} | [79] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
8 | [10, 9, 11] | Vuokra-asuminen | Hyresbostäder | Rental flats | 2018-08-07T14:00:21.267377+03:00 | 2 | 2 | {} | [] | 0 | 1400 | 9 | 13 | 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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
11 | [] | Opiskelija-asunnot | Studentbostäder | Student housing | 484 | 2018-08-07T14:00:21.287386+03:00 | 3 | 8 | {} | [484] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
14 | [16, 23] | Eläimet | Djur | Animals | 2018-08-07T14:00:21.679608+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 103 | 150 | 22 | 25 | ||||||||||||||||||||||||||||||||
16 | [17, 18, 19, 20, 21] | Koira-alueet | Hund områden | Dog areas | 2018-08-07T14:00:21.685399+03:00 | 2 | 14 | {} | [] | 0 | 1400 | 102 | 149 | 22 | 25 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
21 | [] | Opaskoira-aitaukset | Inhägnat områden för ledarhundar | Fenced areas for guide dogs | 480 | 2018-08-07T14:00:21.719558+03:00 | 3 | 16 | {} | [480] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
23 | [] | Luonnonvaraisten eläinten hoitola | Vårdanstalt för vilda djur | Wildlife home | 411 | 2018-08-07T14:00:21.732081+03:00 | 2 | 14 | {} | [411] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
24 | [25, 26, 27] | Energia | Energi | Energy | 2018-08-07T14:00:21.738244+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 6 | 7 | 1 | |||||||||||||||||||||||||||||||||
25 | [] | Asiakaspalvelu | Kundtjänst | Customer services | 62 | 2018-08-07T14:00:21.743023+03:00 | 2 | 24 | {} | [62] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
26 | [] | Energianeuvonta | Energirådgivning | Energy counselling | 146 | 2018-08-07T14:00:21.749651+03:00 | 2 | 24 | {} | [146] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
27 | [] | Voimalaitokset | Kraftverk | Power plants | 798 | 2018-08-07T14:00:21.755624+03:00 | 2 | 24 | {} | [798] | 0 | 1400 | 4 | 4 | |||||||||||||||||||||||||||||||||
28 | [29] | Hallinto | Förvaltning | Administration | 2018-08-07T14:00:21.313217+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
29 | [] | Ympäristölautakunta | Miljövårdsnämnden | Environment committee | 824 | 2018-08-07T14:00:21.318211+03:00 | 3 | 28 | {} | [824] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
31 | [32, 33, 34, 52, 53, 54] | Jätehuolto ja kierrätys | Avfallshantering och återvinning | Waste management and recycling | 2018-08-07T14:00:21.761620+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 215 | 572 | 1 | 150 | 186 | 20 | ||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
33 | [] | Jätteenkäsittelykeskus | Avfallshanteringscentral | Waste treatment centre | 234 | 2018-08-07T14:00:21.773147+03:00 | 2 | 31 | {} | [234] | 0 | 1400 | 1 | 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 );