Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
6 rows where bank_id = "alpian" sorted by valid_from descending
This data as json, CSV (advanced)
Suggested facets: valid_from, language, parsed_at, valid_from (date), parsed_at (date)
| id | bank_id | title | valid_from ▲ | language | filename | parsed_at | bpg |
|---|---|---|---|---|---|---|---|
| 607 | Alpian SA alpian | Alpian Preisseite (Website-Snapshot) | 2026-02-15 | de | 46ea59586da7_pricing.md | 2026-06-03 | BPG0020RB10K |
| 608 | Alpian SA alpian | Alpian Tarifs Expliques (HTML-Snapshot) | 2026-02-15 | en | 605ebab43fa7_tariffs-explained.md | 2026-06-03 | BPG002GJ0XRN |
| 11 | Alpian SA alpian | Dienstleistungen und Gebuehren Uebersicht (SFB2023v3) | 2025-11-06 | de | 4ff35d27fa0f_fees_alpian_de.pdf | 2026-05-28 | BPG0025XJ0AH |
| 12 | Alpian SA alpian | Vertragsbedingungen (Contractual Terms DE) | 2024-01-01 | de | fa178026f8b9_Contractual_terms_DE.pdf | 2026-05-28 | BPG002F45QVG |
| 14 | Alpian SA alpian | Starter Guide to Investing | 2023-04-18 | de | 1f00149ee98f_230418_alpian_starterguidetoinvesting-1-3_de.pdf | 2026-05-28 | BPG002712SS9 |
| 13 | Alpian SA alpian | Fees (Legacy 2021-04-26 DE) | 2021-04-26 | de | 041a6887f9fd_fees-21-04-26-de.pdf | 2026-05-28 | BPG002GH9EEB |
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;