The Mystery genre is a category of books that typically involves a crime, puzzle, or enigma that needs to be solved by the protagonist or a group of characters. These books often feature suspenseful and thrilling plotlines, with unexpected twists and turns that keep readers engaged and guessing until the very end. Mystery novels can range from cozy mysteries, which are lighter and more lighthearted, to hard-boiled detective stories, which are darker and more gritty. Overall, the Mystery genre is a popular and diverse category of books that appeals to readers who enjoy solving puzzles and uncovering secrets.

Dystopian literature is a genre of speculative fiction that explores social and political structures in a dark, nightmare world. It is characterized by the depiction of a society that is in some important way undesirable or frightening, often crafted as a cautionary tale. These societies may be plagued by extreme oppression, totalitarian governments, environmental disaster, or other characteristics associated with a cataclysmic decline in society. Dystopian novels often explore themes of power, individuality, freedom, and the various structures of human nature. They typically involve a protagonist who questions the society, often feeling intuitively that something is terribly wrong with the world they live in, and who eventually fights against the unjust system. Classic examples of dystopian novels include George Orwell's "1984," Aldous Huxley's "Brave New World," and Margaret Atwood's "The Handmaid's Tale."

The "San Francisco" category of books encompasses literature that is set in or inspired by the city of San Francisco, California. This genre includes a wide range of fiction and non-fiction works that explore the city's unique culture, history, and geography. From tales of the Beat Generation to stories of the tech industry, "San Francisco" books offer readers a glimpse into the vibrant and diverse world of this iconic American city.

If you're interested in downloading this list as a CSV file for use in a spreadsheet application, you can easily do so by clicking the button below. Please note that to ensure a manageable file size and faster download, the CSV will include details for only the first 500 books.