`fdic_branch_deposits`

Pack: fdic · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/fdic_branch_deposits for the schema, then POST the same URL with its arguments for the data.

Summary of Deposits (SOD): deposits held at each branch of an FDIC-insured bank as of June 30 of a survey year, in thousands of US dollars, with the branch address, city, state, ZIP, and branch/office identifiers. Pass a cert (and optionally year, state, city); year defaults to the latest survey year published. Returns branches ranked by deposits, plus the sum of the branches returned. Source: FDIC, Summary of Deposits annual branch survey.

Parameters

Name	Type	Required	Description
`cert`	string	no	FDIC certificate number (required unless state and city are both given)
`year`	number	no	Survey year (June 30 snapshot), e.g. 2024. Omit for the latest published year.
`state`	string	no	Two-letter state code of the branch (e.g. “IA”)
`city`	string	no	Branch city (e.g. “Ottumwa”)
`limit`	number	no	Max branches to return (default 50, max 500)

Example call

Arguments

{
  "cert": "28593"
}

curl

curl -X POST https://gateway.pipeworx.io/fdic/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"fdic_branch_deposits","arguments":{"cert":"28593"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('fdic_branch_deposits', {
  "cert": "28593"
});

More examples

{
  "cert": "14413",
  "year": 2020,
  "limit": 2
}

Response shape

Field	Type	Description
`found`	boolean	Whether any branch matched
`survey_year`	number	Summary of Deposits survey year
`year`	number	Requested year when empty
`as_of_date`	string	June 30 snapshot date
`units`	string	Units of deposit figures
`total_branches`	number	Total matching branches
`returned`	number	Branches returned
`truncated`	boolean	True when more branches matched than returned
`deposits_in_returned_branches`	number	Sum of branch deposits returned, in thousands of USD
`deposits_total_is_complete`	boolean	True when the sum covers every matching branch
`branches`	array	Branches ranked by deposits
`empty_reason`	string	Why nothing matched
`hint`	string	How to fix an empty result
`source`	string	Publisher and dataset
`data_as_of`	string \| null	When the FDIC index was built

Full JSON Schema

{
  "type": "object",
  "properties": {
    "found": {
      "type": "boolean",
      "description": "Whether any branch matched"
    },
    "survey_year": {
      "type": "number",
      "description": "Summary of Deposits survey year"
    },
    "year": {
      "type": "number",
      "description": "Requested year when empty"
    },
    "as_of_date": {
      "type": "string",
      "description": "June 30 snapshot date"
    },
    "units": {
      "type": "string",
      "description": "Units of deposit figures"
    },
    "total_branches": {
      "type": "number",
      "description": "Total matching branches"
    },
    "returned": {
      "type": "number",
      "description": "Branches returned"
    },
    "truncated": {
      "type": "boolean",
      "description": "True when more branches matched than returned"
    },
    "deposits_in_returned_branches": {
      "type": "number",
      "description": "Sum of branch deposits returned, in thousands of USD"
    },
    "deposits_total_is_complete": {
      "type": "boolean",
      "description": "True when the sum covers every matching branch"
    },
    "branches": {
      "type": "array",
      "description": "Branches ranked by deposits",
      "items": {
        "type": "object",
        "properties": {
          "cert": {
            "type": [
              "number",
              "null"
            ],
            "description": "FDIC certificate number"
          },
          "institution": {
            "type": [
              "string",
              "null"
            ],
            "description": "Institution name"
          },
          "branch_name": {
            "type": [
              "string",
              "null"
            ],
            "description": "Branch name"
          },
          "address": {
            "type": [
              "string",
              "null"
            ],
            "description": "Street address"
          },
          "city": {
            "type": [
              "string",
              "null"
            ],
            "description": "City"
          },
          "state": {
            "type": [
              "string",
              "null"
            ],
            "description": "State code"
          },
          "zip": {
            "type": [
              "string",
              "null"
            ],
            "description": "ZIP code"
          },
          "county": {
            "type": [
              "string",
              "null"
            ],
            "description": "County"
          },
          "branch_deposits": {
            "type": [
              "number",
              "null"
            ],
            "description": "Deposits at the branch, thousands of USD"
          },
          "branch_number": {
            "type": [
              "number",
              "null"
            ],
            "description": "Bank branch number, 0 = main office"
          },
          "office_id": {
            "type": [
              "number",
              "null"
            ],
            "description": "FDIC unique office number"
          },
          "latitude": {
            "type": [
              "number",
              "null"
            ],
            "description": "Latitude"
          },
          "longitude": {
            "type": [
              "number",
              "null"
            ],
            "description": "Longitude"
          }
        },
        "additionalProperties": true
      }
    },
    "empty_reason": {
      "type": "string",
      "description": "Why nothing matched"
    },
    "hint": {
      "type": "string",
      "description": "How to fix an empty result"
    },
    "source": {
      "type": "string",
      "description": "Publisher and dataset"
    },
    "data_as_of": {
      "type": [
        "string",
        "null"
      ],
      "description": "When the FDIC index was built"
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}

Connect to just the fdic pack

{
  "mcpServers": {
    "fdic": {
      "url": "https://gateway.pipeworx.io/fdic/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

fdic_branch_deposits