Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
6 rows where bank_id = "vali" 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 |
|---|---|---|---|---|---|---|---|
| 732 | Valiant Bank AG vali | Valiant Zinsen Hypotheken (Website-Snapshot) | 2026-04-22 | de | c42356c3ce2e_finanzieren-zinsen-hypotheken.md | 2026-06-04 | BPG002BFFSWQ |
| 734 | Valiant Bank AG vali | Valiant Konditionen-Vergleich (Website-Snapshot) | 2026-04-22 | de | 9204e48d2b6d_finanzieren-konditionen-vergleichen.md | 2026-06-04 | BPG002GVE18X |
| 733 | Valiant Bank AG vali | Valiant Zinssatz-Barometer (Website-Snapshot) | 2026-04-21 | de | e451545beb27_zahlen-zinssatz-barometer.md | 2026-06-04 | BPG0028XYNFW |
| 570 | Valiant Bank AG vali | Valiant Website Privatkunden | 2026-04-01 | de | valiant.ch crawl 2026-Q2 | 2026-04-10 | BPG002JJFDM8 |
| 731 | Valiant Bank AG vali | Factsheet Anlageloesungen und Preismodelle | 2026-04-01 | de | 2026-04_Factsheet_Anlageloesungen_D.pdf | 2026-06-04 | BPG0026RS5PX |
| 569 | Valiant Bank AG vali | Preisverzeichnis | 2026-02-10 | de | preisverzeichnis.pdf | 2026-04-10 | BPG0029GNSQM |
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;