Ramsey County Attorney's Office Adult and Youth Referral and Charging Data

This data set includes adult and youth referrals from law enforcement, and charging data from the Ramsey County Attorney's Office.

• Some referred cases are still pending review.

• There may be multiple charges per case, and the lead charge is “Count 1”.

• For adults, data primarily includes felony-level cases. With a few exceptions, misdemeanor and gross misdemeanor cases are prosecuted by city attorney offices.

• For youth, data includes all levels of cases.

• Data is based on the lead alleged violation in the case, both for referrals and petitions. • Age data is based on age at date of incident.

• Race data is based on information provided in the referral and may be updated if we receive new information.

There is a second data set for youth school attendance matters diversion; located here https://data.ramseycounty.us/Public-Safety-and-Justice/RCAO-Youth-SAM-Data/hqh4-qxri

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/ramsey-county-attorneys-office-adult-and-youth-rksi-6vdw\".\"ramsey_county_attorneys_office_adult_and_youth\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.