bank_profile

Data license: CC-BY-4.0 · Data source: bankproducts.info

402 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: too_big_to_fail, staatsgarantie, parent_group_relation, finma_category, retail_clients

Next page

CREATE TABLE bank_profile (
    bank_id                    TEXT PRIMARY KEY REFERENCES bank(id),
    -- continuity / identity
    operational_since          INTEGER,        -- year continuous operations began (NOT year_founded/Zefix)
    too_big_to_fail            INTEGER DEFAULT 0,  -- 1 if FINMA TBTF designation (category 1 or 2)
    staatsgarantie             TEXT,           -- 'full', 'limited', or NULL
    parent_group_relation      TEXT,           -- 'network_member', 'subsidiary', or NULL
    finma_category             INTEGER,        -- 1-5 (FINMA supervisory category)
    -- client access
    retail_clients             INTEGER,
    institutional_only         INTEGER
);
CREATE INDEX idx_bank_profile_finma ON bank_profile(finma_category);