fastCRW Pergamon
Government
data.sustainablesm.org
data.sustainablesm.org
Socrata open data portal at data.sustainablesm.org, publishing 326 public datasets from the publishing organisation.
Showing the catalogue
GET /v1/data/data-sustainablesm-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/data-sustainablesm-org/catalog-search?offset=0" \ -H "Authorization: Bearer $FASTCRW_API_KEY"
2Response example
A sample shape. Press Run to see live data from data.sustainablesm.org.
JSON
{
"results": [
{
"resource": {
"name": "Air Quality",
"id": "4hct-hin6",
"resource_name": null,
"parent_fxf": [
"uz6r-rjbd"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2023-01-03T18:31:51.356Z",
"createdAt": "2022-04-01T22:25:00.000Z",
"metadata_updated_at": "2022-04-06T22:18:22.000Z",
"data_updated_at": "2023-01-03T18:31:51.356Z",
"page_views": {
"page_views_last_week": 17,
"page_views_last_month": 33,
"page_views_total": 5458,
"page_views_last_week_log": 4.169925001442312,
"page_views_last_month_log": 5.08746284125034,
"page_views_total_log": 12.414420981746419
},
"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-04-06T22:18:22.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/4hct-hin6",
"link": "https://data.sustainablesm.org/stories/s/4hct-hin6",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Sustainable Community Involvement",
"id": "jmxj-hc43",
"resource_name": null,
"parent_fxf": [
"p7pe-cx6w"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-09-01T04:55:14.292Z",
"createdAt": "2022-07-05T16:31:30.000Z",
"metadata_updated_at": "2022-07-05T17:00:32.000Z",
"data_updated_at": "2022-09-01T04:55:14.292Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 19,
"page_views_total": 4566,
"page_views_last_week_log": 3,
"page_views_last_month_log": 4.321928094887363,
"page_views_total_log": 12.157031074378356
},
"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-07-05T17:00:32.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/jmxj-hc43",
"link": "https://data.sustainablesm.org/stories/s/jmxj-hc43",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Urban Forest",
"id": "q3x5-46xh",
"resource_name": null,
"parent_fxf": [
"gis2-me6x",
"pwgv-p8rf",
"dyyk-e3rt"
],
"description": "This section focuses on the City's trees planted, trees removed, and tree canopy.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2023-01-12T20:01:00.634Z",
"createdAt": "2021-11-09T18:38:14.000Z",
"metadata_updated_at": "2021-11-09T19:08:54.000Z",
"data_updated_at": "2023-01-12T20:01:00.634Z",
"page_views": {
"page_views_last_week": 16,
"page_views_last_month": 32,
"page_views_total": 3946,
"page_views_last_week_log": 4.08746284125034,
"page_views_last_month_log": 5.044394119358453,
"page_views_total_log": 11.946540803893104
},
"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-11-09T19:08:54.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/q3x5-46xh",
"link": "https://data.sustainablesm.org/stories/s/q3x5-46xh",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Homeless Count",
"id": "8q2c-ptbu",
"resource_name": null,
"parent_fxf": [
"sypi-hp8z"
],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2023-01-02T23:10:58.932Z",
"createdAt": "2022-05-17T21:11:24.000Z",
"metadata_updated_at": "2022-05-17T21:28:19.000Z",
"data_updated_at": "2023-01-02T23:10:58.932Z",
"page_views": {
"page_views_last_week": 29,
"page_views_last_month": 61,
"page_views_total": 3943,
"page_views_last_week_log": 4.906890595608519,
"page_views_last_month_log": 5.954196310386876,
"page_views_total_log": 11.945443836377912
},
"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-05-17T21:28:19.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/8q2c-ptbu",
"link": "https://data.sustainablesm.org/stories/s/8q2c-ptbu",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Sustainable Local Economy",
"id": "8fcu-wkrs",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-04-28T18:08:30.554Z",
"createdAt": "2022-04-18T21:54:56.000Z",
"metadata_updated_at": "2022-04-18T22:22:19.000Z",
"data_updated_at": "2022-04-28T18:08:30.554Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 23,
"page_views_total": 3299,
"page_views_last_week_log": 3,
"page_views_last_month_log": 4.584962500721157,
"page_views_total_log": 11.688250309133178
},
"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-04-18T22:22:19.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/8fcu-wkrs",
"link": "https://data.sustainablesm.org/stories/s/8fcu-wkrs",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Resource Conservation",
"id": "rabu-422c",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2021-11-09T18:20:30.416Z",
"createdAt": "2021-11-08T19:37:12.000Z",
"metadata_updated_at": "2021-11-08T20:44:44.000Z",
"data_updated_at": "2021-11-09T18:20:30.416Z",
"page_views": {
"page_views_last_week": 12,
"page_views_last_month": 31,
"page_views_total": 3171,
"page_views_last_week_log": 3.700439718141092,
"page_views_last_month_log": 5,
"page_views_total_log": 11.63117705570398
},
"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-11-08T20:43:56.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/rabu-422c",
"link": "https://data.sustainablesm.org/stories/s/rabu-422c",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Transportation",
"id": "9ryj-7idc",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2023-01-03T19:05:05.507Z",
"createdAt": "2022-03-23T21:45:18.000Z",
"metadata_updated_at": "2022-03-23T22:04:46.000Z",
"data_updated_at": "2023-01-03T19:05:05.507Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 34,
"page_views_total": 3085,
"page_views_last_week_log": 3,
"page_views_last_month_log": 5.129283016944966,
"page_views_total_log": 11.591522346570736
},
"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-03-23T22:04:46.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/9ryj-7idc",
"link": "https://data.sustainablesm.org/stories/s/9ryj-7idc",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Civic Participation and Community Education",
"id": "8m9p-s4uy",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-09-01T02:54:44.495Z",
"createdAt": "2022-04-28T16:57:59.000Z",
"metadata_updated_at": "2022-04-28T17:17:20.000Z",
"data_updated_at": "2022-09-01T02:54:44.495Z",
"page_views": {
"page_views_last_week": 9,
"page_views_last_month": 29,
"page_views_total": 3021,
"page_views_last_week_log": 3.3219280948873626,
"page_views_last_month_log": 4.906890595608519,
"page_views_total_log": 11.561287945164828
},
"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-04-28T17:17:20.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/8m9p-s4uy",
"link": "https://data.sustainablesm.org/stories/s/8m9p-s4uy",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Arts and Culture",
"id": "awma-2d82",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-07-27T22:20:29.602Z",
"createdAt": "2022-07-27T22:09:03.000Z",
"metadata_updated_at": "2022-07-27T22:20:29.000Z",
"data_updated_at": "2022-07-27T22:20:29.602Z",
"page_views": {
"page_views_last_week": 7,
"page_views_last_month": 25,
"page_views_total": 2700,
"page_views_last_week_log": 3,
"page_views_last_month_log": 4.700439718141093,
"page_views_total_log": 11.399277924508967
},
"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-07-27T22:20:29.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/awma-2d82",
"link": "https://data.sustainablesm.org/stories/s/awma-2d82",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
{
"resource": {
"name": "Environmental and Public Health",
"id": "gar6-kcif",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "story",
"updatedAt": "2022-12-20T01:03:25.111Z",
"createdAt": "2022-04-06T22:23:28.000Z",
"metadata_updated_at": "2022-04-06T22:52:17.000Z",
"data_updated_at": "2022-12-20T01:03:25.111Z",
"page_views": {
"page_views_last_week": 12,
"page_views_last_month": 30,
"page_views_total": 2657,
"page_views_last_week_log": 3.700439718141092,
"page_views_last_month_log": 4.954196310386876,
"page_views_total_log": 11.376125389276176
},
"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-04-06T22:52:17.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "data.sustainablesm.org"
},
"permalink": "https://data.sustainablesm.org/stories/s/gar6-kcif",
"link": "https://data.sustainablesm.org/stories/s/gar6-kcif",
"owner": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
},
"creator": {
"id": "ee57-5rs6",
"user_type": "interactive",
"display_name": "Amanda Grossman"
}
},
"… 10 more items"
],
"resultSetSize": 326,
"timings": {
"serviceMillis": 23,
"searchMillis": [
9,
5
]
},
"warnings": []
}Attribution: Source: data.sustainablesm.org. Dataset attribution as stated by each publishing agency.
Licence: Datasets on this portal declare the licence "Open Data Commons Attribution License" 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 data.sustainablesm.org (data-sustainablesm-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 "data-sustainablesm-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 data.sustainablesm.org (data-sustainablesm-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=dsuv-utxb. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sustainablesm-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 data.sustainablesm.org (data-sustainablesm-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 "data-sustainablesm-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 data.sustainablesm.org (data-sustainablesm-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=dsuv-utxb. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "data-sustainablesm-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>