Skip to main content
All providers

albany.data.socrata.com

Open data portals

albany.data.socrata.com

Socrata open data portal at albany.data.socrata.com, publishing 6 public datasets from the publishing organisation.

Capabilities (5)

GET /v1/data/albany-data-socrata-com/catalog-search1 credit

Keyword search over the datasets published on albany.data.socrata.com: each hit carries the dataset id, name, description, attribution, category, tags, column names and last update time, plus the total match count.

q?offset?order?only?categories?tags?domain_category?
GET /v1/data/albany-data-socrata-com/dataset1 credit

The complete metadata document for one dataset: name, description, attribution, licence, category, tags, all column definitions with data types, and the table id used for queries.

id
GET /v1/data/albany-data-socrata-com/datasets1 credit

A page of the portal's own dataset records (id, name, description, category, attribution, creation and update timestamps, view count) without the full column metadata.

offset?order?category?
GET /v1/data/albany-data-socrata-com/row-count1 credit

One number: how many rows the dataset currently holds, as a SoQL count aggregate.

id
GET /v1/data/albany-data-socrata-com/rows1 credit

The first 100 rows of a dataset as JSON objects keyed by field name. Column names are the API field names, so they can be used directly in a later SoQL query.

id

Response example

The shape of data from albany-data-socrata-com/catalog-search (Catalogue search). A sample, not live data.

Example truncated, full shape in JSON from the API.

JSON
{
  "results": [
    {
      "resource": {
        "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"
      },
      "classification": {
        "categories": [],
        "tags": [],
        "domain_tags": [],
        "domain_metadata": []
      },
      "metadata": {
        "domain": "albany.data.socrata.com"
      },
      "permalink": "https://albany.data.socrata.com/d/wtnv-7ws5",
      "link": "https://albany.data.socrata.com/dataset/Albany-Operating-Budget/wtnv-7ws5",
      "owner": {
        "id": "wuc5-gu64",
        "user_type": "interactive",
        "display_name": "Andrew S Deming"
      },
      "creator": {
        "id": "wuc5-gu64",
        "user_type": "interactive",
        "display_name": "Andrew S Deming"
      }
    },
    {
      "resource": {
        "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_na

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>

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.

https://albany.data.socrata.com/

Attribution

Display this wherever you show the data. It arrives on every response as provenance.attribution_text.

Source: albany.data.socrata.com. Dataset attribution as stated by each publishing agency.

Cache: up to 3600s