Course home page            Syllabus           Resources

 

Journalism 772 and 472: Computer-Assisted Reporting

Philip Merrill College of Journalism

University of Maryland

Fall 2010

 

Student presentation Web sites

and Web sites for issues in the news:

 

Past semesters

 

 

Sample Format For Submitting Your Links:

 

Transportation

 

The U.S. Department of Transportation

www.dot.gov

 

The National Transportation Safety Board

www.ntsb.gov

 

Office of Hazardous Materials Safety

http://hazmat.dot.gov

 

Searchable Database

 

National Highway Traffic Safety Administration

http://www.nhtsa.dot.gov/

 

Downloadable Database

 

The Office of Hazardous Materials Safety

http://hazmat.dot.gov/pubs/inc/hmisframe.htm

 

Story:

 

“Rails Carry a Growing Risk;

With train traffic through the region surging,

a close call after a recent derailment in San Bernardino raises the question:

Are we ready for a real disaster?”

By Phil Pitchford, Ben Goad, David Danelski and Mark Kawar

The Press-Enterprise, San Bernardino, CA

November 20, 2005

http://www.pe.com/digitalextra/metro/trains/inland.html

 

 

 

Sites for Class Discussions:

 

 

Polling

 

Example 1:

http://www.upi.com/Top_News/International/2009/12/04/CNN-Poll-Obama-approval-below-50-percent/UPI-80491259957900/

 

Example 2:

http://latimesblogs.latimes.com/washington/2009/12/sarah-palin-barack-obama-poll-gap-narrows.html

 

Example 3:

http://voices.washingtonpost.com/thefix/most-important-number/the-most-important-number-in-p-74.html?wprss=thefix

 

Example 3: http://www.google.com/hostednews/afp/article/ALeqM5hYmz80PClfDc7XQebN7pu35jj2UQ

 

Pollster.com

http://www.pollster.com/

 

Obama:

http://www.pollster.com/polls/us/jobapproval-obama.php

 

Press release:

http://www.quinnipiac.edu/x1295.xml?ReleaseID=1403

 

 

 

Some final items

 

Annie Dillard, from The Writing Life

http://jclass.umd.edu/cars/secure/stories/DillardWritingLife.pdf

 

Publick Occurrences, Both Forreign and Domestick, 1690

http://jclass.umd.edu/cars/secure/stories/publickoccurrences.pdf

 

Thomas Paine, from Common Sense, 1776

http://jclass.umd.edu/cars/secure/stories/commonsense.pdf

 

 

Hiding in plain sight …

 

Manhole covers / The New York Times

(Multimedia)

http://www.nytimes.com/2007/11/26/nyregion/26manhole.html?_r=1&hp&oref=slogin

 

 

The Patrick Hughes Story

http://www.youtube.com/watch?v=-qTiYA1WiY8&feature=RecentlyWatched&page=1&t=t&f=b

 

 

Mastery in many forms …

 

Shadow puppet

http://jclass.umd.edu/cars/secure/videos/puppet.wmv

 

Four-part fugue

http://www.youtube.com/watch?v=pVadl4ocX0M

 

 

Landing in the Hudson

Video

http://www.youtube.com/watch?v=G9CZivaR0tU

 

Animation with audio

http://www.youtube.com/watch?v=imDFSnklB0k

 

Pilot interview

http://www.cbsnews.com/video/watch/?id=4784012n&tag=main_home_MediaBox

 

 

 

Data Visualization

 

Visual display of data: Examples

http://bit.ly/chinoy_data_viz

 

Charles Joseph Minard (1781-1870)

http://cartographia.files.wordpress.com/2008/05/minard_napoleon.png

 

Challenger: Previous Data

http://jclass.umd.edu/cars/secure/visual/tufte1.pdf

 

Challenger: Data Revised

http://jclass.umd.edu/cars/secure/visual/tufte2.pdf

 

Post: Census National

http://jclass.umd.edu/cars/secure/visual/CensusNational.pdf

 

Post: Census Regional

http://jclass.umd.edu/cars/secure/visual/CensusRegional.pdf

 

“A Day’s Work, Four Day’s Pay”

From New York Times investigation of LI Rail Road Disability Payments

http://www.nytimes.com/interactive/2008/09/19/nyregion/20080920_LIRR_GRAPHIC.html

 

Journalism in the Age of Data

http://datajournalism.stanford.edu/

 

Hans Rosling's 200 Countries, 200 Years, 4 Minutes - The Joy of Stats - BBC Four

http://tv.gawker.com/5701672/watch-a-visualization-of-countries-health-wealth-over-200-years

http://www.youtube.com/watch?v=jbkSRLYSojo&feature=youtu.be

 

 

 

Future of Information Forum

University of Maryland, Nov. 5. 2010

http://ischool.umd.edu/futureinfo/

Keynote speaker: Dan Russell, Google’s “Director of User Happiness” (starts at 16 min 40 sec on video)

http://www.ustream.tv/recorded/10652064

Dan Russell’s blog: SearchReSearch

http://searchresearch1.blogspot.com/

 

Examples of database documentation on the Web

 

Social Security Death Index
http://data.nicar.org/files/active/0/layout.txt

FBI Annual Supplemental Homicide Report - part of the Uniform Crime Reports
http://data.nicar.org/files/active/0/lay_shr.txt

IRS tax exempt organizations
http://data.nicar.org/files/active/0/990layout.txt

consumer product safety commission
http://data.nicar.org/files/active/0/cpsc.pdf

Fatality Analysis reporting System
http://data.nicar.org/files/active/0/FARS_layout_94_08.xls

 

 

Montgomery County -- Senior Abuse:

http://www.montgomerycountymd.gov/hhstmpl.asp?url=/content/hhs/ads/disabilityseniorservices/abusesenior.asp

 

http://www.montgomerycountymd.gov/sentmpl.asp?url=/content/pio/senior/pub.asp

http://www.montgomerycountymd.gov/sentmpl.asp?url=/Content/pio/senior/safety.asp#abuse

http://www.montgomerycountymd.gov/content/hhs/ads/AnnualReports/coa2007annualreport.pdf

http://www.montgomerycountymd.gov/Content/pio/senior/doc/AnnualRp_Summit_11-2009.pdf

 

“D.C. schools dinner program aims to fight childhood hunger”

Bill Turque, Washington Post, October 19, 2010

http://www.washingtonpost.com/wp-dyn/content/article/2010/10/18/AR2010101805040.html?hpid=dynamiclead

 

 

Landing in the Hudson - footage

http://www.youtube.com/watch?v=G9CZivaR0tU

 

Landing animation with audio

http://www.youtube.com/watch?v=imDFSnklB0k

 

 

 

 

Sites for Class Presentations

 

Education, K-12 – Jessica

 

The U.S. Department of Education

www.ed.gov

 

Education Writers Association

www.ewa.org

 

Educational Resources Information Center

www.eric.ed.gov/index.html

 

Education Commission on States

www.ecs.org

 

Public Agenda

http://www.publicagenda.org/citizen/issueguides/education

 

Searchable Database:

 

Florida Department of Education: Discipline against Educator Licenses

http://www.myfloridateacher.com/discipline/summary.aspx

 

 Downloadable Database:

 

2010 Maryland Report Card

http://www.msp.msde.state.md.us/downloadindex.aspx?WDATA=download

 

Story:

 

“Broken Trust: A Herald-Tribune Investigation”

By Chris Davis, Matthew Doig, Tiffany Lankes

The Herald-Tribune, Sarasota, FL

March 18, 2007

 http://www.heraldtribune.com/article/99999999/MULTIMEDIA/100419819

 

 

 

Health Care – Andy

 

Downloadable database

 

Centers for Disease Control and Prevention (CDC) Wonder DATA 2010

http://wonder.cdc.gov/data2010/ftpselec.htm

 

Searchable database

 

World Health Organization's Global Health Observatory (UN)

http://apps.who.int/ghodata/

 

National Center for Health Statistics (CDC):

http://wonder.cdc.gov/data2010/ftpselec.htm

 

National Institutes of Health (DHHS)

http://www.nih.gov/

 

Maryland Department of Health and Mental Hygiene

http://www.dhmh.state.md.us/reports/index.html

 

Medicare's Nursing Home Compare

http://www.medicare.gov/NHCompare/Include/DataSection/Questions/ProximitySearch.asp

 

Center for Medicare and Medicaid Services (DHHS)

http://www.cms.hhs.gov

 

Story:

 

“A Dangerous Place: Assisted Living in Virginia”

By David Fallis

The Washington Post

May 23-26, 2004

http://www.washingtonpost.com/wp-dyn/metro/va/homes/

 

“How This Series Was Reported”

http://www.washingtonpost.com/wp-dyn/articles/A46294-2004May21.html

 

 

 

Transportation - Tolleah

 

The U.S. Department of Transportation

 http://www.dot.gov/

 

The National Transpiration Safety Board

http://www.ntsb.gov/

 

The U.S. Department of Transpiration Pipeline and Hazardous Materials Safety Administration

http://www.phmsa.dot.gov/public

 

The NTSB Accident and Animations

http://www.ntsb.gov/publictn/animations.htm

 

Searchable Database

 

The NTSB Publications

 http://www.ntsb.gov/publictn/P_Acc.htm

 

 

Downloadable Database

 

PHMSA Pipeline Safety Program

http://primis.phmsa.dot.gov/comm/reports/safety/SigPSI.html?nocache=6356

 

Story:

 

Part One: “Spills raise fears about inspection of pipelines”

http://www.freep.com/article/20100926/NEWS06/9260501/Spills-raise-fears-about-inspection-of-pipelines#ixzz10yci4SY3

 

Part Two: “Many live next to dangerous pipelines in Michigan”

http://www.freep.com/article/20100927/NEWS05/9270374/Many-live-next-to-dangerous-pipelines-in-Michigan

 

By Tina Lam

The Detroit Free Press

September 26-27, 2010

 

 

World of the Disadvantaged –  Maite

 

The U.S. Environmental Protection Agency

www.epa.gov

 

Office of Environmental Justice, EPA

http://www.epa.gov/compliance/environmentaljustice/index.html

 

The U.S. Department of Housing and Urban Development

www.hud.gov

 

Environmental Justice Resource Center at Clark Atlanta University

http://www.ejrc.cau.edu/

 

Searchable Database

EPA’s “Cleanups in My Community”: a mapping and listing tool that shows sites where pollution is being or has been cleaned up throughout the U.S.

 

http://iaspub.epa.gov/Cleanups/

 

Downloadable Database

EPA’s Comprehensive Environmental Response Compensation, and Liability Information System or CERCLIS, identifies hazardous waste sites across the U.S. (It is also a searchable database.)

http://cfpub.epa.gov/supercpad/cursites/srchsites.cfm

 

Story:

 

“Toxic Traps”

Three-part series published on Oct. 1, 2 & 3, 2000

1st story: “Toxic Neighbors. Residents of projects find common problem: Pollution”

By Craig Flournoy and Randy Lee Loftis

The Dallas Morning News, Dallas, Texas

 

http://jclass.umd.edu/cars/secure/stories/Dallas_Morning_News_Toxic_Traps.mht

 

“How this series was done”

Oct. 1, 2000

The Dallas Morning News, Dallas, Texas

 

“Electronic Mapping and Social Justice Journalism: A Perfect Match”

By Craig Flournoy

This report is part of a series of papers for using maps to promote health equality.

It was commissioned by The Opportunity Agenda in partnership with the Health Policy Institute at the Joint Center for Political and Economical Studies.

June 2009

http://opportunityagenda.org/mapping

 

http://jclass.umd.edu/cars/secure/stories/mapping_flournoy.pdf

 

 

 

Law Encforcement - David

 

Police Unions:

National Association of Police Organizations:

http://www.napo.org/

International Union of Police Associations:

http://www.iupa.org/

 

Office of Chief Medical Examiner:

http://www.dhmh.state.md.us/ocme/

 

Maryland State Police budget links:

http://dbm.maryland.gov/agencies/operbudget/Documents/2011/Proposed/statpol.pdf

http://www.msa.md.gov/msa/mdmanual/23dsp/html/dspb.html

Maryland fy2011 budget

http://dbm.maryland.gov/agencies/operbudget/Documents/2011/FY2011BudgetHighlights.pdf (page 67)

 

Maryland State Police downloadable reports:

http://msp.maryland.gov/

 

Searchable databases

 

FBI UCR Data

http://www2.fbi.gov/ucr/cius2009/index.html

 

Vital Statistics MATCH:

http://www.matchstats.org/cgi-bin/broker.dll?_SERVICE=MDMATCH&_PROGRAM=match.deathsmap.sas

 

Downloadable database

 

Montgomery County police stats

http://www.montgomerycountymd.gov/poltmpl.asp?url=/content/pol/media/crimestats.asp

 

Stories

 

“Dallas police's crime stats omit some car burglaries”

Steve Thompson and Tanya Eiserer

Dallas Morning News

Sept. 6, 2009

http://www.dallasnews.com/sharedcontent/dws/dn/latestnews/stories/090609dnmetunderreporting.477d39f.html

 

“Are Dallas police correctly counting all burglaries?
Steve Thompson and Tanya Eiserer

Dallas Morning News

Oct. 25, 2009

http://www.dallasnews.com/sharedcontent/dws/dn/latestnews/stories/102509dnmetundercount.3f5a19b.html

 

“Dallas undercount of assaults builds 'artificial image'”

Steve Thompson and Tanya Eiserer

Dallas Morning News

Dec. 15, 2009

http://www.dallasnews.com/sharedcontent/dws/dn/latestnews/stories/121509dnmetcrimestats.4122364.html

 

 

 

Nonprofit and Religious Organizations - Holly

 

The Foundation Center

www.foundationcenter.org

 

The Urban Institute

http://www.urban.org/nonprofits/index.cfm

 

IRS: Tax Information for Charities

http://www.irs.gov/charities/index.html?navmenu=menu1

 

Searchable Databases:

 

GuideStar

www.guidestar.org

 

Better Business Bureau: Charity Page

www.give.org

 

Secretary of State: Maryland Charities Database

http://www.sos.state.md.us/Charity/SearchCharity.aspx

 

Downloadable Database:

 

IRS Master File Data: Tax Exempt Organizations (by state)

http://www.irs.gov/taxstats/charitablestats/article/0,,id=97186,00.html

 

Story:

“Perfectly Legal”

By Robert Anglen

The Arizona Republic, Phoenix, AZ

May 3, 2009

 

Day 1

Follow the donations: Charities kept most cash for themselves

http://www.azcentral.com/news/articles/2009/05/03/20090503charities-transfers0503.html

 

Day 2

Follow the cash: Charities spent most of it on salaries, expenses

http://www.azcentral.com/news/articles/2009/05/04/20090504charities-day2-container.html

 

Day 3

Questions raised on Phoenix ministry funds

http://www.azcentral.com/news/articles/2009/05/05/20090505charities-cfc0505.html

 

Day 4

Disclosure rules keep donors, IRS in dark

http://www.azcentral.com/news/articles/2009/05/06/20090506charities-day4-container.html

 

 

 

 

Executive Branch - Kerry

 
Archive of Government Websites
http://govinfo.library.unt.edu/default.htm
 
U.S. Government Daily Journal
http://www.federalregister.gov/
 
CIA electronic reading room
http://www.foia.cia.gov/default.asp
 
Searchable database:
 
U.S. Government Recovery Act
http://www.recovery.gov
 
Downloadable data:
 
Federal Procurement data system
https://www.fpds.gov/fpdsng/index.php/archives/18-data-archives
 
Story:
 
“Crime and Injustice”
Philadelphia Inquirer 
Series by Donald L. Barlett and James B. Steele,
with assistance in computer analysis from Philip Meyer
[Link to 1973 reprint]

 

 

 

Financial Institutions and Insurance – Laura

 

Federal Deposit Insurance Corporation (FDIC)

www.dot.gov

 

Consumer Action Website (State Insurance Regulators)

http://www.consumeraction.gov/insurance.shtml

 

Securities and Exchange Commission (SEC)

www.sec.gov

 

Searchable Database

 

New York Worker's Compensation Employer Coverage

http://www.wcb.state.ny.us/icpocinq/icpocsearch.jsp

 

Downloadable Database

 

North Carolina Department of Insurance (Complaint Ratios)

http://www.ncdoi.com/Consumer/consumer_ratios.asp

 

Story:

“Lenders Abandoning Foreclosed Properties;

‘Walkaway’ properties quickly deteriorate, dragging down borrowers and neighborhoods”

By Casey Spivak (Contributions by Ben Poston)

Milwaukee Wisconsin Journal Sentinel

July 11, 2009

http://www.jsonline.com/watchdog/watchdogreports/50548282.html

 

 

 

For-Profit Businesses, Part A (Companies and Workplaces) -- Steve

 

Occupational Safety and Health Administration

www.osha.gov

 

Small Business Administration

www.sba.gov

 

Equal Employment Opportunity Commission

www.eeoc.gov

 

National Labor Relations Board

http://www.nlrb.gov

 

Searchable Database:

 

New York State, Division of Corporations, Corporation/Business Entity Database

http://www.dos.state.ny.us/corps/index.html

 

Downloadable Database:

 

Bureau Labor of Statistics

http://www.bls.gov

 

Story:

 

“In reporting pay, firms can err big;

Figures on executives off by up to $500,000”

and related stories

By Todd Wallack

The Boston Globe, Boston, Mass.

October 3-11, 2010

https://docs.google.com/document/pub?id=1Ys-unvMk54kSslnsMC47du6kcQhSPydddPQVMY9SaDA

 

 

 

Licensed Professionals - Allie

 

The Council on Licensure Enforcement and Regulation

http://www.clearhq.org/

 

The Federation of State Medical Boards

http://www.fsmb.org/

 

DLLR's Division of Occupational and Professional Licensing

http://www.dllr.maryland.gov/license/

 

Maryland Attorney Grievance Commission

http://www.courts.state.md.us/attygrievance/overview.html

 

Maryland Board of Physicians

http://www.mbp.state.md.us/pages/whatis.html

 

Searchable Database

 

Maryland’s Division of Occupational and Professional Licensing Search

http://www.dllr.maryland.gov/pq/

 

Maryland Board of Nursing Web Lookup

http://209.60.234.65/mdbon_weblookup/

 

Downloadable Database

 

Colorado Division of Registrations, Registrations Online Services

Licensee Database Request

https://www.doradls.state.co.us/lic_database_req.php

 

Story

 

“When Caregivers Harm: America’s Unwatched Nurses”

By Charles Ornstein and Tracey Weber

ProPublica and the Los Angeles Times

Oct. 4, 2008-July 19,2010

http://www.propublica.org/series/nurses

 

 

 

Utilities/Energy - Madhu

Center for Disease Control & Prevention
http://www.cdc.gov/nceh/lead/

Maryland Public Service Commission
http://webapp.psc.state.md.us/Intranet/home.cfm

Environmental Protection Agency
http://www.epa.gov

Searchable Database

Scorecard
http://www.scorecard.org

Downloadable Database

CDC State Surveillance Data
http://www.cdc.gov/nceh/lead/data/state.htm

 

Story:

“Lead Levels in Water Misrepresented Across U.S.:

Utilities Manipulate or Withhold Test Results to Ward Off Regulators”
By Carol Leonning
The Washington Post
October 5, 2004
http://www.washingtonpost.com/wp-dyn/articles/A7094-2004Oct4.html

Series Archive:

http://www.washingtonpost.com/wp-dyn/metro/specials/water/archive/

 

 

 

Legislative Branch – Maggie

 

U.S. House and Senate

www.house.gov, www.senate.gov

 

THOMAS: The Library of Congress

http://thomas.loc.gov

 

National Congress of State Legislatures

www.nscl.org

 

Maryland Department of Assessments and Taxation

http://sdatcert3.resiusa.org/rp_rewrite/index.aspx?county=16

  

Center for Public Integrity

http://www.publicintegrity.org/

 

National Institute for Money in State Politics

www.followthemoney.org

 

General Assembly: How a Bill Becomes a Law (Maryland)

http://www.msa.md.gov/msa/mdmanual/07leg/html/proc.html

 

 Searchable Database

 

Center for Responsive Politics

www.opensecrets.org

  

Downloadable Database

 

Federal Election Commission

http://www.fec.gov/DisclosureSearch/mapHSApp.do?election_yr=2010

 

Story:

 

“How Legislators Turned a Perk Into Profit”

By Brian Joseph

The Orange County Register, Santa Ana, CA

February 18, 2010

http://articles.ocregister.com/2010-02-18/politics/24638020_1_tax-deductions-legislators-in-other-states-lawmakers

 

 

Environment – Cathy

 

U.S. Environmental Protection Agency

http://epa.gov/

 

U.S. Government Accountability Office

(reports on environmental protection)

http://www.gao.gov

 

Society of Environmental Journalists (watchdog tipsheet)

http://www.sej.org/publications/watchdog-tipsheet/overview

 

Searchable Databases

 

EPA Comprehensive Environmental Response, Compensation, and Liability

Information System (CERCLIS) Database (Superfund sites)

http://www.epa.gov/enviro/html/cerclis/cerclis_query.html

 

EPA’s “TRI Explorer”

(provides access to the Toxics Release Inventory data)

http://www.epa.gov/triexplorer/introduction.htm

 

Downloadable Databases

 

Maryland Sewer Overflow Database (downloadable Excel files)

http://www.mde.state.md.us/programs/Water/OverFlow/Pages/ReportedSewerOverflow.aspx

 

National Response Center

http://www.nrc.uscg.mil/download.html

 

Story:

 

 “Underfoot, Out of Reach”

Daniel Gilbert

Bristol Herald Courier

December 6-13, 2009

http://www2.tricities.com/special_section/mineral/

 

 

 

Judicial System - Stephanie

 

The American Bar Association

www.abanet.org

 

FindLaw.com

http://www.findlaw.com/

 

The Federal Bureau of Prisons

http://www.bop.gov/index.jsp

 

Searchable Database

 

Federal Judiciary Center

Biographical Directory of Federal Judges

http://www.fjc.gov/history/home.nsf/page/judges.html

 

Downloadable Database

 

Bureau of Labor Statistics

Database of Juvenile Felony Defendants in Criminal Courts

http://bjs.ojp.usdoj.gov/index.cfm?ty=dcdetail&iid=403

 

Story

 

“Aging Justice”

By Tisha Thompson

WTTG-Fox 5, Washington, D.C.

March 5, 2009

http://www.myfoxdc.com/subindex/news/aging_judges

 

 

 

 

Real Estate - Bethany

 

NETRonline

http://publicrecords.netronline.com/

 

ForeclosureListings.com

http://www.foreclosurelistings.com/list/MD/

 

FindLaw

http://www.findlaw.com/10fedgov/judicial/bankruptcy_courts.html

 

Searchable database:

 

Maryland Department of Assessment and Taxation

http://sdatcert3.resiusa.org/rp_rewrite/results.aspx?County=02&SearchType=STREET&StreetNumber=%&StreetName=Baltimore

 

Downloadable database:

Housing and Urban Development

 http://www.hud.gov/offices/hsg/mfh/exp/mfhdiscl.cfm

 

Story:

 

"Tosa Bank Lost Gamble on Shaky Loan Deals”

Cary Spivak

Milwaukee Journal Sentinel

Oct. 24, 2009

http://www.jsonline.com/watchdog/watchdogreports/65918057.html