Created for VCU RAMHacks, a 24-hr hackathon from 12th-13th September 2015.

Tools used: Python, iPython, Pandas, Google Places API for public university addresses (Physical address, latitute/longitude), and Tableau software

Data by the Office of Postsecondary Education, U.S. Department of Education - http://ope.ed.gov/Security/

Data is categorized by
  • University size: number of students
  • University type
    1. Public, 4-yr or above
    2. Private nonprofit, 4-yr or above
    3. Private profit, 4-yr or above
    4. Public, 2-yr
    5. ...
  • State
  • Location of Crime
    1. On-campus
    2. On-campus student residential
    3. Out of campus
    4. Public property
  • Type of Crime
    • Disciplinary offense (alhocol/drugs)
    • Criminal offenses
      1. Murder/Non-negligent manslaughter
      2. Sex offenses - forcible
      3. Sex offenses - non-forcible
      4. Burglary
      5. Aggravated assault
      6. Motor vehicle theft
      7. Robbery
      8. Arson
  • Department (major)

For this analysis, we look at on-campus crimes at public universities (with 4-yr and above curriculum) with greater than 25000 university student size. It will be expanded to other types of crimes and institutions in the future.

Incidence rates (number of crime records/institution size) of respective entities are reported.

Source: http://ope.ed.gov/Security/