Austin Crime Reports
Product type
Dataset
Update frequency
Weekly
Updated
May 8, 2023
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 are columns within the dataset that have a linear dependency on each other and can be dropped or filtered out when creating models
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 | numeric | 391 | 100 | 8905 |
Incident Number | numeric | 2,349,480 | 20035 | 2021500935700 |
Occurred Time | numeric | 1,446 | 0 | 2400 |
Report Time | numeric | 1,440 | 0 | 2359 |
Zip Code | numeric | 69 | 0 | 78759 |
Council District | numeric | 10 | 1 | 10 |
Census Tract | numeric | 526 | 1 | 960100 |
Y-coordinate | numeric | 72,305 | -32621852 | 38895240 |
X-coordinate | numeric | 72,305 | -32621852 | 38895240 |
Longitude | numeric | 37,303 | -99.18163 | -0.00013356 |
Latitude | numeric | 119,473 | 0.00012045 | 42.166645 |
Family Violence | categorical | 2 | 1 | 1 |
APD Sector | categorical | 63 | 1 | 5 |
APD District | categorical | 75 | 1 | 5 |
PRA | categorical | 755 | 1 | 4 |
Clearance Status | categorical | 5 | 1 | 3 |
UCR Category | categorical | 17 | 3 | 3 |
Category Description | categorical | 8 | 3 | 18 |
Highest Offense Description | text | 431 | 3 | 45 |
Location Type | text | 47 | 3 | 46 |
Address | text | 248,071 | 1 | 100 |
Location | text | 214,858 | 3 | 27 |
Occurred Date | date | 6,773 | 01/01/2003 | 07/12/2021 |
Report Date | date | 6,775 | 01/01/2003 | 07/12/2021 |
Clearance Date | date | 6,765 | 2003-01-01T00:00:00 | 2021-07-18T00:00:00 |
Occurred Date Time | date | 1,634,344 | 01/01/2003 01:00:00 AM | 07/17/2021 12:00:00 PM |
Report Date Time | date | 2,047,964 | 11/29/2002 05:30:00 AM | 07/18/2021 12:17:00 PM |