Source documents
Data license: CC-BY-4.0 · Data source: bankproducts.info
8 rows where bank_id = "nekb" 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 |
|---|---|---|---|---|---|---|---|
| 907 | Banque Cantonale Neuchateloise nekb | Hypothèque (page produit Q3) | 2026-07-01 | fr | 04aae0395540_hypotheque.md | 2026-08-02 | BPG002Z6G6XZ |
| 908 | Banque Cantonale Neuchateloise nekb | Hypoprimo (page produit Q3) | 2026-07-01 | fr | d35dc92d2f23_hypoprimo.md | 2026-08-02 | BPG002YEN9JA |
| 909 | Banque Cantonale Neuchateloise nekb | Hypoflex (page produit Q3) | 2026-07-01 | fr | 9f2d141b23b4_hypoflex.md | 2026-08-02 | BPG00249E945 |
| 910 | Banque Cantonale Neuchateloise nekb | Pret BCN Ecohabitat (page produit Q3) | 2026-07-01 | fr | 05a2b043cef4_pret-bcn-ecohabitat.md | 2026-08-02 | BPG0028238AW |
| 911 | Banque Cantonale Neuchateloise nekb | BCN Bourse en ligne (page produit Q3) | 2026-07-01 | fr | 70c0fe990738_bourse-en-ligne.md | 2026-08-02 | BPG002KJNDHX |
| 409 | Banque Cantonale Neuchateloise nekb | Pages produits bcn.ch (comptes, cartes, flexipack) | 2026-04-08 | fr | bcn.ch HTML crawl | 2026-04-10 | BPG002NDCANA |
| 777 | Banque Cantonale Neuchateloise nekb | BCN Placements financiers (brochure) | 2025-01-01 | fr | 351505b751b4_bcn_placements_financiers_brochure.pdf | 2026-06-04 | BPG002HT02K6 |
| 740 | Banque Cantonale Neuchateloise nekb | BCN Tarification des credits prives et commerciaux (2018-09-30) | 2018-09-30 | fr | 9697d48004f6_bcn_factsheet_tarifs_credits_prives_commerciaux_v1811.pdf | 2026-08-09 | BPG002RV69HS |
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;