Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
12 rows where bank_id = "clientis_oberaargau" 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 |
|---|---|---|---|---|---|---|---|
| 132 | Clientis Bank Oberaargau AG clientis_oberaargau | Bank Oberaargau — Website Aktuelle Zinssaetze Privatkunden (rendered HTML, captured 2026-Q2) | 2026-04-22 | de | 95ef6f3e5aad_aktuelle-zinssaetze.md | 2026-06-03 | BPG002K26AGB |
| 130 | Clientis Bank Oberaargau AG clientis_oberaargau | Bank Oberaargau — Preise und Gebuehren (consumer/retail) Stand Januar 2026 | 2026-01-01 | de | manual_BOA_Preise_und_Gebuehren.pdf | 2026-06-03 | BPG002WWHHWZ |
| 131 | Clientis Bank Oberaargau AG clientis_oberaargau | Bank Oberaargau — Preise fuer Dienstleistungen im Wertschriftengeschaeft Stand Januar 2026 | 2026-01-01 | de | manual_BOA_Preise_Dienstleistungen_Wertschriftengeschaeft.pdf | 2026-06-03 | BPG0027CCK0Q |
| 668 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Preise und Gebuehren | 2026-01-01 | de | fa3e9716d0c1_BOA_Preise_und_Gebuehren.pdf | 2026-06-05 | BPG0028Q6GXR |
| 669 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Preise DL Wertschriftengeschaeft | 2026-01-01 | de | 4180894fa919_BOA_Preise_Dienstleistungen_Wertschriftengeschaeft.pdf | 2026-06-05 | BPG002AWZF8M |
| 676 | Clientis Bank Oberaargau AG clientis_oberaargau | Clientis Anlegen Fondsinvest Flyer | 2026-01-01 | de | m5_CLI_Anlegen_Clientis_Fondsinvest_Flyer.pdf | 2026-06-05 | BPG002HHQMPB |
| 672 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Factsheet Sparkonto Top | 2025-07-01 | de | m5_BOA_factsheet_sparkonto_top.pdf | 2026-06-05 | BPG0022M40VY |
| 673 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Factsheet myMix Sparen | 2025-07-01 | de | m5_BOA_mymix_sparen.pdf | 2026-06-05 | BPG002NBW3SB |
| 671 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Factsheet Sparkonto | 2024-11-01 | de | m5_BOA_factsheet_sparkonto.pdf | 2026-06-05 | BPG002BKZXXN |
| 675 | Clientis Bank Oberaargau AG clientis_oberaargau | Clientis Factsheet Geldmarkthypothek SARON | 2024-02-01 | de | e99a684a5bc0_CLI_IT_Factsheet_Geldmarkthypothek.pdf | 2026-06-05 | BPG002MFKFTP |
| 670 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Factsheet Privatkonto | 2023-08-01 | de | m5_BOA_factsheet_privatkonto.pdf | 2026-06-05 | BPG002KD3XFS |
| 674 | Clientis Bank Oberaargau AG clientis_oberaargau | BOA Factsheet Kontokorrent | 2023-08-01 | de | m5_BOA_factsheet_kontokorrent.pdf | 2026-06-05 | BPG002HBBKB4 |
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;