Investigative

One of our top First Amendment duties is to root out fraud, corruption and waste — among governments, companies, charities and powerful individuals. Learn how to add an investigative edge to all you do.

Getting sources and maintaining them is half the job. Learn how diversifying sources and why it’s important, how to approach the people you need to know on your beat and how to build mutually rewarding connections with sources.

 

Google Trends 301

How to download data from the Google Trends store and create Flourish graphics with it. Also: Tracking midterm election issues and candidates. How can you use Trends during an election?

Skill:

Level:

  • Protected: Google MyMaps 301

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Data visualization: Flourish 201/301

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Scrape-a-palooza and Google Flourish

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Google Finance scraping and other tools for business beats

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Data-scraping websites, PDFs and Flourish

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Environment tools, Part III

    me new tools, such as the Environmental Justice Atlas that documents cases around the world of environmental infractions. We’ll also look at Protected Planet, which tracks conservation measures, and the Wildlife Dashboard.

    Skill:

    Level:

  • Empower your research with Lexis/Nexis

    How to conduct basic research for news stories.

    Skill:

    Level:

  • Tools for investigating non-profit organizations

    A look at tools for tracking non-profit finances, what their CEOs earn and much more. We also spend some time looking at Form 990s of charities and give you a chance to pull some on organizations in your area.

    Skill:

    Level:

  • Build your own reporting robot

    How to use the automation function of Github, a tool for programmers, to create a web scraping bot to automatically gather information and data from the web. Our example will be using it to automate a tedious beat check. No prior coding knowledge needed.

    Skill:

    Level:

  • Protected: Business reporters and editors: Tools for covering companies and industries

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Protected: Google Earth tools for your newsroom

    There is no excerpt because this is a protected post.

    Skill:

    Level:

  • Data-scraping web pages, PDFs and Google Finance

    How to extract data from the web and PDFs and flow them into a spreadsheet. You’ll also learn how to scrape real-time and historical stock data into Google Sheets to track specific companies or industries. Code: data

    Skill:

    Level:

  • Identifying discrimination through data

    Jayme Fraser of the I-Team and Robbie Gutierrez of the DOT will show how to pick out patterns hiding in data sets.

    Skill:

    Level:

  • Master classes for business reporters and editors, Part II

    We will cover Charity Watch, SEC filings, Form 990s on Guidestar, etc. Google Dataset Search, Google Scholar, including ways to analyze case-law. We will learn to scrape Google Finance to isolate stock data and historical stock data. And will finish by learning how to scrape data from business sites and visualize it using Flourish. Code: business

    Skill:

    Level:

  • Master classes for business reporters and editors, Part I

    We cover Charity Watch, SEC filings, Form 990s on Guidestar, etc. Google Dataset Search, Google Scholar, including ways to analyze case-law. We will learn to scrape Google Finance to isolate stock data and historical stock data. And will finish by learning how to scrape data from business sites and visualize it using Flourish. Code: business

    Skill:

    Level:

  • Reporting with Pinpoint

    Learn how to probe through millions of documents, including audio, video, PDFs and more, to find patterns or that proverbial needle in a haystack. You’ll see case studies of how Gannett journalists have used this software to break big investigative stories.

    Skill:

    Level:

  • Using specialized search engines to find sources, data and fact-checks

    Execute deeper, more precise, more sophisticated web searches by harnessing specialized search engines. Diversity your stories, angles, sources and readers.

    Skill:

    Level:

  • Backgrounding a business

    How to search for proxies and tools for covering business, non-profits and the economy overall.

    Skill:

    Level:

  • Secure communications with sources and tipsters

    Tips and traps: Tools such as Signal app, Freedome and VPNs to keep you, your data and your sources safe.

    Skill:

    Level:

  • CSV Match and other fuzzy-matching tools

    Finds matches between two files rather than within one.

    Skill:

    Level:

  • Analyzing batches of PDFs

    Learn tools and techniques for working with data buried in PDF files.

    Skill:

    Level:

  • Basic databases in Google Flourish and other tools

    A few easy tools to help you show your work: Google Flourish, Airtable and Tableizer.

    Skill:

    Level:

  • Advanced fact-checking for reporters

    Fact-checking images, video and verifying facts.

    Skill:

    Level:

  • Google Collaboratory

    Google Colab runs notebooks on a virtual machine that can execute your code, connect to data in the Google cloud, and share with a collaborators.

    Skill:

    Level:

  • The best data on education

    What education data sets out there, and what stories can they help us tell?

    Skill:

    Level:

  • What do you mean, it’s “statistically significant?”

    Advanced math for journalists.

    Skill:

    Level:

  • The best data about inequality

    What are the best datasets out there and what stories can they tell?

    Skill:

    Level:

  • Investigative/data skills series: Data visualization using Infogram

    Data visualization for everyone using InfoGram, an easy but powerful tool available to journalists across Gannett.

    Skill:

    Level:

  • Basic Databases in Google Flourish and other tools

    A few easy tools to help you show your work: Google Flourish, Airtable and Tableizer.

    Skill:

    Level:

  • Investigative/data skills series: Data visualization using DataWrapper

    In part I of our two-part series, “Data visualization for everyone,” we explore DataWrapper — an easy but powerful tool available to journalists across Gannett.

    Skill:

    Level:

  • Google Public Data Explorer

    The Google Public Data Explorer is linked to reliable datasets that can help you build charts in minutes.

    Skill:

    Level:

  • Data scraping with Google Sheets and Tabula

    In this training video and hands-on exercises, you’ll learn how to scrape data tables out of web pages.

    Skill:

    Level:

  • Scraping online databases with Google Sheets

    An accessible way for anyone to quickly capture data that would otherwise require hundreds of hours at the keyboard to query.

    Skill:

    Level:

  • How to pry public records from a reluctant agency

    Government databases are public records, yet most agencies treat records requests for data as something exotic and fraught with challenges. Anticipate the objections and defeat them for the win.

    Skill:

    Level:

  • Hands-on with fast.ai

    Automatically sort text or images with machine-learning. Got too much text to read, or too many images to dig through? Make the computer do it, by teaching by example.

    Skill:

    Level:

  • Unlocking the power of Excel pivot tables

    Slice and dice data to to organize your reporting, find patterns and reveal better stories.

    Skill:

    Level:

  • Data visualization introduction

    Visualizations can help make a complex story simpler. Play with simple data visualization tools, learn how to automatically import data into a map, and explore the elegant templates of Flourish.

    Skill:

    Level:

  • Introduction to using data in your reporting

    An overview of the key data analysis tools and techniques used to produce investigative stories, with examples of stories that were made possible with these tools.

    Skill:

    Level:

  • Backgrounding like a boss: Reporting on people and companies with free tools

    Even great reporters can get tricked by fake names or sketchy backgrounds. We’ll walk through some websites and strategies you can use to create a routine and spot potential red flags before you get burned.

    Skill:

    Level:

  • Advanced Search: Power tools for search, research and analysis

    See what users in your area are searching and discover story ideas on Google Trends. Explore Backlight, an AI tool for parsing massive amounts of documents.

    Skill:

    Level:

  • Verification tools

    Bad information is dangerous, especially in uncertain times. Learn how to verify images and video, investigate social media posts, and identify misinformation with open-source intelligence tools.

    Skill:

    Level:

  • Building a public records mindset

    A discussion on developing a documents state of mind — the key to doing solid watchdog work on a beat.

    Skill:

    Level:

  • Small newsrooms, big ambitions

    Just because your newsroom is small doesn’t mean your goals need to be.

    Skill:

    Level:

  • 9 Tips for Covering Election Misinformation

    Here are concrete, simple steps journalists can take to fight misinformation, avoid confusion and add context.

    Skill:

    Level:

  • Google News Lab training

    Daniel Petty, a certified Google News Lab trainer with the Denver Post, discusses reverse image search, advanced search, maps and Google Fusion tables.

    Skill:

    Level:

  • Advanced backgrounding of people and companies

    From Investigative Reporters and Editors, here’s how to build a deep well of background to inform your reporting and writing.

    Skill:

    Level:

  • Creating data visualizations

    In this quick clip, Maggie Farley discusses how to build visualizations that will engage and build trust with your audience. She demonstrates different tools to build quick data visualizations and animations.

    Skill:

    Level:

  • Reporting on farm bankruptcies in your own backyard

    Using a database created by Sky Chadde, the Gannett Agriculture Data Fellow at the Midwest Center for Investigative Reporting, you’ll be able to localize the impact of these bankruptcies and identify trends in your community.

    Skill:

    Level:

  • Google: Geo and mapping

    Maggie Farley, a former Los Angeles Times foreign correspondent who now works with Google News Initiative, covers Geo and Mapping.

    Skill:

    Level:

  • Google: Verification

    In this webinar, Maggie Farley, a former Los Angeles Times foreign correspondent, discusses verification.

    Skill:

    Level:

  • FOUNDATIONS: Sources are the key

    This session will cover diversifying sources and why it’s important, how to approach the people you need to know on your beat, and how to build mutually rewarding connections with sources.

    Skill:

    Level:

  • What is Storyful and how can you use it?

    A discussion of Storyful and how to put it to use in your newsroom.

    Skill:

    Level:

  • Investigating the internet

    This workshop uses case studies of BuzzFeed News investigations into misinformation and ad fraud, as well as tips and tutorials, to equip journalists with the basic skills they need to incorporate this data into their work.

    Skill:

    Level:

  • Advanced search techniques

    This primer on Google search includes tips for effective image searches.

    Skill:

    Level:

  • Advanced verification tools

    Watchdog training on advanced verification tools, focused on protest examples (exclusive to Gannett journalists through our relationship with Google News Lab).

    Skill:

    Level:

  • Investigative Reporting: From Numbers to Narrative

    Part one in a two-part webinar series will introduce useful sources of data for a variety of beats.

    Skill:

    Level: