Six people are dead and four are hospitalized from the Virginia shooting, while the suspect is dead from what is believed to be a self-inflicted gunshot wound, authorities said