A full dataset of CrimeWatch data. The Oakland Police Department provides crime data to the public through the City of Oakland's Crime Watch web site. This site presents the data in a geographic format, which allows users of the information to produce maps and/or reports. The file that you are about to electronically download, copy, or otherwise retrieve by other means is a tabular representation of the same data without maps or reporting capabilities. Be advised that the exact address of each crime has been substituted with the block address to protect the privacy of the victim. Please note: This Crime data are captured from reports filed with the police Department. There may be delays in data due to data processing, incident reporting or maybe technical in nature. Please allow up to 90 days from the end of each month for the data to be completely processed. For example, if you want to retrieve the full data set for the month of March, you will need to generate your report on or after June 30th. (A full 90 days after March 31st)
This dataset has the following 9 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| CrimeType | crimetype | text | BURG - AUTO STOLEN VEHICLE PETTY THEFT VANDALISM DOMESTIC VIOLENCE view top 100 |
| DateTime | datetime | calendar_date | 2004-01-01T00:00:00.000 2007-08-01T00:00:00.000 2006-08-01T00:00:00.000 2010-01-01T00:00:00.000 2007-01-01T00:00:00.000 view top 100 |
| CaseNumber | casenumber | text | 13-000001 22-028426 22-010076 19-043015 22-011728 view top 100 |
| Description | description | text | VEHICLE THEFT - AUTO BURGLARY-AUTO THEFT VANDALISM BURGLARY-FORCIBLE ENTRY view top 100 |
| PoliceBeat | policebeat | text | 04X 08X 19X 23X 34X view top 100 |
| Address | address | text | 455 7TH ST UNK 7000 COLISEUM WY UNKNOWN 2651 73RD AV view top 100 |
| City | city | text | Oakland view top 100 |
| State | state | text | CA view top 100 |
| Location | location | point | {"coordinates":[-122.27248,37.804828],"type":"Point"} {"coordinates":[-122.275068994,37.799400998],"type":"Point"} {"coordinates":[-122.201306989,37.751257987],"type":"Point"} {"coordinates":[-122.174599095,37.767716318],"type":"Point"} {"coordinates":[-122.223908958,37.769720008],"type":"Point"} view top 100 |