1 row where picture_entrance_url = "http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg" sorted by picture_caption_fi

View and edit SQL

Suggested facets: created_time (date), last_modified_time (date)

picture_entrance_url

  • http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg · 1
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
54394 [] [{"value": "false", "variable": 84}, {"value": "false", "variable": 62}, {"value": "false", "variable": 103}, {"value": "false", "variable": 23}, {"value": "true", "variable": 106}, {"value": "false", "variable": 22}, {"value": "true", "variable": 70}, {"value": "true", "variable": 37}, {"value": "true", "variable": 75}, {"value": "false", "variable": 48}, {"value": "true", "variable": 57}, {"value": "at_least_3600mm", "variable": 3}, {"value": "true", "variable": 73}, {"value": "true", "variable": 59}, {"value": "false", "variable": 21}, {"value": "true", "variable": 20}, {"value": "true", "variable": 51}, {"value": "canopy_above_entrance", "variable": 36}, {"value": "opens_automatically", "variable": 77}, {"value": "under_20mm", "variable": 91}, {"value": "outdoors", "variable": 2}, {"value": "true", "variable": 76}, {"value": "true", "variable": 72}, {"value": "false", "variable": 107}, {"value": "false", "variable": 102}, {"value": "true", "variable": 58}, {"value": "true", "variable": 5}, {"value": "under_10m", "variable": 4}, {"value": "false", "variable": 83}, {"value": "under_20mm", "variable": 56}, {"value": "not_guided_but_clear", "variable": 19}, {"value": "false", "variable": 44}, {"value": "smooth", "variable": 17}, {"value": "true", "variable": 6}, {"value": "4", "variable": 64}, {"value": "false", "variable": 33}, {"value": "indoor_facility", "variable": 500}, {"value": "false", "variable": 79}, {"value": "true", "variable": 53}, {"value": "true", "variable": 74}, {"value": "false", "variable": 92}, {"value": "false", "variable": 38}, {"value": "true", "variable": 105}, {"value": "sufficiently_wide", "variable": 18}, {"value": "opens_automatically_with_button", "variable": 54}, {"value": "false", "variable": 98}, {"value": "false", "variable": 34}, {"value": "long_term_stay", "variable": 60}, {"value": "true", "variable": 50}, {"value": "true", "variable": 78}, {"value": "true", "variable": 104}, {"value": "false", "variable": 49}, {"value": "1", "variable": 1}, {"value": "true", "variable": 52}, {… internal 24050     b5c38de6-66f7-4d1e-befb-eeca69e4f99c b5c38de6-66f7-4d1e-befb-eeca69e4f99c OTHER_PRODUCTION_METHOD FOUNDATION         1       http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg http://health.aalto.fi/en/midcom-serveattachmentguid-1e6ac0c2155be16ac0c11e69fbe6d36072d6d276d27/health_technology_house_otakaari_3.jpg https://goo.gl/maps/jcxcL3f3wdt Health Technology House (HTH) Otakaari 3:ssa on kotipaikka muun muassa seuraaville:- Neurotieteen ja lääketieteellisen tekniikan laitos (Perustieteiden korkeakoulu)- Eräät Sähkötekniikan korkeakoulun tutkimusryhmät- Biodesign Finland (Otaniemen toimisto)- Aalto Brain Centre- Aalto NeuroImaging (toimisto)- Aalto Health Platform (toimisto)- Health Capital Helsinki (Otaniemen toimisto)- Aalto Health Factory- Opiskelijaravintola Kvarkki- Lääketieteellisen tekniikan ja neurotieteen ja - teknologian alojen opetusSuunnitelmien mukaan HTH:n tiloissa toimii tulevaisuudessa yksi tai useampia terveysteknologian alan yrityksiä. The Health Technology House (HTH), located on Aalto University's main campus in Otaniemi, unites research groups whose work revolves around electrical devices, neuroscience, or related signal processing. The House contains most of the faculty of the Biomedical Engineering and Neuroscience and -technology subareas of Aalto's Health & Wellbeing research community. Examples of research focus areas are medical imaging equipment, neurological therapy devices, rehabilitation technologies, and neurosciences. Faculty and staff in the House produce research with high scientific quality, and there is high productivity in innovation as well. More broadly, Aalto Health Platform, uniting the university's Health & Wellbeing professors and research groups for increased collaboration, is managed from the House.Health Technology House is the current home for the following units and activities:- Department of Neuroscience and Biomedical Engineering (School of Science)- Research groups of School of Electrical Engineering- Biodesign Finland (office in Otaniemi) - Aalto Brain Centre- Aalto NeuroImaging (office)- Aalto Health Platform (office)- Health Capital Helsinki (office in Otaniemi)- Aalto Health Factory- Student restaurant Kvarkki (run by Sodexo)- Learning and teaching activities in biomedical engineering and neuroscience and -technologyIn the future, it is planned that HTH will become the new home for one or several companies in the field of health technology.   Aalto-yliopiston terveysteknologian talo Aalto University Health Technology House Otakaari 3 Otsvängen 3 Otakaari 3 http://health.aalto.fi/en/healthtechnologyhouse/ http://health.aalto.fi/en/healthtechnologyhouse/ http://health.aalto.fi/en/healthtechnologyhouse/               +358 9 470 01 health@aalto.fi http://health.aalto.fi/en/healthtechnologyhouse/driving_instructions/ 2017-08-30T11:47:51+03:00 02150   kaikki espoo 2020-03-13T09:32:29.960438+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"} [1087] espoo [1359] [822] {} Point 24.829647 60.188343     Terveysteknologian talo       Talossa toimii useita terveysteknologian yrityksiä opetus- ja tutkimustilojen lisäksi, 1 1         1     1         1 HTH will become the home for several companies in the field of health technology.   Health Technology House

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
);