Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
8 rows where bank_id = "cic" sorted by valid_from descending
This data as json, CSV (advanced)
Suggested facets: valid_from, valid_from (date), parsed_at (date)
| id | bank_id | title | valid_from ▲ | language | filename | parsed_at | bpg |
|---|---|---|---|---|---|---|---|
| 114 | Bank CIC (Schweiz) AG cic | Gebuehren und Konditionen fuer Privatpersonen (2026-01-14) | 2026-01-14 | de | 22115c72f333_gebuehren-und-konditionen-fuer-privatpersonen.pdf | 2026-05-30 | BPG002G4YWAT |
| 115 | Bank CIC (Schweiz) AG cic | Gebuehren und Konditionen fuer Unternehmen (2026-01-14) | 2026-01-14 | de | 31c1841b807e_gebuehren-und-konditionen-fuer-unternehmen.pdf | 2026-05-30 | BPG002XPDMTM |
| 116 | Bank CIC (Schweiz) AG cic | Kontosortiment fuer Privatpersonen (2025-11-12) | 2025-11-12 | de | 1b981e8b1a64_cic_Kontosortiment_Privatpersonen.pdf | 2026-05-30 | BPG002V53K4Q |
| 117 | Bank CIC (Schweiz) AG cic | Kontosortiment fuer Unternehmen (2025-11-12) | 2025-11-12 | de | 41522cf5ea81_cic_Kontosortiment_Unternehmen.pdf | 2026-05-30 | BPG002W6E0GK |
| 121 | Bank CIC (Schweiz) AG cic | Vorsorgereglement V3 (2024-12-23) | 2024-12-23 | de | 4345994b3963_20241223_Vorsorgereglement%20V3_DE.pdf.pdf | 2026-05-30 | BPG0022RDBXJ |
| 119 | Bank CIC (Schweiz) AG cic | Callgeld 32 Tage Factsheet | 2024-04-01 | de | 4c26cae09855_factsheet_callgeld-32-tage.pdf | 2026-05-30 | BPG002Y6FGYX |
| 120 | Bank CIC (Schweiz) AG cic | Callgeld 48h Factsheet | 2024-04-01 | de | 650786ff9649_FS_Callgeld_48h_DE.pdf | 2026-05-30 | BPG00245C242 |
| 118 | Bank CIC (Schweiz) AG cic | Festgeld Factsheet (DE) | 2023-05-03 | de | 1939a862d0d4_CIC_FS_Festgeld_D.pdf | 2026-05-30 | BPG002KGPT0Z |
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;