cthru.data.socrata.com
Governmentcthru.data.socrata.com
Socrata open data portal at cthru.data.socrata.com, publishing 52 public datasets from the publishing organisation, led by the Government category.
Capabilities (5)
GET /v1/data/cthru-data-socrata-com/catalog-search1 creditKeyword search over the datasets published on cthru.data.socrata.com: 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/cthru-data-socrata-com/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/cthru-data-socrata-com/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/cthru-data-socrata-com/row-count1 creditOne number: how many rows the dataset currently holds, as a SoQL count aggregate.
GET /v1/data/cthru-data-socrata-com/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 cthru-data-socrata-com/catalog-search (Catalogue search). A sample, not live data.
Example truncated, full shape in JSON from the API.
{
"results": [
{
"resource": {
"name": "CTHRU Stabilization (\"Rainy Day\") Fund",
"id": "eqrd-tdvi",
"resource_name": null,
"parent_fxf": [
"b3jr-nhhr",
"ukpj-biwy",
"5v4s-nq74"
],
"description": "The Commonwealth Stabilization (\"Rainy Day\") Fund accounts for amounts calculated in accordance with state finance law and maintains a reserve to enhance the fiscal stability of the Commonwealth of Massachusetts.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-10-05T15:05:37.160Z",
"createdAt": "2019-03-18T20:25:58.000Z",
"metadata_updated_at": "2026-10-05T15:05:37.000Z",
"data_updated_at": "2026-10-05T15:05:37.160Z",
"page_views": {
"page_views_last_week": 99,
"page_views_last_month": 308,
"page_views_total": 31254,
"page_views_last_week_log": 6.643856189774725,
"page_views_last_month_log": 8.271463027904375,
"page_views_total_log": 14.93179938206619
},
"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": "2019-03-18T21:55:24.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/stories/s/eqrd-tdvi",
"link": "https://cthru.data.socrata.com/stories/s/eqrd-tdvi",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
{
"resource": {
"name": "Settlements & Judgements",
"id": "tq8s-u87j",
"resource_name": null,
"parent_fxf": [
"gpqz-7ppn",
"6j38-k6fr"
],
"description": "Information about payments for settlements and judgments processed by the Office of Comptroller under 815 CMR 5.00.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2025-01-10T14:28:15.909Z",
"createdAt": "2018-04-10T13:46:10.000Z",
"metadata_updated_at": "2025-11-19T14:15:21.000Z",
"data_updated_at": "2025-01-10T14:28:15.909Z",
"page_views": {
"page_views_last_week": 53,
"page_views_last_month": 186,
"page_views_total": 22116,
"page_views_last_week_log": 5.754887502163469,
"page_views_last_month_log": 7.546894459887637,
"page_views_total_log": 14.432868087968135
},
"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": "2018-04-10T13:46:10.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": [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 cthru.data.socrata.com (cthru-data-socrata-com) 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 "cthru-data-socrata-com" 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 cthru.data.socrata.com (cthru-data-socrata-com) 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=8cuw-w57y. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cthru-data-socrata-com" 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 cthru.data.socrata.com (cthru-data-socrata-com) 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 "cthru-data-socrata-com" 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 cthru.data.socrata.com (cthru-data-socrata-com) 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=8cuw-w57y. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "cthru-data-socrata-com" 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
Datasets on this portal declare the licence "Public Domain U.S. Government" 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.
https://cthru.data.socrata.com/Attribution
Display this wherever you show the data. It arrives on every response as provenance.attribution_text.
Source: cthru.data.socrata.com. Dataset attribution as stated by each publishing agency.
Cache: up to 3600s