NSA's Where's Snowden?

< Satire alert>
A former NSA IT analyst has gone ronin*, sharing the firm's innermost secrets with the outside world and posing a major threat to the agency's credibility with Washington, the public and beyond. If Edward Snowden's leaks keep coming, you can forget the plush Christmas parties, and chances of promotion out of the department.

As the NSA's best analyst-agent it is up to you alone to save the agency from the curse of this ronin agent. Your mission is to ensure that he no longer represents a threat.

Logging in to the Cyber Remote Analyst Portal (CRAP) you can hack flight traffic, track suspects and ultimately guide your own agents onto the same plane as the target. The CRAP has several windows (It is designed to look a lot like Windows 95/ME, the dated feel is deliberate!) which can help you track him down. A bit of detective work is required. In particular, make good use PRISM, a database query interface that allows you search flights and manage a watchlist.
<Satire end>

Gameplay & Dev notes:
You get information and can control your agents via the email app.
Using PRISM is central to the game. The PRISM database allows you to see and even edit fights (within limits!). It understands basic SQL (we wrote a parser for this game!) but if you are rusty with your SQL you can always type HELP" to be annoyed our office assistant. We didn't have time to write all the SQL help, unfortunately. Watch the comments section of this entry for additional SQL hints.
There's a map that shows you the airports (click on the airports) and flights in the air.
The Intel Dossier app gives you an overview of people of interest, including Snowden.

Ways to win:
a) Get one or more of your agents onto the same aircraft as Snowden
b) Use flight manifest hacking (via PRISM) to delete Snowden from the manifest (he's under an Alias!) whilst he's in flight. He'll be detained at the airport he lands at. If it's a friendly airport he'll be arrested and deported back to USA so you win. HOWEVER, if it's a neutral or hostile airport he'll get asylum and you lose, so be careful with this power.

We didn't want to make a game that only lasted ten seconds so we tried to embed the theme inb a way that was fundamental yet subtle. So the game is played out at high speed: TEN SECONDS = TEN MINUTES. Flight times are calculated to be realistic based on the specifications of the aircraft. Exact details like flight plans and embarkation lists is randomly generated. NPCs are based on real life people related to the story (see dossier). A lot of realism has been added, including airport locations, airlines etc. It's not all 100% accurate but it took a lot more research than we bargained for.

The game starts with Snowden and several other characters situated in various major world airports. Snowdon and Assange are travelling under fake identies and heading for a safe haven, which will be an airport in a 'Hostile' country. In an effort to keep you off their trail, they will take circuitous routes. The RV destination, routes and aliases will be different every time you play.

This is a Jam entry by William Edwards (concept, coding) and Wombatica (opinions, artwork, research & content). To be honest it started as a solo entry but Wombatica kept sticking his nose in. We had so many big ideas but we ran out of time.
If you move the windows around (please do!), be careful not to move your mouse too fast.

*Ronin. In ancient Japan a Ronin was a masterless Samurai, ergo an agent who goes freelance.