Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
12 rows where bank_id = "bs_bank_schaffhausen" 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 |
|---|---|---|---|---|---|---|---|
| 662 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Beratungsmandate | 2026-07-01 | de | 6b3e545e6da3_bsb-factsheet-beratungsmandate.pdf | 2026-06-05 | BPG002BWTARK |
| 654 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Preise DL Wertschriftengeschaeft | 2026-03-01 | de | beaba38ad2c3_BSB_Preise_DL_WS_Geschaeft.pdf | 2026-06-05 | BPG002CF9A7G |
| 653 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Preise und Gebuehren | 2026-01-01 | de | 91b4cb968501_BSB_Preise_und_Gebuehren.pdf | 2026-06-05 | BPG002G4YMVR |
| 658 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Sparkonto Top | 2026-01-01 | de | afdbd9d5c112_BSB_IT_150_FS_Sparkonto_Top.pdf | 2026-06-05 | BPG002E6FMSW |
| 659 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Sparkonto60 | 2026-01-01 | de | 31bab49d4099_BSB_IT_150_FS_Anlagesparkonto_Sparen60.pdf | 2026-06-05 | BPG0023N7WQT |
| 661 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Execution only | 2026-01-01 | de | 586941ccd831_bsb-factsheet-execution-only.pdf | 2026-06-05 | BPG002YQ55Q1 |
| 251 | BS Bank Schaffhausen AG bs_bank_schaffhausen | bsbank.ch (manual fallback) | 2024-01-01 | de | MANUAL_FALLBACK_bsbank_2026q2 | 2026-06-03 | BPG002JVW51D |
| 663 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Geldmarkthypothek SARON | 2024-01-01 | de | 31b5e0485314_BSB_IT_Factsheet_Geldmarkthypothek.pdf | 2026-06-05 | BPG002862XSP |
| 660 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Wertschriftenkonto | 2023-10-01 | de | 56ccee79a498_bsb-factsheet-wertschriftenkonto.pdf | 2026-06-05 | BPG0027PC8BT |
| 657 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet US-Dollarkonto | 2022-06-01 | de | 299fdccd3241_BSB_IT_120_FS_US_Dollarkonto.pdf | 2026-06-05 | BPG0023P6QCK |
| 656 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Eurokonto | 2022-02-01 | de | ce7c42374bdc_BSB_IT_120_FS_Eurokonto.pdf | 2026-06-05 | BPG002Z1FYQP |
| 655 | BS Bank Schaffhausen AG bs_bank_schaffhausen | BSB Factsheet Kontokorrent CHF | 2022-01-01 | de | 7fbfa3477429_BSB_IT_120_FS_Kontokorrent.pdf | 2026-06-05 | BPG002QG96NH |
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;