unit
3 rows where accessibility_shortcoming_count_wheelchair = 11 and "created_time" is on date 2014-11-19
This data as json, CSV (advanced)
Suggested facets: department
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18264 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-to 08-16, pe 08-15", "sv": "\u00f6ppet m\u00e5n-tor 08-16, fre 08-15", "en": "open Mon-Thu 08-16, Fri 08-15"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "eeva.pursimo@vantaa.fi", "phone": "+358 50 310 5978", "contact_person": "Eeva Pursimo"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Asukaspuisto"}, "www": null, "email": null, "phone": "+358 50 318 1446", "contact_person": "Korson asukaspuisto"}, {"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}, {"section_type": "LINK", "name": {"fi": "Korson asukaspuiston nettisivut"}, "www": {"fi": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html", "sv": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html", "en": "https://sivistysvantaa.fi/korsonasukaspuisto/index.html"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "SOCIAL_MEDIA_LINK", "name": {"fi": "Korson asukaspuiston Facebook -sivut"}, "www": {"fi": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/", "sv": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/", "en": "https://www.facebook.com/Korson-Asukaspuisto-131748693662193/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "ramp_under_6m_long", "variable": 45}, {"value": "false", "variable": 106}, {"value": "true", "variable": 22}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 84}, {"value": "false", "variable": 46}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 104}, {"value": "false", "variable": 53}, {"value": "true", "variable": 44}, {"value": "true", "variable": 62}, {"value": "false", "variable": 92}, {"value": "false", "variable": 33}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 29}, {"value": "false", "variable": 58}, {"value": "false", "variable": 50}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "false", "variable": 83}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 40}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 5}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 49}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "no_handrails", "variable": 47}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 79}, {"value": "false", "variable": 98}, {"value": "false", "variable": 107}, {"value": "false", "variable": 43}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "0", "variable": 1}, {"value": "false", "variable": 48}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 105}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "true", "variable": 38}, {"value": "false", "variable": 23}] | internal | 5196 | ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Korson asukaspuisto järjestämme kerhotoimintaa ja avointa toimintaa. | Korson asukaspuisto | Korson asukaspuisto | Korsontie 11 | Korsovägen 11 | Korsontie 11 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/asukaspuistot_ja_avoimet_paivakodit/korso | http://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/klubbar_och_oppna_daghem | http://www.vantaa.fi/day_care_and_education/early_childhood_education/early_childhood_education_options/residential_parks_and_open_day_care_centers | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 50 318 1446 | USRHSELGRU | 2014-11-19T17:01:21+02:00 | 01450 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:11.351330+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"} | [1400, 1403, 1405] | vantaa | [976, 978, 69, 500, 981] | [475, 288, 86] | {"fi": ["asukaspuisto", "kerhotoiminta", "avoin varhaiskasvatus"]} | Point | 25.06948 | 60.353107 | PL 6551, 01030 Vantaan kaupunki | Korson asukaspuisto | Korson asukaspuisto järjestämme kerhotoimintaa ja avointa toimintaa. | 7 | 11 | 2 | P.O. Box 6551, 01030 City of Vantaa | 1 | 10 | PB 6551, 01030 Vanda stad | 6 | |||||||||||||||||||||||||||||
| 18788 | [{"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": "johanna.sandholm@vantaa.fi", "phone": "+358 43 825 4750", "contact_person": "Johanna Sandholm"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 314 5706", "contact_person": "Auringons\u00e4teet ja Kuunsirpit"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 312 1713", "contact_person": "Lounatuulet ja P\u00e4iv\u00e4ns\u00e4teet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 304 1997", "contact_person": "Kumpupilvet ja Poutapilvet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 3030 8744", "contact_person": "Revontulet"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4t"}, "www": null, "email": "pk.ita-hakkila@vantaa.fi", "phone": "+358 50 312 1604", "contact_person": "T\u00e4hdenlennot ja T\u00e4htisumut"}, {"section_type": "LINK", "name": {"fi": "Anna palautetta", "sv": "Ber\u00e4tt\u00e4 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": 92}, {"value": "true", "variable": 107}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "false", "variable": 50}, {"value": "false", "variable": 103}, {"value": "false", "variable": 84}, {"value": "true", "variable": 23}, {"value": "false", "variable": 28}, {"value": "true", "variable": 37}, {"value": "true", "variable": 25}, {"value": "false", "variable": 52}, {"value": "soft", "variable": 17}, {"value": "false", "variable": 115}, {"value": "true", "variable": 20}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 44}, {"value": "true", "variable": 62}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 79}, {"value": "false", "variable": 38}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 58}, {"value": "false", "variable": 112}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 105}, {"value": "true", "variable": 22}, {"value": "sufficiently_wide", "variable": 18}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "false", "variable": 49}, {"value": "true", "variable": 114}, {"value": "on_door", "variable": 110}, {"value": "false", "variable": 117}, {"value": "false", "variable": 111}, {"value": "false", "variable": 83}, {"value": "0", "variable": 1}, {"value": "true", "variable": 109}, {"value": "true", "variable": 113}, {"value": "false", "variable": 98}, {"value": "true", "variable": 104}, {"value": "true", "variable": 116}, {"value": "false", "variable": 31}, {"value": "false", "variable": 102}, {"value": "true", "variable": 29}, {"value": "false", "variable": 5}… | internal | 5286 | 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 kahdeksassa lapsiryhmässä sekä kerhotoimintaa jokaisena arkipäivänä.Päiväkodissa on kahdeksan ryhmää ja kerhoryhmä. Kerhotoimintaa jokaisena arkipäivänä klo 8.30-11 (2-3 -vuotiaat) ja klo 12-15 (4-5 -vuotiaat).Päiväkotimme sijaitsee viihtyisässä kasvuympäristössä metsän ympäröimänä. Toiminta-ajatuksenamme on tarjota lapselle kokemuksellista ja elämyksellistä varhaiskasvatusta yhteistyössä vanhempien kanssa. Tarjoamme monipuolista toimintaa, sopivasti haasteita ja onnistumisen kokemuksia kaikille. Päiväkodissamme lapsia ohjaavat motivoituneet ja ammattitaitoiset kasvattajat, joilla on halu kehittää työtä ja intoa uusille asioille. Pidämme tärkeänä, että vanhemmat voivat luottavaisin ja rauhallisin mielin tuoda lapsensa meille päivähoitoon. | Itä-Hakkilan päiväkoti | Itä-Hakkilan päiväkoti | Keskustie 1-3 | Centralvägen 1-3 | Keskustie 1-3 | https://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/hakunila/ita-hakkilan_paivakoti | https://www.vanda.fi/smabarnspedagogik_och_utbildning/smabarnspedagogik/olika_alternativ/daghem | https://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 8393 0871 | etunimi.sukunimi@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01260 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:12.910009+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, 978, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 288, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "kerho", "p\u00e4iv\u00e4hoito", "esiopetus", "eskari", "tarha", "lastentarha"]} | Point | 25.111595 | 60.29504 | PL 8421, 01030 Vantaan kaupunki | Itä-Hakkilan päiväkoti | Päiväkotimme tarjoaa varhaiskasvatusta ja esiopetusta kahdeksassa lapsiryhmässä sekä kerhotoimintaa jokaisena arkipäivänä. | 7 | 11 | 2 | P.O. Box 8421, 01030 City of Vantaa | 1 | 10 | PB 8421, 01030 Vanda stad | 4 | |||||||||||||||||||||||||||||
| 24112 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 37}, {"value": "false", "variable": 58}, {"value": "true", "variable": 38}, {"value": "true", "variable": 92}, {"value": "false", "variable": 62}, {"value": "false", "variable": 117}, {"value": "over_20mm", "variable": 91}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 116}, {"value": "false", "variable": 44}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 70}, {"value": "false", "variable": 22}, {"value": "1_step", "variable": 24}, {"value": "false", "variable": 49}, {"value": "false", "variable": 103}, {"value": "false", "variable": 52}, {"value": "false", "variable": 109}, {"value": "1_step", "variable": 39}, {"value": "false", "variable": 83}, {"value": "true", "variable": 20}, {"value": "true", "variable": 104}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 97}, {"value": "false", "variable": 115}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 5}, {"value": "true", "variable": 114}, {"value": "false", "variable": 98}, {"value": "opens_easily_manually", "variable": 54}, {"value": "true", "variable": 107}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 113}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 51}, {"value": "false", "variable": 105}, {"value": "false", "variable": 112}, {"value": "false", "variable": 84}, {"value": "false", "variable": 79}, {"value": "0", "variable": 1}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variable": 48}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "true", "variable": 6}, {"value": "false", "variable": 21}, {"value": "false", "variable": 96}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "false", "variable": 34}, {"value": "false", "variable": 29}, {"value": "2… | internal | 7286 | 744852ab-9425-4329-9d1d-96fe0f132f63 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kuraattori auttaa lasta ja nuorta esimerkiksi perhetilanteeseen liittyvissä asioissa, kaverisuhteissa ja koulunkäyntiin liittyvissä kysymyksissä. Oppilaan tilannetta helpottavia ratkaisuja etsitään yhdessä oppilaan ja huoltajien kanssa. Kuraattori voi tavata oppilasta koulussa kahden kesken tai yhdessä perheen tai muiden läheisten kanssa. Tapaamisten sisältö muotoutuu oppilaan tarpeiden mukaan. | Kuraattoripalvelut / Kivistön koulu | Vanha Nurmijärventie 132 | Gamla Nurmijärvivägen 132 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/perusopetus/koululaisen_hyvinvointi_ja_terveys/koulukuraattoripalvelut | http://www.vanda.fi/smabarnspedagogik_och_utbildning/grundlaggande_utbildning/valmaende_och_halsa/skolkuratorstjanster | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 8393 4981 | etunimi.sukunimi@vantaa.fi | +358 40 532 7344 | tiina.turkia@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01700 | www.vantaa.fi | kaikki | vantaa | 2020-03-13T09:31:22.234430+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] | vantaa | [1374] | [340] | {} | Point | 24.845444 | 60.316532 | Vanha Nurmijärventie 132, 01700 Vantaa | Kuratorservice / Kivistön koulu | Kuraattoreiden tehtävänä on tukea lasten ja nuorten koulunkäyntiä, hyvinvointia sekä kasvua ja kehitystä. | 3 | 11 | 1 | 11 | 4 |
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 );