SFC Licensed Representatives
Licensed-representative relationships for Hong Kong SFC-licensed firms
sfc_representatives
- Rows
- 50,224
- Coverage
- April 2026 to October 2026
- Columns
- 7
- Latest data
- 2026-10-01
Sample
8 rows shown
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 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| 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. |
Query it
Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.
SELECT * FROM renavon_exports.sfc_representatives LIMIT 10Ways to get this table
Subscription
HK Corporate Diligence — Compliance Pass
1,000,000 rows a monthwith 14 other tables