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 "database management" ...
-
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;
-
Free Software: From Spreadsheets to GIS
DeBarros & Fenton provide examples of free software for everything from text editing to office productivity to audio/video/photo editing to database managers & web frameworks.
Tags: free software; spreadsheets; Linux; text editing; Notepad++; Vim; Emacs; jEdit; Open Office; Audacity; Gimp; F-Spot; Open Movie Editor; SQLite; MySQL; PostgreSQL; SQL Server Express; Django; Pylons; Ruby on Rails; Wordpress; Drupal
-
Investigative Breaking News
This tipsheet helps ready a reporter for breaking news stories. It beings with having the right training and tools at hand, and includes ideas for collaboration and engaging the team when the story breaks. Borowski also touches on what to consider when the dust settles - is there a bigger story here; something to develop down the road?
Tags: breaking news; databases; social media; reporting; management; sources
-
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
-
Intro to MySQL
Armendariz and Wynn explain MySQL, a relational database management system, and the benefits of using it. Links included for software downloads.
Tags: MySQL; databases; relational databases; database management
-
Juggling and managing CAR work
This tipsheet gives pointers for covering a beat while still producing investigative, CAR-based stories. There are helpful recommendations for: finding shortcuts; improving efficiency; CAR specific suggestions; and working with your editor.
Tags: computer-assisted reporting; reporting; deadline; databases;
-
From Database to Network
This tipsheet discusses the most effective way of getting data into social network software such as UCINET. "The most convenient, consistent and simplest way to get larger files into UCINET is to first work with a database manager and then create text files that are readable in UCINET. This handout will give a brief introduction to DL files (text files readable in UCINET) including creating, importing and displaying them in UCINET. Please note that this handout assumes reasonable knowledge of UCINET, Microsoft Access or Microsoft FoxPro."
Tags: UCINET; social network; social network analysis; text file; Microsoft; Access; FoxPro
-
Editing the CAR story -- Part 1: Laying the right foundation
Tanfani discusses common mistakes made when editing CAR stories, and how to avoid them.
Tags: editing; CAR reporting; writing; story-telling; database analysis; newsroom management
-
Conceiving the Investigation
The author lists and describes websites that could lead to investigative reports. The websites listed include: municipal advisory councils; costreprotdata.com; FDA warning letters database; professional licensing boards; and government performance reporting.
-
Essential Analysis: Data Integrity Checks
powerpoint presentation that reminds journalists what to check when they get data and shows how to look for dirty data using database managers or SPSS. also mentions extensive data documentation [and clean-up of dirty data] that IRE and NICAR include with the databases available from the Database library.
Tags: data; tables; documentary; file format; record layout; data dictionary; outliers; variations; dirty data; database manager; SPSS;