Municipal Court Caseload Information FY 2013

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id 4gv8-96x2
Name Municipal Court Caseload Information FY 2013
Attribution City of Austin
Category Public Safety
Tags municipal, court, violation
Created 2013-11-14T15:10:37Z
Publication Date 2017-03-15T15:15:14Z

Description

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

Columns

| Included | Schema Type | Field Name                 | Name                       | Data Type     | Render Type   |
| ======== | =========== | ========================== | ========================== | ============= | ============= |
| Yes      | series tag  | offense_case_type          | Offense Case Type          | text          | text          |
| Yes      | time        | offense_date               | Offense Date               | calendar_date | calendar_date |
| No       |             | offense_time               | Offense Time               | number        | text          |
| Yes      | series tag  | offense_charge_description | Offense Charge Description | text          | text          |
| Yes      | series tag  | offense_street_name        | Offense Street Name        | text          | text          |
| Yes      | series tag  | offense_cross_street_name  | Offense Cross Street Name  | text          | text          |
| Yes      | series tag  | school_zone                | School Zone                | text          | text          |
| Yes      | series tag  | construction_zone          | Construction Zone          | text          | text          |
| Yes      | series tag  | case_closed                | Case Closed                | text          | text          |
| Yes      | series tag  | agency_code                | Agency Code                | text          | text          |
| Yes      | series tag  | officer_code               | Officer Code               | text          | number        |

Time Field

Value = offense_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = offense_time

Data Commands

series e:4gv8-96x2 d:2013-03-05T00:00:00.000Z t:officer_code=5924 t:school_zone=N t:offense_case_type=TR t:construction_zone=N t:case_closed=Y t:offense_street_name="1900 BLOCK EAST RIVERSIDE DRIVE" t:agency_code=APD t:offense_charge_description="DRIVING WHILE LICENSE INVALID - SUSPENDED" m:row_number.4gv8-96x2=1

series e:4gv8-96x2 d:2012-10-13T00:00:00.000Z t:officer_code=4523 t:school_zone=N t:offense_case_type=TR t:construction_zone=N t:case_closed=Y t:offense_street_name="2400 BLOCK BARTON SPRINGS" t:agency_code=APD t:offense_charge_description="FAILED TO MAINTAIN FINANCIAL RESPONSIBILITY" m:row_number.4gv8-96x2=2

series e:4gv8-96x2 d:2013-08-20T00:00:00.000Z t:officer_code=783 t:school_zone=N t:offense_case_type=TR t:construction_zone=N t:case_closed=N t:offense_street_name="TEST LOCATION" t:agency_code=APD t:offense_charge_description="DRIVING WHILE LICENSE INVALID - SUSPENDED" m:row_number.4gv8-96x2=3

Meta Commands

metric m:row_number.4gv8-96x2 p:long l:"Row Number"

entity e:4gv8-96x2 l:"Municipal Court Caseload Information FY 2013" t:attribution="City of Austin" t:url=https://data.austintexas.gov/api/views/4gv8-96x2

property e:4gv8-96x2 t:meta.view v:id=4gv8-96x2 v:category="Public Safety" v:attributionLink=http://www.austintexas.gov v:averageRating=0 v:name="Municipal Court Caseload Information FY 2013" v:attribution="City of Austin"

property e:4gv8-96x2 t:meta.view.owner v:id=rjt7-ysrk v:screenName="Jim Warren" v:displayName="Jim Warren"

property e:4gv8-96x2 t:meta.view.tableauthor v:id=rjt7-ysrk v:screenName="Jim Warren" v:roleName=publisher v:displayName="Jim Warren"

Top Records

| offense_case_type | offense_date        | offense_time | offense_charge_description                            | offense_street_name                 | offense_cross_street_name | school_zone | construction_zone | case_closed | agency_code | officer_code | 
| ================= | =================== | ============ | ===================================================== | =================================== | ========================= | =========== | ================= | =========== | =========== | ============ | 
| TR                | 2013-03-05T00:00:00 | 14.07.00     | DRIVING WHILE LICENSE INVALID - SUSPENDED             | 1900 BLOCK EAST RIVERSIDE DRIVE     |                           | N           | N                 | Y           | APD         | 5924         | 
| TR                | 2012-10-13T00:00:00 | 10.05.00     | FAILED TO MAINTAIN FINANCIAL RESPONSIBILITY           | 2400 BLOCK BARTON SPRINGS           |                           | N           | N                 | Y           | APD         | 4523         | 
| TR                | 2013-08-20T00:00:00 | 08.00.00     | DRIVING WHILE LICENSE INVALID - SUSPENDED             | TEST LOCATION                       |                           | N           | N                 | N           | APD         | 783          | 
| CM                | 2012-10-01T00:00:00 | 02.15.00     | THEFT C - LESS THAN $50                               | 9200 BURNET ROAD                    |                           | N           | N                 | Y           | APD         | 7212         | 
| CM                | 2012-10-01T00:00:00 | 00.00.00     | POSSESSION OF DRUG PARAPHERNALIA                      | 7002 BLESSING AVENUE                |                           | N           | N                 | Y           | APD         | 6639         | 
| PK                | 2012-10-01T00:00:00 | 12.37.00     | PARKING - TOW AWAY COMM SERVICE ZONE ( NO MARKINGS)   | 100 E 9TH ST                        |                           | N           | N                 | Y           | PW          | 189          | 
| TR                | 2012-10-01T00:00:00 | 14.41.00     | SPEEDING - SCHOOL ZONE                                | 8100 BLOCK SOUTH 1ST                |                           | N           | N                 | Y           | APD         | 2940         | 
| TR                | 2012-10-01T00:00:00 | 13.30.00     | EXPIRED REGISTRATION                                  | 500 BLOCK WEST BEN WHITE BOULEVARD  |                           | N           | N                 | Y           | APD         | 4566         | 
| TR                | 2012-10-01T00:00:00 | 15.25.00     | FAILED TO MAINTAIN ASSURED CLEAR DISTANCE - COLLISION | NORTHLANE DRIVE AT MOPAC EXPRESSWAY | EXIT RAMP                 | N           | N                 | N           | APD         | 7240         | 
| TR                | 2012-10-01T00:00:00 | 15.25.00     | FAILED TO MAINTAIN FINANCIAL RESPONSIBILITY           | NORTHLAND DRIVE AT MOPAC EXPRESSWAY | EXIT RAMP                 | N           | N                 | N           | APD         | 7240         |