Berkeley PD - Data for City Auditor's Report of Police Response (5/11/21) * Updated May 27, 2021

This dataset was provided to the Berkeley City Auditor for the Fiscal Year 2020 report entitled: Data Analysis of the City of Berkeley's Police Response (5/11/21). The data provided herein include calls for service for the years 2015-2019. For a definition of the columns, please refer to the attached document entitled: Auditor's Report (5-11-21) Tabular Data Definitions (Updated May 27, 2021).pdf.

• Updated on May 27, 2021. The initial dataset uploaded was a slightly different version. This May 27 update is the version used for the analysis.

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 \"cityofberkeley-info/berkeley-pd-data-for-city-auditors-report-of-grbw-f5y5\".\"berkeley_pd_data_for_city_auditors_report_of\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.