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