LAPD RIPA (AB 953) STOP Person Detail from 7/1/2018 to Present

STOP Person Detail is focused on data pertaining to the individual person that is involved in a STOP Incident from 7/1/2018 to Present. This dataset contains data fields mandated by AB 953, The Racial and Identity Profiling Act (RIPA) and other data fields that are collected during a STOP. A "STOP" is any detention by a peace officer of a person or any peace officer interaction with a person.

Click below for more info on AB 953: The Racial and Identity Profiling Act-

https://oag.ca.gov/ab953#:~:text=AB%20953%20mandates%20the%20creation%20of%20the%20Racial,and%20racial%20and%20identity%20sensitivity%20in%20law%20enforcement.

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 \"lacity/lapd-ripa-ab-953-stop-person-detail-from-712018-to-bwdf-y5fe\".\"lapd_ripa_ab_953_stop_person_detail_from_712018_to\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.