fastCRW Pergamon
Government · US
bythenumbers.sco.ca.gov
bythenumbers.sco.ca.gov
Socrata open data portal at bythenumbers.sco.ca.gov, publishing 170 public datasets from the publishing organisation, led by the Raw Data category.
Showing the catalogue
GET /v1/data/bythenumbers-sco-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/bythenumbers-sco-ca-gov/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from bythenumbers.sco.ca.gov.
JSON
{
"results": [
{
"resource": {
"name": "About This Site",
"id": "7vdg-5bgf",
"resource_name": null,
"parent_fxf": [],
"description": "In its ongoing effort to promote transparency in government, the California State Controller's Office created this website to make it easier for taxpayers to track revenues, expenditures, and other financial data reported by California's 58 counties, more than 450 cities and more than 4,800 special districts.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2025-12-23T23:26:51.496Z",
"createdAt": "2017-09-11T05:04:42.000Z",
"metadata_updated_at": "2025-12-23T23:26:51.000Z",
"data_updated_at": "2025-12-23T23:26:51.496Z",
"page_views": {
"page_views_last_week": 110,
"page_views_last_month": 694,
"page_views_total": 127106,
"page_views_last_week_log": 6.794415866350106,
"page_views_last_month_log": 9.44086916761087,
"page_views_total_log": 16.955683958652227
},
"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": "2017-09-11T05:04:42.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Finance Application",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/stories/s/7vdg-5bgf",
"link": "https://bythenumbers.sco.ca.gov/stories/s/7vdg-5bgf",
"owner": {
"id": "x5jh-tg6w",
"user_type": "interactive",
"display_name": "Hiko Naito - TylerTech employee"
},
"creator": {
"id": "x5jh-tg6w",
"user_type": "interactive",
"display_name": "Hiko Naito - TylerTech employee"
}
},
{
"resource": {
"name": "Glossary",
"id": "guqp-d3wf",
"resource_name": null,
"parent_fxf": [],
"description": "Learn about local government finance terms and retirement system terms commonly used on this website.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2024-12-04T22:42:58.092Z",
"createdAt": "2017-09-11T05:10:58.000Z",
"metadata_updated_at": "2017-10-04T22:34:18.000Z",
"data_updated_at": "2024-12-04T22:42:58.092Z",
"page_views": {
"page_views_last_week": 98,
"page_views_last_month": 536,
"page_views_total": 110971,
"page_views_last_week_log": 6.6293566200796095,
"page_views_last_month_log": 9.068778277985412,
"page_views_total_log": 16.759836182030888
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1,
"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": "2017-09-11T05:10:58.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov"
},
"permalink": "https://bythenumbers.sco.ca.gov/stories/s/guqp-d3wf",
"link": "https://bythenumbers.sco.ca.gov/stories/s/guqp-d3wf",
"owner": {
"id": "x5jh-tg6w",
"user_type": "interactive",
"display_name": "Hiko Naito - TylerTech employee"
},
"creator": {
"id": "x5jh-tg6w",
"user_type": "interactive",
"display_name": "Hiko Naito - TylerTech employee"
}
},
{
"resource": {
"name": "CalPERS Supplement - Contracting Agencies' Benefits for Fiscal Years 2002-03 to 2023-24",
"id": "ew9v-kudu",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset compares selected benefits of all the local public agencies that contracted with CalPERS. Agencies are listed alphabetically and include the plan types (miscellaneous or safety) and a five-digit code used for identification by CalPERS of the various benefit formulas.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2025-12-23T23:13:34.000Z",
"createdAt": "2014-08-08T21:53:52.000Z",
"metadata_updated_at": "2025-12-23T23:13:32.000Z",
"data_updated_at": "2025-12-23T23:13:34.000Z",
"page_views": {
"page_views_last_week": 16,
"page_views_last_month": 53,
"page_views_total": 29062,
"page_views_last_week_log": 4.08746284125034,
"page_views_last_month_log": 5.754887502163469,
"page_views_total_log": 14.826896011003816
},
"columns_name": [
"Sick Leave Credit",
"Post Retirement Survivor Allowance",
"Ordinary Disability Increase",
"1959 Survivor Benefit",
"Employer",
"Member",
"Employer Code",
"Coverage Group",
"Final Compensation Offset",
"Employer Name",
"… 6 more items"
],
"columns_field_name": [
"sick_leave_credit",
"post_retirement_survivor_allowance",
"ordinary_disability_increase",
"_1959_survivor_benefit",
"employer",
"member",
"employer_code",
"coverage_group",
"final_compensation_offset",
"employer_name",
"… 6 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Text",
"Number",
"Text",
"Number",
"Number",
"Text",
"Text",
"… 6 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 6 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
{},
"… 6 more items"
],
"download_count": 3946,
"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-12-13T23:17:32.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Retirement Systems",
"domain_tags": [
"calpers supplement",
"pr_perscont"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/ew9v-kudu",
"link": "https://bythenumbers.sco.ca.gov/Retirement-Systems/CalPERS-Supplement-Contracting-Agencies-Benefits-f/ew9v-kudu",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Funding Positions of CalPERS Contracting Agencies for Fiscal Years 2002-03 to 2023-24",
"id": "4mw7-e9iu",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset contains the Actuarial Liabilities, Actuarial Value of Assets, Unfunded Liabilities, and Funding Ratios for each Local Contracting Agency.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2025-12-23T23:07:13.000Z",
"createdAt": "2014-08-08T22:02:36.000Z",
"metadata_updated_at": "2025-12-23T23:07:12.000Z",
"data_updated_at": "2025-12-23T23:07:13.000Z",
"page_views": {
"page_views_last_week": 8,
"page_views_last_month": 51,
"page_views_total": 25322,
"page_views_last_week_log": 3.1699250014423126,
"page_views_last_month_log": 5.700439718141093,
"page_views_total_log": 14.628160709621383
},
"columns_name": [
"Prior Year 3",
"Actuarial Liabilities",
"Category",
"Fiscal Year",
"Employer Name",
"Prior Year 2",
"Employer Code",
"Prior Year 1",
"Current Year",
"Unfunded Liabilities",
"… 1 more items"
],
"columns_field_name": [
"prior_year_3",
"actuarial_liabilities",
"category",
"fiscal_year",
"employer_name",
"prior_year_2",
"employer_code",
"prior_year_1",
"current_year",
"unfunded_liabilities",
"… 1 more items"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Text",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 1 more items"
],
"columns_description": [
"",
"",
"1 = Miscellaneous Plan; 2 = Safety Plan; 3 = Safety Fire Plan; 4 = Safety Police/Sheriff Plan; 5 = Safety Lifeguard Plan; 6 = Miscellaneous Tier 2; 7 = Safety Tier 2; 8 = Miscellaneous Tier 3; 9 = Safety School Police",
"",
"",
"",
"",
"",
"",
"",
"… 1 more items"
],
"columns_format": [
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "right"
},
{},
{},
{},
"… 1 more items"
],
"download_count": 3804,
"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-12-21T18:58:51.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Retirement Systems",
"domain_tags": [
"pr_persfratio",
"calpers supplement"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/4mw7-e9iu",
"link": "https://bythenumbers.sco.ca.gov/Retirement-Systems/Funding-Positions-of-CalPERS-Contracting-Agencies-/4mw7-e9iu",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Cities Raw Data for Fiscal Years 2002-03 to 2015-16",
"id": "qqwc-cejz",
"resource_name": null,
"parent_fxf": [],
"description": "39 sheets of data, each sheet representing a table from the database that stores the information. The order of the sheets is based on the sequence of reporting forms for the Financial Transactions Report.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2021-03-09T23:43:42.000Z",
"createdAt": "2014-09-03T19:04:17.000Z",
"metadata_updated_at": "2021-03-09T23:43:42.000Z",
"data_updated_at": "2014-09-03T19:04:17.000Z",
"page_views": {
"page_views_last_week": 15,
"page_views_last_month": 61,
"page_views_total": 22507,
"page_views_last_week_log": 4,
"page_views_last_month_log": 5.954196310386876,
"page_views_total_log": 14.458150248057557
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 15990,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=binary",
"hide_from_data_json": false,
"publication_date": "2014-09-03T19:04:17.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Raw Data",
"domain_tags": [
"raw data",
"city"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/qqwc-cejz",
"link": "https://bythenumbers.sco.ca.gov/Raw-Data/Cities-Raw-Data-for-Fiscal-Years-2002-03-to-2015-1/qqwc-cejz",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Counties Raw Data for Fiscal Years 2002-03 to 2015-16",
"id": "esdm-5xr2",
"resource_name": null,
"parent_fxf": [],
"description": "33 sheets of data, each sheet representing a table from the database that stores the information. The order of these sheets is based on the sequence of reporting forms in the Financial Transactions Report.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2021-03-10T23:27:32.000Z",
"createdAt": "2014-09-02T20:10:30.000Z",
"metadata_updated_at": "2021-03-10T23:27:32.000Z",
"data_updated_at": "2014-09-02T20:10:30.000Z",
"page_views": {
"page_views_last_week": 22,
"page_views_last_month": 223,
"page_views_total": 21925,
"page_views_last_week_log": 4.523561956057013,
"page_views_last_month_log": 7.807354922057604,
"page_views_total_log": 14.420355022089067
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 13955,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=binary",
"hide_from_data_json": false,
"publication_date": "2014-09-02T20:10:30.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Raw Data",
"domain_tags": [
"county",
"raw data"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/esdm-5xr2",
"link": "https://bythenumbers.sco.ca.gov/Raw-Data/Counties-Raw-Data-for-Fiscal-Years-2002-03-to-2015/esdm-5xr2",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "City Expenditures Per Capita",
"id": "ykhf-vfsr",
"resource_name": null,
"parent_fxf": [],
"description": "Per capita values are calculated by dividing the estimated population into total expenditures per city, per fiscal year.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-01-13T22:05:35.000Z",
"createdAt": "2017-12-28T21:07:15.000Z",
"metadata_updated_at": "2026-01-13T22:05:33.000Z",
"data_updated_at": "2026-01-13T22:05:35.000Z",
"page_views": {
"page_views_last_week": 66,
"page_views_last_month": 200,
"page_views_total": 19863,
"page_views_last_week_log": 6.066089190457772,
"page_views_last_month_log": 7.651051691178929,
"page_views_total_log": 14.27786854617684
},
"columns_name": [
"Fiscal Year",
"Total Expenditures",
"Estimated Population",
"Expenditures Per Capita",
"Entity Name"
],
"columns_field_name": [
"fiscal_year",
"total_expenditures",
"estimated_population",
"expenditures_per_capita",
"entity_name"
],
"columns_datatype": [
"Number",
"Number",
"Number",
"Number",
"Text"
],
"columns_description": [
"",
"",
"",
"",
""
],
"columns_format": [
{
"precisionStyle": "standard",
"noCommas": "true",
"precision": "0",
"align": "right"
},
{
"precision": "0"
},
{
"precision": "0",
"groupSeparator": ","
},
{
"precision": "0"
},
{}
],
"download_count": 8288,
"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": "2025-12-29T21:45:25.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Cities",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/ykhf-vfsr",
"link": "https://bythenumbers.sco.ca.gov/Cities/City-Expenditures-Per-Capita/ykhf-vfsr",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Transit Operators Raw Data for Fiscal Years 2002-03 to 2016-17",
"id": "ez7u-5dub",
"resource_name": null,
"parent_fxf": [],
"description": "11 sheets of data, each sheet representing a table from the database that stores the information. The order of the sheets is based on the sequence of reporting forms for the Financial Transactions Report.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2021-06-01T21:28:33.000Z",
"createdAt": "2015-04-02T16:28:32.000Z",
"metadata_updated_at": "2021-06-01T21:28:33.000Z",
"data_updated_at": "2015-04-02T16:28:32.000Z",
"page_views": {
"page_views_last_week": 14,
"page_views_last_month": 357,
"page_views_total": 19653,
"page_views_last_week_log": 3.9068905956085187,
"page_views_last_month_log": 8.483815777264256,
"page_views_total_log": 14.262535340526284
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 10762,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=binary",
"hide_from_data_json": false,
"publication_date": "2015-04-02T16:28:32.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Raw Data",
"domain_tags": [
"transit",
"raw data"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/ez7u-5dub",
"link": "https://bythenumbers.sco.ca.gov/Raw-Data/Transit-Operators-Raw-Data-for-Fiscal-Years-2002-0/ez7u-5dub",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Assessed Valuation Raw Data for Fiscal Years 2002-03 to 2025-26",
"id": "qky3-f2m4",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2026-05-04T16:25:45.000Z",
"createdAt": "2015-02-27T17:58:59.000Z",
"metadata_updated_at": "2026-05-04T16:25:45.000Z",
"data_updated_at": "2015-02-27T17:58:59.000Z",
"page_views": {
"page_views_last_week": 25,
"page_views_last_month": 80,
"page_views_total": 19388,
"page_views_last_week_log": 4.700439718141093,
"page_views_last_month_log": 6.339850002884625,
"page_views_total_log": 14.242950776999097
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 16874,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
"hide_from_data_json": false,
"publication_date": "2015-02-27T17:58:59.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Raw Data",
"domain_tags": [
"raw data",
"assessed valuation",
"av"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/qky3-f2m4",
"link": "https://bythenumbers.sco.ca.gov/Raw-Data/Assessed-Valuation-Raw-Data-for-Fiscal-Years-2002-/qky3-f2m4",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
{
"resource": {
"name": "Special Districts Raw Data for Fiscal Years 2002-03 to 2015-16",
"id": "vi4x-fbus",
"resource_name": null,
"parent_fxf": [],
"description": "18 sheets of data, each sheet representing a table from the database that stores the information. The order of the sheets is based on the sequence of reporting forms for the Financial Transactions Report.",
"attribution": "California State Controller's Office",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2021-03-09T22:54:16.000Z",
"createdAt": "2014-11-06T21:50:53.000Z",
"metadata_updated_at": "2021-03-09T22:54:16.000Z",
"data_updated_at": "2014-11-06T21:50:53.000Z",
"page_views": {
"page_views_last_week": 23,
"page_views_last_month": 45,
"page_views_total": 18586,
"page_views_last_week_log": 4.584962500721157,
"page_views_last_month_log": 5.523561956057013,
"page_views_total_log": 14.182006313099631
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 11495,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet; charset=binary",
"hide_from_data_json": false,
"publication_date": "2014-11-06T21:50:53.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Raw Data",
"domain_tags": [
"special districts",
"raw data"
],
"domain_metadata": []
},
"metadata": {
"domain": "bythenumbers.sco.ca.gov",
"license": "Public Domain"
},
"permalink": "https://bythenumbers.sco.ca.gov/d/vi4x-fbus",
"link": "https://bythenumbers.sco.ca.gov/Raw-Data/Special-Districts-Raw-Data-for-Fiscal-Years-2002-0/vi4x-fbus",
"owner": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
},
"creator": {
"id": "w7vx-4n3g",
"user_type": "interactive",
"display_name": "Matthew"
}
},
"… 10 more items"
],
"resultSetSize": 170,
"timings": {
"serviceMillis": 28,
"searchMillis": [
15,
5
]
},
"warnings": []
}Attribution: Source: bythenumbers.sco.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 bythenumbers.sco.ca.gov (bythenumbers-sco-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 "bythenumbers-sco-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 bythenumbers.sco.ca.gov (bythenumbers-sco-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=hsq2-txxj. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "bythenumbers-sco-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 bythenumbers.sco.ca.gov (bythenumbers-sco-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 "bythenumbers-sco-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 bythenumbers.sco.ca.gov (bythenumbers-sco-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=hsq2-txxj. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "bythenumbers-sco-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>