Baselight

Municipal Court Caseload Information FY 2024

City of Austin

@usgov.city_of_austin_municipal_court_caseload_information_fy_2024

Loading...
Loading...

About this Dataset

Municipal Court Caseload Information FY 2024

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: 2023-11-25T10:43:15.913232
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_2024.table_1
  • 1.79 MB
  • 225508 rows
  • 14 columns
Loading...

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
);

Share link

Anyone who has the link will be able to view this.