SFC Responsible Officers
Responsible-officer relationships for Hong Kong SFC-licensed firms
sfc_responsible_officers
- 行數
- 12,670
- 涵蓋期間
- 2026年4月至2026年10月
- 欄位數目
- 7
- 最新數據
- 2026-10-01
樣本
顯示 8 行
A 500-row slice of the responsible-officer graph.
| corp_ceref | officer_ceref | officer_name | officer_name_chi | ra_types | updated_at | id |
|---|---|---|---|---|---|---|
| AAA121 | ADH091 | CHAN Tsun Kay, Edwin | 陳俊祺 | 4; 9 | 2026-09-24 08:15:34.869000 | 57215cbfe778c485012145d928def6f2 |
| AAA121 | ADN837 | TANG Wai Nam | 鄧偉南 | 1; 2; 9 | 2026-09-24 08:15:34.869000 | cb2cdf53dbc0f0a0cbd8a44f69a2b4f4 |
| AAA121 | AED561 | GOLDFELD Leon | 4; 5; 9 | 2026-09-24 08:15:34.869000 | c40d189fcd19b82348cc68ddab41307f | |
| AAA121 | AMB378 | SHEVLIN Aidan Daniel | 4; 5; 9 | 2026-09-24 08:15:34.869000 | ff1a6c10c73f2aa9efa30345b708e693 | |
| AAA121 | AMW549 | LEUNG Kit Yee, Elka | 梁潔儀 | 4; 9 | 2026-09-24 08:15:34.869000 | 1f307733ec039c2613f8f86d6a04036d |
| AAA121 | AQZ908 | BRAY Lee Matthew | 1; 2; 9 | 2026-09-24 08:15:34.869000 | 7d892a1a86946a98fc4e733ee9c0d0cb | |
| AAA121 | AUE966 | DAVIDS Mark Robert John | 4; 5; 9 | 2026-09-24 08:15:34.869000 | f9a82ff8151c3bd5dc0a606f9ab31533 | |
| AAA121 | AWW451 | EL ASMAR Philippe | 4; 9 | 2026-09-24 08:15:34.869000 | 6429e55f3450e4e956e296b83b5dc662 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| corp_ceref | text | CE Reference of the SFC-licensed corporation |
| officer_ceref | text | CE Reference of the responsible officer (the licensed individual) |
| officer_name | text | Responsible officer's full name (English) |
| officer_name_chi | text | Responsible officer's name in Chinese; NULL if not recorded |
| ra_types | text | Regulated-activity Type numbers the officer is RO for at this corp (semicolon-separated) |
| 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_responsible_officers LIMIT 10取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表