unit
2 rows where accessibility_shortcoming_count_stroller = 2 and "created_time" is on date 2014-03-26
This data as json, CSV (advanced)
Suggested facets: last_modified_time (date)
identifiers_2_namespace ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 );