Skip to content

Double-check environmental data

Many investigative reporters are recreational data users, but data alone cannot be trusted. “You can’t take what is in those databases for granted,” said Kate Golden, a reporter and multimedia producer for WisconsinWatch.org. At the panel “Environmental analyses for any newsroom,” she emphasized the importance of speaking with the lead agency to find out what…

Read More

Getting around PIOs with Web Inspector

By Mayra Cruz @MayraC27 One way to get around bureaucratic hassles is to get the to the data directly by scraping it off the Web. The fight for public records can sometimes be avoided by taking the data directly from websites, Dan Nguyen of ProPublica said. On Saturday, Nguyen led a hands-on class of “Web…

Read More

Hack the Census

By Anna Boiko-Weyrauch@AnnaBoikoW “Hacking the Census” was a collection of lightning talks on tools, tricks and codes to hack the Census and American Community Survey, ranging from introductory to advanced. Steve Doig, professor at Arizona State University, said the Census has information about people and households, of course, but there’s also info on business, education, foreign trade, and more.…

Read More

Excel on steroids: NodeXL and PowerPivot

By Hilary Niles@nilesmedia Excel has two free, plug-ins for Windows users that can dramatically help reporters: NodeXL and PowerPivot. (Sorry Mac devotees, nothing for us.) Tom Torok, CAR editor of The New York Times, and Peter Aldhous, New Scientist’s San Francisco Bureau Chief demoed the two plugins at the 2012 CAR Conference. NodeXL is a network analysis tool compatible…

Read More

Learning to liberate data

By Anna Boiko-Weyrauch@AnnaBoikoW Syntax error. What does this bit of code do? Syntax error. Let’s go back to the source. Syntax error. Maybe try this? After two hours of educated guesses, trial, error and some friendly help, Pam Dempsey, of cu-citizenaccess.org, and I had finally scraped our first bit of text: the word “2011” from a page of…

Read More

From where? Validating data in the real world

By Anna Boiko-Weyrauch@AnnaBoikoW To understand your data, let’s go back to grade-school science class. Remember when you learned about the forest, and all the animals that call it home? The forest is a dynamic ecosystem. Your data is like a chimpanzee; it plays a role in the forest ecosystem.  Over time, the changes in the…

Read More

Getting data from public agencies

By Sarah Morris@smorris198888  In The Art of Requesting and Negotiating Data, David Hunn of the St. Louis Post-Dispatch and Jennifer LaFleur of ProPublica talked through some strategies for getting data. LaFleur began by saying that data can come from inspections, licenses, things that are enforced or purchased. If there was a form, then there would…

Read More

Improving news coverage with data

By Mayra Cruz @MayraC27 News stories can be deepened through data, said speakers in the “Using data journalism to investigate the news” panel.  “News happens fast,” Arizona Daily Star Rob O’Dell reporter said. From tracking crime to finance, incorporating data in journalism goes beyond daily reporting and anecdotal information.  Adding visualizations, numbers and maps allow the public to…

Read More

Avoid data dumps, focus on the story

By Mayra Cruz @MayraC27 News stories should avoid boring readers by not becoming jargon-by-numbers accounts of events, Anthony DeBarros of USA Today said at the “Making sure you tell a story” panel. “Our readers want better,” he said. “We’ve got to make our stories sing.” Ron Nixon of The New York Times said reporters have a…

Read More

Sorting through chaos — analyzing Twitter data

By Anna Boiko-Weyrauch@AnnaBoikoW Tweets are tempting but tricky for data journalists. “Twitter data is probably some of the hardest data you can work with,” Jacob Harris, senior software architect at The New York Times, said at the “Capturing and analyzing Twitter feeds” session. Harris said tweets are hard to collect and analyze, and the tools available at dev.twitter.com are not…

Read More
Scroll To Top