Browse more 5,000 tipsheets from our national conferences and Watchdog Workshops on how to cover specific beats, conduct a great interview and learn countless tips on where to find the information you need.

Logged-in members can download any tipsheet, for free. Contact the Resource Center 573-882-3364 or for questions.

Search results for "open" ...

  • R, RStudio, and the tidyverse for data analysis

    This tutorial is from a class that worked with R, which is a very powerful tool, designed by statisticians for data analysis. Described on its website as “free software environment for statistical computing and graphics,” R is a programming language that opens a world of possibilities for analyzing data. Indeed, just about anything you may want to do with data can be done with R, from web scraping, through statistical analysis and machine learning, to making interactive graphics.

    Tags: r; r studio; tidyverse; statistics; data analysis

    By Peter Aldhous


  • OpenRefine

    These tipsheet and data are from a session that went over how to use OpenRefine for common data cleaning problems, such as parsing and cleaning names and addresses, combining and breaking apart fields and more.

    Tags: cleaning; openrefine

    By Sarah Ryley


  • QGIS I

    QGIS is a powerful and complex piece of software but journalists can get excellent results from a couple of relatively simple functions. It’s useful for data exploration as well as for producing data maps for publication, and it’s open source. These are the full follow-along instructions from the NICAR session with a worked example.

    Tags: qgis; maps

    By Christine Jeavans


  • Buzzfeed's open resources

    An index of all of Buzzfeed's open-source data, analysis, libraries, tools, and guides.

    Tags: buzzfeed; open; resources; index

    By Jeremy Singer-Vine


  • OpenCorporates Tipsheet –the lowdown for investigating using the largest open database of companies in the world

    OpenCorporates is the largest open database of companies in the world, enabling simple, powerful searching of over 137 million companies (and counting). Their data is core infrastructure for journalists, alongside NGOs, governments and businesses working to uncover company information.

    Tags: business; government; search; data

    By Mollie Hanley


  • Maps Made Easy

    At DataMade, a civic technology company in Chicago, we love building, thinking about and learning from digital maps. In this session, we’ll share some of our favorite tools for mapping data, giving emphasis to Derek Eder’s Fusion Tables Searchable Map Template. Open source and easy-to-use, the Fusion Tables Template facilitates the creation of a searchable, filterable map from any spreadsheet or shapefile. We will give a step-by-step overview of the template and demonstrate some of its key features: address search, geolocation, the ability to easily add additional search filters, and hover and popover interactivity for point details.

    Tags: maps; datamade; digital; searchable

    By Regina Compton


  • Buzzfeed open resources

    An index of all Buzzfeed's open-source data, analysis, libraries, tools, and guides. ttps://

    Tags: reproducible; data

    By Jeremy Singer-Vine


  • Csvkit, a command-line tool for reporters repo

    Ever struggled with large data sets? Or need to quickly join or merge data sets without benefit of a database? We will show you how to harness the awesome power of CSVKit to wrangle large datasets on the command line. It's easy to use, fast and powerful. It's a must in every data journalist's tool box. This is good for: People who want a solution for working with multiple​​ CSV files without having to open Excel or to join or merge files without a database.

    Tags: csvkit; command line; command-line; data sets

    By Christian McDonald


  • First Python Notebook

    This textbook will guide you through an investigation of money in politics using data from the California Civic Data Coalition. You will learn just enough of the Python computer programming language to work with the pandas library, a popular open-source tool for analyzing data. The course will teach you how to use pandas to read, filter, join, group, aggregate and rank structured data. You will also learn how to record, remix and republish your analysis using the Jupyter Notebook, a browser-based application for writing code that is emerging as the standard for sharing reproducible research in the sciences.

    Tags: python; notebook; programming; data; analysis; jupyter

    By Ben Welsh; James Gordon; Cheryl Phillips


  • Request for success: FOIA and open records laws

    Learn how to use federal and state open records laws to draft records requests the right way. This slideshow discusses ways to challenge denials and keep a steady flow of information coming into the newsroom with FOI.

    Tags: foi; foia; open records; public records; sunshine

    By Jeremy Rogers