fastCRW Pergamon
Government · US
data.sonomacounty.ca.gov
data.sonomacounty.ca.gov
Socrata open data portal at data.sonomacounty.ca.gov, publishing 139 public datasets from the publishing organisation, led by the Government category.
Showing the catalogue
GET /v1/data/data-sonomacounty-ca-gov/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
1 credit⌘ ↵
Code follows the fields above
curl "https://api.fastcrw.com/v1/data/data-sonomacounty-ca-gov/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.sonomacounty.ca.gov.
JSON
{
"results": [
{
"resource": {
"name": "Sonoma County Sheriff's Office Incident Data",
"id": "3rsj-iche",
"resource_name": null,
"parent_fxf": [],
"description": "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.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "http://www.sonomasheriff.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T08:31:40.000Z",
"createdAt": "2015-05-19T22:19:55.000Z",
"metadata_updated_at": "2024-03-28T18:05:55.000Z",
"data_updated_at": "2026-10-23T08:31:40.000Z",
"page_views": {
"page_views_last_week": 410,
"page_views_last_month": 1590,
"page_views_total": 224948,
"page_views_last_week_log": 8.682994583681683,
"page_views_last_month_log": 10.635718120331047,
"page_views_total_log": 17.779238427936356
},
"columns_name": [
"agency",
"location (city)",
"location (address)",
"location (state)",
"id",
"location type",
"upload",
"intersection",
"incident number",
"date time",
"… 7 more items"
],
"columns_field_name": [
"agency",
"location_city",
"location_address",
"location_state",
"id",
"location_type",
"upload",
"intersection",
"incident_number",
"date_time",
"… 7 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Calendar date",
"… 7 more items"
],
"columns_description": [
"Agency that wrote the incident report including Sheriff's Office and contract city reports.",
"",
"",
"",
"Unique identifier",
"Location category for where the incident report occurred. In the case where multiple locations are reported only the first location will be displayed.",
"Date the data was uploaded into Socrata after incident approval.",
"Closest intersection to the location where the event was reported. Intersections are used to protect victims identities.",
"Sequential number assigned to the incident report.",
"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.",
"… 7 more items"
],
"columns_format": [
{
"align": "left"
},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
"… 7 more items"
],
"download_count": 121487,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2022-05-10T22:22:38.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"windsor",
"incidents",
"crime",
"reports",
"sonoma",
"police",
"sheriff"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Civic Services and Engagement"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/3rsj-iche",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/Sonoma-County-Sheriff-s-Office-Incident-Data/3rsj-iche",
"owner": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
},
"creator": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
}
},
{
"resource": {
"name": "Sonoma County Sheriff's Office Arrest Data",
"id": "f6uf-eqmk",
"resource_name": null,
"parent_fxf": [],
"description": "Each row of data represents an arrest or citation. Arrest charges are grouped together in the charge description column. Charge details are delimited by semicolons and charges are delimited by line breaks with multiple hyphens. Location information has been generalized to the nearest intersection.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "https://www.sonomasheriff.org/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T08:32:23.000Z",
"createdAt": "2017-12-20T20:00:23.000Z",
"metadata_updated_at": "2024-03-28T18:07:28.000Z",
"data_updated_at": "2026-10-23T08:32:23.000Z",
"page_views": {
"page_views_last_week": 576,
"page_views_last_month": 2207,
"page_views_total": 170323,
"page_views_last_week_log": 9.172427508645484,
"page_views_last_month_log": 11.10852445677817,
"page_views_total_log": 17.377922210929608
},
"columns_name": [
"Census Tract Boundary",
"Charge Description",
"Arrest Coordinates",
"Date & Time Arrested",
"Arestee Last Name",
"Arrest ID",
"Incident Number",
"Arrest City",
"Zone",
"Arrest Coordinates (address)",
"… 16 more items"
],
"columns_field_name": [
":@computed_region_xw9s_pz78",
"chargedescription",
"arrestcoordinates",
"datetimearrested",
"aresteelastname",
"arrestid",
"incidentnumber",
"arrestcity",
"zone_",
"arrestcoordinates_address",
"… 16 more items"
],
"columns_datatype": [
"Number",
"Text",
"Point",
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 16 more items"
],
"columns_description": [
"",
"English description of the code violation (arrest charge) associated with each charge.",
"This column contains geo-coordinates used for mapping.",
"Date and time that the arrest was reported to have occurred.",
"Last name of the arrested individual.",
"Sequential number assigned to the arrest report.",
"Sequential number assigned to the incident report. Can be used in combination with agency to link to incident data.",
"Geographic area where the reported arrest 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 approximate arrest location.",
"",
"",
"… 16 more items"
],
"columns_format": [
{},
{
"displayStyle": "plain",
"align": "left"
},
{
"view": "address_coords",
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{},
"… 16 more items"
],
"download_count": 151849,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2021-06-17T16:54:45.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"arrest",
"crime",
"charges"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Civic Services and Engagement"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/f6uf-eqmk",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/Sonoma-County-Sheriff-s-Office-Arrest-Data/f6uf-eqmk",
"owner": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
},
"creator": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
}
},
{
"resource": {
"name": "Salary Steps by Job Classification",
"id": "t7x3-ntip",
"resource_name": null,
"parent_fxf": [],
"description": "Current salary steps (A Step - I Step) and unit designations for all job classifications.",
"attribution": "County of Sonoma Human Resources Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-08T16:39:37.000Z",
"createdAt": "2016-09-22T16:24:28.000Z",
"metadata_updated_at": "2026-01-08T17:47:34.000Z",
"data_updated_at": "2026-10-08T16:39:37.000Z",
"page_views": {
"page_views_last_week": 290,
"page_views_last_month": 1250,
"page_views_total": 93688,
"page_views_last_week_log": 8.184875342908285,
"page_views_last_month_log": 10.28886607416582,
"page_views_total_log": 16.515592050944704
},
"columns_name": [
"F Step",
"E Step",
"C Step",
"B Step",
"A Step",
"I Step",
"D Step",
"Job Code",
"Unit Designation",
"Job Title",
"… 3 more items"
],
"columns_field_name": [
"f_step",
"e_step",
"c_step",
"b_step",
"a_step",
"i_step",
"d_step",
"job_code",
"unit_designation",
"job_title",
"… 3 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text",
"… 3 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 3 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{},
{},
{},
"… 3 more items"
],
"download_count": 13511,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2017-03-01T16:16:52.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"job classification",
"job class",
"salary steps",
"unit designation"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Human Resources"
},
{
"key": "Focus-Area_Focus",
"value": "Economic and Environmental Stewardship"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov"
},
"permalink": "https://data.sonomacounty.ca.gov/d/t7x3-ntip",
"link": "https://data.sonomacounty.ca.gov/Government/Salary-Steps-by-Job-Classification/t7x3-ntip",
"owner": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
},
"creator": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
}
},
{
"resource": {
"name": "Sonoma County Sheriff's Office Event Data",
"id": "bpq8-s7gr",
"resource_name": null,
"parent_fxf": [],
"description": "Event data summarizes Sheriff's dispatch and deputy initiated activities. Events related to the following Penal Codes have been omitted in accordance with the California Public Records Act: 220, 236.1, 243.4, 261, 261.5, 262, 262(a)(1), 264, 264.1, 265, 266, 266(a), 266(b), 266(c), 266(e), 266(f), 266(j), 267, 269, 269(a), 273(a), 273(d), 273.5, 285, 286, 288, 288(a), 288.2, 288.3, 288.5, 288.7, 289, 422.6, 422.7, 422.75, 646.9, 647.6, as well as Welfare and Institutions Code 5150 or Business and Professions Code 729(a) and Stake Out. Additionally canceled events are not reported.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "http://www.sonomasheriff.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T08:32:04.000Z",
"createdAt": "2015-05-13T22:37:46.000Z",
"metadata_updated_at": "2024-03-28T18:06:43.000Z",
"data_updated_at": "2026-10-23T08:32:04.000Z",
"page_views": {
"page_views_last_week": 207,
"page_views_last_month": 610,
"page_views_total": 69227,
"page_views_last_week_log": 7.700439718141093,
"page_views_last_month_log": 9.25502856981873,
"page_views_total_log": 16.079068048782208
},
"columns_name": [
"date time",
"disposition code",
"event source",
"location (city)",
"beat-zone",
"agency name",
"location",
"location (address)",
"location (state)",
"Census Tract Boundary",
"… 10 more items"
],
"columns_field_name": [
"date_time",
"disposition_code",
"event_source",
"location_city",
"beat_zone",
"agency_name",
"location",
"location_address",
"location_state",
":@computed_region_xw9s_pz78",
"… 10 more items"
],
"columns_datatype": [
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"Text",
"Point",
"Text",
"Text",
"Number",
"… 10 more items"
],
"columns_description": [
"Date and time event was created in the dispatch system.",
"Abbreviated version of the event disposition. Disposition is not required data for event data so there are occasionally blanks in this field.",
"Source from which the event was created either a call to our dispatch center or an event initiated by a deputy during the course of their work.",
"",
"Geographic area where the event occurred, the Sheriff's jurisdiction is currently divided into six zones. Windsor and Sonoma do not use beats/zones. Blanks data in this field indicates the system was unable to identify the zone/beat where the event occurred.",
"Full name of responding agency",
"Geographic location of the reported nearest intersection. Entry of coordinates \"(0,0)\" indicates that the system was unable to identify the geographic location of the event.",
"",
"",
"",
"… 10 more items"
],
"columns_format": [
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{},
{
"align": "left"
},
{
"align": "left"
},
{
"view": "address_coords",
"align": "left"
},
{},
{},
{},
"… 10 more items"
],
"download_count": 34837,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2015-06-01T21:47:02.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"calls",
"dispatch",
"events",
"stops",
"activities"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/bpq8-s7gr",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/Sonoma-County-Sheriff-s-Office-Event-Data/bpq8-s7gr",
"owner": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
},
"creator": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
}
},
{
"resource": {
"name": "Animal Shelter Intake and Outcome",
"id": "924a-vesw",
"resource_name": null,
"parent_fxf": [],
"description": "Our community cares a great deal about animals, and many people are interested in better understanding the more than 4,000 animals who come through the doors of Sonoma County Animal Services each year.",
"attribution": "County of Sonoma Department of Health Services",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T14:00:50.000Z",
"createdAt": "2017-02-02T16:29:41.000Z",
"metadata_updated_at": "2019-05-28T16:35:09.000Z",
"data_updated_at": "2026-10-23T14:00:50.000Z",
"page_views": {
"page_views_last_week": 290,
"page_views_last_month": 1036,
"page_views_total": 37682,
"page_views_last_week_log": 8.184875342908285,
"page_views_last_month_log": 10.018200178813226,
"page_views_total_log": 15.201626204182615
},
"columns_name": [
"Location (state)",
"Intake Jurisdiction",
"Intake Type",
"Animal ID",
"Outcome Subtype",
"Outcome Type",
"Location (zip)",
"Outcome Condition",
"Location (city)",
"Color",
"… 19 more items"
],
"columns_field_name": [
"location_state",
"intake_jurisdiction",
"intake_type",
"id",
"outcome_subtype",
"outcome_type",
"location_zip",
"outcome_condition",
"location_city",
"color",
"… 19 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 19 more items"
],
"columns_description": [
"",
"Jurisdiction responsible for animal intake",
"Reason for intake",
"Unique ID",
"Sub reason for release from shelter",
"Reason for release from shelter",
"",
"Animals condition at release from shelter",
"",
"Color of animal, Black, Chocolate, White….",
"… 19 more items"
],
"columns_format": [
{},
{
"displayStyle": "plain",
"align": "center"
},
{
"displayStyle": "plain",
"align": "center"
},
{
"displayStyle": "plain",
"align": "center"
},
{
"displayStyle": "plain",
"align": "center"
},
{
"displayStyle": "plain",
"align": "center"
},
{},
{
"displayStyle": "plain",
"align": "center"
},
{},
{
"displayStyle": "plain",
"align": "center"
},
"… 19 more items"
],
"download_count": 20670,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2017-06-02T17:54:37.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"outcome",
"dog",
"intake",
"license",
"spay",
"pet",
"neuter",
"adopt",
"animal shelter",
"cat"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Health Services"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov"
},
"permalink": "https://data.sonomacounty.ca.gov/d/924a-vesw",
"link": "https://data.sonomacounty.ca.gov/Government/Animal-Shelter-Intake-and-Outcome/924a-vesw",
"owner": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
},
"creator": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
}
},
{
"resource": {
"name": "Petaluma Incidents",
"id": "6nnw-hm7z",
"resource_name": null,
"parent_fxf": [
"3rsj-iche"
],
"description": "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.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "http://www.sonomasheriff.org",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-10-23T08:31:40.000Z",
"createdAt": "2018-05-18T22:18:17.000Z",
"metadata_updated_at": "2025-01-29T03:29:38.000Z",
"data_updated_at": "2026-10-23T08:31:40.000Z",
"page_views": {
"page_views_last_week": 192,
"page_views_last_month": 878,
"page_views_total": 19079,
"page_views_last_week_log": 7.592457037268081,
"page_views_last_month_log": 9.779719355143405,
"page_views_total_log": 14.219773550892876
},
"columns_name": [
"location type",
"intersection",
"location",
"upload",
"city",
"incident number",
"agency",
"agency code",
"date time",
"incident type"
],
"columns_field_name": [
"location_type",
"intersection",
"location",
"upload",
"city",
"incident_number",
"agency",
"agency_code",
"date_time",
"incident_type"
],
"columns_datatype": [
"Text",
"Text",
"Point",
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"Calendar date",
"Text"
],
"columns_description": [
"Location category for where the incident report occurred. In the case where multiple locations are reported only the first location will be displayed.",
"Closest intersection to the location where the event was reported. Intersections are used to protect victims identities.",
"This column contains geo-coordinates used for mapping.",
"Date the data was uploaded into Socrata after incident approval.",
"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.",
"Sequential number assigned to the incident report.",
"Agency that wrote the incident report including Sheriff's Office and contract city reports.",
"Agency code of agency that wrote the incident report.",
"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.",
"Incident category for the type of incident reported."
],
"columns_format": [
{
"align": "left"
},
{
"align": "left"
},
{
"view": "address_coords",
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
}
],
"download_count": 473,
"provenance": "community",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-05-18T22:18:17.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"crime",
"incidents",
"police",
"reports",
"sheriff",
"sonoma",
"windsor"
],
"domain_metadata": [
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/6nnw-hm7z",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/Petaluma-Incidents/6nnw-hm7z",
"owner": {
"id": "6wpa-dyzy",
"user_type": "interactive",
"display_name": "Spencer Crum"
},
"creator": {
"id": "6wpa-dyzy",
"user_type": "interactive",
"display_name": "Spencer Crum"
}
},
{
"resource": {
"name": "Sonoma County Rebuilding Permits",
"id": "652y-5ihx",
"resource_name": null,
"parent_fxf": [],
"description": "Rebuilding permits issued in unincorporated Sonoma County on parcels impacted by the 2017 Sonoma Fire Complex, 2019 Kincade Fire, 2020 Glass Fire, 2020 LNU Lightning Complex Fire.",
"attribution": "County of Sonoma Permit and Resource Management Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-07-27T14:20:55.000Z",
"createdAt": "2018-04-03T20:45:19.000Z",
"metadata_updated_at": "2022-11-08T19:57:03.000Z",
"data_updated_at": "2026-07-27T14:20:55.000Z",
"page_views": {
"page_views_last_week": 46,
"page_views_last_month": 198,
"page_views_total": 15930,
"page_views_last_week_log": 5.554588851677638,
"page_views_last_month_log": 7.636624620543649,
"page_views_total_log": 13.959549208230655
},
"columns_name": [
"Situs Address",
"Location (zip)",
"Census Tract Boundary",
"Zip Codes",
"Buildings",
"Record Type",
"Location (address)",
"Status",
"Total Square Feet",
"Location (state)",
"… 13 more items"
],
"columns_field_name": [
"situs_address",
"geocoded_column_zip",
":@computed_region_xw9s_pz78",
":@computed_region_dig5_f3vy",
"buildings",
"record_type",
"geocoded_column_address",
"status",
"total_square_feet",
"geocoded_column_state",
"… 13 more items"
],
"columns_datatype": [
"Text",
"Text",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 13 more items"
],
"columns_description": [
"",
"",
"",
"",
"The number of buildings related to the permit or record.",
"The type of permit or record.",
"",
"",
"The total square feet related to the permit or record. ",
"",
"… 13 more items"
],
"columns_format": [
{},
{},
{},
{},
{
"precisionStyle": "standard",
"align": "right"
},
{
"align": "left"
},
{},
{},
{
"align": "left"
},
{},
"… 13 more items"
],
"download_count": 9421,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-08-23T16:55:56.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"lightning",
"2017",
"2019",
"2020",
"building",
"building permits",
"complex",
"fire",
"glass",
"kincade",
"… 5 more items"
],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Permit and Resource Management Department"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Creative Commons 1.0 Universal (Public Domain Dedication)"
},
"permalink": "https://data.sonomacounty.ca.gov/d/652y-5ihx",
"link": "https://data.sonomacounty.ca.gov/Government/Sonoma-County-Rebuilding-Permits/652y-5ihx",
"owner": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
},
"creator": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
}
},
{
"resource": {
"name": "Software Application Portfolio (SB272)",
"id": "4juh-m9jm",
"resource_name": null,
"parent_fxf": [],
"description": "On October 11, 2015, Governor Brown signed SB 272 into law. This bill requires local agencies to publish a list of “enterprise” systems. These are systems that are used across multiple departments or that contain information collected about the public and are systems that serve as original sources of data within an agency.\r\n\r\nCertain systems are exempt from disclosure, including: \r\n•Emergency services systems.\r\n•Information technology security.\r\n•Building access.\r\n•Mechanical controls.\r\n\r\nThis catalog will be reviewed and updated on an annual basis by July 1 of each year. For more information, please visit http://sonomacounty.ca.gov/SB272/.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-07-02T00:30:06.000Z",
"createdAt": "2016-05-31T22:42:38.000Z",
"metadata_updated_at": "2026-07-02T00:30:05.000Z",
"data_updated_at": "2026-07-02T00:30:06.000Z",
"page_views": {
"page_views_last_week": 24,
"page_views_last_month": 101,
"page_views_total": 15036,
"page_views_last_week_log": 4.643856189774724,
"page_views_last_month_log": 6.672425341971495,
"page_views_total_log": 13.876229146243357
},
"columns_name": [
"Custodian",
"Frequency Collected",
"Types of Data",
"System Purpose",
"Product",
"Vendor",
"Frequency Updated"
],
"columns_field_name": [
"custodian",
"frequency_collected",
"types_of_data",
"system_purpose",
"product",
"vendor",
"frequency_updated"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{}
],
"download_count": 6965,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2018-06-14T17:25:03.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"software",
"portfolio",
"aps",
"applications",
"application",
"sb272"
],
"domain_metadata": [
{
"key": "Department_Department",
"value": "Information Systems Department"
},
{
"key": "Focus-Area_Focus",
"value": "Civic Services and Engagement"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov"
},
"permalink": "https://data.sonomacounty.ca.gov/d/4juh-m9jm",
"link": "https://data.sonomacounty.ca.gov/Government/Software-Application-Portfolio-SB272-/4juh-m9jm",
"owner": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
},
"creator": {
"id": "fay8-azsg",
"user_type": "interactive",
"display_name": "OpenData"
}
},
{
"resource": {
"name": "drunk",
"id": "vetc-ie2s",
"resource_name": null,
"parent_fxf": [
"3rsj-iche"
],
"description": "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.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "http://www.sonomasheriff.org",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-10-23T08:31:40.000Z",
"createdAt": "2016-02-04T02:22:10.000Z",
"metadata_updated_at": "2025-01-29T03:29:59.000Z",
"data_updated_at": "2026-10-23T08:31:40.000Z",
"page_views": {
"page_views_last_week": 12,
"page_views_last_month": 33,
"page_views_total": 14478,
"page_views_last_week_log": 3.700439718141092,
"page_views_last_month_log": 5.08746284125034,
"page_views_total_log": 13.8216743448946
},
"columns_name": [
"agency code",
"incident type",
"date time",
"location type",
"location",
"agency",
"incident number",
"city",
"intersection",
"upload"
],
"columns_field_name": [
"agency_code",
"incident_type",
"date_time",
"location_type",
"location",
"agency",
"incident_number",
"city",
"intersection",
"upload"
],
"columns_datatype": [
"Text",
"Text",
"Calendar date",
"Text",
"Point",
"Text",
"Text",
"Text",
"Text",
"Calendar date"
],
"columns_description": [
"Agency code of agency that wrote the incident report.",
"Incident category for the type of incident reported.",
"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.",
"Location category for where the incident report occurred. In the case where multiple locations are reported only the first location will be displayed.",
"This column contains geo-coordinates used for mapping.",
"Agency that wrote the incident report including Sheriff's Office and contract city reports.",
"Sequential number assigned to the incident report.",
"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.",
"Closest intersection to the location where the event was reported. Intersections are used to protect victims identities.",
"Date the data was uploaded into Socrata after incident approval."
],
"columns_format": [
{
"align": "left"
},
{
"align": "left"
},
{
"view": "date_time",
"align": "left"
},
{
"align": "left"
},
{
"view": "address_coords",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"view": "date_time",
"align": "left"
}
],
"download_count": 659,
"provenance": "community",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2015-06-10T18:34:04.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [
"police",
"windsor",
"sonoma",
"sheriff",
"reports",
"crime",
"incidents"
],
"domain_metadata": [
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/vetc-ie2s",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/drunk/vetc-ie2s",
"owner": {
"id": "gpbf-5fx9",
"user_type": "interactive",
"display_name": "kcFRED9"
},
"creator": {
"id": "gpbf-5fx9",
"user_type": "interactive",
"display_name": "kcFRED9"
}
},
{
"resource": {
"name": "Sonoma County Sheriff's Office Jail Population Data",
"id": "gemb-q4p5",
"resource_name": null,
"parent_fxf": [],
"description": "Historical population data captured daily. Two figures are shown those in custody and those in outside custody but are still under the responsibility of Sonoma County Sheriff. Examples of outside custody include home confinement, state prison, hospital stays, weekend custody, and supervised by other agencies.",
"attribution": "Sonoma County Sheriff's Office",
"attribution_link": "http://www.sonomasheriff.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T08:32:33.000Z",
"createdAt": "2016-05-23T22:13:04.000Z",
"metadata_updated_at": "2024-03-28T18:09:01.000Z",
"data_updated_at": "2026-10-23T08:32:33.000Z",
"page_views": {
"page_views_last_week": 48,
"page_views_last_month": 197,
"page_views_total": 13420,
"page_views_last_week_log": 5.614709844115208,
"page_views_last_month_log": 7.6293566200796095,
"page_views_total_log": 13.712204550438654
},
"columns_name": [
"Custody",
"ID",
"OutsideCustody",
"LoadDate"
],
"columns_field_name": [
"custody",
"id",
"outsidecustody",
"loaddate"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Calendar date"
],
"columns_description": [
"Number of inmates in custody at the main adult detention facility and north county detention facility.",
"",
" Examples of outside custody include home confinement, state prison, hospital stays, weekend custody, and supervised by other agencies.",
"The date the data was queried."
],
"columns_format": [
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{
"view": "date_time",
"align": "left"
}
],
"download_count": 20141,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "table",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2016-05-25T15:42:29.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Safety",
"domain_tags": [],
"domain_metadata": [
{
"key": "Agency_Agency",
"value": "County of Sonoma"
},
{
"key": "Department_Department",
"value": "Sheriff's Office"
},
{
"key": "Focus-Area_Focus",
"value": "Safe, Healthy, and Caring Community"
}
]
},
"metadata": {
"domain": "data.sonomacounty.ca.gov",
"license": "Public Domain"
},
"permalink": "https://data.sonomacounty.ca.gov/d/gemb-q4p5",
"link": "https://data.sonomacounty.ca.gov/Public-Safety/Sonoma-County-Sheriff-s-Office-Jail-Population-Dat/gemb-q4p5",
"owner": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
},
"creator": {
"id": "mq8t-bfuk",
"user_type": "interactive",
"display_name": "Sheriff Programming Unit"
}
},
"… 10 more items"
],
"resultSetSize": 139,
"timings": {
"serviceMillis": 34,
"searchMillis": [
19,
6
]
},
"warnings": []
}Attribution: Source: data.sonomacounty.ca.gov. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Public Domain" in their Socrata metadata; the portal publishes no separate API licence and different datasets may carry different terms. Quoted as found in the portal's own catalogue.
Ask with this source
A prompt for your agent that names this source and how to call it through the crw MCP.
Catalogue search
Use data.sonomacounty.ca.gov (data-sonomacounty-ca-gov) from fastCRW Pergamon, capability "Catalogue search" (catalog-search). You want to find a dataset on this portal by keyword and do not know its four-by-four id. Example options: q=taxi, offset=0, order=page_views_total DESC. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sonomacounty-ca-gov" and capability "catalog-search". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset metadata
Use data.sonomacounty.ca.gov (data-sonomacounty-ca-gov) from fastCRW Pergamon, capability "Dataset metadata" (dataset). You already hold a dataset id and need its columns, licence or description before querying rows. Example options: id=23z5-fg6m. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sonomacounty-ca-gov" and capability "dataset". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Dataset inventory
Use data.sonomacounty.ca.gov (data-sonomacounty-ca-gov) from fastCRW Pergamon, capability "Dataset inventory" (datasets). You need to enumerate what this portal publishes, or page through its newest datasets. Example options: offset=0, order=createdAt, category=Transportation. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sonomacounty-ca-gov" and capability "datasets". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>
Row count
Use data.sonomacounty.ca.gov (data-sonomacounty-ca-gov) from fastCRW Pergamon, capability "Row count" (row-count). You need to know how large a dataset is before downloading it, or want a cheap liveness check. Example options: id=23z5-fg6m. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sonomacounty-ca-gov" and capability "row-count". Tell me the credits used and cite the licence from the response. If the crw MCP tools are missing, install them with: npx -y crw-mcp install --api-key <your fastCRW API key>