unit
2 rows where accessibility_shortcoming_count_rollator = 4, accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_wheelchair = 5
This data as json, CSV (advanced)
Suggested facets: last_modified_time (date)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 376 | [{"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 73783", "contact_person": "Starkkila Kristiina"}, {"section_type": "LINK", "name": {"fi": "T\u00e4yt\u00e4 p\u00e4iv\u00e4hoitohakemus", "sv": "Ans\u00f6kan om barndagv\u00e5rd", "en": "Application for day care"}, "www": {"fi": "https://www.hel.fi/Helsinki/fi/paivahoito-ja-koulutus/paivahoito/paivakotihoito/hakeminen", "sv": "https://www.hel.fi/helsinki/sv/dagvard-och-utbildning/dagvord/ansokan/ansokan-dagvard", "en": "https://www.hel.fi/helsinki/en/day-care-education/day-care/options/applying"}, "email": null, "phone": null, "contact_person": null}, {"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": "true", "variable": 105}, {"value": "true", "variable": 70}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 38}, {"value": "false", "variable": 76}, {"value": "false", "variable": 44}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 116}, {"value": "false", "variable": 98}, {"value": "true", "variable": 20}, {"value": "false", "variable": 109}, {"value": "smooth", "variable": 17}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 5}, {"value": "true", "variable": 58}, {"value": "false", "variable": 22}, {"value": "false", "variable": 83}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 52}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 59}, {"value": "true", "variable": 107}, {"value": "true", "variable": 74}, {"value": "true", "variable": 113}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 48}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 75}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 117}, {"value": "true", "variable": 6}, {"value": "false", "variable": 72}, {"value": "true", "variable": 23}, {"value": "false", "variable": 103}, {"value": "true", "variable": 115}, {"value": "true", "variable": 73}, {"value": "true", "variable": 37}, {"value": "true", "variable": 104}, {"value": "long_term_stay", "variable": 60}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 62}, {"value": "false", "variable": 92}, {"value": "false", "variable": 114}, {"value": "false", "variable": 21}, {"value": "false", "variable": 79}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 78}, {"value": "0", "variable": 1}, {"value": "false", "variable": 33}, {"value": "false", "variable": 53}, {"value": "sufficiently_wide", "variable": 18}, {"value": "… | internal | 875 | 203f6084-59f4-4498-975a-3bc2d73d9012 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkoti Savotta | Day care Savotta | Puunkaatajantie 16 | Trädfällarvägen 16 | Puunkaatajantie 16 | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/savotta | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/savotta | https://www.hel.fi/varhaiskasvatus/fi/paivakodit/savotta | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 73783, +358 9 310 73612 | pk.savotta@hel.fi | +358 9 310 73783 | kristiina.starkkila@hel.fi | 2007-11-15T00:00:00+02:00 | 00760 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:00:54.483441+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] | helsinki | [879, 1090, 2125, 871, 870] | [861, 861, 663, 160, 160] | {"fi": ["kes\u00e4aukiolo", "eskari", "varhaiskasvatus", "tarha", "lastentarha", "Esiopetus 2021-2022"], "en": ["day care", "preprimaryeducation", "pre-primary education", "preschool", "daycare"]} | Point | 25.068752 | 60.272545 | PL 76997, 00099 Helsingin kaupunki | Päiväkoti Savotta | 2 | 5 | 2 | P.O. Box 76997, 00099 City of Helsinki | 1 | 4 | PB 76997, 00099 Helsingfors stad | 7 | |||||||||||||||||||||||||||||||
| 19717 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 06-18", "sv": "\u00f6ppet m\u00e5n-fre 06-18", "en": "open Mon-Fri 06-18"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloaika on klo 6-18 ennalta sovitun tarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "tuomo.seppanen@vantaa.fi", "phone": "+358 40 577 0992", "contact_person": "Tuomo Sepp\u00e4nen"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 50 303 4065", "contact_person": "Hein\u00e4hukat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 50 303 4065", "contact_person": "Kissankirput"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.misteli@vantaa.fi", "phone": "+358 43 827 0337", "contact_person": "M\u00e4ntymittarit"}, {"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": "false", "variable": 21}, {"value": "false", "variable": 49}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "true", "variable": 5}, {"value": "true", "variable": 35}, {"value": "true", "variable": 6}, {"value": "false", "variable": 102}, {"value": "false", "variable": 48}, {"value": "true", "variable": 115}, {"value": "0", "variable": 1}, {"value": "under_20mm", "variable": 91}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 44}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 103}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 104}, {"value": "true", "variable": 29}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 84}, {"value": "false", "variable": 109}, {"value": "true", "variable": 38}, {"value": "false", "variable": 117}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 116}, {"value": "true", "variable": 20}, {"value": "true", "variable": 107}, {"value": "true", "variable": 114}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 50}, {"value": "1_step", "variable": 39}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "false", "variable": 52}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 51}, {"value": "false", "variable": 22}, {"value": "false", "variable": 83}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 92}, {"value": "false", "variable": 33}, {"value": "false", "variable": 46}, {"value": "true", "variable": 37}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 105}, {"value": "true", "variable": 112}, {"value": "false", "variable": 23}, {"value": "true", "variable": 62}, {"value": "false", "variable": 57}, {"value": "true", "variable": 113}, {"value": "false", "variable": 34}, {"value": "same_floor_as_entrance", "variable… | internal | 5521 | ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kolmessa lapsiryhmässä.Myös Tikkurilan alueen kunnallista ja yksityistä perhepäivähoitoa.Päiväkoti sijaitsee Ruskeasannan vehreällä pientaloalueella, Helsinki-Vantaa -lentoaseman läheisyydessä.Päiväkotimme on v.1997 valmistunut arkkitehti Mikko Kairan suunnittelema hirsirakennus, jonka rakenteissa ja materiaaleissa on pyritty luontoystävällisyyteen. Päiväkodin pihalta löytyy omenapuita ja marjapensaita. Kesäisin kasvatamme omalla kasvimaalla kukkia ja vihanneksia.Mistelissä on tilat kolmelle lapsiryhmälle. Lapset ovat iältään 1-6 -vuotiaita ja ryhmät muodostetaan toimintavuosittain huomioiden lasten määrä ja ikä.Lapsille luodaan mahdollisuus toteuttaa itseään ja kehittää persoonallisuuttaan virikkeellisessä, turvallisessa ja myönteisessä ilmapiirissä. Kestävän kehityksen periaatteet ovat toimintamme ydinajatuksena. Tämän mukaisesti pyrimme lasten, perheiden ja päiväkodin henkilökunnan fyysisen, henkisen ja sosiaalisen hyvinvoinnin edistämiseen huomioon ottaen luonnon ja ympäristön arvot toiminnassamme. Avoin vuorovaikutus kaikkien kesken on jatkuva tavoite. | Mistelin päiväkoti | Mistelin päiväkoti | Tulppaanitie 44, | Tulpanvägen 44, | Tulppaanitie 44, | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/tikkurila/mistelin_paivakoti | http://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem | http://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/day_care_centers | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8392 4743 | pk.misteli@vantaa.fi | http://www.vantaa.fi/fi/opetus_ja_kasvatus/paivahoito/paivahoito_vantaalla_toimintayksikoittain/tikkurilan_paivahoitopalvelut/ruskeasannan_toimintayksikko | 2014-11-19T17:01:21+02:00 | 01390 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:15.041752+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] | vantaa | [879, 962, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 506, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "perhep\u00e4iv\u00e4hoito", "eskari", "tarha", "lastentarha", "p\u00e4iv\u00e4hoito", "esiopetus"]} | Point | 25.00423 | 60.315914 | PL 4420, 01030 Vantaan kaupunki | Mistelin päiväkoti | Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kolmessa lapsiryhmässä.Myös kunnallista ja yksityistä perhepäivähoitoa. | 2 | 5 | 2 | P.O. Box 4420, 01030 City of Vantaa | 1 | 4 | PB 4420, 01030 Vanda stad | 2 |
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 );