fastCRW Pergamon
Government · US
data.roseville.ca.us
data.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.
Showing the catalogue
GET /v1/data/data-roseville-ca-us/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-roseville-ca-us/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.roseville.ca.us.
JSON
{
"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,
"page_views_last_month": 125,
"page_views_total": 5308,
"page_views_last_week_log": 4.169925001442312,
"page_views_last_month_log": 6.977279923499917,
"page_views_total_log": 12.37422442612373
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2021-12-03T19:33:33.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Electric",
"domain_tags": [
"performance measures",
"electric",
"power"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/stories/s/x4rf-d7q3",
"link": "https://data.roseville.ca.us/stories/s/x4rf-d7q3",
"owner": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
},
"creator": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
}
},
{
"resource": {
"name": "Average Monthly Residential Electric Utility Bill Comparison",
"id": "gk8h-929g",
"resource_name": null,
"parent_fxf": [
"hxgu-t6hq"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "chart",
"updatedAt": "2026-03-10T16:26:46.000Z",
"createdAt": "2022-04-20T16:54:03.000Z",
"metadata_updated_at": "2026-03-10T16:26:46.000Z",
"data_updated_at": "2026-02-25T18:21:42.000Z",
"page_views": {
"page_views_last_week": 35,
"page_views_last_month": 139,
"page_views_total": 4186,
"page_views_last_week_log": 5.169925001442312,
"page_views_last_month_log": 7.129283016944966,
"page_views_total_log": 12.031701202740303
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 11,
"provenance": "official",
"lens_view_type": "tabular",
"lens_display_type": "visualization_canvas_chart",
"locked": false,
"backend": "nbe",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2026-03-10T16:26:46.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Electric",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/d/gk8h-929g",
"link": "https://data.roseville.ca.us/Electric/Average-Monthly-Residential-Electric-Utility-Bill-/gk8h-929g",
"owner": {
"id": "xab7-t22k",
"user_type": "interactive",
"display_name": "Molla"
},
"creator": {
"id": "xab7-t22k",
"user_type": "interactive",
"display_name": "Molla"
}
},
{
"resource": {
"name": "Stale Dated Checks",
"id": "vtyn-52t8",
"resource_name": null,
"parent_fxf": [],
"description": "Roseville's Stale Dated Checks (UNCL) as of August, 2026.",
"attribution": "Finance Department",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-09-16T15:39:34.000Z",
"createdAt": "2016-03-29T15:07:34.000Z",
"metadata_updated_at": "2026-09-16T15:39:30.000Z",
"data_updated_at": "2026-09-16T15:39:34.000Z",
"page_views": {
"page_views_last_week": 18,
"page_views_last_month": 80,
"page_views_total": 4106,
"page_views_last_week_log": 4.247927513443585,
"page_views_last_month_log": 6.339850002884625,
"page_views_total_log": 12.003869231979056
},
"columns_name": [
"AMOUNT",
"NAME",
"ORIGINAL DATE OF CHECK"
],
"columns_field_name": [
"amount",
"name",
"date"
],
"columns_datatype": [
"Number",
"Text",
"Calendar date"
],
"columns_description": [
"",
"",
""
],
"columns_format": [
{
"precision": "2",
"align": "left",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
{
"view": "date",
"align": "left"
}
],
"download_count": 7169,
"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": "2019-02-21T20:30:40.000Z"
},
"classification": {
"categories": [
"public safety",
"finance"
],
"tags": [],
"domain_category": "Finance",
"domain_tags": [
"uncashed",
"checks",
"stale dated",
"unclaimed"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/d/vtyn-52t8",
"link": "https://data.roseville.ca.us/Finance/Stale-Dated-Checks/vtyn-52t8",
"owner": {
"id": "cfn9-233h",
"user_type": "interactive",
"display_name": "The City of Roseville"
},
"creator": {
"id": "cfn9-233h",
"user_type": "interactive",
"display_name": "The City of Roseville"
}
},
{
"resource": {
"name": "City of Roseville Boundary (Map Service)",
"id": "azek-tbwn",
"resource_name": null,
"parent_fxf": [],
"description": "Link to City of Roseville Boundary ArcGIS Map Service",
"attribution": "Information Technology Department",
"attribution_link": null,
"contact_email": null,
"type": "href",
"updatedAt": "2021-12-20T17:35:20.000Z",
"createdAt": "2014-08-05T14:36:38.000Z",
"metadata_updated_at": "2021-12-20T17:35:20.000Z",
"data_updated_at": "2014-08-05T14:36:38.000Z",
"page_views": {
"page_views_last_week": 9,
"page_views_last_month": 57,
"page_views_total": 3781,
"page_views_last_week_log": 3.3219280948873626,
"page_views_last_month_log": 5.857980995127572,
"page_views_total_log": 11.884933647949762
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 42,
"provenance": "official",
"lens_view_type": "href",
"lens_display_type": "href",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2014-08-05T14:37:48.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "City Government",
"domain_tags": [
"boundaries",
"city maps",
"gis"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us",
"additional_access_points": [
{
"urls": {
"": "https://ags.roseville.ca.us/arcgis/rest/services/PublicServices/CityBoundaryLine/MapServer"
}
}
],
"access_points": {
"": "https://ags.roseville.ca.us/arcgis/rest/services/PublicServices/CityBoundaryLine/MapServer"
}
},
"permalink": "https://data.roseville.ca.us/d/azek-tbwn",
"link": "https://data.roseville.ca.us/City-Government/City-of-Roseville-Boundary-Map-Service-/azek-tbwn",
"owner": {
"id": "cfn9-233h",
"user_type": "interactive",
"display_name": "The City of Roseville"
},
"creator": {
"id": "cfn9-233h",
"user_type": "interactive",
"display_name": "The City of Roseville"
}
},
{
"resource": {
"name": "Public Works Story Page",
"id": "hznh-d3mx",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "Lainie Anderson-Public Works",
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-09-03T16:24:21.675Z",
"createdAt": "2021-12-03T16:48:08.000Z",
"metadata_updated_at": "2026-09-03T16:24:21.000Z",
"data_updated_at": "2026-09-03T16:24:21.675Z",
"page_views": {
"page_views_last_week": 16,
"page_views_last_month": 77,
"page_views_total": 3627,
"page_views_last_week_log": 4.08746284125034,
"page_views_last_month_log": 6.285402218862249,
"page_views_total_log": 11.824958740528524
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2021-12-03T18:00:22.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Public Works",
"domain_tags": [
"performance measures",
"public works"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/stories/s/hznh-d3mx",
"link": "https://data.roseville.ca.us/stories/s/hznh-d3mx",
"owner": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
},
"creator": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
}
},
{
"resource": {
"name": "Average Monthly Electric Bill Comparison",
"id": "hxgu-t6hq",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-02-25T18:28:49.000Z",
"createdAt": "2022-03-14T20:59:20.000Z",
"metadata_updated_at": "2026-02-25T18:28:49.000Z",
"data_updated_at": "2026-02-25T18:21:42.000Z",
"page_views": {
"page_views_last_week": 13,
"page_views_last_month": 40,
"page_views_total": 3274,
"page_views_last_week_log": 3.8073549220576037,
"page_views_last_month_log": 5.357552004618084,
"page_views_total_log": 11.677279191312175
},
"columns_name": [
"Date",
"Amount",
"City",
"Customer Type",
"Rate (cents/kwh)"
],
"columns_field_name": [
"_12_1_2019",
"amount",
"city",
"customer_type",
"rate_cents_kwh"
],
"columns_datatype": [
"Calendar date",
"Number",
"Text",
"Text",
"Number"
],
"columns_description": [
"",
"",
"",
"",
""
],
"columns_format": [
{
"view": "date_y"
},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "0"
},
{},
{},
{
"precisionStyle": "currency"
}
],
"download_count": 239,
"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-03-14T21:00:03.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Electric",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/d/hxgu-t6hq",
"link": "https://data.roseville.ca.us/Electric/Average-Monthly-Electric-Bill-Comparison/hxgu-t6hq",
"owner": {
"id": "xab7-t22k",
"user_type": "interactive",
"display_name": "Molla"
},
"creator": {
"id": "xab7-t22k",
"user_type": "interactive",
"display_name": "Molla"
}
},
{
"resource": {
"name": "Building Permits Issued",
"id": "buxi-gsvq",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-01T13:32:35.000Z",
"createdAt": "2021-10-20T16:12:12.000Z",
"metadata_updated_at": "2026-10-01T13:32:22.000Z",
"data_updated_at": "2026-10-01T13:32:35.000Z",
"page_views": {
"page_views_last_week": 60,
"page_views_last_month": 295,
"page_views_total": 3165,
"page_views_last_week_log": 5.930737337562887,
"page_views_last_month_log": 8.20945336562895,
"page_views_total_log": 11.628445540137182
},
"columns_name": [
"SQ_FOOTAGE",
"DWELL_SF",
"TOT_SQ_FOOT",
"JOB_VALUE",
"ISSUED_DATE",
"RECORD_NUMBER",
"RECORD_GROUP",
"RECORD_TYPE"
],
"columns_field_name": [
"sq_footage",
"dwell_sf",
"tot_sq_foot",
"job_value",
"issued_date",
"record_number",
"record_group",
"record_type"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Calendar date",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{}
],
"download_count": 558,
"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-10-20T16:17:11.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Development Services",
"domain_tags": [
"home permits",
"building permits",
"building",
"permits"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/d/buxi-gsvq",
"link": "https://data.roseville.ca.us/Development-Services/Building-Permits-Issued/buxi-gsvq",
"owner": {
"id": "7f6e-5h6z",
"user_type": "interactive",
"display_name": "Colin Parks"
},
"creator": {
"id": "7f6e-5h6z",
"user_type": "interactive",
"display_name": "Colin Parks"
}
},
{
"resource": {
"name": "Environmental Utilities Story Page",
"id": "ks8p-mynw",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "Environmental Utilities",
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2023-08-30T21:37:23.226Z",
"createdAt": "2021-12-03T19:12:46.000Z",
"metadata_updated_at": "2022-02-25T17:18:46.000Z",
"data_updated_at": "2023-08-30T21:37:23.226Z",
"page_views": {
"page_views_last_week": 21,
"page_views_last_month": 85,
"page_views_total": 3130,
"page_views_last_week_log": 4.459431618637297,
"page_views_last_month_log": 6.426264754702098,
"page_views_total_log": 11.61240779313867
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2021-12-03T19:17:37.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Environmental Utilities",
"domain_tags": [
"performance measures",
"environmental utilities"
],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/stories/s/ks8p-mynw",
"link": "https://data.roseville.ca.us/stories/s/ks8p-mynw",
"owner": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
},
"creator": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
}
},
{
"resource": {
"name": "Fire Story Page",
"id": "bfie-7dhb",
"resource_name": null,
"parent_fxf": [
"fht6-fdsg"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-07-17T16:56:07.148Z",
"createdAt": "2022-10-05T15:30:15.000Z",
"metadata_updated_at": "2026-07-17T16:56:07.000Z",
"data_updated_at": "2026-07-17T16:56:07.148Z",
"page_views": {
"page_views_last_week": 20,
"page_views_last_month": 57,
"page_views_total": 3044,
"page_views_last_week_log": 4.392317422778761,
"page_views_last_month_log": 5.857980995127572,
"page_views_total_log": 11.572226512793694
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 0,
"provenance": "official",
"lens_view_type": "story",
"lens_display_type": "story",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": null,
"hide_from_data_json": false,
"publication_date": "2022-10-05T15:35:21.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Fire",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.roseville.ca.us"
},
"permalink": "https://data.roseville.ca.us/stories/s/bfie-7dhb",
"link": "https://data.roseville.ca.us/stories/s/bfie-7dhb",
"owner": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
},
"creator": {
"id": "waf3-c7ac",
"user_type": "interactive",
"display_name": "Nanise Tomlinson"
}
},
"… 10 more items"
],
"resultSetSize": 206,
"timings": {
"serviceMillis": 26,
"searchMillis": [
9,
9
]
},
"warnings": []
}Attribution: Source: data.roseville.ca.us. Dataset attribution as stated by each publishing agency.
Licence: (c) available to the public free of charge and without any restriction that would impede the reuse or redistribution of the public record
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>