sfc_responsible_officers
Responsible-officer relationships for Hong Kong SFC-licensed firms
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 setupThe responsible-officer graph for Hong Kong's SFC-licensed corporations: which licensed individual is a Responsible Officer at which firm, and the regulated activities (Types 1-12 / AMLO) they cover there. One row per (corporation, officer) edge. Built from the SFC public register's per-firm RO pages. Useful for compliance due diligence, relationship mapping, and entity resolution 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 | — | — |
| officer_ceref | String | CE Reference of the responsible officer (the licensed individual) | — | — |
| officer_name | String | Responsible officer's full name (English) | — | — |
| officer_name_chi | String | Responsible officer's name in Chinese; NULL if not recorded | — | — |
| ra_types | String | Regulated-activity Type numbers the officer is RO for 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 responsible-officer 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
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