cthru.data.socrata.com
cthru.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.
GET /v1/data/cthru-data-socrata-com/catalog-search1Request
Full-text query over dataset names and descriptions.
Zero-based offset into the results; step by 20 to page.
curl "https://api.fastcrw.com/v1/data/cthru-data-socrata-com/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from cthru.data.socrata.com.
{
"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": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/stories/s/tq8s-u87j",
"link": "https://cthru.data.socrata.com/stories/s/tq8s-u87j",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
{
"resource": {
"name": "CTHRU Budgets",
"id": "vys2-y3d6",
"resource_name": null,
"parent_fxf": [
"cqdr-v9ez",
"kv7m-35wn"
],
"description": "Data on budget-to-actual spending in Commonwealth of Massachusetts budgeted fund accounts, dating back to Fiscal Year 2005, and updated daily.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-09-15T15:11:18.217Z",
"createdAt": "2019-07-17T14:22:04.000Z",
"metadata_updated_at": "2026-09-15T15:11:18.000Z",
"data_updated_at": "2026-09-15T15:11:18.217Z",
"page_views": {
"page_views_last_week": 50,
"page_views_last_month": 197,
"page_views_total": 22017,
"page_views_last_week_log": 5.672425341971496,
"page_views_last_month_log": 7.6293566200796095,
"page_views_total_log": 14.42639580752872
},
"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-07-17T14:28:31.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/vys2-y3d6",
"link": "https://cthru.data.socrata.com/stories/s/vys2-y3d6",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
{
"resource": {
"name": "Commonwealth Of Massachusetts Payroll v4",
"id": "9ttk-7vz6",
"resource_name": null,
"parent_fxf": [],
"description": "This is the production dataset for the Statewide Payroll site.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T09:07:14.000Z",
"createdAt": "2022-11-09T19:46:12.000Z",
"metadata_updated_at": "2026-10-23T09:07:14.000Z",
"data_updated_at": "2026-10-23T09:06:43.000Z",
"page_views": {
"page_views_last_week": 140,
"page_views_last_month": 581,
"page_views_total": 19030,
"page_views_last_week_log": 7.139551352398794,
"page_views_last_month_log": 9.184875342908285,
"page_views_total_log": 14.216063750784947
},
"columns_name": [
"A14",
"NAME_LAST",
"POSITION_TYPE",
"A06",
"A20",
"PAY_YEAR_TO_DATE",
"DEPARTMENT_LOCATION_ZIP_CODE",
"CONTRACT",
"BARGAINING_GROUP_NO",
"CREATE_DATE",
"… 20 more items"
],
"columns_field_name": [
"a14",
"name_last",
"position_type",
"a06",
"a20",
"pay_year_to_date",
"department_location_zip_code",
"contract",
"bargaining_group_no",
"create_date",
"… 20 more items"
],
"columns_datatype": [
"Number",
"Text",
"Text",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text",
"Calendar date",
"… 20 more items"
],
"columns_description": [
"Stipends, bonus pay, and awards",
"",
"",
"Stand by pay",
"Police detail",
"",
"",
"",
"",
"",
"… 20 more items"
],
"columns_format": [
{
"precisionStyle": "currency",
"precision": "2"
},
{},
{},
{
"precisionStyle": "currency",
"precision": "2"
},
{
"precisionStyle": "currency",
"precision": "2"
},
{
"precisionStyle": "currency",
"precision": "2"
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{},
"… 20 more items"
],
"download_count": 11147,
"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": "2026-10-23T09:07:14.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/d/9ttk-7vz6",
"link": "https://cthru.data.socrata.com/Government/Commonwealth-Of-Massachusetts-Payroll-v4/9ttk-7vz6",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
{
"resource": {
"name": "Comptroller of the Commonwealth Spending",
"id": "pegc-naaa",
"resource_name": null,
"parent_fxf": [],
"description": "This is the production dataset for the CTHRU Statewide Spending site.",
"attribution": "Comptroller of the Commonwealth of Massachusetts",
"attribution_link": "http://www.mass.gov/comptroller/",
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-23T10:15:41.000Z",
"createdAt": "2016-07-27T18:27:40.000Z",
"metadata_updated_at": "2026-10-23T10:15:41.000Z",
"data_updated_at": "2026-10-23T09:58:03.000Z",
"page_views": {
"page_views_last_week": 80,
"page_views_last_month": 352,
"page_views_total": 15017,
"page_views_last_week_log": 6.339850002884625,
"page_views_last_month_log": 8.46352437327118,
"page_views_total_log": 13.87440507640949
},
"columns_name": [
"Create_Date",
"City",
"Payment_Id",
"Date",
"Cabinet_Secretariat",
"Department",
"Appropriation_Type",
"Appropriation_Name",
"Object_Class",
"Object_Code",
"… 15 more items"
],
"columns_field_name": [
"create_date",
"city",
"payment_id",
"date",
"cabinet_secretariat",
"department",
"appropriation_type",
"appropriation_name",
"object_class",
"object_code",
"… 15 more items"
],
"columns_datatype": [
"Calendar date",
"Text",
"Text",
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 15 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 15 more items"
],
"columns_format": [
{
"view": "date",
"align": "left"
},
{},
{},
{
"view": "date",
"align": "left"
},
{},
{},
{},
{},
{},
{},
"… 15 more items"
],
"download_count": 8408,
"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": "2026-10-23T10:15:41.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com",
"license": "Public Domain U.S. Government"
},
"permalink": "https://cthru.data.socrata.com/d/pegc-naaa",
"link": "https://cthru.data.socrata.com/Government/Comptroller-of-the-Commonwealth-Spending/pegc-naaa",
"owner": {
"id": "q4uv-j5zd",
"user_type": "interactive",
"display_name": "ADMIN"
},
"creator": {
"id": "q4uv-j5zd",
"user_type": "interactive",
"display_name": "ADMIN"
}
},
{
"resource": {
"name": "Quasi Government Payroll As Of",
"id": "v6ig-nmbz",
"resource_name": null,
"parent_fxf": [
"4gjq-gggh"
],
"description": "This story displays the latest payroll data uploaded to CTHRU for each Quasi Agency.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2026-02-19T12:57:59.948Z",
"createdAt": "2018-03-28T13:30:52.000Z",
"metadata_updated_at": "2026-02-19T12:58:00.000Z",
"data_updated_at": "2026-02-19T12:57:59.948Z",
"page_views": {
"page_views_last_week": 13,
"page_views_last_month": 58,
"page_views_total": 8658,
"page_views_last_week_log": 3.8073549220576037,
"page_views_last_month_log": 5.882643049361842,
"page_views_total_log": 13.079984707033974
},
"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-03-28T13:30:53.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/v6ig-nmbz",
"link": "https://cthru.data.socrata.com/stories/s/v6ig-nmbz",
"owner": {
"id": "ykfj-bfed",
"user_type": "interactive",
"display_name": "SA_ADMIN_2"
},
"creator": {
"id": "ykfj-bfed",
"user_type": "interactive",
"display_name": "SA_ADMIN_2"
}
},
{
"resource": {
"name": "CTHRU Non-Budgeted Special Revenue Funds",
"id": "p7hv-rwxq",
"resource_name": null,
"parent_fxf": [
"ggrr-6ytu",
"uaqe-2tpk"
],
"description": "This dataset continues data pertaining to more than 190 non-budgeted special revenue funds and approximately 1,000 trust accounts with dedicated sources of revenue, dating back to 2005.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2024-12-09T20:49:54.978Z",
"createdAt": "2019-09-18T19:11:04.000Z",
"metadata_updated_at": "2025-11-19T14:16:30.000Z",
"data_updated_at": "2024-12-09T20:49:54.978Z",
"page_views": {
"page_views_last_week": 16,
"page_views_last_month": 88,
"page_views_total": 7336,
"page_views_last_week_log": 4.08746284125034,
"page_views_last_month_log": 6.475733430966398,
"page_views_total_log": 12.840974569821883
},
"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-09-26T15:35:47.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/p7hv-rwxq",
"link": "https://cthru.data.socrata.com/stories/s/p7hv-rwxq",
"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 and Judgments",
"id": "gpqz-7ppn",
"resource_name": null,
"parent_fxf": [],
"description": "This is the production dataset is for the Settlement and Judgements Story.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-08T17:47:51.000Z",
"createdAt": "2018-01-23T20:25:19.000Z",
"metadata_updated_at": "2026-10-08T17:47:48.000Z",
"data_updated_at": "2026-10-08T17:47:51.000Z",
"page_views": {
"page_views_last_week": 21,
"page_views_last_month": 72,
"page_views_total": 6758,
"page_views_last_week_log": 4.459431618637297,
"page_views_last_month_log": 6.189824558880018,
"page_views_total_log": 12.722594098956584
},
"columns_name": [
"Paid on Behalf of",
"Budget Fiscal Year",
"Line Amount",
"Payee Name",
"Payment Date",
"Fiscal Quarter",
"Dept Paid on Behalf of"
],
"columns_field_name": [
"paid_on_behalf_of",
"bfy",
"line_amount",
"payee_name",
"payment_date",
"quarter",
"dept_paid_on_behalf_of"
],
"columns_datatype": [
"Text",
"Number",
"Number",
"Text",
"Calendar date",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{
"precisionStyle": "standard",
"noCommas": "true",
"align": "center"
},
{
"precision": "2",
"decimalSeparator": ".",
"align": "right",
"currencyStyle": "USD",
"groupSeparator": ",",
"precisionStyle": "currency"
},
{},
{
"view": "date",
"align": "center"
},
{
"align": "center"
},
{}
],
"download_count": 7081,
"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-11T18:35:14.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/d/gpqz-7ppn",
"link": "https://cthru.data.socrata.com/Government/Settlements-and-Judgments/gpqz-7ppn",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
{
"resource": {
"name": "Total Tax Revenue Collections",
"id": "me5t-fei2",
"resource_name": null,
"parent_fxf": [
"kcy7-ivxi"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "chart",
"updatedAt": "2026-09-01T02:54:43.000Z",
"createdAt": "2019-12-16T21:32:10.000Z",
"metadata_updated_at": "2020-02-14T21:03:18.000Z",
"data_updated_at": "2026-09-01T02:54:43.000Z",
"page_views": {
"page_views_last_week": 10,
"page_views_last_month": 53,
"page_views_total": 3879,
"page_views_last_week_log": 3.4594316186372978,
"page_views_last_month_log": 5.754887502163469,
"page_views_total_log": 11.92184093707449
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 5,
"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": "2020-02-14T21:03:18.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/d/me5t-fei2",
"link": "https://cthru.data.socrata.com/dataset/Total-Tax-Revenue-Collections/me5t-fei2",
"owner": {
"id": "87pw-3s9b",
"user_type": "interactive",
"display_name": "HowardM"
},
"creator": {
"id": "87pw-3s9b",
"user_type": "interactive",
"display_name": "HowardM"
}
},
{
"resource": {
"name": "Retirement Benefits",
"id": "pni4-392n",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-08T17:26:33.000Z",
"createdAt": "2017-11-02T12:40:52.000Z",
"metadata_updated_at": "2026-08-28T19:48:52.000Z",
"data_updated_at": "2026-10-08T17:26:33.000Z",
"page_views": {
"page_views_last_week": 17,
"page_views_last_month": 53,
"page_views_total": 3496,
"page_views_last_week_log": 4.169925001442312,
"page_views_last_month_log": 5.754887502163469,
"page_views_total_log": 11.771902080697718
},
"columns_name": [
"Department_Last_Worked_In",
"Title_At_Retirement",
"Annual_Amount",
"Position_Type",
"Retirement_System",
"Trans_No",
"Last_Name",
"First_Name",
"Date_Of_Retirement",
"Monthly_Amount",
"… 1 more items"
],
"columns_field_name": [
"department_last_worked_in",
"title_at_retirement",
"annual_amount",
"position_type",
"retirement_system",
"trans_no",
"last_name",
"first_name",
"date_of_retirement",
"monthly_amount",
"… 1 more items"
],
"columns_datatype": [
"Text",
"Text",
"Number",
"Text",
"Text",
"Text",
"Text",
"Text",
"Calendar date",
"Number",
"… 1 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 1 more items"
],
"columns_format": [
{},
{},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
{},
{},
{},
{},
{},
{
"view": "date"
},
{
"decimalSeparator": ".",
"groupSeparator": ","
},
"… 1 more items"
],
"download_count": 541,
"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-11-02T12:51:05.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [
"prod"
],
"domain_metadata": []
},
"metadata": {
"domain": "cthru.data.socrata.com"
},
"permalink": "https://cthru.data.socrata.com/d/pni4-392n",
"link": "https://cthru.data.socrata.com/Government/Retirement-Benefits/pni4-392n",
"owner": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
},
"creator": {
"id": "8c95-296p",
"user_type": "interactive",
"display_name": "SA_ADMIN"
}
},
"… 10 more items"
],
"resultSetSize": 52,
"timings": {
"serviceMillis": 23,
"searchMillis": [
8,
6
]
},
"warnings": []
}Attribution: Source: cthru.data.socrata.com. Dataset attribution as stated by each publishing agency.
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.
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>
