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 
"}
EOF

See the Splitgraph documentation for more information.