Banks

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

420 rows sorted by name descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country, bank_type, uid

Next page

CREATE TABLE bank (
    id          TEXT PRIMARY KEY,      -- zkb, postfinance, ubs, lgt
    name        TEXT NOT NULL,         -- Zürcher Kantonalbank
    country     TEXT NOT NULL,         -- CH, LI
    bank_type   TEXT,                  -- cantonal_bank, universal_bank, cooperative_bank, private_bank, state_bank, neobank
    website     TEXT,
    bic         TEXT,                  -- SWIFT/BIC code (e.g. ZHSZCHZZ80A)
    lei         TEXT,                  -- Legal Entity Identifier (20 chars)
    sic_iid     TEXT,                  -- SIX Interbank Clearing participant number
    uid         TEXT,                  -- Swiss UID (CHE-xxx.xxx.xxx) or national equivalent
    bpg         CHAR(12)               -- opaque global id, BPG001xxxxxx; populated post-load by bpg_assignments.sql
        CHECK (bpg IS NULL OR bpg GLOB 'BPG001[0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z]')
);
CREATE INDEX idx_bank_country ON bank(country);
CREATE UNIQUE INDEX idx_bank_bic ON bank(bic);
CREATE UNIQUE INDEX idx_bank_bpg ON bank(bpg) WHERE bpg IS NOT NULL;