Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
5 rows where bank_id = "ubs" sorted by valid_from descending
This data as json, CSV (advanced)
Suggested facets: valid_from, language, valid_from (date), parsed_at (date)
| id | bank_id | title | valid_from ▲ | language | filename | parsed_at | bpg |
|---|---|---|---|---|---|---|---|
| 563 | UBS Switzerland AG ubs | Zinssatzflyer Privatkundschaft | 2026-03-01 | de | 138ff819da00_zinssatzflyer-de.pdf | 2026-06-03 | BPG002X8DF34 |
| 566 | UBS Switzerland AG ubs | Aktuelle Zinssaetze (live page snapshot) | 2026-03-01 | de | 2c7b1b0ea2e2_interest-rates-privates.html.md | 2026-06-03 | BPG002D7137J |
| 562 | UBS Switzerland AG ubs | Dienstleistungen und Preise | 2026-01-01 | de | c0d3a6d18931_services-prices-de.pdf | 2026-06-03 | BPG0021M9JBR |
| 564 | UBS Switzerland AG ubs | Services and Price Conditions | 2026-01-01 | fr | 94cbfe427ba4_services-and-price-conditions-fr.pdf | 2026-06-03 | BPG0025GK6Q3 |
| 565 | UBS Switzerland AG ubs | Konditionen (supplementary) | 2026-01-01 | de | 1e23166e4065_konditionen-de.pdf | 2026-06-03 | BPG002H64R0N |
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;