unit
9 rows where accessibility_shortcoming_count_visually_impaired = 8 and accessibility_shortcoming_count_wheelchair = 8
This data as json, CSV (advanced)
Suggested facets: accessibility_shortcoming_count_stroller
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | pk.strandboden@hel.fi | +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 | etunimi.sukunimi@vantaa.fi | +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 | liikunta@espoo.fi | 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
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 );