12 rows where "created_time" is on date 2012-12-31

View and edit SQL

id ▼ connections accessibility_properties identifiers_0_namespace identifiers_0_value identifiers_1_namespace identifiers_1_value department root_department provider_type organizer_type contract_type_id contract_type_description_fi contract_type_description_sv contract_type_description_en is_active deleted_at organizer_name organizer_business_id picture_url picture_entrance_url streetview_entrance_url description_fi description_en short_description name_fi name_en street_address_fi street_address_sv street_address_en www_fi www_sv www_en address_postal_full call_charge_info_fi call_charge_info_sv call_charge_info_en picture_caption phone fax accessibility_phone accessibility_email accessibility_www created_time address_zip data_source extensions_maintenance_group extensions_maintenance_organization last_modified_time accessibility_viewpoints root_service_nodes municipality service_nodes services keywords location_type location_coordinates_0 location_coordinates_1 address_postal_full_fi identifiers_2_value picture_caption_fi call_charge_info www name_sv short_description_fi accessibility_shortcoming_count_reduced_mobility accessibility_shortcoming_count_wheelchair location picture_caption_sv accessibility_shortcoming_count_stroller address_postal_full_en accessibility_shortcoming_count_hearing_aid street_address contract_type accessibility_shortcoming_count_rollator identifiers_2_namespace address_postal_full_sv short_description_sv description_sv accessibility_shortcoming_count_visually_impaired short_description_en description picture_caption_en
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

CSV options:

CREATE TABLE [unit] (
   [id] INTEGER PRIMARY KEY,
   [connections] TEXT,
   [accessibility_properties] TEXT,
   [identifiers_0_namespace] TEXT,
   [identifiers_0_value] TEXT,
   [identifiers_1_namespace] TEXT,
   [identifiers_1_value] TEXT,
   [department] TEXT,
   [root_department] TEXT,
   [provider_type] TEXT,
   [organizer_type] TEXT,
   [contract_type_id] TEXT,
   [contract_type_description_fi] TEXT,
   [contract_type_description_sv] TEXT,
   [contract_type_description_en] TEXT,
   [is_active] INTEGER,
   [deleted_at] TEXT,
   [organizer_name] TEXT,
   [organizer_business_id] TEXT,
   [picture_url] TEXT,
   [picture_entrance_url] TEXT,
   [streetview_entrance_url] TEXT,
   [description_fi] TEXT,
   [description_en] TEXT,
   [short_description] TEXT,
   [name_fi] TEXT,
   [name_en] TEXT,
   [street_address_fi] TEXT,
   [street_address_sv] TEXT,
   [street_address_en] TEXT,
   [www_fi] TEXT,
   [www_sv] TEXT,
   [www_en] TEXT,
   [address_postal_full] TEXT,
   [call_charge_info_fi] TEXT,
   [call_charge_info_sv] TEXT,
   [call_charge_info_en] TEXT,
   [picture_caption] TEXT,
   [phone] TEXT,
   [fax] TEXT,
   [email] TEXT,
   [accessibility_phone] TEXT,
   [accessibility_email] TEXT,
   [accessibility_www] TEXT,
   [created_time] TEXT,
   [address_zip] TEXT,
   [data_source] TEXT,
   [extensions_maintenance_group] TEXT,
   [extensions_maintenance_organization] TEXT,
   [last_modified_time] TEXT,
   [accessibility_viewpoints] TEXT,
   [root_service_nodes] TEXT,
   [municipality] TEXT,
   [service_nodes] TEXT,
   [services] TEXT,
   [keywords] TEXT,
   [location_type] TEXT,
   [location_coordinates_0] FLOAT,
   [location_coordinates_1] FLOAT,
   [address_postal_full_fi] TEXT,
   [identifiers_2_value] TEXT,
   [picture_caption_fi] TEXT,
   [call_charge_info] TEXT,
   [www] TEXT,
   [name_sv] TEXT,
   [short_description_fi] TEXT,
   [accessibility_shortcoming_count_reduced_mobility] TEXT,
   [accessibility_shortcoming_count_wheelchair] TEXT,
   [location] TEXT,
   [picture_caption_sv] TEXT,
   [accessibility_shortcoming_count_stroller] TEXT,
   [address_postal_full_en] TEXT,
   [accessibility_shortcoming_count_hearing_aid] TEXT,
   [street_address] TEXT,
   [contract_type] TEXT,
   [accessibility_shortcoming_count_rollator] TEXT,
   [identifiers_2_namespace] TEXT,
   [address_postal_full_sv] TEXT,
   [short_description_sv] TEXT,
   [description_sv] TEXT,
   [accessibility_shortcoming_count_visually_impaired] TEXT,
   [short_description_en] TEXT,
   [description] TEXT,
   [picture_caption_en] TEXT
);