service_node
939 rows where "last_modified_time" is on date 2018-08-07 sorted by name_en
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
622 | [] | Sulkapallohalli | Badmintonhall | Badminton hall | 647 | 2018-08-07T14:00:23.705272+03:00 | 4 | 614 | {} | [647] | 0 | 1403 | 9 | 18 | 5 | 4 | |||||||||||||||||||||||||||||||
659 | [] | Pallokenttä | Bollplan | Ball field | 495 | 2018-08-07T14:00:23.987386+03:00 | 4 | 654 | {} | [495] | 0 | 1403 | 408 | 743 | 169 | 161 | 5 | ||||||||||||||||||||||||||||||
654 | [655, 656, 657, 658, 659, 660, 661, 662] | Pallokentät | Bollplaner | Ball games courts | 2018-08-07T14:00:23.947305+03:00 | 3 | 633 | {} | [] | 0 | 1403 | 697 | 1266 | 1 | 283 | 273 | 1 | 11 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | |||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
660 | [] | Pesäpallostadion | Bobollsstadion | Baseball stadium | 511 | 2018-08-07T14:00:23.995997+03:00 | 4 | 654 | {} | [511] | 0 | 1403 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
1097 | [1187, 1255, 1098] | Perusopetus | Grundläggande utbildning | Basic education | 2018-08-07T14:00:25.451107+03:00 | 1 | 1087 | {} | [] | 0 | 1087 | 414 | 568 | 1 | 97 | 55 | 1 | ||||||||||||||||||||||||||||||
1338 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 652 | 2018-08-07T14:00:27.364989+03:00 | 3 | 1336 | {} | [652] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1345 | [] | Aikuisten peruskoulutus | Grundläggande utbildning för vuxna | Basic education for adults | 592 | 2018-08-07T14:00:27.412986+03:00 | 3 | 1343 | {} | [592] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1187 | [1246, 1249, 1193, 1192, 1188, 1190, 1242] | Ruotsinkielinen perusopetus | Grundläggande utbildning på svenska | Basic education in Swedish | 2018-08-07T14:00:26.251158+03:00 | 2 | 1097 | {} | [] | 0 | 1087 | 47 | 65 | 13 | 5 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
657 | [] | Koripallokenttä | Basketplan | Basketball court | 331 | 2018-08-07T14:00:23.971455+03:00 | 4 | 654 | {} | [331] | 0 | 1403 | 153 | 256 | 64 | 37 | 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 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
594 | [] | Ampumahiihtokeskus | Skidskyttecentrum | Biathlon centre | 53 | 2018-08-07T14:00:23.509751+03:00 | 4 | 592 | {} | [53] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
453 | [] | Pyöräkoulu | Cykelskola | Bicycle school | 541 | 2018-08-07T14:00:23.119521+03:00 | 3 | 368 | {} | [541] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
424 | [] | Lautapelit | Brädspel | Board games | 387 | 2018-08-07T14:00:23.039435+03:00 | 3 | 368 | {} | [387] | 0 | 1403 | 14 | 13 | 1 | ||||||||||||||||||||||||||||||||
700 | [] | Rantautumispaikka | Ilandstigningsplats | Boat dock | 571 | 2018-08-07T14:00:24.275183+03:00 | 4 | 695 | {} | [571] | 0 | 1403 | 2 | 2 | |||||||||||||||||||||||||||||||||
2143 | [] | Venekerhojen venepaikat | Båtklubbarnas båtplatser | Boat parking for yacht clubs | 847 | 2018-08-07T14:00:25.248772+03:00 | 4 | 547 | {} | [847] | 0 | 1402 | 1 | 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 | |||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||
677 | [681, 682, 683] | Veneurheilupaikat | Platser för båtsport | Boating sports facilities | 2018-08-07T14:00:24.115410+03:00 | 3 | 666 | {} | [] | 0 | 1403 | 4 | 5 | 1 | |||||||||||||||||||||||||||||||||
666 | [667, 675, 677] | Vene-, ilmailu- ja moottoriurheilu | Anläggningar för båtsport, flygsport och motorsport | Boating, aviation and motor sports | 2018-08-07T14:00:24.041279+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 9 | 18 | 3 | 6 | ||||||||||||||||||||||||||||||||
1078 | [] | Rajavartiolaitos | Gränsbevakningsväsendet | Border guard | 557 | 2018-08-07T14:00:29.900790+03:00 | 1 | 1061 | {} | [557] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
344 | [] | Kasvitieteelliset puutarhat | Botaniska trädgårdar | Botanic gardens | 248 | 2018-08-07T14:00:22.544317+03:00 | 2 | 343 | {} | [248] | 0 | 1403 | 3 | 3 | |||||||||||||||||||||||||||||||||
607 | [] | Keilahalli | Bowlinghall | Bowling alley | 285 | 2018-08-07T14:00:23.595829+03:00 | 4 | 606 | {} | [285] | 0 | 1403 | 7 | 11 | 2 | 2 | |||||||||||||||||||||||||||||||
606 | [607] | Keilahallit | Bowlinghallar | Bowling alleys | 2018-08-07T14:00:23.590235+03:00 | 3 | 601 | {} | [] | 0 | 1403 | 7 | 11 | 2 | 2 | ||||||||||||||||||||||||||||||||
449 | [] | Poikakerho / poikaryhmät | Pojkklubb / pojkgrupper | Boys' club / Boy groups | 518 | 2018-08-07T14:00:23.107321+03:00 | 3 | 368 | {} | [518] | 0 | 1403 | 1 | 16 | 14 | 1 | |||||||||||||||||||||||||||||||
279 | [281, 282, 283, 284, 285] | Rakennusvalvonta | Byggnadstillsyn | Building Control | 2018-08-07T14:00:22.376681+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 3 | 11 | 2 | 5 | 1 | |||||||||||||||||||||||||||||||
312 | [] | Rakennusvalvonnan arkisto | Byggnadstillsynsverkets arkiv | Building Control archive | 561 | 2018-08-07T14:00:24.689378+03:00 | 3 | 307 | {} | [561] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
285 | [] | Rakennusvalvontamittaukset | Byggnadstillsynsmätningar | Building control measurements | 563 | 2018-08-07T14:00:22.411827+03:00 | 4 | 279 | {} | [563] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
283 | [] | Rakennusrasitteet | Byggnadsservitut | Building easements | 559 | 2018-08-07T14:00:22.397931+03:00 | 4 | 279 | {} | [559] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
142 | [] | Elinkeinomarkkinointi | Näringslivmarknadsföring | Business marketing | 133 | 2018-08-07T14:00:30.132324+03:00 | 3 | 141 | {} | [133] | 0 | 1401 | 2 | 2 | |||||||||||||||||||||||||||||||||
726 | [] | Kahvila | Café | Cafe | 142*239 | 2018-08-07T14:00:24.455731+03:00 | 5 | 725 | {} | [239, 142] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
738 | [] | Kahvilat | Caféer | Cafés | 239 | 2018-08-07T14:00:24.505977+03:00 | 3 | 718 | {} | [239] | 0 | 1403 | 2 | 5 | 3 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
426 | [] | Leiritoiminta | Lägerverksamhet | Camping activities | 391 | 2018-08-07T14:00:23.046486+03:00 | 3 | 368 | {} | [391] | 0 | 1403 | 1 | 6 | 1 | 3 | 1 | ||||||||||||||||||||||||||||||
743 | [] | Leirintäalueet | Campingområden | Camping sites | 390 | 2018-08-07T14:00:24.541305+03:00 | 3 | 718 | {} | [390] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
586 | [] | Melontareitti | Paddlingsled | Canoe route | 434 | 2018-08-07T14:00:23.454892+03:00 | 4 | 577 | {} | [434] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
35 | [] | Akkujen keräys | Återvinning av bilbatterier | Car battery recycling | 45 | 2018-08-07T14:00:21.789985+03:00 | 3 | 34 | {"fi": ["akut"]} | [45] | 0 | 1400 | 34 | 79 | 18 | 26 | 1 | ||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
835 | [] | Päihdehuollon päivätoiminta | Dagverksamhet inom missbrukarvården | Care for substance abuse, daytime activities | 547 | 2018-08-07T14:00:28.047640+03:00 | 2 | 830 | {} | [547] | 0 | 783 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1056 | [] | Päihdehuollon päivätoiminta | Dagverksamhet inom missbrukarvården | Care for substance abuse, daytime activities | 547 | 2018-08-07T14:00:29.716393+03:00 | 2 | 1051 | {} | [547] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
837 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:28.061184+03:00 | 2 | 830 | {} | [544] | 0 | 783 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
1058 | [] | Päihdehuollon katkaisuhoito ja kuntoutus | Akutvård och rehabilitering inom missbrukarvården | Care for substance abuse, detoxification and rehabilitation treatment | 544 | 2018-08-07T14:00:29.732968+03:00 | 2 | 1051 | {} | [544] | 0 | 986 | 6 | 9 | 1 | 2 | |||||||||||||||||||||||||||||||
833 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:28.034805+03:00 | 2 | 830 | {} | [546] | 0 | 783 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
1054 | [] | Päihdehuollon polikliininen hoito | Poliklinisk vård inom missbrukarvården | Care for substance abuse, outpatient treatment | 546 | 2018-08-07T14:00:29.702337+03:00 | 2 | 1051 | {} | [546] | 0 | 986 | 12 | 17 | 3 | 2 | |||||||||||||||||||||||||||||||
836 | [] | Päihdehuollon asumispalvelut | Boendetjänster inom missbrukarvården | Care for substance abuse, residential services | 543 | 2018-08-07T14:00:28.054175+03:00 | 2 | 830 | {} | [543] | 0 | 783 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
1057 | [] | Päihdehuollon asumispalvelut | Boendetjänster inom missbrukarvården | Care for substance abuse, residential services | 543 | 2018-08-07T14:00:29.725065+03:00 | 2 | 1051 | {} | [543] | 0 | 986 | 1 | 15 | 7 | 7 | |||||||||||||||||||||||||||||||
832 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:28.028451+03:00 | 2 | 830 | {} | [548] | 0 | 783 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
1053 | [] | Päihdehuollon sosiaaliohjaus | Socialhandledning inom missbrukarvården | Care for substance abuse, social care work | 548 | 2018-08-07T14:00:29.695330+03:00 | 2 | 1051 | {} | [548] | 0 | 986 | 7 | 6 | 1 | ||||||||||||||||||||||||||||||||
831 | [] | Päihdehuollon sosiaalityö | Socialt arbete inom missbrukarvården | Care for substance abuse, social work | 549 | 2018-08-07T14:00:28.021758+03:00 | 2 | 830 | {} | [549] | 0 | 783 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
1052 | [] | Päihdehuollon sosiaalityö | Socialt arbete inom missbrukarvården | Care for substance abuse, social work | 549 | 2018-08-07T14:00:29.687959+03:00 | 2 | 1051 | {} | [549] | 0 | 986 | 1 | 4 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
834 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:28.041229+03:00 | 2 | 830 | {} | [545] | 0 | 783 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
1055 | [] | Päihdehuollon korvaushoito | Substitutionsbehandling inom missbrukarvården | Care for substance abuse, substitute treatment | 545 | 2018-08-07T14:00:29.709367+03:00 | 2 | 1051 | {} | [545] | 0 | 986 | 4 | 5 | 1 | ||||||||||||||||||||||||||||||||
810 | [815, 816, 817, 813, 812, 811, 818, 814, 1007] | Kehitysvammahuolto | Vård av utvecklingsstörda | Care for the developmentally disabled | 2018-08-07T14:00:27.882619+03:00 | 1 | 783 | {} | [] | 0 | 783 | 56 | 109 | 12 | 36 | 2 | 3 | ||||||||||||||||||||||||||||||
827 | [] | Vanhuspalvelun omaishoidon tuki | Stöd för närståendevårdare inom äldreomsorgen | Care for the elderly, close relative care support | 759 | 2018-08-07T14:00:27.996868+03:00 | 2 | 819 | {} | [759] | 0 | 783 | 4 | 8 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||
813 | [] | Kehitysvammahuollon päivätoiminta | Dagverksamhet inom vård av utvecklingsstörda | Care of the developmentally disabled, daytime activities | 278 | 2018-08-07T14:00:27.899777+03:00 | 2 | 810 | {} | [278] | 0 | 783 | 10 | 18 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||
814 | [] | Kehitysvammahuollon työllistämispalvelut | Sysselsättningstjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, employment services | 282 | 2018-08-07T14:00:27.906450+03:00 | 2 | 810 | {} | [282] | 0 | 783 | 5 | 6 | 1 | ||||||||||||||||||||||||||||||||
818 | [] | Kehitysvammahuollon taloudellinen tuki | Ekonomiskt stöd inom vård av utvecklingsstörda | Care of the developmentally disabled, financial support | 281 | 2018-08-07T14:00:27.931547+03:00 | 2 | 810 | {} | [281] | 0 | 783 | 2 | 4 | 2 | ||||||||||||||||||||||||||||||||
816 | [] | Kehitysvammahuollon laitospalvelu | Institutionsservice inom vård av utvecklingsstörda | Care of the developmentally disabled, institutional service | 276 | 2018-08-07T14:00:27.919212+03:00 | 2 | 810 | {} | [276] | 0 | 783 | 4 | 4 | |||||||||||||||||||||||||||||||||
815 | [] | Kehitysvammahuollon asumispalvelut | Boendetjänster inom vård av utvecklingsstörda | Care of the developmentally disabled, residential services | 275 | 2018-08-07T14:00:27.912869+03:00 | 2 | 810 | {} | [275] | 0 | 783 | 39 | 71 | 9 | 21 | 1 | 1 | |||||||||||||||||||||||||||||
812 | [] | Kehitysvammahuollon sosiaaliohjaus | Socialhandledning inom omsorger om utvecklingsstörda | Care of the developmentally disabled, social care work | 279 | 2018-08-07T14:00:27.893701+03:00 | 2 | 810 | {} | [279] | 0 | 783 | 1 | 1 | |||||||||||||||||||||||||||||||||
811 | [] | Kehitysvammahuollon sosiaalityö | Socialt arbete inom vård av utvecklingsstörda | Care of the developmentally disabled, social work | 280 | 2018-08-07T14:00:27.887549+03:00 | 2 | 810 | {} | [280] | 0 | 783 | 3 | 9 | 5 | 1 | |||||||||||||||||||||||||||||||
817 | [] | Kehitysvammahuollon loma- ja harrastustoiminta | Ferie- och fritidsverksamhet inom omsorger om utvecklingsstörda | Care of the developmentally disabled, vacation and leisure activities | 277 | 2018-08-07T14:00:27.925241+03:00 | 2 | 810 | {} | [277] | 0 | 783 | 3 | 6 | 3 | ||||||||||||||||||||||||||||||||
59 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:21.345565+03:00 | 2 | 1 | {} | [432] | 0 | 1400 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
361 | [] | Matonpesupaikat | Mattvättningsplatser | Carpet washing places | 432 | 2018-08-07T14:00:22.659080+03:00 | 2 | 343 | {} | [432] | 0 | 1403 | 13 | 29 | 5 | 11 | |||||||||||||||||||||||||||||||
504 | [] | Ruoka - ja cateringpalvelut | Catering | Catering | 587 | 2018-08-07T14:00:22.784722+03:00 | 2 | 343 | {} | [587] | 0 | 1403 | 4 | 2 | 2 | ||||||||||||||||||||||||||||||||
764 | [] | Keskusvaalilautakunta | Centralvalnämnd | Central Election Committee | 290 | 2018-08-07T14:00:30.827173+03:00 | 4 | 763 | {} | [290] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
178 | [] | Keskitetyt tietotekniikkapalvelut | Centraliserade datatekniktjänster | Centralised services on information technology | 222 | 2018-08-07T14:00:30.449039+03:00 | 2 | 171 | {} | [222] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
533 | [] | Sähköautojen latauspisteet | Laddstationer för elbilar | Charging stations for electric vehicles | 669 | 2018-08-07T14:00:25.139376+03:00 | 2 | 512 | {} | [669] | 0 | 1402 | 31 | 37 | 6 | ||||||||||||||||||||||||||||||||
788 | [] | Lastensuojelun sosiaalityö | Socialt arbete inom barnskyddet | Child welfare social work | 382 | 2018-08-07T14:00:27.731506+03:00 | 2 | 787 | {} | [382] | 0 | 783 | 25 | 42 | 9 | 7 | 1 | ||||||||||||||||||||||||||||||
253 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:22.189946+03:00 | 3 | 231 | {} | [467] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
1071 | [] | Nuohous | Sotning | Chimney sweeping | 467 | 2018-08-07T14:00:29.851905+03:00 | 2 | 1070 | {} | [467] | 0 | 1061 | 1 | 1 | |||||||||||||||||||||||||||||||||
350 | [] | Kirkot ja muut uskonnolliset tilat | Kyrkor och andra religiösa byggnader | Churches and other religious buildings | 314 | 2018-08-07T14:00:22.584521+03:00 | 2 | 343 | {} | [314] | 0 | 1403 | 63 | 86 | 3 | 19 | 1 | ||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
309 | [] | Kaupunginarkiston asiakaspalvelu | Stadsarkivets kundtjänst | City Archives customer service | 65 | 2018-08-07T14:00:24.669496+03:00 | 3 | 307 | {} | [65] | 0 | 1402 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
193 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.534760+03:00 | 3 | 191 | {} | [272] | 0 | 1401 | 2 | 4 | 1 | 1 | |||||||||||||||||||||||||||||||
759 | [] | Kaupunginhallitus | Stadsstyrelsen | City Board | 272 | 2018-08-07T14:00:30.780581+03:00 | 4 | 757 | {} | [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 | ||||||||||||||||||||||||||||||
760 | [] | Kaupunginvaltuusto | Stadsfullmäktige | City Council | 273 | 2018-08-07T14:00:30.790348+03:00 | 4 | 757 | {} | [273] | 0 | 1401 | 2 | 5 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||
1011 | [] | Kaupungin psykiatrinen sairaala | Stadens psykiatriska sjukhus | City Psychiatric Hospital | 263 | 2018-08-07T14:00:29.322493+03:00 | 2 | 1009 | {} | [263] | 0 | 986 | 2 | 2 | |||||||||||||||||||||||||||||||||
2003 | [] | Kaupungintalot | Stadshus | City halls | 270 | 2018-08-07T14:00:30.383310+03:00 | 4 | 173 | {} | [270] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
1012 | [] | Kaupunginsairaalat | Stadssjukhus | City hospitals | 264 | 2018-08-07T14:00:29.330351+03:00 | 2 | 1009 | {} | [264] | 0 | 986 | 9 | 11 | 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 | ||||||||||||||||||||||||||||||||
248 | [] | 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:22.155735+03:00 | 4 | 245 | {} | [267] | 0 | 1400 | 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 | |||||||||||||||||||||||||||||||
247 | [] | Kaupungin tai kunnan vuokra-asunnot | Stadens eller kommunens hyresbostäder | City's or municipality's rental apartments | 268 | 2018-08-07T14:00:22.149025+03:00 | 4 | 245 | {} | [268] | 0 | 1400 | 9 | 12 | 2 | 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 | |||||||||||||||||||||||||||||||||
302 | [303] | Yhdyskuntarakentaminen | Samhällsbyggnad | Civil engineering | 2018-08-07T14:00:22.510499+03:00 | 3 | 270 | {} | [] | 0 | 1400 | 1 | 1 | ||||||||||||||||||||||||||||||||||
774 | [] | Siviilivihkiminen | Civil vigsel | Civil marriage | 628 | 2018-08-07T14:00:30.898033+03:00 | 4 | 770 | {} | [628] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
254 | [] | Siivouspalvelut | Städningsservice | Cleaning services | 621 | 2018-08-07T14:00:22.196172+03:00 | 3 | 231 | {} | [621] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
54 | [] | Rantavesien ja sisäsaariston puhtaanapito | Renhållning av strandvatten och inre skärgård | Cleaning waterfronts and inner archipelago | 572 | 2018-08-07T14:00:21.940289+03:00 | 2 | 31 | {} | [572] | 0 | 1400 | 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 );