unit
11 rows where accessibility_shortcoming_count_visually_impaired = 8 and accessibility_shortcoming_count_wheelchair = 2
This data as json, CSV (advanced)
Suggested facets: connections
provider_type ✖
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
247 | [{"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 74012", "contact_person": "Anneli Haura"}, {"section_type": "LINK", "name": {"fi": "T\u00e4yt\u00e4 p\u00e4iv\u00e4hoitohakemus", "sv": "Ans\u00f6kan om barndagv\u00e5rd", "en": "Application for day care"}, "www": {"fi": "https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/paivahoito/paivakotihoito/hakeminen", "sv": "https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/ansokan/ansokan-dagvard", "en": "https://www.hel.fi/helsinki/en/day-care-education/day-care/options/applying"}, "email": null, "phone": null, "contact_person": null}, {"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": "false", "variable": 34}, {"value": "false", "variable": 92}, {"value": "true", "variable": 57}, {"value": "true", "variable": 62}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "false", "variable": 98}, {"value": "true", "variable": 59}, {"value": "false", "variable": 46}, {"value": "false", "variable": 48}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 50}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 79}, {"value": "false", "variable": 22}, {"value": "false", "variable": 53}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 23}, {"value": "true", "variable": 112}, {"value": "false", "variable": 31}, {"value": "true", "variable": 114}, {"value": "indoor_facility", "variable": 500}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 43}, {"value": "true", "variable": 115}, {"value": "true", "variable": 105}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 106}, {"value": "false", "variable": 83}, {"value": "true", "variable": 52}, {"value": "true", "variable": 113}, {"value": "0", "variable": 1}, {"value": "true", "variable": 20}, {"value": "handrails_on_one_side", "variable": 47}, {"value": "true", "variable": 38}, {"value": "true", "variable": 117}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 102}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 103}, {"value": "false", "variable": 49}, {"value": "false", "variable": 116}, {"value": "true", "variable": 37}, {"value": "false", "variable": 5}, {"value": "true", "variable": 58}, {"value": "true", "variable": 107}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "true", "variable": 40}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 118}, {"value": "false", "variable": 33}, {"value": "false", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 51}, {… | internal | 579 | 33c95a0c-364d-4713-8691-685c797af438 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://maps.google.fi/?q=http:%2F%2Fwww.hel.fi%2Fpalvelukartta%2Fkml.aspx%3Flang%3Dfi%26id%3D247&ll=60.260829,24.986966&spn=0.000011,0.013036&layer=c&cbll=60.260928,24.986817&cbp=12,209.82,,0,-2.67&t=h&z=17&panoid=kDZTsVxOygu9zhokoSw-KQ | Päiväkoti Immola | Day care Immola | Immolantie 9 | Immusvägen 9 | Immolantie 9 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/immola | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/immola | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/immola | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 74012, +358 9 310 46900 | pk.immola@hel.fi | +358 9 310 74012 | aila.kankaansyrja@hel.fi | 2007-11-15T00:00:00+02:00 | 00780 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:53.340421+02:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087, 1405] | helsinki | [879, 1090, 2125, 871, 870] | [861, 861, 663, 160, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 24.985762 | 60.260353 | PL 78991, 00099 Helsingin kaupunki | Päiväkoti Immola | 3 | 2 | P.O. Box 78991, 00099 City of Helsinki | 1 | 2 | PB 78991, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||
1926 | [{"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 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 5}, {"value": "false", "variable": 76}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 58}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 117}, {"value": "false", "variable": 103}, {"value": "false", "variable": 83}, {"value": "false", "variable": 92}, {"value": "false", "variable": 118}, {"value": "false", "variable": 75}, {"value": "true", "variable": 51}, {"value": "true", "variable": 70}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 104}, {"value": "false", "variable": 98}, {"value": "true", "variable": 73}, {"value": "true", "variable": 52}, {"value": "false", "variable": 48}, {"value": "false", "variable": 78}, {"value": "true", "variable": 59}, {"value": "true", "variable": 115}, {"value": "false", "variable": 84}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "false", "variable": 53}, {"value": "under_20mm", "variable": 56}, {"value": "4", "variable": 64}, {"value": "true", "variable": 37}, {"value": "true", "variable": 57}, {"value": "true", "variable": 112}, {"value": "true", "variable": 105}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "floor_1", "variable": 119}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 29}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 6}, {"value": "false", "variable": 114}, {"value": "floor_2", "variable": 120}, {"value": "false", "variable": 62}, {"value": "false", "variable": 106}, {"value": "true", "variable": 113}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "0", "variable": 1}, {"value": "false", "… | internal | 1361 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kannelmäen palvelutalo | Kannelmäki assisted living facility | Urkupillintie 4 | Orgelpipsvägen 4 | Urkupillintie 4 | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 48822 | +358 9 310 48777 | +358 9 310 48811 | heidi.sipilainen@hel.fi | 2007-11-15T00:00:00+02:00 | 00420 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.919054+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [783, 1403] | helsinki | [2218, 2219, 2220, 2221, 2225, 825] | [901, 900, 898, 896, 895, 760] | {"fi": ["vanhusten asuminen"]} | Point | 24.875124 | 60.242657 | PL 42818, 00099 Helsingin kaupunki | Gamlas servicehus | 1 | 2 | P.O. Box 42818, 00099 City of Helsinki | 1 | 2 | PB 42818, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||
5843 | [{"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 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 92}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 75}, {"value": "true", "variable": 116}, {"value": "true", "variable": 70}, {"value": "true", "variable": 107}, {"value": "false", "variable": 29}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 102}, {"value": "true", "variable": 5}, {"value": "true", "variable": 50}, {"value": "true", "variable": 72}, {"value": "false", "variable": 21}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 118}, {"value": "false", "variable": 106}, {"value": "false", "variable": 51}, {"value": "false", "variable": 78}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 37}, {"value": "false", "variable": 33}, {"value": "true", "variable": 112}, {"value": "true", "variable": 20}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "true", "variable": 22}, {"value": "false", "variable": 44}, {"value": "false", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 79}, {"value": "true", "variable": 74}, {"value": "floor_2", "variable": 108}, {"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 52}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 48}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 105}, {"value": "false", "variable": 98}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 104}, {"value": "false", "variable": 6}, {"value": "true", "variable": 53}, {"value": "2", "variable": 64}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "false", "variable": 103}, {"value": "true", "variable": 115}, {"value": "true", "variable": 57}, {"value": "true", "variable":… | internal | 2439 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Malmin peruskoulu pääkoulu Talvela, kouluterveydenhuolto | Malmi Comprehensive School, Upper Stage, school health care | Talvelantie 1 | Talvelavägen 1 | Talvelantie 1 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 310 5592 | +358 9 310 82930 | www.ymalmipk.edu.hel.fi | Talvelantie 1,pl 3508 | 2008-07-10T22:13:17+03:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:05.310015+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": null} | [986, 1087] | helsinki | [2164, 2165] | [339] | {} | Point | 25.000227 | 60.25494 | PL 70302, 00099 Helsingin kaupunki | Grundskolan Malmin peruskoulu, Talvela, skolhäklsovård | 2 | 2 | P.O. Box 70302, 00099 City of Helsinki | 2 | PB 70302, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||||||
15589 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "true", "variable": 105}, {"value": "false", "variable": 102}, {"value": "false", "variable": 104}, {"value": "false", "variable": 103}, {"value": "false", "variable": 98}, {"value": "less_than_3600mm", "variable": 3}, {"value": "outdoors", "variable": 2}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "narrow", "variable": 18}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 70}, {"value": "true", "variable": 6}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 21}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 23}, {"value": "false", "variable": 33}, {"value": "false", "variable": 29}, {"value": "false", "variable": 22}, {"value": "2", "variable": 63}, {"value": "false", "variable": 53}, {"value": "false", "variable": 38}, {"value": "true", "variable": 37}, {"value": "false", "variable": 51}, {"value": "false", "variable": 48}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "requires_use_of_buzzer_opening_easily_manually", "variable": 54}, {"value": "true", "variable": 52}, {"value": "false", "variable": 59}, {"value": "false", "variable": 55}, {"value": "false", "variable": 57}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "false", "variable": 75}, {"value": "true", "variable": 74}, {"value": "true", "variable": 72}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 73}, {"value": "false", "variable": 83}, {"value": "true", "variable": 82}, {"value": "true", "variable": 76}, {"value": "opens_automatically", "variable": 77}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 78}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value"… | internal | 4490 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Espoonlahden hammashoitola | Espoonlahti Dental Clinic | Merikansantie 4 | Sjöfolksvägen 4 | Merikansantie 4 | https://www.espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Hammashoito | https://www.esbo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Tandvard | https://www.espoo.fi/en-US/Social_and_health_services/Health_Services/Dental_care | Esim. 1 €/puhelu + 0,90€/min + pvm/mpm | Esim. 1 €/telefonsamtal + 0,90€/min + msa/lna | Esim. 1 €/call + 0,90€/min + mobile call charge / local network charge | +358 9 8163 0300 | +358 9 8163 0300 | 2015-11-03T12:03:45+02:00 | 02320 | www.espoo.fi | kaikki | espoo | 2020-09-04T14:30:56.720801+03:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "red", "51": "red", "52": "red", "61": "red"} | [986] | espoo | [995] | [184] | {"fi": ["hammasl\u00e4\u00e4k\u00e4ri", "hammashoitolat", "suun terveydenhoito"]} | Point | 24.66203 | 60.149155 | PL 2400, 02070 PL 2402, 02070 ESPOON KAUPUNKI | Esbovikens tandklinik | 1 | 2 | 1 | P.O. Box 2400, 02070 P.O. Box 2400, 02070 City of Espoo | 1 | 2 | PB 2400, 02070 PB 2400, 02070 ESBO STAD | 8 | |||||||||||||||||||||||||||||||||
15602 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 59}, {"value": "indoors_but_not_service_point", "variable": 9}, {"value": "true", "variable": 8}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 7}, {"value": "1", "variable": 1}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 6}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 10}, {"value": "false", "variable": 23}, {"value": "true", "variable": 58}, {"value": "false", "variable": 13}, {"value": "true", "variable": 12}, {"value": "true", "variable": 11}, {"value": "true", "variable": 16}, {"value": "false", "variable": 22}, {"value": "opens_automatically", "variable": 15}, {"value": "true", "variable": 14}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 21}, {"value": "guided_and_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "false", "variable": 29}, {"value": "false", "variable": 34}, {"value": "true", "variable": 20}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 35}, {"value": "false", "variable": 49}, {"value": "true", "variable": 50}, {"value": "false", "variable": 48}, {"value": "false", "variable": 38}, {"value": "false", "variable": 51}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value": "3", "variable": 63}, {"value": "false", "variable": 111}, {"value": "false", "variable": 76}, {"value": "true", "variable": 74}, {"value": "false", "variable": 75}, {"value": "true", "variable": 73}, {"value": "false", "variable": 62}, {"value": "false", "variable": 79}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 72}, {"value": "false", "variable": 78}, {"value": "opens_easily_manually", "variable": 77}, {"value": "true",… | internal | 4606 | 828201f3-df6c-42e5-8239-fac577c3b248 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Avokuntoutuspalvelut | Pihatörmä 1 C | Gårdsbrinken 1 C | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Terapia_ja_kuntoutus | http://espoo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Terapi_och_rehabilitering | http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Terapia_ja_kuntoutus | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8163 6000 | +358 46 877 1308 | tiina.hannikainen@espoo.fi | 2015-11-03T12:03:45+02:00 | 02070 | www.espoo.fi | kaikki | espoo | 2020-07-28T14:01:01.936375+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] | espoo | [1034] | [416] | {"fi": ["fysioterapia", "toimintaterapia", "aikuisten kuntoutus ja terapiat", "apuv\u00e4linepalvelut", "kuntoutussuunnittelija", "kuntoutussuunnittelu", "l\u00e4\u00e4kinn\u00e4llinen kuntoutus", "l\u00e4\u00e4kinn\u00e4llisen kuntoutuksen yksikk\u00f6", "puheterapia"]} | Point | 24.731491 | 60.16499 | PL 2311, 02070 ESPOON KAUPUNKI | 1 | 2 | 1 | P.O. Box 2311, 02070 ESPOON KAUPUNKI | 1 | 2 | PB 2311, 02070 ESPOON KAUPUNKI | 8 | |||||||||||||||||||||||||||||||||||
18579 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 09-15:30, pe 09-15", "sv": "\u00f6ppet m\u00e5n-tor 09-15:30, fre 09-15", "en": "open Mon-Thu 09-15:30, Fri 09-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Leinikkikerho ma, ke ja pe klo 9.00-12.00\nNiittykerho ti ja to klo 9.00-12.00"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "miia.pentikainen@vantaa.fi", "phone": "+358 50 302 6033", "contact_person": "Miia Pentik\u00e4inen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Avoin p\u00e4iv\u00e4koti Niittyvilla ja kerhot"}, "www": null, "email": null, "phone": "+358 50 312 1968", "contact_person": null}, {"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}, {"section_type": "LINK", "name": {"fi": "Niittyvillan kerhot vantaa.fi:ss\u00e4."}, "www": {"fi": "https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/kerhot/myyrmaki"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Avoin p\u00e4iv\u00e4koti Niittyvilla Facebookissa"}, "www": {"fi": "https://www.facebook.com/Niittyvillan-avoin-p%C3%A4iv%C3%A4koti-239513166206113/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 33}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 99}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 42}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 112}, {"value": "true", "variable": 92}, {"value": "false", "variable": 49}, {"value": "true", "variable": 29}, {"value": "true", "variable": 96}, {"value": "false", "variable": 27}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "true", "variable": 38}, {"value": "true", "variable": 50}, {"value": "true", "variable": 37}, {"value": "opens_easily_manually", "variable": 54}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 97}, {"value": "true", "variable": 25}, {"value": "false", "variable": 103}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 70}, {"value": "true", "variable": 98}, {"value": "false", "variable": 117}, {"value": "false", "variable": 52}, {"value": "true", "variable": 107}, {"value": "1", "variable": 1}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 6}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "false", "variable": 102}, {"value": "true", "variable": 51}, {"value": "false", "variable": 21}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 116}, {"value": "true", "variable": 40}, {"value": "true", "variable": 5}, {"value": "true", "variable": 35}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "true", "variable": 59}, {"value": "false", "variable": 100}, {"value": "true", "variable": 105}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 57}, {"value": "true", "variable": 20}, {"value": "false", "variable": 31}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30… | internal | 5248 | 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/TQMbXcbrqKDG | Avoin päiväkoti Niittyvillassa on tarjolla monipuolista ohjattua toimintaa, jossa painottuu pedagogisuus. Avoimessa päiväkodissamme lapsi ja hänen huoltajansa tai muu läheinen saavat mahdollisuuden tavata toisia lapsia ja aikuisia sekä osallistua ohjattuun toimintaan. Asiakkaamme voivat osallistua toiminnan suunnitteluun, toteutukseen ja arviointiin. Annamme vanhemmille tukea ja ohjausta lapsen kasvatukseen ja kasvuun liittyvissä asioissa sekä kerromme lapsiperheille suunnatuista palveluista.Niittyvillan toimintatilat ovat Autioniityn päiväkodin yhteydessä. Leikkitiloja muokkaamme yhdessä leikki-ideoiden ja vuodenaikojen mukaan. Aukioloaikoinamme myös päiväkodin piha on osittain käytössämme. Kaikki lapset ja aikuiset ovat tervetulleita toimintaamme mukaan. Niittyvillassa eletään arkea yhdessä leikkien, laulaen, keskustellen yhteisistä iloista ja suruista toisiamme tukien ja kaikkia arvostaen.Avoimessa päiväkodissamme on myös kerhotoimintaa 2,5-5-vuotiaille kotona oleville lapsille. Kerhoihin voi hakea varhaiskasvatushakemuksella. Leinikkikerho kokoontuu ma, ke ja pe klo 9.00-12.00 ja Niittykerho ti ja to klo 9.00-12.00. | Avoin päiväkoti Niittyvilla | Lammaslammentie 3 | Lammträskvägen 3 | Lammaslammentie 3 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/asukaspuistot_ja_avoimet_paivakodit/myyrmaki | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/asukaspuistot_ja_avoimet_paivakodit/myyrmaki | https://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/residential_parks_and_open_day_care_centers | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 9138 | 2014-11-19T17:01:21+02:00 | 01710 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:12.176607+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1405] | vantaa | [976, 978] | [288, 86] | {"fi": ["avoin p\u00e4iv\u00e4koti", "kerhotoiminta", "kerho", "kerhot", "perhekerho"]} | Point | 24.808805 | 60.26284 | PL 2418, 01030 Vantaan kaupunki | Avoin päiväkoti Niittyvilla. Kuva: Vantaan kaupunki. | Avoin päiväkoti Niittyvillassa on tarjolla monipuolista ohjattua toimintaa lapsille ja huoltajille. Tilat ovat Autioniityn päiväkodin yhteydessä. | 1 | 2 | Avoin päiväkoti Niittyvilla. Bild: Vanda stad. | P.O. Box 2418, 01030 City of Vantaa | 1 | 2 | PB 2418, 01030 Vanda stad | 8 | Avoin päiväkoti Niittyvilla. Photo: City of Vantaa. | |||||||||||||||||||||||||||||
18613 | [{"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 auki klo 6.00-18.00, ennalta sovitun hoitotarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "pk.kimara@vantaa.fi", "phone": "+358 50 302 6244", "contact_person": "Anne Wevar-Savolainen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": null, "phone": "+358 43 826 8097", "contact_person": "P\u00e4ivystyspuhelin"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.kimara.pajut@vantaa.fi", "phone": "+358 43 826 8097", "contact_person": "Pajut"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.kimara.pihlajat@vantaa.fi", "phone": "+358 43 825 8398", "contact_person": "Pihlajat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.kimara.tammet@vantaa.fi", "phone": "+358 43 826 8095", "contact_person": "Tammet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.kimara.vaahterat@vantaa.fi", "phone": "+358 43 826 8096", "contact_person": "Vaahterat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.kimara.koivut@vantaa.fi", "phone": "+358 43 825 8407", "contact_person": "Koivut"}, {"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": 51}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 52}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 105}, {"value": "floor_1", "variable": 108}, {"value": "false", "variable": 20}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 6}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 113}, {"value": "false", "variable": 22}, {"value": "false", "variable": 62}, {"value": "true", "variable": 104}, {"value": "true", "variable": 115}, {"value": "true", "variable": 50}, {"value": "true", "variable": 74}, {"value": "2", "variable": 64}, {"value": "true", "variable": 112}, {"value": "false", "variable": 106}, {"value": "false", "variable": 78}, {"value": "false", "variable": 29}, {"value": "false", "variable": 98}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 84}, {"value": "false", "variable": 38}, {"value": "true", "variable": 73}, {"value": "false", "variable": 49}, {"value": "false", "variable": 92}, {"value": "false", "variable": 79}, {"value": "false", "variable": 23}, {"value": "true", "variable": 59}, {"value": "false", "variable": 53}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 75}, {"value": "false", "variable": 37}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 76}, {"value": "false", "variable": 57}, {"value": "false", "variable": 117}, {"value": "false", "variable": 34}, {"value": "is_heavy", "variable": 77}, {"value": "true", "variable": 70}, {"value": "false", "variable": 116}, {"value": "indoor_facility", "variable": 500}, {"value": "outdoors", "variable": 2}, {"value": "2", "variable": 1}, {"value": "true", "variable": 72}, {"value": "false", "variable": 44}, {"value": "true", "variable": 21}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 102}, {"value": "true", "variable": 114}, {"value"… | internal | 5229 | 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/BXnm7zjbK5BH | Päiväkodissa on viisi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta.Päiväkotimme tarjoaa lapselle turvallisen ja virikkeellisen kasvu- ja oppimisympäristön. Ympäröivä luonto ja vuodenaikojen vaihtelu antaa hyvät puitteet toiminnallemme. Meillä on loistavat mahdollisuudet luonnon tutkimiseen, metsäretkiin, urheiluun hiekkakentällä, leikkiin läheisessä puistossa; talvella luisteluun, hiihtoon, pulkkamäen laskuun, aivan päiväkodin välittömässä läheisyydessä.Jokaisen lapsen oikeus on tuntea olonsa hyväksytyksi ja turvalliseksi. Mahdollistamme, että lapsi saa paljon onnistumisen kokemuksia ja rakentaa hyviä ystävyyssuhteita sekä oppii toimimaan ryhmässä toisten lasten kanssa. Leikki on lapselle tärkeää ja sille suodaan mahdollisuus päiväkotipäivän aikana.Päiväkodissamme kokoontuu myös vanhempien ylläpitämä perhekerho viikottain. Kimaran lapsiperheillä on mahdollisuus kokoontua päiväkodin ala-aulassa yhtenä aamupäivänä 9:30-11.30 välisenä aikana. Päivästä sovitaan päiväkodinjohtajan kanssa. Perhekerhossa lapset ovat yhdessä vanhempien kanssa. Vanhempien on mahdollista saada toisistaan vertaistukea ja lapset saavat leikkiseuraa. Perhekerho ei vaadi ilmoittautumista, ovet ovat avoinna kaikille ja kerho toimii aktiivisten vanhempien vetämänä. Päiväkodin liikuntasali on käytössä yhden tunnin kerhoajasta sovittuna ajankohtana. | Kimaran päiväkoti | Kimaratie 12 | Kimaravägen 12 | Kimaratie 12 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/kimaran_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_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 9047 | pk.kimaraantaa.fi | 2014-11-19T17:01:21+02:00 | 01680 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:12.272198+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, 978, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 288, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "p\u00e4iv\u00e4hoito", "esiopetus", "eskari", "tarha", "lastentarha", "kerhotoiminta", "perhekerho", "kerho"]} | Point | 24.779078 | 60.282673 | PL 2413, 01030 Vantaan kaupunki | Kimaran päiväkoti. Kuva: Vantaan kaupunki. | Päiväkodissa on viisi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. | 2 | 2 | Kimaran päiväkoti. Bild: Vanda stad. | 1 | P.O. Box 2413, 01030 City of Vantaa | 1 | 2 | PB 2413, 01030 Vanda stad | 8 | Kimaran päiväkoti. Photo: City of Vantaa. | |||||||||||||||||||||||||||
19473 | [{"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\u00e4kotimme on avoinna klo 6-18 ennalta sovitusti 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": "heli.olkkonen@vantaa.fi", "phone": "+358 50 302 6746", "contact_person": "Heli Olkkonen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.jokiuoma@vantaa.fi", "phone": "+358 50 302 6746", "contact_person": "Kaislat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.jokiuoma@vantaa.fi", "phone": "+358 43 827 0382", "contact_person": "Lumpeet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.jokiuoma@vantaa.fi", "phone": "+358 43 827 0379", "contact_person": "Rentukat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.jokiuoma@vantaa.fi", "phone": "+358 43 827 0381", "contact_person": "Ulpukat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.jokiuoma@vantaa.fi", "phone": "+358 43 827 0383", "contact_person": "Vesihein\u00e4t"}, {"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": 59}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 103}, {"value": "false", "variable": 98}, {"value": "false", "variable": 105}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 48}, {"value": "true", "variable": 114}, {"value": "false", "variable": 21}, {"value": "true", "variable": 62}, {"value": "false", "variable": 102}, {"value": "true", "variable": 113}, {"value": "false", "variable": 23}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "true", "variable": 109}, {"value": "true", "variable": 38}, {"value": "on_door", "variable": 110}, {"value": "0", "variable": 1}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 49}, {"value": "true", "variable": 58}, {"value": "false", "variable": 43}, {"value": "true", "variable": 107}, {"value": "true", "variable": 57}, {"value": "false", "variable": 42}, {"value": "false", "variable": 33}, {"value": "false", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 51}, {"value": "sufficiently_wide", "variable": 18}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 116}, {"value": "true", "variable": 112}, {"value": "true", "variable": 115}, {"value": "true", "variable": 37}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 5}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "false", "variable": 104}, {"value": "false", "variable": 22}, {"value": "under_20mm", "variable": 56}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 20}, {"value": "false", "variable": 117}, {"value": "false", "variable": 111}, {"value": "true", "variable": 44}, {"value"… | internal | 5458 | 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/prpB_PLdw9gH | Päiväkodissamme on viisi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. Sijaitsemme Martinlaakson lähiön kauniilla metsään ja puistoon rajoittuvalla tontilla. "Halaus on paljon parempaa kuin suklaa.Yksi hyvä kutitus voi pelastaa pilvisen päivän.Kuunteleminen on tärkeämpää kuin puhuminen.Pidä silmäsi avoinna.Koskaan ei ole liian myöhäistä viettää onnellinen lapsuus.Jokaisella tulisi olla joku, joka ottaa kainaloonsa.Mikään ei voita vanhaa ystävää" - Robert Fulghum | Jokiuoman päiväkoti | Vihertie 16 | Grönvägen 16 | Vihertie 16 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/jokiuoman_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 8393 5166 | 2014-11-19T17:01:21+02:00 | 01620 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:14.387610+02:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087, 1405] | vantaa | [879, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "suomenkielinen varhaiskasvatus", "suomenkielinen esiopetus", "esiopetus", "eskari", "tarha", "lastentarha"]} | Point | 24.864902 | 60.275322 | PL 2443, 01030 Vantaan kaupunki | Jokiuoman päiväkoti. Kuva: Vantaan kaupunki. | Päiväkodissamme on viisi lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. | 2 | 2 | Jokiuoman päiväkoti. Bild: Vanda stad | P.O. Box 2443, 01030 City of Vantaa | 1 | 2 | PB 2443, 01030 Vanda stad | 8 | Jokiuoman päiväkoti. Photo: City of Vantaa. | |||||||||||||||||||||||||||||
19718 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 07-17", "sv": "\u00f6ppet m\u00e5n-fre 07-17", "en": "open Mon-Fri 07-17"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Olemme auki ennalta sovitun tarpeen mukaan klo 7-17."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "miia.pentikainen@vantaa.fi", "phone": "+358 50 302 6033", "contact_person": "Miia Pentik\u00e4inen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "leppakertut.autioniitty@eduvantaa.fi", "phone": "+358 43 826 8088", "contact_person": "Lepp\u00e4kertut"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "ruusunmarjat.autioniitty@eduvantaa.fi", "phone": "+358 43 826 8089", "contact_person": "Ruusunmarjat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "ketut.autioniitty@eduvantaa.fi", "phone": "+358 40 668 6534", "contact_person": "Ketut"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Osap\u00e4iv\u00e4ryhm\u00e4"}, "www": null, "email": "apilat.autioniitty@eduvantaa.fi", "phone": "+358 43 826 8090", "contact_person": "Apilat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Autioniityn p\u00e4iv\u00e4koti"}, "www": null, "email": "pk.autioniitty@vantaa.fi", "phone": null, "contact_person": null}, {"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": 102}, {"value": "true", "variable": 5}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "under_10m", "variable": 4}, {"value": "true", "variable": 97}, {"value": "false", "variable": 117}, {"value": "false", "variable": 103}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 58}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 79}, {"value": "false", "variable": 70}, {"value": "true", "variable": 40}, {"value": "false", "variable": 21}, {"value": "true", "variable": 107}, {"value": "false", "variable": 104}, {"value": "true", "variable": 115}, {"value": "false", "variable": 109}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "false", "variable": 46}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "false", "variable": 62}, {"value": "false", "variable": 49}, {"value": "true", "variable": 92}, {"value": "true", "variable": 94}, {"value": "false", "variable": 34}, {"value": "long_term_stay", "variable": 60}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 84}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "true", "variable": 50}, {"value": "false", "variable": 106}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "true", "variable": 6}, {"value": "true", "variable": 29}, {"value": "false", "variable": 33}, {"value": "false", "variable": 27}, {"value": "1", "variable": 1}, {"value": "true", "variable": 96}, {"value": "true", "variable": 59}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 99}, {"value": "true", "variable": 114}, {"value": "true", "variable": 113}, {"value": "true", "variable": 57}, {"value": "false", "variable": 31}, {"value": "true", "variable": 38}, {"value": "true", "variable": 25}, {"value": "… | internal | 5313 | 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/wrfF__zKPmt7 | Päiväkodissamme toimii neljä lapsiryhmää, joissa tarjoamme kokopäiväistä ja osapäiväistä varhaiskasvatusta. Tarjoamme tiloissamme myös kerhotoimintaa. Avoin päiväkoti Niittyvilla toimii myös samoissa tiloissa.Toiminta-ajatuksenamme on tarjota fyysisesti ja psyykkisesti turvalliset puitteet lapsen yksilölliselle kasvulle, kehitykselle ja oppimiselle sekä tukea lapsen ja lapsiryhmän kasvua yhteisöllisyyteen. Toimimme avoimesti ja oikeudenmukaisesti lasta ja perhettä kunnioittaen ja toteutamme kasvatustyötä yhteistyössä vanhempien kanssa. | Autioniityn päiväkoti | Lammaslammentie 3 | Lammträskvägen 3 | Lammaslammentie 3 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/autioniityn_paivakoti | https://www.vanda.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 9138 | 2014-11-19T17:01:21+02:00 | 01710 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:15.060585+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1405] | vantaa | [871, 870] | [663] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "osap\u00e4iv\u00e4hoito", "p\u00e4iv\u00e4hoito", "tarha", "lastentarha"]} | Point | 24.808655 | 60.26291 | PL 2418, 01030 Vantaan kaupunki | Autioniityn päiväkoti. Kuva: Vantaan kaupunki | Päiväkodissamme toimii neljä lapsiryhmää, joissa tarjoamme kokopäiväistä ja osapäiväistä varhaiskasvatusta sekä kerhotoimintaa. | 1 | 2 | Autioniityn päiväkoti. Bild: Vanda stad. | P.O. Box 2418, 01030 City of vantaa | 1 | 2 | PB 2418, 01030 Vanda stad | 8 | Autioniityn päiväkoti. Photo: City of Vantaa. | |||||||||||||||||||||||||||||
45317 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma 09-20, ti, to 09-18, pe 09-16, la 10-16, suljettu ke, su", "sv": "\u00f6ppet m\u00e5n 09-20, tis, tor 09-18, fre 09-16, l\u00f6r 10-16, st\u00e4ngt ons, s\u00f6n", "en": "open Mon 09-20, Tue, Thu 09-18, Fri 09-16, Sat 10-16, closed Wed, Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/86406/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/86406/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/86406/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "COVID-19: Kirjastojen ohjeita epidemiakaudelle."}, "www": {"fi": "https://www.helmet.fi/fi-FI/Tapahtumat_ja_vinkit/Uutispalat/Kirjastoasioinnista_koronavirusepidemian(208997)"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "https://www.facebook.com/jatkasaarenkirjasto", "sv": "https://www.facebook.com/jatkasaarenkirjasto", "en": "https://www.facebook.com/jatkasaarenkirjasto"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 92}, {"value": "true", "variable": 115}, {"value": "true", "variable": 73}, {"value": "true", "variable": 112}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 113}, {"value": "0", "variable": 1}, {"value": "false", "variable": 79}, {"value": "false", "variable": 48}, {"value": "false", "variable": 82}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 74}, {"value": "false", "variable": 23}, {"value": "false", "variable": 44}, {"value": "false", "variable": 31}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "false", "variable": 34}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 106}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 84}, {"value": "floor_1", "variable": 108}, {"value": "true", "variable": 29}, {"value": "false", "variable": 62}, {"value": "false", "variable": 59}, {"value": "true", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "smooth", "variable": 17}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 53}, {"value": "false", "variable": 83}, {"value": "true", "variable": 105}, {"value": "true", "variable": 107}, {"value": "true", "variable": 117}, {"value": "true", "variable": 116}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 118}, {"value": "true", "variable": 58}, {"value": "false", "variable": 76}, {"value": "true", "variable": 72}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "true", "variable": 114}, {"value": "false", "variable": 21}, {"value": "true", "variable": 78}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 49}, {"value": "true", "variable": 75}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "true", "v… | internal | 17137 | kirkanta | 86406 | dc7d39db-b35a-4612-a921-1b7b24b0baa3 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://kirkanta.kirjastot.fi/files/photos/medium/jätkäsaari-käsitelty-596310e396894.jpg | Jätkäsaaren kirjasto ja infokeskus | Jätkäsaari Library | Tyynenmerenkatu 1 | Stillahavsgatan 1 | Tyynenmerenkatu 1 | www.helmet.fi/jätkäsaari | www.helmet.fi/busholmen | www.helmet.fi/busholmen | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 85815 | jatkasaaren_kirjasto@hel.fi | +358 9 310 85815 | jatkasaaren_kirjasto@hel.fi | https://www.helmet.fi/fi-FI/Kirjastot_ja_palvelut/Jatkasaaren_kirjasto_ja_infokeskus | 2015-06-22T09:58:27+03:00 | 00220 | www.hel.fi | kaikki | helsinki | 2021-01-04T07:31:30.683681+02:00 | {"00": null, "11": "green", "12": "red", "13": "red", "21": "green", "22": "red", "23": "red", "31": "green", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1402, 1403] | helsinki | [341, 337, 338, 331, 328, 349] | [813, 806, 692, 691, 483] | {} | Point | 24.920868 | 60.159977 | PL 22455, 00099 HELSINGIN KAUPUNKI | Busholmens bibliotek och infocenter | 2 | 2 | P.O. Box 22455, 00099 HELSINGIN KAUPUNKI | 1 | 2 | PB 22455, 00099 HELSINGIN KAUPUNKI | 8 | ||||||||||||||||||||||||||||
46604 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 50 401 3262", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 512 5097", "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 auditorio ja sali", "sv": "Tillg\u00e4nglig: auditorium och sal", "en": "Available: auditorium and 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": "true", "variable": 116}, {"value": "true", "variable": 53}, {"value": "true", "variable": 118}, {"value": "false", "variable": 48}, {"value": "false", "variable": 76}, {"value": "true", "variable": 57}, {"value": "smooth", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 22}, {"value": "0", "variable": 1}, {"value": "false", "variable": 78}, {"value": "2", "variable": 64}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 70}, {"value": "false", "variable": 98}, {"value": "false", "variable": 106}, {"value": "true", "variable": 5}, {"value": "true", "variable": 105}, {"value": "false", "variable": 38}, {"value": "false", "variable": 34}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "true", "variable": 59}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 72}, {"value": "floor_2", "variable": 108}, {"value": "false", "variable": 103}, {"value": "false", "variable": 44}, {"value": "false", "variable": 75}, {"value": "true", "variable": 20}, {"value": "false", "variable": 102}, {"value": "true", "variable": 113}, {"value": "false", "variable": 92}, {"value": "false", "variable": 51}, {"value": "false", "variable": 104}, {"value": "true", "variable": 107}, {"value": "true", "variable": 73}, {"value": "true", "variable": 117}, {"value": "false", "variable": 21}, {"value": "true", "variable": 58}, {"value": "true", "variable": 74}, {"value": "false", "variable": 79}, {"value": "under_20mm", "variable": 91}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 52}, {"value": "false", "variable": 33}, {"value": "true", "variable": 115}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 62}, {"value": "true", "variable": 37}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 114}, {"value": "false", "variable": 6}, {"value": "false", "variable": 49}, {"value": "false", "variable": 29}, {"value": "… | internal | 17938 | 5431c750-9d5d-4b46-9655-5fa6c83f56aa | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Malmin peruskoulu | Malmi Comprehensive School, Upper and Lower Stages | Talvelantie 1 | Talvelavägen 1 | Talvelantie 1 | http://www.ymalmipk.edu.hel.fi | http://www.ymalmipk.edu.hel.fi | http://www.ymalmipk.edu.hel.fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 82930 | +358 9 310 82930 | www.ymalmipk.edu.hel.fi | Talvelantie 1,00700 Helsinki. | 2015-11-27T12:11:49+02:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:01:51.541449+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": null} | [1087, 1402] | helsinki | [1170, 1123, 1124, 1135, 1136, 1142, 1143, 1147, 1146, 1160, 1163, 1165, 1166, 2229, 1110, 1100, 331] | [904, 806, 662, 661, 121, 119, 117, 114, 108, 101, 37, 35, 28, 27, 16, 15, 1] | {"fi": ["koulu", "sali", "auditorio", "tilanvaraus", "tilavaraus", "yl\u00e4aste", "alaaste", "yl\u00e4koulu", "ala-aste", "alakoulu", "peruskoulu", "peruskoulut"], "sv": ["lokalbokning"], "en": ["reservation of premises", "basiceducation", "basic education"]} | Point | 25.000227 | 60.25494 | PL 70302, 00099 Helsingin kaupunki | Grundskolan Malmin peruskoulu | 2 | 2 | P.O. Box 70302, 00099 City of Helsinki | 2 | PB 70302, 00099 Helsingfors stad | 8 |
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 );