9 rows where accessibility_shortcoming_count_visually_impaired = 8 and accessibility_shortcoming_count_wheelchair = 8

View and edit SQL

Suggested facets: accessibility_shortcoming_count_stroller

provider_type

accessibility_shortcoming_count_wheelchair

accessibility_shortcoming_count_visually_impaired

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
58 [{"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 76858", "contact_person": "Sillman-Rejstr\u00f6m Pia"}, {"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": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 83}, {"value": "0", "variable": 1}, {"value": "true", "variable": 51}, {"value": "true", "variable": 94}, {"value": "false", "variable": 21}, {"value": "true", "variable": 57}, {"value": "false", "variable": 58}, {"value": "false", "variable": 53}, {"value": "over_20mm", "variable": 56}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 117}, {"value": "true", "variable": 92}, {"value": "true", "variable": 107}, {"value": "false", "variable": 97}, {"value": "false", "variable": 5}, {"value": "false", "variable": 34}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 106}, {"value": "false", "variable": 102}, {"value": "true", "variable": 104}, {"value": "true", "variable": 20}, {"value": "false", "variable": 103}, {"value": "false", "variable": 44}, {"value": "false", "variable": 23}, {"value": "true", "variable": 52}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "true", "variable": 37}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 62}, {"value": "false", "variable": 96}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 38}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "over_20mm", "variable": 91}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 59}, {"value": "true", "variable": 113}, {"value": "true", "variable": 50}, {"value": "false", "variable": 33}, {"value": "true", "variable": 105}, {"value": "true", "variable": 22}, {"value": "true", "variable": 112}, {"value": "false", "variable": 109}, {"value": "sufficiently_wide", "variable": 18}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 49}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "true", "variable": 114}, {"value": "true", "variable": 115}, {"value": "true"… internal 386     44916bd9-058c-43f2-a676-8f69a0b5d69b 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Daghemmet Strandboden Day care Strandboden Prammikuja 3 Bramgränden 3 Prammikuja 3 https://www.hel.fi/varhaiskasvatus/sv/daghem/strandboden https://www.hel.fi/varhaiskasvatus/sv/daghem/strandboden https://www.hel.fi/varhaiskasvatus/sv/daghem/strandboden   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 44881, +358 9 310 44876 +358 9 310 28820 +358 9 310 44881 pk.strandboden@hel.fi   2007-11-15T00:00:00+02:00 00980 www.hel.fi kaikki helsinki 2020-12-03T13:00:51.782289+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"} [1405] helsinki [882, 881] [603] {"fi": ["varhaiskasvatus", "tarha"], "en": ["daycare", "day care"]} Point 25.121248 60.200584 PL 98312, 00099 Helsingin kaupunki         Daghemmet Strandboden   4 8     1 P.O. Box 98312, 00099 City of Helsinki 1     8   PB 98312, 00099 Helsingfors stad     8      
7112 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Kuraattori", "sv": "Kuraattori", "en": "Kuraattori"}, "www": null, "email": null, "phone": "+358 40 648 4445", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Psykologi", "sv": "Psykologi", "en": "Psykologi"}, "www": null, "email": null, "phone": "+358 50 512 5090", "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": "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": 62}, {"value": "true", "variable": 50}, {"value": "true", "variable": 37}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 91}, {"value": "3", "variable": 64}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 23}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 53}, {"value": "false", "variable": 79}, {"value": "false", "variable": 34}, {"value": "true", "variable": 52}, {"value": "false", "variable": 57}, {"value": "false", "variable": 21}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 102}, {"value": "false", "variable": 106}, {"value": "true", "variable": 40}, {"value": "false", "variable": 29}, {"value": "true", "variable": 104}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 92}, {"value": "true", "variable": 105}, {"value": "false", "variable": 103}, {"value": "0", "variable": 1}, {"value": "false", "variable": 70}, {"value": "false", "variable": 33}, {"value": "true", "variable": 38}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 20}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 22}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 107}, {"value": "false", "variable": 98}, {"value": "false", "variable": 5}, {"value": "long_term_stay", "variable": 60}, {"value": "over_20mm", "variable": 56}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 51}, {"value": "false", "variable": 44}] internal 16960     cfe981a5-3493-4432-b3b1-7945dc2c7fa3 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Munkkiniemen ala-asteen koulu Munkkiniemi Comprehensive School, Lower Stage Tietokuja 1 Datagränden 1 Tietokuja 1 http://www.munka.edu.hel.fi http://www.munka.edu.hel.fi http://www.munka.edu.hel.fi   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 82229   +358 50 595 4444 heikki.eskola@hel.fi https://www.munka.edu.hel.fi 2015-11-27T12:11:49+02:00 00330 www.hel.fi kaikki helsinki 2020-12-03T13:00:58.689765+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, 1129, 1135, 1142, 1146, 1100, 331] [806, 661, 108, 35, 27, 21, 15] {"fi": ["koulu", "peruskoulut", "peruskoulu"], "en": ["basiceducation", "basic education"]} Point 24.875952 60.202244 PL 33303, 00099 Helsingin kaupunki         Lågstadieskolan Munkkiniemen ala-asteen koulu   6 8     1 P.O. Box 33303, 00099 City of Helsinki       8   PB 33303, 00099 Helsingfors stad     8      
15352 [{"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": 98}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 94}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 53}, {"value": "false", "variable": 38}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "false", "variable": 62}, {"value": "true", "variable": 20}, {"value": "true", "variable": 37}, {"value": "true", "variable": 96}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 22}, {"value": "false", "variable": 79}, {"value": "over_20mm", "variable": 56}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "true", "variable": 105}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variable": 23}, {"value": "true", "variable": 58}, {"value": "true", "variable": 35}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "true", "variable": 52}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "false", "variable": 49}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 59}, {"value": "true", "variable": 50}, {"value": "false", "variable": 107}, {"value": "true", "variable": 106}, {"value": "false", "variable": 5}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 102}, {"value": "0", "variable": 1}, {"value": "false", "variable": 44}, {"value": "false", "variable": 97}, {"value": "true", "variable": 51}, {"value": "false", "variable": 70}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 92}, {"value": "false", "variable": 21}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "2", "variable": 64}] internal 4430     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             Mainingin koulu on vasta peruskorjattu musiikki- ja tanssipainotteinen yhtenäinen peruskoulu, jossa on luokat 1. - 9. Koulun oppilasmäärä on 518. Koulun tavoitteena on kasvattaa oppilaat työskentelemään yhdessä ja hankkimaan ja soveltamaan itsenäisesti tietoja ja taitoja. Koulussa arvostetaan työntekoa ja tervettä itsetuntoa sekä korostetaan vastuuntuntoa, suvaitsevaisuutta ja hyvää käytöstä. Luokilla 3. - 9. on musiikkiluokat, yksi kullakin luokkatasolla. Yläluokilla on myös tanssipainotus. Mainingin koulu is a nine-year comprehensive school providing primary and secondary education. The school has specialist music classes from Year 3 to Year 9 and specialist dance classes from Year 7 to 9.The school was built in 1974 and it is the first comprehensive school in Finland to comprise both the six-year primary level and the lower secondary level (Year 7 to Year 9).There are approximately 520 pupils and 55 teachers at Mainingin koulu.   Mainingin koulu Mainingin koulu Maininkitie 23 Dyningsvägen 23 Maininkitie 23 http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Yhtenaiset_peruskoulut/Mainingin_koulu http://espoo.fi/fi-FI/Kasvatus_ja_opetus/Perusopetus/Peruskoulut/Yhtenaiset_peruskoulut/Mainingin_koulu http://www.espoo.fi/en-US/Childcare_and_education/Comprehensive_education   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8163 0194         2015-11-03T12:03:45+02:00 02320 www.espoo.fi kaikki espoo 2020-03-13T09:31:04.820462+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] espoo [1123, 1141, 1134, 1146, 1165, 1166, 1110, 1100] [662, 661, 121, 119, 108, 34, 33, 15] {"fi": ["yl\u00e4aste", "ala-aste", "koulu"]} Point 24.643406 60.15232 PL 3429, 02070 ESPOON KAUPUNKI           Mainingin koulu on vasta peruskorjattu musiikki- ja tanssipainotteinen yhtenäinen peruskoulu, jossa on luokat 1. - 9. Koulun oppilasmäärä on 518. 6 8     1 P.O. Box 3429, 02070 ESPOO CITY 1     8   PB 3429, 02070 ESBO STAD     8 Mainingin koulu is a nine-year comprehensive school providing primary and secondary education.    
15510 [{"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": 44}, {"value": "false", "variable": 111}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 117}, {"value": "false", "variable": 112}, {"value": "false", "variable": 102}, {"value": "false", "variable": 113}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 107}, {"value": "floor_3", "variable": 108}, {"value": "false", "variable": 105}, {"value": "true", "variable": 109}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 104}, {"value": "true", "variable": 114}, {"value": "false", "variable": 83}, {"value": "false", "variable": 84}, {"value": "false", "variable": 82}, {"value": "false", "variable": 92}, {"value": "false", "variable": 79}, {"value": "false", "variable": 80}, {"value": "false", "variable": 98}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 75}, {"value": "true", "variable": 76}, {"value": "3", "variable": 63}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 115}, {"value": "true", "variable": 78}, {"value": "false", "variable": 103}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 62}, {"value": "false", "variable": 59}, {"value": "true", "variable": 70}, {"value": "false", "variable": 55}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 57}, {"value": "true", "variable": 72}, {"value": "true", "variable": 52}, {"value": "false", "variable": 53}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "false", "variable": 48}, {"value": "true", "variable": 50}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "true", "variable": 73}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "true", "variable": 40}, {"value": "true", "variable": 38}, {"value": "false", "variable": 42}, {"value": "false", "variable": 33}, {"value": "true", "variable": 37}, {"value": "false", "variable": 43}, {"value": "at_least_4_steps", "variable":… internal 4581     828201f3-df6c-42e5-8239-fac577c3b248 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Espoon nuorisopoliklinikka   Komentajankatu 5 A, 3. krs Kommendörsgatan 5 A, 3. vån. Komentajankatu 5 A, 3. floor http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Koululaiset_ja_opiskelijat/Nuorisopoliklinikka http://espoo.fi/sv-FI/Social_och_halsovard/Sjuk_och_halsovard/Skolelever_och_studerande/Ungdomspoliklinik http://espoo.fi/fi-FI/Sosiaali_ja_terveyspalvelut/Terveyspalvelut/Koululaiset_ja_opiskelijat/Nuorisopoliklinikka   pvm/mpm lna/msa local network charge/mobile call charge   +358 43 825 9828   +358 43 825 9826     2015-11-03T12:03:45+02:00 02600 www.espoo.fi kaikki espoo 2020-07-14T12:31:01.198554+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, 1087] espoo [2164, 2165, 2166, 2167] [863, 339] {"fi": ["keskusteluapua", "nupoli", "ohjaaja", "psykologi ja perheterapeutti", "terveydenhoitaja"]} Point 24.821558 60.21566 PL 2533, 02070 Espoon kaupunki           13 - 22 vuotiaiden espoolaisten nuorten perusterveydenhuollon mielenterveys- ja päihdepalveluyksikkö. 3 8     2 P.O. Box 2533, 02070 Espoon kaupunki 1     8   PB 2533, 02070 Espoon kaupunki     8      
15624 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] [{"value": "smooth", "variable": 17}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 104}, {"value": "true", "variable": 105}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 23}, {"value": "true", "variable": 37}, {"value": "false", "variable": 5}, {"value": "false", "variable": 29}, {"value": "false", "variable": 79}, {"value": "true", "variable": 62}, {"value": "false", "variable": 52}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 51}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 107}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 22}, {"value": "false", "variable": 38}, {"value": "true", "variable": 25}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}, {"value": "false", "variable": 106}, {"value": "false", "variable": 92}, {"value": "false", "variable": 21}, {"value": "false", "variable": 28}, {"value": "true", "variable": 35}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "false", "variable": 58}, {"value": "0", "variable": 1}, {"value": "false", "variable": 44}, {"value": "false", "variable": 102}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 27}, {"value": "false", "variable": 33}, {"value": "true", "variable": 59}] internal 4562     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Karamäen päiväkoti   Kalasääksenkuja 4 Fiskgjusgränden 4 Kalasääksenkuja 4 http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Karamaen_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Karamaen_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Karamaen_paivakoti   pvm/mpm lna/msa local network charge/mobile call charge   +358 40 552 1524   +358 9 8163 6005 tuula.mikkonen-grohn@espoo.fi   2015-11-03T12:03:45+02:00 02620 www.espoo.fi kaikki espoo 2020-03-20T13:30:54.675895+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"} [1405] espoo [871, 870] [663] {"fi": ["eskari", "tarha", "lastentarha"]} Point 24.772429 60.23041             päiväkoti 5 8     2   1     8         8      
15738 [{"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": 84}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 29}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 57}, {"value": "false", "variable": 22}, {"value": "false", "variable": 28}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "indoor_facility", "variable": 500}, {"value": "no_handrails", "variable": 26}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 25}, {"value": "false", "variable": 104}, {"value": "true", "variable": 112}, {"value": "false", "variable": 50}, {"value": "true", "variable": 62}, {"value": "false", "variable": 103}, {"value": "true", "variable": 37}, {"value": "opens_easily_manually", "variable": 54}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 43}, {"value": "false", "variable": 52}, {"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "false", "variable": 34}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 40}, {"value": "true", "variable": 115}, {"value": "true", "variable": 51}, {"value": "false", "variable": 105}, {"value": "false", "variable": 116}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 33}, {"value": "true", "variable": 107}, {"value": "false", "variable": 79}, {"value": "false", "variable": 102}, {"value": "true", "variable": 23}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 59}, {"value": "false", "variable": 117}, {"value": "false", "variable": 48}, {"value": "false", "variable": 5}, {"value": "false", "variable": 20}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "false", "variable": 98}, {"value": "true", "variable": 113}, {"value": "false", "variable": 109}, {"value": "true", "variable": 114}, {"value": "false", "variable": 44}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "0", "variable": 1}, … internal 4777     d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Laaksolahden päiväkoti   Laaksolahdentie 1 A Dalsvikvägen 1 A Laaksolahdentie 1 A http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Laaksolahden_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Laaksolahden_paivakoti http://www.espoo.fi/fi-FI/Kasvatus_ja_opetus/Varhaiskasvatus/Varhaiskasvatuksen_toimipaikat/Kunnalliset_paivakodit/Leppavaara/Laaksolahden_paivakoti   pvm/mpm lna/msa local network charge/mobile call charge   +358 46 877 1502   +358 9 8163 6049 sirkka.lehto@espoo.fi   2015-11-03T12:03:45+02:00 02720 www.espoo.fi kaikki espoo 2020-11-05T13:01:01.492394+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] espoo [879, 1090, 2125, 871, 870] [861, 861, 663, 160, 160] {"fi": ["tarha", "eskari", "lastentarha"]} Point 24.74733 60.240055             päiväkotiesiopetus 5 8     1   1     8         8      
18379 [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 09-15", "sv": "\u00f6ppet m\u00e5n-fre 09-15", "en": "open Mon-Fri 09-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Kerho toimii ti ja ke klo 9-12 ja to klo 12-14.30"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "mervi.pykalaniemi@vantaa.fi", "phone": "+358 40 742 0327", "contact_person": "Mervi Pyk\u00e4l\u00e4niemi"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Vihertien asukaspuisto"}, "www": null, "email": "vihertien.asukaspuisto@vantaa.fi", "phone": "+358 50 318 1657", "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Luontokerho"}, "www": null, "email": null, "phone": "+358 50 303 0852", "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": "true", "variable": 37}, {"value": "false", "variable": 98}, {"value": "false", "variable": 79}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 34}, {"value": "false", "variable": 44}, {"value": "true", "variable": 57}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 52}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 38}, {"value": "false", "variable": 49}, {"value": "false", "variable": 33}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 58}, {"value": "true", "variable": 6}, {"value": "multipurpose_sport_hall", "variable": 61}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 20}, {"value": "false", "variable": 50}, {"value": "true", "variable": 22}, {"value": "false", "variable": 104}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 84}, {"value": "sport_facility", "variable": 60}, {"value": "false", "variable": 92}, {"value": "smooth", "variable": 17}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 83}, {"value": "false", "variable": 29}, {"value": "false", "variable": 105}, {"value": "true", "variable": 40}, {"value": "true", "variable": 62}, {"value": "false", "variable": 102}, {"value": "false", "variable": 43}, {"value": "false", "variable": 103}, {"value": "true", "variable": 59}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "false", "variable": 107}, {"value": "false", "variable": 23}, {"value": "false", "variable": 80}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 51}, {"value": "false", "variable": 48}, {"value": "true", "variable": 5}] internal 5170     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/thrS8hhNfKrL     ‍Vihertien avoimessa asukaspuistossa on tarjolla monipuolista ohjattua toimintaa. Toiminta on tarkoitettu alle kouluikäisille lapsille ja heidän vanhemmilleen. Avoimen toimintaan osallistuminen ei vaadi ennakkoilmoittautumista.Avoin varhaiskasvatustoiminta on suunnitelmallista ja tavoitteellista. Asukaspuistossa noudatetaan soveltuvin osin Vantaan varhaiskasvatussuunnitelmaa. Asukaspuistossa lapsi ja hänen huoltajansa tai muu läheinen saavat mahdollisuuden tavata toisia lapsia ja aikuisia sekä osallistua ohjattuun toimintaan.Asiakkaat voivat osallistua toiminnan suunnitteluun, toteutukseen ja arviointiin.Annamme vanhemmille tukea ja ohjausta lapsen kasvatukseen ja kasvuun liittyvissä asioissa sekä muista lapsiperheille suunnatuista palveluista. Viherpuisto on avoin kohtaamispaikka kaikille aikuisille ja lapsille ja on avoinna päivittäin 9-15. Viherpuistossa on joka päivä ohjattua toimintaa.Ohjatut tuokiot alkavat 10.15. Tuokiot ovat liikuntaa, lauluja ja loruja, erilaisia ratoja, satuja, perheluontotuokioita ja kaikkea yhdessä tekemistä.Viherpuistossa on leluja, jotka ovat aukioloaikana kaikkien käytettävissä. Talvella ulkotulet sytytetään joka perjantai. Kesäisin meillä on käytössä grilli, jolloin on mahdollista grillata omia eväitä. Viherpuistossa lapset ovat aina vanhempien vastuulla. Lapset eivät voi olla puistossa ilman oman aikuisen valvontaa.Toimipisteessämme järjestetään myös maksutonta kerhotoimintaa 2,5-5-vuotiaille kotihoidossa oleville lapsille. Viherin luontokerhoon haetaan varhaiskasvatushakemuksella. Lisätietoja saa soittamalla tai toimipisteissä ohjaajilta.Lämpimästi tervetuloa kaikenikäiset Viherpuistoon!     Vihertien asukaspuisto   Vihertie 56d Grönvägen 56d Vihertie 56d 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   +358 9 8393 4786 -   2014-11-19T17:01:21+02:00 01620 www.vantaa.fi kaikki vantaa 2020-11-05T16:31:11.668034+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, 1403, 1405] vantaa [976, 978, 69, 500, 981] [475, 288, 86] {"fi": ["varhaiskasvatus", "kerhotoiminta", "avoin p\u00e4iv\u00e4koti", "kerho", "asukaspuisto", "puisto", "leikkipuisto"]} Point 24.848387 60.27317 PL 2578, 01030 Vantaan kaupunki   Vihertien asukaspuisto. Kuva: Vantaan kaupunki.       Vihertien avoimessa asukaspuistossa on tarjolla monipuolista ohjattua toimintaa alle kouluikäisille lapsille ja heidän vanhemmilleen. 5 8   Vihertien asukaspuisto. Bild: Vanda stad. 2 P.O. Box 2578, 01030 City of Vantaa 1     8   PB 2578, 01030 Vanda stad     8     Vihertien asukaspuisto. Photo: City of Vantaa.
35385 [{"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": 44}, {"value": "false", "variable": 84}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 48}, {"value": "false", "variable": 79}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 52}, {"value": "false", "variable": 23}, {"value": "false", "variable": 51}, {"value": "false", "variable": 29}, {"value": "false", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 5}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}, {"value": "false", "variable": 21}, {"value": "false", "variable": 103}, {"value": "false", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 92}, {"value": "false", "variable": 102}, {"value": "false", "variable": 38}, {"value": "true", "variable": 62}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 49}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 37}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 50}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 57}, {"value": "false", "variable": 20}, {"value": "false", "variable": 105}, {"value": "true", "variable": 22}, {"value": "true", "variable": 59}] internal 16972     6c92d0db-4ee8-414c-9527-b2cf2704739b 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       http://www.espoo.fi/materiaalit/asuminen_ja_ymparisto/muut_aineistot/palvelukartan_kuvat/Kurkijoentienleikkipaikka_palvelukartta.JPG           Kurkijoentien leikkipaikka Kurkijoentie playground Kurkijoentie 24, 02140 Espoo Kronoborgsvägen 24, 02140 Espoo   https://www.espoo.fi/fi-FI/Asuminen_ja_ymparisto/Asuminen/Asukastoiminta/Asukas_ja_leikkipuistot https://www.esbo.fi/sv-FI/Boende_och_miljo/Boende/Invanarverksamhet/Lekparker https://www.espoo.fi/en-US/Housing_and_environment   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8162 5100         2015-11-03T12:03:45+02:00 02140 www.espoo.fi kaikki espoo 2020-03-13T09:31:33.691407+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, 1403] espoo [70, 501] [389] {"sv": ["lek", "barn", "fritid", "lekpark", "lekparken", "lekplats"], "fi": ["leikkipuisto", "lapset", "leikkipaikka", "leikki", "vapaa-aika"], "en": ["leisure time spending", "chidren", "children\u00bfs play park", "kids", "leisure time", "playground"]} Point 24.805912 60.20396           Kronoborgsvägens lekplats   6 8     1   1     8         8      
39371 [{"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": "Ohjattuun liikuntaan ilmoittautuminen"}, "www": {"fi": "https://resurssivaraus.espoo.fi/ohjattuliikunta/haku"}, "email": null, "phone": null, "contact_person": null}] [{"value": "false", "variable": 92}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 104}, {"value": "true", "variable": 25}, {"value": "false", "variable": 103}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "false", "variable": 80}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 28}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 5}, {"value": "false", "variable": 44}, {"value": "false", "variable": 58}, {"value": "false", "variable": 21}, {"value": "true", "variable": 51}, {"value": "false", "variable": 107}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 37}, {"value": "false", "variable": 102}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 79}, {"value": "true", "variable": 53}, {"value": "true", "variable": 62}, {"value": "true", "variable": 50}, {"value": "gym", "variable": 61}, {"value": "true", "variable": 23}, {"value": "false", "variable": 83}, {"value": "true", "variable": 59}, {"value": "false", "variable": 98}, {"value": "false", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "false", "variable": 22}, {"value": "false", "variable": 48}, {"value": "true", "variable": 20}, {"value": "false", "variable": 105}, {"value": "false", "variable": 33}, {"value": "false", "variable": 27}, {"value": "sport_facility", "variable": 60}, {"value": "indoor_facility", "variable": 500}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 34}, {"value": "false", "variable": 38}, {"value": "false", "variable": 84}, {"value": "false", "variable": 49}, {"value": "true", "variable": 57}] internal 13716 lipas 78491 d8dab34f-a68f-4244-b906-84e7f651b8e1 520a4492-cb78-498b-9c82-86504de88dce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1       https://c1.staticflickr.com/5/4291/36005831562_997b8f3acb_b.jpg     Olarin kuntosalilla on sekä ohjattua että vapaaharjoittelutoimintaa.     Olarin kuntosali   Yläportti 4 a-b Överporten 4 a-b Yläportti 4 a-b http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit http://www.espoo.fi/fi-FI/Kulttuuri_ja_liikunta/Liikunta/Liikunta_ja_ulkoilupaikat/Kuntosalit   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 816 21         2014-09-05T13:29:21+03:00 02210 www.espoo.fi kaikki espoo 2020-11-25T08:01:31.709075+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 [611] [350] {} Point 24.734371 60.175503           Olars gym   4 8     2   1     8         8      

Advanced export

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

CSV options:

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