Crime by Offense Type and Law Enforcement Agency Data

Dataset showing annual counts, rates and clearance information of reported crime by offense type are categorized by the reporting law enforcement agency.

The Bureau of Criminal Apprehension calculates the crime rates using local estimates of each jurisdiction's resident population.

These population estimates differ from census estimates and result in crime rates different than those reported in the county dataset.

Querying over HTTP

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 \"ramseycounty-us/crime-by-offense-type-and-law-enforcement-agency-7xsh-v4fe\".\"crime_by_offense_type_and_law_enforcement_agency\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.