Course home page            Syllabus           Resources

 

Journalism 772 and 472: Computer-Assisted Reporting

Philip Merrill College of Journalism

University of Maryland

Fall 2003

 

 

Class Web sites:

 

 

From class discussions:

 

General Accounting Office Reports

www.gao.gov

 

IGnet – Federal inspectors general

www.ignet.gov

 

Yahoo links:  Government waste and fraud

http://dir.yahoo.com/Government/U_S__Government/Politics/Political_Issues/Government_Fraud_and_Waste/

 

 

Tamara – Executive branch

 

FirstGov: Federal Executive Branch

http://www.firstgov.gov/Agencies/Federal/Executive.shtml

 

Council for Excellence in Governmentt

www.excelgov.org

 

Bureau of Labor Statistics

www.bls.gov

 

Fedworld.gov – government info site

http://www.fedworld.gov/

 

A journalist’s database of databases

http://www.drewsullivan.com/database.html

 

Story:

“Vacations perk costly to county; Taxpayers spend thousands to pay for unused time off “

By Charles Levin, Ventura County Star, August 31, 2003

Levin used computer assisted reporting to see how much

government officials were being paid for unused vacation time.

http://www.insidevc.com/vcs/county_news/article/0,1375,VCS_226_2223810,00.html

 

 

 

Lidija – Legislative branch

 

Center for Responsive Politics

http://opensecrets.org

 

General Accounting Office

www.gao.gov

 

National Institute for Computer-Assisted Reporting Database Library

http://www.ire.org/datalibrary/databases/index.html

 

Congressional Budget Office

www.cbo.gov

 

National Conference of State Legislatures

http://ncsl.org

 

Story:

“Justices Split on Campaign Finance”

Charles Lane, The Washington Post, September 9, 2003

http://www.washingtonpost.com/wp-dyn/articles/A41880-2003Sep8.html

 

“McConnell v. FEC: Soft Money's Role”

OpenSecrets.org

http://opensecrets.org/news/McConnell/supremecourt.asp

 

Profile: Senator Mitch McConnell

OpenSecrets.org

http://www.opensecrets.org/politicians/summary.asp?cucle=2004&cid=N00003389

 

 

 

Stephanie – Legislative branch

 

IRE's Campaign Finance Information Center

http://www.campaignfinance.org/

 

Legislative Branch Resources on GPO Access

http://www.gpoaccess.gov/legislative.html

 

Center for Responsive Politics

http://www.opensecrets.org/

 

Downloadable Databases:

 

Center for Public Integrity's Buying of the President

2004 Document Warehouse

http://www.stateprojects.org/dtaweb/bop2004/default.aspx?section=DOCWHSE

 

FEC Campaign Finance Reports and Data

http://www.fec.gov/finance_reports.html

 

Reporting Project:

 

"Broken Trust, Part I, Guardian"

The Sedalia Democrat, Sedalia, MO

 http://www.sedaliademocrat.com/News/278644823561522.htm

 

 

 

Daysi – Executive branch

 

Library of Congress – Official US Executive Branch Web Sites

http://www.loc.gov/global/executive/fed.html

 

United States Department of Health and Human Services

National Institutes of Health Ethics Program

http://ethics.od.nih.gov/

 

Management/Budget – US Department of Housing and Urban Development

http://www.hud.gov/offices/cfo/reports/cforept.cfm

 

U.S. Department of Labor

Occupation Safety & Health Administration

http://www.osha.gov/pls/publications/pubindex.list

 

US Department of Homeland Security

Fiscal Year 2002 Yearbook of Immigration Statistics

http://www.bcis.gov/graphics/shared/aboutus/statistics/TEMP02yrbk/Temp2002list.htm

 

Story

 

“Study: Top teachers pick up lighter assignments,”

Dallas Morning News, August 12, 2003

A study by Joshua Benton found that less experienced teachers

were assigned to work in poor areas.

http://www.dallasnews.com/latestnews/stories/081003dnmettpi.c5c1c.html

 

 

 

Zenitha – Education

 

IRE Resource Center

www.ire.org/resourcecenter

 

Education Writers’ Association

www.ewa.org

 

U.S. Department of Education

www.ed.gov

www.ed.gov/stats.html

 

Educational Resources Information Center (ERIC)

www.eric.ed.gov/index.html

 

Public Agenda

 (put together by Barbara White Stack of the Pittsburgh Post-Gazette)

www.publicagenda.org

 

National Federation of Teachers

www.nft.org

 

Downloadable Databases

 

National Center for Education Statistics

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

 

2001 Maryland School Performance Report Card:

http://www.msp.msde.state.md.us/rawdata/index.asp

 

Stories

 

“Lessons of change,”

   Lucy Hood, San Antonio Express-News, Aug. 17, 2003  

http://news.mysanantonio.com/story.cfm?xla=saen&xlb=320&xlc=1041035&xld=320

 

“School bosses in Oakland wine, dine and live it up on taxpayers' dime,”

L.L. Brasier, Detroit Free Press, Aug. 22, 2003

http://www.freep.com/news/education/ois22_20030822.htm

 

 

Stacy – Law enforcement

 

Officer.com

www.officer.com

 

Links to police agencies

www.pimacc.pima.edu/dps/police.htm

www.pima.edu/dps/police.htm

www.pima.edu/dps/

www.pima.edu

 

National Tactical Officers Association

www.ntoa.org

 

Crime on campus

www.ope.ed.gov/security

 

Commission on Accreditation for Law Enforcement Agencies

www.calea.org

 

Federal Law Enforcement Training Center

www.ustreas.gov/fletc

 

National Youth Gang Center

www.iir.com/nygc

 

 

 

Joe – Law enforcement

 

Diana K. Sugg on Covering a Beat/Cops

http://legacy.poynter.org/centerpiece/100801.htm

 

Guide for Covering Cops Beat

http://www.justicejournalism.org/crimeguide/

 

Downloadable Databases:

 

US Dept of Justice Statistics

http://www.ojp.usdoj.gov/bjs/welcome.html

 

FBI Uniform Crime Reports

http://www.fbi.gov/ucr/ucr.htm

 

Federal Justice Statistics Resource Center

http://fjsrc.urban.org/index.cfm

 

National Archive of Criminal Justice Data

http://www.icpsr.umich.edu/NACJD/index.html

 

Reporting Projects:

 

“D.C. Police Lead Nation in Shootings”

Washington Post

http://www.pulitzer.org/year/1999/public-service/works/day1/

 

“Cops tap database to harass, intimidate”

Detroit Free Press

http://www.freep.com/news/mich/lein31_20010731.htm

 

 

 

 

Nikolai – Financial institutions

 

FDIC database source

http://www.fdic.gov/bank/

 

Office of Thrift Supervision (savings and loans)

http://www.ots.treas.gov/

 

The National Credit Union Administration

http://www.ncua.gov/

 

The Securities Investor Protection Corporation (SIPC)

http://www.sipc.org/index.html

 

Federal Reserve System

http://www.federalreserve.gov/banknreg.htm

 

Federal Deposit Insurance Corporation

http://www.fdic.gov

 

Office of the Comptroller of the Currency (OCC

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

 

The Federal Reserve Board's National Information Center of Banking Information

http://www.ffiec.gov/nic/default.htm

 

Federal Deposit Insurance Corporation (FDIC) Institution Directory

http://www.fdic.gov/bank/index.html

 

US Securities and Exchange Commission

http://www.sec.gov/

 

SEC Edgar Database

http://www.sec.gov/edgar.shtml

 

SEC - specialists that have databases

http://www.sec.gov/info.shtml

 

SEC info on specialists

http://www.sec.gov/info.shtml

Accountants -  http://www.sec.gov/info/accountants.shtml

Broker-Dealers -  http://www.sec.gov/divisions/marketreg.shtml

Funds & Advisers  - http://www.sec.gov/info/advisers.shtml

 

Graham Leach-Bliley Act – 1999 –

http://www.keytlaw.com/Links/glbact.htm

Community Reinvestment Act

 

Securities Exchange Act of 1934

http://www.law.uc.edu/CCL/34Act/index.html

 

General Rules and Regulations under the Securities Exchange Act of 1934

http://www.law.uc.edu/CCL/34Act/index.html

 

American Banker (subscription required for some info) - http://www.americanbanker.com/index.html

 

Securities Lawyer's Deskbook – additional info on Securities  http://www.law.uc.edu/CCL/sldtoc.html

 

The Motley Fool –

http://www.fool.com/index.htm

 

The House Committee on Financial Services

http://financialservices.house.gov/

 

Freddie Mac

http://www.freddiemac.com/corporate/about/

 

Example:

SEC investigating Freddie Mac for possible fraud http://reuters.com/financeNewsArticle.jhtml?type=governmentFilingsNews&storyID=3533050

 

 

Jon – Judicial system

 

Prince George’s County government site

http://www.goprincegeorgescounty.com/

 

U.S. Supreme Court database

http://www.supremecourtus.gov/

 

Maryland sex offender registry

http://www.dpscs.state.md.us/sor/sor_listings/pdf_cat.pdf

 

More for Supreme Court research

http://www.fedworld.gov/supcourt/

 

 

Lisa – Environment

 

U.S. Environmental Protection Agency

http://www.epa.gov/

 

Enivrofacts Data Warehouse

http://www.epa.gov/enviro/index_java.html

 

EnviroMapper

http://www.epa.gov/enviro/html/em/index.html

 

 

National Library of Medicine - Toxicology and Environmental Health

http://sis.nlm.nih.gov/Tox/ToxMain.html

 

TOXNET

http://toxnet.nlm.nih.gov/

 

 

U.S. Fish and Wildlife Service

http://www.fws.gov/

 

United Nations Environment Programme

http://www.unep.org/

 

Society of Environmental Journalists

http://www.sej.org/

 

Stories:

 

“State of Denial” - A special report on the environment

The Sacramento Bee & Sacbee.com

http://www.sacbee.com/static/live/news/projects/denial/index.html

 

The Nature Conservancy - A special report series

The Washington Post

http://www.washingtonpost.com/wp-dyn/nation/specials/natureconservancy/

 

 

 

Hongmei – Professionals

 

Maryland’s Division of Occupational and Professional Licensing

http://www.dllr.state.md.us/license/occprof/

 

Pacific Information Resources

http://pac-info.com

 

Link to Lists of state boards of Health

http://www.zeal.com/category/preview.jhtml?cid=10026680

 

Professional Associations:

 

American Bar Association

www.abanet.org

 

Maryland Board of Nursing

www.mbon.org

 

American Medical Association

http://www.ama-assn.org

 

Databases:

 

The national practitioner databank

http://www.ire.org/datalibrary/databases/npd/

 

Federation of State Medical Boards

www.fsmb.org

 

U.S. Department of Labor Statistics:

http://www.bls.gov/oes/home.htm

 

Reporting Project:

 

“Va. Doctor's Misconduct Left Trail of Broken Lives: Medical System Failed To Protect Patients”

The Washington Post, Sept. 28, 2003

http://www.washingtonpost.com/wp-dyn/articles/A10967-2003Sep27.html

 

“A Broken Marriage and a 'Life Destroyed’ ”

The Washington Post, Sept. 28, 2003

http://www.washingtonpost.com/wp-dyn/articles/A10929-2003Sep27.html

 

 

Tricia – The disadvantaged

 

U.S. Census Bureau's Poverty Section

http://www.census.gov/hhes/www/poverty.html

 

Food Stamp Program Data

http://www.fns.usda.gov/pd/fspmain.htm

 

Kid's Count Data Book

http://www.aecf.org/kidscount/databook/

 

The Annie E. Casey Foundation

http://www.aecf.org/

 

Social Security Administration

http://www.ssa.gov/

 

Welfare Information Network

http://www.financeprojectinfo.org/win/

 

U.S. Health and Human Services Department

www.hhs.gov

 

National Agricultural Library Welfare Reform Page

http://www.nal.usda.gov/ric/ruralres/welfare.htm

 

 

Story:

 

Washington Post Series On Child Welfare System:

by Sari Horwitz, Scott Higham and Sarah Cohen

http://www.pulitzer.org/year/2002/investigative-reporting/works/

 

 

Christina – Nonprofits

 

American Institute of Philanthropy

www.charitywatch.org

 

BBB Wise Giving

Alliance  www.give.org

 

National Committee for Responsible Philanthropy

www.ncrp.org

 

Maryland Association of Nonprofit Organizations

http://www.mdnonprofit.org/INDEX.htm

 

Internal Revenue Service

www.irs.gov

 

National Center for Nonprofit Boards

www.ncnb.org

 

Evangelical Council for Financial Accountability 

www.ecfa.org

 

Databases:

 

GuideStar-The National Database of Nonprofit Organizations

www.guidestar.org

 

Maryland Charities Database

http://www.sos.state.md.us/sos/charity/html/search.html

 

The Foundation Center 

www.fdncenter.org

 

Story:

Handout:  Washington Post stories

 on National Capital United Way's spending practices

 by Jacqueline Salmon and Peter Whoriskey

May-October, 2002

 

 

Alex – Health care

 

American Hospital Directory

www.ahd.com

 

Department of Health and Human Services

www.hhs.gov

 

National Library of Medicine

www.nlm.nih.gov

 

Databases

 

Medicare

Nursing Homes

www.medicare.gov/Download/DownloadDB.asp

 

Centers for Medicare & Medicaid Services

Per-visit Cost Limits Dataset

www.cms.hhs.gov/data/download/default.asp

 

National Center for Health Statistics

Mortality, Multiple Cause-of-Death Public-Use Data Files

www.ire.org/datalibrary/databases/health/

 

Articles

 

“Deadly Consequences: Ohio's broken mental retardation system”

Dayton Daily News, Dayton, Ohio

February, 2002

www.daytondailynews.com/project/content/project/mrdd/mrdd_index.html

 

 

 

Roland – Insurance

 

National Association of Insurance Commissioners

http://www.naic.org

 

Maryland Insurance Administration

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

 

Coalition Against Insurance Fraud

http://www.insurancefraud.org

 

Story:

 

Florida's Insurance Crisis: Malpractice Insurance”

“Boy's case illustrates malpractice crisis”

Palm Beach Post, Palm Beach, Florida

June 15, 2003

http://www.palmbeachpost.com/business/content/business/insurance_byrd_061503.html

 

 

Josh – Financial institutions

 

FDIC

http://www.fdic.gov

 

National Credit Union Administration

  http://www.ncua.gov

 

Securities and Exchange Commission

  www.sec.gov

 

"Questions of Conflict Sting Mutual Funds"

Diana B. Henriques, The New York Times,  August 7, 1994

http://web.lexis-nexis.com/universe/document?_m=203eafdf3c39b6613fdcd6cf15d206b7&_docnum=1&wchp=dGLbVlz-zSkVb&_md5=93b196d5d5e235147ba2860cd106a3e8

 

 

Jennifer – Utilities

 

Energy Information Administration, Dept of Energy

http://www.eia.doe.gov

 

National Association of Regulatory Utility Commissioners

http://www.naruc.org

 

Blackout- CA Energy Crisis

http://www.pbs.org/wgbh/pages/frontline/shows/blackout

 

General Accounting Office (GAO)

http://www.gao.gov

 

Nuclear Regulatory Commission

http://www.nrc.gov

 

Association of State Drinking Water Administrators

http://www.asdwa.org/state.html

 

Environmental Protection Agency’s (EPA) Water Quality Reports

http://www.epa.gov/safewater/dwinfo.htm

 

Federal Communications Commission

http://www.fcc.gov

 

 

Databases:

 

Electricity Database Files (EIA, Dept of Energy)

http://www.eia.doe.gov/cneaf/electricity/page/data.html

 

Electric Quarterly Reports (Federal Energy Regulatory Commission)

http://www.ferc.gov/docs-filing/eqr.asp

 

Story:

 

“Utilities Held Down Spending on the Upkeep.” 

The Washington Post, Oct. 17, 2003

http://www.washingtonpost.com/wp-dyn/articles/A38385-2003Oct16.html?referrer=emailarticle

 

 

 

Rick – Business

 

Hoover’s: The Business Information Authority

www.hoovers.com

 

Society of Business Editors and Writers: Online resources

http://sabew.org/sabewweb.nsf/LinksView/D57CC7170C52F8DE86256B27006894D8

 

Business Wire: Expert Source

http://www.businesswire.com/expertsource/

 

Occupational Safety and Health Administration

Violation database

http://www.osha.gov/oshstats/

 

Reporting Project:

“The Whistle-Blower,”

Virginia Young, The St. Louis Post-Dispatch

http://www.stltoday.com/stltoday/news/stories.nsf/News/St.+Louis+City+%2F+County/8A7FD896094BB32C86256DD8003D107C?OpenDocument&Headline=State+investigates+tax+credits

 

 

 

Charmere – Transportation

 

U.S. Department of Transportation

www.dot.gov

 

National Highway Traffic Safety Administration

www.nhtsa.dot.gov

 

Federal Highway Administration

www.fhwa.dot.gov

 

U.S. Coast Guard

www.uscg.mil

 

Downloadable Databases

 

Bureau of Transportation Statistics

www.transtats.bts.gov

 

Landings.com

www.landings.com

 

Reporting Projects

 

"Cars and trucks in deadly conflict on I-80"

by Kurt Rogahn, The Gazett, Cedar Rapids, Iowa

Tuesday, Nov. 11, 2003

http://www.gazetteonline.com/article.aspx?art_id=69917&cat_id=1

OR

www.gazetteonline.com

 

AND

 

"The Danger Zone"

A special report by KCRG-TV 9 reporter Renee Chou (based on The Gazette story)

Monday, Nov. 10, 2003

http://www.kcrg.com/article.aspx?art_id=70012&cat_id=123

 

 

Deitrich – Real estate

 

Research Property Data Search

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

 

American Society of Home Inspectors

www.ashi.org

 

Federal national Mortgage Association (Fannie Mae)

www.fanniemae.com/

 

Federal Home Loan Mortgage Corp (Freddie Mac)

www.freddiemac.com/

 

Department of Veterans Affairs Home Loan Guaranty Services

www.homeloans.va.gov/

 

Databases

 

Housing and Urban Development

http://www.huduser.org/datasets/pdrdatas.html

 

Urban Land Institute

http://research.uli.org/DK/Data/re_Data_AmRIEst_fst.html

 

Stories:

 

"Huge land swap proposed Idaho Broker Crafts Trade That May Involve Million Acres"

Ken Olsen, Spokesman-Review

March 16, 1999

http://www.westlx.org/assets/spokane07.pdf

 

Faulty tax assessments

Newsday

(referenced on Poynter site)

http://www.poynteronline.org/dg.lts/id.2/aid.1727/column.htm

 

 

Nancy – Environment

 

U.S. Environmental Protection Agency

http://www.epa.gov/

 

Society of Environmental Journalists

http://www.sej.org/

 

National Safety Council's Environmental Health Center

http://www.nsc.org/ehc.htm

 

This is the first in a series of articles published in the Tulsa World

in 2002 about violations of environmental regulations

http://web.lexis-nexis.com/universe/document?_m=0935cadc3ec257117e971e0099214d25&_docnum=65&wchp=dGLbVlz-zSkVb&_md5=3d078bbd3b6cb959364c456014ae93fc

 

 

Ely – The disadvantaged

 

Casey Journalism Center

http://casey.umd.edu/home.nsf

 

U.S. Census

http://www.census.gov

http://www.census.gov/hhes/poverty/povmeas/reports.html

 

The Urban Institute

http://www.urban.org/

 

U.S. Health and Human Services Department (HHS)

http://www.hhs.gov/

 

Stories

 

“Lives Lost:  Losing Hope in Appalachia

The Boston Globe, Nov. 23, 2003,

http://www.boston.com/news/specials/lives_lost/

 

Clergy sexual abuse coverage

The Boston Globe

http://www.boston.com/globe/spotlight/abuse/

 

“Lack of options keeps mentally disturbed youth locked up”

Pittsburgh Post-Gazette, July 15, 2001

http://www.post-gazette.com/headlines/20010715juvenilejp1.asp

 

 

 

Graphics, Charts and Mapping:  Visual Display of Data

 

IRE archive of mapping projects on the Web

http://www.ire.org/extraextra/archives/cat_mapping.html

 

Edward Tufte – graphics guru

http://www.edwardtufte.com/tufte/

 

A classic graphic from 1869:

Charles Joseph Minard’s account of Napoleon’s Russia campaign of 1812-1813

http://www.edwardtufte.com/tufte/minard

 

Story example:

 Florida Today: “NASA never studied debris risks”

http://www.floridatoday.com/columbia/columbiastory2A52178A.htm

 

 

 

Public Opinion

 

The Pew Research Center for the People and the Press

http://people-press.org/

 

Public Agenda

http://www.publicagenda.org/

 

“20 Questions Journalists Should Ask About Poll Results”

by Sheldon R. Gawiser and G. Evans Witt

http://www.publicagenda.org/polling/polling_20q.cfm

 

“Red Flags”

“Public Agenda's Red Flags examines areas of public opinion research

where findings may be misleading, unstable, or easily misinterpreted.”

http://www.publicagenda.org/polling/polling_redflags.cfm

 

PollingReport.com

http://www.pollingreport.com/

 

Gallup

http://www.gallup.com