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.