product_snapshot

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

2,929 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target_group, client_type, currency, is_tailored, iso_account_type, notice_period_days, valid_from, access_tier, valid_from (date)

Next page

CREATE TABLE product_snapshot (
    id                  TEXT NOT NULL,
    snapshot_quarter    TEXT NOT NULL,               -- '2026-Q3'
    bank_id             TEXT NOT NULL,
    category            TEXT NOT NULL,
    target_group        TEXT,
    client_type         TEXT,
    currency            TEXT,
    name                TEXT NOT NULL,
    description         TEXT,
    is_tailored         INTEGER,
    iso_account_type    TEXT,
    notice_period_days  INTEGER,
    valid_from          TEXT,
    access_tier         TEXT,
    bpg                 CHAR(12),
    PRIMARY KEY (id, snapshot_quarter)
);
CREATE INDEX idx_product_snapshot_bank    ON product_snapshot(bank_id, snapshot_quarter);
CREATE INDEX idx_product_snapshot_quarter ON product_snapshot(snapshot_quarter);