product_feature

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

2 rows where product_id = "bcp:trade_finance"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
bcp:trade:pf:atom_274_81 Commodity Trade Finance bcp:trade_finance pricing_condition Atom #274 81st instance — trade-finance specialty + LU + Dubai branches BCP Geneva: founded 1963. International commodity trade finance specialist with branches in Luxembourg + Dubai. FINMA-supervised. Credit ratings Fitch BBB- (Stable) / Moody's Baa3 (Positive). 1000+ banking correspondent network. Distinctive within atom #274 — specialty trade-finance focus rather than classical UHNW WM (closest cohort peers: Aletti commodities/Italian-focus, BACE Algeria-trade-finance, Habib MENA-trade).  
bcp:trade:pf:atom_300_crawler_bug Commodity Trade Finance bcp:trade_finance pricing_condition Atom #300 — crawler discovery falsely clustered as branch_of bbo (FIRST OBSERVED) The crawler marked BCP as status:"branch_of" detail:"Same homepage as bbo; data shared with canonical". FALSE: BCP is Geneva-based trade-finance, completely unrelated to BBO Bank Brienz Oberhasli (Berner Oberland regional). 5 different banks (bcp/beb/bsd/bsu + bbo) falsely clustered. Likely cause: homepage-similarity heuristic with too-loose threshold misidentifies basic cooperative-bank navigation structures as identical. Worth Walid follow-up.  

Advanced export

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

CSV options: 

CREATE TABLE product_feature (
    id          TEXT PRIMARY KEY,
    product_id  TEXT NOT NULL REFERENCES product(id),
    feature_key TEXT NOT NULL,          -- withdrawal_limit_free, notice_period, daily_limit, monthly_limit,
                                        -- interest_late_payment, max_balance, included_services, ...
    feature_value TEXT,
    note        TEXT,
    source_page INTEGER
);
CREATE INDEX idx_product_feature_product ON product_feature(product_id);
CREATE INDEX idx_product_feature_key ON product_feature(feature_key);