fastCRW Pergamon
Government
columbiasc.data.socrata.com
columbiasc.data.socrata.com
Socrata open data portal at columbiasc.data.socrata.com, publishing 16 public datasets from the publishing organisation.
Showing the catalogue
GET /v1/data/columbiasc-data-socrata-com/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/columbiasc-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 columbiasc.data.socrata.com.
JSON
{
"results": [
{
"resource": {
"name": "Business Licenses",
"id": "54d2-wqcs",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-07-09T04:01:05.000Z",
"createdAt": "2021-03-31T23:39:30.000Z",
"metadata_updated_at": "2022-07-09T04:01:02.000Z",
"data_updated_at": "2022-07-09T04:01:05.000Z",
"page_views": {
"page_views_last_week": 11,
"page_views_last_month": 14,
"page_views_total": 217,
"page_views_last_week_log": 3.5849625007211565,
"page_views_last_month_log": 3.9068905956085187,
"page_views_total_log": 7.768184324776926
},
"columns_name": [
"LicenseNumber",
"CssRecordAttachUrl",
"CssRecordUrl",
"location",
"District",
"MainParcelNumber",
"LicenseId",
"CompanyName",
"DoingBusinessAs",
"LicenseType",
"… 10 more items"
],
"columns_field_name": [
"licensenumber",
"cssrecordattachurl",
"cssrecordurl",
"location",
"district",
"mainparcelnumber",
"licenseid",
"companyname",
"doingbusinessas",
"licensetype",
"… 10 more items"
],
"columns_datatype": [
"Text",
"Text",
"Text",
"Point",
"Text",
"Text",
"Text",
"Text",
"Text",
"Text",
"… 10 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 10 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 10 more items"
],
"download_count": 62,
"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-01-10T20:11:16.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/54d2-wqcs",
"link": "https://columbiasc.data.socrata.com/dataset/Business-Licenses/54d2-wqcs",
"owner": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
},
"creator": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
}
},
{
"resource": {
"name": "Permits",
"id": "cetj-imqb",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-07-09T04:01:40.000Z",
"createdAt": "2021-03-31T23:39:31.000Z",
"metadata_updated_at": "2022-07-09T04:01:38.000Z",
"data_updated_at": "2022-07-09T04:01:40.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 3,
"page_views_total": 146,
"page_views_last_week_log": 0,
"page_views_last_month_log": 2,
"page_views_total_log": 7.199672344836364
},
"columns_name": [
"GeocodePermit",
"ProjectName",
"MainAddress",
"CssRecordUrl",
"CssRecordAttachUrl",
"Council District",
"Council Boundary",
"IsStatusHold",
"ProjectNumber",
"IsStatusCompleted",
"… 20 more items"
],
"columns_field_name": [
"geocodepermit",
"projectname",
"mainaddress",
"cssrecordurl",
"cssrecordattachurl",
":@computed_region_43z5_qqqs",
":@computed_region_nau8_edwp",
"isstatushold",
"projectnumber",
"isstatuscompleted",
"… 20 more items"
],
"columns_datatype": [
"Point",
"Text",
"Text",
"Text",
"Text",
"Number",
"Number",
"Checkbox",
"Text",
"Checkbox",
"… 20 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"This column was automatically created in order to record in what polygon from the dataset 'Council District' (43z5-qqqs) the point in column 'geocodepermit' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"This column was automatically created in order to record in what polygon from the dataset 'Council Boundary' (nau8-edwp) the point in column 'geocodepermit' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.",
"",
"",
"",
"… 20 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 20 more items"
],
"download_count": 29,
"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-01-11T18:29:25.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/cetj-imqb",
"link": "https://columbiasc.data.socrata.com/dataset/Permits/cetj-imqb",
"owner": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
},
"creator": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
}
},
{
"resource": {
"name": "Council Districts",
"id": "mkay-djqk",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2023-09-07T19:07:13.000Z",
"createdAt": "2021-05-27T15:59:17.000Z",
"metadata_updated_at": "2021-05-27T15:59:19.000Z",
"data_updated_at": "2023-09-07T19:07:13.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 1,
"page_views_total": 88,
"page_views_last_week_log": 0,
"page_views_last_month_log": 1,
"page_views_total_log": 6.475733430966398
},
"columns_name": [
"Council Member",
"OBJECTID",
"Council District",
"the_geom"
],
"columns_field_name": [
"council_member",
"objectid",
"label",
"the_geom"
],
"columns_datatype": [
"Text",
"Number",
"Text",
"MultiPolygon"
],
"columns_description": [
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{}
],
"download_count": 21,
"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": "2021-05-27T15:59:19.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/mkay-djqk",
"link": "https://columbiasc.data.socrata.com/dataset/Council-Districts/mkay-djqk",
"owner": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
},
"creator": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
}
},
{
"resource": {
"name": "Code Cases",
"id": "4gyu-7b5n",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-07-09T04:02:33.000Z",
"createdAt": "2021-03-31T23:39:30.000Z",
"metadata_updated_at": "2022-07-09T04:02:31.000Z",
"data_updated_at": "2022-07-09T04:02:33.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 4,
"page_views_total": 85,
"page_views_last_week_log": 1,
"page_views_last_month_log": 2.321928094887362,
"page_views_total_log": 6.426264754702098
},
"columns_name": [
"ProjectName",
"MainAddress",
"IsStatusCancelled",
"MainZone",
"CssRecordAttachUrl",
"IsStatusSuccessful",
"Location",
"IsStatusFailure",
"CssRecordUrl",
"ClosedDate",
"… 9 more items"
],
"columns_field_name": [
"projectname",
"mainaddress",
"isstatuscancelled",
"mainzone",
"cssrecordattachurl",
"isstatussuccessful",
"location",
"isstatusfailure",
"cssrecordurl",
"closeddate",
"… 9 more items"
],
"columns_datatype": [
"Text",
"Text",
"Checkbox",
"Text",
"Text",
"Checkbox",
"Point",
"Checkbox",
"Text",
"Calendar date",
"… 9 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 9 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 9 more items"
],
"download_count": 39,
"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-01-10T20:24:25.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/4gyu-7b5n",
"link": "https://columbiasc.data.socrata.com/dataset/Code-Cases/4gyu-7b5n",
"owner": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
},
"creator": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
}
},
{
"resource": {
"name": "Inspections",
"id": "ugbz-k27d",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-07-09T04:04:03.000Z",
"createdAt": "2021-03-31T23:39:30.000Z",
"metadata_updated_at": "2022-07-09T04:04:01.000Z",
"data_updated_at": "2022-07-09T04:04:03.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 0,
"page_views_total": 78,
"page_views_last_week_log": 0,
"page_views_last_month_log": 0,
"page_views_total_log": 6.303780748177103
},
"columns_name": [
"IsStatusInViolation",
"IsStatusExtendExpireDate",
"MainAddress",
"InspectionLinkTypeName",
"CssRecordAttachUrl",
"IsStatusReinspection",
"Location",
"IsStatusCancelled",
"BalanceDue",
"IsStatusWait",
"… 16 more items"
],
"columns_field_name": [
"isstatusinviolation",
"isstatusextendexpiredate",
"mainaddress",
"inspectionlinktypename",
"cssrecordattachurl",
"isstatusreinspection",
"location",
"isstatuscancelled",
"balancedue",
"isstatuswait",
"… 16 more items"
],
"columns_datatype": [
"Checkbox",
"Checkbox",
"Text",
"Text",
"Text",
"Checkbox",
"Point",
"Checkbox",
"Number",
"Checkbox",
"… 16 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 16 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 16 more items"
],
"download_count": 32,
"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-01-11T17:57:29.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/ugbz-k27d",
"link": "https://columbiasc.data.socrata.com/dataset/Inspections/ugbz-k27d",
"owner": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
},
"creator": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
}
},
{
"resource": {
"name": "County Boundary",
"id": "bgfw-udrd",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-08-22T14:31:05.000Z",
"createdAt": "2021-05-18T13:37:35.000Z",
"metadata_updated_at": "2021-05-18T13:37:36.000Z",
"data_updated_at": "2021-08-22T14:31:05.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 0,
"page_views_total": 68,
"page_views_last_week_log": 0,
"page_views_last_month_log": 0,
"page_views_total_log": 6.10852445677817
},
"columns_name": [
"the_geom",
"County Code",
"Shape__Area",
"OBJECTID",
"Name",
"Shape__Length"
],
"columns_field_name": [
"the_geom",
"countycode",
"shape_area",
"objectid",
"name",
"shape_length"
],
"columns_datatype": [
"MultiPolygon",
"Text",
"Number",
"Number",
"Text",
"Number"
],
"columns_description": [
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{}
],
"download_count": 26,
"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": "2021-05-18T13:37:36.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/bgfw-udrd",
"link": "https://columbiasc.data.socrata.com/dataset/County-Boundary/bgfw-udrd",
"owner": {
"id": "cjgf-k7fr",
"user_type": "interactive",
"display_name": "Peter Moore"
},
"creator": {
"id": "cjgf-k7fr",
"user_type": "interactive",
"display_name": "Peter Moore"
}
},
{
"resource": {
"name": "County Boundary",
"id": "5t5p-32y2",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2025-03-12T17:18:01.000Z",
"createdAt": "2021-05-27T15:59:14.000Z",
"metadata_updated_at": "2023-12-20T04:55:08.000Z",
"data_updated_at": "2025-03-12T17:18:01.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 0,
"page_views_total": 67,
"page_views_last_week_log": 0,
"page_views_last_month_log": 0,
"page_views_total_log": 6.08746284125034
},
"columns_name": [
"the_geom",
"OBJECTID",
"Name",
"County Code",
"SHAPE_Length",
"SHAPE_Area"
],
"columns_field_name": [
"the_geom",
"objectid",
"name",
"countycode",
"shape_length",
"shape_area"
],
"columns_datatype": [
"MultiPolygon",
"Number",
"Text",
"Text",
"Number",
"Number"
],
"columns_description": [
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{}
],
"download_count": 24,
"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-12-20T04:55:08.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/5t5p-32y2",
"link": "https://columbiasc.data.socrata.com/dataset/County-Boundary/5t5p-32y2",
"owner": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
},
"creator": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
}
},
{
"resource": {
"name": "Plans",
"id": "s4rd-x67x",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2022-07-09T04:03:35.000Z",
"createdAt": "2021-03-31T23:39:31.000Z",
"metadata_updated_at": "2022-07-09T04:03:31.000Z",
"data_updated_at": "2022-07-09T04:03:35.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 0,
"page_views_total": 66,
"page_views_last_week_log": 0,
"page_views_last_month_log": 0,
"page_views_total_log": 6.066089190457772
},
"columns_name": [
"PlanId",
"BalanceDue",
"PlanValuation",
"CompleteDate",
"ApprovalExpirationDate",
"ExpirationDate",
"MainParcelNumber",
"ProjectNumber",
"ProjectName",
"MainZone",
"… 16 more items"
],
"columns_field_name": [
"planid",
"balancedue",
"planvaluation",
"completedate",
"approvalexpirationdate",
"expirationdate",
"mainparcelnumber",
"projectnumber",
"projectname",
"mainzone",
"… 16 more items"
],
"columns_datatype": [
"Text",
"Number",
"Number",
"Calendar date",
"Calendar date",
"Calendar date",
"Text",
"Text",
"Text",
"Text",
"… 16 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 16 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 16 more items"
],
"download_count": 19,
"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-01-11T18:01:55.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/s4rd-x67x",
"link": "https://columbiasc.data.socrata.com/dataset/Plans/s4rd-x67x",
"owner": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
},
"creator": {
"id": "4djs-q6xf",
"user_type": "interactive",
"display_name": "Data Integrations Service Account"
}
},
{
"resource": {
"name": "Council Districts",
"id": "a2e5-ev2g",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2021-08-22T16:30:31.000Z",
"createdAt": "2021-05-18T13:37:29.000Z",
"metadata_updated_at": "2021-05-18T13:37:31.000Z",
"data_updated_at": "2021-08-22T16:30:31.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 1,
"page_views_total": 64,
"page_views_last_week_log": 0,
"page_views_last_month_log": 1,
"page_views_total_log": 6.022367813028454
},
"columns_name": [
"OBJECTID",
"Shape__Area",
"Council Member",
"Council District",
"Shape__Length",
"the_geom"
],
"columns_field_name": [
"objectid",
"shape_area",
"council_member",
"label",
"shape_length",
"the_geom"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Number",
"MultiPolygon"
],
"columns_description": [
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{}
],
"download_count": 23,
"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": "2021-05-18T13:37:31.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/a2e5-ev2g",
"link": "https://columbiasc.data.socrata.com/dataset/Council-Districts/a2e5-ev2g",
"owner": {
"id": "cjgf-k7fr",
"user_type": "interactive",
"display_name": "Peter Moore"
},
"creator": {
"id": "cjgf-k7fr",
"user_type": "interactive",
"display_name": "Peter Moore"
}
},
{
"resource": {
"name": "Council Districts",
"id": "iid3-sg6m",
"resource_name": null,
"parent_fxf": [],
"description": "The data is maintained by Planning and Development. The boundaries are based up parcels within the COC GIS system. Any updates are done via annexations approved by the city. The parcels are verified at the time of the annexation to guarentee accuracy of where the boundary should be drawn. The outer boundary of each district should match the city limit boundary exactly.",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2026-10-15T09:09:15.000Z",
"createdAt": "2021-05-27T15:59:09.000Z",
"metadata_updated_at": "2023-01-05T08:45:26.000Z",
"data_updated_at": "2026-10-15T09:09:15.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 2,
"page_views_total": 62,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1.5849625007211563,
"page_views_total_log": 5.977279923499917
},
"columns_name": [
"DATASET_NUMBER",
"the_geom",
"Shape_Length",
"Phone2",
"Email2",
"LegacyID",
"REVISION_DATE",
"COUNCIL_MEMBER",
"Phone",
"Email",
"… 8 more items"
],
"columns_field_name": [
"dataset_number",
"the_geom",
"shape_length",
"phone2",
"email2",
"legacyid",
"revision_date",
"council_member",
"phone",
"email",
"… 8 more items"
],
"columns_datatype": [
"Text",
"MultiPolygon",
"Number",
"Text",
"Text",
"Text",
"Date",
"Text",
"Text",
"Text",
"… 8 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 8 more items"
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{},
{},
"… 8 more items"
],
"download_count": 24,
"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": "2021-05-27T15:59:11.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "columbiasc.data.socrata.com"
},
"permalink": "https://columbiasc.data.socrata.com/d/iid3-sg6m",
"link": "https://columbiasc.data.socrata.com/dataset/Council-Districts/iid3-sg6m",
"owner": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
},
"creator": {
"id": "ft46-kupe",
"user_type": "interactive",
"display_name": "ArcGIS Connector"
}
},
"… 6 more items"
],
"resultSetSize": 16,
"timings": {
"serviceMillis": 40,
"searchMillis": [
25,
4
]
},
"warnings": []
}Attribution: Source: columbiasc.data.socrata.com. Dataset attribution as stated by each publishing agency.
Licence: No licence is declared in the dataset metadata this portal exposes through its catalogue API. No reuse grant is made here: commercial use and redistribution are recorded as false and no rights are claimed over the upstream data.
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 columbiasc.data.socrata.com (columbiasc-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 "columbiasc-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 columbiasc.data.socrata.com (columbiasc-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=mkay-djqk. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "columbiasc-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 columbiasc.data.socrata.com (columbiasc-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 "columbiasc-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 columbiasc.data.socrata.com (columbiasc-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=mkay-djqk. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "columbiasc-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>