unit
7 rows where accessibility_shortcoming_count_stroller = 2 and "created_time" is on date 2008-07-10
This data as json, CSV (advanced)
Suggested facets: street_address_fi, street_address_sv, street_address_en, phone, address_zip, accessibility_shortcoming_count_reduced_mobility, address_postal_full_en, accessibility_shortcoming_count_rollator, address_postal_full_sv, accessibility_shortcoming_count_visually_impaired
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4177 | [{"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": 22}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "at_least_4_steps", "variable": 93}, {"value": "false", "variable": 33}, {"value": "handrails_on_both_sides", "variable": 95}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "false", "variable": 105}, {"value": "true", "variable": 25}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 49}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 98}, {"value": "false", "variable": 44}, {"value": "true", "variable": 20}, {"value": "true", "variable": 5}, {"value": "false", "variable": 79}, {"value": "true", "variable": 51}, {"value": "false", "variable": 52}, {"value": "false", "variable": 104}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 92}, {"value": "true", "variable": 38}, {"value": "false", "variable": 103}, {"value": "true", "variable": 40}, {"value": "false", "variable": 21}, {"value": "true", "variable": 37}, {"value": "true", "variable": 23}, {"value": "false", "variable": 62}, {"value": "5", "variable": 64}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 6}, {"value": "false", "variable": 48}, {"value": "false", "variable": 34}, {"value": "true", "variable": 94}, {"value": "true", "variable": 59}, {"value": "true", "variable": 50}, {"value": "indoor_facility", "variable": 500}, {"value": "0", "variable": 1}, {"value": "false", "variable": 29}, {"value": "true", "variable": 57}, {"value": "opens_easily_manually", "variable": 54}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 107}, {"value": "no_handrails", "variable": 41}, {"value": "smooth", "variable": 17}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 70}, {"value": "false", "variable": 102}, {"value": "false", "variable": 58}] | internal | 1721 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Käpylän peruskoulu, kouluterveydenhuolto | Käpylä Comprehensive School, Lower Stage, school health care | Väinölänkatu 7 | Väinölägatan 7 | Väinölänkatu 7 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 310 5580 | +358 9 310 72414 | 2008-07-10T22:13:17+03:00 | 00610 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:02.180485+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} | [986, 1087] | helsinki | [2164, 2165] | [339] | {} | Point | 24.947838 | 60.21068 | PL 61301, 00099 Helsingin kaupunki | Lågstadieskolan Käpylän peruskoulu ala-aste, skolhälsovård | 5 | 9 | 2 | P.O. Box 61301, 00099 City of Helsinki | 9 | PB 61301, 00099 Helsingfors stad | 5 | |||||||||||||||||||||||||||||||||||||
4233 | [{"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}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hammashoidon asiointipalvelu", "sv": "Tandv\u00e5rdens e-tj\u00e4nster", "en": "Dental care e-service"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=562", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=562", "en": "https://www.hel.fi/helsinki/en/administration/administra… | [{"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 38}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "false", "variable": 84}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 59}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "false", "variable": 34}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 29}, {"value": "false", "variable": 107}, {"value": "false", "variable": 57}, {"value": "true", "variable": 5}, {"value": "2", "variable": 1}, {"value": "false", "variable": 98}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 20}, {"value": "chairs_available", "variable": 81}, {"value": "2", "variable": 63}, {"value": "false", "variable": 92}, {"value": "false", "variable": 70}, {"value": "outdoors", "variable": 2}, {"value": "at_least_4_steps", "variable": 39}, {"value": "false", "variable": 103}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 80}, {"value": "false", "variable": 52}, {"value": "false", "variable": 21}, {"value": "false", "variable": 79}, {"value": "true", "variable": 51}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 104}, {"value": "true", "variable": 37}, {"value": "false", "variable": 102}, {"value": "false", "variable": 62}, {"value": "true", "variable": 40}, {"value": "sufficiently_wide", "variable": 18}, {"value": "guided_and_clear", "variable": 19}, {"value": "false", "variable": 49}, {"value": "false", "variable": 33}, {"value": "at_least_3600mm", "variable": 3}, {"value": "false", "variable": 48}, {"value": "false", "variable": 22}, {"value": "false", "variable": 106}, {"value": "false", "variable": 83}, {"value": "false", "variable": 23}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 105}, {"value": "false", "variable": 82}, {"value": "true", "variable": 6}, {"value": "smooth", "variable": 17}] | internal | 1916 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Suutarilan hammashoitola | Suutarila Dental Clinic | Seulastentie 11 | Plejadvägen 11 | Seulastentie 11 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 51400 | +358 9 310 53442 | +358 9 310 53441 | Suutarilan.Hammashoitola.@hel.fi | 2008-07-10T22:13:17+03:00 | 00740 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:02.338478+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"} | [986] | helsinki | [995] | [184] | {} | Point | 24.99842 | 60.275635 | PL 6563, 00099 Helsingin kaupunki | Skomakarböle tandklinik | 3 | 4 | 2 | P.O. Box 6563, 00099 City of Helsinki | 1 | 4 | PB 6563, 00099 Helsingfors stad | 4 | ||||||||||||||||||||||||||||||||||
4670 | [{"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": "true", "variable": 6}, {"value": "no_handrails", "variable": 47}, {"value": "true", "variable": 29}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "true", "variable": 74}, {"value": "true", "variable": 23}, {"value": "false", "variable": 49}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 46}, {"value": "false", "variable": 84}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 53}, {"value": "is_heavy", "variable": 77}, {"value": "false", "variable": 105}, {"value": "true", "variable": 58}, {"value": "false", "variable": 48}, {"value": "false", "variable": 107}, {"value": "false", "variable": 34}, {"value": "over_20mm", "variable": 56}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 76}, {"value": "false", "variable": 50}, {"value": "false", "variable": 78}, {"value": "0", "variable": 1}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 31}, {"value": "true", "variable": 52}, {"value": "true", "variable": 72}, {"value": "false", "variable": 33}, {"value": "at_least_4_steps", "variable": 24}, {"value": "short_term_stay", "variable": 60}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 79}, {"value": "true", "variable": 104}, {"value": "false", "variable": 98}, {"value": "false", "variable": 102}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 92}, {"value": "false", "variable": 22}, {"value": "false", "variable": 75}, {"value": "true", "variable": 38}, {"value": "true", "variable": 44}, {"value": "true", "variable": 25}, {"value": "false", "variable": 83}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 103}, {"value": "true", "variable": 57}, {"value": "true", "variable": 70}, {"value": "tr… | internal | 1870 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Malminkartano 1 lähipalvelualue | Malminkartano 1 home care unit | Kitarakuja 4 | Gitarrgränden 4 | Kitarakuja 4 | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/lantinen-kotihoitoyksikko | https://www.hel.fi/helsinki/sv/social-och-halso/aldre/hem/kontaktuppgifter/vastra | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/lantinen-kotihoitoyksikko | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 552 1084 | +358 9 310 46350 | 2008-07-10T22:13:17+03:00 | 00420 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:03.271459+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.876993 | 60.238888 | PL 6625, 00099 Helsingin kaupunki | Malmgård 1 närserviceområde | 4 | 9 | 2 | P.O. Box 6625, 00099 City of Helsinki | 1 | 7 | PB 6625, 00099 Helsingfors stad | 4 | |||||||||||||||||||||||||||||||||
5101 | [{"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": "true", "variable": 40}, {"value": "true", "variable": 44}, {"value": "false", "variable": 92}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 58}, {"value": "true", "variable": 72}, {"value": "true", "variable": 73}, {"value": "true", "variable": 70}, {"value": "false", "variable": 75}, {"value": "false", "variable": 21}, {"value": "false", "variable": 83}, {"value": "false", "variable": 59}, {"value": "true", "variable": 52}, {"value": "false", "variable": 80}, {"value": "short_term_stay", "variable": 60}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 103}, {"value": "false", "variable": 107}, {"value": "at_least_4_steps", "variable": 24}, {"value": "false", "variable": 22}, {"value": "true", "variable": 6}, {"value": "true", "variable": 76}, {"value": "true", "variable": 104}, {"value": "is_heavy", "variable": 77}, {"value": "false", "variable": 102}, {"value": "true", "variable": 38}, {"value": "false", "variable": 48}, {"value": "2", "variable": 63}, {"value": "false", "variable": 84}, {"value": "true", "variable": 20}, {"value": "false", "variable": 31}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 50}, {"value": "no_handrails", "variable": 47}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "true", "variable": 74}, {"value": "false", "variable": 78}, {"value": "at_least_4_steps", "variable": 39}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 33}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "over_20mm", "variable": 91}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 37}, {"value": "true", "variable": 23}, {"value": "true", "variable": 25}, {"value": "false", "variable": 53}, {"value": "true", "variable": 51}, {"value": "0", "variable": 1}, {"value": "false", "variable": 6… | internal | 2030 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kannelmäki 1 lähipalvelualue | Kannelmäki 1 home care unit | Kitarakuja 4 | Gitarrgränden 4 | Kitarakuja 4 | https://www.hel.fi/Helsinki/fi/sosiaali-ja-terveyspalvelut/ikaantyneiden-palvelut/kotihoito/kotihoidon-yhteystiedot/lantinen-kotihoitoyksikko/ | https://www.hel.fi/helsinki/sv/social-och-halso/aldre/hem/kontaktuppgifter/vastra | https://www.hel.fi/Helsinki/fi/sosiaali-ja-terveyspalvelut/ikaantyneiden-palvelut/kotihoito/kotihoidon-yhteystiedot/lantinen-kotihoitoyksikko/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 47339 | +358 9 310 41793 | +358 9 310 47339 | 2008-07-10T22:13:17+03:00 | 00420 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:04.144156+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.876993 | 60.238888 | PL 6625, 00099 Helsingin kaupunki | Gamlas 1 närserviceområde | 4 | 9 | 2 | P.O. Box 6625, 00099 City of Helsinki | 1 | 7 | PB 6625, 00099 Helsingfors stad | 4 | ||||||||||||||||||||||||||||||||
5472 | [{"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}, {"section_type": "ESERVICE_LINK", "name": {"fi": "Hammashoidon asiointipalvelu", "sv": "Tandv\u00e5rdens e-tj\u00e4nster", "en": "Dental care e-service"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=562", "sv": "https://www.hel.fi/helsinki/sv/stad-och-forvaltning/forvaltning/tjanster/e-tjanster?id=562", "en": "https://www.hel.fi/helsinki/en/administration/administra… | [{"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 44}, {"value": "false", "variable": 62}, {"value": "guided_and_clear", "variable": 19}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "true", "variable": 51}, {"value": "false", "variable": 37}, {"value": "false", "variable": 82}, {"value": "true", "variable": 52}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 20}, {"value": "false", "variable": 33}, {"value": "false", "variable": 78}, {"value": "3", "variable": 63}, {"value": "false", "variable": 48}, {"value": "opens_automatically", "variable": 77}, {"value": "false", "variable": 22}, {"value": "rough", "variable": 17}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 83}, {"value": "false", "variable": 98}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 74}, {"value": "false", "variable": 29}, {"value": "false", "variable": 79}, {"value": "false", "variable": 105}, {"value": "true", "variable": 6}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 59}, {"value": "true", "variable": 73}, {"value": "false", "variable": 38}, {"value": "false", "variable": 92}, {"value": "false", "variable": 49}, {"value": "false", "variable": 75}, {"value": "true", "variable": 70}, {"value": "true", "variable": 53}, {"value": "true", "variable": 72}, {"value": "false", "variable": 84}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "false", "variable": 103}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 107}, {"value": "false", "variable": 34}, {"value": "true", "variable": 5}, {"value": "false", "variable": 104}, {"value": "true", "variable": 76}, {"value": "false", "variable": 57}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 23}, {"value": "true", "variable": 80}, {"value": "false", "variable": 50}, {"value": "false", "variable": 102}] | internal | 2348 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Puistolan hammashoitola | Puistola Dental Clinic | Maatullinaukio 10 A | Landtullsplatsen 10 A | Maatullinaukio 10 A | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 51400 | +358 9 310 58065 | +358 9 310 84095 | Puistolan.Hammashoitola@hel.fi | 2008-07-10T22:13:17+03:00 | 00750 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:04.701789+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"} | [986] | helsinki | [995] | [184] | {} | Point | 25.034311 | 60.27546 | PL 6562, 00099 Helsingin kaupunki | Parkstads tandklinik | 4 | 6 | 2 | P.O. Box 6562, 00099 City of Helsinki | 1 | 6 | PB 6562, 00099 Helsingfors stad | 6 | ||||||||||||||||||||||||||||||||||
5901 | [{"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": "true", "variable": 50}, {"value": "at_least_4_turning_steps", "variable": 39}, {"value": "true", "variable": 59}, {"value": "true", "variable": 57}, {"value": "false", "variable": 48}, {"value": "false", "variable": 107}, {"value": "false", "variable": 105}, {"value": "false", "variable": 102}, {"value": "true", "variable": 23}, {"value": "smooth", "variable": 17}, {"value": "0", "variable": 1}, {"value": "false", "variable": 21}, {"value": "4", "variable": 64}, {"value": "true", "variable": 40}, {"value": "over_20mm", "variable": 91}, {"value": "true", "variable": 51}, {"value": "true", "variable": 25}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 37}, {"value": "false", "variable": 44}, {"value": "false", "variable": 98}, {"value": "true", "variable": 5}, {"value": "false", "variable": 83}, {"value": "false", "variable": 103}, {"value": "true", "variable": 38}, {"value": "false", "variable": 70}, {"value": "true", "variable": 20}, {"value": "false", "variable": 29}, {"value": "false", "variable": 49}, {"value": "false", "variable": 53}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "true", "variable": 58}, {"value": "true", "variable": 92}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "no_handrails", "variable": 95}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 34}, {"value": "false", "variable": 22}, {"value": "at_least_4_turning_steps", "variable": 93}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 94}, {"value": "false", "variable": 33}, {"value": "false", "variable": 84}, {"value": "true", "variable": 52}, {"value": "false", "variable": 104}, {"value": "sufficiently_wide", "variable": 18}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 62}, {"value": "indoor_facility", "variable": 500}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 79}, {"value… | internal | 2513 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Vuoniityn peruskoulu, Heteniityntien toimipiste, kouluterveydenhuolto | Vuoniitty Comprehensive School, Heteniityntie unit, school health care | Heteniityntie 4 | Gjutängsvägen 4 | Heteniityntie 4 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 40 334 5292 | +358 50 401 3867 | 2008-07-10T22:13:17+03:00 | 00960 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:05.409376+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"} | [986, 1087] | helsinki | [2164, 2165] | [339] | {} | Point | 25.134104 | 60.21789 | PL 96301, 00099 Helsingin kaupunki | Grundskolan Vuoniityn peruskoulu, Gjutängsvägens enhet skolhälsovård | 4 | 8 | 2 | P.O. Box 96301, 00099 City of Helsinki | 1 | 8 | PB 96301, 00099 Helsingfors stad | 7 | ||||||||||||||||||||||||||||||||||||
6402 | [{"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": "smooth", "variable": 17}, {"value": "true", "variable": 115}, {"value": "true", "variable": 23}, {"value": "no_handrails", "variable": 41}, {"value": "false", "variable": 29}, {"value": "true", "variable": 114}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 22}, {"value": "true", "variable": 112}, {"value": "true", "variable": 113}, {"value": "true", "variable": 50}, {"value": "false", "variable": 44}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 79}, {"value": "true", "variable": 105}, {"value": "false", "variable": 52}, {"value": "false", "variable": 48}, {"value": "true", "variable": 25}, {"value": "true", "variable": 6}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 37}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "true", "variable": 62}, {"value": "false", "variable": 98}, {"value": "true", "variable": 59}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 49}, {"value": "no_handrails", "variable": 26}, {"value": "false", "variable": 103}, {"value": "true", "variable": 20}, {"value": "false", "variable": 84}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 106}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 34}, {"value": "true", "variable": 116}, {"value": "0", "variable": 1}, {"value": "false", "variable": 83}, {"value": "requires_use_of_door_phone_opening_easily_manually", "variable": 54}, {"value": "false", "variable": 102}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "true", "variable": 51}, {"value": "floor_1", "variable": 120}, {"value": "true", "variable": 40}, {"value": "3_consecutive_steps", "variable": 93}, {"value": "no_handrails", "variable": 95}, {"value": "floor_1", "variable": 119}, {"value": "true", "variable": 107}, {"value": "true", "variable": 57}, {"value": "true", "variable": 117}, {"… | internal | 2705 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Auroran psykiatrian päiväosasto 10 | Southern day hospital | Nordenskiöldinkatu 20, rak. 10 | Nordenskiöldsgatan 20, byggnad 10 | Nordenskiöldinkatu 20, bldg 10 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5015 | +358 9 310 50833 | +358 9 310 50830 | paivasairaala10@hel.fi | 2008-07-10T22:13:17+03:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:06.235167+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"} | [986] | helsinki | [1026] | [524] | {} | Point | 24.927237 | 60.192482 | PL 6800, 00099 Helsingin kaupunki | Södra dagsjukhuset | 4 | 7 | 2 | P.O. Box 6800, 00099 City of Helsinki | 1 | 7 | PB 6800, 00099 Helsingfors stad | 6 |
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 );