Cold Cases Database

This database consists of unsolved homicides collected from family submissions, law enforcement submissions, and public records. This database is not part of our advocacy and awareness platform but a separate database for information purposes only. 

Please note: This database is not updated regularly due to cost and manpower. A bug occurred during a recent update and reset many of the dates to January 1, 1970.

Search

Show More Options

25129 cases found.
CCR: 40067446
VICTIM DETAILS
Name Scharod Fleming
Age 15
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Gun/Firearm
Location At Large
CASE DETAILS
Status Unsolved
Incident Location 220 Golden Gate Avenue
San Francisco, California, 94102
San Francisco County
L.E.A San Francisco Police Department, San Francisco, California

Cold Case Spotlight

Scharod Fleming was attending a teen dance at the YMCA in the Tenderloin neighborhood of San Francisco on January 17, 2004. After two fights broke out and spilled into the street police arrived (around 10:30pm) to defuse the situation. While the teens gathered in front of the building around 11:50pm a gunman opened fire on the crowd, shooting multiple people and killing 15-year-old Scharod Fleming. The Office of the Mayor of San Francisco has authorized a $100,000 reward for information leading to the arrest and prosecution of the suspect responsible for the murder of Scharod Fleming. Persons with information or questions are urged to contact:SFPD Homicide Detail: 415-553-9105, SFPD Homicide Tip Line: 415-431-2127, SFPD CASE # 040 067 446
CCR: Unknown
Date Reported: June 26, 2016
VICTIM DETAILS
Name Fredrick Johnson
Age 41
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 928 N Massasoit Ave
Chicago, Illinois, 60651
Cook County
L.E.A Chicago Police Department, Chicago, Illinois

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Chicago Police Department at (312) 746-6000.
CCR: Unknown
Date Reported: March 18, 2008
VICTIM DETAILS
Name Deondray Hill
Age 30
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 334 Helen St
Cincinnati, Ohio, 45219
Hamilton County
L.E.A Cincinnati Police Department, Cincinnati, Ohio

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Cincinnati Police Department at (513) 352-3536.
CCR: Unknown
Date Reported: October 6, 2017
VICTIM DETAILS
Name Ian Ashford
Age 22
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 4600 N Central Park Ave
Chicago, Illinois, 60625
Cook County
L.E.A Chicago Police Department, Chicago, Illinois

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Chicago Police Department at (312) 746-6000.
CCR: Unknown
Date Reported: October 2, 2016
VICTIM DETAILS
Name Brandon Jones
Age 26
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 78 Charles E Davis Blvd
Nashville, Tennessee, 37210
Davidson County
L.E.A Metropolitan Nashville Police Department, Nashville, Tennessee

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Metropolitan Nashville Police Department at (615) 862-7400.
CCR: Unknown
Date Reported: July 18, 2016
VICTIM DETAILS
Name Daniel Lovato Jr.
Age 27
Gender Male
Race Caucasian/White
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 7100 Trumbull Ave SE
Albuquerque, New Mexico, 87108
Bernalillo County
L.E.A Albuquerque Police Department, Albuquerque, New Mexico

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Albuquerque Police Deparment at (505) 242-2677.
CCR: Unknown
Date Reported: March 28, 2010
VICTIM DETAILS
Name Jose Flores
Age 35
Gender Male
Race Hispanic/Latino
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 1520 Castroville Rd
San Antonio, Texas, 78237
Bexar County
L.E.A San Antonio Police Department, San Antonio, Texas

CCR: Unknown
Date Reported: February 9, 2008
VICTIM DETAILS
Name Clarence Williams
Age 53
Gender Male
Race African American/Black
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location S Wolcott Ave
Chicago, Illinois, 60620
L.E.A Chicago Police Department, Chicago, Illinois

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Chicago Police Department at (312) 746-6000.
CCR: Unknown
Date Reported: March 11, 2008
VICTIM DETAILS
Name Maximino Macedo-Santana
Age 23
Gender Male
Race Hispanic/Latino
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 9889 Harwin Dr
Houston, Texas, 77036
Harris County
L.E.A Houston Police Department, Houston, Texas

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Houston Police Department at (713) 222-8477.
CCR: Unknown
Date Reported: April 30, 2010
VICTIM DETAILS
Name Bernard Jackson
Age 23
Gender Unknown
Race Unknown
SUSPECT DETAILS
Name Unknown
Offense Murder
Cause Unknown
Location Unknown
CASE DETAILS
Status Unsolved
Incident Location 8409 E 108th St
Kansas City, Missouri, 64134
Jackson County
L.E.A Kansas City Police Department, Kansas City, Missouri

This case was gathered through a partnership with The Washington Post. The Post gathered information from 50 large cities in the United States regarding their unsolved murders. View the original article here: https://www.washingtonpost.com/graphics/2018/investigations/where-murders-go-unsolved/?noredirect=on&utm_term=.986316f33dac Anyone with information regarding this case is encouraged to contact the Kansas City Police Department at (816) 234-5000 .