Course home page            Syllabus           Resources

 

Journalism 772 and 472: Computer-Assisted Reporting

Philip Merrill College of Journalism

University of Maryland

Spring 2012

 

Student presentation websites

& websites 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:

 

 

Recent Data Projects from CNS and Maryland Newsline

 

“State Archives' Budget Struggles Leaves Tattered Treasures,”

By Steve Kilar, Capital News Service

April 28, 2011

 

“Arson, Then Foreclosures, Burn Indian Head Home Owners,”

By Steve Kilar, Capital News Service,

April 15, 2011

Detail: “Blacks in Maryland who bought homes between 2004 and 2006 were more than twice as likely to receive subprime rates for their first mortgage as whites with the same income, according to data collected by the federal government and analyzed by Capital News Service.”

 

 “More Than 1,500 Homicides Grow Cold in Prince George's County,”

By Andy Marso, Capital News Service, May 4, 2011

 

“Maryland on Track to Comply with Federal Juvenile Detention Rules,”

By Maggie Clark, Capital News Service, April 29, 2011

 

 

High Steel

 

Smithsonian

http://www.sites.si.edu/exhibitions/exhibits/archived_exhibitions/booming/main.htm

 

http://www.sites.si.edu/images/exhibits/Booming%20Out/index.htm

 

NPR

http://www.npr.org/templates/story/story.php?storyId=3048030

 

 

Dead voters, 2012:

 

“S.C. Officials to Investigate 900 Dead 'Voters':

The Attorney General's Office has requested a formal probe into possible voter fraud”

By Jeff Brush, Easley Patch, Jan. 12, 2012

http://easley.patch.com/articles/s-c-officials-to-investigate-900-deceased-voters

(link provided by Carl)

 

 

“Inaccurate, Costly, and Inefficient:

Evidence That America’s Voter Registration System Needs an Upgrade”

The Pew Center on the States

http://www.pewcenteronthestates.org/uploadedFiles/Pew_Upgrading_Voter_Registration.pdf

(link provided by Jason)

Details from this national study include:

More than 1.8 million dead people registered to vote.

About 2.75 million voters registered in more than one state

About 24 million registrations are “no longer valid” or “significantly inaccurate”

 

Interesting data mapping

 

Basketball

http://gizmodo.com/5892424/five-years-of-every-nba-shot-attempt-visualized

 

Corruption and Transparency

 

State Integrity Investigation

http://www.stateintegrity.org/

 

 

Mastery 

 

Landing

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

 

Animation

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

 

Interview

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

 

 

 

Visual display of data for news

 

Examples – historical and current, image and video

http://bit.ly/chinoy_data_viz

 

Charles Joseph Minard (1781-1870)

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

 

Edward Tufte – Principles of Graphical Excellence

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

 

Washington Post 1993 Homicide Series

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

 

Challenger: Previous Data

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

 

Challenger: Data Revised

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

 

Dallas Morning News – School Testing Irregularities

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

 

Miami Herald Hurricane Andrew Coverage

http://jclass.umd.edu/cars/secure/hurricaneandrew.htm

 

Post: Census National

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

 

Post: Census Regional

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

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

 

Journalism in the Age of Data (See Part II)

http://datajournalism.stanford.edu/

 

Data Explored at a Variety of Levels:

2008 Presidential Election

New York Times maps

State results, county results, county shifts

http://elections.nytimes.com/2008/results/president/map.html

 

 

 

 

Final Items:

 

Annie Dillard, from The Writing Life

 

Publick Occurrences, Both Forreign and Domestick, 1690

 

Thomas Paine, from Common Sense, 1776

 

Stories all around: The Patrick Hughes Story

 

Mastery in many forms: Shadow puppets

 

“For Their Own Good”

 

 

Sites for Class Presentations:

 

 

Anna – Environment

 

Environmental Protection Agency

http://www.epa.gov/foia/

 

Society of Environmental Journalists

http://www.sej.org/

 

National Audubon Society

http://www.audubon.org/

 

 

Searchable Database

 

Toxics Release Inventory Database

http://www.epa.gov/tri/

 

 

Downloadable Database

 

EPA Drinking Water Data

http://water.epa.gov/scitech/datait/databases/drink/sdwisfed/pivottables.cfm

 

Story

“TOO YOUNG TO DIE” Three-part series

Part Two: “TOXIC LEGACY:

Babies born in neighborhoods afflicted by pollution -- from smog to pesticides -- are more likely to die before their first birthday.”

 

By Reynolds Holding, Erin McCormick

San Francisco Chronicle, San Francisco, Calif.

October 4, 2004

http://www.sfgate.com/cgi-bin/article.cgi?f=/c/a/2004/10/04/MNG7C92LD61.DTL

 

 

 

 

 

Caitlin – Health Care

 

American Medical Writers Association

http://www.reportingonhealth.org/

 

National Institutes of Health

http://health.nih.gov/

 

The Association of Health Care Journalists

http://www.healthjournalism.org/

 

Searchable database

 

The Data Bank, National Practitioner Healthcare Integrity and Protection

http://www.npdb-hipdb.hrsa.gov/

 

Downloadable database

 

Centers for Disease Control and Prevention

http://www.cdc.gov/

 

Story

 

“Prime Healthcare's treatment of rare ailments stands out”

California Watch, founded by the Center for Investigative Reporting

By Christina Jewett and Stephen K. Doig

October 14, 2011

http://californiawatch.org/health-and-welfare/prime-healthcares-treatment-rare-ailments-stands-out-13021

 

 

 

Carl – Transportation:

 

TranStats

http://www.transtats.bts.gov

 

Federal Transit Authority

http://www.fta.dot.gov

 

WMATA Audit Reports

http://www.wmata.com/about_metro/inspector_general/audit_reports.cfm

 

Searchable database:

 

National Transportation Safety Board Accident Reports

http://www.ntsb.gov/investigations/reports.html

 

Downloadable database:

 

National Transit Database

http://www.ntdprogram.gov/ntdprogram/data.htm

 

Story:

 

"D.C. transit agency often slow to act on safety recommendations."

By Joe Stephens and Lena H. Sun

The Washington Post, Washington, D.C.

December 26, 2009.

http://www.washingtonpost.com/wp-dyn/content/article/2009/12/25/AR2009122501882.html

 

 

Danielle – The Disadvantaged

 

World Bank Group

www.worldbank.org

 

Health and Human Services

www.hhs.gov

 

The Journalism Center on Children and Families

www.journalismcenter.org

 

Searchable Database

 

American Fact Finder, US Census Bureau

www.factfinder2.census.gov

 

Downloadable Database

 

Medicaid

www.medicaid.gov

(Database at http://www.medicaid.gov/Medicaid-CHIP-Program-Information/By-Topics/Benefits/Prescription-Drugs/Medicaid-Drug-Rebate-Program-Data)

 

 

Story

 

"Methadone and the Politics of Pain"

Michael J Berens and Ken Armstrong

The Seattle Times, Seattle, WA

December 12, 2011

http://seattletimes.nwsource.com/flatpages/specialreports/methadone/methadoneandthepoliticsofpain.html

 

 

 

 

Kelsey – Education

 

U.S. Department of Education

http://www.ed.gov/

 

Education Writers Association

http://www.ewa.org/site/PageServer

 

Center on Education Policy

http://www.cep-dc.org/

 

 

Searchable Database

 

Elementary/Secondary Information System

http://nces.ed.gov/ccd/elsi/default.aspx?agree=0

 

 

Downloadable Databases

 

State Dropout and Completion Data:

http://nces.ed.gov/ccd/drpcompstatelvl.asp

 

Federal Cost of School Food Program Data:

http://explore.data.gov/Health-and-Nutrition/Federal-Cost-of-School-Food-Program-Data/qbf5-8z5c

 

 

Story:

 

“State ignores teacher licensing violations”

Star Tribune

Minnesota

By Corey Mitchell and Jane Friedmann

April 10, 2011

http://www.startribune.com/local/119537854.html?page=all&prepage=2&c=y#continue

 

 

 

 

 

Chelsea -- Higher Education

 

U.S. Department of Education

http://www.ed.gov/

 

National Center for Education Statistics

http://nces.ed.gov/ipeds/

 

The Chronicle of Higher Education

http://chronicle.com/

 

National Education Writers Association

http://www.ewa.org/

 

 

Searchable Database

 

National Center for Education Statistics

http://nces.ed.gov/ipeds/datacenter/login.aspx

 

 

National Education Writers Association

http://www.ewa.org/site/PageServer?pagename=resources_experts

 

 

Downloadable Database

 

U.S Department of Education

http://ope.ed.gov/accreditation/GetDownloadFile.aspx

 

Story

 

Government Vastly Undercounts Defaults

By Kelly Field

The Chronicle of Higher Education, Washington, D.C.

July 11, 2010

http://chronicle.com/article/Many-More-Students-Are/66223/

 

 

David – Executive Branch

 

Story:

 

Presidential Pardons: Shades of Mercy

Part 1 of 2: Presidential Pardons Heavily Favor Whites

By Dafna Linzer and Jennifer LaFleur ProPublica

co-published with The Washington Post

Dec. 4, 2011

http://www.propublica.org/article/shades-of-mercy-presidential-forgiveness-heavily-favors-whites

 

 

Searchable databases

 

The Federal Register

www.gpoaccess.gov/fr/

 

The Federal Election Commission

http://www.fec.gov/finance/disclosure/disclosure_data_search.shtml

 

Downloadable database:

The Federal Election Commission

http://www.fec.gov/data/

 

State and Local Government on the Net

http://www.statelocalgov.net/

 

Federal Reserve Economic Data

http://research.stlouisfed.org/fred2/

 

Data.gov

https://explore.data.gov/catalog/raw/

 

 

 

Clara – Law Enforcement (Part A)

 

Police Assessment Resource Center

http://www.parc.info/home.chtml

 

Sourcebook of Criminal Justice Statistics

http://www.albany.edu/sourcebook/

 

National Institute of Justice

http://www.nij.gov/

 

Searchable Database

 

U.S. Department of Education’s Campus Safety and Security Data Analysis Cutting Tool

http://www.ope.ed.gov/security/

 

Downloadable Database

 

Bureau of Justice Statistics

http://bjs.ojp.usdoj.gov/content/dtdata.cfm

 

Story:

 

“Deadly Force: When Las Vegas Police Shoot, and Kill,”

By Lawrence Mower, Alan Maimon and Brian Haynes

Las Vegas Review-Journal, Las Vegas, NV

November 27-December 1, 2011

http://www.lvrj.com/news/deadly-force

 

 

 

Sophie – Law Enforcement (Part B)

 

Baltimore City Police Department

www.baltimorepolice.org/about-us/police-department/annual-report

 

 

The Federal Bureau of Investigation

www.fbi.gov/stats-services/publications

.

The Office of Police Complaints, District of Columbia

http://policecomplaints.dc.gov/occr/site/default.asp

.

The State’s Attorney of Baltimore City

www.stattorney.org

 

Searchable databases:

 

Maryland Judiciary Case Search

http://casesearch.courts.state.md.us/inquiry/processDisclaimer.jis

 

Baltimore City Police Department: Crime Map

www.baltimorepolice.org/your-community/crime-map

 

 

Story:

 

"City Rape Statistics, Investigations Draw Concern"

by Justin Fenton

Baltimore Sun.

June 27, 2010

http://www.baltimoresun.com/news/bs-md-ci-rapes-20100519,0,5338041.story

 

 

 

 

Lyndsey – Judicial System (Part A)

 

FindLaw

http://public.findlaw.com/library/state-laws.html

 

Judicial Staff Directory (Congressional Quarterly)

http://library.cqpress.com/jsd/

 

National Center for State Courts

http://www.ncsc.org/

 

Biographical Database of Federal Judges- Federal Judicial Center

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

 

Searchable Database

 

Maryland Judiciary Case Search

http://casesearch.courts.state.md.us/inquiry/inquiry-index.jsp

 

Downloadable Database

 

The Supreme Court Database

http://scdb.wustl.edu/index.php

 

Story:

 

“Aging Justice”

FOX 5, Washington DC

By Tisha Thompson

March 2009

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

 

 

 

Tosin – Judicial System (Part B)

 

National Center for State Courts

www.ncsc.org

 

Maryland Judiciary Circuit Court Locations

http://mdcourts.gov/circuit/directory.html

 

National Institute of Justice

http://www.nij.gov/

 

Searchable Database

 

National Center for State Courts Budget Resource Center

http://www.ncsc.org/Information-and-Resources/Budget-Resource-Center.aspx

 

Downloadable Database

 

Bureau of Justice Statistics Employment and Expenditure

http://bjs.ojp.usdoj.gov/index.cfm?ty=pbdetail&iid=2315

 

Story

 

"Many Courts making financial decisions in private, despite state law that demands openness and public hearings"

By Matt Davis

The Lens Focusing on New Orleans and the Gulf Coast

June 21, 2011

http://thelensnola.org/2011/06/21/new-orleans-judicial-budgets/

 

 

 

 

Kelsi - Charities and Foundations

 

National Center for Charitable Statistics

http://nccs.urban.org/

 

The Foundation Center

http://foundationcenter.org/

 

Searchable Database

 

Foundation Center 990 finder

http://tfcny.fdncenter.org/990s/990search/esearch.php

 

Md. Office of the Secretary of State

http://www.sos.state.md.us/charity/searchcharity.aspx

 

Guidestar

http://www.guidestar.org/

 

Downloadable Database

 

All tax-exempt organizations registered with the IRS

http://apps.irs.gov/app/eos/forwardToPub78Download.do

 

Story:

 

“Some Officers of Charities Steer Assets to Themselves”

By the Globe Spotlight Team:

Reporters Beth Healy, Francie Latour, Sacha Pfeiffer, and Michael Rezendes,

and editor Walter V. Robinson

The Globe, Boston, MA

October 9, 2003

http://www.boston.com/news/nation/articles/2003/10/09/some_officers_of_charities_steer_assets_to_selves/

 

 

 

 

Jason – Energy and Utilities

 

Story:

 

Pepco: A Washington Post Analysis

By Joe Stephens and Mary Pat Flaherty

Washington Post Staff Writers

Sunday, December 5, 2010

http://www.washingtonpost.com/wp-srv/metro/pepco/index.html

 

 

Federal Regulators and Sources of Info

 

National Association of Regulatory Utility Commissioners

www.naruc.org

 

United States Energy Information Administration

www.eia.gov

 

EIA Summary Data for Excel Download

http://www.eia.gov/electricity/data.cfm#summary

 

Federal Energy Regulatory Commission

www.ferc.gov

 

Local Regulators

 

Maryland Public Service Commission

http://webapp.psc.state.md.us/Intranet/home.cfm

 

D.C. Public Service Commission

http://www.dcpsc.org/

 

Local Advocate Groups

 

Maryland Office of People’s Counsel

http://www.opc.state.md.us/

 

D.C. Office of People’s Counsel

http://www.opc-dc.gov/

 

Lobbying/Influence/Deregulation

 

Center for Responsive Politics Deregulation Overview

http://www.opensecrets.org/news/issues/electricity/index.php

 

Center for Responsive Politics Contributions Database

http://www.opensecrets.org/industries/summary.php?cycle=2012&ind=E08

 

 

 

Aisha – Business

 

U.S. Securities and Exchange Commission

www.sec.gov

 

Morningstar Document Research

SEC Filing: www.10kwizard.com

 

 

Reynolds Center for Business Journalism

www.businessjournalism.org

 

Searchable Database

 

Occupational Health and Safety Administration: http://www.osha.gov/pls/imis/establishment.html

 

U.S. Securities and Exchange Commission: http://www.sec.gov/edgar/searchedgar/webusers.htm

 

Downloadable Database

 

United States Census Bureau

http://www.census.gov/econ/sbo/

 

Story:

 

“The Cruelest Cuts: The human cost of bringing poultry to your table”

By Kerry Hall, Ames Alexander, and Franco Ordonez

The Charlotte Observer, Charlotte, North Carolina

Feb. 10, 2008

http://www.charlotteobserver.com/poultry/

http://www.charlotteobserver.com/2008/09/30/223415/the-cruelest-cuts.html

 

 

Maria Pia – Financial Institutions

 

National Credit Union Administration

http://www.ncua.gov/Pages/default.aspx

 

The Office of the Comptroller of the Currency

http://www.helpwithmybank.gov/

http://www.occ.treas.gov/

 

Conference of State Banks Supervisor

http://www.csbs.org/Pages/default.aspx

 

Federal Housing Finance Agency

http://www.fhfa.gov

 

Federal Financial Institutions Examination Council

http://www.ffiec.gov/

 

 

Searchable Database

 

FFIEC Central Data Repository

https://cdr.ffiec.gov/public/ManageFacsimiles.aspx?ReportType=289

 

FDIC Federal Deposit Insurance Cor. Failed Financial Institution Contact Search http://www2.fdic.gov/drrip/cs/index.asp

 

Downloadable Database

 

http://www.treasury.gov/initiatives/financial-stability/briefing-room/reports/tarp-transactions/Pages/default.aspx

 

 

Story

 

On-going Investigation: Foreclosure Crisis Banks and Government Fail Homeowners

“The Great American Foreclosure Story:

The Struggle for Justice and a Place to Call Home”

by Paul Kiel

ProPublica, New York, NY

April 10, 2012, 3 a.m.

http://www.propublica.org/article/the-great-american-foreclosure-story-the-struggle-for-justice-and-a-place-t

 

 

 

 

 

 

 

Jack – Real Estate

 

Fannie Mae

http://www.fanniemae.com/portal/research-and-analysis/index.html?

 

U.S Department Housing and Urban Development

http://portal.hud.gov/hudportal/HUD

 

RealtyTrac

http://www.realtytrac.com/trendcenter/

 

Searchable Database

 

Maryland Department of Assessments & Taxation

http://sdatcert3.resiusa.org/rp_rewrite/

 

Downloadable Database

 

Federal Housing Finance Agency- FHFA

http://www.fhfa.gov/Default.aspx?Page=87

 

Story

 

“Weak Insurers Put Millions of Floridians at Risk” (Series)

By Paige St. John

Sarasota Herald Tribune, Sunday, March 14, 2010

www.heraldtribune.com/floridainsurance