CASE FILE · No. 005 · 1893
The Limehouse Web
LIMEHOUSE, EAST LONDON · DIFFICULTY: CAPITAL
THE BRIEFING
Three establishment owners in Limehouse — a den proprietor, a pawnbroker, and a publican — were found dead over the course of six weeks in the spring of 1893. Each had received a written threat before dying. The murders are too clean, too calculated, too familiar in method to be unrelated. A reliable informant places a single individual near each crime scene on the night in question. The shipping authority's crew manifests place that same individual aboard a vessel docked in the East India Docks throughout the entire period. You have five tables. Use them all.
CLUES ON THE TABLE
- 01.All three victims received written threats before their deaths — check the sender
- 02.The killer's ship was docked in London from before the first murder to after the last
- 03.Informant sightings place one individual near every crime scene on the night of each killing
- 04.Cross all five tables: a single name will emerge
/ THE EVIDENCE
Database Schema
The tables we have warrants for. Cross-reference them carefully.
- idINT
- nameTEXT
- occupationTEXT
- killed_onDATE
- locationTEXT
- idINT
- victim_idINT→ victims.id
- sent_byTEXT
- sent_onDATE
- idINT
- nameTEXT
- arrivedDATE
- departedDATE
- idINT
- ship_idINT→ ships.id
- nameTEXT
- rankTEXT
- idINT
- suspectTEXT
- locationTEXT
- sighted_onDATE
/ THE QUERY TERMINAL
Interrogate the records
This is your magnifying glass. Run queries to explore the tables and chase down clues — the terminal won't solve the case for you, but it will surface the evidence you need.
/ THE NOTEPAD
Your field notes
Jot down leads, suspicious names, patterns you've spotted. The page is yours.
/ THE ACCUSATION
Name your suspect
One name. No second guesses. The constable is at the door.
NEXT IN THE PILE
The Clockmaker's Last Hour →"A clockmaker found dead. The regulator stopped at 11:17. The missing watch held more than just time."