Berkeley PD - Stop Data (October 1, 2020 - Present)

Berkeley PD transitioned to RIPA stop data collection effective October 1, 2020. Data collected from these stops conforms to requirements set forth in Government Code section 12525.5 that was enacted as a result of AB 953, the Racial and Identity Profiling Act (RIPA) of 2015 (https://oag.ca.gov/ab953). Berkeley PD will begin reporting RIPA data to the CA DOJ effective January 1, 2021.

For more information about any of the column definitions, please download the document: One Page Narrative for Stop Data (October 1, 2020).pdf.

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-stop-data-october-1-2020-present-ysvs-bcge\".\"berkeley_pd_stop_data_october_1_2020_present\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.