Washington State Uniform Crime Reporting - Summary Reporting System

Summary Reporting System (SRS) and the National Incident-Based Reporting System (NIBRS) are part of the FBI's Uniform Crime Reporting system. SRS and NIBRS collect data on crime incidents that are reported by law enforcement agencies across the country. Because SRS and NIBRS data are collected differently, they cannot be compared.

SRS has been used since the 1930s to collect national crime data. Washington SRS data is available from 1994 to 2018. Data will no longer be produced from the SRS as of 2018.

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 \"wa-gov/washington-state-uniform-crime-reporting-summary-6njs-53y5\".\"washington_state_uniform_crime_reporting_summary\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.