Skip to main content
fastcrw
All providersProvider terms
fastCRW Pergamon
Government

clatsop.data.socrata.com

clatsop.data.socrata.com

Socrata open data portal at clatsop.data.socrata.com, publishing 8 public datasets from the publishing organisation.

Showing the catalogue

1Request

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/clatsop-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 clatsop.data.socrata.com.

resourceclassificationmetadatapermalinklinkownercreator
{"name":"Revenue Budget","id":"rggr-t9x6","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2020-02-03T23:57:55.000Z","createdAt":"2015-10-05T17:30:19.000Z","metadata_updated_at":"2020-02-03T23:57:54.000Z","data_updated_at":"2020-02-03T23:57:55.000Z","page_views":{"page_views_last_week":2,"page_views_last_month":7,"page_views_total":127693,"page_views_last_week_log":1.5849625007211563,"page_views_last_month_log":3,"page_views_total_log":16.962331212683345},"columns_name":["Description","Fund","Organization","Fiscal Year","Estimated Revenue","Account","Category","Functional Area"],"columns_field_name":["description","fund","organization","fiscal_year","estimated_revenue","account","category","functional_area"],"columns_datatype":["Text","Text","Text","Number","Number","Text","Text","Text"],"columns_description":["","","","","","","",""],"columns_format":[{},{},{},{"precisionStyle":"standard","noCommas":"true","align":"left"},{},{},{},{}],"download_count":1314,"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":"2018-07-20T20:30:52.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/rggr-t9x6https://clatsop.data.socrata.com/dataset/Revenue-Budget/rggr-t9x6{"id":"7krv-k7t3","user_type":"interactive","display_name":"Alicia Brown"}{"id":"7krv-k7t3","user_type":"interactive","display_name":"Alicia Brown"}
{"name":"Operating Budget","id":"xz5z-yryd","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2020-02-01T01:08:21.000Z","createdAt":"2015-09-30T16:43:50.000Z","metadata_updated_at":"2020-02-01T01:08:20.000Z","data_updated_at":"2020-02-01T01:08:21.000Z","page_views":{"page_views_last_week":5,"page_views_last_month":9,"page_views_total":123997,"page_views_last_week_log":2.584962500721156,"page_views_last_month_log":3.3219280948873626,"page_views_total_log":16.919957325586452},"columns_name":["Original Budget","Account","Category","Current Budget","Organization","Functional Area","Fund","Fiscal Year","Description"],"columns_field_name":["original_budget","account","category","current_budget","organization","functional_area","fund","fiscal_year","description"],"columns_datatype":["Number","Text","Text","Number","Text","Text","Text","Number","Text"],"columns_description":["","","","","","","","",""],"columns_format":[{},{},{},{},{},{},{},{"precisionStyle":"standard","noCommas":"true","align":"left"},{}],"download_count":1332,"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":"2018-07-20T20:31:29.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/xz5z-yrydhttps://clatsop.data.socrata.com/dataset/Operating-Budget/xz5z-yryd{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"Capital Budget","id":"mjef-xjt6","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2020-02-03T23:59:02.000Z","createdAt":"2015-10-14T21:43:46.000Z","metadata_updated_at":"2020-02-03T23:59:02.000Z","data_updated_at":"2020-02-03T23:59:02.000Z","page_views":{"page_views_last_week":4,"page_views_last_month":7,"page_views_total":106494,"page_views_last_week_log":2.321928094887362,"page_views_last_month_log":3,"page_views_total_log":16.700426171136375},"columns_name":["org_id","facility","gb_account_category_account_category_rep","category_name","account_category_code","balance_code","gb_v_current_session_session_fiscal_year_id","original_budget","account_group_code","fund_id","… 4 more items"],"columns_field_name":["org_id","facility","gb_account_category_account_category_rep","category_name","account_category_code","balance_code","gb_v_current_session_session_fiscal_year_id","original_budget","account_group_code","fund_id","… 4 more items"],"columns_datatype":["Number","Text","Number","Text","Text","Text","Number","Number","Text","Number","… 4 more items"],"columns_description":["","","","","","","","","","","… 4 more items"],"columns_format":[{"precisionStyle":"standard","noCommas":"true","align":"right"},{},{},{},{},{},{"precisionStyle":"standard","noCommas":"true","align":"left"},{},{},{},"… 4 more items"],"download_count":1311,"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":"2018-07-23T16:28:25.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/mjef-xjt6https://clatsop.data.socrata.com/dataset/Capital-Budget/mjef-xjt6{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"Capital Project Details","id":"pig3-t82b","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2020-02-04T00:00:11.000Z","createdAt":"2015-10-14T21:48:10.000Z","metadata_updated_at":"2020-02-04T00:00:10.000Z","data_updated_at":"2020-02-04T00:00:11.000Z","page_views":{"page_views_last_week":3,"page_views_last_month":6,"page_views_total":53098,"page_views_last_week_log":2,"page_views_last_month_log":2.807354922057604,"page_views_total_log":15.69639707092491},"columns_name":["long","facility","description","account_group_code","Number","Proj_description","lat"],"columns_field_name":["long","facility","description","account_group_code","number","proj_description","lat"],"columns_datatype":["Number","Text","Text","Text","Text","Text","Number"],"columns_description":["","","","","","",""],"columns_format":[{"align":"left"},{},{},{},{},{},{"align":"left"}],"download_count":1333,"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":"2018-07-23T16:18:37.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/pig3-t82bhttps://clatsop.data.socrata.com/dataset/Capital-Project-Details/pig3-t82b{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"Astoria Sunrise","id":"r939-xhqj","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"file","updatedAt":"2020-01-31T15:44:09.000Z","createdAt":"2015-10-09T22:55:08.000Z","metadata_updated_at":"2020-01-31T15:44:09.000Z","data_updated_at":"2015-10-09T22:55:08.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":0,"page_views_total":3052,"page_views_last_week_log":0,"page_views_last_month_log":0,"page_views_total_log":11.576011874206781},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":2292,"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-10-09T22:55:08.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/r939-xhqjhttps://clatsop.data.socrata.com/dataset/Astoria-Sunrise/r939-xhqj{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"Example dataset","id":"7irg-jc9h","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2015-11-17T22:49:06.000Z","createdAt":"2015-11-17T18:40:37.000Z","metadata_updated_at":"2015-11-17T22:49:06.000Z","data_updated_at":"2015-11-17T22:48:26.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":3,"page_views_total":888,"page_views_last_week_log":1,"page_views_last_month_log":2,"page_views_total_log":9.796039608829771},"columns_name":["Activity","Agency","Subobject","Program","Outcome","Fund","FY","Detailed Fund","Approved","Recommended","… 1 more items"],"columns_field_name":["activity","agency","subobject","program","outcome","fund","fy","detailed_fund","approved","recommended","… 1 more items"],"columns_datatype":["Text","Text","Text","Text","Text","Text","Number","Text","Number","Number","… 1 more items"],"columns_description":["","","","","","","","","","","… 1 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 1 more items"],"download_count":1223,"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-11-17T22:49:06.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/7irg-jc9hhttps://clatsop.data.socrata.com/dataset/Example-dataset/7irg-jc9h{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"County Logo","id":"25rh-kffe","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"file","updatedAt":"2015-10-02T17:08:03.000Z","createdAt":"2015-10-02T16:36:34.000Z","metadata_updated_at":"2015-10-02T17:08:03.000Z","data_updated_at":"2015-10-02T16:36:34.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":2,"page_views_total":833,"page_views_last_week_log":1,"page_views_last_month_log":1.5849625007211563,"page_views_total_log":9.703903573444665},"columns_name":[],"columns_field_name":[],"columns_datatype":[],"columns_description":[],"columns_format":[],"download_count":82,"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-02T16:36:34.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/25rh-kffehttps://clatsop.data.socrata.com/dataset/County-Logo/25rh-kffe{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}{"id":"38x4-duhy","user_type":"interactive","display_name":"Paige Alvarez"}
{"name":"test","id":"nis8-vm3c","resource_name":null,"parent_fxf":["rggr-t9x6"],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"filter","updatedAt":"2024-07-20T13:46:08.000Z","createdAt":"2024-07-20T13:45:50.000Z","metadata_updated_at":"2024-07-20T13:46:08.000Z","data_updated_at":"2020-02-03T23:57:55.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":1,"page_views_total":515,"page_views_last_week_log":1,"page_views_last_month_log":1,"page_views_total_log":9.011227255423254},"columns_name":["Fund","Category","Estimated Revenue","Fiscal Year","Description","Account","Functional Area","Organization"],"columns_field_name":["fund","category","estimated_revenue","fiscal_year","description","account","functional_area","organization"],"columns_datatype":["Text","Text","Number","Number","Text","Text","Text","Text"],"columns_description":["","","","","","","",""],"columns_format":[{},{},{},{"precisionStyle":"standard","noCommas":"true","align":"left"},{},{},{},{}],"download_count":9,"provenance":"community","lens_view_type":"tabular","lens_display_type":"table","locked":false,"backend":"nbe","blob_mime_type":null,"hide_from_data_json":false,"publication_date":"2024-07-20T13:46:07.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"clatsop.data.socrata.com"}https://clatsop.data.socrata.com/d/nis8-vm3chttps://clatsop.data.socrata.com/dataset/test/nis8-vm3c{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}

Attribution: Source: clatsop.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 clatsop.data.socrata.com (clatsop-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 "clatsop-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 clatsop.data.socrata.com (clatsop-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=7irg-jc9h. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "clatsop-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 clatsop.data.socrata.com (clatsop-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 "clatsop-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 clatsop.data.socrata.com (clatsop-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=7irg-jc9h. Use the crw MCP tools: crw_find_data to confirm the source and its options, then crw_get_data with provider "clatsop-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>