unit
4 rows where accessibility_shortcoming_count_visually_impaired = 7 and data_source = "www.kauniainen.fi"
This data as json, CSV (advanced)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14404 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 70}, {"value": "0", "variable": 1}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 98}, {"value": "false", "variable": 92}, {"value": "true", "variable": 20}, {"value": "false", "variable": 104}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 118}, {"value": "false", "variable": 84}, {"value": "false", "variable": 83}, {"value": "true", "variable": 57}, {"value": "true", "variable": 22}, {"value": "false", "variable": 53}, {"value": "false", "variable": 33}, {"value": "true", "variable": 50}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 111}, {"value": "false", "variable": 116}, {"value": "true", "variable": 103}, {"value": "true", "variable": 113}, {"value": "false", "variable": 29}, {"value": "false", "variable": 38}, {"value": "true", "variable": 59}, {"value": "false", "variable": 44}, {"value": "false", "variable": 49}, {"value": "true", "variable": 109}, {"value": "true", "variable": 37}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 52}, {"value": "true", "variable": 58}, {"value": "false", "variable": 23}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 79}, {"value": "false", "variable": 51}, {"value": "false", "variable": 62}, {"value": "under_20mm", "variable": 56}, {"value": "true", "variable": 114}, {"value": "smooth", "variable": 17}, {"value": "2", "variable": 64}, {"value": "true", "variable": 117}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 107}, {"value": "true", "variable": 105}, {"value": "true", "variable": 5}, {"value": "true", "variable": 112}, {"value": "floor_2", "variable": 119}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 21}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 102}, {"value": "true", "variable": 115}, {"value": "false", "variable": 48}, {"value"… | internal | 4363 | 4a87368d-4a78-40ea-8a18-2a944f713ab5 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hagelstamska skolan | Läntinen Koulupolku 1-3 | Västra Skolstigen 1-3 | Läntinen Koulupolku 1-3 | http://www.hagelstamskaskolan.fi/fi | http://www.hagelstamskaskolan.fi/ | http://www.hagelstamskaskolan.fi/fi | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 322 4306 | hagelstamska.skolan@edu.grankulla.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-06-01T07:31:10.618752+03:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [986, 1087] | kauniainen | [1374, 2164, 2165] | [340, 339] | {"fi": ["ruotsinkielinen yl\u00e4aste"], "sv": ["h\u00f6gstadium", "hagelstam"]} | Point | 24.724125 | 60.214394 | Läntinen Koulupolku 3, 02700 Kauniainen | Hagelstamska skolan | Ruotsinkielinen yläkoulu Kauniaisissa. | 3 | 3 | Läntinen Koulupolku 3, 02700 Kauniainen | 1 | 3 | Västra Skolstigen 3, 02700 Grankulla | Svenskspråkig högstadieskola i Grankulla. | 7 | |||||||||||||||||||||||||||||||||
| 14409 | [{"section_type": "LINK", "name": {"fi": "Musiikkiopiston kotisivu"}, "www": {"fi": "http://kanslia@kaumo.fi"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 29}, {"value": "false", "variable": 62}, {"value": "true", "variable": 22}, {"value": "under_20mm", "variable": 56}, {"value": "under_20mm", "variable": 91}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 58}, {"value": "true", "variable": 37}, {"value": "false", "variable": 103}, {"value": "guided_and_clear", "variable": 19}, {"value": "true", "variable": 57}, {"value": "true", "variable": 20}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "true", "variable": 94}, {"value": "false", "variable": 97}, {"value": "false", "variable": 79}, {"value": "false", "variable": 21}, {"value": "true", "variable": 52}, {"value": "true", "variable": 51}, {"value": "false", "variable": 53}, {"value": "false", "variable": 5}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 107}, {"value": "2", "variable": 64}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 23}, {"value": "false", "variable": 44}, {"value": "false", "variable": 105}, {"value": "false", "variable": 102}, {"value": "true", "variable": 50}, {"value": "false", "variable": 83}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 84}, {"value": "true", "variable": 38}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 96}, {"value": "false", "variable": 70}, {"value": "false", "variable": 33}, {"value": "0", "variable": 1}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 48}, {"value": "true", "variable": 92}, {"value": "true", "variable": 59}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 34}] | internal | 4388 | 4a87368d-4a78-40ea-8a18-2a944f713ab5 | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | OTHER_PRODUCTION_METHOD | PRIVATE_ENTERPRISE | private_service | yksityinen palvelu | privat tjänst | private service | 1 | Kauniaisten musiikkiopisto on kaksikielinen musiikkioppilaitos, jossa annetaan musiikin laajan oppimäärän mukaista taiteen perusopetusta. Musiikkiopistossa on noin 500 oppilasta, joista varsinaisia oppilaita noin 230 ja musiikkileikkikoululaisia on runsaat 200. Musiikkiopistossa on myös yleinen osasto. | Kauniaisten musiikkiopisto | Valmukuja 3 | Vallmogränden 3 | Valmukuja 3 | http://www.kaumo.fi/ | http://www.kaumo.fi/ | http://www.kaumo.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 540 4440 | +358 9 5404 4444 | kanslia@kaumo.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-11-18T07:30:56.639265+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1087] | kauniainen | [1370] | [456] | {"fi": ["leirikoulu", "muskari", "opisto", "soitin", "soittimet", "taiteen perusopetus", "vauvamuskari"], "sv": ["babymusik", "institut", "instrument", "knattemusik", "musik", "musiklek", "musikutbildning"]} | Point | 24.732403 | 60.213978 | Valmukuja 3, 02700 Kauniainen | Grankulla musikinstitut | 5 | 8 | 1 | 8 | 7 | ||||||||||||||||||||||||||||||||||
| 14414 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://www.kauniainen.fi/kaupunki_ja_paatoksenteko/osallistu_ja_vaikuta"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Esiopetukseen hakeminen", "sv": "F\u00f6rskoleans\u00f6kan"}, "www": {"fi": "http://www.kauniainen.fi/kaupunki_ja_paatoksenteko/ajankohtaista/lomakkeet/k_-_o", "sv": "http://www.kauniainen.fi/sv/staden_och_beslutsfattande/aktuellt/blanketter/a-_j"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 116}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 111}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 105}, {"value": "false", "variable": 79}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 58}, {"value": "false", "variable": 83}, {"value": "false", "variable": 92}, {"value": "false", "variable": 44}, {"value": "true", "variable": 109}, {"value": "false", "variable": 49}, {"value": "false", "variable": 103}, {"value": "1_step", "variable": 39}, {"value": "smooth", "variable": 17}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 57}, {"value": "over_20mm", "variable": 91}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 62}, {"value": "false", "variable": 50}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "false", "variable": 5}, {"value": "false", "variable": 23}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 53}, {"value": "true", "variable": 107}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 22}, {"value": "false", "variable": 34}, {"value": "true", "variable": 115}, {"value": "false", "variable": 106}, {"value": "false", "variable": 98}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 117}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 112}, {"value": "false", "variable": 33}, {"value": "true", "variable": 38}, {"value": "false", "variable": 29}, {"value": "false", "variable": 20}, {"value": "false", "variable": 102}, {"value": "true", "variable": 37}, {"value": "true", "variable": 59}, {"value": "true", "variable": 52}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "false", "variable": 48}] | internal | 4395 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Daghemmet Grankotten | Palokunnantie 1-3 | Brandkårsvägen 1-3 | Palokunnantie 1-3 | http://www.kauniainen.fi/sv/utbildning_och_smabarnsfostran/smabarnsfostran/daghem/grankotten | http://www.kauniainen.fi/sv/utbildning_och_smabarnsfostran/smabarnsfostran/daghem/grankotten | http://www.kauniainen.fi/sv/utbildning_och_smabarnsfostran/smabarnsfostran/daghem/grankotten | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 379 0676 | daghemmet.grankotten@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:00:57.144057+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"} | [1405] | kauniainen | [882, 881] | [603] | {"sv": ["dagv\u00e5rd", "dagis"], "fi": ["lastenhoito", "p\u00e4iv\u00e4hoito", "eskari", "tarha"]} | Point | 24.718119 | 60.21223 | PL 52, 02700 Kauniainen | Daghemmet Grankotten | Ruotsinkielinen päiväkoti, 1-6-vuotiaille n. 48 paikkaa. | 3 | 7 | 2 | P.O. Box 52, 02700 Kauniainen | 1 | 7 | PB 52, 02700 Grankulla | Svenskspråkigt daghem för 1-6-åringar, ca. 48 platser. | 7 | ||||||||||||||||||||||||||||||||
| 14425 | [{"section_type": "ESERVICE_LINK", "name": {"fi": "Esiopetukseen hakeminen", "sv": "F\u00f6rskoleans\u00f6kan"}, "www": {"fi": "http://www.kauniainen.fi/kaupunki_ja_paatoksenteko/ajankohtaista/lomakkeet/k_-_o", "sv": "http://www.kauniainen.fi/sv/staden_och_beslutsfattande/aktuellt/blanketter/a-_j"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 79}, {"value": "long_term_stay", "variable": 60}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 5}, {"value": "true", "variable": 105}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "false", "variable": 23}, {"value": "false", "variable": 50}, {"value": "true", "variable": 59}, {"value": "false", "variable": 33}, {"value": "true", "variable": 104}, {"value": "false", "variable": 42}, {"value": "false", "variable": 92}, {"value": "false", "variable": 29}, {"value": "soft", "variable": 17}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "false", "variable": 102}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 44}, {"value": "false", "variable": 22}, {"value": "false", "variable": 103}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 58}, {"value": "false", "variable": 20}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 98}, {"value": "true", "variable": 62}, {"value": "true", "variable": 57}, {"value": "false", "variable": 52}, {"value": "false", "variable": 43}, {"value": "true", "variable": 40}, {"value": "false", "variable": 106}, {"value": "over_20mm", "variable": 91}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 49}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 83}, {"value": "false", "variable": 34}, {"value": "true", "variable": 37}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 107}, {"value": "true", "variable": 38}] | internal | 4368 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | ORGANIZATION | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Folkhälsans Barnträdgård | Eteläinen Heikelintie 5 | Södra Heikelvägen 5 | Eteläinen Heikelintie 5 | https://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/ostopalvelupaivakodit/folkhalsans_barntradgard | http://www.kauniainen.fi/sv/utbildning_och_smabarnsfostran/smabarnsfostran/daghem/daghem_av_vilka_staden_koper_tjanster/folkhalsans_barntradgard | https://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/ostopalvelupaivakodit/folkhalsans_barntradgard | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 356 5443 | forestandare.fhgrankulla@elisanet.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:00:57.203425+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"} | [1405] | kauniainen | [882, 881] | [603] | {"sv": ["dagv\u00e5rd", "dagis"], "fi": ["lastenhoito", "p\u00e4iv\u00e4hoito", "eskari", "tarha"]} | Point | 24.727036 | 60.215637 | PL 52, 02700 Kauniainen | Folkhälsans Barnträdgård | Ruotsinkielinen päiväkoti 3-6-vuotiaille. | 4 | 9 | 2 | P.O. Box 52, 02700 Kauniainen | 1 | 9 | PB 52, 02700 Grankulla | I barnträdgården fungerar två heldagsgrupper för barn i åldern 3-6 år. En av grupperna är förskola och den andra är en grupp för 3-5 åringar | Vår gård är mångsidig och ger möjlighet till olika aktiviteter. Våra barn leker, klättrar, spelar boll, undersöker naturen och åker skidor på gården.Barnträdgården arbetar enligt ett hälsofrämjande koncept som utarbetats av Folkhälsan och vilket vi kontinuerligt utvecklar i vår egen plan för småbarnsfostran samt läroplan för förskolan. Vi ser alla barn som enskilda individer och trygghet betonas. Riktlinjer i vår verksamhet är att barnen ska få leka - lära - uppleva med glädje.I vårt arbete kombinerar vi språk, musik, rörelse, drama och att skapa med våra händer. Vi experimenterar och laborerar genom lek. Vårt läge mitt i naturen ger ypperliga möjligheter till utfärder i naturen, vilket vi aktivt använder oss av.Vi arbetar för att ge barnen trygghet, vilket skapas av kommunikation och tydliga regler. Vi ser att glädje ger utrymme för god lek och fantasi. Vi uppmuntrar till omtänksamhet och tränar barnens sociala och empatiska förmågor genom bl.a. programmet StegVis, som utvecklats i syfte att förebygga mobbning. Stadens specialbarnträdgårdslärare stöder personalen i arbetet och ger individuellt stöd till enskilda barn vid behov. Vår egen talterapeut arbetar med barnen i barnträdgården en dag i veckan. | 7 |
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 );