Quarterly financial summaries by bank from 1984 to 2026, and institutions.
Publisher: Federal Deposit Insurance Corporation
This runs against the full table, free, with no key.
| Field | Type | Example |
|---|---|---|
| active | string | 1 |
| aoa | string | 7470 |
| aoar | string | 2.4315693876155975 |
| asdroth | string | |
| asdrres | string | |
| asset | string | 307209 |
| astempm | string | 2.04806 |
| bkclass | string | SL |
| bkprem | string | 5540 |
| callform | string | 100 |
| cb | string | 1 |
| cblrind | string | |
| cbsa | string | ORLANDO-KISSIMMEE-SANFORD, FL |
| cert | string | 29309 |
| chbal | string | 26805 |
| city | string | KISSIMMEE |
| coredep | string | 249460 |
| dep | string | 266729 |
| depallex | string | |
| depbefex | string | |
| depcsbq | string | 263156.2348 |
| depdastr | string | 86.82 |
| depdom | string | 266729 |
| depfor | string | 59135 |
| depidom | string | 251726 |
| depins | string | 263660 |
| depnidom | string | 15003 |
| depunins | string | 16570 |
| eeffr | string | 82.42778541953233 |
| effdate | string | 19930712 |
| eintexp | string | 6081 |
| elnantr | string | 255.9322033898305 |
| elnatr | string | 151 |
| elnatry | string | 0.1 |
| endefymd | string | 19970919 |
| eq | string | 18982 |
| eqcdiv | string | 0 |
| eqcdivntinc | string | 0 |
| eqcstkrx | string | 0 |
| eqtot | string | 18982 |
| eqv | string | 6.178855437177947 |
| ernastr | string | 93.71 |
| estymd | string | 19341201 |
| extra | string | 0 |
| fdicdbsdesc | string | ATLANTA |
| fdicsupvdesc | string | ATLANTA |
| feddesc | string | ATLANTA |
| fldoff | string | TAMPA |
| frepo | string | 0 |
| hctmult | string | 1 |
| ibefxtr | string | 572 |
| id | string | 29309_19960630 |
| iderncvr | string | 17.322033898305083 |
| idlncorr | string | 77.9636013789786 |
| idnccir | string | 0 |
| idncconr | string | 0 |
| idncgtpr | string | 0 |
| idncothr | string | 0 |
| idntcir | string | 0 |
| idntconr | string | 0.5238583304862772 |
| idt1cer | string | 0 |
| idt1rwajr | string | 11.244326678384972 |
| iglsec | string | 44 |
| insagnt1 | string | SAIF |
| insdate | string | 19890809 |
| intan | string | 288 |
| intexpy | string | 4.302964759938061 |
| intinc | string | 10863 |
| intincy | string | 7.686746618517868 |
| itax | string | 343 |
| liab | string | 288227 |
| lnatresr | string | 2.7049200830435978 |
| lnlsdepr | string | 72.91595589530947 |
| lnlsnet | string | 194488 |
| lnlsntv | string | 63.31 |
| lnndepc | string | |
| lnndepd | string | |
| lnresncr | string | 144.39912143081267 |
| lsalnls | string | |
| lsaoa | string |
81 more fields; select the table above to list them all.
Settings, Connectors, Add custom connector. Paste this address:
https://data.nysgpt.com/mcp
claude mcp add --transport http nysgpt-data https://data.nysgpt.com/mcp
curl -s https://data.nysgpt.com/query -H "content-type: application/json" \
-d '{"sql":"SELECT count(*) FROM govblock_awards.usaspending_contracts"}'Any MCP client works. The tools are list_databases, list_tables, describe_table and query (Athena SQL, read-only, up to 1,000 rows a query). With a paid key, add ?key=YOUR_KEY to the address or send the header X-Api-Key.
$1,500/month
20,000 queries and 1 TB scanned a day, for a lab, department or team.
SubscribePayment is by card through Stripe. The key appears on screen as soon as payment completes.