Sonoma County Sheriff's Office Incident Data
Sheriff’s incident reports are generated after either of two events 1) a citizen has reported an event/crime and a deputy has substantiated that a report is necessary or 2) a deputy has witnessed an event/crime in progress. These incident reports represent a wide spectrum of law enforcement activity from informational reports to serious crime reports. For more information about this dataset please go to the About button and click on the Attachment.
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 \"sonomacounty-ca-gov/sonoma-county-sheriffs-office-incident-data-3rsj-iche\".\"sonoma_county_sheriffs_office_incident_data\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
