Noah’s Market Database Backup

These files contain the same exact data in different formats. You should only need to download one of these files to solve the puzzles.

The password is the same as the password in the Introduction.

• noahs-csv.zip (6MB)
• noahs-jsonl.zip (6MB)
• noahs-sqlite.zip (10MB)

Resources

Here are some free and open-source tools you might find useful to explore and query the above data.

• VisiData: Our bonkers data exploration tool for the terminal.
• Datasette: Simon Willison’s excellent tool to publish SQLite databases in the web browser.
• WizardZines - Become a SELECT Star: Julia Evans’ awesome zine for SQL.
• Ibis: Python expressions to SQLite and many other databases.