CrookBook is a web-based application that is tailored for use by the Los Angeles Police Department (LAPD) in regards to their cold case murder files. Prior to CrookBook, the LAPD had been storing their murder case files in binders with no efficient method for sorting, querying, or physically locating case data other than compiling large Excel files.

The goal of CrookBook is to make a user-friendly application that allows LAPD detectives to intuitively input, edit, and search their binders for case information in a timely and organized manner. CrookBook contains two search engines, one for fast queries, and the other for detailed queries. The fast search allows users to intuitively search for cases based on keywords, while the advanced search allows users to input values for specific fields that they are interested in. Each entry in the database has its own unique details page where users can view and edit case specific information.

CrookBook uses Postgres for storing and managing case file data, Python and Django for the backend logic, and HTML, CSS and JavaScript to create an intuitive user interface.