跳至內容

SFC Licensed Persons

Hong Kong SFC licensed financial intermediaries directory

sfc_licences

行數
145,013
涵蓋期間
2003年4月至2026年11月
欄位數目
14
最新數據
2026-11-20

樣本

顯示 8 行

500 SFC licensees stratified across entity kind, active status, and AMLO.

SFC Licensed Persons: 樣本
cerefentity_nameentity_name_chientity_kindregulated_activity_typeslicence_infois_activehas_amlo_licencehas_licence_infolicence_valid_fromlicence_valid_tosource_urlupdated_atid
BWM012Tsinghua Redbud Capital Investment Limited—Corporation4; 9Advising on securities; Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/corp/BWM012/details2026-11-21 04:25:44.8930004276b269f544a50aae3d6b1ef0237e5f
BYF864HUO Yuying霍玉瑛Individual1; 6Dealing in securities; Advising on corporate finance1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYF864/licenceRecord2026-11-21 04:25:44.89300066a4886e0e35e42d7e0d4357274adcd8
BYM332XIE Lei謝磊Individual4; 9Advising on securities; Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYM332/licenceRecord2026-11-21 04:25:44.893000184f5cbc56a50102a92fe3a8c2d4a757
BYQ390WANG Weibiao王维标Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYQ390/licenceRecord2026-11-21 04:25:44.8930006bea0e8d0f8fdbbf9ac400b42e6e7d2d
BYR273DENG Guanxian鄧冠賢Individual9Asset management1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYR273/licenceRecord2026-11-21 04:25:44.893000475814df3c9283ee9192c8ff145f5306
BYR898LEUNG Ki Wing梁琪穎Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYR898/licenceRecord2026-11-21 04:25:44.8930001ddb7d1f531a0d34b715dcf04dc521bf
BYS092XU Zhaoen徐兆恩Individual1Dealing in securities1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYS092/licenceRecord2026-11-21 04:25:44.89300048351e5ebc35cd4194d9dafc75bb6466
BYT288LIU Huaqiu劉華秋Individual1; 6Dealing in securities; Advising on corporate finance1012026-11-20—https://apps.sfc.hk/publicregWeb/indi/BYT288/licenceRecord2026-11-21 04:25:44.893000493c4dd3febe20da8e323367ee5c89c0

兩者均可直接用試算表開啟。

亦提供 壓縮 CSV 檔, JSON 格式

對此數據表有疑問?歡迎查詢。 (在新分頁開啟)

欄位

SFC Licensed Persons: 欄位
欄位名稱 類型 說明
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.

查詢數據

每個數據表均可透過 Renavon 帳戶,以 SQL、API 或 AI 助理查詢。

SELECT * FROM renavon_exports.sfc_licences LIMIT 10

在 renavon.com 取得金鑰 (在新分頁開啟)

取得此數據表的方式

免費樣本

樣本檔案可免費下載。

免費

下載樣本

一次性存檔

SFC Licensed Persons — Snapshot

All current + historical licensees

一次性 US$49

購買存檔 SFC Licensed Persons — Snapshot

訂閱

HK Corporate Diligence — Compliance Pass

每月 1,000,000 行另包含 14 個數據表

訂閱及存檔由 Renavon 銷售,價格及付款程序均由其處理。

Renavon 的付款頁面只提供英文版本。

查看所有價格