SFC Licensed Persons
Hong Kong SFC licensed financial intermediaries directory
sfc_licences
- Rows
- 145,013
- Coverage
- April 2003 to November 2026
- Columns
- 14
- Latest data
- 2026-11-20
Sample
8 rows shown
500 SFC licensees stratified across entity kind, active status, and AMLO.
| ceref | entity_name | entity_name_chi | entity_kind | regulated_activity_types | licence_info | is_active | has_amlo_licence | has_licence_info | licence_valid_from | licence_valid_to | source_url | updated_at | id |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BWM012 | Tsinghua Redbud Capital Investment Limited | — | Corporation | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/corp/BWM012/details | 2026-11-21 04:25:44.893000 | 4276b269f544a50aae3d6b1ef0237e5f |
| BYF864 | HUO Yuying | 霍玉瑛 | Individual | 1; 6 | Dealing in securities; Advising on corporate finance | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYF864/licenceRecord | 2026-11-21 04:25:44.893000 | 66a4886e0e35e42d7e0d4357274adcd8 |
| BYM332 | XIE Lei | 謝磊 | Individual | 4; 9 | Advising on securities; Asset management | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYM332/licenceRecord | 2026-11-21 04:25:44.893000 | 184f5cbc56a50102a92fe3a8c2d4a757 |
| BYQ390 | WANG Weibiao | 王维标 | Individual | 1 | Dealing in securities | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYQ390/licenceRecord | 2026-11-21 04:25:44.893000 | 6bea0e8d0f8fdbbf9ac400b42e6e7d2d |
| BYR273 | DENG Guanxian | 鄧冠賢 | Individual | 9 | Asset management | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYR273/licenceRecord | 2026-11-21 04:25:44.893000 | 475814df3c9283ee9192c8ff145f5306 |
| BYR898 | LEUNG Ki Wing | 梁琪穎 | Individual | 1 | Dealing in securities | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYR898/licenceRecord | 2026-11-21 04:25:44.893000 | 1ddb7d1f531a0d34b715dcf04dc521bf |
| BYS092 | XU Zhaoen | 徐兆恩 | Individual | 1 | Dealing in securities | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYS092/licenceRecord | 2026-11-21 04:25:44.893000 | 48351e5ebc35cd4194d9dafc75bb6466 |
| BYT288 | LIU Huaqiu | 劉華秋 | Individual | 1; 6 | Dealing in securities; Advising on corporate finance | 1 | 0 | 1 | 2026-11-20 | — | https://apps.sfc.hk/publicregWeb/indi/BYT288/licenceRecord | 2026-11-21 04:25:44.893000 | 493c4dd3febe20da8e323367ee5c89c0 |
Both open directly in a spreadsheet.
Also as compressed CSV, JSON
Columns
| Column | Type | Description |
|---|---|---|
| ceref | text | Central Entity Reference number — the SFC's unique identifier for every licensed person and registered institution. |
| entity_name | text | Licensee name (the individual's name, or the firm's English name). NULL for deregistered entities present only in the historical archive. |
| entity_name_chi | text | Licensee name in Chinese, where the SFC register provides one. |
| entity_kind | text | Whether the licensee is an 'Individual' or a 'Corporation'. NULL for historical-archive-only entities. |
| regulated_activity_types | text | Semicolon-separated SFC regulated-activity Type numbers the entity is currently licensed for (e.g. '1; 4; 9'). Types 1-12 cover dealing in securities/futures, advising, asset management, and other regulated activities. Empty for historical-archive-only entities. |
| licence_info | text | Semicolon-separated descriptions of the regulated activities in regulated_activity_types (e.g. 'Dealing in securities; Advising on securities; Asset management'). |
| is_active | number | 1 if the entity currently holds at least one active SFC licence, 0 if not. NULL for deregistered entities present only in the historical archive. |
| has_amlo_licence | number | 1 if the entity holds an active Anti-Money Laundering Ordinance (AMLO) licence (virtual-asset / trust-or-company service providers), 0 otherwise. NULL for historical-archive-only entities. |
| has_licence_info | number | 1 if the entity has at least one regulated activity on record. |
| licence_valid_from | date | Earliest date the entity held any SFC licence, across all regulated activities. The SFC licensing regime began on 1 April 2003, so most active licensees show 2003-04-01. |
| licence_valid_to | date | Latest date the entity's SFC licensing ended; NULL while the entity is currently licensed. Mined from the SFC's per-activity licence history. |
| source_url | text | SFC public register URL for the entity. |
| updated_at | date and time | Timestamp when the record was last refreshed from the SFC register. |
| 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_licences LIMIT 10
Ways to get this table
One-off archive
SFC Licensed Persons — Snapshot
All current + historical licensees
US$49 one-off
Buy the archive SFC Licensed Persons — SnapshotSubscription
HK Corporate Diligence — Compliance Pass
1,000,000 rows a monthwith 14 other tables
Subscriptions and archives are sold by Renavon, which sets the prices shown here and handles checkout.