As of January, 2017, this JTools unit is not being updated, but much of the information is still accurate.
Students: Use the links for either option
Option 1: Students learn on their own by watching the video and doing the exercises
This video takes awhile to download; if it doesn’t use the link below. Video updated 1/16
video link: http://youtu.be/F5ituU3M5TI
Option 2: Students learn in the classroom, with the professor
Journalists Use Databases
To enhance your stories
- example: Boston Globe using TRAC data
To find stories in the data
- example: Raleigh ABC 11
To provide data interactively for readers
Reminders about data
- Who compiled it?
- Why was it compiled?
- How was it compiled?
- Where did the data come from?
- What is the data (content)?
- and remember, mistakes are common in databases
a. Political Campaign Data
NYOpenGovernment from Attorney General
Ways to find more about donors
- Phone database Whitepages.com
- Search engine Google
- Media search Syracuse Newspapers at SU Libraries
- Linked In
- NYS charities database charitiesnys.com
- Non-profits database Guidestar
b. Property Tax Records
NYOpen Government same as above # 2 from Attorney General
Open Book New York for state contracts from Comptroller
Edgar – search SEC filings by publicy-traded companies (on stock exchange)
Tips from financial reporter Diana Henriques, about best documents:
- 10-K, which is the annual report, includes executive salaries
- 10- Q covering business operations, property, finances, pending suits, officers, general background
- 8-K, designating significant changes such as a sale, new management, a lawsuit, court judgment or fine
Charities and non-profits
•Fed gov’t: IRS
•State gov’t: NYS
4. Criminal Justice
local criminal courts not available
Onondaga Supreme Court – trial court for civil cases (not highest court in the state)
Sex Offenders Registry
- tail N-numbers
questions? contact Professor Fought and put JTools in the subject line