home / bankproducts

bank_membership

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

9 rows where organisation_id = "swiss_fippp"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: joined (date), extracted_at (date)

Link bank_id organisation_id role status joined exited source_url source_filename extracted_at confidence note
deutschebank,swiss_fippp,founding_member Deutsche Bank (Suisse) SA deutschebank Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Deutsche Bank (Schweiz) AG
hsbc,swiss_fippp,founding_member HSBC Private Bank (Suisse) SA hsbc Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: HSBC Private Bank (Suisse) SA
juliusbaer,swiss_fippp,founding_member Bank Julius Bär & Co. AG juliusbaer Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Bank Julius Bär & Co AG
lombardodier,swiss_fippp,founding_member Lombard Odier & Cie SA lombardodier Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Banque Lombard Odier & Cie SA
raiffeisen_schweiz,swiss_fippp,founding_member Raiffeisen Schweiz Genossenschaft raiffeisen_schweiz Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Raiffeisen Schweiz Genossenschaft
ubs,swiss_fippp,founding_member UBS Switzerland AG ubs Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: UBS AG (parent group); our DB carries UBS Switzerland AG (Swiss subsidiary) — membership is at parent-group level
vali,swiss_fippp,founding_member Valiant Bank AG vali Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Valiant Bank AG
vontobel,swiss_fippp,founding_member Bank Vontobel AG vontobel Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Bank Vontobel AG
zkb,swiss_fippp,founding_member Zuercher Kantonalbank zkb Swiss Financial Intelligence Public Private Partnership swiss_fippp founding_member active 2024-11-08   https://www.fedpol.admin.ch/de/nsb?id=103066 swiss-fippp-2024.md 2026-06-24 authoritative FIPPP source: Zürcher Kantonalbank

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE bank_membership (
    bank_id          TEXT NOT NULL REFERENCES bank(id),
    organisation_id  TEXT NOT NULL REFERENCES organisation(id),
    role             TEXT NOT NULL DEFAULT 'member',  -- see header for vocabulary
    status           TEXT DEFAULT 'active',           -- 'active' / 'former' / 'suspended' / 'pending'
    joined           TEXT,                             -- ISO date or year-only YYYY (NULL if unknown)
    exited           TEXT,                             -- ISO date or year-only YYYY (NULL if still active)
    source_url       TEXT,                             -- URL where membership was observed
    source_filename  TEXT,                             -- filename in Organisations-Memberships/<quarter>/
    extracted_at     TEXT,                             -- ISO date when this row was last verified
    confidence       TEXT DEFAULT 'authoritative',     -- 'authoritative' / 'research_grade' / 'inferred'
    note             TEXT,                             -- free-text context
    PRIMARY KEY (bank_id, organisation_id, role)
);
CREATE INDEX idx_bank_membership_bank ON bank_membership(bank_id);
CREATE INDEX idx_bank_membership_org  ON bank_membership(organisation_id);
CREATE INDEX idx_bank_membership_role ON bank_membership(role);
Powered by Datasette · Queries took 21.28ms · Data license: CC-BY-4.0 · Data source: bankproducts.info