unit
4 rows where accessibility_shortcoming_count_stroller = 2 and accessibility_shortcoming_count_wheelchair = 13
This data as json, CSV (advanced)
Suggested facets: contract_type_description_sv, street_address_sv, address_postal_full_fi
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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8058 | [{"section_type": "OPENING_HOURS", "name": {"fi": "Aukioloajat"}, "www": {"fi": "http://harju.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": "2", "variable": 64}, {"value": "true", "variable": 23}, {"value": "true", "variable": 105}, {"value": "false", "variable": 117}, {"value": "false", "variable": 21}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 102}, {"value": "false", "variable": 33}, {"value": "false", "variable": 104}, {"value": "false", "variable": 79}, {"value": "true", "variable": 92}, {"value": "true", "variable": 37}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 49}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 106}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 98}, {"value": "true", "variable": 112}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 48}, {"value": "false", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 114}, {"value": "true", "variable": 113}, {"value": "false", "variable": 115}, {"value": "false", "variable": 50}, {"value": "true", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 62}, {"value": "false", "variable": 29}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 57}, {"value": "true", "variable": 107}, {"value": "true", "variable": 59}, {"value": "false", "variable": 44}, {"value": "true", "variable": 94}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "rough", "variable": 17}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "true", "variable": 5}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 70}, {"value": "true", "variable": 38}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 22}, {"value": "1_step", "variable": 24}, {"value": "0", "variable": 1}, {"value": "true", "variable": 116}, {"value": "true", "variab… | internal | 3093 | cfe4d81b-7366-4ae2-b87b-b986e10cd220 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | http://happi.munstadi.fi/files/2016/10/Harjunnuorisotalo-1024x702.jpg | Harjun nuorisotalo | Harju Youth Centre | Aleksis Kiven katu 1 | Aleksis Kivis gata 1 | http://harju.munstadi.fi/ | http://harju.munstadi.fi/ | http://harju.munstadi.fi/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 71692 | +358 9 310 51809 | harjun.nuorisotalo@hel.fi | +358 9 310 71692 | harjun.nuorisotalo@hel.fi | https://www.nuoriso.hel.fi/harju | 2008-09-09T20:14:31+03:00 | 00500 | www.hel.fi | kaikki | helsinki | 2020-11-05T16:31:02.317210+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": null} | [1403] | helsinki | [371, 378, 381, 403, 418, 419, 433, 442, 366, 468, 481] | [741, 632, 468, 455, 433, 362, 359, 287, 130, 128, 72] | {} | Point | 24.957947 | 60.189754 | PL 50401, 00099 Helsingin kaupunki | Ås ungdomsgård | 6 | 13 | 2 | P.O. Box 50401, 00099 City of Helsinki | 13 | PB 50401, 00099 Helsingfors stad | 3 | ||||||||||||||||||||||||||||||
| 19117 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Kiirreellinen hammashoito puh. 09 8393 5300 ma-to klo 7.30-15.00, pe klo 7.30-14.00."}, "www": null, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 34}, {"value": "true", "variable": 31}, {"value": "true", "variable": 94}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "true", "variable": 37}, {"value": "true", "variable": 38}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 50}, {"value": "0", "variable": 1}, {"value": "false", "variable": 82}, {"value": "false", "variable": 43}, {"value": "false", "variable": 106}, {"value": "true", "variable": 22}, {"value": "short_term_stay", "variable": 60}, {"value": "no_handrails", "variable": 32}, {"value": "true", "variable": 57}, {"value": "false", "variable": 33}, {"value": "true", "variable": 25}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "ramp_under_6m_long", "variable": 45}, {"value": "true", "variable": 20}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 53}, {"value": "true", "variable": 35}, {"value": "rough", "variable": 17}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 5}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 79}, {"value": "false", "variable": 97}, {"value": "true", "variable": 52}, {"value": "true", "variable": 100}, {"value": "ramp_under_6m_long", "variable": 30}, {"value": "false", "variable": 28}, {"value": "true", "variable": 40}, {"value": "no_handrails", "variable": 95}, {"value": "true", "variable": 62}, {"value": "true", "variable": 92}, {"value": "over_20mm", "variable": 91}, {"value": "2_consecutive_steps", "variable": 93}, {"value": "true", "variable": 51}, {"value": "true", "variable": 104}, {"value": "false", "variable": 107}, {"value": "false", "variable": 83}, {"value": "true", "variable": 44}, {"value": "true", "variable": 58}, {"value": "no_handrails", "variable": 47}, {"value": "under_20mm", "variable": 56}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true"… | internal | 5443 | 8809b663-71b1-43bd-a894-ac7d0c503427 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | service_by_municipally_owned_company | kunnan liikelaitoksen palvelu | tjänst från kommunalt affärsverk | service by municipally owned company | 1 | Sotungin koulun hammashoitola | Dental clinic at Sotungin koulu | Sotungintie 19 | Sottungsbyvägen 19 | http://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/hammashoito/hammashoitolat | http://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/tandvard/tandklinikerna | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 839 11 | etunimi.sukunimi@vantaa.fi | +358 9 8393 0874 | jaana.nissinen | vantaa.fi | 2014-11-19T17:01:21+02:00 | 01200 | www.vantaa.fi | kaikki | vantaa | 2020-05-05T09:30:55.737729+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"} | [986] | vantaa | [995] | [184] | {} | Point | 25.121601 | 60.28021 | Sotungintie 19, 01200 Vantaa | Tandkliniken vid Sotungin koulu | 8 | 13 | 2 | 1 | 10 | 9 | |||||||||||||||||||||||||||||||||
| 24048 | [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 84}, {"value": "true", "variable": 59}, {"value": "true", "variable": 52}, {"value": "false", "variable": 106}, {"value": "false", "variable": 50}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 48}, {"value": "false", "variable": 29}, {"value": "4", "variable": 64}, {"value": "false", "variable": 23}, {"value": "false", "variable": 43}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 34}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 57}, {"value": "false", "variable": 79}, {"value": "0", "variable": 1}, {"value": "false", "variable": 98}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 33}, {"value": "false", "variable": 70}, {"value": "true", "variable": 94}, {"value": "true", "variable": 105}, {"value": "false", "variable": 53}, {"value": "false", "variable": 5}, {"value": "false", "variable": 62}, {"value": "false", "variable": 58}, {"value": "false", "variable": 97}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 92}, {"value": "true", "variable": 38}, {"value": "false", "variable": 103}, {"value": "false", "variable": 83}, {"value": "false", "variable": 104}, {"value": "over_20mm", "variable": 91}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 51}, {"value": "true", "variable": 20}, {"value": "false", "variable": 102}, {"value": "true", "variable": 96}, {"value": "true", "variable": 40}, {"value": "false", "variable": 49}, {"value": "false", "variable": 107}, {"value": "true", "variable": 22}, {"value": "rough", "variable": 17}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 37}, {"value": "false", "variable": 44}, {"value": "no_handrails", "variable": 41}… | internal | 7492 | 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 / Tuomelan koulu | Ainontie 44 | Ainovägen 44 | Ainontie 44 | 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 9105 | etunimi.sukunimi@vantaa.fi | +358 40 532 7344 | tiina.turkia@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01630 | www.vantaa.fi | kaikki | vantaa | 2020-03-13T09:31:21.861704+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] | vantaa | [1374] | [340] | {} | Point | 24.785645 | 60.265545 | Ainontie 44, 01630 Vantaa | Kuratorservice / Tuomelan koulu | Kuraattoreiden tehtävänä on tukea lasten ja nuorten koulunkäyntiä, hyvinvointia sekä kasvua ja kehitystä. | 8 | 13 | 2 | 1 | 13 | 13 | ||||||||||||||||||||||||||||||||
| 24113 | [{"section_type": "OPENING_HOURS", "name": {"fi": "COVID-19: Koulu- ja opiskeluterveydenhuollon keskitetyt puhelinpalvelut, kouluterveydenhuolto p. 09 8395 0025 ma-pe klo 8-15 ja opiskeluterveydenhuolto p. 09 8395 0035 ma-pe klo 8-15."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] | [{"value": "false", "variable": 29}, {"value": "false", "variable": 5}, {"value": "true", "variable": 59}, {"value": "false", "variable": 97}, {"value": "false", "variable": 34}, {"value": "false", "variable": 79}, {"value": "true", "variable": 40}, {"value": "false", "variable": 49}, {"value": "false", "variable": 62}, {"value": "true", "variable": 96}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "no_handrails", "variable": 41}, {"value": "sufficiently_wide", "variable": 18}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 104}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 51}, {"value": "false", "variable": 98}, {"value": "false", "variable": 83}, {"value": "true", "variable": 22}, {"value": "false", "variable": 70}, {"value": "true", "variable": 105}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "false", "variable": 107}, {"value": "0", "variable": 1}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 84}, {"value": "false", "variable": 102}, {"value": "false", "variable": 23}, {"value": "false", "variable": 44}, {"value": "4", "variable": 64}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 50}, {"value": "false", "variable": 58}, {"value": "false", "variable": 43}, {"value": "true", "variable": 92}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 53}, {"value": "false", "variable": 21}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 33}, {"value": "true", "variable": 94}, {"value": "false", "variable": 37}, {"value": "true", "variable": 20}, {"value": "true", "variable": 52}, {"value": "false", "variable": 106}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 38}… | internal | 7287 | 4738c8e5-8bab-40c2-865d-5b28e64d7591 | 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Koulu- ja opiskeluterveydenhuolto / Tuomelan koulu | School and student health care / Tuomelan opetuspiste | Ainontie 44 | Ainovägen 44 | Ainontie 44 | http://www.vantaa.fi/varhaiskasvatus_ja_koulutus/perusopetus/koululaisen_hyvinvointi_ja_terveys/kouluterveydenhuolto | http://www.vanda.fi/smabarnspedagogik_och_utbildning/grundlaggande_utbildning/valmaende_och_halsa/skolhalsovard | http://www.vantaa.fi/en/social_and_health_care_services | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 834 8404 | etunimi.sukunimi@vantaa.fi | +358 40 532 7344 | tiina.turkia@vantaa.fi | 2014-11-19T17:01:21+02:00 | 01630 | www.vantaa.fi | kaikki | vantaa | 2020-05-22T11:01:15.906070+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"} | [986, 1087] | vantaa | [2164, 2165, 2166, 2167] | [863, 339] | {"fi": ["koulu- ja opiskeluterveydenhuollon palvelut"]} | Point | 24.785645 | 60.265545 | Ainontie 44, 01630 Vantaa | Skol- och studenthälsovård / Tuomelan opetuspiste | Koulu- ja opiskeluterveydenhuolto | 8 | 13 | 2 | 1 | 13 | 13 |
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 );