fastCRW Pergamon
Government
datahub.smcgov.org
datahub.smcgov.org
Socrata open data portal at datahub.smcgov.org, publishing 1379 public datasets from the publishing organisation, led by the Government category.
Showing the catalogue
GET /v1/data/datahub-smcgov-org/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/datahub-smcgov-org/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from datahub.smcgov.org.
JSON
{
"results": [
{
"resource": {
"name": "Job Classification Table: Table View",
"id": "exxw-88ki",
"resource_name": null,
"parent_fxf": [
"i4fw-626v"
],
"description": "Position & Salary information for San Mateo County Job Classifications",
"attribution": "Human Resources Department of San Mateo County",
"attribution_link": "https://www.smcgov.org/hr",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-10-23T16:00:08.000Z",
"createdAt": "2015-03-30T21:23:20.000Z",
"metadata_updated_at": "2025-01-30T04:28:27.000Z",
"data_updated_at": "2026-10-23T16:00:08.000Z",
"page_views": {
"page_views_last_week": 13,
"page_views_last_month": 72,
"page_views_total": 110164,
"page_views_last_week_log": 3.8073549220576037,
"page_views_last_month_log": 6.189824558880018,
"page_views_total_log": 16.74930641933737
},
"columns_name": [
"Biweekly-B",
"DMV A and D Testing (Some Positions in Class)",
"Work Group",
"Probation Period (Hours)",
"Tuberculosis Exam",
"Exit Exam",
"Hepatitis B Immunization",
"Security Clearance",
"Respiratory Exam",
"Hourly-D",
"… 23 more items"
],
"columns_field_name": [
"biweekly_b",
"dmv_a_and_d_testing_some_positions_in_class",
"work_group",
"probation_period_hours",
"tuberculosis_exam",
"exit_exam",
"hepatitis_b_immunization",
"security_clearance",
"respiratory_exam",
"hourly_d",
"… 23 more items"
],
"columns_datatype": [
"Number",
"Text",
"Text",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"Number",
"… 23 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 23 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{},
{},
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
"… 23 more items"
],
"download_count": 4771,
"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-03-30T20:11:23.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": [
{
"key": "Departments_Department",
"value": "Human Resources"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org"
},
"permalink": "https://datahub.smcgov.org/d/exxw-88ki",
"link": "https://datahub.smcgov.org/Government/Job-Classification-Table-Table-View/exxw-88ki",
"owner": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
},
"creator": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
}
},
{
"resource": {
"name": "Job Classification Table (JCT)",
"id": "i4fw-626v",
"resource_name": null,
"parent_fxf": [],
"description": "Position & Salary information for San Mateo County Job Classifications",
"attribution": "Human Resources Department of San Mateo County",
"attribution_link": "https://www.smcgov.org/hr",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T16:00:08.000Z",
"createdAt": "2015-03-30T19:54:37.000Z",
"metadata_updated_at": "2025-01-13T21:48:57.000Z",
"data_updated_at": "2026-10-23T16:00:08.000Z",
"page_views": {
"page_views_last_week": 221,
"page_views_last_month": 929,
"page_views_total": 92986,
"page_views_last_week_log": 7.794415866350106,
"page_views_last_month_log": 9.861086905995393,
"page_views_total_log": 16.50474141462507
},
"columns_name": [
"Biweekly-F",
"Hourly-B",
"Title",
"Respiratory Exam",
"Monthly-E",
"Biweekly-A",
"Hourly-D",
"Representation Status / Bargaining Unit",
"Maximum Hourly",
"Monthly-B",
"… 25 more items"
],
"columns_field_name": [
"biweekly_f",
"hourly_b",
"title",
"respiratory_exam",
"monthly_e",
"biweekly_a",
"hourly_d",
"representation_status_bargaining_unit",
"maximum_hourly",
"monthly_b",
"… 25 more items"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Number",
"Number",
"Number",
"Text",
"Number",
"Number",
"… 25 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 25 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"
},
"… 25 more items"
],
"download_count": 7341,
"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": "2023-07-26T15:57:11.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": [
{
"key": "Departments_Department",
"value": "Human Resources"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org"
},
"permalink": "https://datahub.smcgov.org/d/i4fw-626v",
"link": "https://datahub.smcgov.org/Government/Job-Classification-Table-JCT-/i4fw-626v",
"owner": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
},
"creator": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
}
},
{
"resource": {
"name": "Your Tax Dollars at Work",
"id": "uzxy-yhzg",
"resource_name": null,
"parent_fxf": [],
"description": "Breakdown of what percent of each tax dollar paid to the County is spent. Using Shared Vision 2025 community outcomes as the long-term direction for County programs and services, the budget allocates resources to those areas that can significantly contribute to building a healthy, safe, livable, prosperous, environmentally conscious and sustainable community.",
"attribution": "County Manager's Office, County of San Mateo",
"attribution_link": "https://cmo.smcgov.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2018-03-28T17:00:20.000Z",
"createdAt": "2018-03-28T16:55:23.000Z",
"metadata_updated_at": "2018-03-28T17:00:20.000Z",
"data_updated_at": "2018-03-28T16:55:25.000Z",
"page_views": {
"page_views_last_week": 2,
"page_views_last_month": 22,
"page_views_total": 9469,
"page_views_last_week_log": 1.5849625007211563,
"page_views_last_month_log": 4.523561956057013,
"page_views_total_log": 13.209148710355748
},
"columns_name": [
"Percent",
"Entity"
],
"columns_field_name": [
"percent",
"entity"
],
"columns_datatype": [
"Number",
"Text"
],
"columns_description": [
"",
""
],
"columns_format": [
{
"precisionStyle": "percentage",
"percentScale": "100",
"decimalSeparator": ".",
"groupSeparator": ","
},
{}
],
"download_count": 121,
"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-03-28T17:00:20.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"budget",
"taxes"
],
"domain_metadata": [
{
"key": "Performance-Management_Measure-A-program-title",
"value": ""
},
{
"key": "Performance-Management_Target-met",
"value": ""
},
{
"key": "Performance-Management_Benchmark-met",
"value": ""
},
{
"key": "Performance-Management_Measure-ID",
"value": ""
},
{
"key": "Performance-Management_Notes",
"value": ""
},
{
"key": "Performance-Management_JL-code",
"value": ""
},
{
"key": "Dimensions_Spatial",
"value": ""
},
{
"key": "Dimensions_Temporal",
"value": "2018 -"
},
{
"key": "Departments_Department",
"value": "County Managers Office"
},
{
"key": "Updates_Update-period",
"value": "Annually"
},
"… 1 more items"
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/uzxy-yhzg",
"link": "https://datahub.smcgov.org/Government/Your-Tax-Dollars-at-Work/uzxy-yhzg",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
{
"resource": {
"name": "Educational Attainment",
"id": "mb6a-xn89",
"resource_name": null,
"parent_fxf": [],
"description": "This dataset contains data about the highest grade completed by residents of San Mateo County by city. Grade levels include less than high school graduate, high school graduate, some college or associate's degree, and bachelor's degree or higher. This data was extracted from the United States Cenus Bureau's American Community Survey 2014 5 year estimates.",
"attribution": "United States Census Bureau American Community Survey",
"attribution_link": "http://factfinder.census.gov/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-12-15T19:37:44.000Z",
"createdAt": "2015-12-15T16:42:25.000Z",
"metadata_updated_at": "2015-12-15T19:37:44.000Z",
"data_updated_at": "2015-12-15T16:42:41.000Z",
"page_views": {
"page_views_last_week": 14,
"page_views_last_month": 52,
"page_views_total": 6314,
"page_views_last_week_log": 3.9068905956085187,
"page_views_last_month_log": 5.7279204545632,
"page_views_total_log": 12.624567018674915
},
"columns_name": [
"Census Designated Places",
"Location 1 (address)",
"Location 1",
"Bachelor's Degree or Higher",
"Some College or Associate's Degree",
"Less Than High School Graduate",
"Year",
"High School Graduate",
"Geography",
"Location 1 (state)",
"… 4 more items"
],
"columns_field_name": [
":@computed_region_uph5_8hpn",
"location_1_address",
"location_1",
"bachelor_s_degree_or_higher",
"some_college_or_associate_s_degree",
"less_than_high_school_graduate",
"year",
"high_school_graduate",
"geography",
"location_1_state",
"… 4 more items"
],
"columns_datatype": [
"Number",
"Text",
"Point",
"Number",
"Number",
"Number",
"Calendar date",
"Number",
"Text",
"Text",
"… 4 more items"
],
"columns_description": [
"This column was automatically created in order to record in what polygon from the dataset 'Census Designated Places' (uph5-8hpn) the point in column 'location_1' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 4 more items"
],
"columns_format": [
{},
{},
{},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{
"view": "date_y",
"align": "left"
},
{
"precisionStyle": "percentage",
"percentScale": "100",
"view": "percent_bar_and_text"
},
{},
{},
"… 4 more items"
],
"download_count": 654,
"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-12-15T16:50:15.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"education",
"school",
"opportunity",
"grade level"
],
"domain_metadata": [
{
"key": "Updates_Update-period",
"value": "Annually"
},
{
"key": "Dimensions_Temporal",
"value": "2014"
},
{
"key": "Departments_Department",
"value": "County Managers Office"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain U.S. Government"
},
"permalink": "https://datahub.smcgov.org/d/mb6a-xn89",
"link": "https://datahub.smcgov.org/Government/Educational-Attainment/mb6a-xn89",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
{
"resource": {
"name": "Restaurant Health Inspections",
"id": "pjzf-pe8z",
"resource_name": null,
"parent_fxf": [],
"description": "Inspection results are available online 14 days after the inspector's visit. To file a complaint about a food facility in San Mateo County call (650) 372-6200, email EnvHealth@smcgov.org, or use our Online Complaint Form and submit your complaint online: http://www.smchealth.org/ehcomplaint\r\n\r\nSome addresses for inspection results are located outside of San Mateo County. In these cases, this is likely the business address for a company that has provided food services within the County. In many cases, this is a caterer or other service provider for an event or similarly temporary location.\r\n\r\nCode definitions for violations and inspection results are attached to this metadata. Many thanks to Tom Cox of OpenSMC for creating this glossary.",
"attribution": "County of San Mateo Health System",
"attribution_link": "http://www.smchealth.org/foodinspections",
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-01-24T22:32:39.000Z",
"createdAt": "2015-01-12T23:16:36.000Z",
"metadata_updated_at": "2022-01-24T22:32:37.000Z",
"data_updated_at": "2022-01-24T22:32:39.000Z",
"page_views": {
"page_views_last_week": 31,
"page_views_last_month": 71,
"page_views_total": 6093,
"page_views_last_week_log": 5,
"page_views_last_month_log": 6.169925001442312,
"page_views_total_log": 12.573173784686485
},
"columns_name": [
"Zip Codes",
"Location ID",
"Zip",
"Service Code",
"Result Code",
"Violation Code",
"Location Name",
"Address",
"City",
"Daily Location ID",
"… 11 more items"
],
"columns_field_name": [
":@computed_region_i2t2_cryp",
"tb_core_daily_record_id1",
"zip",
"service1",
"result_code1",
"violation_code1",
"facility_name1",
"site_address",
"city1",
"tb_core_daily_pe1",
"… 11 more items"
],
"columns_datatype": [
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 11 more items"
],
"columns_description": [
"",
"Identification code for the food service site",
"Site Zip Code",
"Inspection reason code",
"Inspection result code",
"Code for the violation type",
"Site name",
"Business address of the site",
"Facility city",
"Site type code",
"… 11 more items"
],
"columns_format": [
{},
{
"displayStyle": "plain",
"align": "left"
},
{},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"displayStyle": "plain",
"align": "left"
},
"… 11 more items"
],
"download_count": 5917,
"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-07-09T23:51:57.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [
"inspections",
"restaurants",
"violations",
"food"
],
"domain_metadata": [
{
"key": "Dimensions_Temporal",
"value": "2013 -"
},
{
"key": "Departments_Department",
"value": "Health System"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/pjzf-pe8z",
"link": "https://datahub.smcgov.org/dataset/Restaurant-Health-Inspections/pjzf-pe8z",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
{
"resource": {
"name": "Secured Property Taxes",
"id": "pmvw-bs84",
"resource_name": null,
"parent_fxf": [],
"description": "Secured, unitary, and railroad property tax data, by parcel, for the County of San Mateo, as of the January 1 lien date.\r\n\r\nMore information about secured property taxes in the County can be found on the County's Treasurer-Tax Collector site: http://www.sanmateocountytaxcollector.org/securedTaxes.html",
"attribution": "County of San Mateo Treasurer-Tax Collector",
"attribution_link": "http://www.sanmateocountytaxcollector.org/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2019-04-15T16:22:09.000Z",
"createdAt": "2016-11-04T17:07:49.000Z",
"metadata_updated_at": "2019-04-15T16:21:45.000Z",
"data_updated_at": "2019-04-15T16:22:09.000Z",
"page_views": {
"page_views_last_week": 11,
"page_views_last_month": 58,
"page_views_total": 5957,
"page_views_last_week_log": 3.5849625007211565,
"page_views_last_month_log": 5.882643049361842,
"page_views_total_log": 12.540612408249531
},
"columns_name": [
"Special Assessments",
"TRA",
"2nd Installment",
"Fiscal Year",
"1st Installment",
"Tax Rate",
"Exemption",
"Parcel Number",
"Situs Address",
"Total Charge",
"… 3 more items"
],
"columns_field_name": [
"special_assessments",
"tra",
"_2nd_installment_charge",
"date",
"_1st_installment_charge",
"composite_rate",
"exemption",
"parcel_number",
"situs_address",
"total_charge",
"… 3 more items"
],
"columns_datatype": [
"Number",
"Text",
"Number",
"Text",
"Number",
"Number",
"Number",
"Text",
"Text",
"Number",
"… 3 more items"
],
"columns_description": [
"",
"",
"",
"July 1 - June 30",
"",
"General taxes and debt service",
"",
"",
"",
"",
"… 3 more items"
],
"columns_format": [
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"displayStyle": "plain",
"align": "left"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"noCommas": "false",
"precision": "4",
"align": "right",
"percentScale": "100",
"precisionStyle": "percentage",
"view": "percent_text"
},
{
"precision": "0",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{},
{},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
"… 3 more items"
],
"download_count": 588,
"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-03-19T05:05:49.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"real estate",
"taxes",
"property"
],
"domain_metadata": [
{
"key": "Dimensions_Temporal",
"value": "2015 -"
},
{
"key": "Departments_Department",
"value": "Tax Collector / Treasurer"
},
{
"key": "Updates_Update-period",
"value": "Annually"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/pmvw-bs84",
"link": "https://datahub.smcgov.org/Government/Secured-Property-Taxes/pmvw-bs84",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
{
"resource": {
"name": "Employee salary data",
"id": "29rh-6e32",
"resource_name": null,
"parent_fxf": [],
"description": "Salaries and compensation for all employees of the County of San Mateo [Note: 2020 salaries are based on 27 pay periods due to leap year]",
"attribution": "San Mateo County",
"attribution_link": "http://smcgov.org",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-02-12T20:34:31.000Z",
"createdAt": "2016-02-25T23:44:46.000Z",
"metadata_updated_at": "2026-02-12T20:34:31.000Z",
"data_updated_at": "2026-02-12T20:32:47.000Z",
"page_views": {
"page_views_last_week": 5,
"page_views_last_month": 30,
"page_views_total": 5682,
"page_views_last_week_log": 2.584962500721156,
"page_views_last_month_log": 4.954196310386876,
"page_views_total_log": 12.472437000051329
},
"columns_name": [
"Name",
"Job Title",
"Department Name",
"Regular Pay",
"Overtime Pay",
"Other Pay",
"Total Gross Pay",
"Employer Share of Health Benefits",
"Employer Share of Retirement",
"Employer Pick Up of Employee Share of Retirement",
"… 4 more items"
],
"columns_field_name": [
"name",
"job_title",
"department_name",
"regular_pay",
"overtime",
"other_pay",
"gross_pay",
"employer_share_of_health_benefits",
"employer_share_of_retirement",
"employer_pick_up_of_employee_share_of_retirement",
"… 4 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"Number",
"… 4 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"(Includes but is not limited to differentials, special pay, transportation and uniform allowance, management leave, recoupment of overpayments and terminal pay)",
"(Due to rounding numbers may vary by less than .50)",
"",
"",
"",
"… 4 more items"
],
"columns_format": [
{},
{
"align": "left"
},
{
"align": "left"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
"… 4 more items"
],
"download_count": 472,
"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-02-15T18:29:59.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"pay"
],
"domain_metadata": [
{
"key": "Dimensions_Temporal",
"value": "2012 - 2025"
},
{
"key": "Departments_Department",
"value": "Human Resources"
},
{
"key": "Updates_Update-period",
"value": "Annually"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/29rh-6e32",
"link": "https://datahub.smcgov.org/Government/Employee-salary-data/29rh-6e32",
"owner": {
"id": "d54x-xuec",
"user_type": "interactive",
"display_name": "Lisa Yapching"
},
"creator": {
"id": "d54x-xuec",
"user_type": "interactive",
"display_name": "Lisa Yapching"
}
},
{
"resource": {
"name": "Employee Salary Data 2016",
"id": "knbq-332g",
"resource_name": null,
"parent_fxf": [
"29rh-6e32"
],
"description": "Salaries and compensation for all employees of the County of San Mateo",
"attribution": "San Mateo County",
"attribution_link": "http://smcgov.org",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-02-12T20:32:47.000Z",
"createdAt": "2017-03-02T23:28:14.000Z",
"metadata_updated_at": "2025-01-30T04:29:35.000Z",
"data_updated_at": "2026-02-12T20:32:47.000Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 38,
"page_views_total": 5374,
"page_views_last_week_log": 3,
"page_views_last_month_log": 5.285402218862249,
"page_views_total_log": 12.392049039364187
},
"columns_name": [
"Name",
"Regular Pay",
"Overtime Pay",
"Other Pay",
"Other Employer Costs",
"Date",
"Job Title",
"Department Name",
"Total Gross Pay",
"Employer Share of Health Benefits",
"… 4 more items"
],
"columns_field_name": [
"name",
"regular_pay",
"overtime",
"other_pay",
"other_employer_cost",
"date",
"job_title",
"department_name",
"gross_pay",
"employer_share_of_health_benefits",
"… 4 more items"
],
"columns_datatype": [
"Text",
"Number",
"Number",
"Number",
"Number",
"Calendar date",
"Text",
"Text",
"Number",
"Number",
"… 4 more items"
],
"columns_description": [
"",
"",
"",
"(Includes but is not limited to differentials, special pay, transportation and uniform allowance, management leave, recoupment of overpayments and terminal pay)",
"(Includes but is not limited to the County's contribution towards workers comp insurance and state unemployment insurance)",
"",
"",
"",
"(Due to rounding numbers may vary by less than .50)",
"",
"… 4 more items"
],
"columns_format": [
{},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"view": "date_y",
"align": "left"
},
{
"align": "left"
},
{
"align": "left"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
{
"precision": "2",
"align": "right",
"currencyStyle": "USD",
"humane": "false",
"precisionStyle": "currency"
},
"… 4 more items"
],
"download_count": 585,
"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-02T23:22:38.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"pay"
],
"domain_metadata": [
{
"key": "Dimensions_Temporal",
"value": "2012- 2016"
},
{
"key": "Departments_Department",
"value": "Human Resources"
},
{
"key": "Updates_Update-period",
"value": "Annually"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/knbq-332g",
"link": "https://datahub.smcgov.org/Government/Employee-Salary-Data-2016/knbq-332g",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
{
"resource": {
"name": "Job Classification Table with Position Summary View",
"id": "np9a-mk4k",
"resource_name": null,
"parent_fxf": [
"i4fw-626v"
],
"description": "Position & Salary information for San Mateo County Job Classifications",
"attribution": "Human Resources Department of San Mateo County",
"attribution_link": "https://www.smcgov.org/hr",
"contact_email": null,
"type": "filter",
"updatedAt": "2026-10-23T16:00:08.000Z",
"createdAt": "2015-03-30T21:23:46.000Z",
"metadata_updated_at": "2025-01-30T04:30:04.000Z",
"data_updated_at": "2026-10-23T16:00:08.000Z",
"page_views": {
"page_views_last_week": 9,
"page_views_last_month": 82,
"page_views_total": 4781,
"page_views_last_week_log": 3.3219280948873626,
"page_views_last_month_log": 6.375039431346925,
"page_views_total_log": 12.223398414711628
},
"columns_name": [
"Biweekly-E",
"Respiratory Exam",
"Probation Period (Hours)",
"Work Group",
"Tuberculosis Exam",
"Auditory Exam",
"Exit Exam",
"Security Clearance",
"Hepatitis B Immunization",
"DMV A and D Testing",
"… 23 more items"
],
"columns_field_name": [
"biweekly_e",
"respiratory_exam",
"probation_period_hours",
"work_group",
"tuberculosis_exam",
"auditory_exam",
"exit_exam",
"security_clearance",
"hepatitis_b_immunization",
"dmv_a_and_d_testing",
"… 23 more items"
],
"columns_datatype": [
"Number",
"Text",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 23 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 23 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"currencyStyle": "USD",
"precision": "2"
},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 23 more items"
],
"download_count": 274,
"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-03-30T20:11:23.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": [
{
"key": "Departments_Department",
"value": "Human Resources"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org"
},
"permalink": "https://datahub.smcgov.org/d/np9a-mk4k",
"link": "https://datahub.smcgov.org/Government/Job-Classification-Table-with-Position-Summary-Vie/np9a-mk4k",
"owner": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
},
"creator": {
"id": "ucim-h8wx",
"user_type": "interactive",
"display_name": "Kelly Hoang"
}
},
{
"resource": {
"name": "Reports from Report It! SMC",
"id": "4u6x-x6rk",
"resource_name": null,
"parent_fxf": [],
"description": "Report It! SMC allows citizens, residents, and visitors to report illegal dumping issues quickly and easily via web tools and mobile apps. You can even take photos of issues and submit them on your phone! These reports are then forwarded directly to County departments to respond and address.",
"attribution": "North Fair Oaks Forward",
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T01:00:08.000Z",
"createdAt": "2015-06-17T19:48:12.000Z",
"metadata_updated_at": "2026-01-02T17:32:08.000Z",
"data_updated_at": "2026-10-23T01:00:08.000Z",
"page_views": {
"page_views_last_week": 3,
"page_views_last_month": 23,
"page_views_total": 3256,
"page_views_last_week_log": 2,
"page_views_last_month_log": 4.584962500721157,
"page_views_total_log": 11.669328004395904
},
"columns_name": [
"Minutes to closed",
"Zip Codes",
"Status",
"Count",
"Reported using mobile?",
"Rating",
"Category",
"Minutes to acknowledged",
"Reopened at local",
"Updated at local",
"… 10 more items"
],
"columns_field_name": [
"minutes_to_closed",
":@computed_region_i2t2_cryp",
"status",
"count",
"reported_using_mobile",
"rating",
"category",
"minutes_to_acknowledged",
"reopened_at_local",
"updated_at_local",
"… 10 more items"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Number",
"Number",
"Number",
"Text",
"Number",
"Calendar date",
"Calendar date",
"… 10 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 10 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{
"view": "date_time"
},
{
"view": "date_time"
},
"… 10 more items"
],
"download_count": 384,
"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-05-28T18:52:01.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Environment",
"domain_tags": [
"services",
"trash",
"311",
"illegal dumping"
],
"domain_metadata": [
{
"key": "Dimensions_Temporal",
"value": "20150531 -"
},
{
"key": "Departments_Department",
"value": "County Managers Office"
},
{
"key": "Updates_Update-period",
"value": "Daily"
}
]
},
"metadata": {
"domain": "datahub.smcgov.org",
"license": "Public Domain"
},
"permalink": "https://datahub.smcgov.org/d/4u6x-x6rk",
"link": "https://datahub.smcgov.org/Environment/Reports-from-Report-It-SMC/4u6x-x6rk",
"owner": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
},
"creator": {
"id": "4uzi-bw65",
"user_type": "interactive",
"display_name": "John Ridener"
}
},
"… 10 more items"
],
"resultSetSize": 1379,
"timings": {
"serviceMillis": 23,
"searchMillis": [
7,
5
]
},
"warnings": []
}Attribution: Source: datahub.smcgov.org. 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 datahub.smcgov.org (datahub-smcgov-org) 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 "datahub-smcgov-org" 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 datahub.smcgov.org (datahub-smcgov-org) 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=jswj-6gxx. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datahub-smcgov-org" 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 datahub.smcgov.org (datahub-smcgov-org) 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 "datahub-smcgov-org" 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 datahub.smcgov.org (datahub-smcgov-org) 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=jswj-6gxx. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "datahub-smcgov-org" 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>