Journalist dies in hospital after being shot