sfc_licences

PREMIUM 142,180 rows

Hong Kong SFC licensed financial intermediaries directory

No-code

Download a file

CSV · Excel · Parquet · JSON. Filtered exports.

See pricing
For engineers

Query with SQL

DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.

Open connection details
Agent builders

Connect to AI

MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.

See setup

Directory of persons and entities licensed by Hong Kong's Securities and Futures Commission (SFC). Look up any financial intermediary by their Central Entity Reference (CE Ref) and find their name, whether they are an individual or a corporation, the regulated activities they are licensed for (Types 1-12: dealing, advising, asset management, etc.), whether they currently hold an active licence, and whether they hold an Anti-Money Laundering Ordinance (AMLO) licence, and the validity period of their licensing (when it began and, for past licensees, when it ended). Covers all entities on the live SFC public register plus deregistered entities retained from the historical archive. Essential for verifying whether a financial service provider is properly licensed in Hong Kong.

Premium dataset

Evaluate it in full below: the evidence and a working sample are open to everyone. Buy or subscribe to unlock the complete dataset — your account is created automatically at checkout.

See access options

The evidence

Data coverage
Apr 2003 – present
Volume
142,180 rows
Last updated
21 July, 2026 (1 day ago)

Rows over time

month
2003-04-01 2026-07-01
Schema & column quality (14 columns)
Column Type Description Populated Distinct
ceref String Central Entity Reference number — the SFC's unique identifier for every licensed person and registered institution. — —
entity_name Nullable(String) 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 Nullable(String) Licensee name in Chinese, where the SFC register provides one. — —
entity_kind Nullable(String) Whether the licensee is an 'Individual' or a 'Corporation'. NULL for historical-archive-only entities. — —
regulated_activity_types String 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 Nullable(String) Semicolon-separated descriptions of the regulated activities in regulated_activity_types (e.g. 'Dealing in securities; Advising on securities; Asset management'). — —
is_active Nullable(UInt8) 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 Nullable(UInt8) 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 UInt8 1 if the entity has at least one regulated activity on record. — —
licence_valid_from Nullable(Date32) 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 Nullable(Date32) 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 String SFC public register URL for the entity. — —
updated_at DateTime64(3, 'UTC') Timestamp when the record was last refreshed from the SFC register. — —
id String 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. — —

Sample data

CSV Excel

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

SELECT * FROM renavon_exports.sfc_licences LIMIT 50 0.02s
Loading data… | Click a header to sort; drag headers to reorder.

Choose your access

A Pass gives you freshness within a rolling window. The Full Archive gives you the full history we hold for the dataset, frozen at purchase. They solve different problems, and they work together.

Satisfaction guarantee: 14-day money-back. Details →

One-off purchase

Full Archive

The full history we hold, frozen at purchase. Yours to keep.

Full details →
What you get
The full history we hold, to your purchase date
History depth
All current + historical licensees, in full
Updates
None. Frozen at purchase
Delivery
Gzipped CSV, opens in Excel; link valid 7 days
API access
Not included
US$49
one-time purchase

Pass subscription

HK Corporate Diligence — Compliance Pass

Continuously updated, with API access.

View full package →
Access window
Full history (no window)
Updates
Continuous, within hours of the source
Delivery
API, SQL and downloads
Exports
1,000,000 rows/month included

Included Datasets

Hong Kong Companies
Hong Kong Company Name History
Hong Kong Company Filings
Hong Kong Money Lenders Register
HKEX Company Directors
HKEX Disclosure Codes
HKEX Insider Disclosures
SFC Corporation Addresses & Contacts
SFC Complaints Officers
SFC Disciplinary Actions
SFC Executive Officers
SFC Licensed Persons this dataset
SFC Licensed Representatives
SFC Responsible Officers
US$299
per month

Get notified when this dataset is updated.

Questions about this data?

Our data experts are ready to help clarify any aspects of this dataset.

Contact Our Team