Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
8 rows where bank_id = "leman" 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 |
|---|---|---|---|---|---|---|---|
| 899 | Banque du Léman leman | Carte Or Visa/Mastercard Produktseite | 2026-07-01 | fr | 3d25b1c4225f_carte-or-visa-ou-mastercard.md | 2026-08-02 | BPG002SJ8ABW |
| 900 | Banque du Léman leman | Carte Prepaid Produktseite | 2026-07-01 | fr | 679706ae2ffd_carte-prepaid.md | 2026-08-02 | BPG00204BYRH |
| 366 | Banque du Léman leman | Banque du Léman — Conditions générales particuliers retail | 2026-04-22 | fr | a05830db4bf5_Conditions-generales-particuliers-retail.pdf | 2026-06-03 | BPG002BQSWEP |
| 367 | Banque du Léman leman | Banque du Léman — Conditions générales entreprises | 2026-04-22 | fr | 21ae53cde73b_cg_entreprises.pdf | 2026-06-03 | BPG002XNYY6W |
| 368 | Banque du Léman leman | Banque du Léman — Fiche produit Dépôts | 2026-04-22 | fr | 5e539516881a_depots.pdf | 2026-06-03 | BPG0021DSV9C |
| 369 | Banque du Léman leman | Banque du Léman — Fiche produit Trafic des paiements | 2026-04-22 | fr | 7c54fb4cbaa3_trafic_des_paiements.pdf | 2026-06-03 | BPG002072G4B |
| 370 | Banque du Léman leman | Banque du Léman — Carte Visa Or factsheet | 2026-04-22 | fr | 7aa261da85dc_Visa-Or.pdf | 2026-06-03 | BPG002X6QXJD |
| 365 | Banque du Léman leman | Banque du Léman — Brochure tarifaire (Tarifs des prestations et des moyens de paiement, gültig ab 1.1.2026) | 2026-01-01 | fr | 8e3f9bc7a71d_Brochure-tarifaire-2026.01-VF.pdf | 2026-06-03 | BPG002NVVK5A |
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;