Municipal Court Caseload Information FY 2020

This data is provided to help with analysis of various violations charged throughout the City of Austin.

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

Fields for 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 (Closed Y/N)

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/municipal-court-caseload-information-fy-2020-evsr-c9ts\".\"municipal_court_caseload_information_fy_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.