Ghost in the SQL Data
A call reported a school fire 14 minutes before the first witness saw it. Find out who made it, in SQL, by exploring a year of Paris emergency calls.
Oct 29, 2026
About
Here is a case. Use SQL to search a year of calls to the Paris Emergency Switchboard. Find who called 14 minutes before the first witness saw the school on fire.
Use SQL to explore the data, filter it and join the tables. The first cases teach you the basics, and the later ones only give you the question.
Use an investigator’s board to pin your results, their charts and your notes, then connect the clues to solve the case.
Every case takes place in Paris: a school fire, a metro ticket with no name, or even a crown stolen from the Musée d’Orsay!Videos
Screenshots
Achievements
38 achievements
System requirements
Windows
Minimum OS: Windows 10 (64-bit) Processor: Dual Core 2,0 GHz (Intel Core i3) Memory: 4 GB RAM Graphics: Intel HD Graphics 4000 (support WebGL / DirectX 11) Storage: 1 GB available space Recommended OS: Windows 10/11 (64-bit) Processor: Quad Core 2,5 GHz or more Memory: 8 GB RAM Graphics: GPU (Intel Iris Xe / AMD Vega 8) Storage: 1 GB available space
macOS
Minimum OS: macOS 11 Processor: Apple M1 or Intel Core i5 Memory: 4 GB RAM Recommended OS: macOS 11+ Processor: Apple M1 or Intel Core i5 Memory: 8 GB RAM
Tags
SimulationStrategySingle-playerSteam AchievementsFull controller supportSteam WorkshopAdjustable Text SizeCamera ComfortColor AlternativesCustom Volume Controls#category_playable_at_your_own_pacePlayable without Timed InputDualShock Controller SupportDualSense Controller SupportSave AnytimeSubtitle OptionsSteam CloudStatsIncludes level editorFamily Sharing