Data and links for Precision Journalism

Excel files - first few weeks

FAA enforcement data

• FAA enforcements 1997-2001(Excel)
• FAA enforcements 1997-2001(Access)
• FAA enforcements 1997-2001(cleaned by R. Gordon)
• FAA site -- includes description of data, searchable database

Fatal Accident Reporting System (NHTSA) data

• State-by-state traffic fatality data 1993-2002 (Excel)
• State Traffic Safety Facts 1993 (PDF)
• State Traffic Safety Facts 1994 (PDF)
• State Traffic Safety Facts 1995 (PDF)
• State Traffic Safety Facts 1996 (PDF)
• State Traffic Safety Facts 1997 (PDF)
• State Traffic Safety Facts 1998 (PDF)
• State Traffic Safety Facts 1999 (PDF)
• State Traffic Safety Facts 2000 (PDF)
• State Traffic Safety Facts 2001 (PDF)
• State Traffic Safety Facts 2002 (PDF)
• Traffic fatality summary over time in MS Word format

Tennessee campaign contributions: tenncand.mdb

Wisconsin hunting accidents: hunting_acc97.mdb

Illinois child support enforcement: ildebtor_access97.mdb

South Florida school report card data: Elemsdata.xls

U.S. Census data

• General Demographic Characteristics: Illinois (Excel)
• General Demographic Characteristics: Illinois (Access)

U.S. Census - links

• "Reporting Census 2000" Web site
  • "Getting Data" page
• Census Web site (www.census.gov)
• SF1 - state by state
  • Illinois
• SF1 - Rankings, comparisons and summaries:
  • Counties by Race
  • States
  • Counties
  • Metropolitan areas
  • Incorporated places of more than 100,000 population
  • Hispanic/Latino origin: regions, divisions, states
  • General Demographic Characteristics by race
  • Population by Age, Sex, Race, and Hispanic or Latino Origin
  • Older Population
  • Male/female ratio
  • Multigenerational households
  • Race & Hispanic origin - U.S.
  • Race & Hispanic origin - various geography
  • LIST OF ALL ranking/comparison/summary data
• Census Briefs (analytical/summary reports prepared by U.S. Census demographers)
• Data lookup (American FactFinder)
• State & county QuickFacts
• Census tract maps (2000)
  • Illinois
• Earlier data:
  • Northwestern Library Government Publications Branch
  • 1990 data can be downloaded here from Census Bureau site (scroll down!)

Dams database: dams.mdb

Contracts database: contract.mdb

Driving database: bradys.mdb

Stories:

• "Young Hunters Account for One Out of Three Deer Hunting Accidents" (Robert Imrie; AP)
• "Half of Snowmobile Victims Were Drunk" (Robert Imrie; AP)
• "A Deadly Difference" (Dave Davis & Elizabeth Marchak; Cleveland Plain Dealer)
• "New Values Off the Mark" (Mark Houser; (Pittsburgh) Tribune-Review)
• "The Body Brokers" (Mark Katches, William Heisel, Ronald Campbell; Orange County Register)
• "High Cost of Hard Time" (Bill Sizemore; The Virginian-Pilot)
• "Restaurant Reservations" (Rick Linsk, Gita Sitaramiah; St. Paul Pioneer Press)
• "Detroit Fire Department: Out of Service" (Melvin Claxton, Charles Hurt; The Detroit News)