bank_iid_lookup (view)

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

867 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_qr_iid

Next page

CREATE VIEW bank_iid_lookup AS
    SELECT
        printf('%05d', CAST(je.value AS INTEGER)) AS iid,
        bi.bank_id,
        0 AS is_qr_iid
    FROM bank_iban bi, json_each(bi.iid_ranges) je
    WHERE bi.iid_ranges IS NOT NULL
UNION ALL
    SELECT
        printf('%05d', bi.qr_iid) AS iid,
        bi.bank_id,
        1 AS is_qr_iid
    FROM bank_iban bi
    WHERE bi.qr_iid IS NOT NULL;