SFC Executive Officers
Executive officers of Hong Kong banks conducting SFC-regulated activities
sfc_executive_officers
- 行數
- 850
- 涵蓋期間
- 2004年10月至2026年9月
- 欄位數目
- 8
- 最新數據
- 2026-09-18
樣本
顯示 8 行
The complete executive-officer graph — small enough to ship in full.
| eo_ceref | principal_ceref | principal_name | principal_name_chi | ra_types | appointed_from | updated_at | id |
|---|---|---|---|---|---|---|---|
| AAA608 | BJN782 | Bank of Communications (Hong Kong) Limited | 交通銀行(香港)有限公司 | 1; 4 | 2017-11-09 | 2026-09-24 06:16:38.663000 | 6cca0409bc9636f71fd10e4b518b82e6 |
| AAB945 | BMG891 | Banque Pictet & Cie SA | 1; 4; 9 | 2021-03-30 | 2026-09-24 06:16:38.663000 | fa3c68abbe5616f89940c34f11effdd3 | |
| AAD601 | BDM672 | Morgan Stanley Bank Asia Limited | 摩根士丹利銀行亞洲有限公司 | 1; 2; 9 | 2015-01-22 | 2026-09-24 06:16:38.663000 | 58ed5ab2abdbd0c0c1eaf995dbd5786b |
| AAE987 | AAJ165 | Bank of East Asia Limited, The | 東亞銀行有限公司 | 1; 4; 6; 9 | 2005-01-11 | 2026-09-24 06:16:38.663000 | ef8dbd123ff5a1e8b4000901ba3a6657 |
| AAJ561 | AAH297 | Hang Seng Bank Limited | 恒生銀行 | 1; 4 | 2024-07-15 | 2026-09-24 06:16:38.663000 | cf05f0018ebfe1540896ab8b39b4b4e4 |
| AAW389 | AAA621 | Chong Hing Bank Limited | 創興銀行有限公司 | 4; 9 | 2018-06-20 | 2026-09-24 06:16:38.663000 | 27ef47b9696e747b9d99bf2d46ab18ca |
| ABA346 | AAE727 | Royal Bank of Canada | 加拿大皇家銀行 | 1; 4; 6 | 2017-02-02 | 2026-09-24 06:16:38.663000 | 8dcdfa067d5b1dedbe78a312feb0d77a |
| ABH959 | AAP937 | Citibank, N.A. | 花旗銀行 | 6 | 2006-04-13 | 2026-09-25 06:15:26.591000 | 544e642fbdfa0964190b70a6a6f569c0 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| eo_ceref | text | CE Reference of the executive officer (the individual) |
| principal_ceref | text | CE Reference of the registered institution (bank) the EO supervises |
| principal_name | text | Name of the registered institution (English) |
| principal_name_chi | text | Name of the registered institution (Chinese); empty if not recorded |
| ra_types | text | Regulated-activity Type numbers the EO supervises at this institution (semicolon-separated) |
| appointed_from | date | Earliest effective date across the EO's regulated activities at this institution; NULL if unrecorded |
| updated_at | date and time | Timestamp of the most recent fetch that witnessed this edge |
| id | text | Stable unique identifier for this row — the last column of every export. Use it to deduplicate, to key an incremental load, or to reference one specific row. It is additive: the entity and join keys you already use (race_id, horse_id, and the like) are unchanged. |
查詢數據
每個數據表均可透過 Renavon 帳戶，以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.sfc_executive_officers LIMIT 10取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表