Best used with an AI agent

40+ live apps, open data APIs, MCP servers, and 200+ guides - more than anyone wants to click through. Point your AI here and it reads the whole map and does the work: finds the tool, pulls the data, runs the analysis, and hands you the links.

Here for the open-source code? Your agent finds the right repo for you - and can even clone and deploy it.

Prefer to explore on your own? Go right ahead.

Paste this to Claude Code, Codex, or any AI agent:
Go to tigzig.com and read tigzig.com/llms.txt. It is a practitioner toolkit - 40+ analytics apps, open no-auth data APIs, MCP servers, open-source repos (github.com/amararun), and 200+ build guides. Help me [your task]. Surface the exact links; where there is an API or MCP, call it directly; and if I want to self-host, find the repo and help me deploy it.

ECB SII vs LSI NPL - data tables

Detailed data tables backing the ECB Supervisory Banking Statistics analysis on the SII vs LSI non-performing loan divergence. Companion to the analysis note. Tables organised as expandable sections - click any heading to expand or collapse.

What this covers

The bank-side tables on this page (Tables 1-6) cover the entire euro area banking sector under ECB supervision: 109 Significant Institutions (SII) directly supervised by the ECB Single Supervisory Mechanism, plus about 1,811 Less Significant Institutions (LSI) supervised by national authorities under ECB oversight. Together this is roughly 1,920 banks holding about EUR 33.8 trillion in assets - SII at ~85% of the total and LSI at ~15%. This is not a sample; it is effectively the complete euro area banking system.

What sits outside: branches of non-EU banks operating in the euro area (supervised by their home authority, typically <2-3% of activity), pure investment firms and asset managers not classified as credit institutions, and shadow-banking entities tracked under separate ECB statistics. None of these are material for the SII vs LSI corporate-NPL story.

Table 7 (German corporate insolvencies, IWH-Insolvenztrend) is a separate independent indicator from a different source, used as a leading signal for the German LSI corporate-NPL trend.

Sources

Tables 1-7 · ECB SDMX REST API. All bank NPL / asset numbers extracted live from the ECB Statistical Data Warehouse via the SDMX REST API. Public endpoint, no authentication, free for re-use.

API bases: https://data-api.ecb.europa.eu/service/data/SUP/ (Supervisory Banking Statistics, quarterly) and https://data-api.ecb.europa.eu/service/data/CBD2/ (Consolidated Banking Data, used for the long-history view).

ECB API documentation: data.ecb.europa.eu/help/api/overview. SUP dataset structure: data.ecb.europa.eu/data/datasets/SUP.

Data anchor: Q1 2026 for SII (released 19 June 2026), Q4 2025 for LSI (LSI Q1 2026 not published until 16 July 2026 - ECB publishes LSI on a ~25 day lag vs SII).

NPL ratios are stock measures (point-in-time, end of quarter). No quarterly de-cumulation needed. Validation methodology + cross-checks against published ECB PDFs: see VALIDATION_REPORT.md in the source repository.

Table 8 · IWH-Insolvenztrend. German corporate insolvency early indicator (monthly), published by the Leibniz-Institut für Wirtschaftsforschung Halle (IWH). Public dataset, freely available. Source page (English): iwh-halle.de. Excel download: iwh-halle.de Excel. The raw Excel + the German-language May 2026 press release PDF are also bundled in this folder for offline reference.

Table 1: SII vs LSI NPL ratios by counterparty - quarterly history

The headline divergence table. Non-performing loan ratios for Significant Institutions (SII) and Less Significant Institutions (LSI), split by counterparty sector. SII covers ~109 ECB-supervised banks; LSI covers ~2,000 smaller national-supervisor-overseen banks. SII data goes through Q1 2026; LSI runs one quarter behind (LSI Q1 2026 not released until 16 July 2026).

QuarterSII TotalSII NFCSII HouseholdsLSI TotalLSI NFCLSI Households
2020-Q23.50%5.27%3.46%2.53%4.09%1.95%
2020-Q33.43%5.24%3.30%2.47%4.00%1.95%
2020-Q43.22%4.88%3.05%2.48%4.05%1.94%
2021-Q13.21%4.85%3.09%2.61%4.27%1.98%
2021-Q22.97%4.57%2.80%2.37%3.82%1.87%
2021-Q32.80%4.31%2.64%2.28%3.68%1.79%
2021-Q42.61%3.88%2.51%2.23%3.48%1.80%
2022-Q12.51%3.76%2.42%2.19%3.44%1.76%
2022-Q22.35%3.48%2.29%2.11%3.30%1.69%
2022-Q32.30%3.41%2.25%2.06%3.26%1.64%
2022-Q42.27%3.37%2.15%2.06%3.28%1.61%
2023-Q12.24%3.36%2.16%2.05%3.26%1.60%
2023-Q22.26%3.38%2.20%2.08%3.30%1.61%
2023-Q32.27%3.40%2.21%2.15%3.44%1.64%
2023-Q42.30%3.48%2.19%2.38%3.96%1.72%
2024-Q12.31%3.55%2.25%2.47%4.13%1.75%
2024-Q22.30%3.56%2.24%2.56%4.28%1.77%
2024-Q32.31%3.65%2.25%2.55%4.45%1.83%
2024-Q42.28%3.53%2.23%2.69%4.80%1.88%
2025-Q12.24%3.49%2.21%2.71%4.85%1.91%
2025-Q22.22%3.50%2.16%2.72%4.89%1.92%
2025-Q32.22%3.51%2.16%2.79%5.06%1.93%
2025-Q42.18%3.45%2.11%2.81%5.16%1.93%
2026-Q12.18%3.44%2.14%---

Ratios are stock measures (point in time, end of quarter). No de-cumulation needed. Source: ECB SDMX REST API (CB_ITEM=I7005, SBS_DI_1=SII/LSI, COUNTERPART_SECTOR=_Z/S11/S14).

Table 2: SII NPL by bank business model + LSI - quarterly history

Within the SII population, ECB breaks banks by business model (SBS_BREAKDOWN dimension). Shown here: total SII, retail/consumer-credit specialists, universal+investment banks, G-SIBs, plus LSI as the contrast. Demonstrates that the LSI rise is unique - all SII archetypes are flat-to-falling.

QuarterSII Total (all)SII Retail+ConsumerSII Universal+InvestmentSII G-SIBsLSI Total
2020-Q23.50%3.63%3.04%2.88%2.53%
2020-Q33.43%3.53%3.13%2.88%2.47%
2020-Q43.22%3.02%2.77%2.88%2.48%
2021-Q13.21%3.23%2.68%2.89%2.61%
2021-Q22.97%3.04%2.57%2.84%2.37%
2021-Q32.80%3.02%2.38%2.78%2.28%
2021-Q42.61%2.81%2.20%2.63%2.23%
2022-Q12.51%2.66%2.07%2.54%2.19%
2022-Q22.35%2.52%1.89%2.43%2.11%
2022-Q32.30%2.52%1.87%2.40%2.06%
2022-Q42.27%1.87%1.90%2.41%2.06%
2023-Q12.24%1.87%1.85%2.40%2.05%
2023-Q22.26%1.89%1.96%2.43%2.08%
2023-Q32.27%1.81%1.95%2.47%2.15%
2023-Q42.30%1.77%2.03%2.48%2.38%
2024-Q12.31%1.78%2.04%2.49%2.47%
2024-Q22.30%1.73%2.02%2.49%2.56%
2024-Q32.31%1.81%2.02%2.52%2.55%
2024-Q42.28%1.71%2.04%2.48%2.69%
2025-Q12.24%1.72%1.98%2.44%2.71%
2025-Q22.22%1.65%1.97%2.43%2.72%
2025-Q32.22%1.70%1.93%2.47%2.79%
2025-Q42.18%1.66%1.87%2.47%2.81%
2026-Q12.18%1.69%1.85%2.49%-

Source: ECB SDMX REST API (CB_ITEM=I7005, SBS_BREAKDOWN={_T,RCCL,UNI,GSIB}).

Table 3: Supporting metrics - Stage 2 / Stage 3 / Coverage / Cost of Risk - quarterly

The IFRS 9 forward-looking metrics and risk-management ratios that sit alongside the NPL ratio. Stage 2 = "significant credit risk increase" (loans not yet defaulted but worth watching). Stage 3 = credit-impaired (essentially the same population as NPL). Coverage = allowances on NPLs / NPL stock. Cost of Risk = annualised impairment / loans (closest analog to a US-style charge-off rate).

QuarterStage 2 TotalStage 2 NFCStage 2 HHStage 3 TotalNPL Coverage %Cost of Risk %
2019-Q1-----0.75%
2019-Q2-----0.52%
2019-Q3-----0.47%
2019-Q4-----0.50%
2020-Q1-----0.66%
2020-Q28.41%--3.54%45.47%0.70%
2020-Q38.16%12.26%6.91%3.48%45.53%0.67%
2020-Q49.27%14.49%7.38%3.25%45.07%0.69%
2021-Q19.23%14.47%7.19%3.23%44.81%0.64%
2021-Q29.01%14.35%6.98%2.84%44.45%0.57%
2021-Q38.85%14.10%6.87%2.69%45.20%0.53%
2021-Q49.14%13.90%7.41%2.51%44.59%0.50%
2022-Q19.28%14.38%7.33%2.44%44.96%0.56%
2022-Q29.72%14.61%7.98%2.27%44.05%0.52%
2022-Q39.83%14.63%8.14%2.22%44.25%0.48%
2022-Q49.62%13.77%8.39%2.21%43.61%0.47%
2023-Q19.31%13.34%8.35%2.18%43.69%0.46%
2023-Q29.19%12.93%8.38%2.21%42.91%0.45%
2023-Q39.29%13.34%8.31%2.22%42.50%0.44%
2023-Q49.73%13.73%8.89%2.25%42.14%0.46%
2024-Q19.50%13.59%8.85%2.27%41.58%0.49%
2024-Q29.45%13.56%8.81%2.27%41.97%0.46%
2024-Q39.74%14.01%9.20%2.28%41.66%0.46%
2024-Q49.93%13.93%9.64%2.25%41.41%0.47%
2025-Q19.76%13.81%9.68%2.20%41.63%0.56%
2025-Q29.59%13.65%9.48%2.18%41.77%0.47%
2025-Q39.49%13.57%9.41%2.17%41.98%0.48%
2025-Q49.33%13.32%9.03%2.14%41.41%0.47%
2026-Q19.29%13.23%9.13%2.12%41.41%0.58%

All series at SII aggregate level for the euro area. Source: ECB SDMX REST API (CB_ITEMs I7500, I7600, I3647, I2110).

Table 4: Long-history NPL - euro area all banking groups (CBD2) - quarterly Q4 2014 to Q4 2025

To see the longer cycle, switch from SUP (which only goes back to Q2 2020) to ECB's Consolidated Banking Data v2 (CBD2). CBD2 covers all euro area banking groups + stand-alones (a wider sample than SUP) so the level differs slightly, but the multi-year trajectory is what matters. Shows the post-sovereign-debt-crisis cleanup (8.12% Q4 2014 to 1.84% Q3 2022 trough) and the gentle rise since.

QuarterEuro area NPL ratio (all banking groups, CBD2)
2014-Q48.12%
2015-Q17.87%
2015-Q27.72%
2015-Q37.55%
2015-Q47.33%
2016-Q17.21%
2016-Q26.99%
2016-Q36.89%
2016-Q46.49%
2017-Q16.23%
2017-Q25.76%
2017-Q35.42%
2017-Q44.83%
2018-Q14.65%
2018-Q24.32%
2018-Q34.09%
2018-Q43.74%
2019-Q13.65%
2019-Q23.55%
2019-Q33.39%
2019-Q43.21%
2020-Q13.05%
2020-Q22.93%
2020-Q32.82%
2020-Q42.63%
2021-Q12.55%
2021-Q22.35%
2021-Q32.20%
2021-Q42.09%
2022-Q11.98%
2022-Q21.89%
2022-Q31.84%
2022-Q41.88%
2023-Q11.85%
2023-Q21.90%
2023-Q31.91%
2023-Q41.94%
2024-Q11.96%
2024-Q21.98%
2024-Q31.99%
2024-Q42.00%
2025-Q12.00%
2025-Q22.00%
2025-Q32.00%
2025-Q42.00%

Different dataset from SUP. Denominator includes cash balances at central banks (SUP excludes these). Source: ECB SDMX REST API (CBD2 dataset, CB_ITEM=I3632).

Table 5: NPL ratios by country - latest quarter, all 21 euro area + Bulgaria

Country-level drill-down. SII numbers are Q1 2026 (latest available); LSI numbers are Q4 2025 (LSI Q1 2026 not published until 16 July 2026). Six countries (CY, BG, HR, SK, LU, MT) have no Significant Institutions at highest consolidation - their SII cells show "-". Sorted by combined total banking system size (France > Germany > Spain > Italy > Netherlands > ...).

Country codeCountrySII TotalSII NFCSII HouseholdsLSI TotalLSI NFCLSI Households
FRFrance2.52%3.92%2.27%3.09%5.41%4.77%
DEGermany1.84%3.84%1.69%2.35%4.58%1.58%
ESSpain2.77%2.98%3.59%2.15%3.56%2.01%
ITItaly2.11%3.40%1.70%8.00%10.03%5.17%
NLNetherlands1.46%2.83%1.11%1.27%2.75%0.67%
ATAustria2.58%4.05%2.04%3.85%6.74%2.73%
FIFinland1.19%1.35%1.26%2.87%4.11%2.40%
IEIreland1.35%2.98%1.63%1.23%2.09%-
BEBelgium-3.31%0.74%2.16%2.11%2.38%
GRGreece2.97%2.00%7.33%4.86%4.25%18.07%
PTPortugal2.16%3.68%1.62%2.83%4.63%2.15%
LULuxembourg---2.11%2.83%3.60%
LTLithuania0.86%1.51%1.66%5.43%7.16%4.27%
LVLatvia0.57%0.92%0.49%10.14%12.22%7.46%
SISlovenia2.56%3.99%1.88%1.87%5.80%1.33%
EEEstonia1.49%1.83%0.85%2.75%2.24%3.13%
BGBulgaria---5.85%8.54%3.54%
HRCroatia---4.09%4.62%4.50%
SKSlovakia---2.83%6.62%2.66%
MTMalta---3.16%4.22%3.12%
CYCyprus---21.59%9.17%-

Same SDMX endpoint as Table 1, with REF_AREA dimension varied. Source: ECB SDMX REST API (CB_ITEM=I7005).

Table 6: Total assets by country - SII + LSI - latest quarter, EUR billions

Bank sector size by country. Germany dominates the LSI sector (~63% of euro area LSI assets - the Sparkassen + Volksbanken cooperative network). France dominates SII (~35%). Total euro area banking system is ~EUR 33.8 trillion. SII numbers are Q1 2026; LSI Q4 2025. Bulgaria, Croatia, Slovakia, Cyprus, Luxembourg, Malta show no SII assets because they have no Significant Institutions at highest consolidation.

Country codeCountrySII assets (EUR bn)LSI assets (EUR bn)SII share of EA SIILSI share of EA LSITotal assets (EUR bn)
FRFrance9,97015334.7%3.1%10,123
DEGermany5,4833,11719.1%63.0%8,600
ESSpain4,03724514.1%5.0%4,282
ITItaly2,6873379.4%6.8%3,024
NLNetherlands2,6012039.1%4.1%2,804
ATAustria8613683.0%7.4%1,229
FIFinland776652.7%1.3%841
IEIreland735872.6%1.7%821
BEBelgium709272.5%0.5%736
GRGreece355201.2%0.4%375
PTPortugal269710.9%1.4%340
LULuxembourg-146-2.9%146
LTLithuania6350.2%0.1%68
LVLatvia6240.2%0.1%66
SISlovenia5850.2%0.1%63
EEEstonia3680.1%0.2%44
BGBulgaria-32-0.7%32
HRCroatia-24-0.5%24
SKSlovakia-16-0.3%16
MTMalta-13-0.3%13
CYCyprus-3-0.1%3
-TOTAL EURO AREA28,7024,949100.0%100.0%33,651

Source: ECB SDMX REST API (CB_ITEM=A0000, DATA_TYPE=ALL, BS_SUFFIX=E for EUR amount).

Table 7: German corporate insolvency early indicator (IWH-Insolvenztrend) - monthly

Independent corroborating data set. The Leibniz-Institut für Wirtschaftsforschung Halle (IWH) publishes a monthly early indicator of corporate (partnerships and corporations) insolvencies in Germany, derived from real-time bankruptcy notifications of the German register courts and linked to firm-level data from Bureau van Dijk. IWH publishes 2-3 months ahead of the official Destatis statistics.

This matters for the LSI corporate-NPL thesis because Germany dominates the euro area LSI sector (about 63% of LSI assets - Sparkassen + Volksbanken) and the LSI book is heavily SME-oriented. German corporate insolvencies are therefore the cleanest leading indicator of where the LSI NFC NPL rate is heading.

Numbers shown: the Excel file (snapshot date 2026-06-01) covers Jan 2020 - Feb 2026. The May 2026 number (1,518; +3% YoY, -15% MoM vs April 2026) is added from the IWH press release 2026-15 (also saved in this folder). The third column shows each month against its pre-pandemic baseline (mean of 2016-2019 for the same calendar month). Positive numbers mean insolvencies are running above the pre-pandemic norm.

MonthGermany insolvencies (corp + partnership)vs pre-pandemic 2016-19 baseline
2020-01943+4.5%
2020-02901-3.1%
2020-03946-5.4%
2020-04900-7.7%
2020-05986+1.8%
2020-06894-5.3%
2020-07860-11.0%
2020-08665-28.9%
2020-09665-26.3%
2020-10725-21.4%
2020-11651-26.4%
2020-12890+2.4%
2021-01685-24.1%
2021-02713-23.4%
2021-03869-13.1%
2021-04765-21.5%
2021-05679-29.9%
2021-06705-25.3%
2021-07639-33.8%
2021-08566-39.5%
2021-09567-37.1%
2021-10619-32.9%
2021-11650-26.5%
2021-12716-17.6%
2022-01593-34.3%
2022-02701-24.6%
2022-03771-22.9%
2022-04757-22.4%
2022-05777-19.8%
2022-06707-25.1%
2022-07714-26.1%
2022-08715-23.6%
2022-09761-15.6%
2022-10719-22.0%
2022-11805-9.0%
2022-12870+0.1%
2023-01777-13.9%
2023-02831-10.7%
2023-03958-4.2%
2023-04927-4.9%
2023-05910-6.1%
2023-061,046+10.8%
2023-071,021+5.7%
2023-08999+6.8%
2023-091,018+12.9%
2023-101,033+12.0%
2023-11969+9.6%
2023-121,072+23.4%
2024-011,080+19.6%
2024-021,192+28.1%
2024-031,301+30.0%
2024-041,342+37.6%
2024-051,261+30.1%
2024-061,156+22.4%
2024-071,401+45.1%
2024-081,265+35.2%
2024-091,295+43.6%
2024-101,522+65.1%
2024-111,335+51.0%
2024-121,330+53.0%
2025-011,337+48.1%
2025-021,432+53.9%
2025-031,453+45.2%
2025-041,618+65.9%
2025-051,476+52.3%
2025-061,415+49.9%
2025-071,579+63.5%
2025-081,403+50.0%
2025-091,469+62.9%
2025-101,548+67.9%
2025-111,287+45.5%
2025-121,513+74.1%
2026-011,391+54.1%
2026-021,466+57.6%
2026-031,716+71.5%
2026-041,776+82.2%
2026-051,518+56.7%
2020-011,024+13.4%
2020-02953+2.4%
2020-031,002+0.1%
2020-04976+0.1%
2020-051,054+8.8%
2020-06938-0.7%
2020-07926-4.1%
2020-08725-22.5%
2020-09756-16.2%
2020-10759-17.7%
2020-11729-17.6%
2020-12885+1.8%
2021-01761-15.7%
2021-02761-18.2%
2021-03896-10.4%
2021-04836-14.3%
2021-05682-29.6%
2021-06776-17.8%
2021-07711-26.4%
2021-08670-28.4%
2021-09612-32.2%
2021-10678-26.5%
2021-11698-21.1%
2021-12751-13.6%
2022-01639-29.2%
2022-02742-20.2%
2022-03813-18.7%
2022-04816-16.3%
2022-05798-17.6%
2022-06732-22.5%
2022-07734-24.0%
2022-08729-22.1%
2022-09820-9.1%
2022-10823-10.7%
2022-11857-3.1%
2022-12931+7.1%
2023-01813-9.9%
2023-02902-3.0%
2023-031,001+0.0%
2023-04974-0.1%
2023-05974+0.5%
2023-061,061+12.4%
2023-071,083+12.1%
2023-081,034+10.5%
2023-091,047+16.1%
2023-101,045+13.3%
2023-111,019+15.2%
2023-121,109+27.6%
2024-011,136+25.8%
2024-021,286+38.2%
2024-031,284+28.3%
2024-041,391+42.7%
2024-051,326+36.8%
2024-061,189+25.9%
2024-071,395+44.4%
2024-081,258+34.5%
2024-091,280+41.9%
2024-101,486+61.2%
2024-111,305+47.6%
2024-121,312+51.0%
2025-011,313+45.4%
2025-021,463+57.3%
2025-031,420+41.9%
2025-041,567+60.7%
2025-051,472+51.9%
2025-061,400+48.3%
2025-071,575+63.1%
2025-081,461+56.2%
2025-091,390+54.1%
2025-101,498+62.5%
2025-111,295+46.5%
2025-121,448+66.6%
2026-011,385+53.4%
2026-021,459+56.8%
2026-05 (PR)1,518+56.7%

Data source files saved alongside this HTML (for downstream re-use): iwh-insolvenztrend_daten.xlsx (Excel, full monthly history 2020-2026 plus by federal state and affected-employees) and iwh-press-release_2026-15.pdf (German-language press release for May 2026, with the 1,518 headline + commentary). Permanent public URL: iwh-halle.de press release (English landing page). Excel download (live): iwh-halle.de Excel. Methodology: bankruptcy announcements of German register courts linked with Bureau van Dijk firm-level data.