Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
8 rows where bank_id = "vdkb" sorted by valid_from descending
This data as json, CSV (advanced)
Suggested facets: valid_from, language, parsed_at, valid_from (date), parsed_at (date)
| id | bank_id | title | valid_from ▲ | language | filename | parsed_at | bpg |
|---|---|---|---|---|---|---|---|
| 571 | Banque Cantonale Vaudoise vdkb | Tarifs pour la clientele privee | 2026-01-01 | fr | 42-558_Brochure-Tarifs-web.pdf | 2026-04-10 | BPG002NNYW7P |
| 573 | Banque Cantonale Vaudoise vdkb | Brochure LSFin - Tarifs des services financiers | 2026-01-01 | fr | a73a89113052_44-014-Brochure-LSFin-Tarifs-des-services-financiers.pdf | 2026-05-27 | BPG002KJM5Z0 |
| 572 | Banque Cantonale Vaudoise vdkb | Taux des comptes | 2025-11-01 | fr | 40-710-Affiche-Taux-Comptes-web.pdf | 2026-04-10 | BPG002KD17C6 |
| 695 | Banque Cantonale Vaudoise vdkb | BCV Brochure Tarifs (EN) | 2024-01-01 | en | b7463c1913e2_42-558e-Brochure-Tarifs.pdf | 2026-06-03 | BPG002YXP7F2 |
| 696 | Banque Cantonale Vaudoise vdkb | BCV Brochure LSFin Tarifs des services financiers (EN) | 2024-01-01 | en | 86ea10f10504_44-014e-Brochure-LSFin-Tarifs-des-services-financiers.pdf | 2026-06-03 | BPG00295ZBQM |
| 697 | Banque Cantonale Vaudoise vdkb | BCV Fiche tarif Conseil Classique | 2024-01-01 | fr | 726ed69965a5_43-381_Fiche-tarif-BCV-Conseil-Classique.pdf | 2026-06-03 | BPG002FCHA2P |
| 698 | Banque Cantonale Vaudoise vdkb | BCV Fiche tarif Conseil Premium | 2024-01-01 | fr | b760599e18c1_43-382-Fiche-tarif-BCV-Conseil-Premium.pdf | 2026-06-03 | BPG00239CZ2R |
| 699 | Banque Cantonale Vaudoise vdkb | BCV TradeDirect Brochure | 2024-01-01 | fr | 842b3ce66221_42-100_brochure_tradedirect_fr-web.pdf | 2026-06-03 | BPG0028HN2TP |
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;