Downtown Austin Community Court (DACC) FY 2022 Caseload Information

This data is provided to help with analysis of various violations charged throughout the City of Austin's Downtown Community Court.

"Case Status" and "Race" abbreviations go as follows:

Race -

A, Asian

B, Black

BA, Black or African American

CD, Client does not know

CR, Client refused

DNC, Data not calculated

H, Native Hawaiian or Other Pacific Islander

L, Hispanic or Latino

ME, Middle Eastern

MR, Identified Multiple Races

N, Native American or Alaskan

O, Other

U, Unknown

W, White

Case Status - Y = closed || N = Not closed

TERMINATED (TERM) and TERMINATED ADMINISTRATIVELY (TERMA) = Y

ACTIVE (ACT) AND INACTIVE(IN) INACTIVE = N

Active, Inactive, Terminated, Terminated Administratively

Inactive doesn't mean the cases is closed only TERM and TERMA.

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 \"datahub-austintexas-gov/downtown-austin-community-court-dacc-fy-2022-56au-zawf\".\"downtown_austin_community_court_dacc_fy_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.