Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
6 rows where bank_id = "grkb" 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 |
|---|---|---|---|---|---|---|---|
| 292 | Graubuendner Kantonalbank grkb | GKB Preise im Ueberblick | 2026-03-01 | de | 222a707a42bf_Preise-Ueberblick-DE.pdf | 2026-05-31 | BPG00274E86Q |
| 780 | Graubuendner Kantonalbank grkb | GKB Aktuelle Zinssaetze HTML-Snapshot (sibling of cited .md) | 2026-01-01 | de | 21d431489ea6_zinsen-konditionen.html | 2026-06-03 | BPG0024ABNF9 |
| 781 | Graubuendner Kantonalbank grkb | GKB Hypotheken + Kredite Uebersichtsseite | 2026-01-01 | de | f0bb3d9e3095_zinsen-und-kredite.md | 2026-06-03 | BPG002126H2R |
| 293 | Graubuendner Kantonalbank grkb | GKB Aktuelle Zinssaetze (Webseite) | 2025-09-01 | de | 21d431489ea6_zinsen-konditionen.md | 2026-05-31 | BPG0027NTYT7 |
| 295 | Graubuendner Kantonalbank grkb | Zinssatzanpassungen 09.2025 | 2025-09-01 | de | 87348f8d763e_zinssatzanpassungen-bei-der-gkb-09-2025.md | 2026-05-31 | BPG002RV4NFT |
| 294 | Graubuendner Kantonalbank grkb | Sparpyramide Factsheet | 2024-04-01 | de | 7163a4ef021c_Factsheet-Sparpyramide-DE.pdf | 2026-05-31 | BPG0026HYMM9 |
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;