Interest rates
Data license: CC-BY-4.0 · Data source: bankproducts.info
20 rows where bank_id = "ce_courtelary" sorted by snapshot_date descending
This data as json, CSV (advanced)
Suggested facets: product_id, rate_type, rate, tier_floor, tier_ceiling, currency, snapshot_date, valid_from, note, snapshot_date (date), valid_from (date)
| id | product_id | bank_id | rate_type | rate | tier_floor | tier_ceiling | tenor_months | currency | snapshot_date ▲ | valid_from | note | source_document_id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ce_courtelary:mymix_paiements:cleanup_sweep_on_request | myMix Paiements ce_courtelary:mymix_paiements | Caisse d'Epargne Courtelary SA ce_courtelary | credit | CHF | 2026-08-02 | 2026-07-01 | Konditionen fuer myMix Paiements (current_account) nicht im 2026-Q3 Crawl publiziert / auf Anfrage. Bulk NULL-anchor via cleanup-sweep. | |||||
| ce_courtelary:mymix_etudes:cleanup_sweep_on_request | myMix Etudes ce_courtelary:mymix_etudes | Caisse d'Epargne Courtelary SA ce_courtelary | credit | CHF | 2026-08-02 | 2026-07-01 | Konditionen fuer myMix Etudes (current_account) nicht im 2026-Q3 Crawl publiziert / auf Anfrage. Bulk NULL-anchor via cleanup-sweep. | |||||
| ce_courtelary:compte_euro:cleanup_sweep_on_request | Compte EUR ce_courtelary:compte_euro | Caisse d'Epargne Courtelary SA ce_courtelary | credit | EUR | 2026-08-02 | 2026-07-01 | Konditionen fuer Compte EUR (current_account) nicht im 2026-Q3 Crawl publiziert / auf Anfrage. Bulk NULL-anchor via cleanup-sweep. | |||||
| ce_courtelary:hypotheque_variable:mortgage | Hypothèque variable ce_courtelary:hypotheque_variable | Caisse d'Epargne Courtelary SA ce_courtelary | mortgage_rate | CHF | 2026-07-09 | 2026-04-01 | Sur demande — taux personalise | |||||
| ce_courtelary:hypotheque_fixe:mortgage | Hypothèque fixe ce_courtelary:hypotheque_fixe | Caisse d'Epargne Courtelary SA ce_courtelary | mortgage_rate | CHF | 2026-07-09 | 2026-04-01 | Sur demande — taux personalise | |||||
| ce_courtelary:mymix_etudes:credit:tier2 | myMix Etudes ce_courtelary:mymix_etudes | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.1 | 50000.0 | CHF | 2026-07-09 | 2026-04-01 | Au-dela | |||
| ce_courtelary:mymix_etudes:credit:tier1 | myMix Etudes ce_courtelary:mymix_etudes | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.2 | 0.0 | 50000.0 | CHF | 2026-07-09 | 2026-04-01 | Jusqu'a CHF 50000 | ||
| ce_courtelary:mymix_paiements:credit:tier2 | myMix Paiements ce_courtelary:mymix_paiements | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.1 | 50000.0 | CHF | 2026-07-09 | 2026-04-01 | Au-dela | |||
| ce_courtelary:mymix_paiements:credit:tier1 | myMix Paiements ce_courtelary:mymix_paiements | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.2 | 0.0 | 50000.0 | CHF | 2026-07-09 | 2026-04-01 | Jusqu'a CHF 50000 | ||
| ce_courtelary:compte_euro:credit | Compte EUR ce_courtelary:compte_euro | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.0 | EUR | 2026-07-09 | 2026-04-01 | |||||
| ce_courtelary:compte_courant:credit | Compte courant ce_courtelary:compte_courant | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.01 | CHF | 2026-07-09 | 2026-04-01 | Compte courant SME | ||||
| ce_courtelary:compte_prive:credit | Compte privé ce_courtelary:compte_prive | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.05 | CHF | 2026-07-09 | 2026-04-01 | |||||
| ce_courtelary:privor_3a:credit | Privor — Compte prévoyance ce_courtelary:privor_3a | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.4 | CHF | 2026-07-09 | 2026-04-01 | Privor — Compte prevoyance 3a | ||||
| ce_courtelary:compte_epargne_cadeau:credit:tier2 | Compte épargne cadeau ce_courtelary:compte_epargne_cadeau | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.1 | 10000.0 | CHF | 2026-07-09 | 2026-04-01 | Au-dela | |||
| ce_courtelary:compte_epargne_cadeau:credit:tier1 | Compte épargne cadeau ce_courtelary:compte_epargne_cadeau | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.5 | 0.0 | 10000.0 | CHF | 2026-07-09 | 2026-04-01 | Jusqu'a CHF 10000 | ||
| ce_courtelary:compte_epargne_top:credit | Compte epargne Top ce_courtelary:compte_epargne_top | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.3 | CHF | 2026-07-09 | 2026-04-01 | Compte epargne Top — taux flat | ||||
| ce_courtelary:compte_epargne:credit:tier2 | Compte épargne ce_courtelary:compte_epargne | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.05 | 100000.0 | CHF | 2026-07-09 | 2026-04-01 | Au-dela | |||
| ce_courtelary:compte_epargne:credit:tier1 | Compte épargne ce_courtelary:compte_epargne | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.1 | 0.0 | 100000.0 | CHF | 2026-07-09 | 2026-04-01 | Jusqu'a CHF 100000 | ||
| ce_courtelary:mymix_epargne:credit_t2 | myMix Epargne ce_courtelary:mymix_epargne | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.1 | 50000.0 | CHF | 2026-05-31 | 2026-01-01 | myMix Epargne (<25 ans): 0.100% au-delà de CHF 50'000. | |||
| ce_courtelary:mymix_epargne:credit_t1 | myMix Epargne ce_courtelary:mymix_epargne | Caisse d'Epargne Courtelary SA ce_courtelary | credit | 0.5 | 0.0 | 50000.0 | CHF | 2026-05-31 | 2026-01-01 | myMix Epargne (<25 ans): 0.500% jusqu'à CHF 50'000. |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE interest_rate (
id TEXT PRIMARY KEY, -- sgkb:sparkonto:credit:tier1
product_id TEXT NOT NULL REFERENCES product(id),
bank_id TEXT NOT NULL REFERENCES bank(id), -- denormalized
rate_type TEXT NOT NULL, -- credit (paid to customer), debit (charged to customer),
-- bonus (conditional extra), discount (reduction on base),
-- overdraft (penalty rate)
rate REAL, -- percentage value (0.050 = 0.050%); NULL = on request / not published
tier_floor REAL, -- balance threshold lower bound; NULL = from zero
tier_ceiling REAL, -- balance threshold upper bound; NULL = unlimited
tenor_months INTEGER, -- term length in months (24 = 2yr); NULL = no fixed term
currency TEXT DEFAULT 'CHF',
snapshot_date TEXT NOT NULL, -- date the rate was observed (YYYY-MM-DD)
valid_from TEXT, -- date the rate took effect (YYYY-MM-DD)
note TEXT, -- conditions, fine print
source_document_id INTEGER REFERENCES source_document(id)
);
CREATE INDEX idx_interest_rate_product ON interest_rate(product_id);
CREATE INDEX idx_interest_rate_bank ON interest_rate(bank_id);
CREATE INDEX idx_interest_rate_snapshot ON interest_rate(bank_id, snapshot_date);
CREATE INDEX idx_interest_rate_type ON interest_rate(rate_type, bank_id);