lacity/arrest-data-from-2010-to-2019-yru6-6re4
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 11 months ago
Indexed 31 minutes ago

Arrest Data from 2010 to 2019

This dataset reflects arrest incidents in the City of Los Angeles from 2010 to 2019. This data is transcribed from original arrest reports that are typed on paper and therefore there may be some inaccuracies within the data. Some location fields with missing data are noted as (0.0000°, 0.0000°). Address fields are only provided to the nearest hundred block in order to maintain privacy. This data is as accurate as the data in the database. Please note questions or concerns in the comments.

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/arrest-data-from-2010-to-2019-yru6-6re4\".\"arrest_data_from_2010_to_2019\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • arrest_data_from_2010_to_2019
     
     
     
     
     
Upstream Metadata