product_feature

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

2 rows where product_id = "maerki:eam_services"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ product_id feature_key feature_value note source_page
maerki:eam_services:pf:eam_b2b_segment EAM-Services (externe Vermoegensverwalter) maerki:eam_services pricing_condition B2B EAM services (Betreuung externer Vermoegensverwalter) Maerki Baumann betreut externe Vermoegensverwalter (EAM-Geschaeft). Comparable to Aquila multi-IFA platform but Aquila is dedicated B2B-only. Maerki Baumann combines traditional UHNW retail with EAM platform services — uncommon combination. 2nd EAM-offering atom #274 instance after BIL Suisse (which lists similar service).  
maerki:eam_services:pf:lugano_first_ticino EAM-Services (externe Vermoegensverwalter) maerki:eam_services pricing_condition FIRST Ticino presence in atom #274 cohort (Geschaeftsstelle Lugano) Geschaeftsstelle Lugano serves Ticino + Italian-speaking clientele + Italian cross-border. Cohort city distribution after this load: Zurich x8, Geneva x4, Basel x3, Bern x1, Lucerne x1, Lugano TI x1 (NEW). Six cities now covered. 2nd multi-canton instance after Dreyfus (ZH+TI for Maerki, BS+VD+JU for Dreyfus).  

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);