If you need to visualize U.S. Census data, unemployment statistics or other datasets quick and with no spreadsheets or coding, give the Google Public Data Explorer a try. The Data Explorer is linked into several official databases, including the census, Bureau of Labor Statistics, Eurostat, the Inter-American Development Bank, World Trade Organization and the International Monetary Fund.
This feature celebrates one of SPJ’s four guiding principals: We are stewards of ethical journalism. Truth took a beating during the past four years, with the previous U.S. president frequently spewing provably false or misleading statements as disinformation overall coursed through social media with ferocious speed.
There are many ways to visualize data from the U.S. Census. Next month, we’ll explore chart-making software to visualize demographic data. But this month we’ll explore how to visualize physical change with Google Earth Engine Timelapse. Earth Engine is a project organized by Google, Carnegie Mellon, the US Geological Survey and NASA.
April 12th, 2021 • Featured, Toolbox, Quill Archives
SPJ Journalist’s Toolbox Tool of the Month: Scraping a .PDF
I loathe .PDFs of public records with the power of a thousand suns. They’re a tease. They’re full of data tables but useless to most data journalists in the .PDF format. And government officials love to share them with us because they know a .PDF
Government websites love to bury data in tables on web pages. Why? It satisfies legal requirements for making document public under sunshine laws, but it renders the data useless. You can’t sort or filter the data to look for trends, do math calculations to find rates and averages, and other things journalists need to find stories.
Reporters hate transcribing notes and they often ask me during newsroom training what tools work best. They want speed and accuracy with the transcriptions, and they want it free (or very cheap). I’ve listed many tools on the Toolbox’s Transcription Tools page, but here are my three favorites for speed, use and cost: Otter.ai:
Editor’s note: This is the first of what will be monthly posts about how to use digital and data tools on Journalist’s Toolbox. Check back each month for new tools, tips and tricks. Google launched its Dataset Search tool in November 2018 to help researchers locate data that is freely available for use.
Victor Hernandez preaches the gospel of newsroom productivity, whether he’s working with his reporters in the Crosscut newsroom in Seattle or training journalists at conferences around the country. Hernandez’s philosophy is simple: Think trends and not tools when finding digital resources that can make you more productive.
June 4th, 2020 • Featured, Quill Blog, Ethics Toolbox
Ethics: Should journalists show the faces of protesters?
Taking photos or video of protesters and people marching or demonstrating in public spaces is a right afforded to journalists under the First Amendment. In the United States people have a right to information. Journalists help fulfill that right to information by responsibly reporting on what is happening in communities across the country.
April 8th, 2020 • Featured, Quill Blog, Code Words, Ethics Toolbox
Ethics: Answering questions about COVID-19 coverage
At the Society of Professional Journalists, we talk a lot about how your ethical standards should not change no matter the medium or type of story you are producing. While covering COVID-19, the same is true: Ethics apply no matter the medium.
Can you show a decrease in your journalism income because of the current pandemic? Freelance journalists nationwide including sole proprietors, independent contractors and the self-employed (for example, S Corporation owners) might now be entitled unemployment benefits in their state. Under the Coronavirus Aid, Relief and Economic Security Act, the provisions of the unemployment program have been expanded to help provide temporary monetary relief for freelance journalists and other workers who illustrate a decrease in income resulting from the effects of the current pandemic virus on business operations.
March 18th, 2020 • Featured, Quill Blog, Toolbox, Quill Archives
Hicks: Groups urge care, precision in coronavirus reporting
Journalists covering the coronavirus have produced compelling, informative stories, but along the way, there have been mischaracterizations, inaccuracies and absent nuances. An ABC News story posted to its website incorrectly implied the terms coronavirus and COVID-19 can be used interchangeably, a common mistake.
The new book The Craft of Science Writing is a curated collection from The Open Notebook, a primary resource for science journalists. It offers a primer on how to report and write about science, including how to read a scientific paper and how to explain complex concepts and processes clearly.
Misinterpreted data and unsubstantiated conclusions plague press and social media. What can journalists do to stop them? Quill asked Rob Pyatt, who has presented workshops focused on teaching critical thinking skills, to chime in on the subject. Pyatt, an assistant professor in the New Jersey Center for Science, Technology and Mathematics at Kean University, is certified in Clinical Molecular Genetics and serves as a director of the Oxy-Gen Laboratory in Norcross, Georgia.
December 13th, 2019 • Featured, Toolbox
Toolbox: What’s to like (and not like) about “likes” leaving Instagram?
Instagram has begun hiding likes. Well, from the public. You, as a user, will still be able to see your own likes once this reaches all accounts, but your followers (and their followers and their friends), won’t be able to see your likes.
As the Society of Professional Journalists celebrates its 110th anniversary in 2019, it may come as a surprise that SPJ did not have its signature Code of Ethics for the group’s first 17 years. In 1909 when the young men at DePauw University founded SPJ as a college fraternity, Sigma Delta Chi, one of their goals was “to advance the standards of the press by fostering a higher ethical code.”