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.
This dataset has the following 11 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| id | id | text | Unique identifier | LW_DWILEADS_100000 LW_DWILEADS_1000009 LW_DWILEADS_1000014 LW_DWILEADS_1000017 LW_DWILEADS_1000019 view top 100 |
| agency code | agency_code | text | Agency code of agency that wrote the incident report. | SCSD WIP SOP 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 view top 100 |
| incident number | incident_number | text | Sequential number assigned to the incident report. | SO150000248 SD171023010 SD020915024 SD200819010 WI100220003 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 2002-12-12T00:00:00.000 2002-09-02T00:00:00.000 view top 100 |
| incident type | incident_type | text | Incident category for the type of incident reported. | All Other - Non-Criminal Burglary Drug Offense Larceny Assault - Other 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 MOTOR VEHICLES PARKING LOT/GARAGE 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 SONOMA WINDSOR GUERNEVILLE PETALUMA view top 100 |
| intersection | intersection | text | Closest intersection to the location where the event was reported. Intersections are used to protect victims identities. | Mendocino Ave / Russell Ave Ventura Ave / Paulin Dr Victory Ln / Calabazas Dr Golf Course Dr W / Labath Ave Lake Sub / 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. | 2022-05-10T00:00:00.000 2024-06-10T00:00:00.000 2023-12-08T00:00:00.000 2022-09-02T00:00:00.000 2023-12-17T00:00:00.000 view top 100 |