service_node
1,140 rows sorted by name_sv descending
This data as json, CSV (advanced)
last_modified_time (date) ✖
- 2018-08-07 858
- 2018-10-25 82
- 2020-03-06 16
- 2020-11-18 12
- 2018-10-24 10
- 2020-06-09 9
- 2019-03-05 8
- 2020-06-22 8
- 2020-12-02 4
- 2018-08-31 3
- 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
- 2020-05-08 2
- 2020-08-20 2
- 2020-09-01 2
- 2019-04-11 1
- 2019-08-22 1
- 2019-08-23 1
- 2019-09-02 1
- 2020-01-02 1
- 2020-02-12 1
- 2020-05-25 1
- 2020-10-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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||
74 | [76, 77, 78, 75, 79, 2205] | Tiet ja kadut | Vägar och gator | Roads and streets | 2018-08-07T14:00:21.451762+03:00 | 2 | 1 | {} | [] | 0 | 1400 | 356 | 376 | 3 | 16 | 1 | |||||||||||||||||||||||||||||||
534 | [536, 537, 538, 535, 539, 2206] | Tiet ja kadut | Vägar och gator | Roads and streets | 2018-08-07T14:00:25.145762+03:00 | 2 | 512 | {} | [] | 0 | 1402 | 356 | 376 | 3 | 16 | 1 | |||||||||||||||||||||||||||||||
1335 | [1343, 1336] | Aikuiskoulutus | Vuxenutbildning | Adult education | 2018-08-07T14:00:27.345252+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 5 | 11 | 2 | 3 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
567 | [568, 569] | Katetut talviurheilupaikat | Vintersportplatser under tak | Covered winter sports facilities | 2018-08-07T14:00:23.339639+03:00 | 3 | 558 | {} | [] | 0 | 1403 | 2 | 2 | ||||||||||||||||||||||||||||||||||
549 | [] | Veneiden talvisäilytys | Vinterförvaring av båtar | Winter storage for boats | 768 | 2018-08-07T14:00:25.255633+03:00 | 4 | 547 | {} | [768] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
687 | [] | Talviuintipaikka | Vinterbadplats | Winter swimming area | 684 | 2018-08-07T14:00:24.182493+03:00 | 4 | 685 | {} | [684] | 0 | 1403 | 13 | 23 | 8 | 2 | |||||||||||||||||||||||||||||||
697 | [] | Laavu, kota tai kammi | Vindskydd eller kåta | Lean-to, goahti (Lapp tent shelter) or 'kammi' earth lodge | 365 | 2018-08-07T14:00:24.250943+03:00 | 4 | 695 | {} | [365] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
1363 | [] | Opetuspaikat | Verksamhetsställen | Teaching locations | 665*727 | 2020-11-18T07:30:12.858775+02:00 | 3 | 1361 | {} | [727, 665] | 0 | 1087 | 44 | 46 | 1 | 1 | |||||||||||||||||||||||||||||||
1367 | [] | Opetuspaikat | Verksamhetsställen | Teaching locations | 605*727 | 2020-11-18T07:30:12.891173+02:00 | 3 | 1365 | {} | [727, 605] | 0 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
485 | [] | Viikonlopputoiminta | Veckoslutsverksamhet | Weekend activities | 789 | 2018-08-07T14:00:23.188643+03:00 | 3 | 368 | {} | [789] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
91 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:21.983685+03:00 | 2 | 85 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
299 | [] | Vedenpuhdistuslaitos | Vattenreningsverket | Water treatment plant | 766 | 2018-08-07T14:00:22.497732+03:00 | 4 | 293 | {} | [766] | 0 | 1400 | 2 | 2 | |||||||||||||||||||||||||||||||||
85 | [87, 88, 91, 93] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:21.953530+03:00 | 1 | 1400 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
293 | [295, 296, 299, 301] | Vesihuolto | Vattenförsörjning | Water services | 2018-08-07T14:00:22.465138+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 30 | 32 | 1 | 1 | ||||||||||||||||||||||||||||||||
93 | [] | Vesilaskut ja asiakaspalvelu | Vattenfakturering och kundtjänst | Billing for water and customer services | 67+781 | 2018-10-24T20:30:07.186738+03:00 | 2 | 85 | {} | [781, 67] | 0 | 1400 | 26 | 26 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
730 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 142*776 | 2018-08-07T14:00:24.485125+03:00 | 4 | 719 | {} | [776, 142] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
2144 | [] | Vesibussilaiturit | Vattenbussbryggor | Water bus platforms | 776 | 2018-08-07T14:00:25.224191+03:00 | 4 | 542 | {} | [776] | 0 | 1402 | 3 | 3 | |||||||||||||||||||||||||||||||||
763 | [764, 765] | Vaalit ja äänestäminen | Val och röstning | Elections and voting | 2018-08-07T14:00:30.816923+03:00 | 3 | 756 | {} | [] | 0 | 1401 | 2 | 4 | 1 | 1 | ||||||||||||||||||||||||||||||||
357 | [] | Näyttelytilat | Utställningslokaler | Exhibition spaces | 474 | 2018-08-07T14:00:22.630116+03:00 | 3 | 352 | {} | [474] | 0 | 1403 | 105 | 114 | 7 | 2 | |||||||||||||||||||||||||||||||
631 | [] | Telinevoimistelutila | Utrymme för redskapsgymnastik | Artistic gymnastics facility | 697 | 2018-08-07T14:00:23.775695+03:00 | 4 | 624 | {} | [697] | 0 | 1403 | 6 | 15 | 5 | 4 | |||||||||||||||||||||||||||||||
625 | [] | Miekkailutila | Utrymme för fäktning | Fencing venue | 439 | 2018-08-07T14:00:23.729643+03:00 | 4 | 624 | {} | [439] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
633 | [634, 639, 646, 654, 663] | Ulkokentät ja liikuntapuistot | Utomhusplaner och idrottsparker | Outdoor fields and sports parks | 2018-08-07T14:00:23.790680+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 1261 | 2383 | 1 | 1 | 636 | 457 | 4 | 23 | ||||||||||||||||||||||||||||
574 | [] | Ulkokiipeilyseinä | Utomhusklättervägg | Open-air climbing wall | 736 | 2018-08-07T14:00:23.381720+03:00 | 4 | 572 | {} | [736] | 0 | 1403 | 5 | 10 | 5 | ||||||||||||||||||||||||||||||||
374 | [] | Av- ja leirivälinelainaamo | Utlåning av AV-utrustning och campingutrustning | Loaning service for audiovisual and camping equipment | 81 | 2018-08-07T14:00:22.905139+03:00 | 3 | 368 | {} | [81] | 0 | 1403 | 3 | 4 | 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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
139 | [] | Maa-alueiden vuokraus ja myynti | Uthyrning och försäljning av markområden | Selling or renting land areas | 419 | 2018-08-07T14:00:30.113920+03:00 | 3 | 134 | {} | [419] | 0 | 1401 | 17 | 17 | |||||||||||||||||||||||||||||||||
251 | [] | Maa-alueiden vuokraus ja myynti | Uthyrning och försäljning av markområden | Selling or renting land areas | 419 | 2018-08-07T14:00:22.176075+03:00 | 4 | 245 | {} | [419] | 0 | 1400 | 17 | 17 | |||||||||||||||||||||||||||||||||
137 | [] | Asuntotonttien vuokraus ja myynti | Uthyrning och försäljning av bostadstomter | Selling or renting residential lots | 78 | 2018-08-07T14:00:30.100472+03:00 | 3 | 134 | {} | [78] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
249 | [] | Asuntotonttien vuokraus ja myynti | Uthyrning och försäljning av bostadstomter | Selling or renting residential lots | 78 | 2018-08-07T14:00:22.162414+03:00 | 4 | 245 | {} | [78] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
148 | [] | Torimyyntipaikkojen vuokraus | Uthyrning av torgförsäljningsplatser | Market square vending stall rental | 713 | 2018-08-07T14:00:30.169994+03:00 | 3 | 146 | {} | [713] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
257 | [] | Torimyyntipaikkojen vuokraus | Uthyrning av torgförsäljningsplatser | Market square vending stall rental | 713 | 2018-08-07T14:00:22.214641+03:00 | 4 | 255 | {} | [713] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
161 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:30.270249+03:00 | 4 | 156 | {} | [706] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
268 | [] | Teurastamotilojen vuokraus | Uthyrning av slakterilokaler | Slaughterhouse rental | 706 | 2018-08-07T14:00:22.300791+03:00 | 5 | 265 | {} | [706] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
158 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:30.238264+03:00 | 4 | 156 | {} | [718] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
2022 | [] | Tuotantotilojen vuokraus | Uthyrning av produktionslokaler | Production facility rental | 718 | 2018-08-07T14:00:22.279273+03:00 | 5 | 265 | {} | [718] | 0 | 1400 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
162 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:30.280128+03:00 | 4 | 156 | {} | [788] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
269 | [] | Vihertukkutilojen vuokraus | Uthyrning av lokaler för grönsaksgrossister | Green wholesale trade space rental | 788 | 2018-08-07T14:00:22.308088+03:00 | 5 | 265 | {} | [788] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
159 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:30.247429+03:00 | 4 | 156 | {} | [765] | 0 | 1401 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
2023 | [] | Varastotilojen vuokraus | Uthyrning av lagerlokaler | Storage space rental | 765 | 2018-08-07T14:00:22.286375+03:00 | 5 | 265 | {} | [765] | 0 | 1400 | 3 | 4 | 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 | ||||||||||||||||||||||||||||||||
256 | [] | Kauppahallimyyntipaikkojen vuokraus | Uthyrning av försäljningsplatser i saluhallar | Market hall sales location leasing | 258 | 2018-08-07T14:00:22.208042+03:00 | 4 | 255 | {} | [258] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
160 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:30.257660+03:00 | 4 | 156 | {} | [494] | 0 | 1401 | 1 | 1 | |||||||||||||||||||||||||||||||||
267 | [] | Pakastamotilojen vuokraus | Uthyrning av fryslokaler | Cold storage space rental | 494 | 2018-08-07T14:00:22.293996+03:00 | 5 | 265 | {} | [494] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
157 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:30.231632+03:00 | 4 | 156 | {} | [393] | 0 | 1401 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
2021 | [] | Liike- ja toimistotilojen vuokraus | Uthyrning av affärs- och kontorslokaler | Commercial and office space rental | 393 | 2018-08-07T14:00:22.272146+03:00 | 5 | 265 | {} | [393] | 0 | 1400 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
713 | [] | Retkeilyalue | Utflyktsområde | Hiking area | 581 | 2018-08-07T14:00:24.359089+03:00 | 4 | 706 | {} | [581] | 0 | 1403 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
590 | [] | Retkeilyreitti | Utflyktsled | Hiking route | 582 | 2018-08-07T14:00:23.482263+03:00 | 4 | 577 | {} | [582] | 0 | 1403 | 4 | 19 | 2 | 8 | 5 | ||||||||||||||||||||||||||||||
685 | [686, 687, 688, 689] | Maauimalat ja uimarannat | Utebassänger och badstränder | Open air pools and beaches | 2018-08-07T14:00:24.169221+03:00 | 3 | 684 | {} | [] | 0 | 1403 | 43 | 98 | 4 | 39 | 8 | 4 | ||||||||||||||||||||||||||||||
686 | [] | Maauimala | Utebassäng | Open-air pool | 426 | 2018-08-07T14:00:24.174926+03:00 | 4 | 685 | {} | [426] | 0 | 1403 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||||
1043 | [] | Omahoitotarvikejakelu | Utdelning av egenvårdsartiklar | Distribution of self-care supplies | 477 | 2018-08-07T14:00:29.623935+03:00 | 1 | 986 | {"fi": ["diabetes", "hoitotarvike", "hoitotarvikkeet", "haavanhoito", "vaippa", "vaipat", "tarvikejakelu", "ilmaisjakelu", "ilmaistarvike", "hoitov\u00e4lineet"]} | [477] | 0 | 986 | 1 | 6 | 3 | 2 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
177 | [] | Hankintapalvelut | Upphandlingstjänster | Procurement services | 217 | 2018-08-07T14:00:30.442764+03:00 | 2 | 171 | {} | [217] | 0 | 1401 | 1 | 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 | ||||||||||||||||||||||||||||||||
1010 | [] | Yliopistolliset sairaalat | Universitetssjukhus | University hospitals | 820 | 2018-08-07T14:00:29.314677+03:00 | 2 | 1009 | {} | [820] | 0 | 986 | 18 | 31 | 1 | 1 | 4 | 2 | 3 | 2 | |||||||||||||||||||||||||||
2194 | [] | Yliopistojen kirjastot | Universitetsbibliotek | University libraries | 879 | 2019-03-20T13:30:07.460582+02:00 | 3 | 324 | {} | [879] | 0 | 1403 | 10 | 11 | 1 | ||||||||||||||||||||||||||||||||
2197 | [] | Yliopistojen kirjastot | Universitetsbibliotek | University libraries | 879 | 2019-04-02T13:30:07.786077+03:00 | 3 | 345 | {} | [879] | 0 | 1403 | 10 | 11 | 1 | ||||||||||||||||||||||||||||||||
1359 | [] | Yliopistot | Universitet | Universities | 822 | 2018-08-07T14:00:27.510881+03:00 | 1 | 1087 | {} | [822] | 0 | 1087 | 10 | 60 | 50 | ||||||||||||||||||||||||||||||||
1334 | [] | Nuorten työpajatoiminta | Ungdomsverkstäder | Workshops for the young | 472 | 2018-08-07T14:00:27.336955+03:00 | 1 | 1087 | {} | [472] | 1 | 1087 | 9 | 17 | 8 | ||||||||||||||||||||||||||||||||
154 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:30.213017+03:00 | 4 | 149 | {} | [803] | 0 | 1401 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
263 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.252638+03:00 | 5 | 258 | {} | [803] | 0 | 1400 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
366 | [] | Nuorisotalot | Ungdomsgårdar | Youth centres | 468 | 2018-08-07T14:00:22.869007+03:00 | 2 | 365 | {} | [468] | 0 | 1403 | 39 | 69 | 16 | 13 | 1 | ||||||||||||||||||||||||||||||
510 | [] | Nuorisotilat | Ungdomsgårdar | Youth facilities | 803 | 2018-08-07T14:00:22.836894+03:00 | 3 | 505 | {} | [803] | 0 | 1403 | 17 | 16 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1340 | [] | Aikuisten lukioaineiden opetus | Undervisning i gymnasiets läroämnen för vuxna | Education on upper secondary school subjects for adults | 649 | 2018-08-07T14:00:27.379870+03:00 | 3 | 1336 | {} | [649] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1346 | [] | Aikuisten lukioaineiden opetus | Undervisning i gymnasiets läroämnen för vuxna | Education on upper secondary school subjects for adults | 589 | 2018-08-07T14:00:27.419564+03:00 | 3 | 1343 | {} | [589] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1341 | [] | Aikuisten peruskouluaineiden opetus | Undervisning i grundskolans läroämnen för vuxna | Education on comprehensive school subjects for adults | 651 | 2018-08-07T14:00:27.386151+03:00 | 3 | 1336 | {} | [651] | 1 | 1087 | 3 | 3 | |||||||||||||||||||||||||||||||||
1347 | [] | Aikuisten peruskouluaineiden opetus | Undervisning i grundskolans läroämnen för vuxna | Education on comprehensive school subjects for adults | 591 | 2018-08-07T14:00:27.426296+03:00 | 3 | 1343 | {} | [591] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
219 | [220] | Tuet ja avustukset | Understöd och bidrag | Grants and benefits | 715 | 2018-08-07T14:00:30.723645+03:00 | 2 | 171 | {} | [715] | 0 | 1401 | 3 | 2 | 1 | ||||||||||||||||||||||||||||||||
604 | [] | Kilpajäähalli | Tävlingsishall | Competition ice arena | 308 | 2018-08-07T14:00:23.575267+03:00 | 4 | 602 | {} | [308] | 0 | 1403 | 2 | 7 | 2 | 2 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
937 | [938] | Saksankielinen päivähoito | Tyskspråkig dagvård | Day care in German | 614 | 2018-08-07T14:00:28.671882+03:00 | 3 | 869 | {} | [614] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
316 | [] | Matkailuneuvonta | Turistinformation | Tourism information | 429 | 2018-08-07T14:00:24.717090+03:00 | 3 | 314 | {} | [429] | 0 | 1402 | 2 | 12 | 6 | 4 | |||||||||||||||||||||||||||||||
744 | [] | Matkailuneuvonta | Turistinformation | Tourism information | 429 | 2018-08-07T14:00:24.548312+03:00 | 3 | 718 | {} | [429] | 0 | 1403 | 2 | 12 | 6 | 4 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||
1081 | [] | Tullin asiointipisteet | Tullens verksamhetsställen | Customs offices | 716 | 2018-08-07T14:00:29.921102+03:00 | 2 | 1080 | {} | [716] | 0 | 1061 | 4 | 7 | 1 | 2 | |||||||||||||||||||||||||||||||
1080 | [1081] | Tulli | Tullen | Customs | 2018-08-07T14:00:29.915254+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 4 | 7 | 1 | 2 | ||||||||||||||||||||||||||||||||
330 | [331, 332] | Langaton internet, wlan | Trådlöst internet, wlan | Wireless internet, wlan | 2018-10-25T08:00:07.331877+03:00 | 3 | 329 | {} | [] | 0 | 1402 | 233 | 240 | 7 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
99 | [] | Puutarhapalvelut | Trädgårdstjänster | Gardening services | 533 | 2018-08-07T14:00:21.548578+03:00 | 3 | 97 | {} | [533] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
47 | [] | Puujäte | Träavfall | Wood waste | 531 | 2018-08-07T14:00:21.882472+03:00 | 3 | 34 | {} | [531] | 0 | 1400 | 2 | 5 | 2 | 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 );