About this Dataset

Municipal Court Caseload Information FY 2022

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.
Organization: City of Austin
Last updated: 2021-10-15T21:09:51.380007
Tags: cases, city-government, city-of-austin, city-ordinance, court, criminal-municipal, municipal-court, ordinance, parking, tickets, traffic, traffic-tickets, violation

Tables

Table 1

@usgov.city_of_austin_municipal_court_caseload_information_fy_2022.table_1

1.4 MB
146,221 rows
14 columns

CREATE TABLE table_1 (
  "offense_case_type" VARCHAR,
  "offense_date" TIMESTAMP,
  "offense_time" VARCHAR,
  "violation_charge_code" VARCHAR,
  "offense_charge_description" VARCHAR,
  "offense_street_name" VARCHAR,
  "offense_cross_street" VARCHAR,
  "school_zone" BOOLEAN,
  "construction_zone" BOOLEAN,
  "case_closed" VARCHAR,
  "race" VARCHAR,
  "defendant_gender" VARCHAR,
  "agency" VARCHAR,
  "officer_code" VARCHAR
);