unit
8 rows where accessibility_shortcoming_count_visually_impaired = 8 and "last_modified_time" is on date 2020-11-27
This data as json, CSV (advanced)
data_source ✖
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1328 | [{"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": "0", "variable": 1}, {"value": "false", "variable": 102}, {"value": "false", "variable": 50}, {"value": "false", "variable": 92}, {"value": "false", "variable": 57}, {"value": "at_least_4_steps", "variable": 24}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 62}, {"value": "no_handrails", "variable": 26}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "false", "variable": 79}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 22}, {"value": "over_20mm", "variable": 91}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 44}, {"value": "false", "variable": 37}, {"value": "smooth", "variable": 17}, {"value": "narrow", "variable": 18}, {"value": "false", "variable": 51}, {"value": "true", "variable": 38}, {"value": "false", "variable": 107}, {"value": "true", "variable": 23}, {"value": "false", "variable": 5}, {"value": "at_least_4_steps", "variable": 39}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 49}, {"value": "true", "variable": 40}, {"value": "true", "variable": 25}, {"value": "false", "variable": 29}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "false", "variable": 105}, {"value": "false", "variable": 98}, {"value": "false", "variable": 48}, {"value": "false", "variable": 33}, {"value": "false", "variable": 34}, {"value": "false", "variable": 20}, {"value": "true", "variable": 59}, {"value": "false", "variable": 52}, {"value": "false", "variable": 103}, {"value": "false", "variable": 104}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 21}] | internal | 1017 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Ruusulan ryhmäkoti | Ruusula group home | Ruusulankatu 7 a 1-2 | Rosavillagatan 7 a 1-2 | Ruusulankatu 7 a 1-2 | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/ruusula/ | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/ruusula/ | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/ruusula/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 44352 | +358 9 310 44352 | pienryhmakoti.ruusula@hel.fi | 2007-11-15T00:00:00+02:00 | 00260 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.434183+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} | [783] | helsinki | [815] | [275] | {} | Point | 24.92468 | 60.182106 | PL 26713, 00099 Helsingin kaupunki | Rosavilla grupphem | 4 | 9 | 4 | P.O. Box 26713, 00099 City of Helsinki | 9 | PB 26713, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||||
| 1331 | [{"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": "0", "variable": 1}, {"value": "true", "variable": 79}, {"value": "true", "variable": 57}, {"value": "false", "variable": 22}, {"value": "true", "variable": 50}, {"value": "true", "variable": 52}, {"value": "false", "variable": 48}, {"value": "true", "variable": 114}, {"value": "false", "variable": 31}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "true", "variable": 59}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 30}, {"value": "true", "variable": 35}, {"value": "false", "variable": 49}, {"value": "opens_with_access_control_key", "variable": 54}, {"value": "true", "variable": 38}, {"value": "true", "variable": 70}, {"value": "true", "variable": 115}, {"value": "false", "variable": 103}, {"value": "false", "variable": 20}, {"value": "true", "variable": 104}, {"value": "false", "variable": 33}, {"value": "true", "variable": 72}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 21}, {"value": "false", "variable": 98}, {"value": "false", "variable": 75}, {"value": "false", "variable": 62}, {"value": "false", "variable": 92}, {"value": "under_20mm", "variable": 91}, {"value": "false", "variable": 53}, {"value": "false", "variable": 28}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 6}, {"value": "false", "variable": 43}, {"value": "false", "variable": 84}, {"value": "6", "variable": 64}, {"value": "false", "variable": 34}, {"value": "true", "variable": 105}, {"value": "true", "variable": 23}, {"value": "false", "variable": 106}, {"value": "no_handrails", "variable": 41}, {"value": "ramp_over_6m_long_no_intermediate_landing", "variable": 45}, {"value": "true", "variable": 112}, {"value": "no_handrails", "variable": 26}, {"value": "true", "variable": 29}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 102}, {"value": "true", "variable": 25}, {"value": "true", "variable": 73}, {"value": "true", "variable": 74}, {"value": "true… | internal | 1187 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Tilkan ryhmäkoti | Tilkka group home | Tilkankatu 1 A | Tilkgatan 1 A | Tilkankatu 1 A | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | https://www.hel.fi/vammaiset/fi/asuminen/kehitysvammaisten-asumispalvelut/ryhmakodit/tilkka | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 41743 | +358 9 310 73987 | jarmo-ahti.karppinen@hel.fi | 2007-11-15T00:00:00+02:00 | 00300 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.473820+02:00 | {"00": null, "11": "green", "12": "red", "13": "green", "21": "red", "22": "red", "23": "red", "31": "green", "32": "red", "33": "green", "41": "green", "51": "red", "52": "red", "61": "red"} | [783] | helsinki | [815] | [275] | {} | Point | 24.894983 | 60.204018 | PL 30811, 00099 Helsingin kaupunki | Tilkka grupphem | 3 | 1 | P.O. Box 30811, 00099 City of Helsinki | 1 | 1 | PB 30811, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||||
| 1570 | [{"section_type": "HIGHLIGHT", "name": {"fi": "P\u00e4ihteet\u00f6nt\u00e4 p\u00e4iv\u00e4toimintaa ei tilap\u00e4isesti j\u00e4rjestet\u00e4.", "sv": "Missbrukarfri dagverksamhet ordnas f\u00f6r tillf\u00e4llet inte.", "en": "Substance-free day activities are not organised at present."}, "www": null, "email": null, "phone": null, "contact_person": null}, {"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": 105}, {"value": "false", "variable": 70}, {"value": "false", "variable": 29}, {"value": "false", "variable": 44}, {"value": "false", "variable": 43}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 23}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 35}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 98}, {"value": "true", "variable": 20}, {"value": "handrails_on_one_side", "variable": 41}, {"value": "over_20mm", "variable": 91}, {"value": "spiral_staircase", "variable": 39}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 38}, {"value": "false", "variable": 49}, {"value": "false", "variable": 79}, {"value": "false", "variable": 22}, {"value": "false", "variable": 42}, {"value": "false", "variable": 107}, {"value": "false", "variable": 37}, {"value": "false", "variable": 55}, {"value": "false", "variable": 52}, {"value": "false", "variable": 40}, {"value": "false", "variable": 62}, {"value": "false", "variable": 5}, {"value": "sufficiently_wide", "variable": 18}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "false", "variable": 102}, {"value": "0", "variable": 1}, {"value": "false", "variable": 103}, {"value": "false", "variable": 34}, {"value": "true", "variable": 51}, {"value": "false", "variable": 84}, {"value": "3", "variable": 63}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 104}, {"value": "false", "variable": 59}, {"value": "false", "variable": 21}, {"value": "false", "variable": 50}, {"value": "false", "variable": 83}, {"value": "true", "variable": 48}, {"value": "false", "variable": 92}, {"value": "true", "variable": 57}, {"value": "false", "variable": 58}] | internal | 968 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Villa Sture päivätoiminta | Substance abuse services/day activities Villa Sture | Sturenkatu 12 | Sturegatan 12 | Sturenkatu 12 | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/paihdepalvelut/paivatoiminta/paihteeton-paivatoiminta/villa-sture | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/paihdepalvelut/paivatoiminta/paihteeton-paivatoiminta/villa-sture | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/paihdepalvelut/paivatoiminta/paihteeton-paivatoiminta/villa-sture | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 50442 | +358 9 310 50442 | 2007-11-15T00:00:00+02:00 | 00510 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.748853+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 | [835, 1056] | [547] | {"fi": ["A-klinikka"]} | Point | 24.94803 | 60.190247 | PL 7720, 00099 Helsingin kaupunki | Missbrukartjänster/dagverksamheten Villa Sture | 7 | 9 | 3 | P.O. Box 7720, 00099 City of Helsinki | 1 | 9 | PB 7720, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||||
| 1926 | [{"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": 5}, {"value": "false", "variable": 76}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 58}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 117}, {"value": "false", "variable": 103}, {"value": "false", "variable": 83}, {"value": "false", "variable": 92}, {"value": "false", "variable": 118}, {"value": "false", "variable": 75}, {"value": "true", "variable": 51}, {"value": "true", "variable": 70}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 104}, {"value": "false", "variable": 98}, {"value": "true", "variable": 73}, {"value": "true", "variable": 52}, {"value": "false", "variable": 48}, {"value": "false", "variable": 78}, {"value": "true", "variable": 59}, {"value": "true", "variable": 115}, {"value": "false", "variable": 84}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 23}, {"value": "long_term_stay", "variable": 60}, {"value": "false", "variable": 34}, {"value": "false", "variable": 33}, {"value": "false", "variable": 53}, {"value": "under_20mm", "variable": 56}, {"value": "4", "variable": 64}, {"value": "true", "variable": 37}, {"value": "true", "variable": 57}, {"value": "true", "variable": 112}, {"value": "true", "variable": 105}, {"value": "true", "variable": 20}, {"value": "true", "variable": 50}, {"value": "false", "variable": 22}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 49}, {"value": "floor_1", "variable": 119}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 29}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 6}, {"value": "false", "variable": 114}, {"value": "floor_2", "variable": 120}, {"value": "false", "variable": 62}, {"value": "false", "variable": 106}, {"value": "true", "variable": 113}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "0", "variable": 1}, {"value": "false", "… | internal | 1361 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kannelmäen palvelutalo | Kannelmäki assisted living facility | Urkupillintie 4 | Orgelpipsvägen 4 | Urkupillintie 4 | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | https://www.hel.fi/sote/toimipisteet-fi/aakkosittain/kannelmaki-pt | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 48822 | +358 9 310 48777 | +358 9 310 48811 | heidi.sipilainen@hel.fi | 2007-11-15T00:00:00+02:00 | 00420 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:00.919054+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "green", "22": "red", "23": "green", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [783, 1403] | helsinki | [2218, 2219, 2220, 2221, 2225, 825] | [901, 900, 898, 896, 895, 760] | {"fi": ["vanhusten asuminen"]} | Point | 24.875124 | 60.242657 | PL 42818, 00099 Helsingin kaupunki | Gamlas servicehus | 1 | 2 | P.O. Box 42818, 00099 City of Helsinki | 1 | 2 | PB 42818, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||
| 4616 | [{"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": 49}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 82}, {"value": "indoor_facility", "variable": 500}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 34}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "true", "variable": 6}, {"value": "false", "variable": 84}, {"value": "false", "variable": 105}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "0", "variable": 1}, {"value": "false", "variable": 33}, {"value": "false", "variable": 29}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 57}, {"value": "false", "variable": 98}, {"value": "true", "variable": 23}, {"value": "3_consecutive_steps", "variable": 24}, {"value": "false", "variable": 50}, {"value": "false", "variable": 21}, {"value": "false", "variable": 53}, {"value": "false", "variable": 92}, {"value": "false", "variable": 48}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 102}, {"value": "false", "variable": 80}, {"value": "true", "variable": 59}, {"value": "false", "variable": 104}, {"value": "chairs_available", "variable": 81}, {"value": "false", "variable": 103}, {"value": "true", "variable": 35}, {"value": "false", "variable": 58}, {"value": "rough", "variable": 17}, {"value": "false", "variable": 107}, {"value": "true", "variable": 5}, {"value": "3_consecutive_steps", "variable": 39}, {"value": "true", "variable": 52}, {"value": "false", "variable": 51}, {"value": "true", "variable": 62}, {"value": "false", "variable": 55}, {"value": "true", "variable": 20}, {"value": "false", "variable": 79}, {"value": "false", "variable": 22}, {"value": "true", "variable": 40}, {"value": "true", "variable": 37}, {"value": "false", "variable": 83}, {"value": "true", "variable": 38}, {"value": "false", "variable": 44}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "under_20mm", "variable": 91}, {"value": "… | internal | 2004 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Haaga 4 lähipalvelualue | Haaga 4 home care unit | Leiviskätie 11 | Lispundsvägen 11 | Leiviskätie 11 | 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 9 310 41146 | +358 9 310 55419 | +358 9 310 41146 | 2008-07-10T22:13:17+03:00 | 00440 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:03.171921+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.879465 | 60.23112 | PL 6615, 00099 Helsingin kaupunki | Haga 4 närserviceområde | 5 | 9 | 4 | P.O. Box 6615, 00099 City of Helsinki | 1 | 9 | PB 6615, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||
| 4845 | [{"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": 70}, {"value": "false", "variable": 103}, {"value": "false", "variable": 48}, {"value": "0", "variable": 1}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 99}, {"value": "true", "variable": 50}, {"value": "false", "variable": 102}, {"value": "same_floor_as_entrance", "variable": 108}, {"value": "false", "variable": 34}, {"value": "false", "variable": 49}, {"value": "false", "variable": 53}, {"value": "true", "variable": 52}, {"value": "requires_use_of_buzzer_and_is_heavy", "variable": 54}, {"value": "true", "variable": 113}, {"value": "false", "variable": 55}, {"value": "false", "variable": 22}, {"value": "false", "variable": 116}, {"value": "false", "variable": 106}, {"value": "false", "variable": 44}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 76}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "true", "variable": 5}, {"value": "true", "variable": 98}, {"value": "true", "variable": 117}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 107}, {"value": "true", "variable": 37}, {"value": "over_20mm", "variable": 56}, {"value": "false", "variable": 29}, {"value": "false", "variable": 62}, {"value": "true", "variable": 57}, {"value": "true", "variable": 20}, {"value": "true", "variable": 105}, {"value": "true", "variable": 74}, {"value": "handrails_on_one_side", "variable": 101}, {"value": "true", "variable": 115}, {"value": "2", "variable": 64}, {"value": "over_20mm", "variable": 91}, {"value": "false", "variable": 23}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 6}, {"value": "false", "variable": 33}, {"value": "true", "variable": 59}, {"value": "false", "variable": 78}, {"value": "false", "variable": 21}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 114}, {"value": "false", "variable": 51}, {"value": "false", "variable": 38}, {"value": "true", "variable": 118}, {"value": "true", "variable": 112}, {"value": "smooth",… | internal | 2047 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Merilahden peruskoulu,Kalvikinniementien toimipiste, kouluterveydenhuolto | Merilahti Comprehensive School, Kalvikinniementie unit, Lower and Upper Stages, school health care | Kallvikinniementie 1 | Kallviksuddsvägen 1 | Kallvikinniementie 1 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 46033 | +358 9 310 72616 | 2008-07-10T22:13:17+03:00 | 00980 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:03.713815+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 | 25.132538 | 60.201607 | PL 98302, 00099 Helsingin kaupunki | Grundskolan Merilahden peruskoulu, Kallviksuddsvägens enhet, skolhälsovård | 3 | 5 | 1 | P.O. Box 98302, 00099 City of Helsinki | 5 | PB 98302, 00099 Helsingfors stad | 8 | |||||||||||||||||||||||||||||||||||||
| 5843 | [{"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": 92}, {"value": "under_20mm", "variable": 56}, {"value": "false", "variable": 75}, {"value": "true", "variable": 116}, {"value": "true", "variable": 70}, {"value": "true", "variable": 107}, {"value": "false", "variable": 29}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 102}, {"value": "true", "variable": 5}, {"value": "true", "variable": 50}, {"value": "true", "variable": 72}, {"value": "false", "variable": 21}, {"value": "opens_with_access_control_key", "variable": 77}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 118}, {"value": "false", "variable": 106}, {"value": "false", "variable": 51}, {"value": "false", "variable": 78}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 37}, {"value": "false", "variable": 33}, {"value": "true", "variable": 112}, {"value": "true", "variable": 20}, {"value": "true", "variable": 113}, {"value": "true", "variable": 114}, {"value": "true", "variable": 22}, {"value": "false", "variable": 44}, {"value": "false", "variable": 38}, {"value": "long_term_stay", "variable": 60}, {"value": "otherwise_stands_out_clearly", "variable": 36}, {"value": "false", "variable": 79}, {"value": "true", "variable": 74}, {"value": "floor_2", "variable": 108}, {"value": "false", "variable": 49}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 52}, {"value": "true", "variable": 59}, {"value": "false", "variable": 62}, {"value": "false", "variable": 48}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "true", "variable": 105}, {"value": "false", "variable": 98}, {"value": "opens_easily_manually", "variable": 54}, {"value": "false", "variable": 104}, {"value": "false", "variable": 6}, {"value": "true", "variable": 53}, {"value": "2", "variable": 64}, {"value": "false", "variable": 34}, {"value": "false", "variable": 23}, {"value": "false", "variable": 103}, {"value": "true", "variable": 115}, {"value": "true", "variable": 57}, {"value": "true", "variable":… | internal | 2439 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Malmin peruskoulu pääkoulu Talvela, kouluterveydenhuolto | Malmi Comprehensive School, Upper Stage, school health care | Talvelantie 1 | Talvelavägen 1 | Talvelantie 1 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 310 5592 | +358 9 310 82930 | www.ymalmipk.edu.hel.fi | Talvelantie 1,pl 3508 | 2008-07-10T22:13:17+03:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:05.310015+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": null} | [986, 1087] | helsinki | [2164, 2165] | [339] | {} | Point | 25.000227 | 60.25494 | PL 70302, 00099 Helsingin kaupunki | Grundskolan Malmin peruskoulu, Talvela, skolhäklsovård | 2 | 2 | P.O. Box 70302, 00099 City of Helsinki | 2 | PB 70302, 00099 Helsingfors stad | 8 | ||||||||||||||||||||||||||||||||||||
| 45005 | [{"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": "ramp_under_6m_long", "variable": 99}, {"value": "opens_automatically", "variable": 77}, {"value": "true", "variable": 57}, {"value": "handrails_on_one_side", "variable": 32}, {"value": "false", "variable": 27}, {"value": "false", "variable": 44}, {"value": "true", "variable": 105}, {"value": "smooth", "variable": 17}, {"value": "false", "variable": 84}, {"value": "true", "variable": 104}, {"value": "true", "variable": 6}, {"value": "false", "variable": 92}, {"value": "true", "variable": 29}, {"value": "false", "variable": 28}, {"value": "true", "variable": 74}, {"value": "false", "variable": 72}, {"value": "true", "variable": 23}, {"value": "true", "variable": 75}, {"value": "false", "variable": 53}, {"value": "false", "variable": 100}, {"value": "indoor_facility", "variable": 500}, {"value": "handrails_on_both_sides", "variable": 101}, {"value": "false", "variable": 48}, {"value": "true", "variable": 70}, {"value": "3", "variable": 64}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 106}, {"value": "true", "variable": 73}, {"value": "true", "variable": 59}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "false", "variable": 102}, {"value": "is_heavy_or_otherwise_hard_to_open", "variable": 54}, {"value": "false", "variable": 103}, {"value": "long_term_stay", "variable": 60}, {"value": "not_guided_not_clear", "variable": 19}, {"value": "false", "variable": 33}, {"value": "true", "variable": 25}, {"value": "true", "variable": 98}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "difficult_to_perceive", "variable": 36}, {"value": "false", "variable": 79}, {"value": "true", "variable": 5}, {"value": "false", "variable": 62}, {"value": "true", "variable": 58}, {"value": "false", "variable": 37}, {"value": "false", "variable": 83}, {"value": "false", "variable": 49}, {"value": "false", "variable": 107}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 51}, {"value": "over_20mm", "variable": 91}, {"value"… | internal | 16679 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Hermannin ryhmäkoti | Hermanni group home | Haukilahdenkuja 15 A 1 | Gäddviksgränden 15 A 1 | Haukilahdenkuja 15 A 1 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 45033 | 2015-05-18T00:01:11+03:00 | 00580 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:57.402823+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 | [815] | [275] | {} | Point | 24.972143 | 60.196167 | PL 8770, 00099 Helsingin kaupunki | Hermansstads grupphem | 3 | 5 | 1 | P.O. Box 8770, 00099 City of Helsinki | 1 | 5 | PB 8770, 00099 Helsingfors stad | 8 |
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 );