Skip to content

SFC Responsible Officers

Responsible-officer relationships for Hong Kong SFC-licensed firms

sfc_responsible_officers

Rows
12,670
Coverage
April 2026 to October 2026
Columns
7
Latest data
2026-10-01

Sample

8 rows shown

A 500-row slice of the responsible-officer graph.

SFC Responsible Officers: Sample
corp_cerefofficer_cerefofficer_nameofficer_name_chira_typesupdated_atid
AAA121ADH091CHAN Tsun Kay, Edwin陳俊祺4; 92026-09-24 08:15:34.86900057215cbfe778c485012145d928def6f2
AAA121ADN837TANG Wai Nam鄧偉南1; 2; 92026-09-24 08:15:34.869000cb2cdf53dbc0f0a0cbd8a44f69a2b4f4
AAA121AED561GOLDFELD Leon4; 5; 92026-09-24 08:15:34.869000c40d189fcd19b82348cc68ddab41307f
AAA121AMB378SHEVLIN Aidan Daniel4; 5; 92026-09-24 08:15:34.869000ff1a6c10c73f2aa9efa30345b708e693
AAA121AMW549LEUNG Kit Yee, Elka梁潔儀4; 92026-09-24 08:15:34.8690001f307733ec039c2613f8f86d6a04036d
AAA121AQZ908BRAY Lee Matthew1; 2; 92026-09-24 08:15:34.8690007d892a1a86946a98fc4e733ee9c0d0cb
AAA121AUE966DAVIDS Mark Robert John4; 5; 92026-09-24 08:15:34.869000f9a82ff8151c3bd5dc0a606f9ab31533
AAA121AWW451EL ASMAR Philippe4; 92026-09-24 08:15:34.8690006429e55f3450e4e956e296b83b5dc662

Both open directly in a spreadsheet.

Also as compressed CSV, JSON

Question about this table? Ask us. (opens in new tab)

Columns

SFC Responsible Officers: Columns
Column Type Description
corp_ceref text CE Reference of the SFC-licensed corporation
officer_ceref text CE Reference of the responsible officer (the licensed individual)
officer_name text Responsible officer's full name (English)
officer_name_chi text Responsible officer's name in Chinese; NULL if not recorded
ra_types text Regulated-activity Type numbers the officer is RO for at this corp (semicolon-separated)
updated_at date and time Timestamp of the most recent fetch that witnessed this edge
id text 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.

Query it

Every table can be queried with SQL, the API or an AI assistant, using a Renavon account.

SELECT * FROM renavon_exports.sfc_responsible_officers LIMIT 10

Get a key on renavon.com (opens in new tab)

Ways to get this table

Free sample

The sample files are free to download.

Free

Download the sample

See all pricing