unit
6 rows where accessibility_shortcoming_count_visually_impaired = 5 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14407 | [{"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": 49}, {"value": "true", "variable": 35}, {"value": "false", "variable": 5}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 111}, {"value": "false", "variable": 117}, {"value": "false", "variable": 103}, {"value": "true", "variable": 109}, {"value": "false", "variable": 27}, {"value": "false", "variable": 38}, {"value": "false", "variable": 29}, {"value": "false", "variable": 82}, {"value": "false", "variable": 28}, {"value": "true", "variable": 22}, {"value": "true", "variable": 50}, {"value": "true", "variable": 113}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 25}, {"value": "true", "variable": 104}, {"value": "true", "variable": 58}, {"value": "false", "variable": 92}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 84}, {"value": "true", "variable": 20}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 33}, {"value": "1", "variable": 1}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 57}, {"value": "false", "variable": 44}, {"value": "false", "variable": 79}, {"value": "true", "variable": 114}, {"value": "true", "variable": 37}, {"value": "false", "variable": 98}, {"value": "false", "variable": 53}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "under_20mm", "variable": 91}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}, {"value": "true", "variable": 112}, {"value": "smooth", "variable": 17}, {"value": "at_least_3600mm", "variable": 3}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 62}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 115}, {"value": "true", "variable": 51}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 116}, {"value": "false", "variable": 105}, {"value": "true… | internal | 4386 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kauniaisten kaupungin kansalaisopisto | The Adult Education Centre of Kauniainen | Pohjoinen Suotie 5 A | Norra Mossavägen 5 A | Pohjoinen Suotie 5 A | http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/kansalaisopisto | http://www.kauniainen.fi/sv/kultur_och_fritid/medborgarinstitutet | http://www.kauniainen.fi/kulttuuri_ja_vapaa-aika/kansalaisopisto | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 411 6404 | petra@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-11-18T07:30:56.609762+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] | kauniainen | [1371, 1365, 1361] | [665, 605, 244] | {"fi": ["aerobic", "dancing", "exercise", "exercising", "finnish", "fitness", "french", "german", "gymnastics", "handicraft", "health", "kansalaisopisto", "litteratur", "magdans", "matlagning", "mbi", "medborgarinstitut", "medis", "motion", "musik", "ruoanlaitto", "ruotsi", "ryska", "saksa", "senior", "seniori", "senioritanssi", "suomi", "taide", "tanssi", "terveys", "tietokone", "tiffany", "tilkkuty\u00f6", "ty\u00f6vis", "ty\u00f6v\u00e4enopisto", "vatsatanssi", "venyttely", "ven\u00e4j\u00e4", "viro", "voimistelu"], "sv": ["adb", "seniordans", "spanska", "spr\u00e5k", "stretching", "tyska", "vuxeninstitut", "vuxenutbildning", "v\u00e4vning", "yoga", "medborgarinstitut"], "en": ["adult education", "it", "italian", "literature", "music", "painting", "philosophy", "senior", "swedish", "yoga"]} | Point | 24.721117 | 60.21741 | Pohjoinen Suotie 5 A, 02700 Kauniainen | Grankulla stads medborgarinstitut | 2 | 4 | 1 | Pohjoinen Suotie 5 A, 02700 Kauniainen | 1 | 4 | Norra Mossavägen 5 A, 02700 Grankulla | 5 | |||||||||||||||||||||||||||||||||
| 14421 | [{"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": 29}, {"value": "false", "variable": 79}, {"value": "true", "variable": 112}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 37}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 115}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 62}, {"value": "false", "variable": 33}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 113}, {"value": "true", "variable": 59}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 23}, {"value": "true", "variable": 114}, {"value": "false", "variable": 84}, {"value": "false", "variable": 44}, {"value": "true", "variable": 52}, {"value": "true", "variable": 38}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 20}, {"value": "false", "variable": 49}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 34}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 22}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 83}, {"value": "false", "variable": 48}, {"value": "true", "variable": 109}, {"value": "true", "variable": 50}, {"value": "false", "variable": 53}, {"value": "false", "variable": 102}, {"value": "false", "variable": 103}, {"value": "true", "variable": 104}, {"value": "false", "variable": 21}, {"value": "true", "variable": 58}, {"value": "false", "variable": 111}, {"value": "true", "variable": 118}, {"value": "false", "variable": 92}, {"value": "false", "variable": 116}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 117}, {"value": "false", "variable": 106}, {"value": "false", "variable": 5}, {"value": "0", "variable": 1}, {"value": "true", "variable": 107}, {"value": "true", "variable": 57}, {"value": "true", "variable": 51}, {"value": "true", "variable": 105}, {"value": "long_term_stay", "variabl… | internal | 4394 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkodissamme on viisi eri ikäisille lapsille suunnattua ryhmää. Yksi ryhmistä tarjoaa ympärivuorokautista hoitoa. Esiopetusta järjestetään keskitetysti yhdessä ryhmässä. Päiväkotimme toiminnan suunnittelun kantavana ajatuksena on pienryhmätyöskentely ja pitkäkestoinen, keskeytymätön leikki. Tämän mahdollistavat päiväkodin monipuoliset tilat, mm. ateljé, liikuntasali, uima-allas ja pienryhmätila. Lasten liikunnalliset tarpeet on huomioitu myös piha-alueen suunnittelussa sekä hyödyntämällä päiväkodin läheisyydessä sijaitsevaa metsää ja liikuntapaikkoja. Ammattitaitoisen henkilökuntamme pyrkimyksenä on luoda turvallinen, suvaitseva ja kannustava kasvuympäristö jokaiselle lapselle.Pikku Akatemian päiväkoti on ammattikorkeakoulujen opiskelijoiden harjoittelupäiväkoti ja lisäksi teemme kehittämis- ja koulutusyhteistyötä pääkaupunkiseudun muiden kuntien kanssa. | Päiväkoti Pikku Akatemia | Akatemiantie 11-13 | Akademivägen 11-13 | Akatemiantie 11-13 | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/paivakoti_pikku_akatemia | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/paivakoti_pikku_akatemia | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/paivakoti_pikku_akatemia | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 341 5391 | pikku.akatemia@kauniainen.fi | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:00:57.187135+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 | [872, 883, 871, 882, 881, 870] | [663, 603, 200] | {"sv": ["dagv\u00e5rd", "dagis"], "fi": ["lastenhoito", "p\u00e4iv\u00e4hoito", "eskari", "tarha", "lastentarha"]} | Point | 24.714134 | 60.219692 | PL 52, 02700 Kauniainen | Päiväkoti Pikku Akatemia | suomenkielinen, 1-6-vuotiaille, vuorohoitoryhmä, n. 77 paikkaa | 4 | 7 | 1 | P.O. Box 52, 02700 Kauniainen | 1 | 7 | PB 52, 02700 Grankulla | finskspråkigt daghem, 1-6-åringar, ca. 77 platser | 5 | |||||||||||||||||||||||||||||||
| 14424 | [{"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": "over_20mm", "variable": 56}, {"value": "false", "variable": 29}, {"value": "0", "variable": 1}, {"value": "false", "variable": 106}, {"value": "false", "variable": 20}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 50}, {"value": "false", "variable": 34}, {"value": "true", "variable": 38}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 48}, {"value": "true", "variable": 22}, {"value": "true", "variable": 105}, {"value": "false", "variable": 53}, {"value": "false", "variable": 102}, {"value": "true", "variable": 37}, {"value": "false", "variable": 23}, {"value": "false", "variable": 5}, {"value": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 58}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 83}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 107}, {"value": "true", "variable": 104}, {"value": "false", "variable": 79}, {"value": "false", "variable": 44}, {"value": "true", "variable": 62}, {"value": "true", "variable": 51}, {"value": "false", "variable": 33}, {"value": "false", "variable": 103}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 57}, {"value": "true", "variable": 52}] | internal | 4396 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | PURCHASED_SERVICE | FOUNDATION | purchased_service | ostopalvelu | köpt tjänst | purchased service | 1 | Daghemmet Lyan | Gresantie 3-5 | Gräsavägen 3-5 | Gresantie 3-5 | https://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/ostopalvelupaivakodit/lyan | https://www.kauniainen.fi/sv/utbildning_och_smabarnspedagogik/smabarnspedagogik/daghem/daghem_av_vilka_staden_koper_tjanster/daghemmet_lyan | https://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/ostopalvelupaivakodit/lyan | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 300 3531 | stora.lyan@bensow.com | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:00:57.195316+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"} | [1405] | kauniainen | [882, 881] | [603] | {"sv": ["dagv\u00e5rd", "dagis"], "fi": ["lastenhoito", "p\u00e4iv\u00e4hoito", "eskari", "tarha"]} | Point | 24.73631 | 60.207855 | PL 52, 02700 Kauniainen | Daghemmet Lyan | ruotsinkielinen päiväkoti 1-7-vuotiaille. | 5 | 8 | P.O. Box 52, 02700 Kauniainen | 1 | 8 | PB 52, 02700 Kauniainen | Daghemmet Lyan består av Lilla Lyan med plats för 12 barn i åldern 1- 3 år samt Stora Lyan med plats för 30 barn i åldern 3 -7 år. | Lyan är beläget mitt i skogen men ändå på kort avstånd från stadens centrum. Detta ser vi som en stor fördel eftersom det ger möjlighet till uteaktiviteter av varierande slag.Även inomhusmiljön, på såväl Lilla som Stora Lyan, bjuder på estetik och hemkänsla.Personalstyrkan är 11 personer vilket inkluderar daghemmets egen husmor. På Lyan arbetar vi i kontinuerlig växelverkan med barnen. Det är synnerligen viktigt för oss alla att vara lyhörda för barnens behov, utveckling och erfarenheter. Samarbetet med föräldrarna är centralt och gemensamma samtal förs kontinuerligt.Vi vill bjuda på möjligheter till nya upplevelser och inlärningsmöjligheter med leken och experimenterandet som de viktigaste redskapen. Vi rör oss mycket i skog och mark och på vintern finns det fina möjligheter i vår egen terräng att skida samt att få öva sig på skridsko på den närbelägna skridskoplanen.Förutom leken som inlärningsmetod, i såväl ledd som fri verksamhet, har även musiken, drama och övrigt skapande en betydande roll på Lyan.Vårt mål är att barnen ska växa upp till trygga och rättvisa människor med en sund självkänsla och en stark tro på sig själva. | 5 | |||||||||||||||||||||||||||||||
| 14428 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna joka p\u00e4iv\u00e4 08-16", "sv": "\u00f6ppet varje dag 08-16", "en": "open every day 08-16"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"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": "true", "variable": 62}, {"value": "false", "variable": 22}, {"value": "under_20mm", "variable": 56}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 82}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "smooth", "variable": 17}, {"value": "at_least_3600mm", "variable": 3}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 83}, {"value": "false", "variable": 92}, {"value": "false", "variable": 38}, {"value": "true", "variable": 107}, {"value": "false", "variable": 79}, {"value": "over_10m", "variable": 4}, {"value": "true", "variable": 52}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 109}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 114}, {"value": "true", "variable": 118}, {"value": "false", "variable": 44}, {"value": "true", "variable": 117}, {"value": "true", "variable": 37}, {"value": "true", "variable": 116}, {"value": "true", "variable": 115}, {"value": "true", "variable": 58}, {"value": "true", "variable": 84}, {"value": "false", "variable": 102}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "false", "variable": 21}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 5}, {"value": "on_door", "variable": 110}, {"value": "3", "variable": 1}, {"value": "false", "variable": 49}, {"value": "false", "variable": 33}, {"value": "true", "variable": 113}, {"value": "false", "variable": 98}, {"value": "false", "variable": 53}, {"value": "true", "variable": 59}, {"value": "false", "variable": 103}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 106}, {"value": "true", "variable": 6}, {"value": "false", "variable": 34}, {"value": "true", "variable": 112}, {"value": "true", "variable": 80}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "sufficiently_wide", "variable": 18}, {"valu… | internal | 4377 | 7bf9f508-7534-427d-9229-09d5400fa5bc | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Villa Bredassa on eri kohderyhmille tarkoitettua päivä- ja ryhmätoimintaa, liikuntaa, tapahtumia, terveydenhuollon vastaanottopisteitä, ikäihmisille tarkoitettua palveluohjausta ja yksityisiä palveluntuottajia. Hoivayksikkö.Lounas arkisin 11-14.Toiminnassa painotetaan erityisesti kulttuuria ja musiikkia. | Palvelukeskus Villa Breda | Bredantie 16 | Bredavägen 16 | Bredantie 16 | http://www.kauniainen.fi/villabreda | http://www.grankulla.fi/vbreda | http://www.kauniainen.fi/villabreda | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 411 9268 | villa.breda@kauniainen.fi | +358 50 411 9268 | villa.breda@kauniainen.fi | http://www.kauniainen.fi/villabreda | 2014-03-26T16:39:26+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-11-05T16:31:07.968400+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "green", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "green"} | [783, 986] | kauniainen | [1040, 1033, 820, 824, 825, 823, 822] | [764, 762, 761, 760, 757, 355, 206] | {"fi": ["askartelu", "harrastus", "palvelukeskus", "ruokailu", "lounas", "hoivayksikk\u00f6", "kuntouttava p\u00e4iv\u00e4toiminta", "rikshapy\u00f6r\u00e4", "vuokrattavat tilat"], "sv": ["hobby", "mat", "motion", "m\u00e5ltid", "servicecenter", "boendeenhet", "lunch", "rehabiliterande dagsverksamhet", "rikshacykel", "utrymmen att hyra"]} | Point | 24.7192 | 60.211494 | PL 52, 02700 Kauniainen | Villa Breda servicecenter | Palvelukeskus ja hoivayksikkö | 1 | P.O. Box 52, 02700 Kauniainen | 1 | PB 52, 02700 Grankulla | Servicecenter och boendeenhet | Villa Breda inhyser verksamhet för olika målgrupper i form av dag- och gruppverksamhet, motion, evenemang, hälsovårdsmottagningar, servicehandledning för seniorer samt privata serviceproducenter. Boendeenhet.Lunch vardagar 11-14.Kultur och musik är särskilt viktiga inslag i verksamheten. | 5 | ||||||||||||||||||||||||||||||
| 14432 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-ti, to-pe 11-17, suljettu ke, la-su", "sv": "\u00f6ppet m\u00e5n-tis, tor-fre 11-17, st\u00e4ngt ons, l\u00f6r-s\u00f6n", "en": "open Mon-Tue, Thu-Fri 11-17, closed Wed, Sat-Sun"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat", "sv": "\u00d6ppettider", "en": "Opening hours"}, "www": {"fi": "http://www.helmet.fi/kirjasto/84779/Aukioloajat/", "sv": "http://www.helmet.fi/bibliotek/84779/Kontaktuppgifter/", "en": "http://www.helmet.fi/library/84779/Contact_information/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Elmer-kirjailijatietokanta", "sv": "Elmer-kirjailijatietokanta", "en": "Elmer-kirjailijatietokanta"}, "www": {"fi": "http://elmerinfo.net/", "sv": "http://elmerinfo.net/", "en": "http://elmerinfo.net/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Facebook", "sv": "Facebook", "en": "Facebook"}, "www": {"fi": "http://www.facebook.com/kirjasto.grani.bibban", "sv": "http://www.facebook.com/kirjasto.grani.bibban", "en": "http://www.facebook.com/kirjasto.grani.bibban"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 49}, {"value": "false", "variable": 29}, {"value": "false", "variable": 38}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 98}, {"value": "true", "variable": 62}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 34}, {"value": "false", "variable": 103}, {"value": "false", "variable": 116}, {"value": "true", "variable": 104}, {"value": "false", "variable": 102}, {"value": "true", "variable": 80}, {"value": "true", "variable": 107}, {"value": "0", "variable": 1}, {"value": "true", "variable": 51}, {"value": "false", "variable": 21}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 106}, {"value": "true", "variable": 5}, {"value": "false", "variable": 92}, {"value": "false", "variable": 83}, {"value": "true", "variable": 57}, {"value": "waiting_by_standing", "variable": 81}, {"value": "false", "variable": 53}, {"value": "false", "variable": 117}, {"value": "false", "variable": 111}, {"value": "true", "variable": 37}, {"value": "false", "variable": 82}, {"value": "false", "variable": 23}, {"value": "false", "variable": 22}, {"value": "false", "variable": 84}, {"value": "false", "variable": 114}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 109}, {"value": "true", "variable": 115}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "opens_automatically_with_motion_sensor", "variable": 54}, {"value": "short_term_stay", "variable": 60}, {"value": "on_door", "variable": 110}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "true", "variable": 59}, {"value": "true", "variable": 113}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "true", "variable": 6}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 112}, {"value": "false", "variable": 44}, {"value": "true", "… | internal | 4375 | kirkanta | 84779 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | https://kirkanta.kirjastot.fi/files/photos/medium/img-4184-577661737c748.jpg | Kirjasto on avoinna kaikille. Tarjoamme käyttöösi kirjoja, lehtiä, musiikkia, elokuvia, pelejä ja paljon muuta. Meillä on viihtyisät tilat ja ystävällinen henkilökunta, joka auttaa sinua mielellään.Voit käyttää tiloissamme tietokoneita ja joitain muita laitteita. Lukupaikkoja on ripoteltu ympäri kirjastoa: myös tutkijoille, opiskelijoille, nuorille ja lapsille. Pienimmät lapset pitävät varmasti leikkihuoneestamme. Tarvitset kirjastokortin ja PIN-koodin käyttääksesi kaikkia palveluitamme. Kortti on ilmainen, ja saat sen näyttämällä kuvallisen henkilöllisyystodistuksen. Kortilla voit käyttää myös muiden HelMet-kirjastojen palveluita.Kauniaisten kirjasto toimii omatoimikirjastona normaalien palveluaikojen ulkopuolella, aamuisin, iltaisin ja viikonloppuisin. Omatoimikirjastoon kirjaudutaan sisään kirjastokortilla ja pin-koodilla. Omatoimikirjaston ikäraja on 16 vuotta. | Our library is open to everyone. We have books, magazines and newspapers, music, movies, games and many more resources available. We have comfy facilities and friendly staff who is happy to assist you.You can use computers and other equipment in the library. Reading areas are scattered all over the library: for researchers, students, the youth and children alike. The smallest children are sure to enjoy our playroom.You will need a library card and pin code to be able use all our services. The card is free of charge and you can receive one by presenting an identity card that includes your photo. You can also use the card to access the services at other HelMet libraries.The library has extended self service opening hours outside of the regular opening hours, mornings, evenings and weekends. You can log in with your library card and pin code. The self service library is open to customers who are 16 years old or older. | Kauniaisten kirjasto | Kauniainen library | Thurmaninaukio 6 | Thurmansplatsen 6 | Thurmaninaukio 6 | http://www.kauniainen.fi/kirjasto | http://www.kauniainen.fi/kirjasto | http://www.kauniainen.fi/kirjasto | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 411 6504 | kirjasto@kauniainen.fi | +358 9 505 6400 | kirjasto@kauniainen.fi | 2011-03-22T15:51:43+02:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2021-01-04T07:30:52.432233+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [1402, 1403] | kauniainen | [328, 349] | [813] | {} | Point | 24.725943 | 60.21083 | Thurmaninaukio 6, 02700 KAUNIAINEN | Grankulla bibliotek | HelMet-kirjasto Kauniaisten keskustassa. | 1 | 4 | Thurmaninaukio 6, 02700 KAUNIAINEN | 1 | 4 | Thurmansplatsen 6, 02700 KAUNIAINEN | Ett HelMet-bibliotek i Grankulla centrum. | Biblioteket är öppet för alla. Hos oss hittar du böcker, tidningar, musik, filmer, spel och mycket annat. Biblioteket har trivsamma utrymmen och vänlig personal som gärna hjälper till när det behövs. Vi betjänar gärna på svenska!Våra datorer och annan teknisk utrustning står till ditt förfogande. I biblioteket finns läsplatser för alla från forskare och studerande till tonåringar och barn. De minsta barnen brukar uppskatta vårt sagorum med både böcker och leksaker.För att kunna använda alla våra tjänster behöver du ett bibliotekskort och en pin-kod. Du får ditt kort gratis genom att visa upp ett identitetsbevis med foto i biblioteket. Kortet gäller i alla HelMet-biblioteken. Biblioteket är meröppet utanför de normala servicetiderna, på morgnar, kvällar och helger. Du loggar in i det meröppna biblioteket med bibliotekskort och pin-kod. Åldersgränsen för det meröppna biblioteket är 16 år. | 5 | A HelMet library in Kauniainen. | |||||||||||||||||||||||
| 35022 | [{"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": 46}, {"value": "false", "variable": 102}, {"value": "false", "variable": 92}, {"value": "false", "variable": 34}, {"value": "true", "variable": 104}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 21}, {"value": "false", "variable": 84}, {"value": "false", "variable": 23}, {"value": "false", "variable": 53}, {"value": "outdoors", "variable": 2}, {"value": "false", "variable": 50}, {"value": "true", "variable": 105}, {"value": "false", "variable": 29}, {"value": "false", "variable": 103}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 33}, {"value": "true", "variable": 59}, {"value": "true", "variable": 52}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "4", "variable": 1}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 106}, {"value": "true", "variable": 62}, {"value": "false", "variable": 48}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 58}, {"value": "false", "variable": 20}, {"value": "over_20mm", "variable": 56}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 107}, {"value": "false", "variable": 98}, {"value": "false", "variable": 83}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 44}, {"value": "false", "variable": 22}, {"value": "false", "variable": 5}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "under_10m", "variable": 4}, {"value": "long_term_stay", "variable": 60}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 79}, {"value": "no_handrails", "variable": 47}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 51}, {"value": "true", "variable": 38}] | internal | 17336 | 8ba2f57e-0e4d-4050-b3ec-82f4dfc6c70c | 6f0458d4-42a3-434a-b9be-20c19fcfa5c3 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Lapsiryhmässä on n. 21 lasta ja henkilökuntaan kuuluu kaksi lastentarhanopettajaa ja lastenhoitaja.Kielikylpyperiaatteen mukaan henkilökunta puhuu lapsille ruotsia ja ympäristö muokataan tukemaan kielenomaksumista. Henkilökunta on kaksikielistä ja yhteistyö huoltajien kanssa tapahtuu suomenkielellä.Yleis- ja sisällölliset tavoitteet sekä toimintaperiaatteet, ovat kielikylvyssä samat kuin muillakin esikoululaisilla. Kielikylvyn tavoitteena on vaikuttaa myönteisesti asenteisiin uutta kieltä ja kulttuuria kohtaan. Toiminnassa omaksutaan esikoulupäivän arkeen liittyvää kieltä ja käsitteitä. Etätavoitteena on toiminnallinen ruotsinkieli.Huoltajilla on kielikylpyohjelmassa tärkeä rooli suomenkielen vahvistajina.Esikoulun jälkeen lasten kielikylpyohjelma jatkuu Mäntymäen koulun kielikylpyluokilla. | Kielikylpy Grani | Stenbergintie 30 | Stenbergsvägen 30 | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/kielikylpy_grani_sprakbad | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/kielikylpy_grani_sprakbad | http://www.kauniainen.fi/koulutus_ja_varhaiskasvatus/varhaiskasvatus/paivakodit/kielikylpy_grani_sprakbad | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 411 8949 | 2014-06-27T11:22:20+03:00 | 02700 | www.kauniainen.fi | kaikki | kauniainen | 2020-10-05T10:01:15.883560+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 | [876, 871, 882, 881, 870] | [663, 603, 294] | {"fi": ["kielikylpy", "eskari", "tarha"], "sv": ["spr\u00e5kbad"]} | Point | 24.706387 | 60.214813 | Språkbad Grani | Ruotsinkielinen kielikylpy on kaksivuotinen ja se on suunnattu suomenkielisten kotien 5 ja 6- vuotiaille lapsille. | 3 | 6 | 2 | 1 | 5 | Svenskspråkigt språkbad, två-årigt för 5-6 åringar med finska som hemspråk. | 5 |
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 );