data.roseville.ca.us
Open data portalsUSdata.roseville.ca.us
Socrata open data portal at data.roseville.ca.us, publishing 206 public datasets from the publishing organisation, led by the Electric category.
Capabilities (5)
GET /v1/data/data-roseville-ca-us/catalog-search1 creditKeyword search over the datasets published on data.roseville.ca.us: each hit carries the dataset id, name, description, attribution, category, tags, column names and last update time, plus the total match count.
GET /v1/data/data-roseville-ca-us/dataset1 creditThe complete metadata document for one dataset: name, description, attribution, licence, category, tags, all column definitions with data types, and the table id used for queries.
GET /v1/data/data-roseville-ca-us/datasets1 creditA page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.
GET /v1/data/data-roseville-ca-us/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/data-roseville-ca-us/rows1 creditThe first 100 rows of a dataset as JSON objects keyed by field name. Column names are the API field names, so they can be used directly in a later SoQL query.
Response example
The shape of data from data-roseville-ca-us/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "Catalog of Enterprise Systems",
"id": "rvhx-gmk2",
"resource_name": null,
"parent_fxf": [],
"description": "SB272 requires that local agencies create a catalog of enterprise systems used and that information be made publicly available on the agency’s website. This dataset serves as a repository of such data and will be updated annually.",
"attribution": "Information Technology Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-08-12T18:42:22.000Z",
"createdAt": "2016-06-22T22:27:27.000Z",
"metadata_updated_at": "2026-08-12T18:42:20.000Z",
"data_updated_at": "2026-08-12T18:42:22.000Z",
"page_views": {
"page_views_last_week": 21,
"page_views_last_month": 107,
"page_views_total": 7820,
"page_views_last_week_log": 4.459431618637297,
"page_views_last_month_log": 6.754887502163469,
"page_views_total_log": 12.933137368256713
},
"columns_name": [
"Application",
"Vendor",
"Collected Frequency",
"Description",
"Categories or Types of Data",
"Custodian",
"Update Frequency"
],
"columns_field_name": [
"application",
"vendor",
"collected_frequency",
"description",
"categories_or_types_of_data",
"custodian",
"update_frequency"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{}
],
"download_count": 1215,
"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-07-12T21:14:48.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Government",
"domain_tags": [
"systems",
"enterprise systems",
"sb272",
"senate bill",
"enterprise"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/d/rvhx-gmk2",
"link": "https://data.roseville.ca.us/City-Government/Catalog-of-Enterprise-Systems/rvhx-gmk2",
"owner": {
"id": "8xuy-5asv",
"user_type": "interactive",
"display_name": "City of Roseville"
},
"creator": {
"id": "8xuy-5asv",
"user_type": "interactive",
"display_name": "City of Roseville"
}
},
{
"resource": {
"name": "Electric Story Page",
"id": "x4rf-d7q3",
"resource_name": null,
"parent_fxf": [
"gk8h-929g",
"jjsg-jkf9",
"uwp6-yqqs",
"rgsx-xwu3",
"7pfh-7jcs",
"mbf3-4y3f",
"bk55-y3at",
"8kyb-ypei",
"ga8g-wwft",
"4nds-r8t5"
],
"description": "",
"attribution": "Electric Dept.",
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-02-25T18:09:45.441Z",
"createdAt": "2021-12-03T19:21:25.000Z",
"metadata_updated_at": "2026-02-25T18:09:45.000Z",
"data_updated_at": "2026-02-25T18:09:45.441Z",
"page_views": {
"page_views_last_week": 17,
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.roseville.ca.us (data-roseville-ca-us) 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-roseville-ca-us" 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.roseville.ca.us (data-roseville-ca-us) 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=4bae-gqjc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-roseville-ca-us" 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.roseville.ca.us (data-roseville-ca-us) 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-roseville-ca-us" 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.roseville.ca.us (data-roseville-ca-us) 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=4bae-gqjc. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-roseville-ca-us" 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>
Licence
(c) available to the public free of charge and without any restriction that would impede the reuse or redistribution of the public record
https://www.roseville.ca.gov/privacy_policy/index.phpAttribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: data.roseville.ca.us. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s
