sfc_representatives

PREMIUM 46,473 rows

Licensed-representative relationships for Hong Kong SFC-licensed firms

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

The 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.

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 2026 – present
Volume
46,473 rows
Last updated
17 July, 2026 (12 hours ago)
Schema & column quality (7 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. — —

Sample data

CSV Excel

A 500-row slice of the representative graph.

SELECT * FROM renavon_exports.sfc_representatives 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 →

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
SFC Licensed Representatives this dataset
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