Offense Types based on the Uniform Crime Reporting (UCR) Program by the National Incident-Based Reporting System (NIBRS).
Offense codes and description are from https://ucr.fbi.gov/nibrs/2011/resources/nibrs-offense-codes
The definition of whether a offense type is violent or not was based on https://ucr.fbi.gov/crime-in-the-u.s/2018/crime-in-the-u.s.-2018/topic-pages/violent-crime
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"internal-chattadata/nibrs-offense-types-jibm-c9er\".\"nibrs_offense_types\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
