sfc_corp_complaints
Complaints-handling officer contacts 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 designated complaints-handling officer for each Hong Kong SFC-licensed corporation — the phone, fax, email, and address to use when raising a complaint against the firm. One row per complaints-officer contact (most firms have one; a few have two). Includes contacts the live register has since dropped (retained from the archive). Useful for compliance, dispute handling, and entity resolution.
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)
| Column | Type | Description | Populated | Distinct |
|---|---|---|---|---|
| corp_ceref | String | CE Reference of the SFC-licensed corporation | — | — |
| tel | String | Complaints officer's telephone number; empty if none on record | — | — |
| fax | String | Complaints officer's fax number; empty if none on record | — | — |
| String | Complaints officer's email address; empty if none on record | — | — | |
| full_address | String | Complaints officer's address (English); empty if none on record | — | — |
| full_address_chi | String | Complaints officer's address (Chinese); empty if none on record | — | — |
| updated_at | DateTime64(3, 'UTC') | Timestamp of the most recent fetch that witnessed this contact | — | — |