unit
12 rows where "created_time" is on date 2012-12-31
This data as json, CSV (advanced)
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
31791 | [{"section_type": "OPENING_HOURS", "name": {"fi": "avoinna ma-pe 08-16, suljettu poikkeuksellisesti alkaen 4.9.2020 pe", "sv": "\u00f6ppet m\u00e5n-fre 08-16, undantagsvis st\u00e4ngt fr\u00e5n 4.9.2020 fre", "en": "open Mon-Fri 08-16, exceptionally closed from 4 Sep 2020 Fri"}, "www": null, "email": null, "phone": null, "contact_person": null}, {"section_type": "HIGHLIGHT", "name": {"fi": "Terveysasema on auki arkisin klo 8-16 (ei iltavastaanottoja).", "sv": "H\u00e4lsostationen \u00e4r \u00f6ppen vardagar kl. 8-16 (ingen kv\u00e4llsmottagning).", "en": "The health station is open on weekdays from 8 am to 4 pm (no evening appointments)."}, "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, … | [{"value": "true", "variable": 52}, {"value": "true", "variable": 5}, {"value": "short_term_stay", "variable": 60}, {"value": "true", "variable": 16}, {"value": "true", "variable": 74}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 82}, {"value": "true", "variable": 58}, {"value": "true", "variable": 115}, {"value": "true", "variable": 117}, {"value": "under_20mm", "variable": 91}, {"value": "true", "variable": 13}, {"value": "false", "variable": 49}, {"value": "true", "variable": 116}, {"value": "false", "variable": 38}, {"value": "over_10m", "variable": 4}, {"value": "false", "variable": 7}, {"value": "true", "variable": 109}, {"value": "sufficiently_wide", "variable": 18}, {"value": "false", "variable": 44}, {"value": "false", "variable": 98}, {"value": "true", "variable": 107}, {"value": "true", "variable": 20}, {"value": "false", "variable": 83}, {"value": "2", "variable": 63}, {"value": "false", "variable": 92}, {"value": "true", "variable": 113}, {"value": "parking_hall", "variable": 2}, {"value": "false", "variable": 22}, {"value": "true", "variable": 80}, {"value": "true", "variable": 78}, {"value": "true", "variable": 104}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "true", "variable": 73}, {"value": "true", "variable": 112}, {"value": "true", "variable": 72}, {"value": "at_least_3600mm", "variable": 3}, {"value": "opens_automatically", "variable": 15}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 103}, {"value": "false", "variable": 62}, {"value": "true", "variable": 70}, {"value": "false", "variable": 79}, {"value": "true", "variable": 8}, {"value": "true", "variable": 37}, {"value": "chairs_available", "variable": 81}, {"value": "true", "variable": 57}, {"value": "false", "variable": 21}, {"value": "true", "variable": 106}, {"value": "false", "variable": 102}, {"value": "true", "variable": 105}, {"value": "false", "variable": 48}, {"value": "true", "variable": 6}, {"value": "false", "variable": 23}, {"value": "false",… | internal | 11342 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Idän terveysasema/Myllypuro | Myllypuro Health Station | Jauhokuja 4 | Mjölgränden 4 | Jauhokuja 4 | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/terveysasemat/terveysasemien-yhteystiedot/myllypuron-terveysasema | https://www.hel.fi/helsinki/sv/social-och-halso/halso/halsostationer/kontaktuppgifter/kvarnbackens-halsostation | https://www.hel.fi/helsinki/en/socia-health/health/stations/contact-information/myllypuro-health-station | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 60360 | +358 9 310 60363 | +358 9 310 60360 | 2012-12-31T08:24:04+02:00 | 00920 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.071651+02:00 | {"00": null, "11": "green", "12": "green", "13": "green", "21": "green", "22": "green", "23": "green", "31": "green", "32": "green", "33": "green", "41": "green", "51": "red", "52": "red", "61": "green"} | [986] | helsinki | [992, 993, 991] | [703, 702, 417] | {"en": ["health care center"], "fi": ["terveyskeskus", "Myllypuron terveysasema", "terveysasema", "terveysasemat", "aulapalvelut", "Soten aulapalvelut", "aulapalvelualue2", "aulapalvelualue 2"], "sv": ["h\u00e4lsostation"]} | Point | 25.076681 | 60.225864 | PL 6210, 00099 Helsingin kaupunki | Kvarnbäckens hälsostation | P.O. Box 6210, 00099 City of Helsinki | PB 6210, 00099 Helsingfors stad | 1 | |||||||||||||||||||||||||||||||||||||
31802 | [{"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}] | [] | internal | 11227 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Suursuon vuodeosastot | Suursuon vuodeosastot | Suursuonlaita 3 B | Storkärrskanten 3 B | Suursuonlaita 3 B | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5017 | 2012-12-31T08:24:04+02:00 | 00630 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.083458+02:00 | [986] | helsinki | [1012] | [264] | {} | Point | 24.933016 | 60.234814 | PL 6700, 00099 Helsingin kaupunki | Storkärrs vårdavdelningar | P.O. Box 6700, 00099 City of Helsinki | PB 6700, 00099 Helsingfors stad | ||||||||||||||||||||||||||||||||||||||||||||
31808 | [{"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}] | [] | internal | 11828 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Sosiaali- ja kriisipäivystys | Social and crisis emergency services | Säästöpankinranta 2 A, 5. krs | Sparbankskajen 2 A, 5. vån. | Säästöpankinranta 2 A, 5. floor | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/paivystys/sokri-paivystys/ | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/paivystys/sokri-paivystys/ | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/terveyspalvelut/paivystys/sokri-paivystys/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5015 | 2012-12-31T08:24:04+02:00 | 00530 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.105937+02:00 | [783, 1401] | helsinki | [2011, 189, 857, 2012] | [841, 840, 420] | {} | Point | 24.94925 | 60.179405 | PL 8630, 00099 Helsingin kaupunki | Social- och krisjour | P.O. Box 8630, 00099 City of Helsinki | PB 8630, 00099 Helsingfors stad | |||||||||||||||||||||||||||||||||||||||||
31947 | [{"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": "at_least_4_steps", "variable": 39}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 37}, {"value": "true", "variable": 112}, {"value": "true", "variable": 38}, {"value": "true", "variable": 52}, {"value": "true", "variable": 62}, {"value": "true", "variable": 20}, {"value": "true", "variable": 114}, {"value": "false", "variable": 49}, {"value": "true", "variable": 42}, {"value": "true", "variable": 22}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "short_term_stay", "variable": 60}, {"value": "false", "variable": 98}, {"value": "floor_1", "variable": 108}, {"value": "false", "variable": 79}, {"value": "false", "variable": 33}, {"value": "false", "variable": 83}, {"value": "false", "variable": 34}, {"value": "true", "variable": 51}, {"value": "true", "variable": 59}, {"value": "true", "variable": 116}, {"value": "false", "variable": 84}, {"value": "false", "variable": 5}, {"value": "false", "variable": 105}, {"value": "true", "variable": 107}, {"value": "opens_with_access_control_key", "variable": 54}, {"value": "over_20mm", "variable": 56}, {"value": "true", "variable": 57}, {"value": "true", "variable": 40}, {"value": "false", "variable": 53}, {"value": "false", "variable": 117}, {"value": "true", "variable": 50}, {"value": "false", "variable": 21}, {"value": "0", "variable": 1}, {"value": "false", "variable": 103}, {"value": "true", "variable": 27}, {"value": "false", "variable": 80}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 104}, {"value": "true", "variable": 23}, {"value": "false", "variable": 102}, {"value": "false", "variable": 48}, {"value": "waiting_not_necessary", "variable": 81}, {"value": "false", "variable": 29}, {"value": "false", "variable": 28}, {"value": "false", "variable": 43}, {"value": "false", "variable": 92}, {"value": "at_least_4_steps", "variable": 24}, {"value": "true", "variable": 115}, {"value": "false", "variable": 109}, {"value": "true", "variable": 25}, {"value": "smooth", "variable": 17}, … | internal | 11726 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Pohjoisen kotisairaala | Northern home hospital | Talvelantie 6, rak. 4 | Talvelavägen 6, byggnad 4 | Talvelantie 6, bldg 4 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 67480 | +358 9 310 67410 | +358 9 310 67480 | 2012-12-31T08:24:04+02:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.124043+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 | [1013] | [336] | {} | Point | 24.998795 | 60.253815 | PL 6500, 00099 Helsingin kaupunki | Norra hemsjukhuset | 3 | 7 | 2 | P.O. Box 6500, 00099 City of Helsinki | 1 | 7 | PB 6500, 00099 Helsingfors stad | 7 | |||||||||||||||||||||||||||||||||||
31963 | [{"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}] | [] | internal | 12365 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Laakson toimintaterapia | Laakso occupational therapy | Lääkärinkatu 8 | Läkaregatan 8 | Lääkärinkatu 8 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 4701 | +358 9 310 50944 | 2012-12-31T08:24:04+02:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.134181+02:00 | [986] | helsinki | [1038] | [712] | {} | Point | 24.917477 | 60.193058 | PL 6600, 00099 Helsingin kaupunki | Dals ergoterapi | P.O. Box 6600, 00099 City of Helsinki | PB 6600, 00099 Helsingfors stad | |||||||||||||||||||||||||||||||||||||||||||
31966 | [{"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}] | [] | internal | 11339 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Mielialahäiriöosastot | Affective syndrome wards | Nordenskiöldinkatu 20 | Nordenskiöldsgatan 20 | Nordenskiöldinkatu 20 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5015 | +358 9 310 65064 | 2012-12-31T08:24:04+02:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.144907+02:00 | [986] | helsinki | [1020, 1011, 1041, 1038] | [712, 525, 263, 46] | {} | Point | 24.927237 | 60.192482 | PL 6800, 00099 Helsingin kaupunki | Avdelningar för affektiva störningar | P.O. Box 6800, 00099 City of Helsinki | PB 6800, 00099 Helsingfors stad | |||||||||||||||||||||||||||||||||||||||||||
31991 | [{"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}] | [] | internal | 11422 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Malmin toimintaterapia | Malmi occupational therapy | Talvelantie 6 | Talvelavägen 6 | Talvelantie 6 | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3050 | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3050 | https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/palvelukuvaus?id=3050 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 6611 | +358 9 310 67450 | 2012-12-31T08:24:04+02:00 | 00700 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.156275+02:00 | [986] | helsinki | [1038] | [712] | {} | Point | 24.998795 | 60.253815 | PL 6500, 00099 Helsingin kaupunki | Malms ergoterapi | P.O. Box 6500, 00099 City of Helsinki | PB 6500, 00099 Helsingfors stad | ||||||||||||||||||||||||||||||||||||||||
32039 | [{"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": 117}, {"value": "true", "variable": 105}, {"value": "true", "variable": 51}, {"value": "false", "variable": 59}, {"value": "true", "variable": 116}, {"value": "false", "variable": 79}, {"value": "handrails_on_both_sides", "variable": 47}, {"value": "true", "variable": 5}, {"value": "false", "variable": 46}, {"value": "true", "variable": 44}, {"value": "is_heavy", "variable": 77}, {"value": "smooth", "variable": 17}, {"value": "2", "variable": 63}, {"value": "false", "variable": 115}, {"value": "true", "variable": 73}, {"value": "true", "variable": 113}, {"value": "false", "variable": 75}, {"value": "handrails_on_both_sides", "variable": 26}, {"value": "false", "variable": 102}, {"value": "same_floor_as_service_point", "variable": 108}, {"value": "false", "variable": 103}, {"value": "true", "variable": 74}, {"value": "true", "variable": 80}, {"value": "guided_and_clear", "variable": 19}, {"value": "outdoors", "variable": 2}, {"value": "handrails_on_both_sides", "variable": 41}, {"value": "true", "variable": 72}, {"value": "false", "variable": 49}, {"value": "false", "variable": 92}, {"value": "true", "variable": 40}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 45}, {"value": "less_than_3600mm", "variable": 3}, {"value": "true", "variable": 29}, {"value": "false", "variable": 62}, {"value": "indoor_facility", "variable": 500}, {"value": "true", "variable": 38}, {"value": "false", "variable": 31}, {"value": "false", "variable": 114}, {"value": "true", "variable": 23}, {"value": "false", "variable": 82}, {"value": "2", "variable": 1}, {"value": "sufficiently_wide", "variable": 18}, {"value": "true", "variable": 106}, {"value": "false", "variable": 33}, {"value": "true", "variable": 70}, {"value": "ramp_over_6m_long_with_intermediate_landing", "variable": 30}, {"value": "at_least_4_turning_steps", "variable": 24}, {"value": "true", "variable": 25}, {"value": "true", "variable": 104}, {"value"… | internal | 11761 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Kehitysvammapoliklinikka | Clinic for the intellectually disabled | Sofianlehdonkatu 8, A-rakennus | Sofielundsgatan 8, A-byggnad | Sofianlehdonkatu 8, A-building | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 52550 | +358 9 310 52550 | 2012-12-31T08:24:04+02:00 | 00610 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.169434+02:00 | {"00": null, "11": "red", "12": "red", "13": "red", "21": "red", "22": "red", "23": "red", "31": "red", "32": "red", "33": "red", "41": "green", "51": "red", "52": "red", "61": "red"} | [783, 986] | helsinki | [1031, 1007, 1038] | [712, 284, 172] | {} | Point | 24.94773 | 60.20373 | PL 6461, 00099 Helsingin kaupunki | Polikliniken för personer med utvecklingsstörning | 3 | 4 | P.O. Box 6461, 00099 City of Helsinki | 1 | 4 | PB 6461, 00099 Helsingfors stad | 3 | |||||||||||||||||||||||||||||||||||||
32088 | [{"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}] | [] | internal | 15095 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Psykiatrian ryhmäterapiakeskus | Group therapy centre | Nordenskiöldinkatu 20 | Nordenskiöldsgatan 20 | Nordenskiöldinkatu 20 | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/psykiatriset-palvelut/avohoito-muut/ryhmaterapiakeskus/ | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/psykiatriset-palvelut/avohoito-muut/ryhmaterapiakeskus/ | https://www.hel.fi/helsinki/fi/sosiaali-ja-terveyspalvelut/mielenterveys-ja-paihdepalvelut/psykiatriset-palvelut/avohoito-muut/ryhmaterapiakeskus/ | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 5015 | +358 9 310 49991 | 2012-12-31T08:24:04+02:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.181157+02:00 | [986] | helsinki | [1023] | [521] | {} | Point | 24.927237 | 60.192482 | PL 6800, 00099 Helsingin kaupunki | Gruppterapicentret | P.O. Box 6800, 00099 City of Helsinki | PB 6800, 00099 Helsingfors stad | ||||||||||||||||||||||||||||||||||||||||
32127 | [{"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}] | [] | internal | 15286 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Helsingin kristillinen koulu, kouluterveydenhuolto | Helsingin kristillinen koulu, school health care | Pieksupolku 5 | Pjäxstigen 5 | Pieksupolku 5 | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 50 463 7407 | 2012-12-31T08:24:04+02:00 | 00720 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.192874+02:00 | [986, 1087] | helsinki | [2164, 2165] | [339] | {} | Point | 24.984251 | 60.247864 | Helsingin kristillinen koulu, skolhälsovård | |||||||||||||||||||||||||||||||||||||||||||||||
32151 | [{"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": "Terveysneuvonta, asiointipalvelut"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4073"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 14737 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Nuorten terveystarkastukset | Health controls for young people | Mechelininkatu 46, 4. krs | Mechelingatan 46, 4. vån. | Mechelininkatu 46, 4. floor | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 46730 | 2012-12-31T08:24:04+02:00 | 00250 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.206384+02:00 | [986] | helsinki | [992, 991] | [703, 417] | {} | Point | 24.915346 | 60.18486 | PL 8650, 00099 Helsingin kaupunki | Hälsoundersökningar för unga | P.O. Box 8650, 00099 City of Helsinki | PB 8650, 00099 Helsingfors stad | ||||||||||||||||||||||||||||||||||||||||||||
32190 | [{"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": "Neuvolan s\u00e4hk\u00f6inen asiointi"}, "www": {"fi": "https://www.hel.fi/helsinki/fi/kaupunki-ja-hallinto/hallinto/palvelut/asiointipalvelu?id=4201"}, "email": null, "phone": null, "contact_person": null}] | [] | internal | 14951 | d4b3a166-9fa0-4846-9d63-ff1fdab670b6 | 83e74666-0836-4c1d-948a-4b34a8b90301 | SELF_PRODUCED | municipal_service | kunnallinen palvelu | kommunal tjänst | municipal service | 1 | Neuvoloiden keskitetty ajanvaraus | Appointment bookings to maternity and child health clinics | Rautalammintie 2, 2. krs | Rautalampivägen 2, 2. vån. | Rautalammintie 2, 2. floor | pvm/mpm | lna/msa | local network charge/mobile call charge | +358 9 310 55530 | 2012-12-31T08:24:04+02:00 | 00550 | www.hel.fi | kaikki | helsinki | 2020-11-27T13:01:30.217525+02:00 | [986] | helsinki | [1005, 1008] | [835, 379] | {} | Point | 24.954578 | 60.19633 | PL 6451, 00099 Helsingin kaupunki | Rådgivningsbyråernas centraliserade tidsbeställning | P.O. Box 6451, 00099 City of Helsinki | PB 6451, 00099 Helsingfors stad |
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 );