Category Archives: Nerd

First meetings with Google Fusion Tables

For our coverage of the 2013 Colorado general election, I employed mapping lessons learned during my attendance at the ONA13 conference. I used data from the Secretary of State to create four Fusion Table maps used on TV and online.

The first two maps showed turnout results for the mail-in ballots submitted before the actual opening of the polls on Nov. 5, 2013.

The first colors each Colorado county on a scale between blue and red, indicating which party has had a greater overall turnout.

The second shows, in solid colors, which party has had a greater percentage of their registered members vote.

Marshall Zelinger used simplified versions of these two maps in his presentation during the 5pm news on election day. See that video on TheDenverChannel.

The second pair of maps were built for display on our website and in our app. They indicate the approval or rejection of two statewide initiatives: Proposition AA – taxes on recreational marijuana; Amendment 66 – education funding changes and taxes. See those on TheDenverChannel’s 2013 election page.

All of the information I used to learn this tool is available in this summary of the session I attended during ONA:

Tagged , , , , , , ,

‘Asymmetry’ of transparency: journalism in the age of surveillance

“There is an asymmetry at the moment of how the government can access our information” but isn’t immediately transparent to journalists, attorney Naboha Syed observed during a keynote panel on the third and final day of ONA13.

Her succinct observation came on the tail end of an hour long discussion centered around the Edward Snowden case and the age of government surveillance. 

It began, as It would eventually end, with Guardian US editor-in-chief Janine Gibson fielding questions about the high profile and massive story. She explained in broad strokes how Snowden made contact with the newspaper, how he wanted to reveal himself as the source and had a respectful approach to the judgement of his chosen outlet in the fourth estate. 

In exchange, Gibson said, the Guardian took several steps to protect their private communications. Firstly, she said, reporters were sent to communicate with Snowden face-to-face because that is always the most secure method. She said it took a great deal of trust to send them to Hong Kong and not want them to provide updates to the home office, which would ruin the security plans.

When they did communicate, she said, they used secured disposable chatrooms.

Micah Lee, Staff Technologist for the Electronic Frontier Foundation, observed that encryption was also used in the initial email contact with Snowden. It is a trend he observed was growing as organizations try to learn good habits that will protect them if an important source does come up.

“What we do on the internet and what we say on the phone is like an open book,” Lee answers, adding good security habits close the book at least partially.

Nabiha seemed to agree, saying the proposed federal shield law won’t protect the kind of national security information leaked by Snnowden. She added, “I don’t know what (law) can.”

“Technological solutions are really key because we don’t have anything else,” she said.

The result? The panel concluded we are at the beginning of a new era, and suggested investing in the security and infrastructure to be prepared for the future. Having in-house counsel and basic security protocols were recommended.

Precautions aside, Gibson said the Guardian staff was not under a pretense that security would continue after publication began. After the first story, she said, everyone would know there was a leak. The second would prove it was a big leak and the third, she said, would make the government begin to investigate very quickly.

The Snowden NSA documents story is not over, as Gibson revealed. They are still exploring the information in the leak and preparing more stories.

“We have a ton of stuff still to do. We’re not stopping,” she said.


–Phil Tenser, KMGH

Tagged , , , , , , , , , , ,

Nate Silver keynote -quick blog

Quick notes, top 4 quotes IMHO from Nate Silver’s awesome keynote lunch speech:

“Too often the respiration of a statistic shuts down the critical thinking from a reporter”

“Just as they ask good questions of their sources, journalists should ask good questions of the data”

“You can train research techniques and writing skill, but do you have that critical thinking ability?”

“In the online news space, it’s all about differentiation and not about volume”

What were your favorites?




— Phil Tenser, KMGH

Tagged , , , , , , , ,