servicemap

Custom SQL query returning 1 row (hide)

Query parameters

idparentbusiness_idname_fiabbrstreet_addressaddress_cityaddress_postal_fullwwwphoneaddress_zipoidorganization_typelevelmunicipalitywww_svstreet_address_svstreet_address_enaddress_postal_full_enaddress_city_finame_enwww_enaddress_postal_full_svabbr_fiaddress_postal_full_fiabbr_svabbr_enaddress_city_enname_svstreet_address_fiaddress_city_svwww_fi
84075c47-a8e4-4a45-a109-65221f63b3bf   1567535-0 HUS-kuntayhtymä           +358 9 4711 00290 HUS JOINT_MUNICIPAL_AUTHORITY 0   http://www.hus.fi/sv/Sidor/default.aspx       Helsinki HUS Hospital District http://www.hus.fi/en/Pages/default.aspx   HUS       Helsinki Samkommunen HNS Stenbäckinkatu 9 Helsingfors http://www.hus.fi/Sivut/default.aspx