unit
3 rows where accessibility_shortcoming_count_visually_impaired = 14
This data as json, CSV (advanced)
Suggested facets: keywords, accessibility_shortcoming_count_reduced_mobility, created_time (date), last_modified_time (date)
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2859 | [{"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": 43}, {"value": "true", "variable": 40}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 51}, {"value": "false", "variable": 84}, {"value": "false", "variable": 62}, {"value": "true", "variable": 57}, {"value": "false", "variable": 82}, {"value": "false", "variable": 98}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 49}, {"value": "true", "variable": 25}, {"value": "true", "variable": 38}, {"value": "false", "variable": 79}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 33}, {"value": "false", "variable": 22}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "false", "variable": 96}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 42}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 20}, {"value": "false", "variable": 52}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 37}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "true", "variable": 23}, {"value": "true", "variable": 92}, {"value": "false", "variable": 105}, {"value": "false", "variable": 80}, {"value": "false", "variable": 50}, {"value": "false", "variable": 97}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 34}, {"value": "false", "variable": 27}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 48}, {"value": "false", "variable": 28}, {"value": "false", "variable": 59}, {"value": "false", "variable": 70}, {"value": "false", "variable": 107}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 103}, {"value": "false", "variable": 44}, {"value": "false", "variable": 104}, {"value": "over_20mm", "variable": 56}, {"… | internal | 1407 | 18b157ac-e863-4482-8bd7-3c737e6fe6d6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Perhepäivähoito Jakomäki-Puistola-Suutarila | Family day care Suutarila | Linnunradantie 8 | Vintergatsvägen 8 | Linnunradantie 8 | https://www.hel.fi/varhaiskasvatus/fi/pph-alueittain/puistola-jakomaki-suutarila/puistola-jakomaki-suutarila | https://www.hel.fi/helsinki/fi/kasvatus-ja-koulutus/paivahoito/perhepaivahoito/perhepaivahoitoalueet/pph-puistola-jakomaki | https://www.hel.fi/varhaiskasvatus/fi/pph-alueittain/puistola-jakomaki-suutarila/puistola-jakomaki-suutarila | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 73465 | +358 9 310 73465 | pph.suutarila@hel.fi | 2007-11-15T00:00:00+02:00 | 00740 | www.hel.fi | kaikki | helsinki | 2021-01-01T07:30:43.995493+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"} | [1405] | helsinki | [962] | [506] | {} | Point | 25.006842 | 60.280216 | PL 74999, 00099 Helsingin kaupunki | 6 | 13 | 4 | P.O. Box 74999, 00099 City of Helsinki | 1 | 13 | PB 74999, 00099 Helsingfors stad | 14 | |||||||||||||||||||||||||||||||||
| 9020 | [{"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": 53}, {"value": "false", "variable": 62}, {"value": "false", "variable": 84}, {"value": "false", "variable": 76}, {"value": "true", "variable": 78}, {"value": "false", "variable": 79}, {"value": "false", "variable": 25}, {"value": "narrow", "variable": 18}, {"value": "true", "variable": 50}, {"value": "waiting_by_standing", "variable": 81}, {"value": "0", "variable": 1}, {"value": "true", "variable": 72}, {"value": "false", "variable": 29}, {"value": "false", "variable": 102}, {"value": "false", "variable": 33}, {"value": "true", "variable": 70}, {"value": "false", "variable": 82}, {"value": "true", "variable": 23}, {"value": "false", "variable": 58}, {"value": "false", "variable": 21}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 104}, {"value": "false", "variable": 83}, {"value": "false", "variable": 48}, {"value": "true", "variable": 92}, {"value": "false", "variable": 80}, {"value": "spiral_staircase", "variable": 93}, {"value": "false", "variable": 103}, {"value": "false", "variable": 73}, {"value": "spiral_staircase", "variable": 24}, {"value": "false", "variable": 44}, {"value": "handrails_on_one_side", "variable": 95}, {"value": "false", "variable": 75}, {"value": "false", "variable": 59}, {"value": "under_20mm", "variable": 56}, {"value": "handrails_on_one_side", "variable": 26}, {"value": "6", "variable": 63}, {"value": "entrance_in_recess_no_canopy", "variable": 36}, {"value": "false", "variable": 22}, {"value": "true", "variable": 20}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 98}, {"value": "false", "variable": 49}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 38}, {"value": "true", "variable": 57}, {"value": "true", "variable": 37}, {"value": "requires_use_of_door_phone_and_is_heavy", "variable": 54}, {"value": "false", "variable": 107}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "not_guided_not_clear", "variable": 19}, {"value… | internal | 3741 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Sijaishuollon asiakasohjaus ja valvonta | Client supervising in foster care | Toinen linja 4 A | Andra linjen 4 A | Toinen linja 4 A | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5015 | +358 9 310 46889 | juha.jokinen@hel.fi | 2009-01-26T15:22:59+02:00 | 00530 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:09.464180+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] | helsinki | [789] | [380] | {} | Point | 24.946972 | 60.181797 | PL 6090, 00099 Helsingin kaupunki | Klienthandledning inom vård utom hemmet | 7 | 8 | 2 | P.O. Box 6090, 00099 City of Helsinki | 1 | 8 | PB 6090, 00099 Helsingfors stad | 14 | |||||||||||||||||||||||||||||||||||
| 43924 | [{"section_type": "PHONE_OR_EMAIL", "name": {"fi": "Koulujen tilojen ilta- ja vapaa-ajank\u00e4yt\u00f6n neuvonta ja varaukset: liikuntasalit 09 310 87800, muut tilat 09 310 12001", "sv": "Information g\u00e4llande reservationer av skolornas utrymmen p\u00e5 kv\u00e4llar och helger: gymnastiksalar 09 310 87800, \u00f6vriga utrymmen 09 310 12001"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "OTHER_INFO", "name": {"fi": "ruotsinkielinen perusopetus luokille 1-5", "sv": "grundl\u00e4ggande utbildning p\u00e5 svenska f\u00f6r \u00e5rskurserna 1-5", "en": "basic education for grades 1-5 in Swedish"}, "www": null, "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": "false", "variable": 103}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 22}, {"value": "true", "variable": 37}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 49}, {"value": "true", "variable": 105}, {"value": "true", "variable": 25}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 79}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 51}, {"value": "true", "variable": 50}, {"value": "true", "variable": 5}, {"value": "false", "variable": 106}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 94}, {"value": "false", "variable": 21}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 48}, {"value": "true", "variable": 40}, {"value": "true", "variable": 59}, {"value": "false", "variable": 97}, {"value": "true", "variable": 92}, {"value": "false", "variable": 44}, {"value": "false", "variable": 6}, {"value": "false", "variable": 58}, {"value": "false", "variable": 102}, {"value": "false", "variable": 104}, {"value": "2_consecutive_steps", "variable": 24}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 70}, {"value": "false", "variable": 53}, {"value": "false", "variable": 28}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 52}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 62}, {"value": "false", "variable": 34}, {"value": "false", "variable": 96}, {"value": "7", "variable": 64}, {"value": "2_consecutive_steps", "variable": 39}, {"value": "true", "variable": 23}, {"value": "true", "variable": 20}, {"value": "false", "variable": 33}, {"value": "true", "variable": 38}, {"value": "false", "variable": 43}, {"value": "sufficiently_wide", "variable": 18}, {"value": "0", "variable": 1}, {"value": "false", "variable": 98}, {"value": "false", "variable": 84}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 29}, {"value": "false… | internal | 20696 | e61d617e-26a0-4fd1-b7db-ccebfecfb95b | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hoplaxskolan: Munksnäs-enheten 0-5 | Hoplaxskolan: Munksnäs-enheten 0-5 | Lokkalantie 9 | Locklaisvägen 9 | Lokkalantie 9 | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | https://www.hel.fi/peruskoulut/sv/skolor/hoplaxskolan/hoplaxskolan | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 86678 | 2015-11-27T12:11:49+02:00 | 00330 | www.hel.fi | kaikki | helsinki | 2020-12-03T13:01:46.544945+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 | [1194, 1208, 1214, 2128, 1095, 2126, 1093, 1189] | [862, 601, 159, 33, 27, 24] | {"fi": ["eskari"], "en": ["basiceducation", "basic education"]} | Point | 24.880447 | 60.19969 | PL 33302, 00099 Helsingin kaupunki | Hoplaxskolan: Munksnäs-enheten 0-5 | 7 | 11 | 1 | P.O. Box 33302, 00099 City of Helsinki | 1 | 11 | PB 33302, 00099 Helsingfors stad | 14 |
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 );