Tipsheets

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 rescntr@ire.org for questions.

Search results for "joining" ...

  • Csvkit, a command-line tool for reporters Github 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. https://github.com/utdata/csvkit-nicar2018

    Tags: database; dataset; csvkit; merge; joining

    By Christian McDonald

    2018

  • Beyond 1M rows: Using and joining large datasets in Excel

    The old restriction of 1 million rows in Excel no longer applies. Get and Transform in Office 2016 allows you to connect to large data sources, query them and even merge tables straight from your spreadsheet. This data and files help you look at visualizing this data in Excel with Pivot Charts. https://www.dropbox.com/s/r68wwih83o27suk/Microsoft%20session%20files.zip?dl=0

    Tags: datasets; joining; excel

    By Leo Zhao; Callie Neylan; Joseph Chirilov

    2018

  • QGIS II: Manipulating, editing and analyzing geographic data

    Dive even deeper into data mapping in this continuation of QGIS I. This guide will cover joining data tables to maps, aggregating point data for easier analysis and preparing geographic data for display online. http://akanik.github.io/mapping-2017/

    Tags: data; qgis; tables; maps; analysis; geographic

    By Alexandra Kanik

    2017

  • Joining with SQL

    Learn how to join tables, matching information from one file to another. We'll use SQLite and the Firefox SQLite Manager.

    Tags: SQLite; SQL; Firefox; tables

    By Andrea Fuller

    2016

  • What IRE can do for you?

    Why is joining IRE such a great idea? Turn to this tipsheet for a list of all the things an IRE membership will give you access to.

    Tags: perks

    By IRE Staff

    2014

  • Mapping 2: Manipulating and editing geographic data with QGIS

    "In this class we'll explore some useful QGIS data processing functions, including joining tables of data to existing shapefiles, simplifying geographic features so that online maps will render quickly, and how to save data in formats commonly used for web mapping. We'll also learn how to edit geographic data, and how to process data consisting of hundreds or thousands of closely spaced or overlapping points to give a more meaninful summary display." Check out the rest of Peter's tipsheet that's attached.

    Tags:

    By Peter Aldhous

    2014

  • Mapping 2: Manipulating geographical data with QGIS

    In addition to displaying geographic data, QGIS is a powerful tool for processing data for use by other mapping applications. If you want to make online maps, using tools including TileMile and Leaflet, for instance, QGIS can help get your data into the right shape. In this class, we'll explore some useful QGIS data processing functions, including joining tables of data to existing shapeflies, simplifying geographic features so that online maps will render quickly, and how to save data in formats commonly used for web mapping. We'll also learn how to edit geographic data, and how to process data consisting of hundreds or thousands of closely spaced or overlapping points to give a more meaning summary display.

    Tags: geographical data; qgis;

    By Peter Aldhous

    2014

  • Tracking sex offenders: How to find the ones who have dropped off the radar screen

    This tipsheet is a good guide to finding missing sex offenders in your state. The author suggests using your state's Internet registry and joining it to the Department of Corrections inmate database in Access to see which inmates were recently released but are unaccounted for.

    Tags: sex offenders; Megan's Law; prison; crime; Microsoft Access; criminal justice

    By Paul D'Ambrosio

    2006

  • Sex offenders in long-term care facilities

    This tipsheet explains how the Tulsa World matched a nursing home database with one of sex offenders and found that 18 registered sex offenders were living in nursing homes. Branstetter offers advice for the actual data analysis, such as how to clean and standardize the data, as well as advice about the shoe-leather reporting aspect of the story. Finally, Branstetter suggests some online resources that are helpful for covering this topic.

    Tags: sex offenders; matching; joining databases; Medicare; retirement; assisted-living

    By Ziva Branstetter

    2005

  • A Few Clues and Rules for Finding Hidden Data

    Suggestions on how to find hidden electronic databases include cultivating sources among applied social researchers, joining the Association of Public Data users, searching the General Accounting Office audits, and using the Federal Database Finder CD-ROM.

    Tags: BBS; CAR; Internet

    By Brant Houston

    1995