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, gleif_entity_status, gleif_registration_status, gleif_successor_lei, gleif_last_update, direct_parent_lei, ultimate_parent_lei, bpg

421 rows

bank_iban

bank_id, clearing_number, iban_pattern, qr_iban_pattern, iid_ranges, qr_iid

164 rows

bank_membership

bank_id, organisation_id, role, status, joined, exited, source_url, source_filename, extracted_at, confidence, note

356 rows

bank_profile

bank_id, operational_since, too_big_to_fail, staatsgarantie, parent_group_relation, finma_category, retail_clients, institutional_only

402 rows

bpg_alias

id, bpg, slug, valid_from, valid_to, created_at

4,090 rows

category_actus_map

category, actus_type

30 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,157 rows

fee

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

6,225 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,981 rows

organisation

id, name, type, scope, url, members_count, members_as_of, description, parent_org_id

17 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,843 rows

product_alias

product_id, alias, alias_source

119 rows

product_feature

id, product_id, feature_key, feature_value, note, source_page

1,266 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

815 rows

sqlite_sequence

name, seq

1 row

Views