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.