How Many Database Queries Do NSA Analysts Perform Each Day?

Let our journalists help you make sense of the noise: Subscribe to the Mother Jones Daily newsletter and get a recap of news that matters.


Last night, based on a statement from the NSA’s director of compliance, I wrote that NSA analysts performed about 600,000 database queries per day. This prompted several suggestions on Twitter that perhaps I was unfamiliar with SQL and had no idea how databases work. For example, this one:

@ggreenwald @kdrum select * from news.articles where technical_literacy < 0 limit 600000

Snark aside, this tweet is pointing out that a single query can return many records from a database, so perhaps the NSA’s estimate referred to the total number of records they retrieved, not the actual number of queries they made. Maybe! But according to the New York Times, the NSA guy said “the agency performs about 20 million such queries each month.” Is it possible that he misspoke? Or that the reporter misinterpreted him? Sure. But it doesn’t sound like it. There’s nothing there about the number of records retrieved. He said the agency “performs” 20 million queries per month.

As I mentioned last night, it’s possible that many of these are automated queries for one purpose or another. Actual human beings might perform only a fraction of them. Until there’s some clarification from NSA, though, there’s no particular reason to think that. For now, anyway, it sounds like he’s talking about actual queries from NSA analysts.

DOES IT FEEL LIKE POLITICS IS AT A BREAKING POINT?

Headshot of Editor in Chief of Mother Jones, Clara Jeffery

It sure feels that way to me, and here at Mother Jones, we’ve been thinking a lot about what journalism needs to do differently, and how we can have the biggest impact.

We kept coming back to one word: corruption. Democracy and the rule of law being undermined by those with wealth and power for their own gain. So we're launching an ambitious Mother Jones Corruption Project to do deep, time-intensive reporting on systemic corruption, and asking the MoJo community to help crowdfund it.

We aim to hire, build a team, and give them the time and space needed to understand how we got here and how we might get out. We want to dig into the forces and decisions that have allowed massive conflicts of interest, influence peddling, and win-at-all-costs politics to flourish.

It's unlike anything we've done, and we have seed funding to get started, but we're looking to raise $500,000 from readers by July when we'll be making key budgeting decisions—and the more resources we have by then, the deeper we can dig. If our plan sounds good to you, please help kickstart it with a tax-deductible donation today.

Thanks for reading—whether or not you can pitch in today, or ever, I'm glad you're with us.

Signed by Clara Jeffery

Clara Jeffery, Editor-in-Chief

payment methods

We Recommend

Latest