douglasco.data.socrata.com
douglasco.data.socrata.com
Socrata open data portal at douglasco.data.socrata.com, publishing 12 public datasets from the publishing organisation, led by the Government category.
GET /v1/data/douglasco-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/douglasco-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 douglasco.data.socrata.com.
{
"results": [
{
"resource": {
"name": "DC-REV",
"id": "fryp-nt5v",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-12-28T18:50:14.000Z",
"createdAt": "2015-10-21T15:48:06.000Z",
"metadata_updated_at": "2015-12-28T18:50:14.000Z",
"data_updated_at": "2015-12-28T18:49:21.000Z",
"page_views": {
"page_views_last_week": 2,
"page_views_last_month": 5,
"page_views_total": 5151,
"page_views_last_week_log": 1.5849625007211563,
"page_views_last_month_log": 2.584962500721156,
"page_views_total_log": 12.330916878114618
},
"columns_name": [
"Adopted Budget",
"Category Type",
"FY",
"Fund Description",
"Variance",
"Actuals",
"Amended Budget",
"Line Item",
"Divison Description",
"Department Description"
],
"columns_field_name": [
"adopted_budget",
"category_type",
"fy",
"fund_description",
"variance",
"actuals",
"amended_budget",
"line_item",
"divison_description",
"department_description"
],
"columns_datatype": [
"Number",
"Text",
"Number",
"Text",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{},
{},
{},
{}
],
"download_count": 1235,
"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-28T18:50:14.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/fryp-nt5v",
"link": "https://douglasco.data.socrata.com/dataset/DC-REV/fryp-nt5v",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "DC-EXP",
"id": "qtwb-h2h7",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-12-28T18:51:54.000Z",
"createdAt": "2015-11-02T19:41:24.000Z",
"metadata_updated_at": "2015-12-28T18:51:54.000Z",
"data_updated_at": "2015-12-28T18:51:22.000Z",
"page_views": {
"page_views_last_week": 3,
"page_views_last_month": 6,
"page_views_total": 4169,
"page_views_last_week_log": 2,
"page_views_last_month_log": 2.807354922057604,
"page_views_total_log": 12.025831668332026
},
"columns_name": [
"Variance",
"FY",
"Fund",
"Department",
"Divison ",
"Category Type",
"Adopted Budget",
"Amended Budget",
"Actuals",
"Line Item"
],
"columns_field_name": [
"variance",
"fy",
"fund",
"department",
"divison",
"category_type",
"adopted_budget",
"amended_budget",
"actuals",
"line_item"
],
"columns_datatype": [
"Number",
"Number",
"Text",
"Text",
"Text",
"Text",
"Number",
"Number",
"Number",
"Text"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
""
],
"columns_format": [
{},
{},
{},
{},
{},
{},
{},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{}
],
"download_count": 1284,
"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-28T18:51:54.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/qtwb-h2h7",
"link": "https://douglasco.data.socrata.com/dataset/DC-EXP/qtwb-h2h7",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "Open Budget Icon",
"id": "ixc7-rdac",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "Douglas County Government",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2017-12-21T20:56:04.000Z",
"createdAt": "2017-12-20T18:36:42.000Z",
"metadata_updated_at": "2017-12-21T20:56:04.000Z",
"data_updated_at": "2017-12-20T18:36:42.000Z",
"page_views": {
"page_views_last_week": 3,
"page_views_last_month": 6,
"page_views_total": 1816,
"page_views_last_week_log": 2,
"page_views_last_month_log": 2.807354922057604,
"page_views_total_log": 10.827342704234116
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1337,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/png; charset=binary",
"hide_from_data_json": false,
"publication_date": "2017-12-20T18:36:42.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/ixc7-rdac",
"link": "https://douglasco.data.socrata.com/Government/Open-Budget-Icon/ixc7-rdac",
"owner": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
},
"creator": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
}
},
{
"resource": {
"name": "Open Expenditure Icon",
"id": "b3p4-ddvn",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "Douglas County Government",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2017-12-21T20:57:23.000Z",
"createdAt": "2017-12-21T20:56:53.000Z",
"metadata_updated_at": "2017-12-21T20:57:23.000Z",
"data_updated_at": "2017-12-21T20:56:53.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 5,
"page_views_total": 1802,
"page_views_last_week_log": 1,
"page_views_last_month_log": 2.584962500721156,
"page_views_total_log": 10.816183681432342
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1328,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/png; charset=binary",
"hide_from_data_json": false,
"publication_date": "2017-12-21T20:56:53.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/b3p4-ddvn",
"link": "https://douglasco.data.socrata.com/Government/Open-Expenditure-Icon/b3p4-ddvn",
"owner": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
},
"creator": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
}
},
{
"resource": {
"name": "DC-CAP",
"id": "vkh6-2u4j",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-12-28T18:48:05.000Z",
"createdAt": "2015-11-02T19:39:17.000Z",
"metadata_updated_at": "2015-12-28T18:48:05.000Z",
"data_updated_at": "2015-12-28T18:47:05.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 8,
"page_views_total": 1178,
"page_views_last_week_log": 1,
"page_views_last_month_log": 3.1699250014423126,
"page_views_total_log": 10.203348002979764
},
"columns_name": [
"Division",
"Fund Description",
"Adopted Budget",
"Variance",
"Actuals",
"FY",
"Amended Budget",
"Department",
"Business Unit",
"Line Item",
"… 1 more items"
],
"columns_field_name": [
"division",
"fund_description",
"adopted_budget",
"variance",
"actuals",
"fy",
"amended_budget",
"department",
"business_unit",
"line_item",
"… 1 more items"
],
"columns_datatype": [
"Text",
"Text",
"Number",
"Number",
"Number",
"Number",
"Number",
"Text",
"Text",
"Text",
"… 1 more items"
],
"columns_description": [
"",
"",
"",
"",
"",
"",
"",
"",
"",
"",
"… 1 more items"
],
"columns_format": [
{
"align": "left"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{},
{
"precisionStyle": "standard",
"noCommas": "false",
"align": "right"
},
{},
{
"align": "left"
},
{
"align": "left"
},
"… 1 more items"
],
"download_count": 1254,
"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-28T18:48:05.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/vkh6-2u4j",
"link": "https://douglasco.data.socrata.com/dataset/DC-CAP/vkh6-2u4j",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "DC-CAPDETAILS",
"id": "6daf-uvjj",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "dataset",
"updatedAt": "2015-12-28T22:23:38.000Z",
"createdAt": "2015-11-02T21:20:25.000Z",
"metadata_updated_at": "2015-12-28T22:23:38.000Z",
"data_updated_at": "2015-12-28T22:23:14.000Z",
"page_views": {
"page_views_last_week": 0,
"page_views_last_month": 0,
"page_views_total": 1109,
"page_views_last_week_log": 0,
"page_views_last_month_log": 0,
"page_views_total_log": 10.116343961237469
},
"columns_name": [
"Business Unit",
"Divison ",
"Description"
],
"columns_field_name": [
"business_unit",
"divison",
"description"
],
"columns_datatype": [
"Text",
"Text",
"Text"
],
"columns_description": [
"",
"",
""
],
"columns_format": [
{
"align": "left"
},
{},
{}
],
"download_count": 821,
"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-28T22:23:38.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/6daf-uvjj",
"link": "https://douglasco.data.socrata.com/dataset/DC-CAPDETAILS/6daf-uvjj",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "Hero",
"id": "qrtg-xt8s",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2015-12-29T00:12:51.000Z",
"createdAt": "2015-12-29T00:12:42.000Z",
"metadata_updated_at": "2015-12-29T00:12:51.000Z",
"data_updated_at": "2015-12-29T00:12:42.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 1,
"page_views_total": 1032,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1,
"page_views_total_log": 10.01262453886506
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 146,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/jpeg; charset=binary",
"hide_from_data_json": false,
"publication_date": "2015-12-29T00:12:42.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/qrtg-xt8s",
"link": "https://douglasco.data.socrata.com/dataset/Hero/qrtg-xt8s",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "Budget Collage",
"id": "dbw3-pipf",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2015-12-30T02:38:11.000Z",
"createdAt": "2015-12-30T02:38:02.000Z",
"metadata_updated_at": "2015-12-30T02:38:11.000Z",
"data_updated_at": "2015-12-30T02:38:02.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 1,
"page_views_total": 747,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1,
"page_views_total_log": 9.546894459887637
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 77,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/jpeg; charset=binary",
"hide_from_data_json": false,
"publication_date": "2015-12-30T02:38:02.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/dbw3-pipf",
"link": "https://douglasco.data.socrata.com/dataset/Budget-Collage/dbw3-pipf",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
{
"resource": {
"name": "Open Fund Balance Icon",
"id": "s8q6-sp5m",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": "Douglas County Government",
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2017-12-21T20:58:18.000Z",
"createdAt": "2017-12-21T20:58:00.000Z",
"metadata_updated_at": "2017-12-21T20:58:18.000Z",
"data_updated_at": "2017-12-21T20:58:00.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 2,
"page_views_total": 636,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1.5849625007211563,
"page_views_total_log": 9.3151495622563
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 1,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/png; charset=binary",
"hide_from_data_json": false,
"publication_date": "2017-12-21T20:58:00.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_category": "Government",
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/s8q6-sp5m",
"link": "https://douglasco.data.socrata.com/Government/Open-Fund-Balance-Icon/s8q6-sp5m",
"owner": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
},
"creator": {
"id": "hczz-y8gp",
"user_type": "interactive",
"display_name": "Chris Vodnik"
}
},
{
"resource": {
"name": "Dc-logo",
"id": "mice-ehth",
"resource_name": null,
"parent_fxf": [],
"description": "",
"attribution": null,
"attribution_link": null,
"contact_email": null,
"type": "file",
"updatedAt": "2015-10-21T16:21:33.000Z",
"createdAt": "2015-10-21T16:21:27.000Z",
"metadata_updated_at": "2015-10-21T16:21:33.000Z",
"data_updated_at": "2015-10-21T16:21:27.000Z",
"page_views": {
"page_views_last_week": 1,
"page_views_last_month": 1,
"page_views_total": 583,
"page_views_last_week_log": 1,
"page_views_last_month_log": 1,
"page_views_total_log": 9.189824558880018
},
"columns_name": [],
"columns_field_name": [],
"columns_datatype": [],
"columns_description": [],
"columns_format": [],
"download_count": 14,
"provenance": "official",
"lens_view_type": "blobby",
"lens_display_type": "blob",
"locked": false,
"backend": "not_a_dataset",
"blob_mime_type": "image/png; charset=binary",
"hide_from_data_json": false,
"publication_date": "2015-10-21T16:21:27.000Z"
},
"classification": {
"categories": [],
"tags": [],
"domain_tags": [],
"domain_metadata": []
},
"metadata": {
"domain": "douglasco.data.socrata.com"
},
"permalink": "https://douglasco.data.socrata.com/d/mice-ehth",
"link": "https://douglasco.data.socrata.com/dataset/Dc-logo/mice-ehth",
"owner": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
},
"creator": {
"id": "ikyq-eh5e",
"user_type": "interactive",
"display_name": "Ben Varon"
}
},
"… 2 more items"
],
"resultSetSize": 12,
"timings": {
"serviceMillis": 34,
"searchMillis": [
23,
5
]
},
"warnings": []
}Attribution: Source: douglasco.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 douglasco.data.socrata.com (douglasco-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 "douglasco-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 douglasco.data.socrata.com (douglasco-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=6daf-uvjj. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "douglasco-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 douglasco.data.socrata.com (douglasco-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 "douglasco-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 douglasco.data.socrata.com (douglasco-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=6daf-uvjj. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "douglasco-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>
