sfc_licences
Hong Kong SFC licensed financial intermediaries directory
Download a file
CSV · Excel · Parquet · JSON. Filtered exports.
See pricingQuery with SQL
DBeaver, DuckDB, MotherDuck, or HTTPS. Sub-second latency.
Open connection detailsConnect to AI
MCP for Claude Desktop, Cursor, ChatGPT, Goose. 1-line install.
See setupDirectory 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.
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.
The evidence
Rows over time
monthSchema & column quality (14 columns)
Scroll table sideways to see more 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. | — | — |
500 SFC licensees stratified across entity kind, active status, and AMLO.
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.
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
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
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