Swiss + Liechtenstein bank products

Structured retail bank product data. Mounted at /v1/ — use the BPG-canonical URLs (e.g. /v1/banks/BPG001QKZP47) for stable references; slug URLs (e.g. /v1/banks/zkb) return 301 redirects to the canonical form.

Data license: CC-BY-4.0 · Data source: bankproducts.info

Custom SQL query

Tables

actus_contract_type

id, name, description

11 rows

bank

id, name, country, bank_type, website, bic, lei, sic_iid, uid, bpg

420 rows

bank_profile

bank_id, operational_since, too_big_to_fail, staatsgarantie, parent_group_relation, finma_category, offers_usd_accounts, offers_eur_accounts, offers_gbp_accounts, retail_clients, institutional_only

234 rows

bpg_alias

id, bpg, slug, valid_from, valid_to, created_at

3,995 rows

category_actus_map

category, actus_type

27 rows

claim

id, bank_id, product_id, category, claim_key, claim_value, display_text_de, display_text_en, display_text_fr, source, source_url, verifiable, valid_from, valid_to

1,148 rows

fee

id, product_id, bank_id, fee_type, label, amount, currency, frequency, tier, channel, note, source_page, valid_from, access_tier

6,040 rows

interest_rate

id, product_id, bank_id, rate_type, rate, tier_floor, tier_ceiling, tenor_months, currency, snapshot_date, valid_from, note, source_document_id

1,820 rows

package_item

package_id, included_product, sort_order

239 rows

partner

id, name, sponsor, partner_type, website, note, bpg

11 rows

product

id, bank_id, category, name, currency, client_type, target_group, description, valid_from, source_document_id, bpg, access_tier, is_tailored, notice_period_days, iso_account_type

2,790 rows

product_alias

product_id, alias, alias_source

119 rows

product_feature

id, product_id, feature_key, feature_value, note, source_page

1,239 rows

product_partner_link

product_id, partner_id, role, note, valid_from

148 rows

source_document

id, bank_id, title, valid_from, language, filename, parsed_at, bpg

774 rows

sqlite_sequence

name, seq

1 row

Views