sfc_representatives
Licensed-representative relationships for Hong Kong SFC-licensed firms
Download a file
CSV and Parquet. 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 setupThe licensed-representative graph for Hong Kong's SFC-licensed corporations: which licensed individual is a representative at which firm, and the regulated activities (Types 1-12 / AMLO) they cover there. One row per (corporation, representative) edge. Built from the SFC public register's per-firm representative pages. Useful for compliance due diligence and relationship mapping across the SFC register.
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
Schema & column quality (7 columns)
Scroll table sideways to see more columns →
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| corp_ceref | String | CE Reference of the SFC-licensed corporation | — | — |
| rep_ceref | String | CE Reference of the licensed representative (the individual) | — | — |
| rep_name | String | Representative's full name (English) | — | — |
| rep_name_chi | String | Representative's name in Chinese; NULL if not recorded | — | — |
| ra_types | String | Regulated-activity Type numbers the representative covers at this corp (semicolon-separated) | — | — |
| updated_at | DateTime64(3, 'UTC') | Timestamp of the most recent fetch that witnessed this edge | — | — |
| 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. | — | — |
A 500-row slice of the representative graph.
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.
Pass subscription
HK Corporate Diligence — Compliance Pass
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