Sheriff’s incident reports are generated after either of two events 1) a citizen has reported an event/crime and a deputy has substantiated that a report is necessary or 2) a deputy has witnessed an event/crime in progress. These incident reports represent a wide spectrum of law enforcement activity from informational reports to serious crime reports. For more information about this dataset please go to the About button and click on the Attachment. For an interactive map of this data, please visit: http://www.raidsonline.com/?address=4787%20Old%20Redwood%20Hwy%20Santa%20Rosa,%20CA.
This dataset has the following 11 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| id | id | number | Unique identifier | 1205 1270 1271 1272 1555 view top 100 |
| agency code | agency_code | text | Agency code of agency that wrote the incident report. | SCSD WIP SOP SRP WIP view top 100 |
| agency | agency | text | Agency that wrote the incident report including Sheriff's Office and contract city reports. | Sonoma County Sheriff's Office Windsor Police Department Sonoma Police Department Santa Rosa Police Department view top 100 |
| incident number | incident_number | text | Sequential number assigned to the incident report. | 190919009 100502001 030603005 100223004 100402003 view top 100 |
| date time | date_time | calendar_date | Date and time that the incident was reported to have taken place. For incidents such as burglary when there is a time range within which the incident occurred this is the first possible time the incident could have occurred. | 2006-06-22T07:18:00.000 2006-07-27T10:07:00.000 2002-12-18T00:00:00.000 2009-07-23T10:59:00.000 2002-12-17T00:00:00.000 view top 100 |
| incident type | incident_type | text | Incident category for the type of incident reported. | ALL OTHER OFFENSE DRUG / NARCOTIC OFFENSE BURGLARY / BREAKING AND ENTERING ASSAULT - SIMPLE DESTRUCTION OF PROPERTY / VANDALISM view top 100 |
| location type | location_type | text | Location category for where the incident report occurred. In the case where multiple locations are reported only the first location will be displayed. | HIGHWAY/ROAD/ALLEY RESIDENCE/HOME OTHER/UNKNOWN PARKING LOT/GARAGE MOTOR VEHICLES view top 100 |
| city | city | text | Geographic area where the reported incident took place. Some unincorporated areas are given three character codes rather then full town names. Additionally city names do not imply that the report occurred within city limits, simply within a geographic area designated with that city name. Use the intersection or geographic coordinates to identify the incident location. | SANTA ROSA WINDSOR SONOMA GUERNEVILLE BOYES HOT SPRINGS view top 100 |
| intersection | intersection | text | Closest intersection to the location where the event was reported. Intersections are used to protect victims identities. | Russell Ave / Mendocino Ave Paulin Dr / Ventura Ave Stewarts Point Skaggs Springs Rd / Dry Creek Rd Victory Ln / Calabazas Dr Golf Course Dr W / Labath Ave view top 100 |
| location | location | location | This column contains geo-coordinates used for mapping. | view top 100 |
| upload | upload | calendar_date | Date the data was uploaded into Socrata after incident approval. | 2019-05-10T00:00:00.000 2019-12-06T00:00:00.000 2015-07-27T00:00:00.000 2019-09-19T00:00:00.000 2019-07-17T00:00:00.000 view top 100 |