Dataset logo

Austin Crime Reports

Dataset logo
Dataset logo

Austin Crime Reports

By Austin Police Department

City of Austin crime reports from 2003 to present

Type

Dataset

Update frequency

Weekly

Updated

Oct 11, 2021

Delivery method

Download

Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.

Dataset file name: Crime_Reports.csv

Key Statistics

Total records

2,349,480

Missing values

0.991%

Duplicate rows

0%

Columns

Columns

27

Categorical

7

Numeric

11

Date/time

5

Correlations

Correlations

3

Correlated columns

Y-coordinate and Longitude, Longitude and X-coordinate, Y-coordinate and X-coordinate

Column name

Type

Unique values

Min value

Max value

Highest Offense Code

numeric3911008905

Incident Number

numeric2,349,480200352021500935700

Occurred Time

numeric1,44602400

Report Time

numeric1,44002359

Zip Code

numeric69078759

Council District

numeric10110

Census Tract

numeric5261960100

Y-coordinate

numeric72,305-3262185238895240

X-coordinate

numeric72,305-3262185238895240

Longitude

numeric37,303-99.18163-0.00013356

Latitude

numeric119,4730.0001204542.166645

Family Violence

categorical211

APD Sector

categorical6315

APD District

categorical7515

PRA

categorical75514

Clearance Status

categorical513

UCR Category

categorical1733

Category Description

categorical8318

Highest Offense Description

text431345

Location Type

text47346

Address

text248,0711100

Location

text214,858327

Occurred Date

date6,77301/01/200307/12/2021

Report Date

date6,77501/01/200307/12/2021

Clearance Date

date6,7652003-01-01T00:00:002021-07-18T00:00:00

Occurred Date Time

date1,634,34401/01/2003 01:00:00 AM07/17/2021 12:00:00 PM

Report Date Time

date2,047,96411/29/2002 05:30:00 AM07/18/2021 12:17:00 PM