I have read on Hacker News today that

The overall solution rate for murder in the US is about 65%. In big cities with dubious police leadership, the solution rate for murder can be under 50%.

(Chicago, Baltimore, St.Lou etc..., right?)

Where can one get the dataset for the States, and for other countries of the world, at any level of aggregation?

Yes, I do know about police misreporting, and forced confessions. Having both corrected and raw rates would be great.

The narrowest definition is finding the victim's body. Rate of unsolved disappearance cases would be a welcome, but not essential variable.

Similar questions here:

P.S. Use case - should be an excellent indicator of rule of law/lawlessness in an area.

  • look at the geographies available in the national crime and victimization survey? May 13, 2017 at 22:08
  • BTW, lower "solution" rates in big cities might simply be because there are more possible suspects and/or more places to hide the bodies. Watch out for statistical speculation: it can be very wrong.
    – user3856
    May 14, 2017 at 17:14

3 Answers 3


The Uniform Crime Report program will have the best answer to your question for the U.S. The best known part of this program is the annual report "Crime in the United States" issued by the FBI every fall. That's the source of most of your crime rate information reported in the popular press. What you're looking for is the clearance rate -- which is not quite the same as a solved case, but is very close. There is no way to get clearance information at a department/local level from the mainstream reports. That data is archived at the ICPSR, a social research repository at the University of Michigan. Here's a link to the latest raw data - https://www.icpsr.umich.edu/icpsrweb/ICPSR/series/57 - it's from 2015.


Kaggle has a Murder Accountability dataset you may find useful.


Generally, it is quite easy to find some open historical data. For example:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.