Vehicle and Pedestrian Stop Data 2010 to June 30th, 2018

NOTE: Legislation has increased the types of information collected regarding stops. These changes took effect on July 1, 2018 and are reflected in the data sets LAPD RIPA (AB 953) STOP Incident Details from 7/1/2018 to Present & LAPD RIPA (AB 953) STOP Person Detail from 7/1/2018 to Present.

This data set has been limited to show data from 2010 thru June 30, 2018 which was using the legacy requirements.

This dataset reflects incidents of a vehicle or pedestrian being stopped by the Los Angeles Police Department in the City of Los Angeles dating back to 2010. This data is transcribed from original stop reports that are typed on paper and therefore there may be some inaccuracies within the data. This data is as accurate as the data in the database. Please note questions or concerns in the comments.

This dataset is part of the Police Data Initiative (https://www.policedatainitiative.org/). For questions, contact the dataset owner or leave a comment.

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/vehicle-and-pedestrian-stop-data-2010-to-june-30th-ci25-wgt7\".\"vehicle_and_pedestrian_stop_data_2010_to_june_30th\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.