unit
12 rows where accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_visually_impaired = 2
This data as json, CSV (advanced)
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 | lp.tapuli@hel.fi | +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 | etunimi.sukunimi@vantaa.fi | +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 | etunimi.sukunimi@vantaa.fi | +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 | etunimi.sukunimi@vantaa.fi | +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 | sockenstugan.forskola@hel.fi | +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 | ohjaamotalo@espoo.fi | +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
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 );