RCAO Historical Charging Rate

Historical charging rate from 2009-2023, based on data available contemporaneous to the time of collection. Law enforcement refers cases to the Ramsey County Attorney’s Office (RCAO) based on the charge they believe is supported by the evidence they have gathered. These cases are reviewed by RCAO to determine if the charges are supported and appropriate. A charging rate is the percentage of files referred by law enforcement in a specific year that were charged with a crime through the justice system by RCAO.

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 \"ramseycounty-us/rcao-historical-charging-rate-jwym-iqm3\".\"rcao_historical_charging_rate\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.