The IRE Resource Center is a major research library containing more than 23,250 investigative stories — both print and broadcast. Add to that more than 3,000 tipsheets from our national conferences on how to cover specific beats or do specific stories and you have a resource that no reporter or editor should be without. These stories and tipsheets are searchable online or by contacting the Resource Center directly (573-882-3364 or rescntr@ire.org) where a researcher can help you pinpoint what you need. Browse or search the tipsheet section of our library below. Logged-in members can view the tipsheets free online:
Search results for "query" ...
-
The one-query story: Quick hits for your newsroom
Amaze your editors and wow your readers with these quick-hit data story ideas. Learn techniques on how to look for the short-form watchdog and how to juggle it all. Afflict the comfortable by fact-checking their statements, find expert sources and use spreadsheets to inform your next project.
Tags: spreadsheets; query; data; car
-
Data Tables: Step-by-step Basic Instructions
Schnaars gives instructions on how to use the jQuery plug-in "Data Tables" to quickly display searchable and sortable data through content management system.
Tags: jquery; data tables; ssi; json; htm; html; data; sorting;
-
Lightning Talks: NodeXL for Social Network Analysis
NodeXL is a free template for Excel 2007 and 2010 that makes Social Network Analysis easy for anyone familiar with basic spreadsheet functions. NodeXL has been optimized for analyzing online social media-it includes built-in connections to query the APIs of Twitter, Flickrand YouTube, allowing you to draw networks of users and their activity.
Tags: social network analysis; NodeXL; Excel; API; clustering
-
Tweets telling stories; Tweets as data
Marcus explores how twitter can be used to aid in telling stories and collecting data thru the use of tools such as TwitInfo and TweeQL.
Tags: twitter; tweets; SQL; TwitInfo; TweeQL; data; storytelling; structured queries;
-
Data on Deadline
Benincasa's powerpoint lists several strategies for using data on deadline. He includes story examples with an explanation of the data used in each. He also addresses "readiness strategies" and "geek notes" - tips to help manage an utilize the data you've collected.
Tags: data; deadline; beat reporting; mapping; MySQL; queries; database library; database organization
-
Mining the web for data and stories
Mellnik and Dowdell provide a list of searchable government data that can be found online - from statistics to public records and much, much more. They have also included links to data you can download and advanced search strategies to improve your reporting.
Tags: federal data; government data; census; datta queries; search strategieis
-
Essential SQL Queries (To Me, At Least)
For a five minute lightening talk, DeBarros presented on what he considers the five essential SQL queries that everyone should know.
Tags: SQL queries; MySQL; tables; temporary table; CASE expression; ailiasing; join table;
-
Excel/Access User Defined Functions`
Harbord discusses how Visual Basic for Applications can be used to expand the capabilities of Excel and Access. \\\"Based on the original Basic programming language from the early 70’s, this version is built in to all Microsoft Office products and is similar to Visual Basic version 6.0. Each product like Excel has special capabilities in VBA for accessing and manipulating its specific “objects” such as cells and ranges of cells. (Called the Object Model).\\\"
Tags: visual basic; excel; access; object model; VBA; functions; query
-
Using Access 2007
This tipsheet addresses the difference between Access 2003 and Access 2007. "Like all Office 2007 products, Access has introduced the Ribbon, but with Access they didn’t stop there. The new Access is something that takes time to get used to. This handout will serve as a guide to introduce you to Access 2007. Topics covered will include creating databases, importing data, running queries, modifying tables, etc.\\\"
Tags: Access 2003; Access 2007