Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
11 rows where bank_id = "aikb" 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 |
|---|---|---|---|---|---|---|---|
| 691 | Appenzeller Kantonalbank aikb | AIKB Konditionen Zinssaetze Finanzieren (website) | 2026-08-10 | de | 2193cb86d963_konditionen-zinssaetze-finanzieren.md | 2026-08-10 | BPG002DC3AJJ |
| 692 | Appenzeller Kantonalbank aikb | AIKB Zahlungsverkehr Konditionen (website) | 2026-08-10 | de | 12bb2a86dd27_zahlungsverkehr-konditionen.md | 2026-08-10 | BPG002VD0CRJ |
| 830 | Appenzeller Kantonalbank aikb | Konto fuer Vereine / Servicekonto (Q3) | 2026-07-01 | de | b31348037851_konto-fuer-vereine.md | 2026-08-02 | BPG0022AAPC5 |
| 831 | Appenzeller Kantonalbank aikb | Privatkonto EUR Produktseite (Q3) | 2026-07-01 | de | 15d56276fa21_privatkonto-eur.md | 2026-08-02 | BPG002K9BXS2 |
| 832 | Appenzeller Kantonalbank aikb | Private Vorsorgen Service-Konditionen (Q3) | 2026-07-01 | de | 106436a9e1fa_private-vorsorgen-service-konditionen.md | 2026-08-02 | BPG002V2MBAK |
| 833 | Appenzeller Kantonalbank aikb | Zahlen — Karten-Konditionen (Q3) | 2026-07-01 | de | d929c5e16353_zahlen-konditionen-karten.md | 2026-08-02 | BPG002XSAWZK |
| 834 | Appenzeller Kantonalbank aikb | Private Zinssaetze und Rueckzuege (Q3) | 2026-07-01 | de | 1ae011dd1d11_private-zinssaetze-rueckzuege.md | 2026-08-02 | BPG00263FPQW |
| 617 | Appenzeller Kantonalbank aikb | AIKB Konditionen Anlageloesungen (website) | 2026-04-01 | de | 85a9647b4026_konditionen-anlageloesungen.md | 2026-06-04 | BPG002SNTQVT |
| 618 | Appenzeller Kantonalbank aikb | AIKB Konditionen Courtagen (website) | 2026-04-01 | de | 6da89ab94efb_konditionen-courtagen.md | 2026-06-04 | BPG002G26FCG |
| 619 | Appenzeller Kantonalbank aikb | AIKB APPKB-Invest Fondssparplan (website) | 2026-04-01 | de | c84e2d7520eb_appkb-invest.md | 2026-06-04 | BPG002ACYYF1 |
| 10 | Appenzeller Kantonalbank aikb | Produktseiten appkb.ch | 2026-01-01 | de | appkb.ch-product-pages | 2026-04-08 | BPG002AK0VSK |
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;