Spiral gives your agent every tool with one account. Browse the tools →

VS Code · Finance

How to Use FDIC branch deposits in VS Code

Returns annual branch deposit balances from the FDIC's Summary of Deposits survey, with history since 1994. Use it to calculate local deposit market share or compare a bank's geographic deposit footprint at June 30.

Prompts to try with FDIC branch deposits in VS Code

Copy an example into VS Code, or ask in your own words.

Use FDIC branch deposits to fetch Austin, Texas, office deposits for 2024 and 2025, then add a table of each bank's calculated share of the returned market totals.

FDIC branch depositsVS Code
Try asking
  • Use FDIC branch deposits to look this up and give me the result as a table. Save the result in ./assets.

  • Pull the latest numbers from FDIC branch deposits and tell me what changed since last week.

  • Check FDIC branch deposits and summarize what you find in three bullet points.

  • Pull the newest data from FDIC branch deposits and give me the result as a table.

How to set up FDIC branch deposits in VS Code

Pick the way that suits you. Each takes about two minutes.

Use Spiral's MCP server

  1. Add the hosted server

    Use Add to VS Code on the console's Agents & MCP page, or run:

    code --add-mcp '{"name":"spiral","type":"http","url":"https://api.spiral.ai/mcp"}'
  2. Sign in

    VS Code asks you to sign in when it first starts the server: sign in to Spiral and click Authorize. No API key. Run MCP: List Servers from the Command Palette to check that Spiral is running.

Use the Spiral skill

  1. Send VS Code this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run FDIC branch deposits

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "banks-data-fdic-gov/bank-data/deposits",
        "input": {
          "cert": 1
        }
      }'

Then paste one of the prompts above: VS Code finds FDIC branch deposits on Spiral, shows the price and runs it.

FDIC branch deposits providers and prices

Spiral runs FDIC branch deposits through Alexandria. Open a card for today's price, with every fee included.

AlexandriaFinance
FDIC BankFind Suite · Deposits
banks-data-fdic-gov/bank-data/deposits

Settings you can ask for

Ask VS Code for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Cert1 to 9999999

FDIC certificate number, the institution id shared by every BankFind dataset (3511 = Wells Fargo Bank, N.A.; 628 = JPMorgan Chase Bank, N.A.). Find it with institutions. A number no institution has ever held is not_found.

Year1934 to 2100

One survey year (deposits as of June 30), 1994 onward. Not combinable with from_year / to_year.

To year1934 to 2100

Latest survey year to include.

From year1934 to 2100

Earliest survey year to include.

Page size1 to 100025

Records per page.

Sort orderasc or desc

Direction for every sort column. Defaults to the direction of the default sort.

Every API field of FDIC BankFind Suite · Deposits is on its tool page: open its card above.

What can you do with FDIC branch deposits in VS Code?

Build a bank research dashboard with FDIC institution profiles, branch maps, financial trends, and historical context. Keep annual deposit surveys, quarterly financial reports, structural events, and annual industry totals on their own timelines.

Research a Texas banking market

Identify banks and offices serving Austin, calculate annual deposit shares, and compare the banks' financial scale. Add statewide annual totals to put the local market in context.

Explain a bank's expansion

Combine institution identity, structural events, office locations, annual branch deposits, and quarterly financial reports. Show whether a larger footprint coincides with recorded mergers or financial growth.

Produce a state banking yearbook

Create a California banking reference with institution profiles, office coverage, deposit shares, financial comparisons, structural events, failure records, and annual industry totals. Label each table with its reporting period.

Study a banking crisis

Compare Florida failure and assistance records from 2008 through 2012 with bank financial reports, structural events, and annual statewide totals. Use branch deposit surveys to examine the geographic distribution of deposits during those years.

Compare local banking competitors

List banks serving Charlotte, compare their office networks and annual branch deposits, and place institution financial results beside North Carolina's annual banking totals.

Maintain a public banking dashboard

Display bank profiles, office maps, deposit concentration, financial trends, structural changes, failure records, and annual totals. Refresh each section according to its source reporting cycle.

Check a banking news article

Verify institution names, office locations, deposit figures, financial periods, structural event dates, failure estimates, and industry totals against FDIC records. Keep annual deposit snapshots separate from quarterly financial comparisons.

Questions about FDIC branch deposits in VS Code

Can VS Code use FDIC branch deposits?

Yes. Add Spiral to VS Code as an MCP server, and VS Code can find and run FDIC branch deposits like any built-in tool.

How much does FDIC branch deposits cost in VS Code?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your VS Code plan is separate.

Do I need an Alexandria account to use FDIC branch deposits in VS Code?

No. Spiral runs FDIC branch deposits on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up FDIC branch deposits in VS Code?

About two minutes: add the hosted server, then sign in.

Does VS Code wait while FDIC branch deposits runs?

FDIC branch deposits runs in the background. VS Code starts the run, checks on it and gives you the json when it's ready.

How far back do FDIC records go?

Institution records and failure records extend to 1934. Quarterly financial reporting starts in 1992, and annual branch deposit reports start in 1994.

Is BankFind data live?

FDIC demographic data updates weekly, and financial data updates quarterly. Branch deposits represent June 30 each year, while annual banking summaries use December 31 observations.

What does a branch deposit balance measure?

It is the branch's reported deposit balance at June 30, rather than a current balance. The annual survey includes insured U.S. branches of foreign banks.

Can historical deposit figures change?

Yes. FDIC accepts amendments to Summary of Deposits surveys, including corrected deposit amounts, addresses, county codes, and ZIP codes.

Does every failure record describe a bank closing?

The dataset includes both failures and assistance transactions from 1934 onward. Its financial measures include assets and deposits last reported before failure, and its resolution costs are estimates.

Get started

Start using FDIC branch deposits in VS Code

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into VS Code:

Set up VS Code

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options