Icon for Socrata external plugin
Open repository in Console
Updated over 1 year ago
Indexed 4 hours ago

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 ( 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 \
    -H "Content-Type: application/json" \
{"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 

See the Splitgraph documentation for more information.

  • berkeley_pd_stop_data_october_1_2020_present
Upstream Metadata