unit
2 rows where accessibility_shortcoming_count_visually_impaired = 8 and accessibility_shortcoming_count_wheelchair = 12
This data as json, CSV (advanced)
provider_type ✖
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7980 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://herttoniemenranta.munstadi.fi/tietoa-meista/aukioloajat/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Kysymys & vastauspalsta Pulmakulma", "sv": "Fr\u00e5ge- & svarspalten Pulmakulma", "en": "Forum for questions and answers"}, "www": {"fi": "http://www.nuoret.info/", "sv": "http://www.nuoret.info/", "en": "http://www.nuoret.info/"}, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Harrastushaku.fi", "sv": "Harrastushaku.fi", "en": "Harrastushaku.fi"}, "www": {"fi": "http://nk.hel.fi/harrastushaku/", "sv": "http://nk.hel.fi/harrastushaku/", "en": "http://nk.hel.fi/harrastushaku/"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 105}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 102}, {"value": "false", "variable": 79}, {"value": "true", "variable": 92}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "0", "variable": 1}, {"value": "true", "variable": 37}, {"value": "false", "variable": 21}, {"value": "true", "variable": 62}, {"value": "false", "variable": 53}, {"value": "false", "variable": 112}, {"value": "false", "variable": 111}, {"value": "false", "variable": 48}, {"value": "false", "variable": 104}, {"value": "false", "variable": 33}, {"value": "false", "variable": 98}, {"value": "true", "variable": 22}, {"value": "false", "variable": 114}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 58}, {"value": "true", "variable": 109}, {"value": "false", "variable": 44}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 113}, {"value": "true", "variable": 52}, {"value": "true", "variable": 20}, {"value": "false", "variable": 116}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 83}, {"value": "false", "variable": 96}, {"value": "false", "variable": 117}, {"value": "true", "variable": 59}, {"value": "over_20mm", "variable": 56}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 5}, {"value": "false", "variable": 29}, {"value": "true", "variable": 51}, {"value": "false", "variable": 49}, {"value": "true", "variable": 107}, {"value": "indoor_facility", "variable": 500}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "next_to_door_on_opening_side", "variable": 110}, {"value": "false", "variable": 97}, {"value": "false", "variable": 50}, {"value": "true", "variable": 57}, {"v… | internal | 3029 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Herttoniemenrannan nuorisotalo | Herttoniemenranta Youth Centre | Paasivaarankatu 6 | Paasivaaragatan 6 | Paasivaarankatu 6 | http://herttoniemenranta.munstadi.fi/ | http://herttoniemenranta.munstadi.fi/ | http://herttoniemenranta.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 757 0384 | herttoniemenrannan.nuorisotalo@hel.fi | +358 9 757 0384 | herttoniemenrannan.nuorisotalo@hnk.fi | 2008-09-09T20:14:31+03:00 | 00810 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:01.832172+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"} | [1403] | helsinki | [375, 399, 367, 366] | [468, 254, 231, 85] | {} | Point | 25.028568 | 60.190857 | PL 80403, 00099 Helsingin kaupunki | Hertonäs strands ungdomsgård | 4 | 12 | 2 | P.O. Box 80403, 00099 City of Helsinki | 1 | 12 | PB 80403, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||
18485 | [{"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": "P\u00e4iv\u00e4koti on auki klo 6-18, ennalta sovitun hoitotarpeen mukaan."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodin johtaja"}, "www": null, "email": "marita.heikkila@vantaa.fi", "phone": "+358 50 302 6472", "contact_person": "Marita Heikkil\u00e4"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.pahkinarinne@vantaa.fi", "phone": "+358 43 826 8108", "contact_person": "Mansikat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.pahkinarinne@vantaa.fi", "phone": "+358 43 826 8109", "contact_person": "Mustikat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.pahkinarinne@vantaa.fi", "phone": "+358 43 826 9111", "contact_person": "Puolukat"}, {"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Lapsiryhm\u00e4"}, "www": null, "email": "pk.pahkinarinne@vantaa.fi", "phone": "+358 43 826 8110", "contact_person": "Vaapukat"}, {"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": "indoor_facility", "variable": 500}, {"value": "false", "variable": 52}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "no_handrails", "variable": 47}, {"value": "0", "variable": 1}, {"value": "true", "variable": 40}, {"value": "true", "variable": 20}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 43}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 51}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 92}, {"value": "true", "variable": 59}, {"value": "false", "variable": 102}, {"value": "false", "variable": 98}, {"value": "false", "variable": 104}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 44}, {"value": "false", "variable": 27}, {"value": "false", "variable": 83}, {"value": "false", "variable": 34}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 6}, {"value": "false", "variable": 58}, {"value": "true", "variable": 25}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 106}, {"value": "false", "variable": 103}, {"value": "true", "variable": 38}, {"value": "false", "variable": 28}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 46}, {"value": "false", "variable": 50}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 48}, {"value": "false", "variable": 21}, {"value": "true", "variable": 31}, {"value": "true", "variable": 23}, {"value": "false", "variable": 84}, {"value": "true", "variable": 35}, {"value": "true", "variable": 57}, {"value": "true", "variable": 105}, {"value": "false", "variable": 49}, {"value": "over_20mm", "variable": 91}, {"value": "no_handrails", "variable": 41}, {"value": "true", "variable": 5}, {"value": "false", "variable": 107}, {"value": "true", "variable": 62}, {"value": "false", "variable": 37}, {"value": "sufficiently_wide", "variable": 18}, {"value": "ramp_under_6m_lon… | internal | 5263 | ab4f37d0-3e53-462e-ad40-c73b57e3e39e | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Päiväkodissa on neljä lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta.Meille on tärkeää lämpöisen ilmapiirin luominen, jossa lapsella on turvallista kasvaa ja kehittyä. Toimimme pienryhmissä tarjoten lapsille monipuolista, lapsen ikä- ja kehitystason huomioon ottavaa toimintaa.Harjoittelemme yhdessä arjen taitoja. Meillä askarrellaan, liikutaan eri tavoin, lauletaan ja musisoidaan päivittäin. Huolehdimme, että lasten leikeille on päivittäin riittävästi aikaa.Päiväkoti sijaitsee hyvien retkeily- ja ulkoilumaastojen lähellä, retket luontoon ja lähiympäristöön kuuluvat olennaisesti toimintaamme. Ympäristöstä huolehdimme mm. hoitamalla lasten ja perheiden kanssa Lammaslammen läheisyydessä olevaa ketoaluetta. Toiminnan suunnittelussa huomioimme lasten toiveet ja mielipiteet. Teemme työtä yhdessä vanhempien kanssa lasten parhaaksi. | Pähkinärinteen päiväkoti | Pähkinätie 12 | Hasselvägen 12 | Pähkinätie 12 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/varhaiskasvatus/palvelut/paivakodit/myyrmaki/pahkinarinteen_paivakoti | https://www.vantaa.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 8392 9271 | marita.heikkila@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01710 | www.vantaa.fi | kaikki | vantaa | 2020-11-05T16:31:11.985765+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, 1090, 2125, 871, 1089, 2122, 870] | [861, 663, 160] | {"fi": ["varhaiskasvatus", "p\u00e4iv\u00e4koti", "p\u00e4iv\u00e4hoito", "esiopetus", "eskari", "tarha", "lastentarha"]} | Point | 24.801819 | 60.264027 | PL 2429, 01030 Vantaan kaupunki | Päiväkodissa on neljä lapsiryhmää, joissa tarjoamme kokopäiväistä varhaiskasvatusta ja esiopetusta. | 5 | 12 | 2 | P.O. Box 2429, 01030 City of Vantaa | 1 | 10 | PB 2429, 01030 Vanda stad | 8 |
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 );