Seattle Police Department SPD Crime Data
Seattle Police Department SPD Crime Data
By Seattle Police Department
Seattle crime data from 2008 to present
Product type
Dataset
Update frequency
Daily
Updated
Jun 7, 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: SPD_Crime_Data__2008-Present.csv
Key Statistics
Total records
913,705
Missing values
1%
Duplicate rows
0%
Columns
Columns
17
Categorical
6
Numeric
3
Date/time
2
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
Offense ID | numeric | 913,705 | 7624428906 | 26068234872 |
Longitude | numeric | 14,194 | -122.43225 | 0 |
Latitude | numeric | 20,227 | 0 | 47.77484 |
Group A B | categorical | 2 | 1 | 1 |
Crime Against Category | categorical | 4 | 6 | 11 |
Offense Code | categorical | 59 | 3 | 3 |
Precinct | categorical | 7 | 1 | 7 |
Sector | categorical | 26 | 1 | 7 |
Beat | categorical | 55 | 2 | 7 |
Report Number | text | 851,397 | 9 | 11 |
Offense End DateTime | text | 328,916 | 3 | 22 |
Offense Parent Group | text | 32 | 5 | 40 |
Offense | text | 59 | 4 | 43 |
MCPP | text | 59 | 4 | 32 |
100 Block Address | text | 34,517 | 3 | 57 |
Offense Start DateTime | date | 579,483 | 12/13/1908 09:14:00 AM | 07/23/2021 12:59:00 PM |
Report DateTime | date | 803,032 | 01/01/2008 01:00:00 AM | 07/23/2021 12:45:39 PM |