"It breaks my heart every time", said President Obama today as he responded to yet another shooting. Here are just some of the gun-attacks to have happened since his inauguration in January 2009.
March 2009 - Geneva County Massacre - 10 dead
Michael Kenneth McLendon, 28, a laid-off worker, opens fire while driving through several towns in Alabama.
April 2009 - Binghamton shootings - 13 dead
Jiverly Antares Wong, a naturalised American citizen from Vietnam, starts shooting at a civic centre in New York.
November 2009 - Fort Hood - 13 dead, 42 wounded
U.S. army psychologist, Major Nidal Hasan opens fire at the Texas military base.
February 2010 - University of Alabama in Huntsville - 3 dead, 3 wounded
Amy Bishop, a professor, starts shooting 50 minutes into a Biological Sciences Department faculty meeting, killing three colleagues and injuring three more.
August 2010 - Manchester, CT - 8 dead
Omar Thornton, 34, a driver for Hartford Distributors, leaves a disciplinary hearing and begins shooting before turning the gun on himself.
January 2011 - Tuscon, AZ - 6 dead, 11 wounded
Jared Lee Loughner, 22, shoots Arizona Representative Gabrielle Giffords in the head during a constituents meet-and-greet at a supermarket.
October 2011 - Seal Beach - 8 dead, 1 wounded
Amid a child custody dispute, Scott Dekraai, 41, walks into a crowded California hair salon and opens fire on his former wife. Dekraai pleads not guilty.
April 2012 - Oikos University - 7 dead, 3 wounded
One L. Goh, 43, a former student at the small Christian college starts shooting in a classroom.
July 2012 - Century 16 movie theater shooting - 12 dead, 58 wounded
James Holmes, 24, is arrested after entering a cinema during the late-night premiere of "The Dark Knight Rises" and opening fire. He had booby-trapped his apartment with explosives and was recently jailed and given 12 life sentences.
December 2012 - Sandy Hook Massacre - 27 dead, 1 wounded
Adam Lanza, 20, forces his way into Sandy Hook Elementary School in Newtown, Connecticut. He kills 20 first-graders and six adults. Before arriving at the school, he had killed his mother at their home. At the White House, President Obama wipes away tears, saying “our hearts are broken today".
June 2013 - Santa Monica College - 5 dead
John Zawahri, an unemployed 23-year-old, kills five people in a rampage which begins at his father home and ends in the California college's library.
September 2013 - Washington Navy Yard - 13 dead, 3 injured
Aaron Alexis, a Navy contractor and former Navy man, engages police in a running firefight in the Washington D.C. industrial complex before being shot and killed.
May 2014 - UC Santa Barbara - 7 dead, 7 wounded
Elliot Rodger opens fire in the campus town of Isla Vista, California from inside a black BMW. Rodgers acted alone and written and video evidence suggest the attack is premeditated.
June 2015 - Charleston, South Carolina - 9 dead
White supremacist, Dylann Roof, begins shooting in a historic black church in an attempt to start a race-war.
August 2015 - Roanoke, Virginia - 3 dead, 1 wounded
Vester Lee Flanagan II AKA Bryce Williams shoots dead two former colleagues from the WDBJ7 news team.
October 2015 - Umpqua Community College, Oregon - At least 9 dead and 7 wounded
A gunman attacked a college in Oregon killing at least nine people and injuring seven. Police named the attacker as Chris Harper-Mercer, 26, who had posted online messages about other recent massacres.