SFC Corporation Addresses & Contacts
Principal address, email and website for Hong Kong SFC-licensed firms
sfc_corp_addresses
- 行數
- 3,774
- 涵蓋期間
- 2026年4月至2026年10月
- 欄位數目
- 7
- 最新數據
- 2026-10-01
樣本
顯示 8 行
500 SFC-licensed corporations with their addresses and contacts.
| corp_ceref | address | address_chi | website | updated_at | id | |
|---|---|---|---|---|---|---|
| AAA121 | 19/F Chater House, 8 Connaught Road Central, Hong Kong | 香港中環干諾道中8號遮打大廈19樓 | investor.services@jpmorgan.com | www.jpmorgan.com.hk | 2026-09-24 07:15:43.718000 | aed667c27fa886df42f5e71b9b3e7ecf |
| AAA135 | 19/F Chater House, 8 Connaught Road Central, Hong Kong | 香港中環干諾道中8號遮打大廈19樓 | investor.services@jpmorgan.com | www.jpmorgan.com.hk | 2026-09-24 07:15:43.718000 | ecf4de4c1f3a7827c968904d96307d38 |
| AAA137 | 50/F Champion Tower, Three Garden Road, Central, Hong Kong | 香港中環花園道三號冠君大廈五十樓 | wanda.yau@citi.com | www.citigroup.com | 2026-10-01 07:16:26.624000 | e3ffef24deed7ef0b90f07605a7e28f6 |
| AAA347 | Room 1708-1710, 17/F, China Insurance Group Building, 141 Des Voeux Road Central, Hong Kong | 香港中環德輔道中141號中保集團大廈17樓1708-1710室 | info@firstsechk.com | www.firstsechk.com | 2026-09-25 07:15:10.564000 | bf99946db96dadc70faec18bded605d8 |
| AAA451 | Office 1002, 10/F, 8 Wyndham Street, Central, Hong Kong | 香港中環雲咸街8號10樓1002 室 | andy.kong@pfpcapitalhk.com | 2026-09-24 07:15:43.718000 | deb1ab7a2e2359d41613a731cc7f61f7 | |
| AAA523 | Level 10 HSBC Main Building, 1 Queen's Road Central, Hong Kong | 香港中環皇后大道中1號匯豐總行大廈10樓 | dfv.enquiry@hsbc.com.hk | www.hsbc.com.hk | 2026-09-25 07:15:10.564000 | f8bd0a1af27ab46f0e6765461058dc22 |
| AAA529 | Level 25 HSBC Main Building, 1 Queen's Road Central, Hong Kong | 香港皇后大道中1號滙豐總行大廈25樓 | nettrader@hsbc.com.hk | www.hsbc.com.hk/broking | 2026-07-29 07:23:24.180000 | c4882c64dc63af93b6de0975f96d994f |
| AAA530 | HSBC Main Building, 1 Queen's Road Central, Hong Kong | 香港皇后大道中1號滙豐總行大廈 | hcbkregulatorycommunications@hsbc.com.hk | 2026-09-25 07:15:10.564000 | 665cd7bab325838c6fc449e34dbf5fa1 |
兩者均可直接用試算表開啟。
欄位
| 欄位名稱 | 類型 | 說明 |
|---|---|---|
| corp_ceref | text | CE Reference of the SFC-licensed corporation |
| address | text | Principal business address (English); empty if none on record |
| address_chi | text | Principal business address (Chinese); empty if none on record |
| text | Corporation email address; empty if none on record | |
| website | text | Corporation website; empty if none on record |
| updated_at | date and time | Timestamp of the most recent fetch that witnessed this corporation |
| 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. |
查詢數據
每個數據表均可透過 Renavon 帳戶,以 SQL、API 或 AI 助理查詢。
SELECT * FROM renavon_exports.sfc_corp_addresses LIMIT 10
取得此數據表的方式
訂閱
HK Corporate Diligence — Compliance Pass
每月 1,000,000 行另包含 14 個數據表