12 rows where accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_visually_impaired = 2

View and edit SQL

Suggested facets: department, root_department, contract_type_id, contract_type_description_fi, contract_type_description_sv, contract_type_description_en, phone, email, created_time, data_source, extensions_maintenance_organization, accessibility_viewpoints, root_service_nodes, municipality, accessibility_shortcoming_count_reduced_mobility, accessibility_shortcoming_count_wheelchair, accessibility_shortcoming_count_rollator, created_time (date), last_modified_time (date)

id ▼ connections accessibility_properties identifiers_0_namespace identifiers_0_value identifiers_1_namespace identifiers_1_value department root_department provider_type organizer_type contract_type_id contract_type_description_fi contract_type_description_sv contract_type_description_en is_active deleted_at organizer_name organizer_business_id picture_url picture_entrance_url streetview_entrance_url description_fi description_en short_description name_fi name_en street_address_fi street_address_sv street_address_en www_fi www_sv www_en address_postal_full call_charge_info_fi call_charge_info_sv call_charge_info_en picture_caption phone fax accessibility_phone accessibility_email accessibility_www created_time address_zip data_source extensions_maintenance_group extensions_maintenance_organization last_modified_time accessibility_viewpoints root_service_nodes municipality service_nodes services keywords location_type location_coordinates_0 location_coordinates_1 address_postal_full_fi identifiers_2_value picture_caption_fi call_charge_info www name_sv short_description_fi accessibility_shortcoming_count_reduced_mobility accessibility_shortcoming_count_wheelchair location picture_caption_sv accessibility_shortcoming_count_stroller address_postal_full_en accessibility_shortcoming_count_hearing_aid street_address contract_type accessibility_shortcoming_count_rollator identifiers_2_namespace address_postal_full_sv short_description_sv description_sv accessibility_shortcoming_count_visually_impaired short_description_en description picture_caption_en
298 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-16:30", "sv": "\u00f6ppet m\u00e5n-fre 09-16:30", "en": "open Mon-Fri 09-16:30"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Koululaisilla on mahdollisuus maksulliseen v\u00e4lipalaan 36,10 \u20ac/kk."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Johtava leikkipuisto-ohjaaja", "sv": "Ledande lekparksledare", "en": "Leading playground instructor"}, "www": null, "email": "noora.hynynen@hel.fi", "phone": "+358 9 310 58514", "contact_person": "Hynynen Noora"}, {"section_type": "OTHER_INFO", "name": {"fi": "Leikkipuistot tarjoavat koululaisille ohjattua toimintaa turvallisessa ja monipuolisessa \ntoimintaymp\u00e4rist\u00f6ss\u00e4. Koulujen loma-aikoina leikkipuistoissa j\u00e4rjestet\u00e4\u00e4n toimintaa; p\u00e4iv\u00e4leirej\u00e4, retki\u00e4 ja mukavaa tekemist\u00e4 koululaisille. Ohjelmasta tiedotetaan lomien l\u00e4hestyess\u00e4."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Ilmoittautuminen koululaisten iltap\u00e4iv\u00e4toimintaan"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kasvatus-ja-koulutus/perusopetus/aamu-ja-iltapaivatoiminta/iltapaivatoiminta/iptoiminta-leikkipuistoissa/ilmoittautuminen/ilmoittautuminen"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Asiakastiedote 18.3.2020"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kasvatus-ja-koulutus/leikki-ja-avoin-toiminta/leikkipuistotoiminnan+rajaaminen"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook sivu", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "https://www.facebook.com/pages/Leikkipuisto-Tapuli/116324898567440", "sv": "https://www.facebook.com/pages/Leikkipuisto-Tapuli/116324898567440", "en": "https://www.facebook.com/pages/Leikkipui… [{"value": "true", "variable": 52}, {"value": "false", "variable": 22}, {"value": "true", "variable": 62}, {"value": "smooth", "variable": 17}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 116}, {"value": "true", "variable": 115}, {"value": "false", "variable": 46}, {"value": "false", "variable": 48}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "true", "variable": 29}, {"value": "false", "variable": 50}, {"value": "false", "variable": 31}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 92}, {"value": "false", "variable": 109}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 20}, {"value": "true", "variable": 57}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 53}, {"value": "true", "variable": 113}, {"value": "true", "variable": 104}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "0", "variable": 1}, {"value": "false", "variable": 38}, {"value": "false", "variable": 49}, {"value": "true", "variable": 44}, {"value": "true", "variable": 37}, {"value": "false", "variable": 33}, {"value": "false", "variable": 79}, {"value": "true", "variable": 58}, {"value": "false", "variable": 83}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 117}, {"value": "true", "variable": 112}, {"value": "true", "variable": 51}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "true", "variable": 107}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 5}, {"value": "true", "variable": 23}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 114}, {"value": "true", "variable": 21}, {"value": "false", "variable": 105}… internal 520     3e9714d7-fdbc-4812-a04d-b8c6c97fe521 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             LP Tapulissa on kiipeilytelineitä, liukumäkiä, keinut sekä liikunnallisia välineitä. Pelikenttiä kaksi joissa pelaillaan kesäisin. Talvisin käytetään Salotien luistelukenttää.(altaat eivät ole käytössä) Some play parks include playing fields, which are frozen in the winter to serve as ice skating rinks. Play parks also include ball game walls, balancing equipment, climbing nets and wading pools, which support sporting activities. Play parks offer opportunities for sports and games.   Leikkipuisto Tapuli Playground Tapuli Kimnaasipolku 7 Gymnasiestigen 7 Kimnaasipolku 7 https://www.hel.fi/varhaiskasvatus/fi/leikkipuistotjaperhetalot/tapuli https://www.hel.fi/varhaiskasvatus/fi/leikkipuistotjaperhetalot/tapuli https://www.hel.fi/varhaiskasvatus/fi/leikkipuistotjaperhetalot/tapuli   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 57560   +358 9 310 57560 lp.tapuli@hel.fi   2007-11-15T00:00:00+02:00 00750 www.hel.fi kaikki helsinki 2020-11-05T16:30:54.095006+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1087, 1400, 1403, 1405] helsinki [978, 979, 2134, 648, 500, 69, 981] [475, 415, 341, 288] {"fi": ["ip Maatullin ala-asteen koulu"]} Point 25.028519 60.273445 PL 73997, 00099 Helsingin kaupunki         Lekparken Tapuli   3 6     2 P.O. Box 73997, 00099 City of Helsinki 1     5   PB 73997, 00099 Helsingfors stad   I en del av lekparkerna finns spelplaner som på vintern fryses till skridskobanor. I lekparkerna finns även bollväggar, utrustning för balansövningar, klätternät och plaskdammar som stöder motionsaktiviteter. Lekparkerna erbjuder möjligheter till motion och spel. 2      
6865 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 661 5808", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 401 3294", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "Tarjolla sali", "sv": "Tillg\u00e4nglig: sal", "en": "Available: hall"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Tilanvaraus", "sv": "Lokalbokning", "en": "Reservation of premises"}, "www": {"fi": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/fi/palvelut/tilojen-varaaminen/koulutilojen-kaytto", "sv": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/sv/tjanster/anvandning-skollokaler", "en": "https://www.hel.fi/kasvatuksen-ja-koulutuksen-toimiala/en/services/renting-facilities/school-facilities"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] [{"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "false", "variable": 22}, {"value": "true", "variable": 106}, {"value": "true", "variable": 38}, {"value": "5", "variable": 64}, {"value": "at_least_4_steps", "variable": 39}, {"value": "true", "variable": 53}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "true", "variable": 57}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 5}, {"value": "true", "variable": 37}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 55}, {"value": "false", "variable": 62}, {"value": "smooth", "variable": 17}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 58}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 51}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 107}, {"value": "false", "variable": 21}, {"value": "true", "variable": 104}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 23}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "false", "variable": 102}, {"value": "true", "variable": 105}, {"value": "false", "variable": 70}, {"value": "true", "variable": 6}, {"value": "true", "variable": 92}, {"value": "false", "variable": 48}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 94}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "true", "variable": 40}, {"value": "false", "variable": 29}, {"value": "false", "variable": 33}] internal 130     953d7ed6-a626-48bd-9bc0-faa24a548a5f 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Vallilan ala-asteen koulu Vallila Comprehensive School, Lower Stage Hämeentie 80 Tavastvägen 80 Hämeentie 80 http://www.valla.edu.hel.fi http://www.valla.edu.hel.fi http://www.valla.edu.hel.fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 82377   +358 50 401 3826 janne.hakulinen@palmia.fi   2015-11-27T12:11:49+02:00 00550 www.hel.fi kaikki helsinki 2020-12-03T13:00:58.094307+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": null} [1087, 1402] helsinki [1123, 1141, 1134, 1146, 1100, 331] [806, 661, 108, 34, 33, 15] {"fi": ["sali", "tilanvaraus", "tilavaraus", "koulu", "peruskoulu", "peruskoulut"], "sv": ["lokalbokning"], "en": ["reservation of premises", "basiceducation", "basic education"]} Point 24.96379 60.19294 PL 55302, 00099 Helsingin kaupunki         Lågstadieskolan Vallilan ala-asteen koulu   4 7     2 P.O. Box 55302, 00099 City of Helsinki       7   PB 55302, 00099 Helsingfors stad     2      
8560 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-16", "sv": "\u00f6ppet m\u00e5n-fre 09-16", "en": "open Mon-Fri 09-16"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Asukastalot ovat koronatilanteen vuoksi suljettuja maanantaista 30.11. alkaen. \nSulku koskee my\u00f6s tilojen ilta- ja viikonloppuvarauksia. P\u00e4ivisin ajanvarauksella mahdollistuvaa toimintaa, esim. digineuvontaa, toteutetaan talokohtaisesti erillisen ohjeen mukaisesti. Seuraa asukastalojen tiedotteita sosiaalisessa mediassa ja l\u00f6yd\u00e4t lis\u00e4\u00e4 tietoa ajanvarauksella toteutettavasta palvelusta. \nTiedote ajanvarauksesta tulee esille my\u00f6s talojen oviin."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 3… [{"value": "true", "variable": 59}, {"value": "false", "variable": 58}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 5}, {"value": "sufficiently_wide", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "false", "variable": 38}, {"value": "false", "variable": 23}, {"value": "false", "variable": 22}, {"value": "false", "variable": 44}, {"value": "false", "variable": 29}, {"value": "true", "variable": 37}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 34}, {"value": "false", "variable": 50}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "true", "variable": 51}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 53}, {"value": "true", "variable": 52}, {"value": "false", "variable": 102}, {"value": "false", "variable": 79}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "true", "variable": 62}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 20}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "true", "variable": 80}, {"value": "false", "variable": 92}, {"value": "false", "variable": 83}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 82}, {"value": "false", "variable": 84}, {"value": "true", "variable": 104}, {"value": "false", "variable": 103}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 106}, {"value": "false", "variable": 98}, {"value": "false", "variable": 107}, {"value": "true", "variable": 105}] internal 3199     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://www.hel.fi/static/liitteet-2019/Kaupunginkanslia/TPR/kuvat/Liusketie_ulkoa.jpg           Pihlajamäen lähiöasema/ryhmä- ja yhteisötyö Pihlajamäki local centre Liusketie 3 A Skiffervägen 3 A Liusketie 3 A https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/sosiaalinen-tuki-ja-toimeentulo/asukastalot/pohjoinen/pihlajamaki/ https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/sosiaalinen-tuki-ja-toimeentulo/asukastalot/pohjoinen/pihlajamaki/ https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/sosiaalinen-tuki-ja-toimeentulo/asukastalot/pohjoinen/pihlajamaki/   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 41010   +358 9 310 41010 pihlajamaen.lahioasema@hel.fi https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/asukastoiminta/pohjoinen/pihlajamaen-la/ 2008-11-04T12:39:19+02:00 00710 www.hel.fi kaikki helsinki 2020-11-27T13:01:08.664513+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [783, 1402] helsinki [847, 335, 341, 337, 338] [692, 691, 689, 483, 49] {"fi": ["tilavaraus"]} Point 25.013227 60.23456 PL 71797, 00099 Helsingin kaupunki   Pihlajamäen lähiöaseman ovi Liusketiellä     Rönnbacka förortsstation Asukastila, joka on avoinna ma-pe. Talossa erilaista toimintaa alueen asukkaille. 3 5     2 P.O. Box 71797, 00099 City of Helsinki 1     5   PB 71797, 00099 Helsingfors stad Invånarlokal med olika slags verksamhet för områdets invånare.   2 A centre for citizens with many kinds of activities.    
10953 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna joka p\u00e4iv\u00e4 08-20", "sv": "\u00f6ppet varje dag 08-20", "en": "open every day 08-20"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Yleis\u00f6vessa on auki ma-su klo 8-20 lukuun ottamatta arkipyhi\u00e4 (loppiainen, pitk\u00e4perjantai, 1. ja 2. p\u00e4\u00e4si\u00e4isp\u00e4iv\u00e4, helatorstai, juhannus ja joulu 24.-26.12.)."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta", "sv": "Ge respons", "en": "Give feedback"}, "www": {"fi": "https://www.hel.fi/kaupunkiymparisto/fi/yhteystiedot/Anna+palautetta/", "sv": "https://www.hel.fi/kaupunkiymparisto/sv/kontaktuppgifter-och-respons/respons", "en": "https://www.hel.fi/kaupunkiymparisto/en/feedback/feedback/feedback"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 52}, {"value": "true", "variable": 51}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 44}, {"value": "true", "variable": 58}, {"value": "false", "variable": 116}, {"value": "false", "variable": 48}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 21}, {"value": "false", "variable": 5}, {"value": "false", "variable": 23}, {"value": "true", "variable": 37}, {"value": "false", "variable": 29}, {"value": "public_toilet", "variable": 60}, {"value": "0", "variable": 1}, {"value": "false", "variable": 33}, {"value": "false", "variable": 111}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 20}, {"value": "on_door", "variable": 110}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 114}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 115}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 107}, {"value": "true", "variable": 50}, {"value": "false", "variable": 117}, {"value": "false", "variable": 34}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 22}, {"value": "true", "variable": 112}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 91}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "true", "variable": 113}, {"value": "true", "variable": 109}, {"value": "true", "variable": 57}] internal 4109     db5dbae8-93bb-4248-bfe6-e237b59eec12 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Sofiankadun yleisövessa Sofiankatu, public toilet Sofiankatu 2 Sofiegatan 2   https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732 https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732 https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3732   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 22111         2009-12-02T16:33:38+02:00 00170 www.hel.fi kaikki helsinki 2020-11-05T16:31:06.696268+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "green"} [1400] helsinki [94] [819] {"fi": ["wc", "vappu"], "en": ["May Day"], "sv": ["vappen"]} Point 24.95196 60.168293           Sofiegatan, allmän toalett   3 4     2         4         2      
15693 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 22}, {"value": "true", "variable": 105}, {"value": "true", "variable": 106}, {"value": "true", "variable": 107}, {"value": "true", "variable": 104}, {"value": "false", "variable": 92}, {"value": "false", "variable": 102}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 109}, {"value": "false", "variable": 103}, {"value": "true", "variable": 82}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "true", "variable": 112}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 84}, {"value": "false", "variable": 80}, {"value": "false", "variable": 117}, {"value": "false", "variable": 38}, {"value": "true", "variable": 59}, {"value": "true", "variable": 57}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 48}, {"value": "true", "variable": 62}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 50}, {"value": "true", "variable": 51}, {"value": "false", "variable": 79}, {"value": "false", "variable": 49}, {"value": "true", "variable": 52}, {"value": "false", "variable": 44}, {"value": "true", "variable": 53}, {"value": "false", "variable": 23}, {"value": "false", "variable": 29}, {"value": "false", "variable": 33}, {"value": "true", "variable": 20}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "false", "variable": 21}, {"value": "true", "variable": 5}, {"value": "true", "variable": 6}, {"value": "under_10m", "variable": 4}, {"value": "smooth", "variable": 17}, {"value": "less_than_3600mm", "variable": 3}, {"value": "sufficiently_wide", "variable": 18}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 37}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "2", "variable": 1}, {"value": "indoor_facility", "variable": 500}, {"va… internal 4531     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Maahanmuuttajapalveluiden yksikkö   Pyyntitie 3 Fångstvägen 3 Pyyntitie 3 http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Maahanmuuttajapalvelut http://www.esbo.fi/sv-FI/Social_och_halsovard/Invandrartjanster http://espoo.fi/en-US/Social_and_health_services/Immigrant_Services                     2015-11-03T12:03:45+02:00 02230 www.espoo.fi kaikki espoo 2020-10-12T09:01:02.441387+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [783, 1401] espoo [189, 857] [420] {"fi": ["monikulttuurinen ryhm\u00e4toiminta"]} Point 24.733711 60.157875               2 4     2   1     4         2      
18651 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 06-18", "sv": "\u00f6ppet m\u00e5n-fre 06-18", "en": "open Mon-Fri 06-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "P\u00e4iv\u00e4koti on avoinna klo 7-17, tarvittaessa aukioloa jatketaan tunti ennen ja j\u00e4lkeen aukiolon."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "nina.palenius@vantaa.fi", "phone": "+358 40 835 3376", "contact_person": "Nina Palenius"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.vapaala@vantaa.fi", "phone": "+358 50 312 4846", "contact_person": "Auringons\u00e4teet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.vapaala@vantaa.fi", "phone": "+358 50 312 4846", "contact_person": "Poutapilvet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.vapaala@vantaa.fi", "phone": "+358 50 312 1918", "contact_person": "Tuulilaakso"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.vapaala@vantaa.fi", "phone": "+358 50 312 4847", "contact_person": "T\u00e4hdenlento"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Esiopetusryhm\u00e4"}, "www": null, "email": "pk.vapaala.eskarit@vantaa.fi", "phone": "+358 43 826 8113", "contact_person": "Kuusimets\u00e4"}, {"section_type": "LINK", "name": {"fi": "Anna palautetta.", "sv": "Ber\u00e4tta din \u00e5sikt.", "en": "Tell us your opinion."}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta", "sv": "https://asiointi.vantaa.fi/anna-palautetta", "en": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 118}, {"value": "true", "variable": 6}, {"value": "true", "variable": 117}, {"value": "true", "variable": 113}, {"value": "true", "variable": 51}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 103}, {"value": "false", "variable": 109}, {"value": "false", "variable": 102}, {"value": "false", "variable": 83}, {"value": "true", "variable": 5}, {"value": "false", "variable": 58}, {"value": "false", "variable": 116}, {"value": "true", "variable": 115}, {"value": "false", "variable": 21}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 107}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "false", "variable": 44}, {"value": "true", "variable": 52}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 49}, {"value": "false", "variable": 38}, {"value": "true", "variable": 105}, {"value": "true", "variable": 114}, {"value": "false", "variable": 79}, {"value": "false", "variable": 22}, {"value": "false", "variable": 48}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 57}, {"value": "over_20mm", "variable": 56}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 98}, {"value": "false", "variable": 23}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 112}, {"value": "false", "variable": 84}, {"value": "true", "variable": 106}, {"value": "false", "variable": 29}, {"value": "false", "variable": 53}, {"value": "false", "variable": 50}, {"value": "true", "variable": 37}, {"value": "true", "variable": 104}, {"value": "sufficiently_wide", "variable": 18}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 34}, {"value": "false", "variable": 92}, {"value": "true", "variable": 62}, {"value": "true", "variable": 20}] internal 5225     ab4f37d0-3e53-462e-ad40-c73b57e3e39e 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://vantaa.emmi.fi/l/xHZgbfCv-qW7     Päiväkodissa toimii kuusi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. Esiopetusryhmät sijaitsevat eri tiloissa Rajatorpan koululla osoitteessa Vapaalanpolku 13.Alueen ympäristö antaa hyvät mahdollisuudet liikunta- ja luontokasvatukselle. Kiinnitämme erityistä huomiota lasten leikkiin ja kielelliseen kehitykseen. Kuunteleva, keskittyvä ja keskusteleva lapsi kehittää ajatteluaan, vuorovaikutustaan ja tekemistään leikissä ja arkipäivän tilanteissa. Läsnäoleva, rohkaiseva ja kannustava aikuinen tukee lapsen kasvua ja kehitystä.     Vapaalan päiväkoti   Vapaalanpolku 12 Friherrsstigen 12 Vapaalanpolku 12 http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/vapaalan_paivakoti https://www.vantaa.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem https://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/day_care_centers   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 839 11   +358 9 8393 9033 pk.vapaala@vantaa.fi   2014-11-19T17:01:21+02:00 01650 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:12.483415+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1087, 1405] vantaa [879, 1090, 2125, 871, 1089, 2122, 870] [861, 663, 160] {"fi": ["p\u00e4iv\u00e4hoito", "esiopetus", "varhaiskasvatus", "p\u00e4iv\u00e4koti", "eskari", "tarha", "lastentarha"]} Point 24.822977 60.2577 PL 2442, 01030 Vantaan kaupunki   Vapaalan päiväkoti. Kuva: Vantaan kaupunki.       Päiväkodissa toimii kuusi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. Esiopetusryhmät sijaitsevat koulun tiloissa. 2 6     2 P.O. Box 2442, 01030 City of Vantaa 1     6   PB 2442, 01030 Vanda stad     2      
18939 [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 22}, {"value": "0", "variable": 1}, {"value": "true", "variable": 20}, {"value": "false", "variable": 111}, {"value": "false", "variable": 33}, {"value": "false", "variable": 105}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 92}, {"value": "false", "variable": 34}, {"value": "true", "variable": 109}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 46}, {"value": "true", "variable": 29}, {"value": "over_20mm", "variable": 56}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 58}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 80}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "true", "variable": 62}, {"value": "false", "variable": 103}, {"value": "true", "variable": 50}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 82}, {"value": "false", "variable": 83}, {"value": "true", "variable": 113}, {"value": "smooth", "variable": 17}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "true", "variable": 117}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 5}, {"value": "false", "variable": 79}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 118}, {"value": "true", "variable": 116}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "true", "variable": 107}, {"value": "true", "variable": 115}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "true", "variable": 51}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 31}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 57}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 37}, {"value": "false", "variable": 102}, {"value": "true", "variable": 38}, {"… internal 5188     8809b663-71b1-43bd-a894-ac7d0c503427 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   service_by_municipally_owned_company kunnan liikelaitoksen palvelu tjänst från kommunalt affärsverk service by municipally owned company 1                   Simonkylän koulun hammashoitola Dental clinic at Simonkylän koulu Koivukyläntie 52 Björkbyvägen 52   http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna http://www.vantaa.fi/en/social_and_health_care_services   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 839 5300   +358 9 8392 3805     2014-11-19T17:01:21+02:00 01350 www.vantaa.fi kaikki vantaa 2020-06-23T11:31:06.944175+03:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [986] vantaa [995] [184] {"fi": ["hammashoitola"]} Point 25.034903 60.31681 Koivukyläntie 52, 01350 Vantaa         Tandkliniken vid Simonkylän koulu   3 7     2   1     5         2      
19717 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 06-18", "sv": "\u00f6ppet m\u00e5n-fre 06-18", "en": "open Mon-Fri 06-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloaika on klo 6-18 ennalta sovitun tarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "tuomo.seppanen@vantaa.fi", "phone": "+358 40 577 0992", "contact_person": "Tuomo Sepp\u00e4nen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 50 303 4065", "contact_person": "Hein\u00e4hukat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 50 303 4065", "contact_person": "Kissankirput"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 43 827 0337", "contact_person": "M\u00e4ntymittarit"}, {"section_type": "LINK", "name": {"fi": "Anna palautetta.", "sv": "Ber\u00e4tta din \u00e5sikt.", "en": "Tell us your opinion."}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta", "sv": "https://asiointi.vantaa.fi/anna-palautetta", "en": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "true", "variable": 5}, {"value": "true", "variable": 35}, {"value": "true", "variable": 6}, {"value": "false", "variable": 102}, {"value": "false", "variable": 48}, {"value": "true", "variable": 115}, {"value": "0", "variable": 1}, {"value": "under_20mm", "variable": 91}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 44}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 103}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 104}, {"value": "true", "variable": 29}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 84}, {"value": "false", "variable": 109}, {"value": "true", "variable": 38}, {"value": "false", "variable": 117}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 116}, {"value": "true", "variable": 20}, {"value": "true", "variable": 107}, {"value": "true", "variable": 114}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 50}, {"value": "1_step", "variable": 39}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "false", "variable": 52}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 51}, {"value": "false", "variable": 22}, {"value": "false", "variable": 83}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 92}, {"value": "false", "variable": 33}, {"value": "false", "variable": 46}, {"value": "true", "variable": 37}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 105}, {"value": "true", "variable": 112}, {"value": "false", "variable": 23}, {"value": "true", "variable": 62}, {"value": "false", "variable": 57}, {"value": "true", "variable": 113}, {"value": "false", "variable": 34}, {"value": "same_floor_as_entrance", "variable… internal 5521     ab4f37d0-3e53-462e-ad40-c73b57e3e39e 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kolmessa lapsiryhmässä.Myös Tikkurilan alueen kunnallista ja yksityistä perhepäivähoitoa.Päiväkoti sijaitsee Ruskeasannan vehreällä pientaloalueella, Helsinki-Vantaa -lentoaseman läheisyydessä.Päiväkotimme on v.1997 valmistunut arkkitehti Mikko Kairan suunnittelema hirsirakennus, jonka rakenteissa ja materiaaleissa on pyritty luontoystävällisyyteen. Päiväkodin pihalta löytyy omenapuita ja marjapensaita. Kesäisin kasvatamme omalla kasvimaalla kukkia ja vihanneksia.Mistelissä on tilat kolmelle lapsiryhmälle. Lapset ovat iältään 1-6 -vuotiaita ja ryhmät muodostetaan toimintavuosittain huomioiden lasten määrä ja ikä.Lapsille luodaan mahdollisuus toteuttaa itseään ja kehittää persoonallisuuttaan virikkeellisessä, turvallisessa ja myönteisessä ilmapiirissä. Kestävän kehityksen periaatteet ovat toimintamme ydinajatuksena. Tämän mukaisesti pyrimme lasten, perheiden ja päiväkodin henkilökunnan fyysisen, henkisen ja sosiaalisen hyvinvoinnin edistämiseen huomioon ottaen luonnon ja ympäristön arvot toiminnassamme. Avoin vuorovaikutus kaikkien kesken on jatkuva tavoite.     Mistelin päiväkoti Mistelin päiväkoti Tulppaanitie 44, Tulpanvägen 44, Tulppaanitie 44, http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/tikkurila/mistelin_paivakoti http://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem http://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/day_care_centers   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 839 11   +358 9 8392 4743 pk.misteli@vantaa.fi http://www.vantaa.fi/fi/opetus_ja_kasvatus/paivahoito/paivahoito_vantaalla_toimintayksikoittain/tikkurilan_paivahoitopalvelut/ruskeasannan_toimintayksikko 2014-11-19T17:01:21+02:00 01390 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:15.041752+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1087, 1405] vantaa [879, 962, 1090, 2125, 871, 1089, 2122, 870] [861, 663, 506, 160] {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "perhep\u00e4iv\u00e4hoito", "eskari", "tarha", "lastentarha", "p\u00e4iv\u00e4hoito", "esiopetus"]} Point 25.00423 60.315914 PL 4420, 01030 Vantaan kaupunki         Mistelin päiväkoti Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kolmessa lapsiryhmässä.Myös kunnallista ja yksityistä perhepäivähoitoa. 2 5     2 P.O. Box 4420, 01030 City of Vantaa 1     4   PB 4420, 01030 Vanda stad     2      
20039 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Harrastushaku.fi"}, "www": {"fi": "http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Ohjattu_liikunta/Lapset_nuoret_perheet"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Nuorisoj\u00e4rjest\u00f6t ja avustukset", "sv": "Ungdomsf\u00f6reningar och underst\u00f6d"}, "www": {"fi": "https://www.espoo.fi/fi-FI/Nuoret/Yhteystiedot(756)", "sv": "https://www.esbo.fi/sv-FI/Unga/Kontaktuppgifter(7942)"}, "email": null, "phone": null, "contact_person": null}] [{"value": "narrow", "variable": 18}, {"value": "false", "variable": 44}, {"value": "true", "variable": 52}, {"value": "true", "variable": 109}, {"value": "false", "variable": 5}, {"value": "true", "variable": 62}, {"value": "false", "variable": 84}, {"value": "true", "variable": 105}, {"value": "true", "variable": 115}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 23}, {"value": "true", "variable": 104}, {"value": "false", "variable": 22}, {"value": "false", "variable": 92}, {"value": "false", "variable": 111}, {"value": "false", "variable": 103}, {"value": "0", "variable": 1}, {"value": "false", "variable": 83}, {"value": "true", "variable": 50}, {"value": "true", "variable": 80}, {"value": "true", "variable": 106}, {"value": "true", "variable": 58}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 114}, {"value": "false", "variable": 21}, {"value": "true", "variable": 113}, {"value": "true", "variable": 117}, {"value": "false", "variable": 29}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 116}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 37}, {"value": "true", "variable": 57}, {"value": "on_door", "variable": 110}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 38}, {"value": "true", "variable": 51}, {"value": "false", "variable": 82}, {"value": "true", "variable": 107}, {"value": "false", "variable": 98}, {"value": "false", "variable": 118}, {"value": "false", "variable": 33}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 20}, {"value": "false", "variable": 79}, {"value": "false", "variable": 34}, {"value": "true", "variable": 112}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "true", "variable": 53}, {"value": "false", "variable": 102}, {"va… internal 5621     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Tapiolan nuorisotila   Tapiontori 3 A Tapiotorget 3 A Tapiontori 3 A http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Tapiolan_nuorisotila http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Tapiolan_nuorisotila http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Tapiolan_nuorisotila   pvm/mpm lna/msa local network charge/mobile call charge   +358 50 395 2229   +358 50 395 2229 tapiola.nuoriso@espoo.fi http://www.espoo.fi/fi-FI/Nuoret/Kivaa_tekemista/Nuorisotilat/Tapiolan_nuorisotila 2015-11-03T12:03:45+02:00 02100 www.espoo.fi kaikki espoo 2020-11-12T12:30:59.590927+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1400, 1401, 1403] espoo [375, 376, 395, 404, 419, 424, 442, 366, 510, 263, 154, 446, 448, 449] [803, 518, 515, 503, 468, 455, 387, 362, 289, 202, 126, 85] {"fi": ["dico"]} Point 24.803997 60.176727 PL 3280, 02070 ESPOON KAUPUNKI             3 5     2 P.O. Box 3280, 02070 ESPOON KAUPUNKI 1     5   PB 3280, 02070 ESPOON KAUPUNKI     2      
29854 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja", "sv": "Daghemsf\u00f6rest\u00e5ndare", "en": "Manager of daycare centre"}, "www": null, "email": null, "phone": "+358 9 310 40914", "contact_person": "Mirjaleena Enkenberg-Kuisma"}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus ruotsinkieliseen varhaiskasvatukseen", "sv": "Ans\u00f6kan om svenskspr\u00e5kig sm\u00e5barnspedagogik"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4512", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=4512"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hakemus varhaiskasvatukseen tai esiopetukseen", "sv": "Ans\u00f6kan om sm\u00e5barnspedagogik eller f\u00f6rskoleundervisning", "en": "Application for early education or pre-primary education"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=506", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=506", "en": "https://www.hel.fi/helsinki/en/administration/administration/services/eservices?id=506"}, "email": null, "phone": null, "contact_person": null}] [{"value": "0", "variable": 1}, {"value": "true", "variable": 5}, {"value": "false", "variable": 50}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 20}, {"value": "false", "variable": 43}, {"value": "false", "variable": 44}, {"value": "false", "variable": 34}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 104}, {"value": "false", "variable": 107}, {"value": "false", "variable": 102}, {"value": "true", "variable": 38}, {"value": "false", "variable": 92}, {"value": "true", "variable": 40}, {"value": "false", "variable": 21}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 103}, {"value": "false", "variable": 83}, {"value": "true", "variable": 6}, {"value": "false", "variable": 105}, {"value": "true", "variable": 62}, {"value": "false", "variable": 48}, {"value": "true", "variable": 42}, {"value": "false", "variable": 33}, {"value": "false", "variable": 52}, {"value": "false", "variable": 23}, {"value": "over_20mm", "variable": 91}, {"value": "sufficiently_wide", "variable": 18}, {"value": "at_least_4_steps", "variable": 39}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 84}, {"value": "false", "variable": 49}, {"value": "true", "variable": 37}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 79}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 59}, {"value": "true", "variable": 51}, {"value": "false", "variable": 57}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 29}, {"value": "false", "variable": 22}] internal 8710     d065f77d-4aa2-4c1f-8178-1973f7aa7264 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Sockenstugans förskola Sockenstugans förskola Konalantie 13 B Kånalavägen 13 B Konalantie 13 B https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/osallistu-ja-vaikuta/ota-yhteytta/hae-yhteystietoja/toimipistekuvaus?id=29854 https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/dagvord/svenska-daghem/dh-sockenstugan https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/dagvord/svenska-daghem/dh-sockenstugan   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 40914   +358 9 310 28583 sockenstugan.forskola@hel.fi   2012-08-18T01:03:07+03:00 00370 www.hel.fi kaikki helsinki 2020-12-03T13:01:20.527938+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1087, 1405] helsinki [887, 1094, 2129, 882, 1093, 2126, 881] [862, 862, 603, 160, 160] {"fi": ["eskari"], "en": ["preprimaryeducation", "pre-primary education", "preschool"]} Point 24.849874 60.229046 PL 37310, 00099 Helsingin kaupunki         Sockenstugans förskola   2 6     2 P.O. Box 37310, 00099 City of Helsinki 1     6   PB 37310, 00099 Helsingfors stad     2      
30858 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 70}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 6}, {"value": "true", "variable": 73}, {"value": "false", "variable": 102}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 92}, {"value": "false", "variable": 49}, {"value": "true", "variable": 40}, {"value": "true", "variable": 112}, {"value": "false", "variable": 83}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 116}, {"value": "under_20mm", "variable": 56}, {"value": "opens_easily_manually", "variable": 77}, {"value": "false", "variable": 117}, {"value": "true", "variable": 5}, {"value": "true", "variable": 104}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "true", "variable": 75}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 84}, {"value": "true", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 74}, {"value": "false", "variable": 33}, {"value": "true", "variable": 114}, {"value": "false", "variable": 34}, {"value": "true", "variable": 113}, {"value": "false", "variable": 53}, {"value": "true", "variable": 25}, {"value": "true", "variable": 57}, {"value": "true", "variable": 76}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 23}, {"value": "false", "variable": 98}, {"value": "5", "variable": 64}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 29}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 106}, {"value": "true", "v… internal 20759     154af650-9860-4994-b746-e10abb660203 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Kallion lukio Kallio Upper Secondary School Lehtikuusentie 4 Lärkträdsvägen 4 Lehtikuusentie 4 http://www.kallil.edu.hel.fi http://www.kallil.edu.hel.fi http://www.kallil.edu.hel.fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 84426   +358 50 401 3752 jukka.lampi@palmia.fi   2015-11-27T12:11:49+02:00 00270 www.hel.fi kaikki helsinki 2020-11-11T16:01:16.930899+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1087] helsinki [1274, 1280, 1281, 1286, 1292, 1284, 1293, 1294, 1270, 1296, 1259, 1269] [816, 658, 493, 157, 99, 97, 96, 95, 89, 12, 10, 4] {"fi": ["Kampus-1", "koulu", "lukio", "lukiot"]} Point 24.905302 60.19558 PL 53302, 00099 Helsingin kaupunki         Gymnasiet Kallion lukio   2 4     2 P.O. Box 53302, 00099 City of Helsinki 1     3   PB 53302, 00099 Helsingfors stad     2      
57369 [{"section_type": "OPENING_HOURS", "name": {"fi": "Ma, ke ja pe klo 12-16\nTi ja to klo 10-16", "sv": "M\u00e5n, ons, fre kl. 12-16 \nTis och tors kl. 10-16", "en": "Open Monday, Wednesday, Friday from 12 pm to 4 pm and Tuesday, Thursday from 10 pm to 4 pm"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/efeedback/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Harrastushaku.fi"}, "www": {"fi": "http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Ohjattu_liikunta/Lapset_nuoret_perheet"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Nuorisoj\u00e4rjest\u00f6t ja avustukset", "sv": "Ungdomsf\u00f6reningar och underst\u00f6d"}, "www": {"fi": "https://www.espoo.fi/fi-FI/Nuoret/Yhteystiedot(756)", "sv": "https://www.esbo.fi/sv-FI/Unga/Kontaktuppgifter(7942)"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 23}, {"value": "over_20mm", "variable": 56}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 107}, {"value": "true", "variable": 50}, {"value": "true", "variable": 37}, {"value": "false", "variable": 49}, {"value": "0", "variable": 1}, {"value": "true", "variable": 5}, {"value": "false", "variable": 21}, {"value": "false", "variable": 20}, {"value": "false", "variable": 48}, {"value": "false", "variable": 29}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 92}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 58}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 62}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "false", "variable": 38}, {"value": "false", "variable": 83}, {"value": "true", "variable": 106}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 22}, {"value": "true", "variable": 6}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 51}, {"value": "true", "variable": 59}, {"value": "false", "variable": 33}, {"value": "true", "variable": 105}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 53}, {"value": "true", "variable": 57}, {"value": "true", "variable": 52}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "true", "variable": 80}, {"value": "false", "variable": 82}, {"value": "false", "variable": 44}, {"value": "false", "variable": 102}] internal 26421     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://www.espoo.fi/download/noname/%7BA2414D57-4937-44DB-820F-494BADECE0C3%7D/93393 https://scontent-arn2-1.xx.fbcdn.net/v/t1.0-9/37340122_275323369733316_3050775369826172928_o.jpg?_nc_cat=0&oh=f66788f45bd6d130827ab9f7ea7c0c0a&oe=5BC9851A   Ohjaamotalosta saat tietoa ja apua- opiskelumahdollisuuksista- työelämästä, työnhausta ja toimeentulosta - asumisesta, arjenhallinnasta ja hyvinvoinnista- vapaa-ajanmahdollisuuksista Ohjaamo offers information, guidance and support regarding:education and studiesthe labour market, looking for work and finding incomeeveryday life, housing, well-being and social services   Ohjaamotalo, Leppävaaran Starttipiste Ohjaamo, The Startpoint in Leppävaara Lintuvaarantie 2, Katutaso Fågelbergavägen 2, Katutaso Lintuvaarantie 2, Katutaso http://www.espoo.fi/ohjaamotalo http://www.espoo.fi/ohjaamotalo http://www.espoo.fi/ohjaamotalo   pvm/mpm lna/msa local network charge/mobile call charge   +358 40 126 7513   +358 40 126 7513 ohjaamotalo@espoo.fi   2018-07-13T15:05:37+03:00 02650 www.espoo.fi kaikki espoo 2020-11-12T12:31:54.985946+02:00 {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} [1403] espoo [490] [471] {} Point 24.810558 60.221695           Navigatorhuset, Startpunkten i Alberga Tukea elämään alle 30-vuotiaille espoolaisille 3 5     2   1     5       I Navigatorhuset får du information och råd om - studiemöjligheter - arbetslivet, jobbsökning och utkomst - boende, hantering av vardagen och välbefinnande - fritidsmöjligheter 2      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [unit] (
   [id] INTEGER PRIMARY KEY,
   [connections] TEXT,
   [accessibility_properties] TEXT,
   [identifiers_0_namespace] TEXT,
   [identifiers_0_value] TEXT,
   [identifiers_1_namespace] TEXT,
   [identifiers_1_value] TEXT,
   [department] TEXT,
   [root_department] TEXT,
   [provider_type] TEXT,
   [organizer_type] TEXT,
   [contract_type_id] TEXT,
   [contract_type_description_fi] TEXT,
   [contract_type_description_sv] TEXT,
   [contract_type_description_en] TEXT,
   [is_active] INTEGER,
   [deleted_at] TEXT,
   [organizer_name] TEXT,
   [organizer_business_id] TEXT,
   [picture_url] TEXT,
   [picture_entrance_url] TEXT,
   [streetview_entrance_url] TEXT,
   [description_fi] TEXT,
   [description_en] TEXT,
   [short_description] TEXT,
   [name_fi] TEXT,
   [name_en] TEXT,
   [street_address_fi] TEXT,
   [street_address_sv] TEXT,
   [street_address_en] TEXT,
   [www_fi] TEXT,
   [www_sv] TEXT,
   [www_en] TEXT,
   [address_postal_full] TEXT,
   [call_charge_info_fi] TEXT,
   [call_charge_info_sv] TEXT,
   [call_charge_info_en] TEXT,
   [picture_caption] TEXT,
   [phone] TEXT,
   [fax] TEXT,
   [email] TEXT,
   [accessibility_phone] TEXT,
   [accessibility_email] TEXT,
   [accessibility_www] TEXT,
   [created_time] TEXT,
   [address_zip] TEXT,
   [data_source] TEXT,
   [extensions_maintenance_group] TEXT,
   [extensions_maintenance_organization] TEXT,
   [last_modified_time] TEXT,
   [accessibility_viewpoints] TEXT,
   [root_service_nodes] TEXT,
   [municipality] TEXT,
   [service_nodes] TEXT,
   [services] TEXT,
   [keywords] TEXT,
   [location_type] TEXT,
   [location_coordinates_0] FLOAT,
   [location_coordinates_1] FLOAT,
   [address_postal_full_fi] TEXT,
   [identifiers_2_value] TEXT,
   [picture_caption_fi] TEXT,
   [call_charge_info] TEXT,
   [www] TEXT,
   [name_sv] TEXT,
   [short_description_fi] TEXT,
   [accessibility_shortcoming_count_reduced_mobility] TEXT,
   [accessibility_shortcoming_count_wheelchair] TEXT,
   [location] TEXT,
   [picture_caption_sv] TEXT,
   [accessibility_shortcoming_count_stroller] TEXT,
   [address_postal_full_en] TEXT,
   [accessibility_shortcoming_count_hearing_aid] TEXT,
   [street_address] TEXT,
   [contract_type] TEXT,
   [accessibility_shortcoming_count_rollator] TEXT,
   [identifiers_2_namespace] TEXT,
   [address_postal_full_sv] TEXT,
   [short_description_sv] TEXT,
   [description_sv] TEXT,
   [accessibility_shortcoming_count_visually_impaired] TEXT,
   [short_description_en] TEXT,
   [description] TEXT,
   [picture_caption_en] TEXT
);