3 rows where accessibility_shortcoming_count_visually_impaired = 9 and accessibility_shortcoming_count_wheelchair = 8

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
103 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja"}, "www": null, "email": "sanna.hovi@hel.fi", "phone": "+358 9 310 52990", "contact_person": "Hovi Sanna"}, {"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": 75}, {"value": "false", "variable": 33}, {"value": "true", "variable": 23}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 105}, {"value": "false", "variable": 116}, {"value": "false", "variable": 92}, {"value": "sufficiently_wide", "variable": 18}, {"value": "2", "variable": 64}, {"value": "false", "variable": 49}, {"value": "false", "variable": 21}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 72}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 20}, {"value": "false", "variable": 76}, {"value": "floor_1", "variable": 108}, {"value": "false", "variable": 115}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "true", "variable": 117}, {"value": "false", "variable": 98}, {"value": "true", "variable": 37}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "false", "variable": 79}, {"value": "false", "variable": 38}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 29}, {"value": "false", "variable": 48}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 113}, {"value": "false", "variable": 109}, {"value": "true", "variable": 50}, {"value": "false", "variable": 5}, {"value": "false", "variable": 78}, {"value": "false", "variable": 83}, {"value": "true", "variable": 25}, {"value": "false", "variable": 44}, {"value": "0", "variable": 1}, {"value": "true", "variable": 70}, {"value": "true", "variable": 59}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "true", "variable": 57}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "false", "variable": 28}, {"value": "false", "variable": 53}, {"value": "false", "variable": 102}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 104}, {"value": "false", "variable": 84}, {"value": "false", "variable": 62}, {"value": "true", "variable": 51}, {"value": "true", "variable": 52}, {"value": "true", "v… internal 433     8c67fdec-0c89-4dfa-8cfd-5de677c66a4d 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Päiväkoti Käpylinna Day care Käpylinna Ilmattarentie 32 Ilmatarvägen 32 Ilmattarentie 32 https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kapylinna https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kapylinna https://www.hel.fi/varhaiskasvatus/fi/paivakodit/kapylinna   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 52990, +358 9 310 64601         2007-11-15T00:00:00+02:00 00610 www.hel.fi kaikki helsinki 2020-12-03T13:00:52.229868+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 24.938555 60.213066 PL 61971, 00099 Helsingin kaupunki         Päiväkoti Käpylinna   4 8     1 P.O. Box 61971, 00099 City of Helsinki 1     8   PB 61971, 00099 Helsingfors stad     9      
248 [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "P\u00e4iv\u00e4kodinjohtaja"}, "www": null, "email": "anita.tuovinen@hel.fi", "phone": "+358 9 310 73922", "contact_person": "Anita Tuovinen"}, {"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": "0", "variable": 1}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "false", "variable": 29}, {"value": "true", "variable": 25}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 70}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 5}, {"value": "true", "variable": 116}, {"value": "true", "variable": 107}, {"value": "false", "variable": 52}, {"value": "false", "variable": 102}, {"value": "true", "variable": 115}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "true", "variable": 74}, {"value": "false", "variable": 83}, {"value": "false", "variable": 105}, {"value": "false", "variable": 97}, {"value": "true", "variable": 72}, {"value": "false", "variable": 76}, {"value": "true", "variable": 23}, {"value": "true", "variable": 104}, {"value": "3", "variable": 64}, {"value": "false", "variable": 58}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 84}, {"value": "true", "variable": 22}, {"value": "false", "variable": 78}, {"value": "true", "variable": 57}, {"value": "true", "variable": 113}, {"value": "no_handrails", "variable": 26}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 48}, {"value": "false", "variable": 98}, {"value": "false", "variable": 38}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 49}, {"value": "true", "variable": 59}, {"value": "true", "variable": 114}, {"value": "false", "variable": 34}, {"value": "false", "variable": 62}, {"value": "false", "variable": 44}, {"value": "is_heavy", "variable": 77}, {"value": "true", "variable": 21}, {"value": "under_20mm", "variable": 91}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 117}, {"value": "false", "variable": 109}, {"value": "true", "variable": 51}, {"value": "true", "variable": 73}, {"value": "false", "variable": 96}, {"value": "at_least_4_steps", "variable": 24}, {"value": "not_guided_not_clear",… internal 583     33c95a0c-364d-4713-8691-685c797af438 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Päiväkoti Impivaara Day care Impivaara Sompiontori 3 Sompiotorget 3 Sompiontori 3 https://www.hel.fi/varhaiskasvatus/fi/paivakodit/impivaara https://www.hel.fi/varhaiskasvatus/fi/paivakodit/impivaara https://www.hel.fi/varhaiskasvatus/fi/paivakodit/impivaara   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 73922, +358 9 310 46807         2007-11-15T00:00:00+02:00 00730 www.hel.fi kaikki helsinki 2020-12-03T13:00:53.352618+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.028109 60.263737 PL 73991, 00099 Helsingin kaupunki         Päiväkoti Impivaara   6 8     1 P.O. Box 73991, 00099 City of Helsinki 1     8   PB 73991, 00099 Helsingfors stad     9      
12009 [{"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": "false", "variable": 79}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 58}, {"value": "true", "variable": 52}, {"value": "true", "variable": 22}, {"value": "1_step", "variable": 39}, {"value": "true", "variable": 38}, {"value": "false", "variable": 51}, {"value": "true", "variable": 62}, {"value": "false", "variable": 5}, {"value": "true", "variable": 20}, {"value": "false", "variable": 55}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 80}, {"value": "false", "variable": 49}, {"value": "false", "variable": 92}, {"value": "false", "variable": 84}, {"value": "false", "variable": 103}, {"value": "false", "variable": 98}, {"value": "rough", "variable": 17}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 33}, {"value": "false", "variable": 83}, {"value": "true", "variable": 50}, {"value": "false", "variable": 104}, {"value": "requires_use_of_buzzer_opening_easily_manually", "variable": 54}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "false", "variable": 21}, {"value": "false", "variable": 105}, {"value": "false", "variable": 53}, {"value": "true", "variable": 57}, {"value": "false", "variable": 102}, {"value": "false", "variable": 48}, {"value": "false", "variable": 29}, {"value": "0", "variable": 1}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 59}, {"value": "false", "variable": 82}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 107}, {"value": "false", "variable": 37}, {"value": "false", "variable": 44}, {"value": "difficult_to_perceive", "variable": 36}] internal 4339     d4b3a166-9fa0-4846-9d63-ff1fdab670b6 83e74666-0836-4c1d-948a-4b34a8b90301 SELF_PRODUCED   municipal_service kunnallinen palvelu kommunal tjänst municipal service 1                   Kontula 3 lähipalvelualue Kontula 3 home care unit Ostostie 4 Köpvägen 4 Ostostie 4 https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/itainen-kotihoitoyksikko https://www.hel.fi/helsinki/sv/social-och-halso/aldre/hem/kontaktuppgifter/ostra https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/itainen-kotihoitoyksikko   pvm/mpm lna/msa local network charge/mobile call charge   +358 9 310 62662         2010-01-18T07:04:38+02:00 00940 www.hel.fi kaikki helsinki 2020-11-27T13:01:11.696407+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"} [783, 986] helsinki [829, 996] [635] {} Point 25.083698 60.238354 PL 6235, 00099 Helsingin kaupunki         Gårdsbacka 3 närserviceområde   5 8       P.O. Box 6235, 00099 City of Helsinki 1     8   PB 6235, 00099 Helsingfors stad     9      

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