Skip to main content
fastcrw
All providersProvider terms
fastCRW Pergamon
Government

albany.data.socrata.com

albany.data.socrata.com

Socrata open data portal at albany.data.socrata.com, publishing 6 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/albany-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 albany.data.socrata.com.

resourceclassificationmetadatapermalinklinkownercreator
{"name":"Albany Operating Budget","id":"wtnv-7ws5","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2019-08-23T17:59:32.000Z","createdAt":"2018-07-18T16:44:23.000Z","metadata_updated_at":"2019-08-23T17:59:06.000Z","data_updated_at":"2019-08-23T17:59:32.000Z","page_views":{"page_views_last_week":2,"page_views_last_month":13,"page_views_total":382,"page_views_last_week_log":1.5849625007211563,"page_views_last_month_log":3.8073549220576037,"page_views_total_log":8.581200581924957},"columns_name":["Approved Amount","Expense Category","Expense Type","Service","Recommended Amount","Department","Fund","Fiscal Year","Program","Description","… 1 more items"],"columns_field_name":["approved_amount","expense_category","expense_type","service","recommended_amount","department","fund","fiscal_year","program","description","… 1 more items"],"columns_datatype":["Number","Text","Text","Text","Number","Text","Text","Number","Text","Text","… 1 more items"],"columns_description":["","","","","","","","","","","… 1 more items"],"columns_format":[{},{},{},{},{},{},{},{"noCommas":"true"},{},{},"… 1 more items"],"download_count":58,"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-18T16:47:35.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/wtnv-7ws5https://albany.data.socrata.com/dataset/Albany-Operating-Budget/wtnv-7ws5{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}
{"name":"Albany Ledger Datasync","id":"eg8g-etdc","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2018-07-18T17:00:02.000Z","createdAt":"2018-07-18T16:48:53.000Z","metadata_updated_at":"2018-07-18T17:00:02.000Z","data_updated_at":"2018-07-18T17:00:01.000Z","page_views":{"page_views_last_week":5,"page_views_last_month":21,"page_views_total":340,"page_views_last_week_log":2.584962500721156,"page_views_last_month_log":4.459431618637297,"page_views_total_log":8.413627929024173},"columns_name":["Service","Purchase Order Line Number","Invoice Date","Invoice Line Distribution Number","Invoice ID","Payment Date","Fiscal Year Period","Fiscal Year","Fund Type","Amount","… 13 more items"],"columns_field_name":["service","purchase_order_line_number","invoice_date","invoice_line_distribution","invoice_id","payment_date","fiscal_year_period","fiscal_year","fund_type","amount","… 13 more items"],"columns_datatype":["Text","Number","Calendar date","Number","Text","Calendar date","Number","Number","Text","Number","… 13 more items"],"columns_description":["","","","","","","","","","","… 13 more items"],"columns_format":[{},{},{"view":"date_ymonthd"},{},{"noCommas":"false"},{"view":"date_ymonthd"},{},{"noCommas":"true"},{},{},"… 13 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":"2018-07-18T17:00:01.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/eg8g-etdchttps://albany.data.socrata.com/dataset/Albany-Ledger-Datasync/eg8g-etdc{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}
{"name":"Albany Project Phase List","id":"4at3-pqq6","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2018-07-18T17:04:33.000Z","createdAt":"2018-07-18T16:39:07.000Z","metadata_updated_at":"2018-07-18T17:04:33.000Z","data_updated_at":"2018-07-18T16:40:19.000Z","page_views":{"page_views_last_week":2,"page_views_last_month":16,"page_views_total":299,"page_views_last_week_log":1.5849625007211563,"page_views_last_month_log":4.08746284125034,"page_views_total_log":8.228818690495881},"columns_name":["Phase Type","Phase Step Description","Phase Step Number","Phase Step Name"],"columns_field_name":["phase_type","phase_step_description","phase_step_number","phase_step_name"],"columns_datatype":["Text","Text","Number","Text"],"columns_description":["","","",""],"columns_format":[{},{},{},{}],"download_count":49,"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-18T16:40:20.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/4at3-pqq6https://albany.data.socrata.com/dataset/Albany-Project-Phase-List/4at3-pqq6{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}
{"name":"Capital Project List Albany with Lat Long","id":"heub-836w","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2019-08-23T21:46:07.000Z","createdAt":"2018-07-18T16:40:58.000Z","metadata_updated_at":"2019-08-23T21:46:06.000Z","data_updated_at":"2019-08-23T21:46:07.000Z","page_views":{"page_views_last_week":2,"page_views_last_month":11,"page_views_total":268,"page_views_last_week_log":1.5849625007211563,"page_views_last_month_log":3.5849625007211565,"page_views_total_log":8.071462362556625},"columns_name":["project_id","project_description","project_name","longitude","project_details_url","regions","latitude"],"columns_field_name":["project_id","project_description","project_name","longitude","project_details_url","regions","latitude"],"columns_datatype":["Text","Text","Text","Number","Text","Text","Number"],"columns_description":["","","","","","",""],"columns_format":[{},{},{},{},{"displayStyle":"url"},{},{}],"download_count":63,"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-18T16:42:14.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/heub-836whttps://albany.data.socrata.com/dataset/Capital-Project-List-Albany-with-Lat-Long/heub-836w{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}
{"name":"Albany Capital Budget","id":"wppx-73fm","resource_name":null,"parent_fxf":[],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"dataset","updatedAt":"2019-08-23T21:52:42.000Z","createdAt":"2018-07-18T16:42:41.000Z","metadata_updated_at":"2019-08-23T21:52:41.000Z","data_updated_at":"2019-08-23T21:52:42.000Z","page_views":{"page_views_last_week":1,"page_views_last_month":4,"page_views_total":255,"page_views_last_week_log":1,"page_views_last_month_log":2.321928094887362,"page_views_total_log":8},"columns_name":["FY Plus 2 Approved","Fund","Department","Project ID","Service","Fiscal Year","FY Plus 5 Approved","FY Approved","FY Plus 6 Approved","FY Plus 3 Approved","… 6 more items"],"columns_field_name":["fy_plus_2_approved","fund","department","project_id","service","fiscal_year","fy_plus_5_approved","fy_approved","fy_plus_6_approved","fy_plus_3_approved","… 6 more items"],"columns_datatype":["Number","Text","Text","Text","Text","Number","Number","Number","Number","Number","… 6 more items"],"columns_description":["","","","","","","","","","","… 6 more items"],"columns_format":[{},{},{},{},{},{"noCommas":"true"},{},{},{},{},"… 6 more items"],"download_count":56,"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-18T16:43:37.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/wppx-73fmhttps://albany.data.socrata.com/dataset/Albany-Capital-Budget/wppx-73fm{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}{"id":"wuc5-gu64","user_type":"interactive","display_name":"Andrew S Deming"}
{"name":"test","id":"u6nx-3nt5","resource_name":null,"parent_fxf":["wtnv-7ws5"],"description":"","attribution":null,"attribution_link":null,"contact_email":null,"type":"filter","updatedAt":"2024-07-20T14:54:32.000Z","createdAt":"2024-07-20T14:54:12.000Z","metadata_updated_at":"2024-07-20T14:54:32.000Z","data_updated_at":"2019-08-23T17:59:32.000Z","page_views":{"page_views_last_week":0,"page_views_last_month":0,"page_views_total":55,"page_views_last_week_log":0,"page_views_last_month_log":0,"page_views_total_log":5.807354922057605},"columns_name":["Expense Category","Department","Program","Recommended Amount","Approved Amount","Fund","Fund Type","Description","Expense Type","Service","… 1 more items"],"columns_field_name":["expense_category","department","program","recommended_amount","approved_amount","fund","fund_type","description","expense_type","service","… 1 more items"],"columns_datatype":["Text","Text","Text","Number","Number","Text","Text","Text","Text","Text","… 1 more items"],"columns_description":["","","","","","","","","","","… 1 more items"],"columns_format":[{},{},{},{},{},{},{},{},{},{},"… 1 more items"],"download_count":14,"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-20T14:54:31.000Z"}{"categories":[],"tags":[],"domain_tags":[],"domain_metadata":[]}{"domain":"albany.data.socrata.com"}https://albany.data.socrata.com/d/u6nx-3nt5https://albany.data.socrata.com/dataset/test/u6nx-3nt5{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}{"id":"6xuc-er95","user_type":"interactive","display_name":"ricochet"}

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