Title: Tracking down public records
1Tracking down public records
- J. Robert Port
- Investigative Reporter
- New York Daily News
2Your client The reporter
3Reporters lead difficult lives
- Daily deadlines
- Irrascible editors
- Hunting and traveling
- Forced to work by phone
- Demand for accuracy
- Incessant pressure to be creative
4An Interview
Most stories have their beginnings with
5This Story Began With a Government Document
By SANG-HUN CHOECHARLES J. HANLEYand MARTHA
MENDOZAAssociated Press Writers It was a story
no one wanted to hear Early in the Korean War,
villagers said, American soldiers machine-gunned
hundreds of helpless civilians, under a railroad
bridge in the South Korean countryside. When the
families spoke out, seeking redress, they met
only rejection and denial, from the U.S. military
and their own government in Seoul. Now a dozen
ex-GIs have spoken, too, and support their story
with haunting memories from a "forgotten"
war. These American veterans of the Korean War
say that in late July 1950, in the conflict's
first desperate weeks, U.S. troops -- young,
green and scared -- killed a large number of
South Korean refugees, many of them women and
children, trapped beneath a bridge at a place
called No Gun Ri.
6Source National Archives, College Park, Md.
7Why Government Records?
- Records dont lie
- Records dont forget
- Records dont pursue an agenda
- Recorded information creates leads
- Documentary evidence bolsters a story
- Defense against libel lawsuits
8The Candidates Words
9The Official Record
- Also in Archival Records
- Names of State Draft Officials
- Names of Some Local Draft Board Members
- Large Numbers of Local Men Drafted
10The Top Officials Quote
11Tools for Government Records
- The National Archives and Records Administration
(NARA) - Agency reading rooms
- The Federal Freedom of Information Act (FOIA)
- State Freedom of Information or public records
laws - Federal Courts - PACER
12So Many Governments, So Little Time
13So Many Jurisdictions
Federal Court Districts 93
14Sources
- Congressional Quarterlys Washington Information
Directory - Congressional Quarterlys Federal Regulatory
Directory - The Yellow books
- New York Citys Green Book
15(No Transcript)
16The Internet
- E-FOIA slowing taking hold
- Web sites growing daily
- Sophistication steadily increasing
- Many traditionally paper records going
all-electronic - Hybrid vendors evolving
17PACER (Public Access to Court Electronic Records)
http//www.uscourts.gov
18The future actual court records scanned or
created electronically everywhere
19TRAC (Transactional Records Access Clearinghouse)
- 2 million federal employee records
- Justice Dept. case tracking data
- IRS enforcement data
- Judge/prosecutor report cards
20(No Transcript)
21Deeds, liens, etc.
22Uniform Commercial Code filings
23Electronic Data
- Increasingly, most useful government records are
in data form, not paper - Data is better than paper
- Learn to use a spreadsheet
- Better still, learn to use relational database
software
24Government Records and Clothing
- NYS Dept. of Labor enforcement data
- Federal Trade Commission RN data
- Womens Wear Daily
- U.S. Dept. of Labor union data
- OSHA data
25NYS DOL, license and FTC
Microsoft Access
26(No Transcript)
27(No Transcript)
28115
BATF gun tracing data available
29The story
30Licensed nurses aides
Criminal records
31(No Transcript)
32The story
33Public records are the backbone of investigations
At sunrise, Jose Madrid, 11, begins picking red
chilies in New Mexico.
At days end, Jose counts his tickets and
prepares to collect his pay 30.52.
They will be sold for use in Paul Newmans salsa.
His employment is a violation of federal law. The
product of his labor becomes hot goods.
34The Tip Go to certain farms or factories and you
will find children working illegally.
We tested this with a trial run in Ohio using one
reporter and photographer. We found...
We found others and they were all paid for their
labor
35We decide to use a web site to manage
We wanted our web site to...
Let reporters file interview notes and see their
colleagues notes.
Share a library of legal research, news clips and
data.
Share computer files and electronic records in
native form.
Let reporters see photos and artwork as theyre
collected.
36MS Internet Info Server, SQL Server and Lotus
Notes
What we were thinking...
Microsofts web server because it can be set up
fast.
SQL Server to use a big machine to share large
databases with many different programs, including
the web server.
Lotus Notes because it can interconnect with many
systems.
They all work with Windows, allowing easy
interchange of graphics.
37Research assembled to prep reporters
Web material can be pasted with links intact.
Forms can be customized
38Searchable in-house data
Reporters can search DOL case records for child
labor cases, such as they are.
39Web can provide detailed reporting aids.
Staff can assemble lists and tip sheets and post
to the web server.
even maps to obscure places.
40Reporters search for underage workers
and find them.
41and find them.
42and find them.
43and find them.
44Quotes, anecdotes, interviews meshed
Writers everywhere can choose best stuff.
Comment interviews can be documented with a
spreadsheet.
Editors can categorize a mass of material.
45The story moves on the wire
46(No Transcript)
47Finding Mimi
- Chapin School
- Class secretaries
- Miss Porters
- Social Register
- Weddings
- Obituary
- Voter rolls
48Must-have public records data
- State and local payrolls
- Corporate officer registration records
- Criminal court records
- Civil court records
- Property/tax assessment records
- Professional licensing records
- Voter registration records
49Bobs Top 10 Web Sites
- NYS Department of State http//dos.ny.state.us/
- Leadership Library http//ldi.bvdep.com/
- GuideStar http//www.guidestar.org/
- 10K Wizard http//www.tenkwizard.com/
- opensecrets.org http//www.opensecrets.org/
- nexis.com http//www.nexis.com/research/
- NYC Campaign Finance Board http//www.cfb.nyc.ny.u
s/ - Government Printing Office http//www.access.gpo.g
ov/ - TRAC http//trac.syr.edu/
- General Accounting Office http//www.gao.gov/