SFC Licensed Representatives
Licensed-representative relationships for Hong Kong SFC-licensed firms
sfc_representatives
- 行數
- 50,224
- 涵蓋期間
- 2026年4月至2026年10月
- 欄位數目
- 7
- 最新數據
- 2026-10-01
樣本
顯示 8 行
A 500-row slice of the representative graph.
| corp_ceref | rep_ceref | rep_name | rep_name_chi | ra_types | updated_at | id |
|---|---|---|---|---|---|---|
| AAA121 | AHM508 | KWOK Wai Hei, Joanna | 郭為熹 | 4; 5; 9 | 2026-09-24 08:15:53.582000 | 7357773f8c1a86be3a7278f1d57e3515 |
| AAA121 | AJK798 | MANN Chi Sam | 文志生 | 1; 2; 9 | 2026-09-24 08:15:53.582000 | aec8d1185cf55016e2c622cf4087387b |
| AAA121 | AJO207 | WONG Stephen | 黃錦豪 | 4; 5; 9 | 2026-09-24 08:15:53.582000 | 3a456d25c9b7cd164268faf0a1b16004 |
| AAA121 | ALI020 | TAO Wei Vivian | 4; 5; 9 | 2026-09-24 08:15:53.582000 | 64a603316a413c3b7072d110dd00b22a | |
| AAA121 | ALR002 | TUEN MUK Hoi Ning, Helen | 端木愷寧 | 4; 9 | 2026-09-24 08:15:53.582000 | 88413d99fbca0750d473eb1d280f9a14 |
| AAA121 | AMB643 | CHO John Won-Ki | 4; 5; 9 | 2026-09-24 08:15:53.582000 | 33d522d55375f58d0f7f7875dbd2ab8d | |
| AAA121 | AMI069 | XIONG Tao | 熊濤 | 4; 9 | 2026-09-24 08:15:53.582000 | afaf032a23fdcc8a38bdad4a93181d7f |
| AAA121 | ANA757 | PARK Nam Seok | 4; 9 | 2026-09-24 08:15:53.582000 | 13d1bdc858003d11f96440ce446232eb |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| corp_ceref | text | CE Reference of the SFC-licensed corporation |
| rep_ceref | text | CE Reference of the licensed representative (the individual) |
| rep_name | text | Representative's full name (English) |
| rep_name_chi | text | Representative's name in Chinese; NULL if not recorded |
| ra_types | text | Regulated-activity Type numbers the representative covers 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_representatives LIMIT 10取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表