Institution Franchise Footprint
fdic_franchise_footprintBreak down an FDIC-insured institution's branch and deposit distribution across metropolitan statistical areas using Summary of Deposits data, showing market-by-market counts, totals, and percentages.
Instructions
Analyze the geographic franchise footprint of an FDIC-insured institution using Summary of Deposits (SOD) data.
Shows how an institution's branches and deposits are distributed across metropolitan statistical areas (MSAs), providing a market-by-market breakdown of branch count, deposit totals, and percentage of the institution's total deposits.
Output includes:
Total branch count, deposits, and market count
Market-by-market breakdown sorted by deposits
Structured JSON for programmatic consumption
Branches outside MSAs are grouped under "Non-MSA / Rural".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cert | Yes | FDIC Certificate Number | |
| year | No | SOD report year. Defaults to most recent. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||