JTools: Diving Into Databases

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

 Others: BRBSearch Systems

   Open New York

  • NYOpen Government   same as above # 2 from Attorney General

    Open Book New York  for state contracts from Comptroller

    3. Businesses

    Company filings

    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

    •Independent: Guidestar.org and Citizen Audit

    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

          New York State

    Crime Reports

          US Dept of Justice Uniform Crime Reports

    5. Transportation




    questions? contact Professor Fought and put JTools in the subject line



Leave a Reply

Your email address will not be published. Required fields are marked *