unit
3 rows where accessibility_shortcoming_count_visually_impaired = 8 and "last_modified_time" is on date 2020-12-04
This data as json, CSV (advanced)
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15875 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "0", "variable": 1}, {"value": "false", "variable": 96}, {"value": "true", "variable": 59}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 105}, {"value": "false", "variable": 38}, {"value": "false", "variable": 48}, {"value": "true", "variable": 62}, {"value": "false", "variable": 104}, {"value": "true", "variable": 79}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 107}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 5}, {"value": "false", "variable": 58}, {"value": "false", "variable": 51}, {"value": "true", "variable": 92}, {"value": "false", "variable": 49}, {"value": "false", "variable": 83}, {"value": "true", "variable": 37}, {"value": "false", "variable": 97}, {"value": "true", "variable": 52}, {"value": "false", "variable": 44}, {"value": "sufficiently_wide", "variable": 18}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 22}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 98}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 29}, {"value": "false", "variable": 94}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 50}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "false", "variable": 33}, {"value": "false", "variable": 102}, {"value": "false", "variable": 53}, {"value": "true", "variable": 57}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "over_20mm", "variable": 91}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "true", "variable": 20}] | internal | 4859 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://www.esbo.fi/download/noname/%7B74E5A8B5-608A-44A8-9279-3E35B3190D78%7D/77978 | Mattbergets daghem och förskola on osa Mattlidenin koulukeskusta, jossa on sekä päiväkoti, esikoulu, peruskoulu että lukio samassa paikassa. Toimimme alueella kolmessa rakennuksessa.Päiväkoti ja esikoulu tarjoavat turvallisen ja mielekkään toimintaympäristön. Annamme lapselle mahdollisuuden ja tuen, jotta se voi kehittyä itsenäiseksi yksilöksi, joka osaa toimia ryhmässä ja otta toiset huomioon. Yhdessä huoltajien kanssa tuemme lapsen kehitystä ja tarjoamme sopivia haasteita.Esikouluopetuksen tehtävänä on voimistaa lapsen positiivista omakuvaa sekä käsitystä itsestään oppivana indiviidinä.Meillä on neljä lapsiryhmää 0-5 vuotiaille sekä neljä esikouluryhmää.Mattbergets daghem och förskola on perustettu 1985. | Mattbergets daghem och förskola | Matinsyrjä 5 | Mattliden 5 | Matinsyrjä 5 | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Forskoleundervisning/Forskolor/Mattbergets_forskola | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Forskoleundervisning/Forskolor/Mattbergets_forskola | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Forskoleundervisning/Forskolor/Mattbergets_forskola | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 1751 | +358 9 8163 0640 | 2015-11-03T12:03:45+02:00 | 02230 | www.espoo.fi | kaikki | espoo | 2020-12-04T15:31:03.805542+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 | [887, 1094, 2129, 882, 881] | [862, 603, 160] | {"fi": ["ruotsinkielinen p\u00e4iv\u00e4hoito", "ruotsinkielinen p\u00e4iv\u00e4koti", "ruotsinkielinen varhaiskasvatus", "ruotsinkielinen esikoulu", "p\u00e4iv\u00e4koti matinkyl\u00e4ss\u00e4", "esikoulu matinkyl\u00e4ss\u00e4", "eskari"], "sv": ["daghem", "f\u00f6rskola", "esbo stads daghem", "kommunalt daghem", "sm\u00e5barnspedagogik", "svensk dagv\u00e5rd", "dagis", "dagv\u00e5rd", "daghem i mattby", "f\u00f6rskola i mattby"]} | Point | 24.74914 | 60.164165 | Mattbergets daghem och förskola | Mattbergets daghem och förskola | Mattbergets daghem och förskola on osa Mattlidenin koulukeskusta, jossa on sekä päiväkoti, esikoulu, peruskoulu että lukio samassa paikassa. | 6 | 9 | Mattbergets daghem och förskola | 1 | 1 | 9 | PB 23302, 02070 ESBO STAD | Mattbergets daghem och förskola är en del av Mattlidens skolcentrum med både daghem, förskola, grundskola och gymnasium på samma område. | Mattbergets daghem och förskola är en del av Mattlidens skolcentrum med både daghem, förskola, grundskola och gymnasium på samma område. Vi arbetar i tre byggnader på området.Daghemmet och förskolan erbjuder en trygg och meningsfull verksamhetsmiljö. Vi ger barnet möjlighet och stöd att utvecklas till en självständig individ med förmåga att fungera i grupp och ta hänsyn till andra. I samarbete med vårdnadshavarna stöder vi barnets utveckling och erbjuder lämpliga utmaningar.Förskoleundervisningens uppdrag är att stärka barnets positiva självbild och uppfattning om sig själv som lärande individ.Vi har 4 barngrupper för 0-5 åringar samt 4 förskolegrupper.Mattbergets daghem och förskola är grundad 1985. | 8 | |||||||||||||||||||||||||||||
| 15879 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://easiointi.espoo.fi/eFeedback/fi/Home"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "1", "variable": 1}, {"value": "false", "variable": 98}, {"value": "false", "variable": 31}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 103}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "true", "variable": 104}, {"value": "true", "variable": 25}, {"value": "false", "variable": 43}, {"value": "false", "variable": 109}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 113}, {"value": "false", "variable": 92}, {"value": "false", "variable": 114}, {"value": "true", "variable": 105}, {"value": "true", "variable": 58}, {"value": "true", "variable": 27}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 28}, {"value": "false", "variable": 46}, {"value": "at_least_4_steps", "variable": 24}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 29}, {"value": "false", "variable": 20}, {"value": "true", "variable": 57}, {"value": "handrails_on_both_sides", "variable": 32}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 59}, {"value": "false", "variable": 34}, {"value": "false", "variable": 79}, {"value": "false", "variable": 106}, {"value": "false", "variable": 48}, {"value": "false", "variable": 84}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 102}, {"value": "true", "variable": 62}, {"value": "true", "variable": 107}, {"value": "true", "variable": 37}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 49}, {"value": "true", "variable": 118}, {"value": "true", "variable": 6}, {"value": "true", "variable": 117}, {"value": "true", "variable": 112}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "less_than_3600mm", "variable": 3}, {"value": "smooth", "variable": 17}, {"value": "tru… | internal | 4695 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://www.esbo.fi/download/noname/%7BF473F488-E849-4AF3-9D7F-2E6F3101C8AA%7D/77853 | Niperts daghem on jaettu kolmeen ryhmään; Kattfot (kissankäpälä), Blåklocka (kissankello) ja Solros (auringonkukka).Lasten paras on toimintakulttuurissamme etusijalla. Pyrimme antamaan stimuloivan sekä monipuolisen oppimisympäristön kaikille lapsille. Perusajatuksena on ilo, turvallisuus ja laatu.Päiväkoti on perustettu 2010. | Niperts daghem | Nikunpelto 1 | Nikuåkern 1 | Nikunpelto 1 | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Esbo_centrum__Norra_Esbo/Niperts_daghem(3303) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Esbo_centrum__Norra_Esbo/Niperts_daghem(3303) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Esbo_centrum__Norra_Esbo/Niperts_daghem(3303) | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 43 826 8867 | +358 9 8168 3821 | sara.wallius@esbo.fi | 2015-11-03T12:03:45+02:00 | 02920 | www.espoo.fi | kaikki | espoo | 2020-12-04T15:31:03.843129+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 | [882, 881] | [603] | {"sv": ["dagv\u00e5rd", "daghem", "daghem i nipert", "daghem i norra esbo", "esbo stads daghem", "kommunalt daghem", "sm\u00e5barnspedagogik", "svensk dagv\u00e5rd", "dagis"], "fi": ["ruotsinkielinen p\u00e4iv\u00e4hoito", "ruotsinkielinen p\u00e4iv\u00e4koti", "ruotsinkielinen varhaiskasvatus", "p\u00e4iv\u00e4koti niipperiss\u00e4", "p\u00e4iv\u00e4koti pohjois-espoossa"]} | Point | 24.74889 | 60.27496 | Niperts daghemin leikkipaikka | Niperts daghem | Niperts daghem on jaettu kolmeen ryhmään; Kattfot (kissankäpälä), Blåklocka (kissankello) ja Solros (auringonkukka). | 2 | 5 | Niperts daghems lekplats | 1 | 1 | 5 | PB 92301, 02070 ESBO STAD | Niperts daghem är fördelat på tre avdelningar, Kattfot, Blåklocka och Solros. | Niperts daghem är fördelat på tre avdelningar, Kattfot, Blåklocka och Solros.Barnets bästa ligger i fokus för vår verksamhetskultur. Vi vill erbjuda en stimulerande och mångsidig inlärningsmiljö för alla barn. Grundpelaren är glädje, trygghet och kvalitet.Daghemmet är grundat 2010. | 8 | ||||||||||||||||||||||||||||
| 32391 | [{"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": 23}, {"value": "no_handrails", "variable": 26}, {"value": "indoor_facility", "variable": 500}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 31}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 105}, {"value": "false", "variable": 22}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value": "0", "variable": 1}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 106}, {"value": "false", "variable": 79}, {"value": "false", "variable": 34}, {"value": "true", "variable": 50}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 33}, {"value": "false", "variable": 84}, {"value": "false", "variable": 98}, {"value": "true", "variable": 59}, {"value": "true", "variable": 20}, {"value": "true", "variable": 6}, {"value": "true", "variable": 62}, {"value": "false", "variable": 48}, {"value": "false", "variable": 49}, {"value": "false", "variable": 104}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 103}, {"value": "true", "variable": 37}, {"value": "false", "variable": 102}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 21}, {"value": "true", "variable": 25}, {"value": "at_least_4_steps", "variable": 24}, {"value": "no_handrails", "variable": 32}, {"value": "false", "variable": 92}, {"value": "true", "variable": 51}, {"value": "false", "variable": 28}, {"value": "true", "variable": 5}, {"value": "false", "variable": 107}, {"value": "under_20mm", "variable": 56}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 58}, {"value": "false", "variable": 83}, {"value": "false", "variable": 44}, {"value": "true", "variable": 29}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 57}, {"value": "false", "variable": 38}] | internal | 15135 | d8dab34f-a68f-4244-b906-84e7f651b8e1 | 520a4492-cb78-498b-9c82-86504de88dce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://www.esbo.fi/download/noname/%7B94F09313-D108-46ED-A82A-CC8AECF3B8B0%7D/77838 | Ruotsinkielinen ryhmäperhepäiväkoti Olarissa. | Meteorgatans gruppfamiljedaghem | Meteorinkatu 5 B | Meteorgatan 5 B | Meteorinkatu 5 B | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Meteorgatans_gruppfamiljedaghem(3288) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Meteorgatans_gruppfamiljedaghem(3288) | https://www.esbo.fi/sv-FI/Utbildning_och_fostran/Smabarnspedagogik/Kommunal_smabarnspedagogik/Hagalund__Mattby__Olars/Meteorgatans_gruppfamiljedaghem(3288) | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 46 877 3278 | +358 9 8168 3389 | 2015-11-03T12:03:45+02:00 | 02210 | www.espoo.fi | kaikki | espoo | 2020-12-04T15:31:20.144630+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 | [882, 881, 964] | [604, 603] | {"sv": ["dagv\u00e5rd", "daghem", "esbo stads daghem", "kommunalt daghem", "svensk dagv\u00e5rd", "daghem i olars", "gruppfamiljedaghem", "dagis"], "fi": ["ruotsinkielinen p\u00e4iv\u00e4hoito", "ruotsinkielinen p\u00e4iv\u00e4koti", "ruotsinkielinen varhaiskasvatus", "espoon kaupungin p\u00e4iv\u00e4koti", "p\u00e4iv\u00e4koti olarissa", "ruotsinkielinen ryhm\u00e4perhep\u00e4iv\u00e4koti"]} | Point | 24.733541 | 60.168983 | Meteorgatans gruppfamiljedaghem | Meteorgatans gruppfamiljedaghem | Ruotsinkielinen ryhmäperhepäiväkoti Olarissa. | 4 | 5 | Meteorgatans gruppfamiljedaghem | 1 | 1 | 4 | PB 21308, 02070 ESBO STAD | Gruppfamiljedaghem beläget i Olars. | Gruppfamiljedaghem beläget i Olars. | 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 );