3 rows where accessibility_shortcoming_count_visually_impaired = 15

View and edit SQL

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
53 [{"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 40914", "contact_person": "Mirjaleena Enkenberg-Kuisma"}, {"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": "false", "variable": 103}, {"value": "true", "variable": 52}, {"value": "smooth", "variable": 17}, {"value": "long_term_stay", "variable": 60}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 25}, {"value": "false", "variable": 58}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 116}, {"value": "true", "variable": 20}, {"value": "true", "variable": 23}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "3", "variable": 64}, {"value": "false", "variable": 74}, {"value": "true", "variable": 70}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "false", "variable": 72}, {"value": "true", "variable": 38}, {"value": "false", "variable": 75}, {"value": "false", "variable": 96}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "true", "variable": 51}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "true", "variable": 92}, {"value": "true", "variable": 112}, {"value": "false", "variable": 102}, {"value": "false", "variable": 22}, {"value": "true", "variable": 59}, {"value": "true", "variable": 78}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 28}, {"value": "false", "variable": 79}, {"value": "false", "variable": 21}, {"value": "floor_0", "variable": 108}, {"value": "false", "variable": 6}, {"value": "true", "variable": 113}, {"value": "false", "variable": 83}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 53}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 105}, {"value": "false", "variable": 29}, {"value": "true", "variable": 57}, {"value": "0", "variable": 1}, {"value": "false", "variable": 43}, {"value": "false", "variable": 106}, {"value": "true", "variable": 117}, {"value": "true", "variable": 50}, {"value": "false", "variable": 76}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 97}, {"value": "false", "v… internal 189     2e0009d2-c31f-46df-adfb-6fb85c20ce51 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Daghemmet Sockenstugan Day care Sockenstugan Konalantie 13 A Kånalavägen 13 A Konalantie 13 A https://www.hel.fi/varhaiskasvatus/sv/daghem/sockenstugan https://www.hel.fi/varhaiskasvatus/sv/daghem/sockenstugan https://www.hel.fi/varhaiskasvatus/sv/daghem/sockenstugan   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 40914, +358 9 310 26787   +358 9 310 44852 pk.sockenstugan@hel.fi   2007-11-15T00:00:00+02:00 00370 www.hel.fi kaikki helsinki 2020-12-03T13:00:51.727594+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"} [1405] helsinki [882, 881] [603] {"fi": ["varhaiskasvatus", "tarha"], "en": ["daycare", "day care"]} Point 24.849874 60.229046 PL 37310, 00099 Helsingin kaupunki         Daghemmet Sockenstugan   3 8       P.O. Box 37310, 00099 City of Helsinki 1     8   PB 37310, 00099 Helsingfors stad     15      
4541 [{"section_type": "HIGHLIGHT", "name": {"fi": "Jos sinulla on koronavirustartunnan oireita ja tarvitset toimintaohjeet, soita Helsingin koronavirusneuvontaan p. 09\u202f310 10024 (p\u00e4ivitt\u00e4in klo 8-18). Koronavirusneuvonnasta voit varata ajan koronavirustestiin. Sinut ohjataan my\u00f6s tarvittaessa koronaterveysasemalle.\nJos asia ei voi odottaa koronaneuvonnan aukeamista tai kyse on muusta kiireellisest\u00e4 sairaudesta, soita P\u00e4ivystysapuun, p. 116\u202f117.", "sv": "Om du har symtom p\u00e5 coronavirus och beh\u00f6ver r\u00e5d om vad du ska g\u00f6ra, ring Helsingfors coronavirusr\u00e5dgivning p\u00e5 09 310 10024 (dagligen kl. 8-18). Via coronavirusr\u00e5dgivningen kan du boka tid f\u00f6r ett coronavirustest. Vid behov kan du ocks\u00e5 h\u00e4nvisas till en h\u00e4lsostation f\u00f6r coronapatienter.\nOm \u00e4rendet inte kan v\u00e4nta tills coronavirusr\u00e5dgivningen \u00f6ppnar eller om det \u00e4r fr\u00e5ga om n\u00e5gon annan akut sjukdom, betj\u00e4nar jourhj\u00e4lpen p\u00e5 tfn 116 117.", "en": "If you have symptoms indicative of a coronavirus infection and need instructions on what to do, call Helsinki's Coronavirus Helpline, open every day of the week from 8 am to 6 pm at tel. 09 310 10024. You can book an appointment for a coronavirus test via the helpline. If necessary, you will also be directed to a coronavirus health station.\nIf you cannot wait for the Coronavirus Helpline to open or need assistance with an urgent health concern, please contact the Medical Helpline at tel. 116 11"}, "www": null, "email": null, "phone": null, "contact_person": null}] [{"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 34}, {"value": "opens_easily_manually", "variable": 54}, {"value": "0", "variable": 1}, {"value": "false", "variable": 84}, {"value": "false", "variable": 49}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 33}, {"value": "over_20mm", "variable": 91}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 98}, {"value": "false", "variable": 44}, {"value": "2", "variable": 63}, {"value": "false", "variable": 83}, {"value": "false", "variable": 58}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "false", "variable": 80}, {"value": "false", "variable": 79}, {"value": "at_least_4_steps", "variable": 24}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 21}, {"value": "true", "variable": 92}, {"value": "false", "variable": 5}, {"value": "true", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 103}, {"value": "false", "variable": 51}, {"value": "rough", "variable": 17}, {"value": "true", "variable": 52}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "false", "variable": 40}, {"value": "false", "variable": 29}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 53}, {"value": "false", "variable": 62}, {"value": "true", "variable": 57}, {"value": "false", "variable": 20}, {"value": "false", "variable": 94}, {"value": "false", "variable": 22}, {"value": "false", "variable": 59}, {"value": "true", "variable": 38}, {"value": "true", "variable": 23}, {"value": "false", "variable": 37}, {"value": "false", "variable": 105}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 50}, {"value": "false", "variable": 25}, {"value": "false", "variable": 102}, {"value": "no_handrails", "variable": 41}, {"value": "indoor_faci… internal 1987     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Paloheinä 1 lähipalvelualue Paloheinä 1 home care unit Välitalontie 71 Mellangårdsvägen 71 Välitalontie 71 https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/pohjoinen-kotihoitoyksikko https://www.hel.fi/helsinki/sv/social-och-halso/aldre/hem/kontaktuppgifter/norra https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/pohjoinen-kotihoitoyksikko   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 69587 +358 9 310 69191 +358 40 334 6811     2008-07-10T22:13:17+03:00 00660 www.hel.fi kaikki helsinki 2020-11-27T13:01:03.090126+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"} [783, 986] helsinki [829, 996] [635] {} Point 24.92611 60.24608 PL 6725, 00099 Helsingin kaupunki         Svedängen 1 närserviceområde   10 12     3 P.O. Box 6725, 00099 City of Helsinki 1     12   PB 6725, 00099 Helsingfors stad     15      
43415 [{"section_type": "LINK", "name": {"fi": "Anna palautetta"}, "www": {"fi": "https://asiointi.vantaa.fi/anna-palautetta"}, "email": null, "phone": null, "contact_person": null}] [{"value": "true", "variable": 109}, {"value": "true", "variable": 74}, {"value": "false", "variable": 98}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 22}, {"value": "true", "variable": 114}, {"value": "true", "variable": 25}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 44}, {"value": "true", "variable": 73}, {"value": "true", "variable": 38}, {"value": "false", "variable": 28}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 84}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "false", "variable": 80}, {"value": "floor_3", "variable": 108}, {"value": "false", "variable": 92}, {"value": "false", "variable": 83}, {"value": "1", "variable": 1}, {"value": "false", "variable": 75}, {"value": "true", "variable": 57}, {"value": "false", "variable": 103}, {"value": "false", "variable": 111}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 29}, {"value": "false", "variable": 34}, {"value": "false", "variable": 102}, {"value": "true", "variable": 50}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 70}, {"value": "true", "variable": 104}, {"value": "false", "variable": 43}, {"value": "false", "variable": 53}, {"value": "false", "variable": 27}, {"value": "waiting_by_standing", "variable": 81}, {"value": "spiral_staircase", "variable": 24}, {"value": "false", "variable": 51}, {"value": "true", "variable": 23}, {"value": "true", "variable": 72}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "false", "variable": 5}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 107}, {"value": "spiral_staircase", "variable": 39}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 59}, {"value": "false", "variable": 118}, {"value": "false", "variable": 42}, {"value": "false", "variable": 76}, {"value": "false", "variable": 33}, {"value": "false", "variable": 21}, {"value": "true", "variable": 52}, {"value… internal 5     de363a63-45be-487c-bbec-e98accf372a2 6d78f89c-9fd7-41d9-84e0-4b78c0fa25ce SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1             vanhus- ja vammaispalvelut     Hakunilan sosiaaliasema, vanhus- ja vammaispalvelut Hakunila social centre Laukkarinne 6 Galoppbrinken 6 Laukkarinne 6 https://www.vantaa.fi/terveys-_ja_sosiaalipalvelut/terveyspalvelut/terveysasemat/hakunilan_terveysasema https://www.vanda.fi/halsovard_och_sociala_tjanster/halsovardstjanster/halsostationer/hakansbole_halsostation https://www.vantaa.fi/health_care_and_social_services/health_services/health_centers/hakunila_health_center   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 8395 0000   +358 40 518 3488 teija.hakulinen@vantaa.fi   2014-11-19T17:01:21+02:00 01200 www.vantaa.fi kaikki vantaa 2020-06-12T14:01:44.297880+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"} [783] vantaa [811, 818, 807, 808, 806, 801, 799, 809, 820] [764, 755, 752, 751, 749, 748, 747, 281, 280] {"fi": ["sosiaality\u00f6", "toimeentulotuki"]} Point 25.104013 60.278458 Laukkarinne 6, 01200 Vantaa         Håkansböle socialstation vanhus- ja vammaispalvelut 6 8     3   1     8         15      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);