Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
6 rows where bank_id = "gekb" sorted by valid_from descending
This data as json, CSV (advanced)
Suggested facets: valid_from, parsed_at, valid_from (date), parsed_at (date)
| id | bank_id | title | valid_from ▲ | language | filename | parsed_at | bpg |
|---|---|---|---|---|---|---|---|
| 924 | Banque Cantonale de Geneve gekb | Taux hypothecaires (au 14.07.2026) | 2026-07-14 | fr | 364ec56ae366_taux-hypo.md | 2026-08-03 | BPG002X2TXTX |
| 925 | Banque Cantonale de Geneve gekb | Taux des comptes hub page (Q3) | 2026-07-14 | fr | 567ecbc4fa3c_taux-des-comptes.md | 2026-08-03 | BPG002VPQDAJ |
| 887 | Banque Cantonale de Geneve gekb | BCGE Taux des comptes — Brochure PDF (en vigueur 12.06.2026) | 2026-06-12 | fr | BCGE_brochure_taux_comptes.pdf | 2026-07-08 | BPG002ZG2GP0 |
| 888 | Banque Cantonale de Geneve gekb | BCGE Calculateur hypothecaire — Website (2026-Q2 crawl) | 2026-04-01 | fr | 7418b938e9d0_calculateur-hypothecaire.md | 2026-07-08 | BPG002VPVSKA |
| 298 | Banque Cantonale de Geneve gekb | Prestations et services bancaires - Tarifs et conditions | 2026-01-01 | fr | BCGE_brochure_tarif_conditions_paiement.pdf | 2026-04-10 | BPG00234Z0KR |
| 720 | Banque Cantonale de Geneve gekb | BCGE Prestations et Services Bancaires Tarifs et Conditions (2026-01-01) | 2026-01-01 | fr | 830c88423c9d_BCGE_brochure_tarif_conditions_paiement.pdf | 2026-08-11 | BPG002DHWE4H |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE source_document (
id INTEGER PRIMARY KEY AUTOINCREMENT,
bank_id TEXT NOT NULL REFERENCES bank(id),
title TEXT, -- Preisübersicht und Konditionen
valid_from TEXT, -- YYYY-MM-DD
language TEXT DEFAULT 'de',
filename TEXT, -- preisverzeichnis.pdf
parsed_at TEXT, -- YYYY-MM-DD
bpg CHAR(12) -- opaque global id, BPG002xxxxxx; populated post-load by bpg_assignments.sql
CHECK (bpg IS NULL OR bpg GLOB 'BPG002[0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z][0-9A-HJKMNP-TV-Z]')
);
CREATE INDEX idx_source_document_bank ON source_document(bank_id);
CREATE UNIQUE INDEX idx_source_document_bpg ON source_document(bpg) WHERE bpg IS NOT NULL;