service_node
939 rows where "last_modified_time" is on date 2018-08-07 sorted by name_sv
This data as json, CSV (advanced)
Suggested facets: level, keywords, period_enabled, root, unit_count_municipality_sipoo, unit_count_municipality_nurmijärvi, unit_count_municipality__unknown, unit_count_municipality_inkoo, unit_count_municipality_lohja, unit_count_municipality_tuusula, unit_count_municipality_kirkkonummi, unit_count_municipality_hamina, unit_count_municipality_loviisa, 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
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ää |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306 | [] | A-englanti | A-engelska | A-English | 598*4 | 2018-08-07T14:00:27.131698+03:00 | 4 | 1303 | {} | [598, 4] | 1 | 1087 | 2 | 3 | 1 | ||||||||||||||||||||||||||||||||
1304 | [] | A-suomi | A-finska | A-Finnish | 598*13 | 2018-08-07T14:00:27.116631+03:00 | 4 | 1303 | {} | [598, 13] | 1 | 1087 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
1312 | [] | A-ranska | A-franska | A-French | 598*10 | 2018-08-07T14:00:27.175551+03:00 | 4 | 1303 | {} | [598, 10] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
1313 | [] | A-saksa | A-tyska | A-German | 598*12 | 2018-08-07T14:00:27.183391+03:00 | 4 | 1303 | {} | [598, 12] | 1 | 1087 | 1 | 1 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
1020 | [] | Akuuttipsykiatria | Akutpsykiatri | Acute psychiatry | 46 | 2018-08-07T14:00:29.412887+03:00 | 2 | 1019 | {} | [46] | 0 | 986 | 1 | 4 | 3 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
617 | [] | Monitoimihalli / areena | Allaktivitetshall/multiarena | Multipurpose hall/arena | 444 | 2018-08-07T14:00:23.665496+03:00 | 4 | 614 | {} | [444] | 0 | 1403 | 97 | 133 | 36 | ||||||||||||||||||||||||||||||||
355 | [] | Kulttuurin monitoimitalot | Allaktivitetshus för kultur | Multi-functional culture venues | 345 | 2018-08-07T14:00:22.617002+03:00 | 3 | 352 | {} | [345] | 0 | 1403 | 8 | 18 | 3 | 5 | 2 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
668 | [] | Jokamies- ja rallicross -rata | Allemans- och rallycrossbana | Everyman racing and rallycross track | 208 | 2018-08-07T14:00:24.052754+03:00 | 4 | 667 | {} | [208] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
1086 | [] | Yleiset väestönsuojat | Allmänna befolkningsskyddsrum | General public shelters | 815 | 2018-08-07T14:00:29.980338+03:00 | 2 | 1083 | {} | [815] | 0 | 1061 | 27 | 29 | 2 | ||||||||||||||||||||||||||||||||
532 | [] | Yleiset pysäköintialueet | Allmänna parkeringsområden | Public parking lot | 814 | 2018-08-07T14:00:25.132843+03:00 | 3 | 526 | {} | [814] | 0 | 1402 | 1 | 346 | 343 | 2 | |||||||||||||||||||||||||||||||
1066 | [1069, 1068, 1067] | Muut turvallisuuspalvelut | Andra säkerhetstjänster | Other safety services | 2018-08-07T14:00:29.808816+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 3 | 5 | 1 | 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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
601 | [602, 606, 608, 614, 624] | Sisäliikuntatilat | Anläggningar för inomhusidrott | Indoor sports facilities | 2018-08-07T14:00:23.557871+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 795 | 1314 | 278 | 229 | 12 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||
684 | [685, 690] | Vesiliikuntapaikat | Anläggningar för vattenidrott | Water sports facilities | 2018-08-07T14:00:24.163817+03:00 | 2 | 551 | {} | [] | 0 | 1403 | 78 | 153 | 4 | 51 | 15 | 4 | 1 | |||||||||||||||||||||||||||||
712 | [] | Muu luonnonsuojelualue, jolla on virkistyspalveluita | Annat naturskyddsområde med rekreationstjänster | Other nature conservation area with recreational services | 458 | 2018-08-07T14:00:24.351095+03:00 | 4 | 706 | {} | [458] | 0 | 1403 | 1 | 1 | |||||||||||||||||||||||||||||||||
2028 | [] | Tapahtumien järjestäminen | Anordnande av evenemang | Organising events | 845 | 2018-08-07T14:00:24.640373+03:00 | 2 | 717 | {} | [845] | 0 | 1403 | 2 | 6 | 3 | 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 | |||||||||||||||||||||||||||||||||
327 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:24.845380+03:00 | 3 | 324 | {} | [368] | 0 | 1402 | 8 | 8 | |||||||||||||||||||||||||||||||||
348 | [] | Laitoskirjastot | Anstaltsbibliotek | Institutional libraries | 368 | 2018-08-07T14:00:22.571974+03:00 | 3 | 345 | {} | [368] | 0 | 1403 | 8 | 8 | |||||||||||||||||||||||||||||||||
164 | [] | Työsuhdeasiat | Anställningsfrågor | Employment matters | 725 | 2018-08-07T14:00:30.298491+03:00 | 2 | 122 | {} | [725] | 0 | 1401 | 3 | 5 | 1 | 1 | |||||||||||||||||||||||||||||||
990 | [] | Apteekki | Apotek | Pharmacy | 57 | 2018-08-07T14:00:29.143841+03:00 | 1 | 986 | {} | [57] | 0 | 986 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||
897 | [903, 898] | Arabiankielinen päivähoito | Arabiskspråkig dagvård | Day care in Arabic | 58 | 2018-08-07T14:00:28.436562+03:00 | 3 | 869 | {} | [58] | 0 | 1405 | 2 | 2 | |||||||||||||||||||||||||||||||||
163 | [] | Työ- ja elinkeinotoimistot | Arbets- och näringsbyråer | Employment and economic development offices | 723 | 2018-08-07T14:00:30.289431+03:00 | 2 | 122 | {} | [723] | 0 | 1401 | 3 | 7 | 1 | 3 | |||||||||||||||||||||||||||||||
165 | [] | Työttömyys | Arbetslöshet | Unemployment | 464 | 2018-08-07T14:00:30.308304+03:00 | 2 | 122 | {} | [464] | 0 | 1401 | 4 | 8 | 1 | 3 | |||||||||||||||||||||||||||||||
850 | [] | Työhön kuntoutus- ja työllistämispalvelut | Arbetsrehabiliterings- och sysselsättningstjänster | Rehabilitation and employment services for work | 638 | 2018-08-07T14:00:28.151060+03:00 | 2 | 845 | {} | [638] | 0 | 783 | 4 | 12 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
851 | [] | Kuntouttava työtoiminta | Arbetsverksamhet i rehabiliterande syfte | Rehabilitative work | 351 | 2018-08-07T14:00:28.157405+03:00 | 2 | 845 | {} | [351] | 0 | 783 | 34 | 43 | 1 | 8 | |||||||||||||||||||||||||||||||
307 | [308, 313, 309, 310, 312] | Arkistot | Arkiv | Archives | 2018-08-07T14:00:24.657353+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 4 | 11 | 2 | 4 | 1 | |||||||||||||||||||||||||||||||
313 | [] | Katu-, puisto- ja rakennuspiirustusten arkisto | Arkiv för gatu-, park- och byggnadsritningar | Public works department archive | 250 | 2018-08-07T14:00:24.696359+03:00 | 3 | 307 | {} | [250] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
138 | [] | Liike- ja toimistotonttien vuokraus ja myynti | Arrendering och försäljning av affärs- och kontorstomter | Leasing and selling of commercial and office plots | 394 | 2018-08-07T14:00:30.106922+03:00 | 3 | 134 | {} | [394] | 0 | 1401 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
250 | [] | Liike- ja toimistotonttien vuokraus ja myynti | Arrendering och försäljning av affärs- och kontorstomter | Leasing and selling of commercial and office plots | 394 | 2018-08-07T14:00:22.168975+03:00 | 4 | 245 | {} | [394] | 0 | 1400 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
780 | [] | Perinnönjako | Arvskifte | Distribution of estate | 508 | 2018-08-07T14:00:30.947784+03:00 | 3 | 769 | {} | [508] | 0 | 1401 | 1 | 2 | 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 | ||||||||||||||||||||||||||||||
33 | [] | Jätteenkäsittelykeskus | Avfallshanteringscentral | Waste treatment centre | 234 | 2018-08-07T14:00:21.773147+03:00 | 2 | 31 | {} | [234] | 0 | 1400 | 1 | 1 | |||||||||||||||||||||||||||||||||
32 | [] | Jäteasema | Avfallsstation | Waste station | 232 | 2018-08-07T14:00:21.766335+03:00 | 2 | 31 | {} | [232] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
87 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:21.958557+03:00 | 2 | 85 | {} | [233] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
295 | [] | Jäteveden puhdistamo | Avloppsreningsverk | Sewage treatment plant | 233 | 2018-08-07T14:00:22.470442+03:00 | 4 | 293 | {} | [233] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
1074 | [] | Sopimuspalokunnat | Avtalsbrandkårer | Volunteer fire departments | 633 | 2018-08-07T14:00:29.872976+03:00 | 2 | 1070 | {} | [633] | 0 | 1061 | 15 | 23 | 7 | 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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
691 | [] | Kylpylä | Badinrättning | Spa | 361 | 2018-08-07T14:00:24.210042+03:00 | 4 | 690 | {} | [361] | 0 | 1403 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||||
622 | [] | Sulkapallohalli | Badmintonhall | Badminton hall | 647 | 2018-08-07T14:00:23.705272+03:00 | 4 | 614 | {} | [647] | 0 | 1403 | 9 | 18 | 5 | 4 | |||||||||||||||||||||||||||||||
688 | [] | Uimapaikka | Badplats | Unsupervised beach | 730 | 2018-08-07T14:00:24.189679+03:00 | 4 | 685 | {} | [730] | 0 | 1403 | 14 | 48 | 4 | 22 | 4 | 4 | |||||||||||||||||||||||||||||
689 | [] | Uimaranta | Badstrand | Supervised beach | 731 | 2018-08-07T14:00:24.196951+03:00 | 4 | 685 | {} | [731] | 0 | 1403 | 13 | 23 | 8 | 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 | |||||||||||||||||||||||||||||||||
644 | [] | Pikaluistelurata | Bana hastighetsåkning på skridsko | Speed-skating track | 514 | 2018-08-07T14:00:23.862975+03:00 | 4 | 639 | {} | [514] | 0 | 1403 | 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 | |||||||||||||||||||||||||||||||
638 | [] | Ratagolf | Bangolf | Minigolf course | 573 | 2018-08-07T14:00:23.822729+03:00 | 4 | 634 | {} | [573] | 0 | 1403 | 7 | 18 | 7 | 4 | |||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
1082 | [] | Väestöhälyttimet | Befolkningslarm | Public alarm systems | 805 | 2018-08-07T14:00:29.929327+03:00 | 1 | 1061 | {} | [805] | 0 | 1061 | 38 | 38 | |||||||||||||||||||||||||||||||||
1083 | [1084, 1086] | Väestönsuojat | Befolkningsskyddsrum | Public shelters | 2018-08-07T14:00:29.937480+03:00 | 1 | 1061 | {} | [] | 0 | 1061 | 47 | 49 | 2 | |||||||||||||||||||||||||||||||||
191 | [192, 193, 194, 195, 196] | Päätöksenteko | Beslutsfattande | Decision-making | 2018-08-07T14:00:30.523612+03:00 | 2 | 171 | {} | [] | 0 | 1401 | 6 | 10 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
757 | [758, 759, 760, 761, 762] | Päätöksenteko | Beslutsfattande | Decision-making | 2018-08-07T14:00:30.759776+03:00 | 3 | 756 | {} | [] | 0 | 1401 | 6 | 10 | 2 | 1 | 1 | |||||||||||||||||||||||||||||||
132 | [] | Kaupanvahvistus | Bestyrkande av köp | Public purchase witnessing | 255 | 2018-08-07T14:00:30.067157+03:00 | 2 | 122 | {} | [255] | 0 | 1401 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
239 | [] | Kaupanvahvistus | Bestyrkande av köp | Public purchase witnessing | 255 | 2018-08-07T14:00:22.103157+03:00 | 3 | 231 | {} | [255] | 0 | 1400 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
155 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:30.219845+03:00 | 4 | 149 | {} | [804] | 0 | 1401 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
264 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.259199+03:00 | 5 | 258 | {} | [804] | 0 | 1400 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
511 | [] | Tilaussaunat | Beställningsbastur | Reservation-only sauna | 804 | 2018-08-07T14:00:22.844464+03:00 | 3 | 505 | {} | [804] | 0 | 1403 | 1 | 2 | 1 | ||||||||||||||||||||||||||||||||
324 | [325, 2040, 2193, 327, 328, 2194] | Kirjastot | Bibliotek | Libraries | 2018-08-07T14:00:24.821378+03:00 | 2 | 306 | {} | [] | 0 | 1402 | 83 | 125 | 26 | 14 | 2 | |||||||||||||||||||||||||||||||
345 | [346, 2026, 2196, 348, 349, 2197] | Kirjastot | Bibliotek | Libraries | 2018-08-07T14:00:22.550752+03:00 | 2 | 343 | {} | [] | 0 | 1403 | 114 | 157 | 27 | 14 | 2 | |||||||||||||||||||||||||||||||
418 | [] | Kuvataide | Bildkonst | Visual arts | 359 | 2018-08-07T14:00:23.020022+03:00 | 3 | 368 | {} | [359] | 0 | 1403 | 2 | 5 | 2 | 1 | |||||||||||||||||||||||||||||||
376 | [] | Biljardi | Biljard | Billiards | 126 | 2018-08-07T14:00:22.918484+03:00 | 3 | 368 | {} | [126] | 0 | 1403 | 16 | 13 | 3 | ||||||||||||||||||||||||||||||||
723 | [] | Lipunmyynti | Biljettförsäljning | Ticket sales | 403 | 2018-08-07T14:00:24.435423+03:00 | 4 | 719 | {} | [403] | 0 | 1403 | 3 | 4 | 1 | ||||||||||||||||||||||||||||||||
754 | [] | Lipunmyynti tapahtumiin | Biljettförsäljning till evenemang | Ticket sales to events | 405 | 2018-08-07T14:00:24.631976+03:00 | 2 | 717 | {} | [405] | 0 | 1403 | 5 | 13 | 1 | 6 | 1 | ||||||||||||||||||||||||||||||
518 | [] | Matkalippujen tarkastus | Biljettkontroll | Ticket inspection | 431 | 2018-08-07T14:00:25.036866+03:00 | 3 | 513 | {} | [431] | 0 | 1402 | 1 | 1 | |||||||||||||||||||||||||||||||||
353 | [] | Elokuvateatterit | Biografteater | Cinemas | 138 | 2018-08-07T14:00:22.603098+03:00 | 3 | 352 | {} | [138] | 0 | 1403 | 15 | 21 | 2 | 4 | |||||||||||||||||||||||||||||||
48 | [] | Sekajäte | Blandat avfall | Mixed waste | 617 | 2018-08-07T14:00:21.889545+03:00 | 3 | 34 | {} | [617] | 0 | 1400 | 2 | 6 | 2 | 1 | 1 | ||||||||||||||||||||||||||||||
660 | [] | Pesäpallostadion | Bobollsstadion | Baseball stadium | 511 | 2018-08-07T14:00:23.995997+03:00 | 4 | 654 | {} | [511] | 0 | 1403 | 3 | 6 | 1 | 2 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||
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 | |||||||||||||||||
104 | [] | Asumisterveys | Boendehälsa | Housing health | 77 | 2018-08-07T14:00:21.579504+03:00 | 3 | 103 | {} | [77] | 0 | 1400 | 2 | 5 | 1 | 1 | 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 | |||||||||||||||||||||||||||||
2160 | [] | Mielenterveyskuntoutujien asumispalvelut | Boendetjänster för klienter inom psykrehabilitering | Residential services for mental health rehabilitation clients | 857 | 2018-08-07T14:00:28.137962+03:00 | 2 | 845 | {} | [857] | 0 | 783 | 6 | 14 | 8 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
2026 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:22.565354+03:00 | 3 | 345 | {} | [312] | 0 | 1403 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
2040 | [] | Kirjastoautopalvelut | Bokbussar | Mobile libraries | 312 | 2018-08-07T14:00:24.837192+03:00 | 3 | 324 | {} | [312] | 0 | 1402 | 1 | 3 | 1 | 1 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
454 | [] | Pöytäfutis | Bordfotboll | Table football | 554 | 2018-08-07T14:00:23.125546+03:00 | 3 | 368 | {} | [554] | 0 | 1403 | 11 | 10 | 1 | ||||||||||||||||||||||||||||||||
455 | [] | Pöytäjääkiekko | Bordshockey | Table hockey | 555 | 2018-08-07T14:00:23.132016+03:00 | 3 | 368 | {} | [555] | 0 | 1403 | 4 | 3 | 1 | ||||||||||||||||||||||||||||||||
448 | [] | Pingis | Bordtennis | Table tennis | 515 | 2018-08-07T14:00:23.100999+03:00 | 3 | 368 | {} | [515] | 1 | 1403 | 1 | 17 | 12 | 4 | |||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||
7 | [] | Asuntotuotanto | Bostadsproduktion | Housing production | 79 | 2018-08-07T14:00:21.261214+03:00 | 2 | 2 | {} | [79] | 0 | 1400 | 1 | 3 | 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 );