JTools: Diving Into Databases

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

    Courts

    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

    Aviation

    Landings

     

    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 *