organisation

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

0 rows where parent_org_id = "six_struct"

✎ View and edit SQL

This data as json

0 records

CREATE TABLE organisation (
    id              TEXT PRIMARY KEY,                 -- short slug, e.g. 'cls', 'lbma'
    name            TEXT NOT NULL,                    -- human-readable name
    type            TEXT,                             -- 'industry_association' / 'standards_body'
                                                      --  / 'market_infrastructure'
                                                      --  / 'settlement_infrastructure'
                                                      --  / 'clearing_house' / 'advisory_body'
                                                      --  / 'api_initiative' / 'forum'
    scope           TEXT,                             -- 'CH' / 'EU' / 'international' / 'global'
    url             TEXT,                             -- official homepage / membership list
    members_count   INTEGER,                          -- approximate; updated on observation
    members_as_of   TEXT,                             -- ISO date or YYYY-Qn the count is from
    description     TEXT,                             -- one-line description
    parent_org_id   TEXT REFERENCES organisation(id)  -- e.g. SIX Repo → SIX Group
);